Spotlight Dataset 106: Police Data (Per record Crimes, Outcomes, Stop&Search)
https://factsanddimensions.co.uk
Facts and Dimensions provide 1000s of tables of publicly available stats and reference data, ready to query immediately.
This video concentrates on schema: Police
Data back to May 2018
As at time of video: 49million rows
Breakdown:
Crimes
Outcomes
Stop & Search
Crimes/Outcomes data:
Police force reporting the crime
Police force location of the crime
Long/Lat of the crim
LSOA
Crime Type
Last Outcome Category
Stop & Search
Type of search
Whether it was part of a policing operation
Lat/Long
Gender of susper
Suspect's self-defined ethnicity
Police offier's defined ethnicity of the suspect
Object of search
Outcome
Whether or not the outcome was linked to the object of the search
Whether or not there was removal of more than just outer clothing