taskmaster: measurements: 25 rows where contestant = 42

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.

25 rows where contestant = 42

descending

id ▲	task	contestant	measurement	objective
652	Make the best quick-change outfit 266	Rhod Gilbert 42	3.8	time ▼ 2
657	Build the tallest cardboard box tower 267	Rhod Gilbert 42	428	centimeters ▲ 10
662	Work out the perimeter of the caravan in beans 268	Rhod Gilbert 42	310	difference in baked beans ▼ 76
667	Write a ten word story while running 271	Rhod Gilbert 42	10:12	time ▼ 2
672	Build a tower of cans within a hoop 275	Rhod Gilbert 42	11	cans ▲ 48
679	Raise Alex’s heart rate 278	Rhod Gilbert 42	11	beats per minute ▲ 78
684	Get the ball into the hole by striking it 280	Rhod Gilbert 42	1	strokes ▼ 79
689	Silently mouth a ten word fact to Greg 281	Rhod Gilbert 42	1	understood words ▲ 80
694	Work out what the switch does 283	Rhod Gilbert 42	DNF / DQ	time ▼ 2
699	Make the scales read exactly 31.770kg 285	Rhod Gilbert 42	07:07	time ▼ 2
704	Get dressed while wearing handcuffs 286	Rhod Gilbert 42	4	correctly donned items ▲ 81
706	Make the best toilet paper plane 287	Rhod Gilbert 42	22.7	meters ▲ 4
711	Make the most white circles on the target 290	Rhod Gilbert 42	8	white circles ▲ 82
716	Put 50 different things in the bin 295	Rhod Gilbert 42	02:30	time ▼ 2
725	Place 10 pairs of glasses into the smallest box 298	Rhod Gilbert 42	DNF / DQ	box size ▼ 83
726	Place 10 pairs of glasses into the smallest box 298	Rhod Gilbert 42	DNF / DQ	pairs of glasses ▲ 84
731	Throw something into the bin behind the fence 301	Rhod Gilbert 42	03:17	time ▼ 2
736	Don’t blink 302	Rhod Gilbert 42	07:10	time ▲ 35
741	Beat on the drum after exactly 9.58 seconds 305	Rhod Gilbert 42	0.58	difference in seconds ▼ 5
746	Follow the clues and then do what they spell 308	Rhod Gilbert 42	12:51	time ▼ 2
751	Find the satsuma in a sock 314	Rhod Gilbert 42	02:31	time ▼ 2
756	Complete a 24-shot rally 315	Rhod Gilbert 42	DNF / DQ	time ▼ 2
761	Put on overalls and lie on the ground when the siren sounds 318	Rhod Gilbert 42	02:22	time ▼ 2
766	Find the hard-boiled egg 319	Rhod Gilbert 42	DNF / DQ	time ▼ 2
771	Tie yourself up as securely as possible 321	Rhod Gilbert 42	INCONCLUSIVE	time ▲ 35

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