TdlM / taskmaster

Menu
  • Make shortlink

title_coiners

4 rows where coiner = 72

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ episode coiner task
99 The customised inhaler. 99 Victoria Coren Mitchell 72 Solve the riddle 560
101 A chair in a sweet. 101 Victoria Coren Mitchell 72 Sit on the red chair in the secret tower 570
102 The integrity of the product. 102 Victoria Coren Mitchell 72 Write and perform a 30-second jingle 574
105 Caring Uncle Minpict. 105 Victoria Coren Mitchell 72 Describe the Taskmaster / Chocolate button / Guess the tasks 590

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.558ms