participants
4 rows where gid = "fe316e1c-3de4-4ab4-b92b-3423536c61ca"
This data as json, CSV (advanced)
Suggested facets: won
| Link | rowid ▼ | gid | sid | name | won |
|---|---|---|---|---|---|
| 2 | 2 | fe316e1c-3de4-4ab4-b92b-3423536c61ca | gs_j6YBKyhJM6pRvXCqqhXktfXS | Test Snek pls Ignore | 1 |
| 3 | 3 | fe316e1c-3de4-4ab4-b92b-3423536c61ca | gs_y7Vc3dqdQqVSX38MCFTcJrJ6 | Combat Reptile | 0 |
| 4 | 4 | fe316e1c-3de4-4ab4-b92b-3423536c61ca | gs_PpdpRyk9M9prCgyP4mtbCJx4 | biter | 0 |
| 5 | 5 | fe316e1c-3de4-4ab4-b92b-3423536c61ca | gs_SptdkP7KwtFM7bvphvXFPrbP | Pea Eater | 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);