Jacob Kaplan's Concatenated Files: Uniform Crime Reporting Program Data: Offenses Known and Clearances by Arrest (Return A), 1960-2024

For a comprehensive guide to this data and other UCR data, please see my book at ucrbook.com Version 22 release notes:Adds .parquet file formatVersion 21 release notes:Adds 2023 and 2024 dataVersion 20 release notes:Adds 2022 data Version 19 release notes:Starting in year 2018 I used the "card_actual_type" to identify missing months rather than using the "card_actual_pt" column. As noted in previous release notes, a change by the FBI starting in 2018 led to the "card_actual_type" to always say that this month is reported. The "card_actual_type" appears to be unchanged so can be used to actually measure months missing. The tradeoff is that pre-2018 the "card_actual_type" and the "card_actual_pt" columns did not always agree so could have different values. Still, I consider the ability to measure months missing at all to be worth this tradeoff. Version 18 release notes: Adds data for 2021. Version 17 release notes:Adds data for 2020.Please note that the FBI has retired UCR data ending in 2020 data so this will be the last Offenses Known and Clearances by Arrest data they release. Changes .rda files to .rds. Please note that in 2020 the card_actual_pt variable always returns that the month was reported. This causes 2020 to report that all months are reported for all agencies because I use the card_actual_pt variable to measure how many months were reported. This variable is almost certainly incorrect since it is extremely unlikely that all agencies suddenly always report. However, I am keeping this incorrect value to maintain a consistent definition of how many months are missing (measuring missing months through card_actual_type, for example, gives different results for previous years so I don't want to change this). Version 16 release notes:Changes release notes description, does not change data.Version 15 release notes:Adds data for 2019.Please note that in 2019 the card_actual_pt variable always returns that the month was reported. This causes 2019 to report that all months are reported for all agencies because I use the card_actual_pt variable to measure how many months were reported. This variable is almost certainly incorrect since it is extremely unlikely that all agencies suddenly always report. However, I am keeping this incorrect value to maintain a consistent definition of how many months are missing (measuring missing months through card_actual_type, for example, gives different results for previous years so I don't want to change this). Version 14 release notes:Adds arson data from the UCR's Arson dataset. This adds just the arson variables about the number of arson incidents, not the complete set of variables in that dataset (which include damages from arson and whether structures were occupied or not during the arson.As arson is an index crime, both the total index and the index property columns now include arson offenses. The "all_crimes" variables also now include arson.Adds a arson_number_of_months_missing column indicating how many months were not reporting (i.e. missing from the annual data) in the arson data. In most cases, this is the same as the normal number_of_months_missing but not always so please check if you intend to use arson data.Please note that in 2018 the card_actual_pt variable always returns that the month was reported. This causes 2018 to report that all months are reported for all agencies because I use the card_actual_pt variable to measure how many months were reported. This variable is almost certainly incorrect since it is extremely unlikely that all agencies suddenly always report. However, I am keeping this incorrect value to maintain a consistent definition of how many months are missing (measuring missing months through card_actual_type, for example, gives different results for previous years so I don't want to change this).For some reason, a small number of agencies (primarily federal agencies) had the same ORI number in 2018 and I removed these duplicate agencies. Version 13 release notes: Adds 2018 dataNew Orleans (ORI = LANPD00) data had more unfounded crimes than actual crimes in 2018 so unfounded columns for 2018 are all NA. Version 12 release notes: Adds population 1-3 columns - if an agency is in multiple counties, these variables show the population in the county with the most people in that agency in it (population_1), second largest county (population_2), and third largest county (population_3). Also adds county 1-3 columns which identify which counties the agency is in. The population column is the sum of the three population columns. Thanks to Mike Maltz for the suggestion!Fixes bug in the crosswalk data that is merged to this file that had the incorrect FIPS code for Clinton, Tennessee (ORI = TN00101). Thanks for Brooke Watson for catching this bug!Adds a last_month_reported column which says which month was reported last. This is actually how the FBI defines number_of_months_reported so is a more accurate representation of that. Removes the number_of_months_reported variable as the name is misleading. You should use the last_month_reported or the number_of_months_missing (see below) variable instead. Adds a number_of_months_missing in the annual data which is the sum of the number of times that the agency reports "missing" data (i.e. did not report that month) that month in the card_actual_pt variable or reports NA in that variable. Please not that this variable is not perfect and sometimes an agency does not report data but this variable does not say it is missing. Therefore, this variable will not be perfectly accurate. Version 11 release notes: Adds data in the following formats: SPSS and Excel.Changes project name to avoid confusing this data for the ones done by NACJD. Version 10 release notes: Adds card column to the monthly data. The "pt" cards can be used to indicate if no return was submitted that month. Thank you to Tanaya Devi for the suggestion.Adds the mailing address columns to both monthly and yearly data. In 2017 the agency "New Orleans" in Louisiana (ORI = LANPD00) reported hundreds of times more unfounded attempted burglaries than actual attempted burglaries for every month. These were all changed to NA (unfounded total burglaries was also changed to NA. Version 9 release notes: Adds column for index crimes. Index Violent is the sum of murder, total robbery, total rape, and total aggravated assault. Index Property is the sum of burglary, total motor vehicle theft, and total theft (arson is an index crime but is not available in this data set). Index Total is the sum of Index Violent and Index Property. When looking at these columns please consider that some agencies don't always report all crimes (e.g. Chicago didn't report rape between 1986-2012) so these variables may be undercounts. All data now from FBI, not NACJD. Changes some column names so all columns are