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.

32 rows where contestant = 106

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
1885 Build a tower of cans in the lab 768 Sue Perkins 106 1 cans ▲ 48
1890 Cross the finish line while connected to your team 769 Sue Perkins 106
01:30
time ▼ 2
1898 Get the duck into the lake 770 Sue Perkins 106
09:45
time ▼ 2
1899 Get the duck into the lake 770 Sue Perkins 106 0 penalties ▼ 36
1905 Heavier or lighter? 771 Sue Perkins 106 0 correct answers ▲ 32
1910 Pull the sword from the stone 773 Sue Perkins 106
33:21
time ▼ 2
1912 Recite pi 777 Sue Perkins 106 15 decimal places of π ▲ 170
1917 Get the ball in the hole without touching it 779 Sue Perkins 106
09:32
time ▼ 2
1928 Get underneath the most unique things 780 Sue Perkins 106 20 things ▲ 171
1929 Get underneath the most unique things 780 Sue Perkins 106 5 penalties ▼ 36
1930 Get underneath the most unique things 780 Sue Perkins 106 -5 points ▲ 91
1937 Human war boats 782 Sue Perkins 106 2 hits ▲ 172
1942 Complete all the tasks as a team 785 Sue Perkins 106
07:54
time ▼ 2
1947 Roll your animal die 787 Sue Perkins 106 2 rounds survived ▲ 173
1950 Tut the loudest 788 Sue Perkins 106 93.4 decibels ▲ 169
1954 Burst the balloon without looking at it 790 Sue Perkins 106 2459 aspirins ▲ 174
1959 Get all of the water into the vase 792 Sue Perkins 106
DNF / DQ
time ▼ 2
1964 Retrieve and sip your drink 793 Sue Perkins 106 0 points ▲ 91
1969 Avoid the rubbish robots 795 Sue Perkins 106
01:07
time ▲ 35
1977 Recreate the garage scene in the lab 796 Sue Perkins 106 9 forbidden words ▼ 175
1978 Recreate the garage scene in the lab 796 Sue Perkins 106 6 pretty much right things ▲ 176
1984 Pineapple bluff 798 Sue Perkins 106 2 points ▲ 91
1989 Play with these switches / Balance the most golf tees 800 Sue Perkins 106
DNF / DQ
balanced tees ▲ 177
1994 Pie the air dancer in the face 801 Sue Perkins 106
DNF / DQ
time ▼ 2
1999 Place your cardboard replica within the boundary 802 Sue Perkins 106 7.39 meters ▲ 4
2006 Find the secret task 806 Sue Perkins 106
16:05
time ▼ 2
2011 Complete the fortune trail 807 Sue Perkins 106
DNF / DQ
time ▼ 2
2016 Mime proverbs to your team 809 Sue Perkins 106 6 identified proverbs ▲ 178
2021 Obey all of the traffic signals 811 Sue Perkins 106
11:43
time ▼ 2
2026 Feed the clown the most cards 813 Sue Perkins 106
DNF / DQ
cards ▲ 179
2031 Pass the parade exam 814 Sue Perkins 106 3 correct answers ▲ 32
2036 Throw a ball into the bathtub 819 Sue Perkins 106 0 rounds survived ▲ 173

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