taskmaster: attempts: 12 rows where team = 29

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: 〃

12 rows where team = 29

descending

id ▲	task	contestant	PO	base	points	rank	episode	series	team
2924	Score an exercise ball hat-trick using a buggy 606	Ardal O'Hanlon 78	1=	5	5	1=	14	24	A+C
2926	Score an exercise ball hat-trick using a buggy 606	Chris Ramsey 80	1=	5	5	1=	15	38	A+C
2954	Face leg or other leg? 612	Ardal O'Hanlon 78	1=	2	2	2=	11	36	A+C
2956	Face leg or other leg? 612	Chris Ramsey 80	1=	2	2	2=	13	54	A+C
2969	Give Alex the best stag minute 615	Ardal O'Hanlon 78	1=	5	5	1=	12	48	A+C
2971	Give Alex the best stag minute 615	Chris Ramsey 80	1=	5	5	1=	12	66	A+C
3053	Deliver a cocktail to Greg 633	Ardal O'Hanlon 78	1=	2	2	2=	10	96	A+C
3055	Deliver a cocktail to Greg 633	Chris Ramsey 80	1=	2	2	2=	10	107	A+C
3093	Write down things that fit the category 641	Ardal O'Hanlon 78	0	5	5	1=	18	124	A+C
3095	Write down things that fit the category 641	Chris Ramsey 80	0	5	5	1=	14	130	A+C
3138	Record a multi-track song about your team 650	Ardal O'Hanlon 78	1=	3	3	2=	14	152	A+C
3140	Record a multi-track song about your team 650	Chris Ramsey 80	1=	3	3	2=	16	165	A+C

Advanced export

JSON shape: default, array, newline-delimited, object

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