taskmaster: measurements: 38 rows where contestant = 72

measurement: A value of "?" indicates that no conclusive measurement was given, with null used to signify a DNF/DQ. Note that times are stored internally as seconds but presented in D:HH:MM:SS format.

38 rows where contestant = 72

descending

id ▲	task	contestant	measurement	objective
1271	Strike Alex with a ball 543	Victoria Coren Mitchell 72	07:24	time ▼ 2
1276	Pop the balloon 545	Victoria Coren Mitchell 72	25:30	time ▼ 2
1281	Strike poses to represent a hobby, an animal, and a celebrity 546	Victoria Coren Mitchell 72	0	guessed poses ▲ 121
1286	Work out the contents of the bags 549	Victoria Coren Mitchell 72	8	guessed ingredients ▲ 122
1303	Paint the space hopper green 550	Victoria Coren Mitchell 72	1	speed points ▲ 123
1304	Paint the space hopper green 550	Victoria Coren Mitchell 72	1	coverage points ▲ 124
1305	Paint the space hopper green 550	Victoria Coren Mitchell 72	5	cleanliness points ▲ 125
1306	Paint the space hopper green 550	Victoria Coren Mitchell 72	7	points ▲ 91
1311	Put on the medallion 551	Victoria Coren Mitchell 72	DNF / DQ	time ▼ 2
1316	Copy Alex 553	Victoria Coren Mitchell 72	64.5	routine criteria ▲ 126
1321	Make a sand bridge across the river 554	Victoria Coren Mitchell 72	9	inches ▲ 59
1326	Convey objects using shadows 556	Victoria Coren Mitchell 72	1	round wins ▲ 105
1335	Complete the course as slowly as possible 558	Victoria Coren Mitchell 72	8	penalties ▼ 36
1336	Complete the course as slowly as possible 558	Victoria Coren Mitchell 72	0.371	time ▲ 35
1341	Solve the riddle 560	Victoria Coren Mitchell 72	33:33	time ▼ 2
1346	Get the most forks in your bucket 561	Victoria Coren Mitchell 72	7	bucketed forks ▲ 127
1351	Sit on a cake 563	Victoria Coren Mitchell 72	25	time ▼ 2
1356	Get the most balls in the net 564	Victoria Coren Mitchell 72	-128	points ▲ 91
1361	Prevent Alex from scoring a goal 565	Victoria Coren Mitchell 72	INCONCLUSIVE	time ▲ 35
1366	Pop the most balloons 566	Victoria Coren Mitchell 72	3	balloons ▲ 101
1371	Land the iron on the ironing board 568	Victoria Coren Mitchell 72	8.6	meters ▲ 4
1376	Sit on the red chair in the secret tower 570	Victoria Coren Mitchell 72	08:56	time ▼ 2
1389	Make paper aeroplanes 571	Victoria Coren Mitchell 72	0	landed aeroplanes ▲ 128
1390	Make paper aeroplanes 571	Victoria Coren Mitchell 72	7	sheets ▼ 129
1391	Make paper aeroplanes 571	Victoria Coren Mitchell 72	-35	points ▲ 91
1404	Put up a shelf for the Taskmaster's snooker balls 573	Victoria Coren Mitchell 72	03:00	time ▼ 2
1405	Put up a shelf for the Taskmaster's snooker balls 573	Victoria Coren Mitchell 72	4.5	difference in inches ▼ 130
1406	Put up a shelf for the Taskmaster's snooker balls 573	Victoria Coren Mitchell 72	3	points ▲ 91
1411	Pass everything through the pipe and the pipe through everything 575	Victoria Coren Mitchell 72	19:16	time ▼ 2
1416	Direct drawings using limited keywords 576	Victoria Coren Mitchell 72	1	points ▲ 91
1421	Make a popcorn necklace and do the right thing 578	Victoria Coren Mitchell 72	DNF / DQ	time ▼ 2
1426	Pop up before the objects 581	Victoria Coren Mitchell 72	8	points ▲ 91
1433	Have the longest telephone conversation 584	Victoria Coren Mitchell 72	03:41	time ▲ 35
1438	Find the soldier with hindsight 585	Victoria Coren Mitchell 72	13:30	time ▼ 2
1443	Get goosebumps 586	Victoria Coren Mitchell 72	DNF / DQ	time ▼ 2
1448	Duck-slide 587	Victoria Coren Mitchell 72	8	points ▲ 91
1453	Drink with your mouth open 589	Victoria Coren Mitchell 72	08:30	time ▼ 2
1458	Make noises without being identified by the Taskmaster 592	Victoria Coren Mitchell 72	2	identified noises ▼ 131

Advanced export

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

CREATE TABLE measurements (
   id          INTEGER PRIMARY KEY,
   task        INTEGER REFERENCES tasks(id),
   contestant  INTEGER REFERENCES people(id),
   measurement REAL,
   objective   INTEGER REFERENCES objectives(id)
);