A newer version of this project is available. See below for other available versions.

Uniform Crime Reporting (UCR) Program Data: Hate Crime Data 1992-2017

Name: Uniform Crime Reporting (UCR) Program Data: Hate Crime Data 1992-2017
Published: 2018-05-18
License: https://creativecommons.org/licenses/by/4.0

Principal Investigator(s): View help for Principal Investigator(s) Jacob Kaplan, University of Pennsylvania

Version: View help for Version V4

Name	File Type	Size	Last Modified
ucr_hate_crimes_1992_2017_dta.zip	application/zip	36.1 MB	11/04/2018 06:36:AM
ucr_hate_crimes_1992_2017_rda.zip	application/zip	28.1 MB	11/04/2018 06:27:AM

Project Citation:

Kaplan, Jacob. Uniform Crime Reporting (UCR) Program Data: Hate Crime Data 1992-2017. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2018-11-04. https://doi.org/10.3886/E103500V4

Project Description

Summary:

Version 4 release notes:

Adds data for 2017.
Adds rows that submitted a zero-report (i.e. that agency reported no hate crimes in the year). This is for all years 1992-2017.
Made changes to categorical variables (e.g. bias motivation columns) to make categories consistent over time. Different years had slightly different names (e.g. 'anti-am indian' and 'anti-american indian') which I made consistent.
Made the 'population' column which is the total population in that agency.

Version 3 release notes:

Adds data for 2016.
Order rows by year (descending) and ORI.

Version 2 release notes:

Fix bug where Philadelphia Police Department had incorrect FIPS county code.

The Hate Crime data is an FBI data set that is part of the annual Uniform Crime Reporting (UCR) Program data. This data contains information about hate crimes reported in the United States. The data sets here combine all data from the years 1992-2015 into a single file. Please note that the files are quite large and may take some time to open.

Each row indicates a hate crime incident for an agency in a given year. I have made a unique ID column ("unique_id") by combining the year, agency ORI9 (the 9 character Originating Identifier code), and incident number columns together. Each column is a variable related to that incident or to the reporting agency.

Some of the important columns are the incident date, what crime occurred (up to 10 crimes), the number of victims for each of these crimes, the bias motivation for each of these crimes, and the location of each crime. It also includes the total number of victims, total number of offenders, and race of offenders (as a group). Finally, it has a number of columns indicating if the victim for each offense was a certain type of victim or not (e.g. individual victim, business victim religious victim, etc.).

All the data was downloaded from NACJD as ASCII+SPSS Setup files and read into R using the package asciiSetupReader. All work to clean the data and save it in various file formats was also done in R. For the R code used to clean this data, see here. https://github.com/jacobkap/crime_data.

The only changes I made to the data are the following. Minor changes to column names to make all column names 32 characters or fewer (so it can be saved in a Stata format), changed the name of some UCR offense codes (e.g. from "agg asslt" to "aggravated assault"), made all character values lower case, reordered columns. I also added state, county, and place FIPS code from the LEAIC (crosswalk) and generated incident month, weekday, and month-day variables from the incident date variable included in the original data.

The zip file contains the data in the following formats and a codebook:

.dta - Stata
.rda - R

If you have any questions, comments, or suggestions please contact me at [email protected].

Scope of Project

Subject Terms: crime reporting; crime statistics; law enforcement; ucr; FBI; Uniform Crime Reports; hate crimes; disabilities; prejudice; racial tensions; religious tensions; homophobia

Geographic Coverage: United States

Time Period(s): 1992 – 2017

Methodology

Unit(s) of Observation: Hate crime incident

Geographic Unit: police agency

Related Publications

Download this project

Published Versions

Export Metadata

Dublin Core

DDI 2.5

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 received from the data depositor. As of April 2026, depositors are required to submit study materials in accessible formats. ICPSR has not reviewed, checked, or processed this material. For additional information about the study, please contact the investigator(s) directly. If you have questions about the accessibility of materials distributed by ICPSR or require further assistance, please visit ICPSR's Accessibility Center.