Name File Type Size Last Modified application/zip 48.5 MB 04/02/2023 09:58:AM application/zip 20.5 MB 04/02/2023 11:28:AM

Project Citation: 

Kaplan, Jacob. Jacob Kaplan’s Concatenated Files: Uniform Crime Reporting (UCR) Program Data: Supplementary Homicide Reports (SHR), 1976-2021. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2023-04-02.

Project Description

Summary:  View help for Summary
For a comprehensive guide to this data and other UCR data, please see my book at

Version 12 release notes:
  • Adds 2021 data.
Version 11 release notes:
  • Adds 2020 data.
  • Please note that the FBI has retired UCR data ending in 2020 data so this will be the last SHR data they release.
  • Changes .rda file to .rds.
Version 10 release notes:
  • Changes release notes description, does not change data.
Version 9 release notes:
  • Adds 2019 data.
Version 8 release notes:
  • 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 (
  • Adds .csv version of the data.
  • Makes minor changes to value labels for consistency and to fix grammar.
Version 7 release notes:
  • Changes project name to avoid confusing this data for the ones done by NACJD.
Version 6 release notes:
  • Adds 2017 data.
Version 5 release notes:
  • 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.
Version 4 release notes:
  • Fix bug where Philadelphia Police Department had incorrect FIPS county code.
Version 3 Release Notes:
  • 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.
  • Reorder columns.

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.

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

The following is the summary of the Supplementary Homicide Report copied from ICPSR's 2015 page for the data.

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.

Scope of Project

Subject Terms:  View help for Subject Terms SHR; murder; homicide; supplementary homicide report
Geographic Coverage:  View help for Geographic Coverage United States
Time Period(s):  View help for Time Period(s) 1976 – 2020
Universe:  View help for Universe Victims of homicide in the United States between 1976 and 2019.
Data Type(s):  View help for Data Type(s) administrative records data; aggregate data


Data Source:  View help for Data Source United States Department of Justice. Federal Bureau of Investigation
Unit(s) of Observation:  View help for Unit(s) of Observation Incident
Geographic Unit:  View help for Geographic Unit Police agency

Related Publications

Export Metadata

Report a Problem

Found a serious problem with the data, such as disclosure risk or copyrighted content? Let us know.

This material is distributed exactly as it arrived from the data depositor. ICPSR has not checked or processed this material. Users should consult the investigator(s) if further information is desired.