attempts

Table actions
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
〃

55 rows where contestant = 43

✎ 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
1536 The most powerful smell 323 Iain Stirling 43 1 2   2 4 2 2    
1541 Find the baby monitor receiver 324 Iain Stirling 43 1= 5   5 1 7 7    
1546 Make and be seduced by a ventriloquist dummy 325 Iain Stirling 43 3 5   5 1 12 12    
1551 Sneak up on Alex 326 Iain Stirling 43 3= 4   4 2= 16 16    
1556 Collect the most doughnuts in your bucket 327 Iain Stirling 43 0 4   4 2 20 20    
1561 Peel a banana with your feet 328 Iain Stirling 43 1= 0   0   20 20    
1563 The best pair of things 329 Iain Stirling 43 3 4   4 2= 4 24    
1568 Make a moustache from something unexpected 330 Iain Stirling 43 1= 2   2 4 6 26    
1573 Transfer the rice to the bottle 331 Iain Stirling 43 4= 3   3 3 9 29    
1578 Convey an object using only facial expressions, noises, adjectives & verbs 332 Iain Stirling 43 1= 2   2 2= 11 31 IL+P  
1583 Travel the furthest while making a continuous noise 333 Iain Stirling 43 1= 1   1 5 12 32    
1588 Name a bird, eat a grape, name a contestant 334 Iain Stirling 43 3 1   1 5 13 33    
1593 The best burstable thing 335 Iain Stirling 43 3 3   3 3 3 36    
1598 Build the best volcano 336 Iain Stirling 43 2 2   2 4= 5 38    
1603 Work out what Alex is wearing 337 Iain Stirling 43 2= 3   3 3 8 41    
1608 Do the worst thing and make the best apology 338 Iain Stirling 43 4 4   4 2 12 45    
1613 Get into two sleeping bags and complete other actions 339 Iain Stirling 43 0 5   5 1 17 50    
1618 The best present for a doctor 340 Iain Stirling 43 3 1   1 4= 1 51    
1623 Get the toilet paper through the toilet seat 341 Iain Stirling 43 1= 5   5 1 6 56    
1628 Make the best thing to entertain a toddler 342 Iain Stirling 43 2 4   4 3= 10 60    
1633 Get the most weight into a hammock 343 Iain Stirling 43 1=
DQ
   0   10 60 IL+P  
1638 Throw a frying pan into a hoop 344 Iain Stirling 43 4 0   0   10 60    
1646 The best face 346 Iain Stirling 43 5 5   5 1 5 65    
1651 Move the sand from one bucket to another 347 Iain Stirling 43 3
DQ
   0   5 65    
1656 Make a realistic injury using food 348 Iain Stirling 43 4 4   4 2= 9 69    
1661 Play long-distance catch with a beach ball 349 Iain Stirling 43 1= 3   3 1= 12 72 IL+P  
1666 Herd the ping pong balls into a pen 350 Iain Stirling 43 3= 5   5 1 17 77    
1671 Recreate the scene you parade past 351 Iain Stirling 43 2 4   4 2 21 81    
1676 The best see-through item 352 Iain Stirling 43 5 1   1 2= 1 82    
1681 Conceal yourself inside a phone box 353 Iain Stirling 43 4 5   5 1 6 87    
1686 Design an iconic album cover 354 Iain Stirling 43 1= 2   2 2= 8 89 IL+P  
1691 Recall the order of the deck of cards 355 Iain Stirling 43 1= 2   2 4 10 91    
1696 Score a goal from the greatest distance 356 Iain Stirling 43 5
DQ
   0   10 91    
1701 Roll a toilet roll, and retrieve your shoe 357 Iain Stirling 43 3 0   0   10 91    
1706 The best slippery thing 358 Iain Stirling 43 2 3   3 4 3 94    
1711 Find the apples 359 Iain Stirling 43 1=
DQ
   0   3 94    
1716 Work out the crisp flavours 360 Iain Stirling 43 1= 4   4 2 7 98    
1721 Do something powerful with your little finger 361 Iain Stirling 43 1= 3   3 2= 10 101    
1726 Answer the questions, pull the strings; do not release the green egg 362 Iain Stirling 43 1= 0   0   10 101 IL+P  
1731 The nicest thing to hold 363 Iain Stirling 43 1 3   3 3= 3 104    
1736 Make a portrait of a former contestant using sand and one tool 364 Iain Stirling 43 5 5   5 1 8 109    
1741 Catch the tennis balls 365 Iain Stirling 43 2= 5   5 1= 13 114 IL+P  
1746 Move the beach ball across the finish line using only water 366 Iain Stirling 43 1= 5   5 1 18 119    
1751 Complete the five-syllable words 367 Iain Stirling 43 0 0   0   18 119    
1756 The best form of protection 368 Iain Stirling 43 4 4   4 2= 4 123    
1761 Get a ball into a bin with the most bounces 369 Iain Stirling 43 3 3   3 3 7 126    
1766 Make a delicious dust meal 370 Iain Stirling 43 4= 5   5 1 12 131    
1771 Make yourselves look like one person 371 Iain Stirling 43 1= 3   3 1= 15 134 IL+P  
1776 Complete some tasks as one person 372 Iain Stirling 43 1= 1   1 2= 16 135 IL+P  
1781 Stack plates and bowls on your head 373 Iain Stirling 43 0 3   3 3 19 138    
1786 The best thing that will change your life for the better 374 Iain Stirling 43 2 5   5 1 5 143    
1791 Erase the eraser 375 Iain Stirling 43 3= 5   5 1 10 148    
1796 Make the most tremendous legs 376 Iain Stirling 43 5 3   3 3 13 151    
1801 Blindly drive a mobility scooter around a course 377 Iain Stirling 43 3= 5   5 1 18 156    
1806 Hook a duck while wearing inversion goggles 378 Iain Stirling 43 0 0   0   18 156    

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)
);