I don’t want to die – the numbers

Posted by Luke Williams on March 12, 2013 in general thoughts | 0 comments

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…

Method used:

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:

1. Portsmouth
2. Bournemouth
3. Kingston upon Hul
4. York
5. Peterborough
6. Bristol
7. Brighton & Hove
8. Manchester
9. Poole
10. Reading

NOTE:

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.

Data sets:

If you really want the raw data sets to do your own number crunching:

All raw data exports (zip)

Casualty rates per 100,000 raw data (xls)

Final crunched version of the numbers (xls)

Thanks to the National Archives and gov.uk