TdlM / taskmaster

Menu
  • Make shortlink

title_coiners

2 rows where coiner = 90

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ episode coiner task
118 The chassis, the wings. 118 John Kearns 90 Land loo roll in the toilet 660
126 A new business end. 126 John Kearns 90 Paint a self portrait with a selected brush on a selected canvas 703

Advanced export

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

CSV options:

CREATE TABLE title_coiners (
   id       INTEGER PRIMARY KEY,
   episode  INTEGER REFERENCES episodes(id),
   coiner   INTEGER REFERENCES people(id),
   task     INTEGER REFERENCES tasks(id)
);
Powered by Datasette · Queries took 5.612ms