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.

23 rows where contestant = 82

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
1478 Find all ten ducks in the lab 599 Sophie Duker 82 4 ducks ▲ 70
1483 Tie a ribbon round the maypole or hit it with a ping pong ball 604 Sophie Duker 82
31.08
time ▼ 2
1488 Score an exercise ball hat-trick using a buggy 606 Sophie Duker 82
15:02
time ▼ 2
1493 Make all the things happen at the same time 610 Sophie Duker 82
DNF / DQ
time ▼ 2
1498 Enable Alex to bite his duck 611 Sophie Duker 82
02:13
time ▼ 2
1503 Face leg or other leg? 612 Sophie Duker 82 3 deceptions ▲ 64
1508 Guess Shoe 614 Sophie Duker 82 30 questions ▼ 132
1513 Make a stirring speech out of the bunting 616 Sophie Duker 82 51 characters ▲ 133
1520 Raise the water level to the top of the fish tank 622 Sophie Duker 82
DNF / DQ
millimeters ▼ 135
1525 Answer Alex's phone call 623 Sophie Duker 82
19:05
time ▼ 2
1530 Record a high number on a pedometer 627 Sophie Duker 82 1209 steps ▲ 58
1534 Display your vocal range 630 Sophie Duker 82 20 hertz ▼ 136
1535 Display your vocal range 630 Sophie Duker 82 45 hertz ▲ 137
1536 Display your vocal range 630 Sophie Duker 82 25 note range ▲ 138
1541 Deliver a cocktail to Greg 633 Sophie Duker 82
04:30
time ▼ 2
1550 Eat your beautiful sculpture 635 Sophie Duker 82 150 grams ▲ 1
1551 Eat your beautiful sculpture 635 Sophie Duker 82
03:00
time ▼ 2
1556 Poke your tongue out for the longest time 639 Sophie Duker 82
26:20
time ▲ 35
1561 Write down things that fit the category 641 Sophie Duker 82 1 points ▲ 91
1566 Make the longest cup snake 644 Sophie Duker 82 8.77 meters ▲ 4
1571 Predict how many cans you can fit in a bag 646 Sophie Duker 82
DNF / DQ
tin cans ▲ 139
1576 Identify the liquids 648 Sophie Duker 82 4 identified liquids ▲ 140
1581 Get the most ducks in Alex's basket 649 Sophie Duker 82 61 basketed ducks ▲ 141

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