DOI: 10.3886/e100699
title: Jacob Kaplan's Concatenated Files: Uniform Crime Reporting (UCR) Program Data: Supplementary Homicide Reports (SHR), 1976-2024

description: <b><b>For a comprehensive guide to this data and other UCR data, please see my book at ucrbook.com</b></b><b><br></b><b>Version 16 release notes:<br></b>Adds .parquet file format<b>Version 15 release notes:<br></b>Adds 2023 and 2024 data<b>Version 14 release notes:<br></b><b></b>Reupload data to fix issue with Stata file not opening.<br><b>Version 13 release notes:<br></b>Adds 2022 data<br><b>Version 12 release notes:<br></b><b></b>Adds 2021 data.<br><b>Version 11 release notes:</b>Adds 2020 data. <br>Please note that the FBI has retired UCR data ending in 2020 data so this will be the last SHR data they release. <br>Changes .rda file to .rds.<br><b>Version 10 release notes:</b>Changes release notes description, does not change data.<b>Version 9 release notes:</b><b></b>Adds 2019 data.<br><b>Version 8 release notes:</b><br>Adds 2018 data.Changes source of data for years 1985-2018 to be directly from the FBI. 2018 data was received via email from the FBI, 2016-2017 is from the FBI who mailed me a DVD, and 1985-2015 data is from the FBI's Crime Data Explorer site (https://crime-data-explorer.fr.cloud.gov/downloads-and-docs).Adds .csv version of the data.Makes minor changes to value labels for consistency and to fix grammar. <br><b>Version 7 release notes:</b><br>Changes project name to avoid confusing this data for the ones done by NACJD.<b>Version 6 release notes:</b>Adds 2017 data.<b><br></b><b>Version 5 release notes:</b>Adds 2016 data.Standardizes the "group" column which categorizes cities and counties by population.Arrange rows in descending order by year and ascending order by ORI. <br><b>Version 4 release notes: <b><br></b></b>Fix bug where Philadelphia Police Department had incorrect FIPS county code. <b>Version 3 Release Notes:</b>Merges data with LEAIC data to add FIPS codes, census codes, agency type variables, and ORI9 variable.Change column names for relationship variables from offender_n_relation_to_victim_1 to victim_1_relation_to_offender_n to better indicate that all relationship are victim 1's relationship to each offender. <br>Reorder columns.<br><br>This is a single file containing all data from the Supplementary Homicide Reports from 1976 to 2018. The Supplementary Homicide Report provides detailed information about the victim, offender, and circumstances of the murder. Details include victim and offender age, sex, race, ethnicity (Hispanic/not Hispanic), the weapon used, circumstances of the incident, and the number of both offenders and victims. <br><br>Years 1976-1984 were downloaded from NACJD, while more recent years are from the FBI. All files came as ASCII+SPSS Setup files and were
cleaned using R. The "cleaning" just means that column names were 
standardized (different years have slightly different spellings for many
 columns). Standardization of column names is necessary to stack 
multiple years together. Categorical variables (e.g. state) were also 
standardized (i.e. fix spelling errors, have terminology be the same across years). <br><br>The following is the summary of the Supplementary Homicide Report copied from ICPSR's 2015 page for the data.<br><br>The Uniform Crime Reporting Program Data: Supplementary Homicide Reports (SHR) provide detailed information on criminal homicides reported to the police. These homicides consist of murders; non-negligent killings also called non-negligent manslaughter; and justifiable homicides. UCR Program contributors compile and submit their crime data by one of two means: either directly to the FBI or through their State UCR Programs. State UCR Programs frequently impose mandatory reporting requirements which have been effective in increasing both the number of reporting agencies as well as the number and accuracy of each participating agency's reports. Each agency may be identified by its numeric state code, alpha-numeric agency ("ORI") code, jurisdiction population, and population group. In addition, each homicide incident is identified by month of occurrence and situation type, allowing flexibility in creating aggregations and subsets.<br><br>
description: Victims of homicide in the United States between 1976 and 2019. Smallest Geographic Unit: Police agency