taskmaster: tasks: 7 rows where episode = 3

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.

7 rows where episode = 3

descending

id ▲	series	episode	summary	tags	location	points	std	TMI	YT
12	Series 1 1	The poet and the egg. 3	The most meaningful item	👤🎁🎨⚖️📄💡	seats	15	✓	➚	▶
13	Series 1 1	The poet and the egg. 3	Throw a teabag into a mug	👤🎞️🧠💪🎯📄💡	lounge	14	✓	➚	▶
14	Series 1 1	The poet and the egg. 3	Draw an image using a GPS device	👤🎞️🎨💪⚖️📄💡	special	15	✓	➚	▶
15	Series 1 1	The poet and the egg. 3	Buy a gift for the Taskmaster	👤📓📣⚖️📄💡	foyer	15	✓	➚	▶
16	Series 1 1	The poet and the egg. 3	Get an egg as high as possible	👤🎞️🧠💪🎯📄💡	lab	9	✓	➚	▶
17	Series 1 1	The poet and the egg. 3	Stand up after 100 seconds	👤🎪🧠🎯📄💡	stage	16	✓	➚	▶
18	Series 1 1	The poet and the egg. 3	Guess Frank’s age in minutes	👤❗🎪🧠🎯📄💡	seats			➚	▶

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
);