Here's something curious. Using the Department for Transport's road accident statistics for 2006, I calculated road accident severity figures for each county in England. The DfT's accident figures include a Killed-and-Seriously-Injured (KSI) statistic, which is the count of the most serious road injuries: those leading to... well, death or serious injury. For each county, I divided the number of road accidents with a KSI outcome by the total number of recorded accidents. The reasoning was that the higher this ratio is, the more severe the outcomes of that county's road collisions tend to be and, in one sense, the more dangerous that county's roads are.
The statistics I computed gave figures ranging from just 5.6% of road accidents having KSI outcomes (in Plymouth, where it seems most road accidents tend to end okay) to 23.7% (in North Yorkshire, where almost one-quarter of all road accidents lead to someone being killed or seriously injured). I then normalized these values to lie on a scale from 1 to 100, converted these into saturation levels of the colour red and filled in the counties on a map. Yes, it took a few hours.
The map reveals a few points of interest:
* We have to work in call centres, but at least we don't get squashed too badly - Former heavy industrial areas around Manchester, Merseyside, the West Midlands and the Potteries stand out as having quite low accident severities.
* Leafy suburbs, dead bodies - the affluent south-western corner of Greater London suffers quite a lot of serious road accidents. It's so tempting to make a link to all the SUVs...
* Mad Crazy Viking Berserkers - North Yorkshire and the East Riding. One in four road accidents in North Yorkshire has a serious outcome. My father lives there. I'd like him to move away now.
* Wiltshire and Northamptonshire are really dangerous - I live in Wiltshire! Can everybody take more care please?
* Odd pockets of safety - Plymouth wins here, but there are other counties that stand out from their neighbours: Surrey, Rotherham, Newham in London.
Sadly, these statistics aren't broken down by county for Wales and Scotland. However, overall Wales is at a similar level to Southampton and Coventry, with just under 11% of road accidents having a KSI outcome. Scotland is somewhat worse, and with 17% of all road accidents ending in death or serious injury is similar to Essex and East Sussex.
My hope in doing this was that novel insights might reveal themselves if I looked at the accident data in a new way. I wondered if there would be a North/South split, or patterns that follow motorways. Perhaps the most striking thing to emerge here is the suggestion of more serious road accidents in rural areas. (Most notably, wherever there is a city that has separate figures from the county that surrounds it -- Reading in Berkshire, Leicester in Leicestershire, Poole in Dorset -- the city always has a lower accident severity score than the surrounding county.) This seems on the face of it to support the idea that higher levels of road crowding and reduced speeds are good for reducing the severity of road accidents, although we must also consider other factors specific to rural areas such as twistier roads which give poorer visibility, and possibly higher levels of drink-driving. But then we have to explain why Devon and Cornwall -- perhaps the most rural and twisty-roaded counties -- aren't particularly bad.
Like all good data explorations, this raises more questions than it answers, but I think it shows the value of looking at data in novel ways.