teams
2 rows where series = 6
This data as json, CSV (advanced)
id ▲ | series | members | size | initials | irregular |
---|---|---|---|---|---|
11 | Series 6 6 | Alice and Russell | 2 | A+R | |
12 | Series 6 6 | Asim, Liza and Tim | 3 | AL+T |
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 );