participants

4 rows where gid = "e5b96a88-5e29-4c22-9532-aefe3e6a54ef"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
222 222 e5b96a88-5e29-4c22-9532-aefe3e6a54ef gs_7qWCKYYD7XT3fKrG9tmhHkpc Combat Reptile 1
223 223 e5b96a88-5e29-4c22-9532-aefe3e6a54ef gs_YgYhrprFw3Qc4pfKkSfwhk3b Test Snek pls Ignore 0
224 224 e5b96a88-5e29-4c22-9532-aefe3e6a54ef gs_CVjPQF4XWcv7WJB8BRQyK9R6 biter 0
225 225 e5b96a88-5e29-4c22-9532-aefe3e6a54ef gs_htgMyQpRtT89CTBVTd3b6rfW Pea Eater 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);