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.
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 |
? 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