Name File Type Size Last Modified
supprecdes.docx application/vnd.openxmlformats-officedocument.wordprocessingml.document 24 KB 08/14/2018 07:28:AM application/zip 634.7 MB 08/14/2018 12:58:PM application/zip 500.7 MB 08/14/2018 01:21:PM application/zip 95.9 MB 08/14/2018 01:00:PM application/zip 82.6 MB 08/14/2018 01:00:PM

Project Citation: 

Kaplan, Jacob. Uniform Crime Reporting (UCR) Program Data: Property Stolen and Recovered (Supplement to Return A) 1960-2016. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2018-08-14.

Persistent URL:

Project Description

Summary:  View help for Summary
Property Stolen and Recovered is a Uniform Crime Reporting (UCR) Program data set with information on the number of offenses (crimes included are murder, rape, robbery, burglary, theft/larceny, and motor vehicle theft), the value of the offense, and subcategories of the offense (e.g. for robbery it is broken down into subcategories including highway robbery, bank robbery, gas station robbery).

The majority of the data relates to theft. Theft is divided into subcategories of theft such as shoplifting, theft of bicycle, theft from building, and purse snatching. For a number of items stolen (e.g. money, jewelry and previous metals, guns), the value of property stolen and and the value for property recovered is provided. This data set is also referred to as the Supplement to Return A (Offenses Known and Reported).

All the data was received directly from the FBI as text or .DTA files. I created a setup file based on the documentation provided by the FBI and read the data 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: The Word document file available for download is the guidebook the FBI provided with the raw data which I used to create the setup file to read in data.

There may be inaccuracies in the data, particularly in the group of columns starting with "auto." To reduce (but certainly not eliminate) data errors, I replaced the following values with NA for the group of columns beginning with "offenses" or "auto" as they are common data entry error values (e.g. are larger than the agency's population, are much larger than other crimes or months in same agency): 1000, 2000, 3000, 4000, 5000, 6000, 7000, 8000, 9000, 10000, 20000, 30000, 40000, 50000, 60000, 70000, 80000, 90000, 100000, 99942. This cleaning was NOT done on the columns starting with "value."

For every numeric column I replaced negative indicator values (e.g. "j" for -1) with the negative number they are supposed to be. These negative number indicators are not included in the FBI's codebook for this data but are present in the data. I used the values in the FBI's codebook for the Offenses Known and Clearances by Arrest data.

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 (state, county, and place) and agency type/subtype. If an agency has used a different FIPS code in the past, check to make sure the FIPS code is the same as in this data.

Scope of Project

Subject Terms:  View help for Subject Terms stolen property; stolen property recovery; recovered property; larceny; theft; property crime statistics; crime statistics; Uniform Crime Reports; UCR
Geographic Coverage:  View help for Geographic Coverage United States
Time Period(s):  View help for Time Period(s) 1960 – 2016
Data Type(s):  View help for Data Type(s) administrative records data; aggregate data


Data Source:  View help for Data Source Federal Bureau of Investigation
Collection Mode(s):  View help for Collection Mode(s) self-enumerated questionnaire
Unit(s) of Observation:  View help for Unit(s) of Observation Police agency
Geographic Unit:  View help for Geographic Unit City

Usage Metrics

Overall Project Metrics







Download Detailed Metrics

Published Versions

Report a Problem

Found a serious problem with the data, such as disclosure risk or copyrighted content? Let us know.

Creative Commons License This work is licensed under a Creative Commons Attribution 4.0 International License.

openICPSR data are distributed exactly as they arrived from the data depositor. ICPSR has not checked or processed this material. Users should consult the investigator(s) if further information is desired.