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.

31 rows where contestant = 105

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
1884 Build a tower of cans in the lab 768 Sam Campbell 105 20 cans ▲ 48
1889 Cross the finish line while connected to your team 769 Sam Campbell 105
11.5
time ▼ 2
1896 Get the duck into the lake 770 Sam Campbell 105
11:20
time ▼ 2
1897 Get the duck into the lake 770 Sam Campbell 105 9 penalties ▼ 36
1904 Heavier or lighter? 771 Sam Campbell 105 1 correct answers ▲ 32
1909 Pull the sword from the stone 773 Sam Campbell 105
32:00
time ▼ 2
1916 Get the ball in the hole without touching it 779 Sam Campbell 105
03:31
time ▼ 2
1925 Get underneath the most unique things 780 Sam Campbell 105 74 things ▲ 171
1926 Get underneath the most unique things 780 Sam Campbell 105 5 penalties ▼ 36
1927 Get underneath the most unique things 780 Sam Campbell 105 49 points ▲ 91
1936 Human war boats 782 Sam Campbell 105 3 hits ▲ 172
1941 Complete all the tasks as a team 785 Sam Campbell 105
06:48
time ▼ 2
1946 Roll your animal die 787 Sam Campbell 105 4 rounds survived ▲ 173
1953 Burst the balloon without looking at it 790 Sam Campbell 105 564 aspirins ▲ 174
1958 Get all of the water into the vase 792 Sam Campbell 105
DNF / DQ
time ▼ 2
1963 Retrieve and sip your drink 793 Sam Campbell 105 10 points ▲ 91
1968 Avoid the rubbish robots 795 Sam Campbell 105
01:04
time ▲ 35
1975 Recreate the garage scene in the lab 796 Sam Campbell 105 27 forbidden words ▼ 175
1976 Recreate the garage scene in the lab 796 Sam Campbell 105 7 pretty much right things ▲ 176
1983 Pineapple bluff 798 Sam Campbell 105 1 points ▲ 91
1988 Play with these switches / Balance the most golf tees 800 Sam Campbell 105
DNF / DQ
balanced tees ▲ 177
1993 Pie the air dancer in the face 801 Sam Campbell 105
03:40
time ▼ 2
1998 Place your cardboard replica within the boundary 802 Sam Campbell 105 14.24 meters ▲ 4
2002 Pop your party popper the furthest 804 Sam Campbell 105 108 centimeters ▲ 10
2005 Find the secret task 806 Sam Campbell 105
08:50
time ▼ 2
2010 Complete the fortune trail 807 Sam Campbell 105
06:51
time ▼ 2
2015 Mime proverbs to your team 809 Sam Campbell 105 5 identified proverbs ▲ 178
2020 Obey all of the traffic signals 811 Sam Campbell 105
26:22
time ▼ 2
2025 Feed the clown the most cards 813 Sam Campbell 105
DNF / DQ
cards ▲ 179
2030 Pass the parade exam 814 Sam Campbell 105 1 correct answers ▲ 32
2035 Throw a ball into the bathtub 819 Sam Campbell 105 1 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.354ms