Data / Interactive / Journalism

Which London stations are the worst for crime?

In December I was very pleased to have the results of my FOI project, part of my MA at City University, published in The Mail on Sunday. I sent a Freedom of Information request to the British Transport Police requesting data regarding crime on the tube, trains, and stations all across London. The finished piece can be viewed here.

The data found that First Great Western had the most amount of crime on their trains – with 1,179 reported crimes in 2013. The article also broke down the figures into number of crimes per passenger journey – which found that East Coast trains were the worst.

I want to revisit part of the data that was not used a huge amount in the piece – the amount of crime occurring at London overground and underground stations. I decided to look at the figures of total reported crimes between 2010 and 2013 YTD  – in order to see what stations had the worst amount of crime over 3 years.

Worst ten stations for crime 2010 – 2013

Reported crime at stationsHowever, I also wanted to combine this data with the numbers of visitors at the stations – are the stations that are the worst for crime also the busiest stations?

Thankfully, the Office of Rail Regulation release data regarding the number of passengers at stations. The latest figures are based on ticket sales from the financial year 2011-12 – although granted, they are only estimates.

I decided to use Google Fusion Tables to map the top 30 worst stations across London, at the same time informing viewers the passenger numbers per station (although unfortunately there was not data on all the stations).

Google Fusion Tables

Using the bucket function in Google Fusion Tables, I divided the ranges into red or green – to easily show which stations were the worst for crime. I want your opinion on this, would this be better displayed with larger icons and different colours, perhaps yellow and red instead? (Update: I have now removed this element, as I feel it may make the visualisation too distracting).

London Bridge

I’d like to include all of the stations, but given that I have data on 706 this may take a while – watch this space! For now, the visualisation can be viewed here.

UPDATE: I have now added all 706 stations to the visualisation and the updated version is live here

London station crime Google Fusion Tables

All London stations have been mapped with the latest crime figures

I managed to find the longitude and latitude data for all the London stations through a Google Table SearchThe data was available on Doodal.

As the BTP only provided me with the statistics and the name of the station, I then used VLOOKUP in Excel to quickly add the longitude and latitude of each station. Then I simply uploaded the spreadsheet again to Google Fusion Tables.

What do you think of this visualisation? What would you change about it?

Advertisements

4 thoughts on “Which London stations are the worst for crime?

  1. Why don’t you divide the number of journeys (ticket sales) by the number of crimes this would give you a better comparative idea of how bad the crime is per station, ie Victoria (76,231,290 Tickets / 3930 crimes) = 19,397 Tickets sold per crime, Waterloo (94,045,510 Tickets / 2619 crimes) = 35,908 Tickets sold per crime or a much safer station

  2. Why don’t you divide the number of journeys (ticket sales) by the number of crimes this would give you a better comparative idea of how bad the crime is per station, ie Victoria (76,231,290 Tickets / 3930 crimes) = 19,397 Tickets sold per crime, Waterloo (94,045,510 Tickets / 2619 crimes) = 35,908 Tickets sold per crime or a much safer station

  3. Pingback: Extra, Extra | Londonist

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s