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.

30 rows where contestant = 103

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
1882 Build a tower of cans in the lab 768 Julian Clary 103 17 cans ▲ 48
1887 Cross the finish line while connected to your team 769 Julian Clary 103
11.5
time ▼ 2
1892 Get the duck into the lake 770 Julian Clary 103
DNF / DQ
time ▼ 2
1893 Get the duck into the lake 770 Julian Clary 103
DNF / DQ
penalties ▼ 36
1902 Heavier or lighter? 771 Julian Clary 103 1 correct answers ▲ 32
1907 Pull the sword from the stone 773 Julian Clary 103
10:23
time ▼ 2
1914 Get the ball in the hole without touching it 779 Julian Clary 103
03:25
time ▼ 2
1919 Get underneath the most unique things 780 Julian Clary 103 25 things ▲ 171
1920 Get underneath the most unique things 780 Julian Clary 103 6 penalties ▼ 36
1921 Get underneath the most unique things 780 Julian Clary 103 -5 points ▲ 91
1934 Human war boats 782 Julian Clary 103 3 hits ▲ 172
1939 Complete all the tasks as a team 785 Julian Clary 103
06:48
time ▼ 2
1944 Roll your animal die 787 Julian Clary 103 0 rounds survived ▲ 173
1951 Burst the balloon without looking at it 790 Julian Clary 103 292 aspirins ▲ 174
1956 Get all of the water into the vase 792 Julian Clary 103
DNF / DQ
time ▼ 2
1961 Retrieve and sip your drink 793 Julian Clary 103 13 points ▲ 91
1966 Avoid the rubbish robots 795 Julian Clary 103
2.5
time ▲ 35
1971 Recreate the garage scene in the lab 796 Julian Clary 103 27 forbidden words ▼ 175
1972 Recreate the garage scene in the lab 796 Julian Clary 103 7 pretty much right things ▲ 176
1981 Pineapple bluff 798 Julian Clary 103 0 points ▲ 91
1986 Play with these switches / Balance the most golf tees 800 Julian Clary 103
DNF / DQ
balanced tees ▲ 177
1991 Pie the air dancer in the face 801 Julian Clary 103
03:32
time ▼ 2
1996 Place your cardboard replica within the boundary 802 Julian Clary 103 7.55 meters ▲ 4
2003 Find the secret task 806 Julian Clary 103
06:30
time ▼ 2
2008 Complete the fortune trail 807 Julian Clary 103
04:12
time ▼ 2
2013 Mime proverbs to your team 809 Julian Clary 103 5 identified proverbs ▲ 178
2018 Obey all of the traffic signals 811 Julian Clary 103
DNF / DQ
time ▼ 2
2023 Feed the clown the most cards 813 Julian Clary 103 51 cards ▲ 179
2028 Pass the parade exam 814 Julian Clary 103 2 correct answers ▲ 32
2033 Throw a ball into the bathtub 819 Julian Clary 103 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 9.214ms