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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
1474 Find all ten ducks in the lab 599 Ardal O'Hanlon 78 2 ducks ▲ 70
1479 Tie a ribbon round the maypole or hit it with a ping pong ball 604 Ardal O'Hanlon 78
02:10
time ▼ 2
1484 Score an exercise ball hat-trick using a buggy 606 Ardal O'Hanlon 78
08:38
time ▼ 2
1489 Make all the things happen at the same time 610 Ardal O'Hanlon 78
DNF / DQ
time ▼ 2
1494 Enable Alex to bite his duck 611 Ardal O'Hanlon 78
14:37
time ▼ 2
1499 Face leg or other leg? 612 Ardal O'Hanlon 78 1 deceptions ▲ 64
1504 Guess Shoe 614 Ardal O'Hanlon 78 40 questions ▼ 132
1509 Make a stirring speech out of the bunting 616 Ardal O'Hanlon 78 36 characters ▲ 133
1514 Turn over the most beer mats 618 Ardal O'Hanlon 78 64 beer mats ▲ 134
1516 Raise the water level to the top of the fish tank 622 Ardal O'Hanlon 78
INCONCLUSIVE
millimeters ▼ 135
1521 Answer Alex's phone call 623 Ardal O'Hanlon 78
10:12
time ▼ 2
1526 Record a high number on a pedometer 627 Ardal O'Hanlon 78 1084 steps ▲ 58
1537 Deliver a cocktail to Greg 633 Ardal O'Hanlon 78
13:27
time ▼ 2
1542 Eat your beautiful sculpture 635 Ardal O'Hanlon 78 40 grams ▲ 1
1543 Eat your beautiful sculpture 635 Ardal O'Hanlon 78
03:10
time ▼ 2
1552 Poke your tongue out for the longest time 639 Ardal O'Hanlon 78
06:40
time ▲ 35
1557 Write down things that fit the category 641 Ardal O'Hanlon 78 3 points ▲ 91
1562 Make the longest cup snake 644 Ardal O'Hanlon 78 8.56 meters ▲ 4
1567 Predict how many cans you can fit in a bag 646 Ardal O'Hanlon 78 35 tin cans ▲ 139
1572 Identify the liquids 648 Ardal O'Hanlon 78 3 identified liquids ▲ 140
1577 Get the most ducks in Alex's basket 649 Ardal O'Hanlon 78 48 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 11.627ms