participants
2 rows where gid = "00234d70-f801-4e37-bc51-5c956eff917f"
This data as json, CSV (advanced)
| Link | rowid ▼ | gid | sid | name | won | 
|---|---|---|---|---|---|
| 75068 | 75068 | 00234d70-f801-4e37-bc51-5c956eff917f | gs_pDH4WQww7brQDWHKyXHc4Br7 | Gruppe8 | 0 | 
| 75069 | 75069 | 00234d70-f801-4e37-bc51-5c956eff917f | gs_MxgqSvY9PjpFF6RmYF388MWG | Combat Reptile | 1 | 
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);