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.
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?
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 |
? DATA: download the full spreadsheet
? Facts are Sacred: the power of data (on Kindle)
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