participants

4 rows where gid = "0072d239-d7a5-4bf4-9bfe-c29c8f79aa32"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
117860 117860 0072d239-d7a5-4bf4-9bfe-c29c8f79aa32 gs_YwTFy8KrB6v6CJmSFWDDQrh6 🇺🇦🇷🇺 Shapeshifter 🇺🇦🇷🇺 1
117861 117861 0072d239-d7a5-4bf4-9bfe-c29c8f79aa32 gs_fdW9wFB6KCPYPB99FxgjBBd7 Combat Reptile 0
117862 117862 0072d239-d7a5-4bf4-9bfe-c29c8f79aa32 gs_6cB4vRqptKXGcVH8M6h9FVQd Ami ☮ 0
117863 117863 0072d239-d7a5-4bf4-9bfe-c29c8f79aa32 gs_JMmRtXGcPq87QxdrHxHpFwcS Pea Eater 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);