DOI: 10.3886/e103540
title: Jacob Kaplan's Concatenated Files: Uniform Crime Reporting (UCR) Program Data: Arson 1979-2024

description: <b><b>For a comprehensive guide to this data and other UCR data, please see my book at ucrbook.com</b></b><b><br></b><b>Version 14 release notes:<br></b>Adds .parquet file format<b>Version 13 release notes:<br></b>Adds 2023-2024 data<b>Version 12 release notes:<br></b>Adds 2022 data<b>Version 11 release notes:</b><br>Adds 2021 data.<br><b>Version 10 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 arson data they release. <br>Changes .rda file to .rds.<b><br></b><b>Version 9 release notes:</b>Changes release notes description, does not change data.<b>Version 8 release notes:</b>Adds 2019 data.Note that the number of months missing variable sharply changes starting in 2018. This is probably due to changes in UCR reporting of the column_2_type variable which is used to generate the months missing county (the code I used does not change). So pre-2018 and 2018+ years may not be comparable for this variable. <br><b>Version 7 release notes:</b><br><b>Adds a </b><b>last_month_reported </b><b>column which says which month was reported last. This is actually how the FBI defines </b><b>number_of_months_reported </b><b>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.<br></b><b>Adds a </b><b>number_of_months_missing </b><b>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 </b><b>card_2_type</b><b> variable or reports NA in that 
variable. Please note 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.</b><b>Version 6 release notes:</b><b></b>Adds 2018 data<br><b>Version 5 release notes:<br></b>Adds data in the following formats: SPSS and Excel.Changes project name to avoid confusing this data for the ones done by NACJD.<b></b><b>Version 4 release notes: <b><b><br></b></b></b>Adds 1979-2000, 2006, and 2017 data<b><b></b><b></b></b>Adds agencies that reported 0 months.Adds monthly data.All data now from FBI, not NACJD. <br>Changes some column names so all columns are &lt;=32 characters to be usable in Stata.<br><b>Version 3 release notes: <b><b><br></b></b></b>Add data for 2016.Order rows by year (descending) and ORI.Removed data from Chattahoochee Hills (ORI = "GA06059") from 2016 data. In 2016, that agency reported about 28 times as many vehicle arsons as their population (Total mobile arsons = 77762, population = 2754.<br><b>Version 2 release notes: <b><br></b></b>Fix bug where Philadelphia Police Department had incorrect FIPS county code. This Arson data set is an FBI data set that is part of the annual 
Uniform Crime Reporting (UCR) Program data. This data contains 
information about arsons reported in the United States. The information is the number of arsons reported, to have actually occurred, to not have occurred ("unfounded"), cleared by arrest of at least one arsoning, cleared by arrest where all offenders are under the age of 18, and the cost of the arson. This is done for a number of different arson location categories such as community building, residence, vehicle, and industrial/manufacturing structure.<br><br> The yearly data sets here combine data from the years 1979-2018 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. I also added state, county, and place FIPS code from the LEAIC (crosswalk).<br>A small number of agencies had some months with clearly incorrect data. I changed the incorrect columns to NA and left the other columns unchanged for that agency. The following are data problems that I fixed - there are still likely issues remaining in the data so make sure to check yourself before running analyses. Oneida, New York (ORI = NY03200) had multiple years that reported single arsons costing over $700 million. I deleted this agency from all years of data.In January 1989 Union, North Carolina (ORI = NC09000) reported 30,000 arsons in uninhabited single occupancy buildings and none any other months.<br> In December 1991 Gadsden, Florida (ORI = FL02000) reported that a single 
arson at a community/public building caused $99,999,999 in damages (the maximum possible).In April 2017 St. Paul, Minnesota (ORI = MN06209) reported 73,400 arsons in 
uninhabited storage buildings and 10,000 arsons in uninhabited 
community/public buildings and one or fewer every other month.<br>When an arson is determined to be unfounded the estimated damage from that arson is added as negative to zero out the previously reported estimated damages. This occasionally leads to some agencies have negative values for arson damages. You should be cautious when using the estimated damage columns as some values are quite large. Negative values in other columns are also due to adjustments (zeroing out the error) from month to month. Negative values are not meant to be NA in this data set.<br><br><br><br>
description: Smallest Geographic Unit: Police agency