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

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

    For any questions about this data please email me at jacob@crimedatatool.com. If you use this data, please cite it.

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

    All the data was downloaded from NACJD as ASCII+SPSS Setup files and 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 / 2017-12-31
    Time Period: Thu Jan 01 00:00:00 EST 1976--Sun Dec 31 00:00:00 EST 2017
Geographic Coverage
  • United States
Sampled Universe
Victims of homicide in the United States between 1976 and 2017.Smallest Geographic Unit: Police agency

Update Metadata: 2019-09-20 | Issue Number: 1 | Registration Date: 2019-09-20