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.

2,037 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task contestant measurement objective
1 Eat as much watermelon as possible 2 Frank Skinner 3 179 grams ▲ 1
2 Eat as much watermelon as possible 2 Josh Widdicombe 4 218 grams ▲ 1
3 Eat as much watermelon as possible 2 Roisin Conaty 5 9 grams ▲ 1
4 Eat as much watermelon as possible 2 Romesh Ranganathan 6 301 grams ▲ 1
5 Eat as much watermelon as possible 2 Tim Key 7 293 grams ▲ 1
6 Empty the bathtub 4 Frank Skinner 3
07:42
 time ▼ 2
7 Empty the bathtub 4 Josh Widdicombe 4
08:52
 time ▼ 2
8 Empty the bathtub 4 Roisin Conaty 5
09:30
 time ▼ 2
9 Empty the bathtub 4 Romesh Ranganathan 6
02:50
 time ▼ 2
10 Empty the bathtub 4 Tim Key 7
02:20
 time ▼ 2
11 Find Alex 6 Frank Skinner 3
01:50
 time ▼ 2
12 Find Alex 6 Romesh Ranganathan 6
02:27
 time ▼ 2
13 High-five a 55-year-old 8 Frank Skinner 3
12:44
 time ▼ 2
14 High-five a 55-year-old 8 Josh Widdicombe 4
03:18
 time ▼ 2
15 High-five a 55-year-old 8 Roisin Conaty 5
06:12
 time ▼ 2
16 High-five a 55-year-old 8 Romesh Ranganathan 6
01:00:00
 time ▼ 2
17 High-five a 55-year-old 8 Tim Key 7
04:29
 time ▼ 2
18 Identify the contents of the pies 9 Frank Skinner 3 1 pies ▲ 3
19 Identify the contents of the pies 9 Josh Widdicombe 4 3 pies ▲ 3
20 Identify the contents of the pies 9 Roisin Conaty 5 1 pies ▲ 3
21 Identify the contents of the pies 9 Romesh Ranganathan 6 3 pies ▲ 3
22 Identify the contents of the pies 9 Tim Key 7 4 pies ▲ 3
23 Throw a teabag into a mug 13 Frank Skinner 3 10.04 meters ▲ 4
24 Throw a teabag into a mug 13 Josh Widdicombe 4 15.1 meters ▲ 4
25 Throw a teabag into a mug 13 Roisin Conaty 5 2.4 meters ▲ 4
26 Throw a teabag into a mug 13 Romesh Ranganathan 6 8.5 meters ▲ 4
27 Throw a teabag into a mug 13 Tim Key 7 23.87 meters ▲ 4
28 Get an egg as high as possible 16 Frank Skinner 3
DNF / DQ
 meters ▲ 4
29 Get an egg as high as possible 16 Josh Widdicombe 4 6.8 meters ▲ 4
30 Get an egg as high as possible 16 Roisin Conaty 5
DNF / DQ
 meters ▲ 4
31 Get an egg as high as possible 16 Romesh Ranganathan 6 1.11 meters ▲ 4
32 Get an egg as high as possible 16 Tim Key 7
DNF / DQ
 meters ▲ 4
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
38 Guess Frank’s age in minutes 18 Josh Widdicombe 4 30305028 difference in minutes ▼ 6
39 Guess Frank’s age in minutes 18 Romesh Ranganathan 6 30355028 difference in minutes ▼ 6
40 Make a block of ice disappear 20 Frank Skinner 3
27:28
 time ▼ 2
41 Make a block of ice disappear 20 Josh Widdicombe 4
17:04
 time ▼ 2
42 Make a block of ice disappear 20 Roisin Conaty 5
30:20
 time ▼ 2
43 Make a block of ice disappear 20 Romesh Ranganathan 6
47:30
 time ▼ 2
44 Make a block of ice disappear 20 Tim Key 7
13:40
 time ▼ 2
45 Score 11 points 23 Frank Skinner 3
18:01
 time ▼ 2
46 Score 11 points 23 Josh Widdicombe 4
11:12
 time ▼ 2
47 Score 11 points 23 Roisin Conaty 5
11:12
 time ▼ 2
48 Score 11 points 23 Romesh Ranganathan 6
11:12
 time ▼ 2
49 Score 11 points 23 Tim Key 7
18:01
 time ▼ 2
50 Fill an eggcup with tears 24 Frank Skinner 3 12 tears ▲ 7
51 Fill an eggcup with tears 24 Josh Widdicombe 4 7 tears ▲ 7
52 Fill an eggcup with tears 24 Roisin Conaty 5 0 tears ▲ 7
53 Fill an eggcup with tears 24 Romesh Ranganathan 6 10 tears ▲ 7
54 Fill an eggcup with tears 24 Tim Key 7 0 tears ▲ 7
55 Memorise an Australian Rules Football team 26 Frank Skinner 3 1 names ▲ 8
56 Memorise an Australian Rules Football team 26 Josh Widdicombe 4 1 names ▲ 8
57 Memorise an Australian Rules Football team 26 Roisin Conaty 5 1 names ▲ 8
58 Memorise an Australian Rules Football team 26 Romesh Ranganathan 6 1 names ▲ 8
59 Memorise an Australian Rules Football team 26 Tim Key 7 1 names ▲ 8
60 Move the boulder as far as possible 28 Frank Skinner 3 6.5 miles ▲ 9
61 Move the boulder as far as possible 28 Josh Widdicombe 4 14.7 miles ▲ 9
62 Move the boulder as far as possible 28 Roisin Conaty 5 0.17 miles ▲ 9
63 Move the boulder as far as possible 28 Romesh Ranganathan 6 1.75 miles ▲ 9
64 Move the boulder as far as possible 28 Tim Key 7 2.3 miles ▲ 9
65 Grow the longest nail 29 Frank Skinner 3 2.1 centimeters ▲ 10
66 Grow the longest nail 29 Josh Widdicombe 4 2.8 centimeters ▲ 10
67 Grow the longest nail 29 Roisin Conaty 5 1.8 centimeters ▲ 10
68 Grow the longest nail 29 Romesh Ranganathan 6 2.2 centimeters ▲ 10
69 Grow the longest nail 29 Tim Key 7 0 centimeters ▲ 10
70 Make a bed while holding hands 30 Frank Skinner 3
10:57
 time ▼ 2
71 Make a bed while holding hands 30 Josh Widdicombe 4
16:03
 time ▼ 2
72 Make a bed while holding hands 30 Roisin Conaty 5
16:03
 time ▼ 2
73 Make a bed while holding hands 30 Romesh Ranganathan 6
16:03
 time ▼ 2
74 Make a bed while holding hands 30 Tim Key 7
10:57
 time ▼ 2
75 Make a Swedish person blush 31 Frank Skinner 3 26 blush depth in ticks ▲ 11
76 Make a Swedish person blush 31 Josh Widdicombe 4 10 blush depth in ticks ▲ 11
77 Make a Swedish person blush 31 Roisin Conaty 5 46 blush depth in ticks ▲ 11
78 Make a Swedish person blush 31 Romesh Ranganathan 6 33 blush depth in ticks ▲ 11
79 Make a Swedish person blush 31 Tim Key 7 19 blush depth in ticks ▲ 11
80 Play mini golf with eggs 34 Frank Skinner 3 32 shots ▼ 12
81 Play mini golf with eggs 34 Frank Skinner 3 5 eggs ▼ 13
82 Play mini golf with eggs 34 Frank Skinner 3 6.85 minutes ▼ 14
83 Play mini golf with eggs 34 Frank Skinner 3 1096 points ▼ 15
84 Play mini golf with eggs 34 Josh Widdicombe 4 42 shots ▼ 12
85 Play mini golf with eggs 34 Josh Widdicombe 4 7 eggs ▼ 13
86 Play mini golf with eggs 34 Josh Widdicombe 4 21 minutes ▼ 14
87 Play mini golf with eggs 34 Josh Widdicombe 4 6174 points ▼ 15
88 Play mini golf with eggs 34 Roisin Conaty 5 40 shots ▼ 12
89 Play mini golf with eggs 34 Roisin Conaty 5 6 eggs ▼ 13
90 Play mini golf with eggs 34 Roisin Conaty 5 4.167 minutes ▼ 14
91 Play mini golf with eggs 34 Roisin Conaty 5 1000 points ▼ 15
92 Play mini golf with eggs 34 Romesh Ranganathan 6 68 shots ▼ 12
93 Play mini golf with eggs 34 Romesh Ranganathan 6 36 eggs ▼ 13
94 Play mini golf with eggs 34 Romesh Ranganathan 6 14.333 minutes ▼ 14
95 Play mini golf with eggs 34 Romesh Ranganathan 6 35088 points ▼ 15
96 Play mini golf with eggs 34 Tim Key 7 39 shots ▼ 12
97 Play mini golf with eggs 34 Tim Key 7 3 eggs ▼ 13
98 Play mini golf with eggs 34 Tim Key 7 10 minutes ▼ 14
99 Play mini golf with eggs 34 Tim Key 7 1170 points ▼ 15
100 Separate the blue sweets 37 Frank Skinner 3 11 blue sweets ▲ 16

Next page

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