I don’t want to die – the numbers
Yesterday’s blog post went kind of crazy, and with interest from some journalists, I wanted to be really sure that my numbers were 100% accurate including all the possible data I could find.
Important note: both posts relate to casualty rate, which are accidents and injuries not fatalities.
Using 2004-2011 data Bournemouth is actually second to Portsmouth
Using 2005-2010 data Bournemouth is number one
…I leave it up to you if that makes the story any less important…
1) Find as many years of raw data as I could to supplement the 2011 numbers I found yesterday, ignoring the council figures shown in the diagram
2) Sort all areas by pedal cycle casualty rates per 100,000
3) Score each area as per their position from 1 to 10, with anything greater scoring 10
4) Combine those scores to give a ranking
Here is the revised league of shame, using the full 2004-2011 data set:
- Kingston upon Hul
- Brighton & Hove
I found two inaccuracies in the Bournemouth Council table, compared to the National Statistics data: In 2004 Bournemouth ranked 4th not 7th and in 2010 4th not 5th.
If you really want the raw data sets to do your own number crunching:
Casualty rates per 100,000 raw data (xls)
Final crunched version of the numbers (xls)
Thanks to the National Archives and gov.uk