participants
2 rows where gid = "946f7b91-d9f4-48f5-a9d0-1605d7ead5fc"
This data as json, CSV (advanced)
| Link | rowid ▼ | gid | sid | name | won | 
|---|---|---|---|---|---|
| 5960 | 5960 | 946f7b91-d9f4-48f5-a9d0-1605d7ead5fc | gs_hMtdRKJBJpybfXP43d88FSjd | Prüzze v2 | 0 | 
| 5961 | 5961 | 946f7b91-d9f4-48f5-a9d0-1605d7ead5fc | gs_Sc7grWtVXkRfrt8F4TwM7CwS | 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);