TdlM / taskmaster

Menu
  • Make shortlink

teams

4 rows where series = 10

✎ View and edit SQL

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

CSV options:

CREATE TABLE teams (
   id        INTEGER PRIMARY KEY,
   series    INTEGER REFERENCES series(id),
   members   TEXT,
   size      INTEGER,
   initials  TEXT,
   irregular INTEGER
);
Powered by Datasette · Queries took 5.874ms