participants

4 rows where gid = "00779226-81b3-42ff-8166-4706a93a696d"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
135267 135267 00779226-81b3-42ff-8166-4706a93a696d gs_8thTVHtbm7MQMgwyFrcmkVpY Combat Reptile 0
135268 135268 00779226-81b3-42ff-8166-4706a93a696d gs_ttWCpbYK3dwqRkMDcd4gV8gK ich heisse marvin 0
135269 135269 00779226-81b3-42ff-8166-4706a93a696d gs_qrjRH8wFJpt4d6yvgWKxw7xd haspid 0
135270 135270 00779226-81b3-42ff-8166-4706a93a696d gs_KtgKchtbx9HYmJD3RDxtfrK9 Snaky McSnakeface 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);