participants
4 rows where gid = "006ab84a-abcc-4076-9cd2-e3cc84c47159"
This data as json, CSV (advanced)
Suggested facets: won
| Link | rowid ▼ | gid | sid | name | won | 
|---|---|---|---|---|---|
| 178789 | 178789 | 006ab84a-abcc-4076-9cd2-e3cc84c47159 | gs_BPdMPDbMMSmrwHSRXyrGFFPC | Combat Reptile | 1 | 
| 178790 | 178790 | 006ab84a-abcc-4076-9cd2-e3cc84c47159 | gs_kpTtqhgySBpmC6VpckMtjcQF | Prüzze v2 | 0 | 
| 178791 | 178791 | 006ab84a-abcc-4076-9cd2-e3cc84c47159 | gs_9bDWWP3Bj4dwx6d8YQMTRG4C | 😎 Nerdy Caterpillar 🐛 | 0 | 
| 178792 | 178792 | 006ab84a-abcc-4076-9cd2-e3cc84c47159 | gs_rGqDCvGHTDQrmrBtKTrQ76Td | SnakeDrop | 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);