participants

4 rows where gid = "00e09171-f3a5-4d3d-a297-6e0d8a6ed402"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
146387 146387 00e09171-f3a5-4d3d-a297-6e0d8a6ed402 gs_WCPwyQxRgbmvM4Kkyj676hSB Combat Reptile 0
146388 146388 00e09171-f3a5-4d3d-a297-6e0d8a6ed402 gs_VtWFhtXHCXpbYpHm3vtSCdF8 haspid 0
146389 146389 00e09171-f3a5-4d3d-a297-6e0d8a6ed402 gs_RRw9GQK6h4FFfxFF3g8xGQ7T royal marrrvin 0
146390 146390 00e09171-f3a5-4d3d-a297-6e0d8a6ed402 gs_GC9HtCFT6j6SCJ47GrmM4wRP marrrvin 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);