In the 2023/24 reporting year, the crime rate for Greater Manchester was 114.6 crimes per 1,000 population, a decline on the previous year, when the crime rate was at its highest for the recorded time period.

In the 2023/24 reporting year, Greater Manchester Police reported 333,630 crime offences, of which 129,184 were violence against the person offences, the most common type of crime in this reporting year.

In the 2024/25 reporting year, West Yorkshire Police reported a crime rate of 114.5 crimes per 1,000 population, the highest crime rate among the provided police force areas whose territories include large cities. Greater Manchester Police reported a crime rate of 108.2 crimes per 1,000 population and had the second-highest crime rate during this year.

Manchester, Gorton, Manchester full crime rankings and individual crime statistics updated monthly. See how safe Manchester, Gorton, Manchester is as well as all recent crimes.

Context

GreaterManchesterCrime.sql has 6 columns. The fields/columns are as follows CrimeID – this is a randomly generated text string to uniquely indentify each crime record, CrimeTS – this is the timestamp of the recorded crime or activity Location – this is the text description of the area in Greater Manchester where the crime occured, LSOA – this is text. Lower Layer Super Output Area (LSOA) is a GEOGRAPHIC AREA. Lower Layer Super Output Areas are a geographic hierarchy designed to improve the reporting of small area statistics in England and Wales, Type – this is text. It is the type or class of crime, Outcome – this is text. It is an indication of the outcome of the police investigation. TheGeom – this is the geographical location in WGS 84 (EPSG:4326) Longitude Latitude of where the crime was committed.

Content

GreaterManchesterCrime.sql is a geolocated listing of ALL crimes detected and investigated by the Greater Manchester Police Force in the United Kingdom, during August 2018.

Acknowledgements

https://data.police.uk/data/

Inspiration

It was my first class assignment and my first step towards spatial database learning. Hence I am sharing this data set and some sample questions for practice.

QUESTION 1: Write an SQL Query to find all of the crimes recorded in Greater Manchester in an LSOA containing the name Manchester and which occured in the final hour of August 2018. QUESTION 2: Look at the structure of the crimeid field in the database table. Write an SQL query to extract the following rows from the table where the first 3 blocks of the crimeid contain only alphabetical characters and the outcome contains the text 'no suspect identified'. QUESTION 3: The Old Trafford Football Stadium in Manchester has latitude,longitude (53.463056, -2.291389). Write an SQL query to return all of the rows (crimes) which are recorded less than or equal to 2000 meters of this exact coordinate position. You are encouraged to use UTM ESPG:32630 for the UK in your calculations. QUESTION 4: Manchester Picadilly is the largest railway station in Manchester. Coordinates (Lat, Lon): 53.477013,-2.229452. Unfortunately the area around the station is a particularly frequent location of crime. Write an SQL query which returns all of the rows (crimes) recorded within 2000 meters of this precise location. Only return rows which have the word 'theft' (case insensitive) in the crime type column.

In the 2023/24 reporting year, Greater Manchester Police reported 333,630 crime offences, compared with 369,853 in the previous year. During this time period, the number of crimes reported was highest in 2022/23.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Manchester Police Department (City) in Maryland, including incidents, statistics, demographics, and detailed incident information.

Manchester 059, Manchester full crime rankings and individual crime statistics updated monthly. See how safe Manchester 059, Manchester is as well as all recent crimes.

M13 0TW, Manchester full crime rankings and individual crime statistics updated monthly. See how safe M13 0TW, Manchester is as well as all recent crimes.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Manchester Police Department (City) in New Hampshire, including incidents, statistics, demographics, and detailed incident information.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Manchester Police Department (City) in Ohio, including incidents, statistics, demographics, and detailed incident information.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Manchester Police Department (City) in Kentucky, including incidents, statistics, demographics, and detailed incident information.

Fallowfield, Manchester full crime rankings and individual crime statistics updated monthly. See how safe Fallowfield, Manchester is as well as all recent crimes.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Manchester Police Department (City) in Connecticut, including incidents, statistics, demographics, and detailed incident information.

With approximately 122.1 crimes per 1,000 population, Cleveland, in North East England, had the highest crime rate of all the police force areas in England and Wales in 2024/25. High crime rates are evident in other areas of northern England, such as West Yorkshire and Greater Manchester at 114.5 and 108.2, respectively. In the UK capital, London, the crime rate was 105.5 per 1,000 people. The lowest crime rate in England was in the relatively rural areas of Wiltshire in South West England, as well as North Yorkshire. Overall crime in England and Wales The number of crimes in England and Wales reached approximately 6.74 million in 2022/23, falling slightly to 6.66 million in 2023/24, and 6.59 million in 2024/25. Overall crime has been rising steadily across England and Wales for almost a decade, even when adjusted for population rises. In 2022/23, for example, the crime rate in England and Wales was 93.6, the highest since 2006/07. When compared with the rest of the United Kingdom, England and Wales is something of an outlier, as crime rates for Scotland and Northern Ireland have not followed the same trajectory of rising crime. Additionally, there has been a sharp increase in violent crimes and sexual offences since the mid-2010s in England and Wales. While theft offences have generally been falling, the number of shoplifting offences reached a peak of 530,640 in 2024/25. Troubled justice system under pressure Alongside rising crime figures, many indicators also signal that the justice system is getting pushed to breaking point. The percentage of crimes that are solved in England and Wales was just 5.7 percent in 2023, with sexual offences having a clearance rate of just 3.6 percent. Crimes are also taking far longer than usual to pass through the justice system. In 2022, it took an average of 407 days for a crown court case to reach a conclusion from the time of the offence, compared with 233 days in 2018. This is most likely related to the large backlog of cases in crown courts, which reached over 67,750 in 2023. Furthermore, prisons in England and Wales are dangerously overcrowded, with the government even releasing some prisoners early to address the issue.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Manchester Police Department (City) in Vermont, including incidents, statistics, demographics, and detailed incident information.

In the 2023/24 reporting year, Greater Manchester Police reported 32 homicide offences, compared with 35 in the previous year. During this time period, the number of homicides reported was highest in 2016/17.

FBI National Incident-Based Reporting System (FBI NIBRS) crime data for Manchester Police Department (City) in Georgia, including incidents, statistics, demographics, and detailed incident information.