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.

15 rows where contestant = 17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: measurement, objective

id ▲ task contestant measurement objective
185 Reach the microwave in the fewest steps 67 Sara Pascoe 17 27 steps ▼ 25
190 Propel a pea along a red carpet 68 Sara Pascoe 17 18.27 meters ▲ 4
195 Balance swedes on a Swede 70 Sara Pascoe 17 8 balanced swedes ▲ 26
200 The heaviest shoebox-sized item 71 Sara Pascoe 17
INCONCLUSIVE
kilograms ▲ 27
205 Release Alex 73 Sara Pascoe 17
16:46
time ▼ 2
210 Burst all of the balloons 75 Sara Pascoe 17
01:58
time ▼ 2
215 Unravel the tape 76 Sara Pascoe 17
01:46
time ▼ 2
220 Fill an eggcup with sweat 78 Sara Pascoe 17 8 sweatdrops ▲ 28
225 Anchor balloons using bread 82 Sara Pascoe 17 10 anchored balloons ▲ 29
230 Spread your clothes far and wide 84 Sara Pascoe 17 0.02 square miles ▲ 30
235 Find out the lying old man’s occupation 85 Sara Pascoe 17
08:31
time ▼ 2
240 Cover yourself in sticky notes 87 Sara Pascoe 17 33 sticky notes ▲ 31
245 Move water from one bucket to another 90 Sara Pascoe 17 0.8 centimeters ▲ 10
250 Play charades across a river 91 Sara Pascoe 17 7 correct answers ▲ 32
255 The lowest unique number of doughnuts 93 Sara Pascoe 17 3 doughnuts ▼ 33

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.945ms