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
〃

53 rows where contestant = 57

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: PO, base, points, rank, episode, team, location

id ▲ task contestant PO base ± points rank episode series team location
2072 The nicest thing to put in your mouth 431 Richard Herring 57 5 4   4 2 4 4    
2077 Fell the coconut, then move the drinks 432 Richard Herring 57 1=
DQ
  0   4 4    
2082 Make a large object vanish 433 Richard Herring 57 1 3   3 3= 7 7    
2087 Get the most eggs in the pan 434 Richard Herring 57 1= 0   0   7 7    
2092 Get the most balls of the same colour in your bucket using litter pickers 435 Richard Herring 57 0 5   5 1 12 12    
2097 The best thing with loads of holes in it 436 Richard Herring 57 2 3   3 3 3 15    
2102 Find the treasure / Make different, increasingly loud noises 437 Richard Herring 57 1= 4   4 2= 7 19 D+R lab
2107 Make a portrait of the Taskmaster and his toy using balloons, pegs, and clothing 438 Richard Herring 57 3 2   2 3= 9 21    
2112 Get all the exercise balls in the hoops while in a boat 439 Richard Herring 57 2= 4   4 2 13 25    
2117 Guess what is making the noises 440 Richard Herring 57 0 6   6 1= 19 31    
2119 Select a wind-up dinosaur 441 Richard Herring 57 1= 0   0   19 31    
2124 The best thing that probably has a spring 442 Richard Herring 57 1 3   3 3 3 34    
2129 Make the best upside-down film 443 Richard Herring 57 5 1   1 5 4 35    
2134 Put the most spaghetti in a grapefruit 444 Richard Herring 57 1= 2   2 4 6 37    
2139 Catapult a shoe into a bathtub 445 Richard Herring 57 2= 3   3 3 9 40    
2144 Draw an object on a rotating canvas 446 Richard Herring 57 0 6   6 1= 15 46 D+R  
2149 The cheekiest food 447 Richard Herring 57 2 3   3 3 3 49    
2154 Make the phone ring 448 Richard Herring 57 1= 5   5 1 8 54    
2159 Persuade the security guard to look in your bag 449 Richard Herring 57 1= 0   0   8 54 D+R  
2164 Drop a water balloon as far as possible without it bursting 450 Richard Herring 57 2 4   4 4 12 58    
2169 Roll an edible sphere across a line as slowly as possible 451 Richard Herring 57 0 1   1 5 13 59    
2174 The best pointy thing 452 Richard Herring 57 3 5   5 1 5 64    
2179 Bag the heaviest thing from the greatest distance 453 Richard Herring 57 1= 4   4 2 9 68    
2184 Paint a howling wolf on a rotating teapot 454 Richard Herring 57 1= 5   5 1= 14 73    
2189 Do something out of character with £20 455 Richard Herring 57 4 4   4 3= 18 77    
2194 Feed your team-mate(s) the most watermelon 456 Richard Herring 57 1= 5   5 1= 23 82 D+R lab
2199 List words of a certain length without hesitating 457 Richard Herring 57 5 3   3 3= 26 85    
2204 The most narcissistic thing 458 Richard Herring 57 5 2   2 4= 2 87    
2209 Quietly make a cocktail 459 Richard Herring 57 3= 3   3 3 5 90    
2214 Draw the animal watching you from the mirror 460 Richard Herring 57 1= 2   2 4 7 92    
2219 Transfer the water from one barrel to another 461 Richard Herring 57 1= 3   3 3 10 95    
2224 Draw animals using straight lines 462 Richard Herring 57 0 2   2 2= 12 97 D+R  
2229 The best thing that’s bigger at the top than the bottom 463 Richard Herring 57 1 1   1 5 1 98    
2234 Move two chickens around a course using a remote-control car and a mobility scooter 464 Richard Herring 57 2= 3   3 3 4 101    
2239 Communicate the safe contents via reversed audio 465 Richard Herring 57 2= 0   0   4 101 D+R garage
2244 Make the best and longest-lasting marble run 466 Richard Herring 57 3 3   3 3 7 104    
2249 Communicate things to the Taskmaster using only sounds 467 Richard Herring 57 5 2   2 4 9 106    
2256 The best thing with wings 469 Richard Herring 57 2 5   5 1 5 111    
2261 Fill the cup to overflowing without touching the red green 470 Richard Herring 57 4=
DQ
  0   5 111    
2266 Learn your lines and perform a scene 471 Richard Herring 57 1= 5   5 1 10 116    
2271 Extract water from a coconut 472 Richard Herring 57 4 4   4 2 14 120    
2276 Do not blink while staring at your opponent with a selected expression 473 Richard Herring 57 1= 4   4 1= 18 124 JM+R  
2281 The best bedding 474 Richard Herring 57 5 5   5 1 5 129    
2286 Make the largest beer mat house while ringing the doorbell with increasing frequency 475 Richard Herring 57 3= 3   3 3 8 132    
2291 Complete the most tasks behind the five motorised doors 476 Richard Herring 57 1= 4   4 2 12 136    
2296 Work out how many balls are in the basket 477 Richard Herring 57 4= 4   4 2 16 140    
2301 Draw the monster described by the Taskmaster 478 Richard Herring 57 5 5   5 1 21 145    
2306 The greatest collection 479 Richard Herring 57 4 1   1 5 1 146    
2311 Put the wellies on the spider’s feet 480 Richard Herring 57 1= 3   3 3 4 149    
2316 Complete the best performance of a specific song 481 Richard Herring 57 1= 5   5 1= 9 154 D+R lounge
2321 Neatly hang all the clothes on a rail without stepping over the line 482 Richard Herring 57 1= 3   3 3 12 157    
2326 Balance all the mints or biscuits on a spaghetti bridge 483 Richard Herring 57 0 5   5 1 17 162    
2328 Guess how many green eggs are under the Taskmaster’s chair 484 Richard Herring 57 2 0   0   17 162    

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 20.608ms