participants

4 rows where gid = "005c8db8-ae8b-46b2-bcd9-738da59cbdb9"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
282894 282894 005c8db8-ae8b-46b2-bcd9-738da59cbdb9 gs_fWtpxmdqbm3BHBVgCbcqGXjC Battle Snail 1
282895 282895 005c8db8-ae8b-46b2-bcd9-738da59cbdb9 gs_b9XYRYFYccMmcMS8hT9M3GrB bamboozle snake 0
282896 282896 005c8db8-ae8b-46b2-bcd9-738da59cbdb9 gs_jMbdDhDJmHcgrvtw3qTVXtbQ Snaky McSnakeface 0
282897 282897 005c8db8-ae8b-46b2-bcd9-738da59cbdb9 gs_wTPH8CDRYh3X7bBM4Vc99Cq3 Combat Reptile 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);