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.

25 rows where contestant = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
648 Make the best quick-change outfit 266 James Acaster 38
5
time ▼ 2
653 Build the tallest cardboard box tower 267 James Acaster 38 50 centimeters ▲ 10
658 Work out the perimeter of the caravan in beans 268 James Acaster 38 265 difference in baked beans ▼ 76
663 Write a ten word story while running 271 James Acaster 38
20
time ▼ 2
668 Build a tower of cans within a hoop 275 James Acaster 38 1 cans ▲ 48
675 Raise Alex’s heart rate 278 James Acaster 38 80 beats per minute ▲ 78
680 Get the ball into the hole by striking it 280 James Acaster 38 6 strokes ▼ 79
685 Silently mouth a ten word fact to Greg 281 James Acaster 38 9 understood words ▲ 80
690 Work out what the switch does 283 James Acaster 38
05:35
time ▼ 2
695 Make the scales read exactly 31.770kg 285 James Acaster 38
05:44
time ▼ 2
700 Get dressed while wearing handcuffs 286 James Acaster 38 5 correctly donned items ▲ 81
705 Make the best toilet paper plane 287 James Acaster 38 3.9 meters ▲ 4
707 Make the most white circles on the target 290 James Acaster 38 13 white circles ▲ 82
712 Put 50 different things in the bin 295 James Acaster 38
58
time ▼ 2
717 Place 10 pairs of glasses into the smallest box 298 James Acaster 38 3 box size ▼ 83
718 Place 10 pairs of glasses into the smallest box 298 James Acaster 38 6 pairs of glasses ▲ 84
727 Throw something into the bin behind the fence 301 James Acaster 38
19:10
time ▼ 2
732 Don’t blink 302 James Acaster 38
12.4
time ▲ 35
737 Beat on the drum after exactly 9.58 seconds 305 James Acaster 38 1.6 difference in seconds ▼ 5
742 Follow the clues and then do what they spell 308 James Acaster 38
03:48
time ▼ 2
747 Find the satsuma in a sock 314 James Acaster 38
09:34
time ▼ 2
752 Complete a 24-shot rally 315 James Acaster 38
DNF / DQ
time ▼ 2
757 Put on overalls and lie on the ground when the siren sounds 318 James Acaster 38
02:46
time ▼ 2
762 Find the hard-boiled egg 319 James Acaster 38
04:51
time ▼ 2
767 Tie yourself up as securely as possible 321 James Acaster 38
08:05
time ▲ 35

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 10.171ms