participants

4 rows where gid = "21c699d7-19f2-4455-b9fb-45c9d1f612ba"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
190 190 21c699d7-19f2-4455-b9fb-45c9d1f612ba gs_GCrVjYDr3mmvF9fT3q3DqmwM devourer 0
191 191 21c699d7-19f2-4455-b9fb-45c9d1f612ba gs_PCJMf3hJCrDDwKBd3HDVjjWR Morley 0
192 192 21c699d7-19f2-4455-b9fb-45c9d1f612ba gs_T6xDvCYwCkBKHbPmc7bxkmmY Silvester Snake 0
193 193 21c699d7-19f2-4455-b9fb-45c9d1f612ba gs_7v9PcdGW6vvfRBJKJCtjFFQP 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);