participants
4 rows where gid = "00669629-577e-4b4b-9108-d3af606a7c39"
This data as json, CSV (advanced)
Suggested facets: won
| Link | rowid ▼ | gid | sid | name | won |
|---|---|---|---|---|---|
| 118236 | 118236 | 00669629-577e-4b4b-9108-d3af606a7c39 | gs_RpP3dcpfq9JmdvbjvgC6GWx6 | Combat Reptile | 0 |
| 118237 | 118237 | 00669629-577e-4b4b-9108-d3af606a7c39 | gs_BWgmjrr4b8qD7Y8wkvRkdcdR | Test Snek pls Ignore | 1 |
| 118238 | 118238 | 00669629-577e-4b4b-9108-d3af606a7c39 | gs_68pPk83fW3mQ4q9tGpkhFJCS | hawthhhh++ | 0 |
| 118239 | 118239 | 00669629-577e-4b4b-9108-d3af606a7c39 | gs_XQqxtgyDGP9khgpvMYCSGYmG | Pea Eater | 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);