Jacob Kaplan's Concatenated Files: Uniform Crime Reporting (UCR) Program Data: Supplementary Homicide Reports, 1976-2019

Resource Type
Dataset : administrative records data, aggregate data
  • Kaplan, Jacob (University of Pennsylvania. Department of Criminology)
Publication Date
Free Keywords
SHR; murder; homicide; supplementary homicide report
  • Abstract

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

Temporal Coverage
  • 1976-01-01 / 2019-12-31
    Time Period: Thu Jan 01 00:00:00 EST 1976--Tue Dec 31 00:00:00 EST 2019
Geographic Coverage
  • United States
Sampled Universe
Victims of homicide in the United States between 1976 and 2019. Smallest Geographic Unit: Police agency
This study is freely available to the general public via web download.
  • Is version of
    DOI: 10.3886/E100699

Update Metadata: 2021-02-10 | Issue Number: 1 | Registration Date: 2021-02-10