taskmaster: tasks: 28 rows where series = 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.

28 rows where series = 3

descending

id ▲	series	episode	summary	tags	location	points	std	TMI	YT
66	Series 3 3	A pea in a haystack. 12	The most flamboyant clock	👤🎁🎨⚖️📄💡	seats	15	✓	➚	▶
67	Series 3 3	A pea in a haystack. 12	Reach the microwave in the fewest steps	👤🎞️🧠💪🎯📄💡	special	14	✓	➚	▶
68	Series 3 3	A pea in a haystack. 12	Propel a pea along a red carpet	👤🎞️🧠💪🎯📄💡	lounge	14	✓	➚	▶
69	Series 3 3	A pea in a haystack. 12	Make the best snowman	👤🎞️🎨⚖️📄💡	lounge	15	✓	➚	▶
70	Series 3 3	A pea in a haystack. 12	Balance swedes on a Swede	👤🎪💪🎯📄💡	stage	15	✓	➚	▶
71	Series 3 3	The dong and the gong. 13	The heaviest shoebox-sized item	👤🎁🎨🎯📄💡	seats	15	✓	➚	▶
72	Series 3 3	The dong and the gong. 13	Surprise Alex	👤🎞️🎨📣⚖️📄💡	lounge	15	✓	➚	▶
73	Series 3 3	The dong and the gong. 13	Release Alex	👥🎞️🧠🎯📄💡🚫🔎	lounge	10	✓	➚	▶
74	Series 3 3	The dong and the gong. 13	An upside-down condiment self-portrait	👤🎞️🎨⚖️📄💡	patio	16	✓	➚	▶
75	Series 3 3	The dong and the gong. 13	Burst all of the balloons	👤🎞️🧠💪🎯📄💡🚫	garden	15	✓	➚	▶
76	Series 3 3	The dong and the gong. 13	Unravel the tape	👤🎪💪🎯📄💡	stage	14	✓	➚	▶
77	Series 3 3	Little polythene grief cave. 14	The best battery-operated item	👤🎁🎨⚖️📄💡	seats	15	✓	➚	▶
78	Series 3 3	Little polythene grief cave. 14	Fill an eggcup with sweat	👤🎞️🧠💪🎯📄💡	lab	14	✓	➚	▶
79	Series 3 3	Little polythene grief cave. 14	Make the best domino rally	👤🎞️🎨🧠💪⚖️📄💡	lounge	14	✓	➚	▶
80	Series 3 3	Little polythene grief cave. 14	Buy a gift for the Taskmaster	👤📓📣⚖️📄🧬	foyer	15	✓	➚	▶
81	Series 3 3	Little polythene grief cave. 14	Create the best flag meal	👤🎞️🎨⚖️📄🧬	lab	15	✓	➚	▶
82	Series 3 3	Little polythene grief cave. 14	Anchor balloons using bread	👤🎪🧠💪🎯📄💡	stage	15	✓	➚	▶
83	Series 3 3	A very nuanced character. 15	The shiniest thing	👤🎁🎨⚖️📄💡	seats	15	✓	➚	▶
84	Series 3 3	A very nuanced character. 15	Spread your clothes far and wide	👤🎞️🧠💪🎯📄💡	doorstep	15	✓	➚	▶
85	Series 3 3	A very nuanced character. 15	Find out the lying old man’s occupation	👤🎞️🧠📣🎯📄💡	lab	15	✓	➚	▶
86	Series 3 3	A very nuanced character. 15	Create an impressive special effect	👥🎞️🎨📣⚖️📄💡	lab	13	✓	➚	▶
87	Series 3 3	A very nuanced character. 15	Cover yourself in sticky notes	👤🎪💪🎯📄💡	stage	15	✓	➚	▶
88	Series 3 3	A very nuanced character. 15	Have fun on a bouncy castle	👤✨🎞️🎨💪⚫📄💡	garden			➚	▶
89	Series 3 3	The F.I.P. 16	The most handsome relative	👤🎁🎨⚖️📄💡	seats	14	✓	➚	▶
90	Series 3 3	The F.I.P. 16	Move water from one bucket to another	👤🎞️🧠💪🎯📄💡	special	15	✓	➚	▶
91	Series 3 3	The F.I.P. 16	Play charades across a river	👥🎞️🧠📣🎯📄💡	special	15	✓	➚	▶
92	Series 3 3	The F.I.P. 16	Create an impressive time-lapse or slow motion film	👤🎞️🎨⚖️📄💡	doorstep	18	✓	➚	▶
93	Series 3 3	The F.I.P. 16	The lowest unique number of doughnuts	👤🎪🧠📣🎯📄🧬👑	stage	5	✓	➚	▶

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