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

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, compared with 369,853 in the previous year. During this time period, the number of crimes reported was highest in 2022/23.

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.

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.

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.

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.

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.

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.

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.

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.

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 Vermont, including incidents, statistics, demographics, and detailed incident information.

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

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

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

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