participants

4 rows where gid = "000dff4d-132d-44eb-b731-a0cb2386d8af"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
155657 155657 000dff4d-132d-44eb-b731-a0cb2386d8af gs_7wHJPS6rFy84hcW3PKjMmYMM Combat Reptile 0
155658 155658 000dff4d-132d-44eb-b731-a0cb2386d8af gs_DDwMBK67r9VKH4xDtDSgHBCB Hovering Hobbs 0
155659 155659 000dff4d-132d-44eb-b731-a0cb2386d8af gs_r7tFc7GQY9WRPXbMhYqGrmJF nomblegomble 0
155660 155660 000dff4d-132d-44eb-b731-a0cb2386d8af gs_qBghKwWcYw3PjFStbKQkxC38 beta marvin 1

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);