participants
4 rows where gid = "00671bbf-168e-4dbe-8190-3c0cbdd9a68a"
This data as json, CSV (advanced)
Suggested facets: won
| Link | rowid ▼ | gid | sid | name | won |
|---|---|---|---|---|---|
| 149589 | 149589 | 00671bbf-168e-4dbe-8190-3c0cbdd9a68a | gs_bxWBXrCWQVvbjD6KWrH7wMSC | Combat Reptile | 1 |
| 149590 | 149590 | 00671bbf-168e-4dbe-8190-3c0cbdd9a68a | gs_DxVwS4w8HtRDF3kYbddQf7g4 | Test Snek pls Ignore | 0 |
| 149591 | 149591 | 00671bbf-168e-4dbe-8190-3c0cbdd9a68a | gs_YbcGHScMQRK4vQrxTDrXQHmG | Ami ☮ | 0 |
| 149592 | 149592 | 00671bbf-168e-4dbe-8190-3c0cbdd9a68a | gs_Y66dt3cKwYvfKxhwgck7HtDS | 🇺🇦🇷🇺 Shapeshifter 🇺🇦🇷🇺 | 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);