Recorded crime figures for CSP areas. Number of offences for the last two years, percentage change, and rates per 1,000 population for the latest year.

Police recorded crime figures by Police Force Area and Community Safety Partnership areas (which equate in the majority of instances, to local authorities).

Context:

Crime in major metropolitan areas, such as London, occurs in distinct patterns. This data covers the number of criminal reports by month, LSOA borough, and major/minor category from Jan 2008-Dec 2016.

Content:

13M rows containing counts of criminal reports by month, LSOA borough, and major/minor category.

Acknowledgements:

Txt file was pulled from Google Cloud Platform and converted to csv. Photo by James Sutton.

Inspiration:

Are there seasonal or time-of-week/day changes in crime occurrences? Any boroughs where particular crimes are increasing or decreasing? Policy makers use this data to plan upcoming budgets and deployment--can you use previous year crime reports to reliably predict later trends? If you normalize by borough population, can you find any areas where crime is more or less likely?

London Street-Level Crime Data (2024)

This dataset provides street-level crime data reported by the Metropolitan Police Service and the City of London Police from January to December 2024, sourced from the UK Government's open data portal data.police.uk.

It includes detailed records of crimes by type, location, police force, and outcome category, covering the entire London region.

📁 Features (9 Columns)

• Crime ID: Unique identifier for the crime report
• Month: Reporting month in YYYY-MM format
• Reported by: Police force (Metropolitan / City of London)
• Crime type: Category of crime (e.g., drugs, burglary)
• Last outcome category: Case outcome (e.g., investigation complete)
• LSOA name: Lower Super Output Area (small local area)
• Location: Approximate street or landmark
• Latitude, Longitude: Coordinates for mapping

🧠 Suggested Use Cases

• Create interactive crime heatmaps of London
• Analyse trends in crime types over time
• Compare borough-level crime levels
• Build predictive models to forecast crime volume
• Cluster high-crime zones using spatial ML

📌 Source

Original source: https://data.police.uk/data/

📄 License

This dataset is shared under the Open Government Licence v3.0.
Attribution: Contains public sector information licensed under the Open Government Licence v3.0.

Compiled and cleaned by @rahulladhani to support open ML exploration and public safety insights 🔍

Context

London is the capital and most populous city of England and the United Kingdom. Standing on the River Thames in the south east of the island of Great Britain, London has been a major settlement for two millennia. Source: https://en.wikipedia.org/wiki/London

Content

This data counts the number of crimes at two different geographic levels of London (LSOA and borough) by year, according to crime type. Includes data from 2008 to present. Crime categories are included in the BigQuery table description.

Fork this kernel to get started with this dataset.

Acknowledgements

https://data.london.gov.uk/

https://bigquery.cloud.google.com/dataset/bigquery-public-data:london_crime?_ga=2.189454959.-577194880.1523455401

https://console.cloud.google.com/marketplace/details/greater-london-authority/london-crime?filter=category:public-safety

This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source — http://www.data.gov/privacy-policy#data_policy — and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by Luca Micheli from Unplash.

Inspiration

What is the change in the number of crime incidents from 2011 to 2016?

What were the top 3 crimes per borough in 2016?

Part of Release: Official Sub-Ward, Ward and Borough level crime counts. Choose from the three data sets (‘Sub-Ward data’, ‘Ward data’ or ‘Borough data’) according to your requirements. This page contains the borough level data files Click here for corresponding LSOA level data: Recorded Crime Summary Data for London: LSOA Level Click here for corresponding ward level data: Recorded Crime Summary Data for London: Ward Level ‘Borough data’ counts the number of crimes in each Local Authority area of London per month, according to crime type. Use this data if you need to analyse crime data according to the location of geographic boroughs. The categories of crime counts within them may change from time to time. Below is a list of the crime types you can currently extract (only at borough or ward level): Minor Category: Major Category Murder: ViolenceAgainstThePerson CommonAssault: ViolenceAgainstThePerson OffensiveWeapon: ViolenceAgainstThePerson Harassment: ViolenceAgainstThePerson Otherviolence: ViolenceAgainstThePerson AssaultWithInjury: ViolenceAgainstThePerson WoundingGBH: ViolenceAgainstThePerson Rape: SexualOffences OtherSexual: SexualOffences PersonalProperty: Robbery BusinessProperty: Robbery BurglaryInADwelling: Burglary BurglaryInOtherBuildings: Burglary TheftOrTakingOfMotor: TheftAndHandling TheftFromMotor: TheftAndHandling MotorInterferenceAndTampering: TheftAndHandling TheftFromShops: TheftAndHandling TheftOrTakingOfPedalCycles: TheftAndHandling OtherTheftPerson: TheftAndHandling OtherTheft: TheftAndHandling HandlingStolenGoods: TheftAndHandling CountedPerVictim: FraudOrForgery OtherFraudAndForgery: FraudOrForgery CriminalDamageToADwelling: CriminalDamage CriminalDamageToOtherBldg: CriminalDamage CriminalDamageToMotor: CriminalDamage OtherCriminalDamage: CriminalDamage DrugTrafficking: Drugs PossessionOfDrugs: Drugs OtherDrugOffences: Drugs GoingEquipped: OtherNotifiableOffences OtherNotifiable: OtherNotifiableOffences Each row of data in the data sets contains: The number of incidents according to the Month Recorded, the specific crime type, and the Location The Month Recorded The broad crime type (Major HO category – eg Robbery) The specific crime type (Minor HO category – eg Robbery: Personal Property) The Location (Sub –Ward, Ward or borough depending on the data set selected)

Numbers of recorded offences, and rates of offences per thousand population, by broad crime grouping, by financial year and borough.

Rate is given as per thousand population, and are calculated using mid-year population from the first part of the financial year eg For Financial year 2008-09, mid-year estimates for 2008 are used.

Offences: These are confirmed reports of crimes being committed. All data relates to "notifiable offences" - which are designated categories of crimes that all police forces in England and Wales are required to report to the Home Office
Crime rates are not available for Heathrow due to no population figures

Monthly crime data by borough and ward is available from the Met Police website, available around one month after month end.

The total number of recorded crimes per month is also shown. A fuller breakdown by 32 different types of crime is available on the MPS website.

There were changes to the police recorded crime classifications from April 2012. Therefore caution should be used when comparing sub-groups of crime figures from 2012/13 with earlier years.

Action Fraud have taken over the recording of fraud offences on behalf of individual police forces. This process began in April 2011 and was rolled out to all police forces by March 2013. Due to this change caution should be applied when comparing data over this transitional period and with earlier years.

Link to data on Met Police website.

Crime stats on ONS website

Total Notifiable Offence (TNO) data follows the Home Office counting rules for recorded crime (https://www.gov.uk/government/publications/counting-rules-for-recorded-crime ). NB This data-set includes “Other Accepted Crime”, which are non-notifiable crimes and must be excluded when calculating a TNO total.

Source: Metropolitan Police Service via London Datastore Original data: https://data.london.gov.uk/dataset/mps-monthly-crime-dahboard-data/ License: UK Open Government Licence v3.0 (https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/)

As part of the quarterly release of Crime data and trends by the Office for National Statistics, data is released aggregated at police force level for the most recent rolling 12 months. The below interactive infographic allows you to click through the key crime indicators assessed to see how London (the Metropolitan Police Service) is performing compared to the rest of the country (using the same data from 12 months previously). Also included are the key performing London boroughs in each indicator during the period covered.

This data counts the number of crimes at three different geographic levels of London (borough, ward, LSOA) per month, according to crime type. Data is available in two files for each level of geography - the most up to date data covering the last available 24 months only and one covering all historic full calendar years. In March 2019, the Metropolitan Police Service started to provide offences grouped by the updated Home Office crime classifications . This currently only covers the most recent 24 months of data, but historic data using the previous categories is available separately back to January 2008. Below is a list of the crime types covered under the new HO categories (not available at LSOA level): Major Category: Minor Category Arson and Criminal Damage - Arson / Criminal Damage Burglary: Burglary - Business and Community / Burglary - Residential Drug Offences: Drug Trafficking / Possession of Drugs Miscellaneous Crimes Against Society: Absconding from Lawful Custody / Bail Offences / Bigamy / Concealing an Infant Death Close to Birth / Dangerous Driving / Disclosure, Obstruction, False or Misleading State / Exploitation of Prostitution / Forgery or Use of Drug Prescription / Fraud or Forgery Associated with Driver Records / Going Equipped for Stealing / Handling Stolen Goods / Making, Supplying or Possessing Articles for use i / Obscene Publications / Offender Management Act / Other Forgery / Other Notifiable Offences / Perjury / Perverting Course of Justice / Possession of False Documents / Profitting From or Concealing Proceeds of Crime / Soliciting for Prostitution / Threat or Possession With Intent to Commit Crimina / Wildlife Crime Possession of Weapons: Other Firearm Offences / Possession of Firearm with Intent / Possession of Firearms Offences / Possession of Other Weapon / Possession of Article with Blade or Point

Raw data on crime supplied by the Metropolitan Police Service and the Mayors Office for Policing and Crime (MOPAC). Pan-London data includes: - Total Notifiable Offences - Total Victim-based crime (and Sanctioned Detection Rates) - Violence against the Person - Violence with injury (VWI) (and SDR) - Serious Youth Violence - Female victims of robbery & Violence with Injury - Rape - Knife Crime (and SDR) - Knife Crime with Injury - Gun Crime (and SDR) - Gun Crime with firearm discharged - Gang violence indicator - Dog Attacks (and SDR) - Homicide - Sexual Offences - Burglary (all) - Burglary (residential) - Robbery (all) - Theft & Handling - Theft from Person - Theft of Motor Vehicle - Theft from Motor Vehicle - Criminal Damage - Domestic Offences - Homophobic Hate Victims - Racist & Religious Hate Victims - Faith Hate Victims - Disability Hate Victims - Stop & Search Totals (and related Arrest rate) - Police Strengths - Officer/Sergeant/Staff/Special Constable/PCSO - Satisfaction/Confidence in the Metropolitan Police Service (ease of contact/satisfaction with action taken/well-informed/fairly treated/overall satisfaction/overall confidence) NB. Quarterly data - Crime-related calls to Police by category - Anti-Social Behaviour-related calls to Police by category Borough data includes: - Fear of crime ("to what extent are you worried about crime in this area?") NB. Quarterly data NB. Action Fraud have taken over the recording of fraud offences nationally on behalf of individual police forces. This process began in April 2011 and was rolled out to all police forces by March 2013. Data for Greater London is available from Action Fraud here .

This dataset contains on street crimes provided by the Police via their API (https://data.police.uk/docs/). The data is clipped to the London Borough of Camden boundary, and can contain up to fifteen types of street crime including bicycle theft, shoplifting and criminal damage. The London Borough of Camden does not maintain the content of this dataset.

Crime Rates of offences per thousand population, by broad crime grouping, by financial year for wards. Offences: These are confirmed reports of crimes being committed. All data relates to "notifiable offences" - which are designated categories of crimes that all police forces in England and Wales are required to report to the Home Office. Ward data should not be aggregated to give a borough or London total. This is because a small percentage (less than 5%) of crimes in this dataset have not been geocoded to a ward. Therefore total numbers and rates are indicative only, and are not an exact measure at ward level. The rate is calculated using ward GLA 2012-based (SHLAA) population projections, and population data calculated and constrained to 2012 Borough (SHLAA) projections. The London figure only includes the Met Police area, not the City of London. The London total includes all offences in the Met Police Area including those that could not be geocoded. Therefore the London total will not equal the sum of the wards. Some ward boundaries changed in 2014. From 2013/14 the data shown is for the new boundaries. This only affects Hackney, Kensington and Chelsea, and Tower Hamlets. From 2013/14, the numbers and rates for 2013 ward boundaries in Hackney, K&C and Tower Hamlets, have all been modelled based on the proportion of population living in each area at the 2011 Census. Action Fraud have taken over the recording of fraud offences on behalf of individual police forces. This process began in April 2011 and was rolled out to all police forces by March 2013. Due to this change caution should be applied when comparing data over this transitional period and with earlier years. Data by detailed crime group and month are available from the MPS website .

This data counts the number of crimes at two different geographic levels of London (LSOA and borough) by year, according to crime type. Includes data from 2008 to present. Crime categories are included in the BigQuery table description. This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery .

Context

Wanted to understand how law enforcement agency handle crime in global cities such as London. Thanks to their open source data policy for providing the dataset which analysis in turns helps in deriving valuable inferences which can be applicable across the globe.

Content

This dataset pertains to crimes being reported to Metropolitan Police over January 2020. It contains more than 90,000 rows (crimes reported) with 12 columns giving details related to each crime.

The 12 columns associated with crimes being reported are -

• Crime ID
• Month
• Reported by
• Falls Within
• Longitude
• Latitude
• Location
• LSOA code
• LSOA name
• Crime type
• Last outcome category
• Context

This dataset entries as well as the file format has not been altered.

Acknowledgements

I want to thanks UK government open source data policy for providing this dataset. This dataset has been derived from UK Police https://data.police.uk/data/ Also, thanks to the amazing notebook format created by Justinas Cirtautas on House price in London from which I learnt how to better make easy to navigate notebook.

Cover photo by Oliver Hale

Inspiration

Looking forward to do supervised learning with this dataset over how the crime as one of the parameter effects housing prices over boroughs in London.

The data used in the in the Annual Crime Statistics 2022 - 23 Dashboard is available here: 2022 - 2023 crime statistics | Metropolitan Police, along with the related data definitions. Please note that, this data sets is updated on the 4th of each April. Last extraction occurred April 2023.

Total Notifiable Offence (TNO) data follows the Home Office counting rules for recorded crime (https://www.gov.uk/government/publications/counting-rules-for-recorded-crime ).

The “Other Crime” offence data follows the Home Office counting rules but have been grouped by specific features (e.g. Hate Crime): please see dashboard for definitions.

Measures include Offences, Sanction Detections, and the Sanction Detection Rate (total number of sanction detections divided by the total number of offences in a given period).

All data is broken down by financial year for each crime type, and can be filtered by Basic Command Unit (BCU) and Borough. NB: The Borough shown is the ‘investigating’ Borough not necessarily the Borough where the offence occurred.

Due to an internal IT deployment, from 27th February these datasets may be temporarily disrupted. Work is ongoing to rebuild these datasets.

There were 26,803 police recorded sexual offences in London in 2024/25, compared with 24,334 in the previous reporting year, with a peak for sexual offences occurring in the most recent reporting year.

The report looks into the various drivers of social exclusion amongst older people (although many of these indicators are equally relevant amongst all age groups) and attempts to identify areas in London where susceptibility is particularly high. Six key drivers have been included with various indicators used in an attempt to measure these. The majority of these indicators are at Lower Super Output Area (LSOA) level in an effort to identify areas at as small a geography as possible. Key Driver Indicator Description Economic Situation Income deprivation Income Deprivation Affecting Older People Score from the 2015 Indices of Deprivation Transport Accessibility Public Transport Average Public Transport Accessibility Score Car access Percentage aged 65 and over with no cars or vans in household Household Ties One person households Percentage aged 65+ living alone Providing unpaid care Percentage aged 65+ providing 50 or more hours of unpaid care a week Neighbourhood Ties Proficiency in English Percent aged 65+ who cannot speak English well Churn Rate Churn Rate: (inflow+outflow) per 100 population Health Mental health Estimated prevalence of dementia amongst population aged 65 and over (%) General health Percentage aged 65+ with a limiting long-term health problem or disability Safety Fear of crime Percentage in borough worried about anti-social behaviour in area Percentage in borough who feel unsafe walking alone after dark Crime rates Total offences per 100 population