teams
2 rows where series = 16
This data as json, CSV (advanced)
id ▲ | series | members | size | initials | irregular |
---|---|---|---|---|---|
35 | Series 16 16 | Sue and Susan | 2 | S+S | |
36 | Series 16 16 | Julian, Lucy and Sam | 3 | JL+S |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE teams ( id INTEGER PRIMARY KEY, series INTEGER REFERENCES series(id), members TEXT, size INTEGER, initials TEXT, irregular INTEGER );