TdlM / taskmaster

Menu
  • Make shortlink

teams

2 rows where series = 1

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ series members size initials irregular
1 Series 1 1 Frank and Tim 2 F+T
2 Series 1 1 Josh, Roisin and Romesh 3 JR+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.489ms