participants
2 rows where gid = "000a9c65-d862-416e-b6f5-80ce01ea2534"
This data as json, CSV (advanced)
| Link | rowid ▼ | gid | sid | name | won |
|---|---|---|---|---|---|
| 235441 | 235441 | 000a9c65-d862-416e-b6f5-80ce01ea2534 | gs_bdpmx886VwfcgcPtRjBrYGrD | 🇺🇦🇷🇺 Shapeshifter 🇺🇦🇷🇺 | 1 |
| 235442 | 235442 | 000a9c65-d862-416e-b6f5-80ce01ea2534 | gs_QKhYktm4bXxbxJB9fG4R33YJ | Combat Reptile | 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);