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 = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
258 Fell all the ducks 97 Lolly Adefope 20
01:02
time ▼ 2
263 Make the most fruit juice 98 Lolly Adefope 20 0.4 milliliters ▲ 34
268 Keep the basketball on the treadmill 100 Lolly Adefope 20
15.8
time ▲ 35
273 Get the flour onto the target 102 Lolly Adefope 20 217 grams ▲ 1
280 Put an egg in an egg cup without touching either 103 Lolly Adefope 20 1 penalties ▼ 36
281 Put an egg in an egg cup without touching either 103 Lolly Adefope 20
01:28
time ▼ 2
288 Make the longest balloon chain 104 Lolly Adefope 20 4 chained balloons ▲ 37
293 Persuade three animals to stand on the mat 108 Lolly Adefope 20
13:40
time ▼ 2
298 Transfer water from one fishbowl to another 109 Lolly Adefope 20
DNF / DQ
milliliters ▲ 34
305 Make the highest splash 113 Lolly Adefope 20 0 meters ▲ 4
310 Make the tallest tube tower 117 Lolly Adefope 20 2 tubes ▲ 38
315 Slide as far as possible 119 Lolly Adefope 20 3.2 meters ▲ 4
322 Don the diving gear while maintaining eye contact and small talk 120 Lolly Adefope 20 27 penalties ▼ 36
323 Don the diving gear while maintaining eye contact and small talk 120 Lolly Adefope 20
05:45
time ▼ 2
330 Make the longest continuous noise 123 Lolly Adefope 20
21
time ▲ 35
337 Pass a camel through a small gap 126 Lolly Adefope 20 3.1 centimeters ▼ 40
344 Score a goal with a shopping bag 127 Lolly Adefope 20 8 kicks ▼ 41
345 Score a goal with a shopping bag 127 Lolly Adefope 20
05:44
time ▼ 2
352 Identify the contents of the sleeping bag 131 Lolly Adefope 20 2 identified items ▲ 42
359 Cross the bunting to give Alex his lunch 134 Lolly Adefope 20 6 penalties ▼ 36
360 Cross the bunting to give Alex his lunch 134 Lolly Adefope 20
INCONCLUSIVE
time ▼ 2
367 Hide from Alex 135 Lolly Adefope 20
23:00
time ▲ 35
372 Wheelie bin obstacle course 136 Lolly Adefope 20
06:03
time ▼ 2
377 Open the jar of mayonnaise 139 Lolly Adefope 20
INCONCLUSIVE
time ▼ 2
380 The most cash 140 Lolly Adefope 20 2000 £ ▲ 43
385 Strike an item the farthest 143 Lolly Adefope 20 0.25 meters ▲ 4
390 Draw the median duck 145 Lolly Adefope 20 6 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 11.408ms