In the Media

Five years of London murder victims listed

PUBLISHED October 5, 2011

Over 800 murder victims in the capital have been detailed as part of a huge FoI release. Get the full list here ? Get the data ? Interactive: the murder map of London's boroughs The Metropolitan Police is pretty active with its Freedom of Information releases - releasing hundreds of datasets each year which shine a light on crime in London. And this dataset is one of the most compelling of all: a list of every murder case since 2006 . There are 837 murders detailed here, with date, age of the victim and the London borough in which they died. The UK has around 600 murders a year, and the capital annually accounts for 100 to 150 of those. The data itself is messy - it comes as a PDF, which is watermarked and locked, to make copying as difficult as possible. But, thanks to John Houston, we can help you access it (and to the awesome @foimonkey for bringing it to our attention). It shows what many crime experts fear: murders victims in London tend to be young: 433 were under 30 with nearly 200 of those under the age of 21. The worst two boroughs for murders are also two of London's poorest: Lambeth and Newham. Most of these cases end up with someone in court and a conviction. For a minority - 124 - there is still no resolution. That might sound like a lot but sanction detection rates (an investigation resulting in a conviction or some other penalty) are nationally at 83% for murder, so the Met is just above that. The full data is below . Data summary Download the data ? DATA: download the full spreadsheet 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 ? Get the A-Z of data ? More at the Datastore directory ? Follow us on Twitter ? Like us on Facebook Crime Police Freedom of information Free our data Simon Rogers © 2011 Guardian News and Media Limited or its affiliated companies. All rights reserved. | Use of this content is subject to our Terms & Conditions | More Feeds