participants

4 rows where gid = "4c14fae0-e1f1-44fd-b7ba-80910e3e1bed"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
78 78 4c14fae0-e1f1-44fd-b7ba-80910e3e1bed gs_wFkt79kCx3vhWGTHrmmbw89K Gadiuka 0
79 79 4c14fae0-e1f1-44fd-b7ba-80910e3e1bed gs_HgRvCf34fHJPCrdkgb6dbKC4 Jaeger 0
80 80 4c14fae0-e1f1-44fd-b7ba-80910e3e1bed gs_8cxDS4PQqGfK6twkTcDG8RQd biter 0
81 81 4c14fae0-e1f1-44fd-b7ba-80910e3e1bed gs_yBKvdtyg44ccYDck6FdFy7Fc Combat Reptile 1

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