taskmaster: normalized_scores: 57 rows where contestant = 34

rigid: the simplest possible normalization: 5 points for 1st (equal), 4 for 2nd (equal), etc.; null for team tasks (only two ranks)
spread: Distribute points from a pool of {5, 4, 3, 2, 1}, with rank ties between N people sharing the next N available point values. (〃)
scale: Multiply every score by some common factor to achieve a sum of 15 for the task; where this causes any individual score to exceed 5, regrettably abandon the 15-point target and scale down to ensure a maximum of 5. Note that this value does exist for team tasks due to being point- rather than rank-based.
5+3, 3+2, 3½+2½: various ways to normalize team tasks based on rank

57 rows where contestant = 34

descending

id ▲	task	contestant	base	±	points	rank	rigid	spread	scale	5+3	3+2	3½+2½
964	The best liquid 206	Asim Chaudhry 34	1		1	4=	2	1.5	1
969	Perform the best wheelbarrow stunt 207	Asim Chaudhry 34	1		1	5	1	1	1
974	Make the tallest lemon tower 208	Asim Chaudhry 34	1		1	5	1	1	1
979	Return to the house wearing a hat 209	Asim Chaudhry 34	1		1	5	1	1	1
984	Sort the objects by size using your feet 210	Asim Chaudhry 34	4		4	2=	4	3.5	4
991	The best non-living hairy thing 212	Asim Chaudhry 34	1		1	5	1	1	1
996	Get the highest darts score 213	Asim Chaudhry 34	3		3	3	3	3	3
1001	Keep Alex dry 214	Asim Chaudhry 34	1		1	2=			1.25	3	2	2.5
1006	Take a picture of people holding eggs 215	Asim Chaudhry 34	3		3	3	3	3	3
1011	Take the wind-up man on an adventure 216	Asim Chaudhry 34	5		5	1	5	5	4.17
1016	Conceal grapes in your mouth or hand 217	Asim Chaudhry 34	0		0
1021	The most magnificent day trip 218	Asim Chaudhry 34	2		2	4	2	2	2
1026	Write a grown-up bedtime story 219	Asim Chaudhry 34	3		3	2=	4	3.5	3
1031	Make something spin for the longest 220	Asim Chaudhry 34	4		4	2	4	4	4
1036	Identify the baby food flavours 221	Asim Chaudhry 34	5	1	6	1	5	5	5
1041	Catch the most socks 222	Asim Chaudhry 34	4		4	2=	4	3	3.33
1046	The most thought-provoking thing 223	Asim Chaudhry 34	1		1	5	1	1	1
1051	Do something manly with a cardboard box 224	Asim Chaudhry 34	4		4	2=	4	2.5	2.86
1056	Have the most fun in 3 minutes 225	Asim Chaudhry 34	3		3	1=			3.46	5	3	3.5
1061	Exactly recreate your 3 minutes of fun 226	Asim Chaudhry 34	5		5	1=			3	5	3	3.5
1066	Make the best squirty cream art 227	Asim Chaudhry 34	1		1	5	1	1	1
1071	Remove the banknote from under the glass 228	Asim Chaudhry 34	4		4	2	4	4	4
1076	Shake hands with the Taskmaster without revealing your identity 229	Asim Chaudhry 34	0		0
1081	The sturdiest thing 230	Asim Chaudhry 34	1		1	5	1	1	1
1086	Work out the length of a piece of string 231	Asim Chaudhry 34	4		4	2	4	4	4
1091	Remove the tablecloth from underneath the eggs 232	Asim Chaudhry 34	5		5	1=	5	3	3
1096	Identify the link and do it 100 times 233	Asim Chaudhry 34	5		5	1=			3.57	5	3	3.5
1101	Pull off an elaborate snooker trick shot 234	Asim Chaudhry 34	2		2	4	2	2	2
1106	Throw eggs onto a shelf 235	Asim Chaudhry 34	2		2	4	2	2	1.88
1111	The best invention 236	Asim Chaudhry 34	1		1	3=	3	2	1
1116	Make the best snow globe 237	Asim Chaudhry 34	1		1	5	1	1	0.938
1121	Knock over the ducks without leaving the carpet 238	Asim Chaudhry 34	5		5	1=			5	5	3	3.5
1126	Make the best announcement 239	Asim Chaudhry 34	5		5	1	5	5	5
1131	Make a parachute for a wooden spoon 240	Asim Chaudhry 34	1		1	5	1	1	1
1136	Predict how many words you can list for a category 241	Asim Chaudhry 34	4		4	2	4	4	3.75
1141	The scariest thing from the kitchen 242	Asim Chaudhry 34	4		4	2	4	4	4
1146	Knock the bails off the stumps 243	Asim Chaudhry 34	0		0
1151	Draw the contents of the box 244	Asim Chaudhry 34	1		1	4=	2	1.5	1
1156	List and then mime obscure animals 245	Asim Chaudhry 34	2		2	2=			2.5	3	2	2.5
1161	Make and eat a pancake with objects tucked into your sweatband 246	Asim Chaudhry 34	3		3	4	2	2	2.25
1166	Roll eggs to the centre of the target 247	Asim Chaudhry 34	5		5	1	5	5	5
1171	The most interesting footwear 248	Asim Chaudhry 34	5		5	1	5	5	5
1176	Put something surprising inside a chocolate egg 249	Asim Chaudhry 34	3		3	3=	3	2	2.5
1181	Find out what you have in common with a stranger 250	Asim Chaudhry 34	5		5	1	5	5	4.69
1186	Make a join-the-dots image using stiletto heels 251	Asim Chaudhry 34	1		1	5	1	1	1
1191	Stick plasters to the correct body parts 252	Asim Chaudhry 34	2		2	4	2	2	2
1198	The most pleasing cat-sized thing 254	Asim Chaudhry 34	2		2	4	2	2	2
1203	Make the biggest bubble and burst it with your nose 255	Asim Chaudhry 34	3		3	3	3	3	3
1208	Perform a number from the Taskmaster musical 256	Asim Chaudhry 34	2		2	2=			2.5	3	2	2.5
1213	Make an outfit with stationery / Guess what pun Tim will make 257	Asim Chaudhry 34	0		0
1218	Make a plastic bag as heavy as possible 258	Asim Chaudhry 34	4		4	2	4	4	4
1223	Hold the most points above the ground 259	Asim Chaudhry 34	1		1	5	1	1	0.938
1228	The least appropriate wedding accessory 260	Asim Chaudhry 34	5		5	1	5	5	5
1233	Knock over the fewest bowling pins 261	Asim Chaudhry 34	3		3	3=	3	2.5	2.81
1238	Blow out a candle from a distance 262	Asim Chaudhry 34	5		5	1	5	5	5
1243	Declare your love for the Taskmaster 263	Asim Chaudhry 34	5		5	1=	5	4.5	4.69
1248	Pick numbers higher and lower than the people next to you 264	Asim Chaudhry 34	4		4	2	4	4	4

Advanced export

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

CREATE TABLE normalized_scores (
   id         INTEGER PRIMARY KEY,
   task       INTEGER REFERENCES tasks(id),
   contestant INTEGER REFERENCES people(id),
   base       INTEGER,
   adjustment INTEGER,
   points     INTEGER,
   rank       TEXT,
   rigid      REAL,
   spread     REAL,
   scale      REAL,
   '5+3'      REAL,
   '3+2'      REAL,
   '3½+2½'    REAL
);