participants

4 rows where gid = "ab07fc16-371d-48c1-be57-0517e62cd327"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
158 158 ab07fc16-371d-48c1-be57-0517e62cd327 gs_xSH8tGxJC7FPJQcbWhRmjh8H ElenderDödel 0
159 159 ab07fc16-371d-48c1-be57-0517e62cd327 gs_TYDdmVvym6dmbd3XkwJfb8YX Robin 0
160 160 ab07fc16-371d-48c1-be57-0517e62cd327 gs_qFMrSYRmMg7Pfc8B6txr8wyQ Combat Reptile 1
161 161 ab07fc16-371d-48c1-be57-0517e62cd327 gs_KS8ryMbBJMc4txVp9QKFgtgT Ambitious Noodle 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);