participants

4 rows where gid = "00be8ca1-21e7-47c8-bc19-8f6f48155f74"

This data as json, CSV (advanced)

Link rowid ▼ gid sid name won
293604 293604 00be8ca1-21e7-47c8-bc19-8f6f48155f74 gs_hwgvmvc67Wybr3GgV6hjfRyQ Combat Reptile 0
293605 293605 00be8ca1-21e7-47c8-bc19-8f6f48155f74 gs_3HpST8g7Ky4pyhwgYhDBtQBF CoolestSnake! 0
293606 293606 00be8ca1-21e7-47c8-bc19-8f6f48155f74 gs_mvSxWPxYbFYtd98bwX47hv47 Prüzze v2 0
293607 293607 00be8ca1-21e7-47c8-bc19-8f6f48155f74 gs_8M8WpTmBQvDmVKXfmg3Dbv4X Shapeshifter 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);