taskmaster: attempts: 45 rows where contestant = 24

PO (presentation order): the order in which the contestant's prize, VT, work of art, or live attempt was presented; 0 for simultaneous (most live tasks)
± (adjustment): any alteration (bonus or deduction) applied to the attempt's base score
episode: the contestant's cumulative episode score after this task
series: 〃

45 rows where contestant = 24

descending

id ▲	task	contestant	PO	base	points	rank	episode	series	team
685	The most excellent noise 146	Bob Mortimer 24	2	2	2	4	2	2
690	Give Alex a special cuddle 147	Bob Mortimer 24	5	5	5	1	7	7
695	Get Alex to dry land 148	Bob Mortimer 24	3=	2	2	4	9	9
700	Score a basket without your hands 149	Bob Mortimer 24	1=	5	5	1	14	14
705	Get some fruit into the bowl 150	Bob Mortimer 24	0	4	4	2	18	18
710	The hippest headwear 151	Bob Mortimer 24	5	4	4	2	4	22
715	Make a coconut-flinging machine 152	Bob Mortimer 24	4=	5	5	1	9	27
720	Paint a rainbow in the dark 153	Bob Mortimer 24	1=	1	1	5	10	28
725	Slice bread using something from the caravan 154	Bob Mortimer 24	4=	DQ	0		10	28
730	Create the greatest splat 155	Bob Mortimer 24	1=	2	2	2=	12	30	AB+S
735	Paint your own canvas 156	Bob Mortimer 24	0	4	4	5	16	34
740	The proudest item 157	Bob Mortimer 24	1	5	5	1	5	39
745	Retrieve the table tennis ball from the tube 158	Bob Mortimer 24	4	5	5	1	10	44
750	Make a coconut businessman 159	Bob Mortimer 24	1	1	1	5	11	45
755	Eat one item, balance one item, throw one item 160	Bob Mortimer 24	1=	4	4	2	15	49
760	Word table tennis 161	Bob Mortimer 24	0	2	2	4	17	51
765	The most extraordinary souvenir 162	Bob Mortimer 24	4	1	1	5	1	52
770	Make marmite 163	Bob Mortimer 24	3	5	5	1	6	57
775	Do something remarkable synchronised 164	Bob Mortimer 24	2=	3	3	1=	9	60	AB+S
780	Blow up a balloon to the size of a cucumber 165	Bob Mortimer 24	1=	4	4	2	13	64
785	Spot the difference 166	Bob Mortimer 24	1=	2	2	4=	15	66
790	Sneeze the fastest 167	Bob Mortimer 24	1=	5	5	1	20	71
795	Greg says... 168	Bob Mortimer 24	0	1	1	5	21	72
802	The most high-octane item 170	Bob Mortimer 24	5	4	4	2	4	76
807	Put the largest thing inside a balloon 171	Bob Mortimer 24	3=	0	0		4	76
812	Create a remarkable water cooler moment 172	Bob Mortimer 24	1	3	3	3	7	79
818	Build a can tower & greet Alex from different countries 174	Bob Mortimer 24	2	5	5	1=	12	84
823	Identify the Finns 175	Bob Mortimer 24	2	2	2	4=	14	86
828	The best home-made item 176	Bob Mortimer 24	5	5	5	1	5	91
833	Balance Alex on a see-saw 177	Bob Mortimer 24	4	2	2	4	7	93
838	Record the most incredible PoV footage 178	Bob Mortimer 24	3	4	4	2=	11	97
844	Light a candle using a cupcake 180	Bob Mortimer 24	4	5	5	1	16	102
849	Make yourself monotone 181	Bob Mortimer 24	0	2	2	4	18	104
853	Kick yoghurt at a target 182	Bob Mortimer 24	1=	0	0		18	104
856	The most surprisingly expensive item 183	Bob Mortimer 24	3	3	3	3=	3	107
861	Travel blindfolded for three minutes and retrace your steps 184	Bob Mortimer 24	1	5	5	1	8	112
866	Coconut bobsleigh 185	Bob Mortimer 24	4=	DQ	0		8	112
871	Vote for who should receive five points 186	Bob Mortimer 24	1=	0	0		8	112
876	Make a funny flick book 187	Bob Mortimer 24	1	5	5	1=	13	117
881	Zipwire items to the Taskmaster 188	Bob Mortimer 24	0	5	5	1	18	122
886	The most awkward item to take home 189	Bob Mortimer 24	2	1	1	5	1	123
891	Transport a coconut as far as possible 190	Bob Mortimer 24	1=	4	4	2	5	127
896	Create the best graph 191	Bob Mortimer 24	5	4	4	2	9	131
903	Write and perform a song about a stranger 193	Bob Mortimer 24	2=	2	2	2=	11	133	AB+S
908	Throw an egg through a basketball hoop 194	Bob Mortimer 24	0	5	5	1	16	138

Advanced export

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

CREATE TABLE attempts (
   id         INTEGER PRIMARY KEY,
   task       INTEGER REFERENCES tasks(id),
   contestant INTEGER REFERENCES people(id),
   PO         TEXT,
   base       INTEGER,
   adjustment INTEGER,
   points     INTEGER,
   rank       TEXT,
   episode    INTEGER,
   series     INTEGER,
   team       INTEGER REFERENCES teams(id),
   location   INTEGER REFERENCES special_locations(id)
);