taskmaster: measurements: 20 rows where contestant = 24

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.

20 rows where contestant = 24

descending

id ▲	task	contestant	measurement	objective
394	Get Alex to dry land 148	Bob Mortimer 24	12:37	time ▼ 2
399	Score a basket without your hands 149	Bob Mortimer 24	02:59	time ▼ 2
404	Get some fruit into the bowl 150	Bob Mortimer 24	20	time ▼ 2
409	Make a coconut-flinging machine 152	Bob Mortimer 24	16.2	meters ▲ 4
414	Retrieve the table tennis ball from the tube 158	Bob Mortimer 24	08:13	time ▼ 2
419	Eat one item, balance one item, throw one item 160	Bob Mortimer 24	04:00	time ▼ 2
424	Blow up a balloon to the size of a cucumber 165	Bob Mortimer 24	10	difference in centimeters ▼ 45
429	Spot the difference 166	Bob Mortimer 24	2	spotted differences ▲ 46
434	Sneeze the fastest 167	Bob Mortimer 24	10:01	time ▼ 2
441	Build a can tower & greet Alex from different countries 174	Bob Mortimer 24	6	cans ▲ 48
446	Identify the Finns 175	Bob Mortimer 24	-1	identified Finns minus non-Finns ▲ 49
451	Balance Alex on a see-saw 177	Bob Mortimer 24	32	kilograms ▲ 27
456	Light a candle using a cupcake 180	Bob Mortimer 24	03:05	time ▼ 2
460	Kick yoghurt at a target 182	Bob Mortimer 24	0	bull's-eyed yoghurt ▲ 50
463	Travel blindfolded for three minutes and retrace your steps 184	Bob Mortimer 24	0	meters off target ▼ 51
468	Coconut bobsleigh 185	Bob Mortimer 24	DNF / DQ	team members ▲ 52
473	Vote for who should receive five points 186	Bob Mortimer 24	1	votes ▲ 53
478	Zipwire items to the Taskmaster 188	Bob Mortimer 24	8	zip-lined items ▲ 54
483	Transport a coconut as far as possible 190	Bob Mortimer 24	33	meters ▲ 4
490	Throw an egg through a basketball hoop 194	Bob Mortimer 24	1	caught makes ▲ 56

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