participants

4 rows where gid = "009b23f7-bb89-420e-9a48-63f3b3b5c25d"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
216223 216223 009b23f7-bb89-420e-9a48-63f3b3b5c25d gs_yP7QD3MQj9d9XJ7Q7wwgcSSG Combat Reptile 1
216224 216224 009b23f7-bb89-420e-9a48-63f3b3b5c25d gs_HJpKXkfqgKrTbg3FCRj99VMM Pea Eater 0
216225 216225 009b23f7-bb89-420e-9a48-63f3b3b5c25d gs_D3KMm9W78ptSk83tmQvXpCKS Salazar Slitherin 0
216226 216226 009b23f7-bb89-420e-9a48-63f3b3b5c25d gs_JkXBtJPHJJY7d77Vg4vgtF3G conesnake 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);