I don’t want to die – the numbers

Posted by 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

0 Comments

Trackbacks/Pingbacks

  1. I don’t want to die | aLUKEonLIFE - [...] 2) I’ve done a deeper analysis on the original data and technically Bournemouth comes second to Portsmouth – see…

Leave a Comment

Your email address will not be published. Required fields are marked *