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
〃

5 rows where task = 585

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: PO, episode, series

id ▲ task contestant PO base ± points rank episode series team location
2819 Find the soldier with hindsight 585 Alan Davies 68 3= 1   1 5 7 138    
2820 Find the soldier with hindsight 585 Desiree Burch 69 1= 4   4 2 13 132    
2821 Find the soldier with hindsight 585 Guz Khan 70 1= 3   3 3 9 140    
2822 Find the soldier with hindsight 585 Morgana Robinson 71 5 5   5 1 8 140    
2823 Find the soldier with hindsight 585 Victoria Coren Mitchell 72 3= 2   2 4 8 108    

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