participants

4 rows where gid = "008b3fc1-ede5-4eb2-be55-dbae717e8300"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
11412 11412 008b3fc1-ede5-4eb2-be55-dbae717e8300 gs_GXrcmxHD4PBRCtVjCRrbJHVJ beta marvin 0
11413 11413 008b3fc1-ede5-4eb2-be55-dbae717e8300 gs_GxpS8YQhXJ4wJ8k7FbVvVP3c Combat Reptile 1
11414 11414 008b3fc1-ede5-4eb2-be55-dbae717e8300 gs_B837RmGyWCybPHPd37tjRffX Secret Snake 0
11415 11415 008b3fc1-ede5-4eb2-be55-dbae717e8300 gs_F8wkPjDF9TKyC9rf4RFD8wXc hawthhhh++ 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);