taskmaster: measurements: 15 rows where contestant = 12

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.

15 rows where contestant = 12

descending

id ▲	task	contestant	measurement	objective
109	Place the exercise balls on the yoga mat 39	Richard Osman 12	INCONCLUSIVE	time ▼ 2
114	Get the potato into the hole 40	Richard Osman 12	02:13	time ▼ 2
123	Find out about the Swedish person 41	Richard Osman 12	17:00	time ▼ 2
124	Find out about the Swedish person 41	Richard Osman 12	6	Fred facts ▲ 17
129	Pack a suitcase 42	Richard Osman 12	01:18	time ▼ 2
134	Quickly eat an egg 44	Richard Osman 12	INCONCLUSIVE	time ▼ 2
139	Order a pizza without using certain words 47	Richard Osman 12	0	mistakes ▼ 18
144	Put potatoes in a basket 48	Richard Osman 12	DNF / DQ	potatoes ▲ 19
149	Impress the Mayor 50	Richard Osman 12	8	mayor's rating ▲ 20
154	See no potato, hear no potato, speak no potato 53	Richard Osman 12	04:59	time ▼ 2
159	Throw rabbits into a hat 54	Richard Osman 12	7	behatted rabbits ▲ 21
164	Conceal a pineapple on your person 57	Richard Osman 12	8	wrong guesses ▲ 22
170	Move items across a stream 62	Richard Osman 12	01:59	time ▼ 2
175	Build a bridge for the potato 64	Richard Osman 12	8	centimeters ▲ 10
180	Put on gloves, eat a banana, put on a tie, and clap 65	Richard Osman 12	249	claps ▲ 24

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