participants

4 rows where gid = "00c6ff16-4dd9-4ec7-b954-d989d24157a3"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
26678 26678 00c6ff16-4dd9-4ec7-b954-d989d24157a3 gs_dxXd4tDVGWcdmf8PvmwFRMVW marrrvin 0
26679 26679 00c6ff16-4dd9-4ec7-b954-d989d24157a3 gs_TbKrQctPRvQHbfYdtd6rBw4d Combat Reptile 1
26680 26680 00c6ff16-4dd9-4ec7-b954-d989d24157a3 gs_qCDm4ff7Kd6pQf79rBWPVV8R Crash 0
26681 26681 00c6ff16-4dd9-4ec7-b954-d989d24157a3 gs_QHd4TmdbP96BVjMcW9t3fgyH Gruppe8 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);