measurements

Table actions
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 objective = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, contestant, measurement

id ▲ task contestant measurement objective
33 Stand up after 100 seconds 17 Frank Skinner 3
INCONCLUSIVE
 difference in seconds ▼ 5
34 Stand up after 100 seconds 17 Josh Widdicombe 4 5 difference in seconds ▼ 5
35 Stand up after 100 seconds 17 Roisin Conaty 5
INCONCLUSIVE
 difference in seconds ▼ 5
36 Stand up after 100 seconds 17 Romesh Ranganathan 6 12 difference in seconds ▼ 5
37 Stand up after 100 seconds 17 Tim Key 7 12 difference in seconds ▼ 5
519 Return to the house wearing a hat 209 Alice Levine 33 90 difference in seconds ▼ 5
520 Return to the house wearing a hat 209 Asim Chaudhry 34 1260 difference in seconds ▼ 5
521 Return to the house wearing a hat 209 Liza Tarbuck 35 550 difference in seconds ▼ 5
522 Return to the house wearing a hat 209 Russell Howard 36 360 difference in seconds ▼ 5
523 Return to the house wearing a hat 209 Tim Vine 37 1160 difference in seconds ▼ 5
737 Beat on the drum after exactly 9.58 seconds 305 James Acaster 38 1.6 difference in seconds ▼ 5
738 Beat on the drum after exactly 9.58 seconds 305 Jessica Knappett 39 17.62 difference in seconds ▼ 5
739 Beat on the drum after exactly 9.58 seconds 305 Kerry Godliman 40 3.43 difference in seconds ▼ 5
740 Beat on the drum after exactly 9.58 seconds 305 Phil Wang 41 3.48 difference in seconds ▼ 5
741 Beat on the drum after exactly 9.58 seconds 305 Rhod Gilbert 42 0.58 difference in seconds ▼ 5
1672 Reach the end of two lanes in the same amount of time 686 Dara Ó Briain 88 4 difference in seconds ▼ 5
1673 Reach the end of two lanes in the same amount of time 686 Fern Brady 89 16 difference in seconds ▼ 5
1674 Reach the end of two lanes in the same amount of time 686 John Kearns 90 0.5 difference in seconds ▼ 5
1675 Reach the end of two lanes in the same amount of time 686 Munya Chawawa 91 3 difference in seconds ▼ 5
1676 Reach the end of two lanes in the same amount of time 686 Sarah Millican 92 0.1 difference in seconds ▼ 5
1770 Exit the caravan after exactly 20 minutes 727 Frankie Boyle 98 201 difference in seconds ▼ 5
1771 Exit the caravan after exactly 20 minutes 727 Ivo Graham 99 197 difference in seconds ▼ 5
1772 Exit the caravan after exactly 20 minutes 727 Jenny Eclair 100 543 difference in seconds ▼ 5
1773 Exit the caravan after exactly 20 minutes 727 Kiell Smith-Bynoe 101
DNF / DQ
 difference in seconds ▼ 5
1774 Exit the caravan after exactly 20 minutes 727 Mae Martin 102
DNF / DQ
 difference in seconds ▼ 5
1875 Do what Alex does 763 Frankie Boyle 98 92 difference in seconds ▼ 5
1876 Do what Alex does 763 Ivo Graham 99 95 difference in seconds ▼ 5
1877 Do what Alex does 763 Jenny Eclair 100 532 difference in seconds ▼ 5
1878 Do what Alex does 763 Kiell Smith-Bynoe 101 185 difference in seconds ▼ 5
1879 Do what Alex does 763 Mae Martin 102 128 difference in seconds ▼ 5

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)
);