participants
4 rows where gid = "00e09171-f3a5-4d3d-a297-6e0d8a6ed402"
This data as json, CSV (advanced)
Suggested facets: won
Link | rowid ▼ | gid | sid | name | won |
---|---|---|---|---|---|
146387 | 146387 | 00e09171-f3a5-4d3d-a297-6e0d8a6ed402 | gs_WCPwyQxRgbmvM4Kkyj676hSB | Combat Reptile | 0 |
146388 | 146388 | 00e09171-f3a5-4d3d-a297-6e0d8a6ed402 | gs_VtWFhtXHCXpbYpHm3vtSCdF8 | haspid | 0 |
146389 | 146389 | 00e09171-f3a5-4d3d-a297-6e0d8a6ed402 | gs_RRw9GQK6h4FFfxFF3g8xGQ7T | royal marrrvin | 0 |
146390 | 146390 | 00e09171-f3a5-4d3d-a297-6e0d8a6ed402 | gs_GC9HtCFT6j6SCJ47GrmM4wRP | marrrvin | 1 |
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);