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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
1475 Find all ten ducks in the lab 599 Bridget Christie 79 4 ducks ▲ 70
1480 Tie a ribbon round the maypole or hit it with a ping pong ball 604 Bridget Christie 79
11:30
time ▼ 2
1485 Score an exercise ball hat-trick using a buggy 606 Bridget Christie 79
15:02
time ▼ 2
1490 Make all the things happen at the same time 610 Bridget Christie 79
INCONCLUSIVE
time ▼ 2
1495 Enable Alex to bite his duck 611 Bridget Christie 79
01:01
time ▼ 2
1500 Face leg or other leg? 612 Bridget Christie 79 3 deceptions ▲ 64
1505 Guess Shoe 614 Bridget Christie 79 161 questions ▼ 132
1510 Make a stirring speech out of the bunting 616 Bridget Christie 79 39 characters ▲ 133
1517 Raise the water level to the top of the fish tank 622 Bridget Christie 79
DNF / DQ
millimeters ▼ 135
1522 Answer Alex's phone call 623 Bridget Christie 79
23:01
time ▼ 2
1527 Record a high number on a pedometer 627 Bridget Christie 79 11 trillion gazillion steps ▲ 58
1538 Deliver a cocktail to Greg 633 Bridget Christie 79
04:30
time ▼ 2
1544 Eat your beautiful sculpture 635 Bridget Christie 79 8 grams ▲ 1
1545 Eat your beautiful sculpture 635 Bridget Christie 79
INCONCLUSIVE
time ▼ 2
1553 Poke your tongue out for the longest time 639 Bridget Christie 79
12:00
time ▲ 35
1558 Write down things that fit the category 641 Bridget Christie 79 1 points ▲ 91
1563 Make the longest cup snake 644 Bridget Christie 79 5 meters ▲ 4
1568 Predict how many cans you can fit in a bag 646 Bridget Christie 79
DNF / DQ
tin cans ▲ 139
1573 Identify the liquids 648 Bridget Christie 79 2 identified liquids ▲ 140
1578 Get the most ducks in Alex's basket 649 Bridget Christie 79
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 11.893ms