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 = 91

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ task contestant PO base ± points rank episode series team location
3181 The most jaw-dropping item 658 Munya Chawawa 91 4 2   2 4 2 2    
3186 What ten films are you in? 659 Munya Chawawa 91 4= 5   5 1 7 7    
3191 Land loo roll in the toilet 660 Munya Chawawa 91 3= 2   2 4 9 9    
3196 Create the best picture of a bird 661 Munya Chawawa 91 1= 5   5 1= 14 14 M+S  
3201 Don't pop the balloon 662 Munya Chawawa 91 3 0   0   14 14    
3206 The best thing you can't throw away 663 Munya Chawawa 91 1 4   4 2 4 18    
3211 Print, laminate, and distribute the most signs 664 Munya Chawawa 91 4= 2   2 4 6 20    
3216 Obey all your signs 665 Munya Chawawa 91 4= 5   5 1= 11 25    
3221 Put five grapes in the little bowl 666 Munya Chawawa 91 1= 4   4 2 15 29    
3226 Sort the ducks and the socks 667 Munya Chawawa 91 3= 4   4 2 19 33    
3231 Make the Taskmaster say your words 668 Munya Chawawa 91 2= 2   2 2= 21 35 M+S  
3236 The thing you most want on a Sunday morning 669 Munya Chawawa 91 4 1   1 5 1 36    
3241 Put the most sand in the shopping trolley 670 Munya Chawawa 91 1= 5   5 1= 6 41 M+S  
3246 Identify the ice cream flavours 671 Munya Chawawa 91 1= 1   1 5 7 42    
3251 Catch something 672 Munya Chawawa 91 1= 1   1 5 8 43    
3256 Play your sounds right 673 Munya Chawawa 91 0 3   3 3= 11 46    
3261 The greatest addition to a garden 674 Munya Chawawa 91 5 2   2 4 2 48    
3266 Turn on the bubble machine 675 Munya Chawawa 91 3= 1   1 5 3 49    
3271 Get the tarpaulin into one of the containers 676 Munya Chawawa 91 3= 1   1 5 4 50    
3276 Write a classic song incorporating five wonderful words 677 Munya Chawawa 91 5 2   2 4= 6 52    
3281 Egg and spoon throw 678 Munya Chawawa 91 4 3   3 3 9 55    
3286 The most useless thing that cost over £20 679 Munya Chawawa 91 4 3   3 3= 3 58    
3291 Get the most pleasure from these rubber chutes 680 Munya Chawawa 91 1= 4   4 2= 7 62    
3296 Perform the best routine to this music 681 Munya Chawawa 91 2= 4   4 2= 11 66 M+S  
3301 Luggage trolley bowling 682 Munya Chawawa 91 4= 4   4 2 15 70    
3306 Communicate animals by saying letters and doing impressions 683 Munya Chawawa 91 2= 5   5 1= 20 75 M+S  
3311 The best thing you've ever received in the post 684 Munya Chawawa 91 1 4   4 2 4 79    
3316 Hold the milk bottles above the microwaves 685 Munya Chawawa 91 3= 3   3 3 7 82    
3321 Reach the end of two lanes in the same amount of time 686 Munya Chawawa 91 4 3 1 4 3 11 86    
3326 Strike the bullseye with your paint 687 Munya Chawawa 91 1=
DQ
  0   11 86    
3331 Paint a unicorn using your head brush 688 Munya Chawawa 91 4 3   3 3 14 89    
3336 The thing you'd most like to have on a car journey 689 Munya Chawawa 91 4 1   1 5 1 90    
3341 Pop 99 red balloons 690 Munya Chawawa 91 1= 0   0   1 90    
3346 Get this feather into the bath 691 Munya Chawawa 91 2= 2   2 2= 3 92 M+S  
3351 Hit Bernard with an exercise ball 692 Munya Chawawa 91 4=
DQ
  0   3 92    
3356 Blow an item onto The Knappett 693 Munya Chawawa 91 4 5   5 1= 8 97    
3361 The best fancy dress 694 Munya Chawawa 91 4 3   3 2= 3 100    
3366 Communicate an instruction in a secret language 695 Munya Chawawa 91 1= 5   5 1= 8 105 M+S  
3371 Pin an alluring tail on the alluring animal 696 Munya Chawawa 91 1= 5   5 1 13 110    
3376 Find the back of your hand 697 Munya Chawawa 91 3= 5   5 1= 18 115    
3381 Guess the length of the extendible item 698 Munya Chawawa 91 0 3   3 1= 21 118 M+S  
3386 The most underestimated item 699 Munya Chawawa 91 2 1   1 5 1 119    
3391 Snort, raspberry, whistle 700 Munya Chawawa 91 4= 5   5 1 6 124    
3396 Write a one-minute, one-person play 701 Munya Chawawa 91 3 1   1 5 7 125    
3401 Perform a one-minute, one-person play 702 Munya Chawawa 91 1 2   2 5 9 127    
3406 Paint a self portrait with a selected brush on a selected canvas 703 Munya Chawawa 91 5 3   3 3 12 130    
3411 Get your towel in your bucket 704 Munya Chawawa 91 0 4   4 2 16 134    
3416 The thing the Taskmaster would most like to own 705 Munya Chawawa 91 3 1   1 3= 1 135    
3421 Order three things for your final task 706 Munya Chawawa 91 1= 0   0   1 135    
3426 Eat the grape 707 Munya Chawawa 91 1= 2   2 4 3 137    
3431 Sculpt your team 708 Munya Chawawa 91 1= 5   5 1= 8 142 M+S  
3436 Throw an object, hide an object, and place it on the barrel 709 Munya Chawawa 91 1= 4   4 2 12 146    
3441 Land a balloon near the Taskmaster 710 Munya Chawawa 91 2 4   4 2 16 150    

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.283ms