teams

2 rows where series = 4

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ series members size initials irregular
7 Series 4 4 Hugh and Mel 2 H+M
8 Series 4 4 Joe, Lolly and Noel 3 JL+N

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
);