taskmaster: measurements: 24 rows where contestant = 41

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.

24 rows where contestant = 41

descending

id ▲	task	contestant	measurement	objective
651	Make the best quick-change outfit 266	Phil Wang 41	45	time ▼ 2
656	Build the tallest cardboard box tower 267	Phil Wang 41	75	centimeters ▲ 10
661	Work out the perimeter of the caravan in beans 268	Phil Wang 41	565	difference in baked beans ▼ 76
666	Write a ten word story while running 271	Phil Wang 41	02:16	time ▼ 2
671	Build a tower of cans within a hoop 275	Phil Wang 41	3	cans ▲ 48
678	Raise Alex’s heart rate 278	Phil Wang 41	-6	beats per minute ▲ 78
683	Get the ball into the hole by striking it 280	Phil Wang 41	5	strokes ▼ 79
688	Silently mouth a ten word fact to Greg 281	Phil Wang 41	4	understood words ▲ 80
693	Work out what the switch does 283	Phil Wang 41	10:50	time ▼ 2
698	Make the scales read exactly 31.770kg 285	Phil Wang 41	08:28	time ▼ 2
703	Get dressed while wearing handcuffs 286	Phil Wang 41	1	correctly donned items ▲ 81
710	Make the most white circles on the target 290	Phil Wang 41	38	white circles ▲ 82
715	Put 50 different things in the bin 295	Phil Wang 41	06:57	time ▼ 2
723	Place 10 pairs of glasses into the smallest box 298	Phil Wang 41	6	box size ▼ 83
724	Place 10 pairs of glasses into the smallest box 298	Phil Wang 41	10	pairs of glasses ▲ 84
730	Throw something into the bin behind the fence 301	Phil Wang 41	07:19	time ▼ 2
735	Don’t blink 302	Phil Wang 41	12	time ▲ 35
740	Beat on the drum after exactly 9.58 seconds 305	Phil Wang 41	3.48	difference in seconds ▼ 5
745	Follow the clues and then do what they spell 308	Phil Wang 41	09:55	time ▼ 2
750	Find the satsuma in a sock 314	Phil Wang 41	DNF / DQ	time ▼ 2
755	Complete a 24-shot rally 315	Phil Wang 41	DNF / DQ	time ▼ 2
760	Put on overalls and lie on the ground when the siren sounds 318	Phil Wang 41	01:14	time ▼ 2
765	Find the hard-boiled egg 319	Phil Wang 41	DNF / DQ	time ▼ 2
770	Tie yourself up as securely as possible 321	Phil Wang 41	01:00	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)
);