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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
257 Fell all the ducks 97 Joe Lycett 19
01:56
time ▼ 2
262 Make the most fruit juice 98 Joe Lycett 19 3 milliliters ▲ 34
267 Keep the basketball on the treadmill 100 Joe Lycett 19
3.8
time ▲ 35
272 Get the flour onto the target 102 Joe Lycett 19 217 grams ▲ 1
278 Put an egg in an egg cup without touching either 103 Joe Lycett 19 3 penalties ▼ 36
279 Put an egg in an egg cup without touching either 103 Joe Lycett 19
03:02.8
time ▼ 2
287 Make the longest balloon chain 104 Joe Lycett 19 3 chained balloons ▲ 37
292 Persuade three animals to stand on the mat 108 Joe Lycett 19
44.6
time ▼ 2
297 Transfer water from one fishbowl to another 109 Joe Lycett 19 4850 milliliters ▲ 34
301 Decant wine from one bottle to another 111 Joe Lycett 19 79 milliliters ▲ 34
304 Make the highest splash 113 Joe Lycett 19 1.8796 meters ▲ 4
309 Make the tallest tube tower 117 Joe Lycett 19 2 tubes ▲ 38
314 Slide as far as possible 119 Joe Lycett 19 5.8 meters ▲ 4
320 Don the diving gear while maintaining eye contact and small talk 120 Joe Lycett 19 42 penalties ▼ 36
321 Don the diving gear while maintaining eye contact and small talk 120 Joe Lycett 19
06:32
time ▼ 2
329 Make the longest continuous noise 123 Joe Lycett 19
32
time ▲ 35
336 Pass a camel through a small gap 126 Joe Lycett 19 4.6 centimeters ▼ 40
342 Score a goal with a shopping bag 127 Joe Lycett 19 77 kicks ▼ 41
343 Score a goal with a shopping bag 127 Joe Lycett 19
08:09
time ▼ 2
351 Identify the contents of the sleeping bag 131 Joe Lycett 19 2 identified items ▲ 42
357 Cross the bunting to give Alex his lunch 134 Joe Lycett 19 4 penalties ▼ 36
358 Cross the bunting to give Alex his lunch 134 Joe Lycett 19
02:01
time ▼ 2
366 Hide from Alex 135 Joe Lycett 19
01:09
time ▲ 35
371 Wheelie bin obstacle course 136 Joe Lycett 19
06:03
time ▼ 2
376 Open the jar of mayonnaise 139 Joe Lycett 19
0
time ▼ 2
379 The most cash 140 Joe Lycett 19 250 £ ▲ 43
384 Strike an item the farthest 143 Joe Lycett 19 18.45 meters ▲ 4
389 Draw the median duck 145 Joe Lycett 19
INCONCLUSIVE
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 8.818ms