[Data] Safest/most dangerous UK cycling cities.xlsx

	A	B	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	City	Overall danger score (/10)	Count of routes	Average steepness of route	Steepness score (/10)	Sum of Fatal accidents	Fatal accidents score (/10)	Sum of Serious accidents	Serious accidents score (/10)	Sum of Slight accidents	Slight accidents score (/10)	Average bike accident score (/10)	% of routes with acceptable or better surface quality	Surface quality score (/10)	% of routes with lighting on path	Dim lighting score (/10)
2	Birmingham	7.38	257	0.63	6.25	2	7.00	16	6.25	93	7.00	6.75	92.22%	9.00	45.53%	8.75
3	Newcastle upon Tyne	7.21	192	1.17	9.75	5	10.00	37	8.50	114	7.50	8.67	98.44%	3.00	71.35%	4.50
4	Plymouth	7.17	220	0.86	8.00	2	7.00	18	7.00	81	6.75	6.92	90.45%	9.50	70.91%	4.75
5	Sheffield	7.08	259	0.85	7.75	2	7.00	45	9.25	149	8.50	8.25	98.84%	2.25	57.53%	7.75
6	London	6.88	1181	0.46	3.00	3	8.75	119	10.00	856	10.00	9.58	95.00%	7.75	79.00%	1.75
7	Preston	6.79	248	0.59	5.25	2	7.00	31	7.75	77	6.50	7.08	93.95%	8.50	68.55%	5.75
8	Manchester	6.63	574	0.53	4.75	3	8.75	31	7.75	161	9.25	8.58	96.69%	6.25	73.69%	3.00
9	Stoke-on-Trent	6.13	152	0.89	8.25	2	7.00	7	2.00	54	4.50	4.50	97.37%	5.50	43.42%	9.50
10	Bristol	6.08	368	0.75	7.25	1	4.25	16	6.25	184	9.50	6.67	98.10%	4.00	70.11%	5.25
11	Brighton and Hove	5.67	129	0.98	8.75	0	0.00	62	9.75	147	8.25	6.00	97.67%	4.50	75.19%	2.75
12	Bradford	5.54	81	0.99	9.00	0	0.00	16	6.25	68	5.75	4.00	97.53%	5.00	61.73%	7.25
13	Portsmouth	5.54	157	0.37	1.00	2	7.00	38	8.75	150	8.75	8.17	96.18%	7.00	85.99%	0.75
14	Derby	5.42	214	0.49	4.00	2	7.00	12	5.00	104	7.25	6.42	95.79%	7.25	77.10%	2.00
15	Leeds	5.42	131	0.74	7.00	0	0.00	15	6.00	65	5.25	3.75	96.95%	6.00	52.67%	8.25
16	Kingston upon Hull	5.29	171	0.23	0.00	3	8.75	47	9.50	193	9.75	9.33	98.25%	3.50	88.30%	0.25
17	Sunderland	5.17	108	1.20	10.00	0	0.00	9	3.25	46	3.75	2.33	96.30%	6.50	61.11%	7.50
18	Bath	5.08	115	1.01	9.25	0	0.00	5	0.75	22	1.25	0.67	92.17%	9.25	40.00%	10.00
19	Southampton	4.79	164	0.44	2.50	1	4.25	38	8.75	131	8.00	7.00	97.56%	4.75	87.80%	0.50
20	Oxford	4.63	119	0.33	0.50	1	4.25	18	7.00	67	5.50	5.58	94.96%	8.00	75.63%	2.50
21	Newport	4.58	203	1.04	9.50	1	4.25	6	1.50	50	4.25	3.33	100.00%	1.50	65.52%	6.50
22	Chester	4.50	120	0.49	3.75	0	0.00	9	3.25	38	3.25	2.17	86.67%	9.75	63.33%	7.00
23	Wolverhampton	4.46	74	0.50	4.25	0	0.00	8	2.50	26	1.50	1.33	86.49%	10.00	47.30%	8.50
24	Liverpool	4.46	312	0.48	3.50	0	0.00	33	8.25	153	9.00	5.75	99.04%	2.00	73.08%	4.00
25	Salford	4.42	119	0.54	5.00	3	8.75	12	5.00	75	6.25	6.67	100.00%	1.50	92.44%	0.00
26	Carlisle	4.38	62	0.50	4.50	3	8.75	8	2.50	31	2.25	4.50	100.00%	1.50	64.52%	6.75
27	Exeter	4.38	79	0.60	5.75	1	4.25	10	4.25	15	0.25	2.92	96.20%	6.75	70.89%	5.00
28	Coventry	4.21	77	0.44	2.75	1	4.25	11	4.75	28	1.75	3.58	98.70%	2.75	45.45%	9.00
29	Cardiff	4.17	173	0.72	6.75	1	4.25	9	3.25	38	3.25	3.58	100.00%	1.50	67.05%	6.00
30	Peterborough	4.00	202	0.33	0.75	1	4.25	10	4.25	62	5.00	4.50	98.02%	4.25	69.80%	5.50
31	Swansea	3.75	91	0.91	8.50	0	0.00	7	2.00	17	0.75	0.92	100.00%	1.50	41.76%	9.75
32	Norwich	3.63	88	0.60	5.50	0	0.00	14	5.50	30	2.00	2.50	95.45%	7.50	80.68%	1.25
33	St Albans	3.54	61	0.78	7.50	0	0.00	5	0.75	34	2.75	1.17	93.44%	8.75	80.33%	1.50
34	Wakefield	3.54	53	0.63	6.50	0	0.00	5	0.75	18	1.00	0.58	98.11%	3.75	45.28%	9.25
35	York	3.33	112	0.42	2.00	0	0.00	14	5.50	61	4.75	3.42	100.00%	1.50	66.96%	6.25
36	Leicester	3.29	231	0.42	1.50	1	4.25	8	2.50	114	7.50	4.75	99.57%	1.75	75.76%	2.25
37	Cambridge	3.25	158	0.24	0.25	0	0.00	24	7.50	74	6.00	4.50	98.73%	2.50	73.42%	3.25
38	Gloucester	3.17	86	0.42	1.75	1	4.25	3	0.50	8	0.00	1.58	94.19%	8.25	72.09%	4.25
39	Lincoln	3.13	60	0.47	3.25	1	4.25	9	3.25	46	3.75	3.75	98.33%	3.25	81.67%	1.00
40	Nottingham	3.00	78	0.62	6.00	0	0.00	2	0.25	32	2.50	0.92	97.44%	5.25	73.08%	4.00
41	Worcester	2.71	162	0.44	2.25	0	0.00	6	1.50	37	3.00	1.50	100.00%	1.50	56.79%	8.00
42	Chelmsford	1.79	67	0.41	1.25	0	0.00	1	0.00	15	0.25	0.08	97.01%	5.75	73.13%	3.50
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100