Regional (Local Authority and CSP) Crime Trends Data for Scotland, England and Wales - Violence and Burglary - 2004/5 to 2015/16 Prepared by Ellie Bates, Research Fellow in Criminology, January 2015 to September 2017 AQMeN, School of Law, University of Edinburgh, Edinburgh, Scotland 28 September 2017 This excel workbook RegionalCrimeTrends_ScotlandLAs_EnglandWalesCSPs_2004_2016.xlsx contains recorded crime count and rates per 1000 people data for England, Wales and Scotland for violence and burglary (housebreaking in Scotland) Data on violent crimes and burglary / housebreaking is provided separately Data is aggregated for financial years for 12 years 2004-5 to 2015-16 Crime rates and logged crime rates, based on mid year population estimates from NOMIS, are also provided Recorded crime is crime reported to, and recorded by, the police. There are separate sheets for England and Wales which have the same legal system, and Scotland, which has a different legal system Crimes included from England and Wales are a 'best fit' to the Scottish crimes (as more detailed crime data by crime type for Community Safety Partnerships is currently provided on English and Welsh police recorded crime by the UK Home Office than is provided for Scottish police recorded crime for local authorities by the Scottish government) Note murder and manslaughter (murder and culpable homicide in Scotland) are excluded from the violence data due to difficulties in identifying a best fit for these definitions. England and Wales data includes information on Police Force Area (Force Name) and English or Welsh Region There has been single police force in Scotland since April 2013 and there are no Scottish sub-regions so no data on police force or sub-region is included in the Scottish dataset There are a total of N=317 Community Safety Partnerships in England and Wales at 2015-16 and N=32 local authorities in Scotland There are also spreadsheets with England Wales and Scotland combined These have a code for the LA or Local Authority only together with a country code (England =22, Wales=14 or Scotland=12), and a Scotland Yes variable (1 if in Scotland otherwise 0) Total observations N=349 List of sheets and descriptions Sheet Description ReadmeEnglandandWalesCSPs Metadata - Additional information about data preparation for the English and Welsh data DataSourcesEnglandWales Metadata - List of data sources used to create the English and Welsh data sets DefinitionsandCodesEnglandWales Metadata - List of relevant home office crime codes used to define violence (excluding murder and manslaughter) and burglary in English and Welsh datasets CSP201516HONameNomisLA Metadata - List of Community Safety Partnership as at 2015-16, with the name commonly used in the Home Office open data tables, along with the Police Force Area and Sub-Region the CSP falls within, and the unique alphanumeric codes of the local authority (or local authorities where there are more than one) that make up the CSP AppendixEWCSPs Metadata - Additional information on assumptions made to create a time series of England and Wales CSPs based on CSPs at 2015-16 from 2004-5 to 2015-16 including list of all CSP names used as a lookup in all years and notes on assumptions made for each CSP to match data across years MergedCSPs_SourcecheckNotes Metadata -List of information sources used to check dates the community safety partnerships merged (where two or more local districts report data jointly for a single CSP area), or when new partnerships were created following local government reorganisation in 2009 where some district authorities merged to become single unitary authorities. NOMISPopulationLACSPLookup Metadata - A lookup table which lists all unitary and district local authorities as at April 2015 and their unique code (as used on www.nomisweb.co.uk and commonly by Office for National Statistics) of the Community Safety Partnership (CSP) they are part of (unique code and name) as used in the Home Office Open Data tables for 2015-16 recorded crime data. DefinitionsandCodesScotland Metadata - List of relevant Scottish crime recording standard codes used to define violence and housebreaking in the Scottish dataset DataSources_Scotland Metadata - List of data sources used to create the Scottish data sets Violence_Scotland Data - Recorded crimes of violence in Scotland at local authority level with population estimates for all people and rate of violence per 1000 people and the logged rate BurglaryHB_Scotland Data - Recorded crimes of housebreaking in Scotland at local authority level with population estimates for all people and rate of housebreaking per 1000 people and the logged rate ViolenceEnglandWales Data - Recorded crimes of violence in England and Wales at community safety partnership (CSP) level with population estimates for all people and rate of violence per 1000 people and the logged rate BurglaryEnglandWales Data - Recorded crimes of burglary in England and Wales at community safety partnership (CSP) level with population estimates for all people and rate of burglary per 1000 people and the logged rate ViolenceEngWalesScot Data - Recorded crimes of violence in Scotland at local authority level and English and Welsh CSPs with population estimates for all people and rate of violence per 1000 people and the logged rate BurglaryEngWalesScot Data - Recorded crimes of housebreaking and burglary in Scotland at local authority level and English and Welsh CSPs with population estimates for all people and rate of housebreaking and burglary per 1000 people and the logged rate A note on data quality and crime data integrity Not all crimes are reported, and not all crimes are subsequently recorded by the police, following report. National crime recording standards were in place for England, Wales and Scotland for all nations by 1st April 2004. Whilst this should ensure consistency between police forces, local recording practices may still affect crime recording quality. Following concerns about crime recording practices, including around the recording of violence, within forces and additionally relating to the quality of published recorded crime data in official publications, the UK Statistics Authority removed the National Statistics status from English and Welsh police recorded crime in January 2014, and from Scottish police recorded crime in July 2014. In addition Her Majesties Inspectorate of Constabulary (HMIC) (now HM Inspectorate of Constabulary and Fire & Rescue Services (HMICFRS)) inspected all English and Welsh forces for crime data integrity through out 2014 and raised concerns about a number of forces' practices. Reports for all English and Welsh forces in 2014 can be found here https://www.justiceinspectorates.gov.uk/hmicfrs/publications/crime-data-integrity-force-reports/ (accessed 26 September 2017) English and Welsh recorded crime still does not, as at September 2017, have official statistic status. The National Statistics status of Scottish police recorded crime statistics in Scotland was re-instated in September 2016 following evidence from Her Majesty’s Inspectorate of Constabulary in Scotland (HMICS) of "sustained improvement in the quality of crime recording in Police Scotland" however as at September 2017 this status had not been re-instated for England and Wales (see https://www.statisticsauthority.gov.uk/publication/strategic-intervention-outline-crime-statistics/ accessed September 2017) See further for Scotland:- HMICS Crime data audit of 2014 (http://hmics.org/publications/hmics-crime-audit-2014) and 2016 (http://hmics.org/publications/hmics-crime-audit-2016) For England and Wales:- the HMICFRS crime data integrity programme (http://www.justiceinspectorates.gov.uk/hmicfrs/our-work/crime-data-integrity/) and rolling programme of inspections (http://www.justiceinspectorates.gov.uk/hmicfrs/our-work/crime-data-integrity/reports-rolling-programme-crime-data-integrity/)