participants

4 rows where gid = "00c0c291-3c3a-4001-abd8-3eb0bb145c2d"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
123597 123597 00c0c291-3c3a-4001-abd8-3eb0bb145c2d gs_tycpSmdKbHpCXF6XBd8yjM6T lavafish 0
123598 123598 00c0c291-3c3a-4001-abd8-3eb0bb145c2d gs_h4BXt4p3H6QtBMYBM6xDY9Bf Pea Eater 0
123599 123599 00c0c291-3c3a-4001-abd8-3eb0bb145c2d gs_bPrPTT6QTB8Twgd6rjD3M74S Combat Reptile 1
123600 123600 00c0c291-3c3a-4001-abd8-3eb0bb145c2d gs_FCCqDWHvxX3P98pgQVWDF9x8 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);