TdlM / taskmaster

Menu
  • Make shortlink

measurements

Table actions
  • Toggle column notes
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 = 18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
256 Fell all the ducks 97 Hugh Dennis 18
8.9
time ▼ 2
261 Make the most fruit juice 98 Hugh Dennis 18 4 milliliters ▲ 34
266 Keep the basketball on the treadmill 100 Hugh Dennis 18
120:00:00:00
time ▲ 35
271 Get the flour onto the target 102 Hugh Dennis 18 193 grams ▲ 1
276 Put an egg in an egg cup without touching either 103 Hugh Dennis 18 4 penalties ▼ 36
277 Put an egg in an egg cup without touching either 103 Hugh Dennis 18
05:40
time ▼ 2
286 Make the longest balloon chain 104 Hugh Dennis 18 6 chained balloons ▲ 37
291 Persuade three animals to stand on the mat 108 Hugh Dennis 18
06:51
time ▼ 2
296 Transfer water from one fishbowl to another 109 Hugh Dennis 18
INCONCLUSIVE
milliliters ▲ 34
303 Make the highest splash 113 Hugh Dennis 18 0.4572 meters ▲ 4
308 Make the tallest tube tower 117 Hugh Dennis 18 3 tubes ▲ 38
313 Slide as far as possible 119 Hugh Dennis 18 18.9 meters ▲ 4
318 Don the diving gear while maintaining eye contact and small talk 120 Hugh Dennis 18 60 penalties ▼ 36
319 Don the diving gear while maintaining eye contact and small talk 120 Hugh Dennis 18
06:45
time ▼ 2
328 Make the longest continuous noise 123 Hugh Dennis 18
30
time ▲ 35
333 Eat as many peas as possible 124 Hugh Dennis 18 199 peas ▲ 39
335 Pass a camel through a small gap 126 Hugh Dennis 18 0.9 centimeters ▼ 40
340 Score a goal with a shopping bag 127 Hugh Dennis 18 0 kicks ▼ 41
341 Score a goal with a shopping bag 127 Hugh Dennis 18
01:51
time ▼ 2
350 Identify the contents of the sleeping bag 131 Hugh Dennis 18
DNF / DQ
identified items ▲ 42
355 Cross the bunting to give Alex his lunch 134 Hugh Dennis 18 0 penalties ▼ 36
356 Cross the bunting to give Alex his lunch 134 Hugh Dennis 18
01:48
time ▼ 2
365 Hide from Alex 135 Hugh Dennis 18
01:09
time ▲ 35
370 Wheelie bin obstacle course 136 Hugh Dennis 18
06:39
time ▼ 2
375 Open the jar of mayonnaise 139 Hugh Dennis 18
INCONCLUSIVE
time ▼ 2
378 The most cash 140 Hugh Dennis 18 72.2 £ ▲ 43
383 Strike an item the farthest 143 Hugh Dennis 18 24 meters ▲ 4
388 Draw the median duck 145 Hugh Dennis 18 21 inches ◀ 44

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE measurements (
   id          INTEGER PRIMARY KEY,
   task        INTEGER REFERENCES tasks(id),
   contestant  INTEGER REFERENCES people(id),
   measurement REAL,
   objective   INTEGER REFERENCES objectives(id)
);
Powered by Datasette · Queries took 13.723ms