ACT Crime Stats data - ready for people to analyse and mashup

At GovHack a few weeks ago my team, The Hack Warriors, wanted to integrate ACT crime data into our project 'Where Should I?'

While the ACT makes the data available visually in the awesome Crime Statistics site, it wasn't available as open data from data.act.gov.au.

So during the weekend I went through the code for the Crime Statistics site and (with a little help) identified where the data was coming from. I was able to download the actual Crime Stats data and process it into a spreadsheet with all the figures by suburb.

For reuse purposes I put the data up as a public Google Fusion table, which anyone can now access via a search of Fusion tables, or via the direct web address: https://www.google.com/fusiontables/DataSource?docid=1Cztgi-LF4CtXtS-EbU1M6JXnZAzPt1wLAH5YdXnN#rows:id=1

What this means is that now anyone who wants to mine the crime statistics for the ACT can do so easily using this table - performing statistical analysis or mashing it up with other data and mapping it easily.

Even better I found that while the ACT Crime Statistics site allowed people to see data back to 2010, the actual data went all the way back to 2007 - providing more historical data than is visually available from the site.

So if you want to play with the actual numbers behind the ACT's Crime Statistics site - you could start with the table below.