- Go to data.gov.uk
- Look at the most recently uploaded dataset
- Happens to be Local police recorded crime data, a breakdown force by force, offence type by offence from 1 March, 2002 until 1 March 2010 or thereabouts.
- Download the .csv
- Open the .csv
- Filter the data by Offence Group (in this case Drug Offences)
- No need to filter the data by Offence Sub-Group in this case, but you can
- C & P out into another Excel tab the Offence data
- Filter the data byYear (in this case 12 months to 1 March, 2003)
- C & P out into another Excel tab the years data (still only showing drug offences)
- Delete 12 months to column
- Delete Region Name column
- Delete Offence Group column
- Delete Offence Sub-Group column
- Highlight the two remaining columns and all data
- Create a graph
- Make the graph look pretty
- Upload it to ScribD
- Embed it in your blog
Crime Stats From Datadotgovdotuk
You might need to download the spreadsheet or view it over at ScribD - I'm on a 10" netpad and it's not so great at displaying things properly.
This is why data.gov.uk is one of the best websites on the internet. This is why open data is a wonderful thing. This is what can be done when youn open up your data. When I've got more time, I'll cross reference this info with population info of each of the areas the forces cover. Then I might look at deprivation indices inside those areas. Or possibly, you know, someone else might who can make the data look prettier because, after all, this was a 15 minutes job. This is not me showing off. This is merely a 'this is what is possible in 15 minutes'.
My father always told me curiosity killed the cat. No it doesn't. It opens up whole new worlds of information and it kills no one to stick it in a .csv and give it to people like me to play with.