participants

4 rows where gid = "0028e6c8-874a-4b12-9036-a0a593b5d6d2"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
52472 52472 0028e6c8-874a-4b12-9036-a0a593b5d6d2 gs_cjBxDJBmHm3vxV4jbCfrdGbb Canadian Bacon 0
52473 52473 0028e6c8-874a-4b12-9036-a0a593b5d6d2 gs_J3mXf9tHfrQd3gWQ9v8j3qqW Badly Coded Snake 0
52474 52474 0028e6c8-874a-4b12-9036-a0a593b5d6d2 gs_6dWHB8gHfkxvVw9jvfSVHbFT Gunthar 0
52475 52475 0028e6c8-874a-4b12-9036-a0a593b5d6d2 gs_tD7MJ6VxTKqFDf8XygTYFMGB 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);