taskmaster: tasks: 6 rows where episode = 18

location: Note that this is specifically the location of the task brief (except in cases of the Knappett being involved), which is generally but not always where the bulk of a task took place.
std: 1 for "standard" tasks (those having five judged attempts), 0 otherwise
YT: Click to open an in-page player seeked to the beginning of the task (including the transition for filmed tasks). Right-click/long-tap to skip the first ten seconds.

6 rows where episode = 18

descending

id ▲	series	episode	summary	tags	location	points	std	TMI	YT
99	Series 4 4	Look at me. 18	The most boastful item	👤🎁🎨⚖️📄💡	seats	15	✓	➚	▶
100	Series 4 4	Look at me. 18	Keep the basketball on the treadmill	👤🎞️🧠💪🎯📄💡	driveway	15	✓	➚	▶
101	Series 4 4	Look at me. 18	Paint a portrait of the Taskmaster without touching the red mat	👤🎞️🎨🧠💪⚖️📄💡🖋️	doorstep	14	✓	➚	▶
102	Series 4 4	Look at me. 18	Get the flour onto the target	👥🎞️💪🎯📄💡	special	10	✓	➚	▶
103	Series 4 4	Look at me. 18	Put an egg in an egg cup without touching either	👤🎞️🧠💪🎯📄💡	lab	15	✓	➚	▶
104	Series 4 4	Look at me. 18	Make the longest balloon chain	👤🎪💪🎯📄💡	stage	17	✓	➚	▶

Advanced export

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

CREATE TABLE tasks (
   id       INTEGER PRIMARY KEY,
   series   INTEGER REFERENCES series(id),
   episode  INTEGER REFERENCES episodes(id),
   summary  TEXT,
   tags     TEXT,
   location INTEGER REFERENCES special_locations(id),
   points   INTEGER,
   std      INTEGER,
   TMI      INTEGER,
   YT       TEXT
);