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

✎ 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
1540 The most powerful smell 323 Sian Gibson 47 5 3   3 2= 3 3    
1545 Find the baby monitor receiver 324 Sian Gibson 47 1= 4   4 2 7 7    
1550 Make and be seduced by a ventriloquist dummy 325 Sian Gibson 47 2 4   4 2= 11 11    
1555 Sneak up on Alex 326 Sian Gibson 47 1= 2   2 4 13 13    
1560 Collect the most doughnuts in your bucket 327 Sian Gibson 47 0 3   3 3 16 16    
1567 The best pair of things 329 Sian Gibson 47 1 5   5 1 5 21    
1572 Make a moustache from something unexpected 330 Sian Gibson 47 3= 1   1 5 6 22    
1577 Transfer the rice to the bottle 331 Sian Gibson 47 1= 2   2 4 8 24    
1582 Convey an object using only facial expressions, noises, adjectives & verbs 332 Sian Gibson 47 2= 3   3 1= 11 27 J+S  
1587 Travel the furthest while making a continuous noise 333 Sian Gibson 47 3= 3   3 3 14 30    
1592 Name a bird, eat a grape, name a contestant 334 Sian Gibson 47 5 2   2 4 16 32    
1597 The best burstable thing 335 Sian Gibson 47 5 5   5 1 5 37    
1602 Build the best volcano 336 Sian Gibson 47 4 2   2 4= 7 39    
1607 Work out what Alex is wearing 337 Sian Gibson 47 4= 5   5 1 12 44    
1612 Do the worst thing and make the best apology 338 Sian Gibson 47 3 3   3 3 15 47    
1617 Get into two sleeping bags and complete other actions 339 Sian Gibson 47 0 1   1 3= 16 48    
1622 The best present for a doctor 340 Sian Gibson 47 5 5   5 1 5 53    
1627 Get the toilet paper through the toilet seat 341 Sian Gibson 47 3= 2   2 4 7 55    
1632 Make the best thing to entertain a toddler 342 Sian Gibson 47 3 5   5 1= 12 60    
1637 Get the most weight into a hammock 343 Sian Gibson 47 2= 3   3 1= 15 63 J+S  
1642 Throw a frying pan into a hoop 344 Sian Gibson 47 3 0   0   15 63    
1645 Whip the bottle off the barrel 345 Sian Gibson 47 1= 0   0   15 63    
1650 The best face 346 Sian Gibson 47 3 3   3 3 3 66    
1655 Move the sand from one bucket to another 347 Sian Gibson 47 1= 3   3 3 6 69    
1660 Make a realistic injury using food 348 Sian Gibson 47 5 5   5 1 11 74    
1665 Play long-distance catch with a beach ball 349 Sian Gibson 47 2= 2   2 2= 13 76 J+S  
1670 Herd the ping pong balls into a pen 350 Sian Gibson 47 3= 2   2 4 15 78    
1675 Recreate the scene you parade past 351 Sian Gibson 47 5 2   2 3= 17 80    
1680 The best see-through item 352 Sian Gibson 47 4 1   1 2= 1 81    
1685 Conceal yourself inside a phone box 353 Sian Gibson 47 2 2   2 3= 3 83    
1690 Design an iconic album cover 354 Sian Gibson 47 2= 4   4 1= 7 87 J+S  
1695 Recall the order of the deck of cards 355 Sian Gibson 47 1= 3   3 3 10 90    
1700 Score a goal from the greatest distance 356 Sian Gibson 47 1 5   5 1 15 95    
1705 Roll a toilet roll, and retrieve your shoe 357 Sian Gibson 47 1 0   0   15 95    
1710 The best slippery thing 358 Sian Gibson 47 1 2   2 5 2 97    
1715 Find the apples 359 Sian Gibson 47 5
DQ
   0   2 97    
1720 Work out the crisp flavours 360 Sian Gibson 47 3= 2   2 4= 4 99    
1725 Do something powerful with your little finger 361 Sian Gibson 47 5 2   2 4= 6 101    
1730 Answer the questions, pull the strings; do not release the green egg 362 Sian Gibson 47 2= 5   5 1= 11 106 J+S  
1735 The nicest thing to hold 363 Sian Gibson 47 2 3   3 3= 3 109    
1740 Make a portrait of a former contestant using sand and one tool 364 Sian Gibson 47 3 1   1 5 4 110    
1745 Catch the tennis balls 365 Sian Gibson 47 1=
DQ
   0   4 110 J+S  
1750 Move the beach ball across the finish line using only water 366 Sian Gibson 47 1= 4   4 2 8 114    
1755 Complete the five-syllable words 367 Sian Gibson 47 0 0   0   8 114    
1760 The best form of protection 368 Sian Gibson 47 2 3   3 4= 3 117    
1765 Get a ball into a bin with the most bounces 369 Sian Gibson 47 4= 4   4 2 7 121    
1770 Make a delicious dust meal 370 Sian Gibson 47 1= 2   2 4 9 123    
1775 Make yourselves look like one person 371 Sian Gibson 47 1= 2   2 2= 11 125 J+S  
1780 Complete some tasks as one person 372 Sian Gibson 47 1= 4   4 1= 15 129 J+S  
1785 Stack plates and bowls on your head 373 Sian Gibson 47 0 1   1 5 16 130    
1790 The best thing that will change your life for the better 374 Sian Gibson 47 4 2   2 5 2 132    
1795 Erase the eraser 375 Sian Gibson 47 1= 2   2 4 4 134    
1800 Make the most tremendous legs 376 Sian Gibson 47 4 5   5 1 9 139    
1805 Blindly drive a mobility scooter around a course 377 Sian Gibson 47 3= 4   4 2 13 143    
1810 Hook a duck while wearing inversion goggles 378 Sian Gibson 47 0 0   0   13 143    

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