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.

20 rows where contestant = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: measurement, objective

id ▲ task contestant measurement objective
393 Get Alex to dry land 148 Aisling Bea 23
08:22
time ▼ 2
398 Score a basket without your hands 149 Aisling Bea 23
03:08
time ▼ 2
403 Get some fruit into the bowl 150 Aisling Bea 23
DNF / DQ
time ▼ 2
408 Make a coconut-flinging machine 152 Aisling Bea 23 4.4 meters ▲ 4
413 Retrieve the table tennis ball from the tube 158 Aisling Bea 23
DNF / DQ
time ▼ 2
418 Eat one item, balance one item, throw one item 160 Aisling Bea 23
04:30
time ▼ 2
423 Blow up a balloon to the size of a cucumber 165 Aisling Bea 23 19 difference in centimeters ▼ 45
428 Spot the difference 166 Aisling Bea 23 5 spotted differences ▲ 46
433 Sneeze the fastest 167 Aisling Bea 23
DNF / DQ
time ▼ 2
438 Backthrow a picture of a Swede into a bin 169 Aisling Bea 23 66 attempts ▼ 47
440 Build a can tower & greet Alex from different countries 174 Aisling Bea 23 1 cans ▲ 48
445 Identify the Finns 175 Aisling Bea 23 1 identified Finns minus non-Finns ▲ 49
450 Balance Alex on a see-saw 177 Aisling Bea 23
INCONCLUSIVE
kilograms ▲ 27
455 Light a candle using a cupcake 180 Aisling Bea 23
DNF / DQ
time ▼ 2
462 Travel blindfolded for three minutes and retrace your steps 184 Aisling Bea 23 64 meters off target ▼ 51
467 Coconut bobsleigh 185 Aisling Bea 23 14 team members ▲ 52
472 Vote for who should receive five points 186 Aisling Bea 23 0 votes ▲ 53
477 Zipwire items to the Taskmaster 188 Aisling Bea 23 2 zip-lined items ▲ 54
482 Transport a coconut as far as possible 190 Aisling Bea 23
INCONCLUSIVE
meters ▲ 4
489 Throw an egg through a basketball hoop 194 Aisling Bea 23 0 caught makes ▲ 56

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