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