participants

4 rows where gid = "0060a96c-4c4f-4c54-b69f-9111bb75ba97"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
160135 160135 0060a96c-4c4f-4c54-b69f-9111bb75ba97 gs_rMGvSrX6DBdvqRvq8qHScqJW Combat Reptile 0
160136 160136 0060a96c-4c4f-4c54-b69f-9111bb75ba97 gs_FDRVfpcXCWPcvwQfxDXKK7HR Hovering Hobbs 0
160137 160137 0060a96c-4c4f-4c54-b69f-9111bb75ba97 gs_XDy64xqjbCr8jjDTWG3kX8k7 Pea Eater 1
160138 160138 0060a96c-4c4f-4c54-b69f-9111bb75ba97 gs_dStyTYw8b4KgcY9tH967PVSC SnakeDrop 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);