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

✎ 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
3180 The most jaw-dropping item 658 John Kearns 90 3 1   1 5 1 1    
3185 What ten films are you in? 659 John Kearns 90 1= 2   2 4 3 3    
3190 Land loo roll in the toilet 660 John Kearns 90 5 1   1 5 4 4    
3195 Create the best picture of a bird 661 John Kearns 90 1= 2   2 2= 6 6 DF+J  
3200 Don't pop the balloon 662 John Kearns 90 1 5   5 1= 11 11    
3205 The best thing you can't throw away 663 John Kearns 90 4 1   1 5 1 12    
3210 Print, laminate, and distribute the most signs 664 John Kearns 90 1= 1   1 5 2 13    
3215 Obey all your signs 665 John Kearns 90 1= 1   1 5 3 14    
3220 Put five grapes in the little bowl 666 John Kearns 90 3= 3   3 3 6 17    
3225 Sort the ducks and the socks 667 John Kearns 90 1= 1   1 5 7 18    
3230 Make the Taskmaster say your words 668 John Kearns 90 1= 3   3 1= 10 21 DF+J  
3235 The thing you most want on a Sunday morning 669 John Kearns 90 2 5   5 1 5 26    
3240 Put the most sand in the shopping trolley 670 John Kearns 90 2= 5   5 1= 10 31 DF+J  
3245 Identify the ice cream flavours 671 John Kearns 90 4= 4   4 2= 14 35    
3250 Catch something 672 John Kearns 90 1= 2   2 4 16 37    
3255 Play your sounds right 673 John Kearns 90 0 4   4 2 20 41    
3260 The greatest addition to a garden 674 John Kearns 90 1 3   3 3 3 44    
3265 Turn on the bubble machine 675 John Kearns 90 3= 2   2 4 5 46    
3270 Get the tarpaulin into one of the containers 676 John Kearns 90 3= 2   2 4 7 48    
3275 Write a classic song incorporating five wonderful words 677 John Kearns 90 1 4   4 2= 11 52    
3280 Egg and spoon throw 678 John Kearns 90 3 1   1 5 12 53    
3285 The most useless thing that cost over £20 679 John Kearns 90 3 5   5 1 5 58    
3290 Get the most pleasure from these rubber chutes 680 John Kearns 90 3 3   3 4 8 61    
3295 Perform the best routine to this music 681 John Kearns 90 1= 5   5 1= 13 66 DF+J  
3300 Luggage trolley bowling 682 John Kearns 90 3 5   5 1 18 71    
3305 Communicate animals by saying letters and doing impressions 683 John Kearns 90 1= 5   5 1= 23 76 DF+J  
3310 The best thing you've ever received in the post 684 John Kearns 90 4 3   3 3 3 79    
3315 Hold the milk bottles above the microwaves 685 John Kearns 90 1= 4   4 2 7 83    
3320 Reach the end of two lanes in the same amount of time 686 John Kearns 90 3 4 1 5 2 12 88    
3325 Strike the bullseye with your paint 687 John Kearns 90 3=
DQ
  0   12 88    
3330 Paint a unicorn using your head brush 688 John Kearns 90 3 1   1 5 13 89    
3335 The thing you'd most like to have on a car journey 689 John Kearns 90 3 2   2 4 2 91    
3340 Pop 99 red balloons 690 John Kearns 90 4= 5   5 1 7 96    
3345 Get this feather into the bath 691 John Kearns 90 1= 5   5 1= 12 101 DF+J  
3350 Hit Bernard with an exercise ball 692 John Kearns 90 4= 5   5 1 17 106    
3355 Blow an item onto The Knappett 693 John Kearns 90 3 1   1 5 18 107    
3360 The best fancy dress 694 John Kearns 90 3 1   1 5 1 108    
3365 Communicate an instruction in a secret language 695 John Kearns 90 2= 0   0   1 108 DF+J  
3370 Pin an alluring tail on the alluring animal 696 John Kearns 90 5 3   3 3 4 111    
3375 Find the back of your hand 697 John Kearns 90 1= 0   0   4 111    
3380 Guess the length of the extendible item 698 John Kearns 90 0 2   2 2= 6 113 DF+J  
3385 The most underestimated item 699 John Kearns 90 1 2   2 4 2 115    
3390 Snort, raspberry, whistle 700 John Kearns 90 2= 2   2 4= 4 117    
3395 Write a one-minute, one-person play 701 John Kearns 90 5 5   5 1= 9 122    
3400 Perform a one-minute, one-person play 702 John Kearns 90 4 4   4 3 13 126    
3405 Paint a self portrait with a selected brush on a selected canvas 703 John Kearns 90 4 4   4 2 17 130    
3410 Get your towel in your bucket 704 John Kearns 90 0 2   2 4= 19 132    
3415 The thing the Taskmaster would most like to own 705 John Kearns 90 5 3   3 1 3 135    
3420 Order three things for your final task 706 John Kearns 90 1= 0   0   3 135    
3425 Eat the grape 707 John Kearns 90 1= 1   1 5 4 136    
3430 Sculpt your team 708 John Kearns 90 2= 3   3 2= 7 139 DF+J  
3435 Throw an object, hide an object, and place it on the barrel 709 John Kearns 90 1= 3   3 3 10 142    
3440 Land a balloon near the Taskmaster 710 John Kearns 90 3 2   2 4 12 144    

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