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.

21 rows where contestant = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: measurement, objective

id ▲ task contestant measurement objective
397 Get Alex to dry land 148 Sally Phillips 27
10:12
time ▼ 2
402 Score a basket without your hands 149 Sally Phillips 27
DNF / DQ
time ▼ 2
407 Get some fruit into the bowl 150 Sally Phillips 27
03:40
time ▼ 2
412 Make a coconut-flinging machine 152 Sally Phillips 27 5.5 meters ▲ 4
417 Retrieve the table tennis ball from the tube 158 Sally Phillips 27
12:45
time ▼ 2
422 Eat one item, balance one item, throw one item 160 Sally Phillips 27
02:01
time ▼ 2
427 Blow up a balloon to the size of a cucumber 165 Sally Phillips 27 20 difference in centimeters ▼ 45
432 Spot the difference 166 Sally Phillips 27 2 spotted differences ▲ 46
437 Sneeze the fastest 167 Sally Phillips 27
DNF / DQ
time ▼ 2
444 Build a can tower & greet Alex from different countries 174 Sally Phillips 27 2 cans ▲ 48
449 Identify the Finns 175 Sally Phillips 27 -1 identified Finns minus non-Finns ▲ 49
454 Balance Alex on a see-saw 177 Sally Phillips 27 20.16 kilograms ▲ 27
459 Light a candle using a cupcake 180 Sally Phillips 27
DNF / DQ
time ▼ 2
461 Kick yoghurt at a target 182 Sally Phillips 27 0 bull's-eyed yoghurt ▲ 50
466 Travel blindfolded for three minutes and retrace your steps 184 Sally Phillips 27 74 meters off target ▼ 51
471 Coconut bobsleigh 185 Sally Phillips 27
DNF / DQ
team members ▲ 52
476 Vote for who should receive five points 186 Sally Phillips 27 2 votes ▲ 53
481 Zipwire items to the Taskmaster 188 Sally Phillips 27 0 zip-lined items ▲ 54
486 Transport a coconut as far as possible 190 Sally Phillips 27 1770 meters ▲ 4
488 Make the most fish puns 192 Sally Phillips 27 8 fish puns ▲ 55
493 Throw an egg through a basketball hoop 194 Sally Phillips 27 0.9 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 9.169ms