participants
4 rows where gid = "008f534d-db6f-42e2-a5a9-7bc9813ee21b"
This data as json, CSV (advanced)
Suggested facets: won
| Link | rowid ▼ | gid | sid | name | won |
|---|---|---|---|---|---|
| 26604 | 26604 | 008f534d-db6f-42e2-a5a9-7bc9813ee21b | gs_qkS9bPGXp9QhbFCpRB8mW643 | Combat Reptile | 0 |
| 26605 | 26605 | 008f534d-db6f-42e2-a5a9-7bc9813ee21b | gs_PBjwRfWSbKC8TJtrkMmyBkvR | Ami ☮ | 0 |
| 26606 | 26606 | 008f534d-db6f-42e2-a5a9-7bc9813ee21b | gs_DVJKFHG4jFXYHMVVHtcg6xHQ | Fer-De-Lance | 1 |
| 26607 | 26607 | 008f534d-db6f-42e2-a5a9-7bc9813ee21b | gs_QGwDkk4kFrPqHhJvYYQC9krb | Cucumber Cat | 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);