teams
2 rows where series = 12
This data as json, CSV (advanced)
id ▲ | series | members | size | initials | irregular |
---|---|---|---|---|---|
27 | Series 12 12 | Alan and Victoria | 2 | A+V | |
28 | Series 12 12 | Desiree, Guz and Morgana | 3 | DG+M |
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 );