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 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.

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

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.

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.

Manchester 049, Trafford full crime rankings and individual crime statistics updated monthly. See how safe Manchester 049, Trafford 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.

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.

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.

London had the highest crime rate among regions of the United Kingdom in 2024/25, at approximately ***** crimes per 1,000 population, followed by Yorkshire and the Humber, at ***** crimes per 1,000 people. On a more local level, the police force area with the highest crime rate in England and Wales was that of Cleveland, in North East England. Although London had the fifth-highest crime rate among police force areas, it was lower than the crime rates of the West Yorkshire, Greater Manchester, and South Yorkshire police force areas as well. Is crime in the UK rising? Between the early 2000s and the mid-2010s, crime in the UK declined quite significantly. The crime rates of England and Wales, Scotland, and Northern Ireland all fell during this time period. From around 2013/14, however the crime rate in England and Wales began to rise again, approaching levels seen in the 2000s. In Scotland and Northern Ireland crime also stopped declining at the same rate, although there was no sudden increase as seen in England and Wales. Without adjusting for population-size, the overall number of crimes recorded by the police in England and Wales reached a peak of around 6.74 million offences in 2022/23, falling slightly in the two years since then. What kinds of crime are increasing? Although overall crime levels have increased, some types of crime have continued to decline. Overall theft offences for example, are far lower than in the 2000s. This is partly due to the decline in burglaries, and vehicle theft offences. Shoplifting offences, by contrast have spiked since the COVID-19 pandemic, reaching a peak of over ******* offences in 2024/25. Additionally, the number of violence against the person offences surged from 2014/15 onwards, with the number of sexual offences also at far higher levels than in the recent past.

M40 9WL, Salford full crime rankings and individual crime statistics updated monthly. See how safe M40 9WL, Salford is as well as all recent crimes.

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

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

The crime rate in London was 106.4 crime offences per thousand people for the 2024/25 reporting year, compared with 105.8 in the previous year. Between 2015/16 and 2019/20, the crime rate in the UK capital increased in every reporting year. The sudden drop in 2019/20 was due to the COVID-19 pandemic causing a sharp reduction in certain types of crime, such as robbery and theft. Crime patterns in the capital Overall there were 951,803 crimes reported by the police in London in 2024/25, compared with 938,020 in the previous reporting year. Types of crime that have increased recently include violent crimes, shoplifting, and theft from the person offences. One positive is that the number of homicide offences in London has fallen to much lower levels than seen in the late 2010s. Additionally, the Metropolitan Police force area has a lower crime rate than many of the UK's other major police forces, such as West Yorkshire, Greater Manchester, and South Yorkshire. Police recruitment drive ends era of cuts  The rise in crime in London happened alongside a decline in both personnel and funding for the London Metropolitan Police. Compared with 2010 for example, there were around 3,000 fewer police officers in 2018, while annual funding was reduced to around 3.3 billion pounds between 2013/14 and 2018/19, compared with 3.62 billion in 2012/13. These cuts were due to the policy of austerity that was implemented by the UK government during that time period, but this has recently been replaced by pledges to increase spending and to recruit more police. In 2024/25, the budget for the Metropolitan Police was over five billion pounds, while the number of officers in 2024 increased to around 35,310.

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

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

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

M15 6LR, Manchester property and local residence statistical data. View in-depth data for M15 6LR & surrounding areas.