participants

4 rows where gid = "006e5864-dcd4-401f-b756-acac776b6511"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
292046 292046 006e5864-dcd4-401f-b756-acac776b6511 gs_fGHPSkJSvGB7rCCWgjk4v49T Combat Reptile 1
292047 292047 006e5864-dcd4-401f-b756-acac776b6511 gs_3PScq4GtCptxrCmH4K6DtbxQ soma-mini[sink] 0
292048 292048 006e5864-dcd4-401f-b756-acac776b6511 gs_Cg7BjJCCQdMkyS8X73Vythd6 CoolestSnake! 0
292049 292049 006e5864-dcd4-401f-b756-acac776b6511 gs_rTMtRp6gyHbHVwFwqHmttMXR bamboozle snake 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);