participants
4 rows where gid = "538db41b-fb9f-41c7-bb80-5e28361d551b"
This data as json, CSV (advanced)
Suggested facets: won
| Link | rowid ▼ | gid | sid | name | won |
|---|---|---|---|---|---|
| 48 | 48 | 538db41b-fb9f-41c7-bb80-5e28361d551b | gs_4YwRXQw6q3w7bxBmfgFYm9pG | Mamushi | 0 |
| 49 | 49 | 538db41b-fb9f-41c7-bb80-5e28361d551b | gs_GdSHdtTdgbk46W8c8W8WdYTK | Silly Sea Noodle | 0 |
| 50 | 50 | 538db41b-fb9f-41c7-bb80-5e28361d551b | gs_BMHSS69GR3jwKKxC9vcwR8jb | Test Snek pls Ignore | 0 |
| 51 | 51 | 538db41b-fb9f-41c7-bb80-5e28361d551b | gs_49h9XpPK9MV3bbYXW47jqVVC | Combat Reptile | 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);