What’s the most dangerous time of the week to be out on the roads? Are they getting safer or more dangerous? Do more accidents happen at low or high speed? The answers might surprise you...
With the rise of Open Data, government agencies around the world are releasing more and more information to the public. But for that data to be truly open, it needs to be released in a way that everyone can use, not just a few statisticians and experts with specialised tools.
Here’s just one example of open data usability issues.
The UK’s Department for Transport offers 35 years of road safety data for download on the data.gov.uk website. These records cover almost 8 million road traffic accidents, including every road fatality in Great Britain since 1979.
While the department is to be commended for making this resource available for anyone to download and use, it is a shame that the data is released as a series of huge CSV files, most of which are too big to open in Excel. Even if you can open these files, if you want to piece together the details, you need to match up a series of codes in one file with their descriptions in another...
In short: while the data is available, it’s really only available to expert statisticians, with specialist knowledge and tools.
The average member of the public would not even know where to start.
A Better Way...
We think there’s a better way.
We developed SuperWEB2 to allow organisations to disseminate data that anyone can use: with our browser-based solution anyone can start answering their own questions just by dragging and dropping the relevant variables onto a table. That’s true open data usability.
To see the difference, we took the department's data and loaded it into the SuperSTAR platform.
We immediately started to see patterns and insights. Here are just five insights we noticed from spending a few minutes with the data in SuperWEB2...
1. British Roads are Getting Safer, at a Remarkable Rate
Whatever the reason, be it safer cars, better roads, or successful anti-drink driving campaigns, British roads today are safer than they have ever been. There's been a dramatic drop in the total number of accidents, particularly since the turn of the century:
Road deaths show a similar trend, down from over 6,300 in 1979, to 1,793 in 2017:
2. Speed Kills
The vast majority of accidents occur on roads with 30mph speed limits:
But more deaths happen at 60mph:
3. Most Fatalities Happen in Good Conditions
Despite what you might expect, most road deaths happen on dry roads in good weather conditions:
4. The Overwhelming Majority of Road Deaths affect Young Males
Pedestrians killed on the roads are predominately men and women over the age of 75:
However, drivers, passengers and riders who die on the roads are disproportionately young and male:
Perhaps unsurprisingly, given that last statistic, drivers of vehicles involved in fatal accidents are overwhelmingly young and male too:
5. Friday Night is the Most Dangerous Time of the Week
Looking at road deaths by day of week, Fridays and Saturdays stand out:
And you might want to stay off the roads on Friday night, as it’s by far the most dangerous time of the week:
Want to Know More?
SuperWEB2 is a superior way to share data with any audience: allowing anyone to ask questions of the data, and visualise the results, simply by dragging and dropping.
Want to know more about what SuperWEB2 could do for your data? Get in touch today to see how we can help.