participants

4 rows where gid = "00cf1b7c-e15e-466c-be27-a61c787b628e"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
219785 219785 00cf1b7c-e15e-466c-be27-a61c787b628e gs_WCHrbYJjPWcfphwbx3GTWSHF Fairy Rust 0
219786 219786 00cf1b7c-e15e-466c-be27-a61c787b628e gs_bC73v77txjq9SMTj6Skmc7D9 Combat Reptile 0
219787 219787 00cf1b7c-e15e-466c-be27-a61c787b628e gs_MfM8XJ6FHmBxp3SyGSYbY6k6 dubious dtella (dev) 0
219788 219788 00cf1b7c-e15e-466c-be27-a61c787b628e gs_wd3FVhD7Dcf9vqg8x6Fdm8JR nomblegomble 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);