participants

4 rows where gid = "0085569c-2865-4823-b3d8-a29e1ec9630f"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
44764 44764 0085569c-2865-4823-b3d8-a29e1ec9630f gs_hVCjCMqgtBgXXKtB777fhXGM Combat Reptile 0
44765 44765 0085569c-2865-4823-b3d8-a29e1ec9630f gs_HJbyQSHbybQfPtqTrrQg3Tg4 Snaky McSnakeface 1
44766 44766 0085569c-2865-4823-b3d8-a29e1ec9630f gs_7XmcHHW6fM9r4FPpjqQY6KDd Cobra Kai Never Die 0
44767 44767 0085569c-2865-4823-b3d8-a29e1ec9630f gs_rFM39YYpdXX6G7mQM3TPCXQc Pea Eater 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);