teams
2 rows where series = 13
This data as json, CSV (advanced)
| id ▲ | series | members | size | initials | irregular |
|---|---|---|---|---|---|
| 29 | Series 13 13 | Ardal and Chris | 2 | A+C | |
| 30 | Series 13 13 | Bridget, Judi and Sophie | 3 | BJ+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 );