taskmaster: measurements: 19 rows where contestant = 50

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.

19 rows where contestant = 50

descending

id ▲	task	contestant	measurement	objective
899	Hide three aubergines from Alex 380	Jo Brand 50	07:38	time ▲ 35
904	Arrange the lollies in rainbow order 381	Jo Brand 50	1	correct lollies ▲ 94
909	Identify which bin Alex is in 385	Jo Brand 50	DNF / DQ	time ▼ 2
914	Say the word ‘demeaning’ 387	Jo Brand 50	36:26	time ▼ 2
919	Arrange the playdough balls / Do the correct things with the balls 388	Jo Brand 50	23	correct balls ▲ 95
924	Surprise memory test 390	Jo Brand 50	1	remembered items ▲ 96
929	Score a goal with a steamroller 392	Jo Brand 50	08:00	time ▼ 2
934	Fill a glass with water 394	Jo Brand 50	0	parts water minus other ▲ 97
939	Fill a tray with things beginning with a letter you chose 398	Jo Brand 50	136	correct-initialed things ▲ 98
944	Lasso Alex 401	Jo Brand 50	01:20	time ▼ 2
949	Get to know a person who alternately tells the truth, lies, and brags 403	Jo Brand 50	1.5	correct answers ▲ 32
954	Build a tower behind you using a mirror and litter pickers 404	Jo Brand 50	1	bricks ▲ 99
959	Push a watermelon up a slide using breadsticks 407	Jo Brand 50	DNF / DQ	time ▼ 2
964	Throw eggs into metal receptacles 411	Jo Brand 50	2	points ▲ 91
969	Find and put the gold rings on the stick 413	Jo Brand 50	2	gold rings ▲ 100
974	Horse or laminator? 414	Jo Brand 50	13	correct answers ▲ 32
979	Throw something into a pedal bin 416	Jo Brand 50	2.6	meters ▲ 4
984	Inflate, tie, and pop the most balloons 422	Jo Brand 50	DNF / DQ	balloons ▲ 101
989	Complete the seven tasks in any order 428	Jo Brand 50	DNF / DQ	time ▼ 2

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