Jacob Kaplan bio photo

Jacob Kaplan

PhD candidate in Criminology at the University of Pennsylvania

Email Github LinkedIn Twitter

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 jkkaplan6@gmail.com.

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 the


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.

About Me

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.


Projects I Have Done