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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
1477 Find all ten ducks in the lab 599 Judi Love 81 6 ducks ▲ 70
1482 Tie a ribbon round the maypole or hit it with a ping pong ball 604 Judi Love 81
04:15
time ▼ 2
1487 Score an exercise ball hat-trick using a buggy 606 Judi Love 81
15:02
time ▼ 2
1492 Make all the things happen at the same time 610 Judi Love 81
DNF / DQ
time ▼ 2
1497 Enable Alex to bite his duck 611 Judi Love 81
03:15
time ▼ 2
1502 Face leg or other leg? 612 Judi Love 81 3 deceptions ▲ 64
1507 Guess Shoe 614 Judi Love 81 24 questions ▼ 132
1512 Make a stirring speech out of the bunting 616 Judi Love 81 61 characters ▲ 133
1519 Raise the water level to the top of the fish tank 622 Judi Love 81 1.8 millimeters ▼ 135
1524 Answer Alex's phone call 623 Judi Love 81
INCONCLUSIVE
time ▼ 2
1529 Record a high number on a pedometer 627 Judi Love 81 483 steps ▲ 58
1540 Deliver a cocktail to Greg 633 Judi Love 81
04:30
time ▼ 2
1548 Eat your beautiful sculpture 635 Judi Love 81 150 grams ▲ 1
1549 Eat your beautiful sculpture 635 Judi Love 81
01:50
time ▼ 2
1555 Poke your tongue out for the longest time 639 Judi Love 81
05:00
time ▲ 35
1560 Write down things that fit the category 641 Judi Love 81 1 points ▲ 91
1565 Make the longest cup snake 644 Judi Love 81 11.21 meters ▲ 4
1570 Predict how many cans you can fit in a bag 646 Judi Love 81
DNF / DQ
tin cans ▲ 139
1575 Identify the liquids 648 Judi Love 81 3 identified liquids ▲ 140
1580 Get the most ducks in Alex's basket 649 Judi Love 81
DNF / DQ
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.057ms