participants
2 rows where gid = "34993b1a-9ee0-4bc2-86d6-1007ac02f0fd"
This data as json, CSV (advanced)
Link | rowid ▼ | gid | sid | name | won |
---|---|---|---|---|---|
102 | 102 | 34993b1a-9ee0-4bc2-86d6-1007ac02f0fd | gs_tkc4G9ktX3PhrpJB9VmcttqJ | Combat Reptile | 1 |
103 | 103 | 34993b1a-9ee0-4bc2-86d6-1007ac02f0fd | gs_jdW4qmckJwrc6VCSgR6GHvrQ | Noodle | 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);