TdlM / taskmaster

Menu
  • Make shortlink

attempts

Table actions
  • Toggle column notes
PO (presentation order)
the order in which the contestant's prize, VT, work of art, or live attempt was presented; 0 for simultaneous (most live tasks)
± (adjustment)
any alteration (bonus or deduction) applied to the attempt's base score
episode
the contestant's cumulative episode score after this task
series
〃

34 rows where contestant = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: base, points, rank, episode, series

id ▲ task contestant PO base ± points rank episode series team location
4 The most unusual item 1 Romesh Ranganathan 6 4 3   3 3 3 3    
9 Eat as much watermelon as possible 2 Romesh Ranganathan 6 4= 5   5 1 8 8    
14 Paint a horse while riding a horse 3 Romesh Ranganathan 6 1= 4   4 2 12 12    
19 Empty the bathtub 4 Romesh Ranganathan 6 4= 5   5 1 17 17    
24 Pop up a tent and pop on a onesie 5 Romesh Ranganathan 6 0 2   2 4 19 19    
27 Find Alex 6 Romesh Ranganathan 6 1= 0   0   19 19    
31 The most impressive item 7 Romesh Ranganathan 6 2 1   1 5 1 20    
36 High-five a 55-year-old 8 Romesh Ranganathan 6 1= 1   1 5 2 21    
41 Identify the contents of the pies 9 Romesh Ranganathan 6 2= 3   3 3 5 24    
46 Do something that will look impressive in reverse 10 Romesh Ranganathan 6 5 5   5 1= 10 29    
51 Unshackle yourself and sprint one metre 11 Romesh Ranganathan 6 0 4   4 2 14 33    
56 The most meaningful item 12 Romesh Ranganathan 6 2 5   5 1 5 38    
61 Throw a teabag into a mug 13 Romesh Ranganathan 6 1= 3   3 3 8 41    
66 Draw an image using a GPS device 14 Romesh Ranganathan 6 4= 4   4 2 12 45    
71 Buy a gift for the Taskmaster 15 Romesh Ranganathan 6 3 2   2 4 14 47    
76 Get an egg as high as possible 16 Romesh Ranganathan 6 1 4   4 2 18 51    
81 Stand up after 100 seconds 17 Romesh Ranganathan 6 0 4   4 2= 22 55    
84 Guess Frank’s age in minutes 18 Romesh Ranganathan 6 1 0   0   22 55    
88 The most beautiful item 19 Romesh Ranganathan 6 4 1   1 5 1 56    
93 Make a block of ice disappear 20 Romesh Ranganathan 6 5 2   2 4 3 58    
100 Score 11 points 23 Romesh Ranganathan 6 2= 2   2 1= 5 60 JR+R  
105 Fill an eggcup with tears 24 Romesh Ranganathan 6 4 4   4 2 9 64    
111 Memorise an Australian Rules Football team 26 Romesh Ranganathan 6 4 1   1 1= 10 65    
116 The most valuable item 27 Romesh Ranganathan 6 4 3   3 3 3 68    
121 Move the boulder as far as possible 28 Romesh Ranganathan 6 2= 2   2 4 5 70    
126 Grow the longest nail 29 Romesh Ranganathan 6 4 4   4 2 9 74    
131 Make a bed while holding hands 30 Romesh Ranganathan 6 1= 0   0   9 74 JR+R special
136 Make a Swedish person blush 31 Romesh Ranganathan 6 2= 4   4 2 13 78    
141 Inflate the largest balloon while blindfolded 32 Romesh Ranganathan 6 0 3   3 3 16 81    
146 The most satisfying item 33 Romesh Ranganathan 6 2 3   3 3 3 84    
151 Play mini golf with eggs 34 Romesh Ranganathan 6 1= 1   1 5 4 85    
156 Stage a realistic home movie blooper 35 Romesh Ranganathan 6 1= 0   0   4 85 JR+R  
161 Make an alphabet meal 36 Romesh Ranganathan 6 3 4   4 2 8 89    
166 Separate the blue sweets 37 Romesh Ranganathan 6 0 4   4 2 12 93    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE attempts (
   id         INTEGER PRIMARY KEY,
   task       INTEGER REFERENCES tasks(id),
   contestant INTEGER REFERENCES people(id),
   PO         TEXT,
   base       INTEGER,
   adjustment INTEGER,
   points     INTEGER,
   rank       TEXT,
   episode    INTEGER,
   series     INTEGER,
   team       INTEGER REFERENCES teams(id),
   location   INTEGER REFERENCES special_locations(id)
);
Powered by Datasette · Queries took 160.002ms