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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: measurement, objective

id ▲ task contestant measurement objective
395 Get Alex to dry land 148 Mark Watson 25
17:45
time ▼ 2
400 Score a basket without your hands 149 Mark Watson 25
03:00
time ▼ 2
405 Get some fruit into the bowl 150 Mark Watson 25
12
time ▼ 2
410 Make a coconut-flinging machine 152 Mark Watson 25 18.9 meters ▲ 4
415 Retrieve the table tennis ball from the tube 158 Mark Watson 25
23:10
time ▼ 2
420 Eat one item, balance one item, throw one item 160 Mark Watson 25
04:20
time ▼ 2
425 Blow up a balloon to the size of a cucumber 165 Mark Watson 25 1.5 difference in centimeters ▼ 45
430 Spot the difference 166 Mark Watson 25 3 spotted differences ▲ 46
435 Sneeze the fastest 167 Mark Watson 25
2:00:00:00
time ▼ 2
439 Backthrow a picture of a Swede into a bin 169 Mark Watson 25 15 attempts ▼ 47
442 Build a can tower & greet Alex from different countries 174 Mark Watson 25 6 cans ▲ 48
447 Identify the Finns 175 Mark Watson 25 2 identified Finns minus non-Finns ▲ 49
452 Balance Alex on a see-saw 177 Mark Watson 25 7.2 kilograms ▲ 27
457 Light a candle using a cupcake 180 Mark Watson 25
DNF / DQ
time ▼ 2
464 Travel blindfolded for three minutes and retrace your steps 184 Mark Watson 25 140 meters off target ▼ 51
469 Coconut bobsleigh 185 Mark Watson 25 2 team members ▲ 52
474 Vote for who should receive five points 186 Mark Watson 25 1 votes ▲ 53
479 Zipwire items to the Taskmaster 188 Mark Watson 25 5 zip-lined items ▲ 54
484 Transport a coconut as far as possible 190 Mark Watson 25
DNF / DQ
meters ▲ 4
491 Throw an egg through a basketball hoop 194 Mark Watson 25 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 16.353ms