participants

4 rows where gid = "00754f81-1f93-43aa-b50b-5dcd9003368e"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
28930 28930 00754f81-1f93-43aa-b50b-5dcd9003368e gs_TBwt8xBrHW7J4qvF37cdkmGc Combat Reptile 0
28931 28931 00754f81-1f93-43aa-b50b-5dcd9003368e gs_Jg8mPQPtqQD7KPgtJR7TMFMS moustache 🥸 1
28932 28932 00754f81-1f93-43aa-b50b-5dcd9003368e gs_mQyWr7fDQmJYbyJmWCqdqTWT Secret Snake 0
28933 28933 00754f81-1f93-43aa-b50b-5dcd9003368e gs_JgH96vFkgdgrg7qdwwhVQFjb hawthhhh++ 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);