participants
4 rows where gid = "187cb79a-9267-4265-8b0c-b8dd6bacc94e"
This data as json, CSV (advanced)
Suggested facets: won
| Link | rowid ▼ | gid | sid | name | won |
|---|---|---|---|---|---|
| 14 | 14 | 187cb79a-9267-4265-8b0c-b8dd6bacc94e | gs_MXT8kGjXvXkHXGqTBMxVJYdG | 🇺🇦🇷🇺 Shapeshifter 🇺🇦🇷🇺 | 0 |
| 15 | 15 | 187cb79a-9267-4265-8b0c-b8dd6bacc94e | gs_tyFtf3897vPtrxKPM6tJk4pd | Combat Reptile | 0 |
| 16 | 16 | 187cb79a-9267-4265-8b0c-b8dd6bacc94e | gs_yCXRrXx964RbbQTqp3THtrk9 | Test Snek pls Ignore | 1 |
| 17 | 17 | 187cb79a-9267-4265-8b0c-b8dd6bacc94e | gs_w38BwcmKBjJvR6RKmpcGMX3T | Gadiuka | 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);