participants

4 rows where gid = "69d523b4-d2b9-4046-bba8-60852f01e498"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
168 168 69d523b4-d2b9-4046-bba8-60852f01e498 gs_xmM9kmgVdkdQQWPBXXQSj33Y starter-snake-2 0
169 169 69d523b4-d2b9-4046-bba8-60852f01e498 gs_CGFwHC6CRF83rd79TvhH86D4 Silvester Snake 0
170 170 69d523b4-d2b9-4046-bba8-60852f01e498 gs_w4TGw4fBdVJKXc8gwbfbfKc8 TestSnake 0
171 171 69d523b4-d2b9-4046-bba8-60852f01e498 gs_7WJC9XVSmFHQMX6YcKc3rWHW Combat Reptile 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);