participants

4 rows where gid = "0046d5ce-1a23-4d92-a8d4-0d24f40c478a"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
231371 231371 0046d5ce-1a23-4d92-a8d4-0d24f40c478a gs_GbTSHvbPxhxV4J8WGj8bgdBJ Combat Reptile 0
231372 231372 0046d5ce-1a23-4d92-a8d4-0d24f40c478a gs_hGPyKdqXmJvpqHXxvCRyWjqM Kisnake 0
231373 231373 0046d5ce-1a23-4d92-a8d4-0d24f40c478a gs_fXpY8dXWbFkPJfpXdKVvW69W ssss-expression 0
231374 231374 0046d5ce-1a23-4d92-a8d4-0d24f40c478a gs_wYVfkhSGcrHDgMXGHGk8HHfM 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);