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.

27 rows where contestant = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
260 Fell all the ducks 97 Noel Fielding 22
04:50
time ▼ 2
265 Make the most fruit juice 98 Noel Fielding 22 2 milliliters ▲ 34
270 Keep the basketball on the treadmill 100 Noel Fielding 22
3.75
time ▲ 35
275 Get the flour onto the target 102 Noel Fielding 22 217 grams ▲ 1
284 Put an egg in an egg cup without touching either 103 Noel Fielding 22 3 penalties ▼ 36
285 Put an egg in an egg cup without touching either 103 Noel Fielding 22
03:02.5
time ▼ 2
290 Make the longest balloon chain 104 Noel Fielding 22 4 chained balloons ▲ 37
295 Persuade three animals to stand on the mat 108 Noel Fielding 22
06:28
time ▼ 2
300 Transfer water from one fishbowl to another 109 Noel Fielding 22 115 milliliters ▲ 34
302 Decant wine from one bottle to another 111 Noel Fielding 22 16 milliliters ▲ 34
307 Make the highest splash 113 Noel Fielding 22 5.1 meters ▲ 4
312 Make the tallest tube tower 117 Noel Fielding 22 2 tubes ▲ 38
317 Slide as far as possible 119 Noel Fielding 22 14 meters ▲ 4
326 Don the diving gear while maintaining eye contact and small talk 120 Noel Fielding 22
DNF / DQ
penalties ▼ 36
327 Don the diving gear while maintaining eye contact and small talk 120 Noel Fielding 22
DNF / DQ
time ▼ 2
332 Make the longest continuous noise 123 Noel Fielding 22
4.4
time ▲ 35
339 Pass a camel through a small gap 126 Noel Fielding 22 4 centimeters ▼ 40
348 Score a goal with a shopping bag 127 Noel Fielding 22 42 kicks ▼ 41
349 Score a goal with a shopping bag 127 Noel Fielding 22
10:42
time ▼ 2
354 Identify the contents of the sleeping bag 131 Noel Fielding 22 2 identified items ▲ 42
363 Cross the bunting to give Alex his lunch 134 Noel Fielding 22 1 penalties ▼ 36
364 Cross the bunting to give Alex his lunch 134 Noel Fielding 22
51.1
time ▼ 2
369 Hide from Alex 135 Noel Fielding 22
16
time ▲ 35
374 Wheelie bin obstacle course 136 Noel Fielding 22
06:03
time ▼ 2
382 The most cash 140 Noel Fielding 22
INCONCLUSIVE
£ ▲ 43
387 Strike an item the farthest 143 Noel Fielding 22 29 meters ▲ 4
392 Draw the median duck 145 Noel Fielding 22 13.5 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 9.887ms