participants

4 rows where gid = "e09adef3-beac-4f04-b746-6c8e8c440cbf"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
52 52 e09adef3-beac-4f04-b746-6c8e8c440cbf gs_vHXh9FpVSGVGS9h8yjQSYcX4 battlesnake-rails 0
53 53 e09adef3-beac-4f04-b746-6c8e8c440cbf gs_3Qfp63wqHGw9HCPjjGR3BRjF Jormungand 0.1.0 0
54 54 e09adef3-beac-4f04-b746-6c8e8c440cbf gs_6hKBCYkPbTKByKkcWXKYg9gC Silvester Snake 0
55 55 e09adef3-beac-4f04-b746-6c8e8c440cbf gs_Phx7XxJGCvcydHP9PwymRvCV Combat Reptile 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);