participants
4 rows where gid = "000aa0ff-fd69-48de-9b8d-8081dc5575ca"
This data as json, CSV (advanced)
Link | rowid ▼ | gid | sid | name | won |
---|---|---|---|---|---|
102136 | 102136 | 000aa0ff-fd69-48de-9b8d-8081dc5575ca | gs_kJYGPrDvSW9TCq3YvT6GyGBV | Combat Reptile | 0 |
102137 | 102137 | 000aa0ff-fd69-48de-9b8d-8081dc5575ca | gs_qcbKc9bcVt9Jwdgx8dPXHbPG | Gruppe8 | 0 |
102138 | 102138 | 000aa0ff-fd69-48de-9b8d-8081dc5575ca | gs_HpfkcytJ6cfxmgXmQTwTSP9b | hawthhhh++ | 1 |
102139 | 102139 | 000aa0ff-fd69-48de-9b8d-8081dc5575ca | gs_jXqwbyj9YR4wCWRrPjrgXjfJ | nomblegomble | 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);