participants

4 rows where gid = "008c9e85-0b35-43d4-b50b-8165828763ea"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
274320 274320 008c9e85-0b35-43d4-b50b-8165828763ea gs_F3W3jRFJmTVhhR7R6t6DfX7f Snekky 0
274321 274321 008c9e85-0b35-43d4-b50b-8165828763ea gs_4F66CxYjwWwhF3W8GJtYcpdS Murky 0
274322 274322 008c9e85-0b35-43d4-b50b-8165828763ea gs_p76VDtMdJ9C6yWQqYxCpj9jV Combat Reptile 1
274323 274323 008c9e85-0b35-43d4-b50b-8165828763ea gs_bXmCGMxFGtHHHmDMhPFBTxTT fluffy 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);