participants

4 rows where gid = "007f7df7-7487-4230-a5bd-4876228f30e6"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
151055 151055 007f7df7-7487-4230-a5bd-4876228f30e6 gs_K8m3XqjCxC6QMQXJwHX7ypDV Combat Reptile 0
151056 151056 007f7df7-7487-4230-a5bd-4876228f30e6 gs_xKtmvKhQ4GpYWrK6hYqmDbPJ 🇺🇦🇷🇺 Shapeshifter 🇺🇦🇷🇺 1
151057 151057 007f7df7-7487-4230-a5bd-4876228f30e6 gs_HVPmVjrRDGtYhf9wTfTFx6M9 biter 0
151058 151058 007f7df7-7487-4230-a5bd-4876228f30e6 gs_FxrWPMpRxhg3HH6yjGYhYyYW 😎 Nerdy Caterpillar 🐛 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);