participants

4 rows where gid = "21d129ea-3d8b-44f3-8048-71a5a3ff9ca8"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
154 154 21d129ea-3d8b-44f3-8048-71a5a3ff9ca8 gs_Cwcdrx64qjFdfBJTf8BJpS49 Bad translater 0
155 155 21d129ea-3d8b-44f3-8048-71a5a3ff9ca8 gs_mmfPtkvCxRSChWQStXr7tchP Snake without name 0
156 156 21d129ea-3d8b-44f3-8048-71a5a3ff9ca8 gs_xrFby3KGyy9CDYwK8DxxCbwB Combat Reptile 1
157 157 21d129ea-3d8b-44f3-8048-71a5a3ff9ca8 gs_yQ3WkdtYR6FD3F7dCbcyXHKM TestSnake 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);