participants

4 rows where gid = "004022d0-f4c4-4c74-937e-3bf81ba85732"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
269510 269510 004022d0-f4c4-4c74-937e-3bf81ba85732 gs_kcGHd9RYYkyfM39qKGrGMGBP The Worst Possible Snake 0
269511 269511 004022d0-f4c4-4c74-937e-3bf81ba85732 gs_kVtCPdTQ3PKgbkXtj7p3whh7 Murky 0
269512 269512 004022d0-f4c4-4c74-937e-3bf81ba85732 gs_mgMwMXMJTk7vP7TGjQBYjcC6 Combat Reptile 1
269513 269513 004022d0-f4c4-4c74-937e-3bf81ba85732 gs_8TQFvJfFwRq9cDgRpHYWT3pF DaddySnake 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);