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

✎ 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
3179 The most jaw-dropping item 658 Fern Brady 89 2 5   5 1 5 5    
3184 What ten films are you in? 659 Fern Brady 89 1= 3   3 3 8 8    
3189 Land loo roll in the toilet 660 Fern Brady 89 1= 4   4 2 12 12    
3194 Create the best picture of a bird 661 Fern Brady 89 1= 2   2 2= 14 14 DF+J  
3199 Don't pop the balloon 662 Fern Brady 89 4 3   3 3 17 17    
3204 The best thing you can't throw away 663 Fern Brady 89 3 3   3 3= 3 20    
3209 Print, laminate, and distribute the most signs 664 Fern Brady 89 1= 4   4 2 7 24    
3214 Obey all your signs 665 Fern Brady 89 1= 2   2 4 9 26    
3219 Put five grapes in the little bowl 666 Fern Brady 89 3= 0   0   9 26    
3224 Sort the ducks and the socks 667 Fern Brady 89 1= 2   2 4 11 28    
3229 Make the Taskmaster say your words 668 Fern Brady 89 1= 3   3 1= 14 31 DF+J  
3234 The thing you most want on a Sunday morning 669 Fern Brady 89 3 3   3 3 3 34    
3239 Put the most sand in the shopping trolley 670 Fern Brady 89 2= 0   0   3 34 DF+J  
3244 Identify the ice cream flavours 671 Fern Brady 89 1= 4   4 2= 7 38    
3249 Catch something 672 Fern Brady 89 3 4   4 2 11 42    
3254 Play your sounds right 673 Fern Brady 89 0 3   3 3= 14 45    
3259 The greatest addition to a garden 674 Fern Brady 89 4 1   1 5 1 46    
3264 Turn on the bubble machine 675 Fern Brady 89 1= 3   3 3 4 49    
3269 Get the tarpaulin into one of the containers 676 Fern Brady 89 3= 3   3 3 7 52    
3274 Write a classic song incorporating five wonderful words 677 Fern Brady 89 2 4   4 2= 11 56    
3279 Egg and spoon throw 678 Fern Brady 89 2 4   4 2 15 60    
3284 The most useless thing that cost over £20 679 Fern Brady 89 1 3   3 3= 3 63    
3289 Get the most pleasure from these rubber chutes 680 Fern Brady 89 4= 5   5 1 8 68    
3294 Perform the best routine to this music 681 Fern Brady 89 1= 5   5 1= 13 73 DF+J  
3299 Luggage trolley bowling 682 Fern Brady 89 1= 1   1 5 14 74    
3304 Communicate animals by saying letters and doing impressions 683 Fern Brady 89 1= 5   5 1= 19 79 DF+J  
3309 The best thing you've ever received in the post 684 Fern Brady 89 3 1   1 5 1 80    
3314 Hold the milk bottles above the microwaves 685 Fern Brady 89 1= 2   2 4 3 82    
3319 Reach the end of two lanes in the same amount of time 686 Fern Brady 89 5 1   1 5 4 83    
3324 Strike the bullseye with your paint 687 Fern Brady 89 1=
DQ
  0   4 83    
3329 Paint a unicorn using your head brush 688 Fern Brady 89 2 2   2 4 6 85    
3334 The thing you'd most like to have on a car journey 689 Fern Brady 89 2 4   4 2 4 89    
3339 Pop 99 red balloons 690 Fern Brady 89 4= 0   0   4 89    
3344 Get this feather into the bath 691 Fern Brady 89 1= 5   5 1= 9 94 DF+J  
3349 Hit Bernard with an exercise ball 692 Fern Brady 89 1= 2   2 4 11 96    
3354 Blow an item onto The Knappett 693 Fern Brady 89 2 5   5 1= 16 101    
3359 The best fancy dress 694 Fern Brady 89 1 5   5 1 5 106    
3364 Communicate an instruction in a secret language 695 Fern Brady 89 2= 0   0   5 106 DF+J  
3369 Pin an alluring tail on the alluring animal 696 Fern Brady 89 3= 1   1 5 6 107    
3374 Find the back of your hand 697 Fern Brady 89 3= 4   4 3 10 111    
3379 Guess the length of the extendible item 698 Fern Brady 89 0 2   2 2= 12 113 DF+J  
3384 The most underestimated item 699 Fern Brady 89 3 3   3 1= 3 116    
3389 Snort, raspberry, whistle 700 Fern Brady 89 1 2   2 4= 5 118    
3394 Write a one-minute, one-person play 701 Fern Brady 89 1 5   5 1= 10 123    
3399 Perform a one-minute, one-person play 702 Fern Brady 89 2 5   5 1= 15 128    
3404 Paint a self portrait with a selected brush on a selected canvas 703 Fern Brady 89 2 5   5 1 20 133    
3409 Get your towel in your bucket 704 Fern Brady 89 0 3   3 3 23 136    
3414 The thing the Taskmaster would most like to own 705 Fern Brady 89 2 1   1 3= 1 137    
3419 Order three things for your final task 706 Fern Brady 89 1= 0   0   1 137    
3424 Eat the grape 707 Fern Brady 89 3= 3   3 3 4 140    
3429 Sculpt your team 708 Fern Brady 89 2= 3   3 2= 7 143 DF+J  
3434 Throw an object, hide an object, and place it on the barrel 709 Fern Brady 89 5 1   1 5 8 144    
3439 Land a balloon near the Taskmaster 710 Fern Brady 89 4
DQ
  0   8 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 23.064ms