There are "lies, damned lies and crime statistics", as Alan Travis wrote for us. And the latest figures for England and Wales are out today.

For the first time, they're published by the Office for National Statistics (ONS) - here's the link - rather than the Home Office. The switchover hasn't done anything to make them any less opaque, however, and we'll have to wait for more detailed annual tables for 2011/12. These cover the figures up to the end of 2011. And the data shows that muggings and street robberies are up - despite an overall fall in crime.

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0AonYZs4MzlZbdFpWcW80ZU9LSDZvajlNS0JXX0UzVmc&transpose=1&headers=1&range=A4%3AI15&gid=22&pub=1","options":{"vAxes":[{"title":"Recorded crime","viewWindowMode":"pretty","viewWindow":{}},{"viewWindowMode":"pretty","viewWindow":{}}],"series":{"0":{"color":"#3d85c6"},"1":{"color":"#674ea7"},"2":{"color":"#351c75"},"3":{"color":"#e06666"},"4":{"color":"#e6b8af"},"5":{"color":"#dd7e6b"},"6":{"color":"#cc4125"},"7":{"color":"#a61c00"},"8":{"color":"#85200c"},"9":{"color":"#5b0f00"}},"title":"Crimes in England and Wales, 2011","booleanRole":"certainty","useFormatFromData":true,"legendTextStyle":{"color":"#222","fontSize":"9"},"animation":{"duration":500},"annotations":{"domain":{"style":"line"}},"hAxis":{"title":""},"isStacked":true,"width":460,"height":276},"state":{},"view":{"columns":[0,{"label":"","properties":{"role":"annotation"},"sourceColumn":1},2,3,4,5,6,7,8,9,10,11]},"chartType":"AreaChart","chartName":"Chart2"}

The key figures are:

? Total recorded crime fell from 4,159,553 to 4,043,339 - a fall of 3%
? Muggings and street robberies increased by 8% last year
? Violence against the person decreased by 7%
? Domestic burglaries dropped 3%
? Car thefts increased by 2%
? Separate figures from the Crime Survey for England and Wales (CSEW) - the new name for the British Crime Survey - showed "no statistically significant change in overall crime" with police recording 3% fewer incidents

British crime statistics are complicated partly because of double recording. Firstly, there are the official police figures (which historically under-record the true level of crime). Then there is the old British Crime Survey - now the Crime Survey for England and Wales - where 50,000 people are asked for their direct experiences of crime. This is regarded as the most authoritative of either.

There is more detailed data from the last set of crime figures, which were published by the Home Office previously.

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0AonYZs4MzlZbdFpWcW80ZU9LSDZvajlNS0JXX0UzVmc&transpose=0&headers=0&range=A9%3AB59&gid=9&pub=1","options":{"series":{"0":{"color":"#0b5394"}},"reverseCategories":false,"curveType":"","pointSize":0,"backgroundColor":"#FFFFFF","lineWidth":2,"logScale":false,"hasLabelsColumn":true,"hAxis":{"maxAlternations":1},"vAxes":[{"title":null,"minValue":null,"viewWindowMode":"pretty","viewWindow":{"min":null,"max":null},"maxValue":null},{"viewWindowMode":"pretty","viewWindow":{}}],"title":"Homicides recorded by police","interpolateNulls":false,"legend":"none","reverseAxis":false,"width":460,"height":276},"state":{},"view":"{"columns":[0,1]}","chartType":"LineChart","chartName":"Chart1"}

Murder statistics often confound received wisdom. Those figures showed:

? Of the 636 murders in 2010/11, the biggest single number used a sharp instrument, such as a knife, for the murder weapon
? The vast majority of child murder victims are killed by a parent - 36 out of 56. In total, 43 of those victims knew their murderer
? The same goes with total murders - 64% were known to their victim, 33% were friends
? 60% of murders are caused by a quarrel and loss of temper. Only 3% are as a result of theft or robbery

Alan Travis wrote that the riots last summer made little difference to the overall crime figures:

The Home Office said the August riots had only a small impact on the overall crime rate, partly because of the way the official counting rules operate. The official police figures link about 5,000 offences to the riots, including 184 incidents of violent disorder, but do not actually class any of them as riot

{"dataSourceUrl":"//spreadsheets.google.com/spreadsheet/tq?key=0AonYZs4MzlZbdFpWcW80ZU9LSDZvajlNS0JXX0UzVmc&transpose=0&headers=-1&range=E2%3AG13&gid=4&pub=1","options":{"reverseCategories":false,"backgroundColor":"#FFFFFF","pointSize":0,"vAxis":{"format":"#,##0"},"width":460,"logScale":false,"hasLabelsColumn":true,"hAxis":{"maxAlternation":1},"vAxes":[{"min":null,"title":"Offences","max":null,"minValue":0}],"title":"Total crime","height":276,"legend":"bottom","reverseAxis":false,"isStacked":false},"state":{},"chartType":"AreaChart","chartName":"Chart 2"} Roll over lines to get numbers

The police detection rate ? meaning that a suspect has been identified and interviewed and there is sufficient evidence to bring a charge ? remained at 28% in 2010/11. So, under a third of all crimes get solved.

Crime map of England in 2010/11. Click image to explore it

But one of the most interesting figures is about the perception of crime. The Crime Survey asks people whether they think crime is getting worse where they live and nationally. So, people think crime is getting worse - but not where they live. It's the perception gap between what we know is going on and what we think is going on. Or is that the Daily Mail gap?

{"dataSourceUrl":"//spreadsheets.google.com/spreadsheet/tq?key=0AonYZs4MzlZbdFpWcW80ZU9LSDZvajlNS0JXX0UzVmc&transpose=1&headers=1&range=A23%3AN25&gid=4&pub=1","options":{"reverseCategories":false,"backgroundColor":"#FFFFFF","pointSize":0,"vAxis":{"format":"#0"},"smoothLine":false,"lineWidth":2,"logScale":false,"hasLabelsColumn":true,"hAxis":{"maxAlternation":1},"vAxes":[{"min":null,"title":"% saying there is 'a little more' or 'a lot more' crime than two years ago","max":null,"minValue":0}],"title":"Is crime getting worse? Where I live and nationally","interpolateNulls":false,"legend":"bottom","reverseAxis":false,"width":460,"height":276},"state":{},"chartType":"LineChart","chartName":"Chart 3"} Roll over lines to get numbers

The report published last summer said that:

We've extracted the key tables for you below. What can you do with it?

Data summary

Crime by police force

Click heading to sort table. Download this data

Police force area, English regionand Wales
Total
Total , % change
Total , rate
Violenceagainsttheperson, rate
Sexoffen- ces, rate
Burglary, rate per 1,000 h'holds

Rate per 1,000 pop/householdsRates per 1,000 population / households

Recorded crime by police force area, English region and Wales, 12 months to December 2011

Cleveland 44,444 3 79 15 1.10 10.55
Durham 36,068 -1 59 11 0.76 6.31
Northumbria 77,527 -7 55 9 0.77 5.93
North East Region 158,039 -3 61 11 0.84 6.99
Cheshire 60,932 -6 61 12 0.79 7.61
Cumbria 26,646 -1 54 13 0.87 2.94
Greater Manchester 214,500 -6 82 15 1.07 14.81
Lancashire 99,665 -4 69 15 1.10 6.93
Merseyside 98,377 -2 73 11 0.97 12.74
North West Region 500,120 -4 73 14 1.00 10.84
Humberside 75,220 0 82 16 1.31 11.43
North Yorkshire 40,013 -3 50 9 0.74 5.77
South Yorkshire 102,145 -2 78 10 0.65 13.33
West Yorkshire 187,240 -1 84 12 0.88 20.74
Yorkshire and the Humber Region 404,618 -1 77 12 0.88 14.93
Derbyshire 63,034 -4 63 13 0.91 7.73
Leicestershire 68,410 -7 69 15 1.00 10.40
Lincolnshire 45,269 3 65 11 0.94 7.49
Northamptonshire 49,168 -3 72 15 1.11 8.54
Nottinghamshire 79,985 -7 74 14 0.95 9.99
East Midlands Region 305,866 -4 69 14 0.98 8.94
Staffordshire 66,367 -7 62 15 0.81 7.50
Warwickshire 33,972 6 63 10 0.89 9.94
West Mercia 71,058 -0 60 12 1.08 6.19
West Midlands 200,904 -7 76 14 1.03 15.34
West Midlands Region 372,301 -4 69 13 0.98 11.16
Bedfordshire 42,512 -1 70 14 0.60 13.59
Cambridgeshire 52,250 -9 67 12 0.92 8.82
Essex 105,641 3 61 12 0.87 9.40
Hertfordshire 63,898 -4 58 10 0.64 8.16
Norfolk 42,814 -0 50 11 1.05 4.20
Suffolk 45,974 -1 64 14 1.05 6.21
East of England Region 353,089 -2 61 12 0.85 8.31
London, City of 6,293 1 + + + +
Metropolitan Police 816,297 -1 105 20 1.34 19.54
London Region 822,590 -1 106 20 1.35 19.51
Hampshire 133,048 -0 71 17 1.06 6.87
Kent 102,904 -4 62 12 0.79 7.31
Surrey 63,440 -1 57 12 0.60 7.88
Sussex 96,813 1 62 12 0.96 4.61
Thames Valley 155,019 -11 70 13 0.92 10.34
South East Region 551,224 -4 65 13 0.89 7.52
Avon and Somerset 117,486 -2 73 16 1.07 8.21
Devon and Cornwall 89,613 3 54 13 1.08 5.63
Dorset 46,607 2 66 12 0.89 6.27
Gloucestershire 36,105 3 61 10 0.96 12.66
Wiltshire 35,907 -5 55 10 0.81 5.39
South West Region 325,718 0 62 13 1.01 7.26
ENGLAND 3,793,565 -3 73 14 0.99 11.04
Dyfed-Powys 21,317 -2 42 10 0.75 2.49
Gwent 41,481 -11 74 14 1.07 8.85
North Wales 42,869 2 63 16 0.95 5.93
South Wales 89,237 -7 71 14 0.75 8.00
WALES 194,904 -5 65 13 0.86 6.73
British Transport Police 54,870 -6        
ENGLAND AND WALES 4,043,339 -3 74 14 1.00 10.80

Download the data

? DATA: download the full spreadsheet

More open data

Data journalism and data visualisations from the Guardian

World government data

? Search the world's government data with our gateway

Development and aid data

? Search the world's global development data with our gateway

Can you do something with this data?

? Flickr Please post your visualisations and mash-ups on our Flickr group
??Contact us at data@guardian.co.uk

? Get the A-Z of data
? More at the Datastore directory

? Follow us on Twitter
? Like us on Facebook

0 comments… add one

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Skip to toolbar