participants

4 rows where gid = "00853b14-c147-4494-8539-c8e6a39c6cd1"

This data as json, CSV (advanced)

won 2 ✖

Link rowid ▼ gid sid name won
4926 4926 00853b14-c147-4494-8539-c8e6a39c6cd1 gs_KVdfDbjgbcHt6m9x7dWmyQwB Combat Reptile 1
4927 4927 00853b14-c147-4494-8539-c8e6a39c6cd1 gs_ttv63436m9xfcYbdtVBXwXWG snake2_v3_FINAL_final(1) 0
4928 4928 00853b14-c147-4494-8539-c8e6a39c6cd1 gs_KFv9ySBttBQYMrCY6yDBBcXG lavafish 0
4929 4929 00853b14-c147-4494-8539-c8e6a39c6cd1 gs_ghXgjVH6Bbj9RMWkJgchcJFD kaa 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);