participants
2 rows where gid = "00ab979b-7285-48a8-95c5-802c0c6d6ec5"
This data as json, CSV (advanced)
Link | rowid ▼ | gid | sid | name | won |
---|---|---|---|---|---|
282174 | 282174 | 00ab979b-7285-48a8-95c5-802c0c6d6ec5 | gs_7qJGmCwYtmSkdfhv6TRVpdS8 | Combat Reptile | 1 |
282175 | 282175 | 00ab979b-7285-48a8-95c5-802c0c6d6ec5 | gs_r4pqgG8Bhc3t7gMRjXtwTyYH | bamboozle snake | 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);