teams
4 rows where series = 10
This data as json, CSV (advanced)
Suggested facets: size, irregular
| id ▲ | series | members | size | initials | irregular |
|---|---|---|---|---|---|
| 21 | Series 10 10 | Daisy and Richard | 2 | D+R | |
| 22 | Series 10 10 | Johnny, Katherine and Mawaan | 3 | JK+M | |
| 23 | Series 10 10 | Daisy and Katherine | 2 | D+K | ✓ |
| 24 | Series 10 10 | Johnny, Mawaan and Richard | 3 | JM+R | ✓ |
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 );