participants

4 rows where gid = "57d07aac-d19b-4471-88bd-53c872dbb071"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
132 132 57d07aac-d19b-4471-88bd-53c872dbb071 gs_cSH4QmDP6K7kX74TRxhRWBjX Snake without name 0
133 133 57d07aac-d19b-4471-88bd-53c872dbb071 gs_VPh6JQGrkWCvV64f4Vwh8qRD TestSnake 0
134 134 57d07aac-d19b-4471-88bd-53c872dbb071 gs_HxySXcgYBjGxHkD9w9GPdwhb Combat Reptile 1
135 135 57d07aac-d19b-4471-88bd-53c872dbb071 gs_YMFk4htFmmMCKJKdK4PjRYXb starter-snake-2 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);