participants
8 rows where gid = "00c34354-afe1-4485-963b-891d9132e6ed"
This data as json, CSV (advanced)
Suggested facets: won
Link | rowid ▼ | gid | sid | name | won |
---|---|---|---|---|---|
224387 | 224387 | 00c34354-afe1-4485-963b-891d9132e6ed | gs_qqWvwcxhtMRVcv8fVV36p88T | CoolerSnake! | 0 |
224388 | 224388 | 00c34354-afe1-4485-963b-891d9132e6ed | gs_QcfxQjX8h9rKyYbVMXrT4M9M | SmartyTree | 0 |
224389 | 224389 | 00c34354-afe1-4485-963b-891d9132e6ed | gs_t6rxWpDD98b8PbgjgxH3KWqR | Combat Reptile | 0 |
224390 | 224390 | 00c34354-afe1-4485-963b-891d9132e6ed | gs_T7BJXRhMVCV4xqjBQVtk8BWV | anti-blobby | 0 |
224391 | 224391 | 00c34354-afe1-4485-963b-891d9132e6ed | gs_fR8X3hjSXQYcGwd3YFhSPdKP | Mollywobbles | 1 |
224392 | 224392 | 00c34354-afe1-4485-963b-891d9132e6ed | gs_QDkGKbVHXv3yGcDJMq3mQDR6 | Kisnake | 0 |
224393 | 224393 | 00c34354-afe1-4485-963b-891d9132e6ed | gs_cPFkvxR6dmPJQjJHGmvhpj4T | hawthhhh++ | 0 |
224394 | 224394 | 00c34354-afe1-4485-963b-891d9132e6ed | gs_DXJrxRqK3fhqFPKB4tpXSQbS | One | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participants ( gid TEXT NOT NULL REFERENCES games(gid), sid TEXT NOT NULL, name TEXT NOT NULL, won INTEGER NOT NULL ); CREATE INDEX index_gid ON participants(gid); CREATE INDEX index_name ON participants(name);