Using This Site
This site makes it easy for people to analyze crime, arrest, and police death/assault data without having to analyze raw data themselves. Select a page to look at the type of data you're interested in. The data come from the raw data compiled by the FBI as part of the Uniform Crime Reporting (UCR) Program data sets. The data from the FBI are raw, meaning that the data is in difficult to use format (e.g. SPSS+setup file rather than an R or Excel file), with a number of issues in combining years such as columns being labeled differently or the data containing erroneous values (e.g. agencies reporting more officers killed in a month than work there).
What you see here is the result of my cleaning and compiling of all of that data into data sets readily available for research. As a supplement to the data itself, the tools here make quick analysis possible for individual agencies. Neither the site nor the data are perfect. If you have any questions, feedback or find any bugs please email me at firstname.lastname@example.org.
Due to file size limits and to make the site run as fast as possible, what is available here is only a subset of the total data available. To get the complete data please follow the links to the desired data set in theData
page. The data sets there contain the complete file (i.e. all variables for all agencies in all years) for a number of data formats such as R, Stata, and SPSS.
I am a PhD candidate in Criminology at the University of Pennsylvania. My research focuses on Crime Prevention Through Environmental Design (CPTED), specifically on the effect of door locks and outdoor lighting on crime. My other interests include making crime data more accessible to the public, the effect of marijuana of interpersonal violence, and the role of private action in crime prevention.
- asciiSetupReader: Open an 'SPSS' or 'SAS' data file using a .txt file that has the data and a .sps or .sas file with setup instructions.
- fastDummies: Quickly create dummy columns and rows for data analysis.
- boxoffice: Download daily box office information (how much each movie earned in theaters).
Projects I Have Done
- I worked with the NACJD team to produce their second ever Justice Data Learning Guide. This guide explained how to use the Law Enforcement Agencies Identfiers Crosswalk (LEAIC). The guide can be found here.
- My website Crime by the Numbers provides analysis of crime data as well as advice on how to work with certain crime data sets.