taskmaster: measurements: 21 rows where contestant = 3

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.

21 rows where contestant = 3

descending

id ▲	task	contestant	measurement	objective
1	Eat as much watermelon as possible 2	Frank Skinner 3	179	grams ▲ 1
6	Empty the bathtub 4	Frank Skinner 3	07:42	time ▼ 2
11	Find Alex 6	Frank Skinner 3	01:50	time ▼ 2
13	High-five a 55-year-old 8	Frank Skinner 3	12:44	time ▼ 2
18	Identify the contents of the pies 9	Frank Skinner 3	1	pies ▲ 3
23	Throw a teabag into a mug 13	Frank Skinner 3	10.04	meters ▲ 4
28	Get an egg as high as possible 16	Frank Skinner 3	DNF / DQ	meters ▲ 4
33	Stand up after 100 seconds 17	Frank Skinner 3	INCONCLUSIVE	difference in seconds ▼ 5
40	Make a block of ice disappear 20	Frank Skinner 3	27:28	time ▼ 2
45	Score 11 points 23	Frank Skinner 3	18:01	time ▼ 2
50	Fill an eggcup with tears 24	Frank Skinner 3	12	tears ▲ 7
55	Memorise an Australian Rules Football team 26	Frank Skinner 3	1	names ▲ 8
60	Move the boulder as far as possible 28	Frank Skinner 3	6.5	miles ▲ 9
65	Grow the longest nail 29	Frank Skinner 3	2.1	centimeters ▲ 10
70	Make a bed while holding hands 30	Frank Skinner 3	10:57	time ▼ 2
75	Make a Swedish person blush 31	Frank Skinner 3	26	blush depth in ticks ▲ 11
80	Play mini golf with eggs 34	Frank Skinner 3	32	shots ▼ 12
81	Play mini golf with eggs 34	Frank Skinner 3	5	eggs ▼ 13
82	Play mini golf with eggs 34	Frank Skinner 3	6.85	minutes ▼ 14
83	Play mini golf with eggs 34	Frank Skinner 3	1096	points ▼ 15
100	Separate the blue sweets 37	Frank Skinner 3	11	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)
);