teams

4 rows where series = 9

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: size, irregular

id ▲ series members size initials irregular
17 Series 9 9 David and Jo 2 D+J
18 Series 9 9 Ed, Katy and Rose 3 EK+R
19 Series 9 9 David and Ed 2 D+E ✓
20 Series 9 9 Jo, Katy and Rose 3 JK+R ✓

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE teams (
   id        INTEGER PRIMARY KEY,
   series    INTEGER REFERENCES series(id),
   members   TEXT,
   size      INTEGER,
   initials  TEXT,
   irregular INTEGER
);