FOI 0907-2024/25 Hate Crimes

Request
Q1. A Dataset (.ods, .csv or .xlsx) containing all police recorded hate crime offences recorded by the North Yorkshire police force in the financial year(s) 2016/17 and 2017/18 disaggregated by

i)Comunity Safety Partnership (CSP) area,
ii) motivating factor and
iii) month.

I.e. every row should show the total number of hate crimes commited by a certain motivating factor in a certain month in a certain CSP area. The motivating factors covered should include "Disability", "Race", "Sexual Orientation", "Religion" and "Transgender Identity".

I am formulating these very detailed specifications as this is the data structure provided to us by the Home Office (containing the columns "Financial Year",  "Calendar Month" , "Police Force", "Name", "CSP Name", "Motivating Factor", "Offence Count") and it is vital to our research that the data we are requesting from you corresponds with it. 

Alternatively, should this make it easier for you to handle this request, we would also very much appreciate record-level data instead, i.e. Every Row reflecting one incident and the columns reflecting
i) crime location (as CSP, municipality name or postalcode; more precise details are not necessary),
ii) Date (ideally with day, otherwise month and year) and
iii) motivating factor.

Extent and Result of Searches to Locate Information
To locate the information relevant to your request searches were conducted within North Yorkshire Police.

I can confirm that the information you have requested is held by North Yorkshire Police.  

Decision
I have today decided to disclose the following information to you.

Q1. Please find the attached csv file showing the number of recorded hate crimes based on the Home Office hate crime categories (race or ethnicity, religion, disability, sexual orientation and transgender identity) in financial years 2016/2017 and 2017/2018, broken down by calendar month and Safer Neighbourhood Command (SNC) area.

Please note that systems used for recording information are not generic, nor are the procedures used locally in capturing the data.  It should be noted therefore that this force’s response to your questions should not be used for comparison purposes with any other responses you may receive.