taskmaster: measurements: 28 rows where contestant = 90

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.

28 rows where contestant = 90

descending

id ▲	task	contestant	measurement	objective
1594	What ten films are you in? 659	John Kearns 90	4	named films ▲ 142
1599	Land loo roll in the toilet 660	John Kearns 90	DNF / DQ	sheets ▲ 143
1604	Don't pop the balloon 662	John Kearns 90	1461	grams ▲ 1
1609	Print, laminate, and distribute the most signs 664	John Kearns 90	7	signs ▲ 144
1614	Obey all your signs 665	John Kearns 90	42.9	% signs obeyed ▲ 145
1619	Put five grapes in the little bowl 666	John Kearns 90	2000	grams ▲ 1
1628	Sort the ducks and the socks 667	John Kearns 90	1	ducks ▲ 70
1629	Sort the ducks and the socks 667	John Kearns 90	9	socks ▲ 146
1630	Sort the ducks and the socks 667	John Kearns 90	10	ducks and socks ▲ 147
1639	Make the Taskmaster say your words 668	John Kearns 90	3	round wins ▲ 105
1644	Put the most sand in the shopping trolley 670	John Kearns 90	20.9	kilograms ▲ 27
1649	Identify the ice cream flavours 671	John Kearns 90	3	guessed flavors ▲ 65
1654	Turn on the bubble machine 675	John Kearns 90	10:45	time ▼ 2
1659	Luggage trolley bowling 682	John Kearns 90	34	meters ▲ 4
1664	Communicate animals by saying letters and doing impressions 683	John Kearns 90	7	identified animals ▲ 148
1669	Hold the milk bottles above the microwaves 685	John Kearns 90	23:30	time ▼ 2
1674	Reach the end of two lanes in the same amount of time 686	John Kearns 90	0.5	difference in seconds ▼ 5
1679	Strike the bullseye with your paint 687	John Kearns 90	DNF / DQ	time ▼ 2
1684	Pop 99 red balloons 690	John Kearns 90	02:29	time ▼ 2
1689	Get this feather into the bath 691	John Kearns 90	07:45	time ▼ 2
1694	Hit Bernard with an exercise ball 692	John Kearns 90	12	involved balls ▲ 149
1699	Communicate an instruction in a secret language 695	John Kearns 90	DNF / DQ	time ▼ 2
1704	Pin an alluring tail on the alluring animal 696	John Kearns 90	08:12	time ▼ 2
1709	Find the back of your hand 697	John Kearns 90	DNF / DQ	wrong guesses ▼ 150
1714	Guess the length of the extendible item 698	John Kearns 90	2	round wins ▲ 105
1719	Snort, raspberry, whistle 700	John Kearns 90	0	completed cycles ▲ 151
1724	Eat the grape 707	John Kearns 90	20:20	time ▼ 2
1729	Throw an object, hide an object, and place it on the barrel 709	John Kearns 90	04:48	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)
);