DOI: 10.3886/e102263v16-198261
title: Jacob Kaplan's Concatenated Files: Uniform Crime Reporting (UCR) Program Data: Arrests by Age, Sex, and Race, 1974-2024

description: <b><b>For a comprehensive guide to this data and other UCR data, please see my book at ucrbook.com<br></b></b><br><b>Version 15 release notes:</b>Adds 2022-2024 data.Converts data from wide to long to be more consistent with the raw data.Adds parquet file type<b>Version 15 release notes:</b>Adds 2021 data.<br><b>Version 14 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 Arrests by Age, Sex, and Race data they release. <br><b>Version 13 release notes:</b>Changes R files from .rda to .rds.Fixes bug where the number_of_months_reported variable incorrectly was the largest of the number of months reported for a specific crime variable. For example, if theft was reported Jan-June and robbery was reported July-December in an agency, in total there were 12 months reported. But since each crime (and let's assume no other crime was reported more than 6 months of the year) only was reported 6 months, the number_of_months_reported variable was incorrectly set at 6 months. Now it is the total number of months reported of any crime. So it would be set to 12 months in this example. Thank you to Nick Eubank for alerting me to this issue.<br>Adds rows even when a agency reported zero arrests that month; all arrest values are set to zero for these rows.<br><b>Version 12 release notes:</b><b></b>Adds 2019 data.<br><b>Version 11 release notes:</b>Changes release notes description, does not change data.<b>Version 10 release notes:</b>The data now has the following age categories (which were previously aggregated into larger groups to reduce file size): under 10, 10-12, 13-14, 40-44, 45-49, 50-54, 55-59, 60-64, over 64. These categories are available for female, male, and total (female+male) arrests. The previous aggregated categories (under 15, 40-49, and over 49 have been removed from the data). <br><b>Version 9 release notes:</b><b></b>For each offense, adds a variable indicating the number of months that offense was reported - these variables are labeled as "num_months_[crime]" where [crime] is the offense name. These variables are generated by the number of times one or more arrests were reported per month for that crime. For example, if there was at least one arrest for assault in January, February, March, and August (and no other months), there would be four months reported for assault. Please note that this does not differentiate between an agency not reporting that month and actually having zero arrests. <br>The variable "number_of_months_reported" is still in the data and is the number of months that any offense was reported. So if any agency reports murder arrests every month but no other crimes, the murder number of months variable and the "number_of_months_reported" variable will both be 12 while every other offense number of month variable will be 0. <br>Adds data for 2017 and 2018.<br><b>Version 8 release notes:<br></b>Adds annual data in R format.<br>Changes project name to avoid confusing this data for the ones done by NACJD.Fixes bug where bookmaking was excluded as an arrest category. <br>Changed the number of categories to include more offenses per category to have fewer total files. Added a "total_race" file for each category - this file has total arrests by race for each crime and a breakdown of juvenile/adult by race. <br><b></b><b>Version 7 release notes: <b><b><br></b></b></b><b><b></b></b>Adds 1974-1979 dataAdds monthly data (only totals by sex and race, not by age-categories). <br>All data now from FBI, not NACJD. <br>Changes some column names so all columns are &lt;=32 characters to be usable in Stata.Changes how number of months reported is calculated. Now it is the number of unique months with arrest data reported - months of data from the monthly header file (i.e. juvenile disposition data) are not considered in this calculation. <br><b>Version 6 release notes: <b><br></b></b><b></b>Fix bug where juvenile female columns had the same value as juvenile male columns.<br><b>Version 5 release notes: <br></b>Removes support for SPSS and Excel data.Changes the crimes that are stored in each file. There are more files now with fewer crimes per file. The files and their included crimes have been updated below.<br>Adds in agencies that report 0 months of the year.Adds a column that indicates the number of months reported. This is generated summing up the number of unique months an agency reports data for. Note that this indicates the number of months an agency reported arrests for ANY crime. They may not necessarily report every crime every month. Agencies that did not report a crime with have a value of NA for every arrest column for that crime.Removes data on runaways.<br><b>Version 4 release notes: <br></b>Changes column names from "poss_coke" and "sale_coke" to "poss_heroin_coke" and "sale_heroin_coke" to clearly indicate that these column includes the sale of heroin as well as similar opiates such as morphine, codeine, and opium. Also changes column names for the narcotic columns to indicate that they are only for synthetic narcotics. <br><b>Version 3 release notes: </b><br>Add data for 2016.Order rows by year (descending) and ORI.<b>Version 2 release notes: <b><br></b></b>Fix bug where Philadelphia Police Department had incorrect FIPS county code. <br>The Arrests by Age, Sex, and Race (ASR) data is an FBI data set that is part of the annual Uniform Crime Reporting (UCR) Program data. This data contains highly granular data on the number of people arrested for a variety of crimes (see below for a full list of included crimes). The data sets here combine data from the years 1974-2019 into a single file for each group of crimes. Each monthly file is only a single year as my laptop can't handle combining all the years together. These files are quite large and may take some time to load. <br>Columns are crime-arrest category units. For example, If you choose the data set that includes murder, you would have rows for each agency-year/month and columns with the number of people arrests for murder. The ASR data breaks down arrests by age and gender (e.g. Male aged 15, Male aged 18). They also provide the number of adults or juveniles arrested by race. Because most agencies and years do not report the arrestee's ethnicity (Hispanic or not Hispanic) I do not include these columns. <br><br>To make it easier to merge with other data, I merged this data with the Law Enforcement Agency Identifiers Crosswalk (LEAIC) data. The data from the LEAIC add FIPS codes (state, county, and place).<br><br>I created 9 arrest categories myself. The categories are: <br>Total Male JuvenileTotal Female JuvenileTotal Male AdultTotal Female AdultTotal MaleTotal FemaleTotal JuvenileTotal AdultTotal ArrestsAll of these categories are based on the sums of the sex-age categories (e.g. Male under 10, Female aged 22) rather than using the provided age-race categories (e.g. adult Black, juvenile Asian). As not all agencies report the race data, this method is more accurate. I also made total race categories by adding the juvenile and adult count for each race.<br><br>As the arrest data is very granular, and each category of arrest is its own column, there are dozens of columns per crime. To keep the data somewhat manageable, there are five different files, four which contain different crimes and the "all_crimes" file. Each file contains the data for all years. The four categories each have crimes belonging to a major crime category and do not overlap in crimes other than with the index offenses. Please note that the crime names provided below are not the same as the column names in the data. Due to Stata limiting column names to 32 characters maximum, I have abbreviated the crime names in the data. The files and their included crimes are:<br><br><b>Index Crimes<br></b><b></b>MurderRapeRobberyAggravated AssaultBurglaryTheftMotor Vehicle TheftArson<b>Drug Crimes</b>Total DrugTotal Drug SalesTotal Drug PossessionCannabis PossessionCannabis SalesHeroin or Cocaine PossessionHeroin or Cocaine SalesOther Drug PossessionOther Drug SalesSynthetic Narcotic PossessionSynthetic Narcotic Sales<b>Alcohol or Property Crimes</b>DUIDrunkenness<br>LiquorForgeryFraudStolen PropertyEmbezzlementGambling - TotalGambling - OtherGambling - BookmakingGambling - Lottery<br><b>Other Crimes</b>CurfewDisorderly ConductOther Non-trafficSuspicion<br>VandalismVagrancyOffenses Against the Family and Children <br>Other Sex Offenses<br>ProstitutionNegligent ManslaughterWeapon OffensesOther AssaultThese are the age categories, which are also broken up by arrestee gender.<br>Under 1010-1213-141516171819202122232425-2930-3435-3940-4445-4950-5455-5960-6465 and older<br>
description: Police agencies in the United States<br>. Smallest Geographic Unit: Police agency jurisdiction