participants

4 rows where gid = "005ea8e5-c3db-4f79-ab2a-b79142016b79"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
195387 195387 005ea8e5-c3db-4f79-ab2a-b79142016b79 gs_vR7bMMq73JHwbddWkc9Rf4rV Combat Reptile 1
195388 195388 005ea8e5-c3db-4f79-ab2a-b79142016b79 gs_DCGJwfXMbgpcg8ftC4Q37JPR $n4k3 0
195389 195389 005ea8e5-c3db-4f79-ab2a-b79142016b79 gs_JSX9JkYKMRVBW7cg7HqRxF6C Ami ☮ 0
195390 195390 005ea8e5-c3db-4f79-ab2a-b79142016b79 gs_vrRB7XPH8vjb6MpSJmTQFCqJ biter 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);