TdlM / taskmaster

Menu
  • Make shortlink

title_coiners

3 rows where coiner = 105

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ episode coiner task
142 Dynamite chicks. 142 Sam Campbell 105 Complete all the tasks as a team 785
143 Skateboard Division. 143 Sam Campbell 105 Make a cool but scary googly-eyed gang 791
147 Fagin at the disco. 147 Sam Campbell 105 Make the best gift for Greg 812

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 7.32ms