In the Media

London knife crime: how bad is it?

PUBLISHED April 12, 2012
SHARE

Only last week a fatal stabbing was reported from the Blackberry BBM party in London, yet data compiled by the Guardian shows that the highest rate of knife related crime recorded in the capital in the 2010-2011 financial year is still less than 0.5% of total crime for each area.

The highest number of murder knife victims (or otherwise where the weapon used was a "sharp instrument"), for 2010 and 2011 calendar years, was only six - in just two London boroughs.

As the chart below shows, in most London authorities the numbers of such deaths were on average between two and four. That being said, the figures for Southwark, where the stabbing took place just after a Jessie J concert, spiked from no homicide victims of knife crime in 2010 to six in 2011.

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0AtEm89sUNlM1dFlyMjkwQnA4ZUhyM1AtN2VZRmwtc1E&transpose=0&headers=1&range=B2%3AD29&gid=4&pub=1","options":{"series":{"1":{"color":"#a61c00"},"0":{"color":"#134f5c"}},"title":"Homicide victims of knife crime ","booleanRole":"certainty","useFormatFromData":true,"animation":{"duration":500},"legend":"bottom","hAxis":{"viewWindowMode":"pretty","viewWindow":{}},"isStacked":true,"width":480,"height":800},"state":{},"chartType":"BarChart","chartName":"Chart 5"} Roll over chart for data

In order to paint an accurate picture of knife crime across London we cross-referenced crime data from the Metropolitan Police's website with scraped knife crime figures from this freedom of information response also provided by the Met. The merged data shows the percent of stabbings in individual boroughs in the financial year 2010-2011.

Haringey recorded the highest rate of knife crime in London - which was still just 0.31% of the total levels of crime recorded for the area by the Met. Check the map below to see the rate of stabbings in each borough.

Fullscreen version

Visualised in Many Eyes the same data shows the number of stabbings by local authority for every month from January 2010 up to December 2011.

The full data is below - what can you do with it?

Data summary

London knife crime 2010-11

Click heading to sort table. Download this data

Local authority
Total reported crime
Knife crimes
% of all crime

SOURCE: METROPOLITAN POLICE

Barking & Dagenham 19,149 36 0.19
Barnet 25,670 31 0.12
Bexley 13,754 8 0.06
Brent 29,433 47 0.16
Bromley 22,002 23 0.1
Camden 34,168 26 0.08
Croydon 32,228 67 0.21
Ealing 34,973 54 0.15
Enfield 23,612 47 0.2
Greenwich 24,108 40 0.17
Hackney 27,999 68 0.24
Hammersmith & Fulham 24,147 34 0.14
Haringey 24,584 76 0.31
Harrow 14,956 25 0.17
Havering 17,575 29 0.17
Hillingdon 23,738 19 0.08
Hounslow 23,855 24 0.1
Islington 28,079 64 0.23
Kensington & Chelsea 21,136 16 0.08
Kingston upon Thames 11,144 11 0.1
Lambeth 35,636 93 0.26
Lewisham 28,864 60 0.21
Merton 14,716 27 0.18
Newham 34,338 74 0.22
Redbridge 24,486 27 0.11
Richmond Upon Thames 11,727 9 0.08
Southwark 36,196 78 0.22
Sutton 12,416 28 0.23
Tower Hamlets 28,579 38 0.13
Waltham Forest 27,525 37 0.13
Wandsworth 24,713 37 0.15
Westminster 63,934 39 0.06

Download the data

? DATA: download the full spreadsheet

NEW! Buy our book

? Facts are Sacred: the power of data (on Kindle)

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

CATEGORIES