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?
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 |
? DATA: download the full spreadsheet
Data journalism and data visualisations from the Guardian
? Search the world's government data with our gateway
? Search the world's global development data with our gateway
? 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