Crime in Glasgow

Publisher

Glasgow Live

An in-depth look at crime across the city of Glasgow in Scotland from 2012-2017. This was a self-led project created for Glasgow Live (Reach PLC) and based on crime statistics from Police Scotland, which I requested under the Freedom of Information Act.

The graphic was made using CARTO’s map API and SQL to manage the data, and Leaflet, HTML, CSS, JavaScript and jQuery to visualise it.

My role
  • Research
  • Data collection
  • Data wrangling
  • Designer
  • Developer

Tools
  • CartoDB API
  • SQL
  • Leaflet
  • Microsoft Excel