taskmaster: measurements: 20 rows where contestant = 5

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 = 5

descending

id ▲	task	contestant	measurement	objective
3	Eat as much watermelon as possible 2	Roisin Conaty 5	9	grams ▲ 1
8	Empty the bathtub 4	Roisin Conaty 5	09:30	time ▼ 2
15	High-five a 55-year-old 8	Roisin Conaty 5	06:12	time ▼ 2
20	Identify the contents of the pies 9	Roisin Conaty 5	1	pies ▲ 3
25	Throw a teabag into a mug 13	Roisin Conaty 5	2.4	meters ▲ 4
30	Get an egg as high as possible 16	Roisin Conaty 5	DNF / DQ	meters ▲ 4
35	Stand up after 100 seconds 17	Roisin Conaty 5	INCONCLUSIVE	difference in seconds ▼ 5
42	Make a block of ice disappear 20	Roisin Conaty 5	30:20	time ▼ 2
47	Score 11 points 23	Roisin Conaty 5	11:12	time ▼ 2
52	Fill an eggcup with tears 24	Roisin Conaty 5	0	tears ▲ 7
57	Memorise an Australian Rules Football team 26	Roisin Conaty 5	1	names ▲ 8
62	Move the boulder as far as possible 28	Roisin Conaty 5	0.17	miles ▲ 9
67	Grow the longest nail 29	Roisin Conaty 5	1.8	centimeters ▲ 10
72	Make a bed while holding hands 30	Roisin Conaty 5	16:03	time ▼ 2
77	Make a Swedish person blush 31	Roisin Conaty 5	46	blush depth in ticks ▲ 11
88	Play mini golf with eggs 34	Roisin Conaty 5	40	shots ▼ 12
89	Play mini golf with eggs 34	Roisin Conaty 5	6	eggs ▼ 13
90	Play mini golf with eggs 34	Roisin Conaty 5	4.167	minutes ▼ 14
91	Play mini golf with eggs 34	Roisin Conaty 5	1000	points ▼ 15
102	Separate the blue sweets 37	Roisin Conaty 5	-2143	blue sweets ▲ 16

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