participants
4 rows where gid = "005c7ab8-8ef7-48ac-9617-c22dc08515aa"
This data as json, CSV (advanced)
Suggested facets: won
| Link | rowid ▼ | gid | sid | name | won |
|---|---|---|---|---|---|
| 131899 | 131899 | 005c7ab8-8ef7-48ac-9617-c22dc08515aa | gs_bkjw8XFSRpHYTRKh3Cw7xbVC | Ami ☮ | 0 |
| 131900 | 131900 | 005c7ab8-8ef7-48ac-9617-c22dc08515aa | gs_SjhQF9SpdyBKQ3FgvycFxfdD | Combat Reptile | 1 |
| 131901 | 131901 | 005c7ab8-8ef7-48ac-9617-c22dc08515aa | gs_QmdpXbwgjwDKcffKTkWcPT8J | Pea Eater | 0 |
| 131902 | 131902 | 005c7ab8-8ef7-48ac-9617-c22dc08515aa | gs_hf3F97BXWdKDKxYQbMwWqTbS | Test Snek pls Ignore | 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);