TdlM / taskmaster

Menu
  • Make shortlink

title_coiners

14 rows where coiner = 1

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ episode coiner task
13 The dong and the gong. 13 Alex Horne 1 Surprise Alex 72
16 The F.I.P. 16 Alex Horne 1 Move water from one bucket to another 90
26 The leprechaun or the lesbian. 26 Alex Horne 1 Paint a rainbow in the dark 153
27 Phoenix. 27 Alex Horne 1 Word table tennis 161
43 The Bubble Brothers. 43 Alex Horne 1 Make the biggest bubble and burst it with your nose 255
67 Five miles per day. 67 Alex Horne 1 Score a goal with a steamroller 392
71 A cuddle. 71 Alex Horne 1 Find and put the gold rings on the stick 413
72 Shaqinahat. 72 Alex Horne 1 Throw something into a pedal bin 416
85 The fastest duck. 85 Alex Horne 1 Sculpt the scene on the other side of the wall 487
97 Oatmeal and death. 97 Alex Horne 1 Work out the contents of the bags 549
100 Croissants is croissants. 100 Alex Horne 1 Sit on a cake 563
104 Nothing matters. 104 Alex Horne 1 Get goosebumps 586
112 The 75th question. 112 Alex Horne 1 Correctly guess the person's first name 629
148 Always forks and marbles. 148 Alex Horne 1 Give your guest the best service 818

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