participants

4 rows where gid = "004fb385-6649-4660-91ec-1b2214ae7000"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
34308 34308 004fb385-6649-4660-91ec-1b2214ae7000 gs_VKr3ckVMbhVDq4yX7JrCScTc Ami ☮ 0
34309 34309 004fb385-6649-4660-91ec-1b2214ae7000 gs_HwVSrfMkJwCwtRdrBf7R8qqF Combat Reptile 1
34310 34310 004fb385-6649-4660-91ec-1b2214ae7000 gs_xwpT8MQxwJp7wGqQHGDdch7b moustache 🥸 0
34311 34311 004fb385-6649-4660-91ec-1b2214ae7000 gs_VBmX97djKg8bwcTtWYjMwk4K Secret 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);