In the lead-up to the London mayoral elections the datablog has analysed figures on a series of London's key socioeconomic indicators.

This comprehensive analysis of crime statistics shows that while crime has fallen across the capital as a whole in the last decade there are a number of interesting sub-trends.

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0AuZLaKQQs5xpdHl5RVcyNXVRMFoteENGTkV3TXVDdnc&transpose=0&headers=1&merge=COLS&range=A1%3AA10%2CP1%3AP10&gid=3&pub=1","options":{"vAxes":[{"title":"Crimes per 1000 people","minValue":0,"viewWindowMode":"pretty","viewWindow":{"min":0,"max":null},"maxValue":null},{"viewWindowMode":"pretty","viewWindow":{}}],"curveType":"","booleanRole":"certainty","title":"Total of all crimes per 1000 people, London","useFormatFromData":true,"height":276,"animation":{"duration":500},"legend":"none","width":460,"vAxis":{"format":""},"lineWidth":2,"hAxis":{"title":"Year","slantedTextAngle":30,"slantedText":true}},"state":{},"chartType":"LineChart","chartName":"Chart2"} Annual crime rate for London as a whole. Click here for the full size chart.

The chart above shows this general downward trend in crime rates, where the number of recorded crimes per 1,000 of London's inhabitants has fallen by almost a third over the last nine years. In 2002/03 the figure stood at 151.6, but the most recently available figure - for 2010/11 - has dropped to 106.9.

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0AuZLaKQQs5xpdHl5RVcyNXVRMFoteENGTkV3TXVDdnc&transpose=0&headers=1&range=A1%3AO10&gid=3&pub=1","options":{"series":{"0":{"lineWidth":2}},"curveType":"","legendTextStyle":{"color":"#222","fontSize":"8"},"animation":{"duration":500},"vAxis":{"format":""},"width":460,"lineWidth":2,"hAxis":{"title":"Year","slantedTextAngle":30,"slantedText":true,"textStyle":{"color":"#222","fontSize":"12"}},"vAxes":[{"title":"Crimes per 1000 people","minValue":null,"viewWindowMode":"pretty","viewWindow":{"min":null,"max":null},"maxValue":null},{"viewWindowMode":"pretty","viewWindow":{}}],"booleanRole":"certainty","title":"Offences per 1000 people, London","useFormatFromData":true,"height":276},"state":{},"chartType":"LineChart","chartName":"Chart1"} Crime rates for different offences, London as a whole. Click here for the full size chart.

Trends in the rates of different crimes; however, have varied. While violence against the person has seen an overall drop from 25 instances per 1000 people in 2002/03 to 21.5 in 2010/11, the rate of drug offences has risen by 75% over the same period, from 4.7 to 8.3.

Instances of theft against a vehicle saw the most dramatic fall over the nine years studied, the most recent figure standing at just over half of what it was in 2002/3.

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0AuZLaKQQs5xpdHl5RVcyNXVRMFoteENGTkV3TXVDdnc&transpose=1&headers=1&range=A1%3AL33&gid=23&pub=1","options":{"vAxes":[{"title":"Crimes per 1000 people","viewWindowMode":"pretty","viewWindow":{"max":null},"maxValue":null},{"viewWindowMode":"pretty","viewWindow":{}}],"title":"Crimes per 1000 people, by borough","curveType":"","booleanRole":"certainty","useFormatFromData":true,"height":750,"legendTextStyle":{"color":"#222","fontSize":"8"},"animation":{"duration":500},"width":460,"lineWidth":2,"hAxis":{"title":"Financial year","slantedTextAngle":30,"slantedText":true,"textStyle":{"color":"#222","fontSize":"10"}}},"state":{},"chartType":"LineChart","chartName":"Chart3"} Annual crime rates by borough, 2011/12. The trendline for the City of London has been excluded as it distorts the chart's appearance. Click here for the full size chart.

Exploring the data on a regional basis also yields interesting results. Three Boroughs - Camden, the City of London and Westminster have seen reductions of 40% or more in overall crime rate between 2000/01 and 2010/11.

By contrast, the crime rate in Tower Hamlets has increased by 5% over the same period, from 116.6 to 122.7 per 1000 people. Lewisham fared only marginally better, with the equivalent figure dropping by under 2%.

Overall crime rates rose for for ten boroughs over the most recently available year-on-year period - between the 2009/10 and 2010/11 financial years - with Hammersmith & Fulham witnessing the largest increase.

While the figures for Westminster may appear startlingly high, this can be explained in part by the difference between its day- and night-time populations. The borough has disproportionately high numbers of visitors during the day compared to its numbers of permanent residents, meaning crime rates measured by population are skewed upwards.

Data for the most recent financial year (see below) is missing figures for March 2012, but to-date Westminster has the highest crime rate by a large margin. The borough's figure for theft & handling offences dwarfs the corresponding statistic of any other borough for which data is available*.

* This particular set of figures is from the Metropolitan Police, and as a result does not include data for the City of London, where crime rates measured against population tend to be much higher than any other borough.

Data summary

2011/12 offence rate by borough

Click heading to sort

 
Violence Against The Person
Sexual Offences
Robbery
Burglary
Theft & Handling
Fraud & Forgery
Criminal Damage
Drug offences
Other Offences

Source: Metropolitan Police

Barking & Dagenham 21.05 1.38 5.3 12.11 31.58 6.24 10.58 5.32 1.84
Barnet 10.89 0.79 3.04 12.86 26.34 4.87 6.33 2.83 0.7
Bexley 11.02 0.66 1.28 5.99 15.81 2.57 6.7 3.64 0.64
Brent 26.2 1.2 7.88 14.05 32.01 5.08 8.53 16.23 1.6
Bromley 13.55 0.73 2.09 9.85 22.6 4.2 7.69 3.06 0.59
Camden 21.71 1.47 5.5 12.93 73.03 4.25 8.29 10.47 1.33
Croydon 17.64 1.29 4.76 12.1 28.94 4.95 9.43 6.47 1.13
Ealing 20.44 1.18 4.26 11.11 32.69 6.49 8.86 6.8 1.66
Enfield 12.75 0.83 3.35 10.86 24.75 4.21 8.11 4.61 1.15
Greenwich 21.27 1.48 3.09 10.52 31.12 5.02 10.96 5.19 1.45
Hackney 22.31 1.57 4.98 9.17 52.94 3.31 8.8 10.62 1.33
Hammersmith & Fulham 23.29 1.04 4.34 12.55 60.64 4.11 9.5 8.52 2.05
Haringey 19.14 1.33 6.12 14.7 39.41 4.89 11.25 6.71 1.01
Harrow 11.27 0.69 2.82 10.67 17.77 3.31 5.82 2.65 0.86
Havering 12.68 0.77 1.97 11.02 24.9 3.25 7.15 3.8 0.9
Hillingdon 18.55 0.94 3.19 13.1 28.26 3.15 9.32 4.9 1.07
Hounslow 21.53 1.06 2.66 11.06 34.53 5.48 10.49 6.86 1.6
Islington 23.81 1.31 5.71 13.46 59.62 3.15 9.73 7.76 1.71
Kensington & Chelsea 14.87 1 3.25 8.75 63.96 4.1 6.36 8.15 0.91
Kingston upon Thames 12.05 0.88 1.36 7.15 25.47 3.09 6.4 3.61 0.73
Lambeth 23.03 1.67 9.99 12.27 47.02 3.89 9.81 9.87 1.34
Lewisham 21.51 1.52 5.39 11.1 29.64 5.83 10.08 6.43 1.4
Merton 11.02 0.85 2.92 9.85 22.58 2.63 7.28 4.27 0.45
Newham 24.36 1.67 9.4 12.05 47.02 6.35 9.85 8.09 1.54
Redbridge 12.89 0.96 3.95 12.09 30.37 4.94 7.97 7.66 1
Richmond upon Thames 9.33 0.8 1.07 9.84 23.38 2.93 6.68 2.73 0.54
Southwark 21.07 1.61 7.82 11.23 43.33 2.85 9.8 10.67 1.61
Sutton 11.29 0.98 1.49 7.39 21.43 1.91 7.57 2.49 0.43
Tower Hamlets 22.34 1.66 5.41 10.57 42.49 5.27 9.46 14.45 1.66
Waltham Forest 19.79 1.33 6.9 12.8 39.17 4.62 9.39 4.88 1.09
Wandsworth 12.91 1.04 3.84 9.76 33.89 2.86 7.08 3.17 0.96
Westminster 30.11 2.13 7.45 12.07 141.81 8.06 8.68 24.24 2.84

Download the data

? DATA: download the full spreadsheet

More 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