U.S. Rape Clearance Data (2014-2016)
- Type of resource
- Stanford (Calif.) : Big Local News, 2018
- Date created
Also available at
Item belongs to a collection
The Big Local News project is part of the Stanford Journalism and Democracy Initiative. The aim of the project is to collect, process and share U.S. government information and public records data that is difficult to obtain and analyze. Through partnerships with local and national newsrooms, the Big Local team collects, cleans, normalizes, and aggregates local data for wider comparisons across, cities, counties and states. This project examines a wide range of issues including criminal justice, housing, health and education for accountability journalism. , The Big Local News project is part of the Stanford Journalism and Democracy Initiative. The aim of the project is to collect, process and share U.S. government information and public records data that is difficult to obtain and analyze. Through partnerships with local and national newsrooms, the Big Local team collects, cleans, normalizes, and aggregates local data for wider comparisons across, cities, counties and states. This project examines a wide range of issues including criminal justice, housing, health and education for accountability journalism.
- Digital collection
- 6 digital items
- Preferred citation
- Fahey, Mark et al. (2018) U.S. Rape Clearance Data (2014-2016). Stanford Digital Repository. Available at: http://purl.stanford.edu/ns801cg2606
- This data was collected as part of an investigation by Newsy, Reveal, and ProPublica into how police process rape cases. Newsy requested internal case management data for all Part I crimes (as defined by the FBI’s Uniform Crime Reporting program) from every major law enforcement agency in the United States serving a population of at least 300,000 people. The data provided in this download (analysis.csv) includes annual counts of total rape cases and number of clearances by type (arrest, unfounded, and exceptional) for each jurisdiction, as well as the columns in the data provided by the agencies that were used to distinguish rape cases from other crimes, to divide the data by reporting year and to tally case dispositions as either unfounded, cleared by arrest or cleared by exceptional means. (A complete description of the included fields is included below.)
- To create this data, the authors sent record requests to 103 law enforcement agencies and, as of initial publication, received data from 69 agencies. As of November 14, 2018, five agencies were excluded from the graphic due to accuracy concerns identified in the data provided by the agency (Oklahoma City PD, Maricopa County PD, Pittsburgh PD, El Paso PD and New York PD) but are still included in this data set. A copy of the request sent to each jurisdiction is included with the download (records_request.txt).
- The requests were for the years 2014 through 2016 and included the incident number of the offense, the date, the type of offense, whether it was unfounded, the date it was unfounded, the date it was cleared, the arrest date, the type of clearance and the reason for exceptional clearance if applicable. The authors parsed data from the FBI’s summary and NIBRS master files for the three years and calculated reported FBI clearance rates alongside the analysis of the internal data from each jurisdiction.
- Through the analysis the authors found that it was common for agencies to use a reporting category called “clearance by exceptional means” to mark rape cases as cleared without making an arrest, inflating the clearance rates that are often cited as a measure of police effectiveness. The FBI reporting system used by most agencies nationwide (summary UCR) does not distinguish between the two types of clearance. These data provide a window into how often these agencies are using exceptional means to clear rape cases, as well as the prevalence of unfounded rape reports for jurisdictions that do not report that total to the FBI. For most jurisdictions, they also provide the means for local journalists to request specific reports by case or incident number.
- Each agency was contacted in the course of reporting to discuss the correct interpretation of the data provided and users are encouraged to reach out to local agencies to gain an appropriate understanding of the limitations and caveats associated with each set of data. Questions about our interpretation of the data can be directed to email@example.com .
- Upon request, Newsy can provide additional files containing additional data provided by each agency on rape cases. The columns are as provided with the exception of any column named “YEAR,” which was added when data were provided in separate files or tabs for each year, and any column starting with the letters “MF,” which are columns that were added in the course of processing the data. All of the files have been restricted to rape cases as defined in the analysis file and data dictionary, and in some cases fields have been dropped from the originals to remove personally identifiable information.
- To request information for one or more jurisdictions, please contact firstname.lastname@example.org.
- See below for the agency and FBI ORI number associated with each file name.
- ANNEARUNDEL.csv -- Anne Arundel County PD, Maryland (MD00202)
- ARLINGTON.csv -- Arlington PD, Texas (TX22001)
- ATLANTA.csv -- Atlanta PD, Georgia (GAAPD00)
- AURORA.csv -- Aurora PD, Colorado (CO00101)
- AUSTIN.csv -- Austin PD, Texas (TX22701)
- BAKERSFIELD.csv -- Bakersfield PD, California (CA01502)
- BALTIMORECOUNTY.csv -- Baltimore County PD, Maryland (MD00301)
- BALTIMORE.csv -- Baltimore PD, Maryland (MDBPD00)
- BOSTON.csv -- Boston PD, Massachusetts (MA01301)
- CHARLOTTEMECKLENBURG.csv -- Charlotte-Mecklenburg PD, North Carolina (NC06001)
- CHESTERFIELD.csv -- Chesterfield County PD, Virginia (VA02101)
- CHICAGO.csv -- Chicago PD, Illinois (ILCPD00)
- COBB.csv -- Cobb County PD, Georgia (GA03302)
- COLLIER.csv -- Collier County Sheriff’s Office, Florida (FL01100)
- COLORADOSPRINGS.csv -- Colorado Springs PD, Colorado (CO02101)
- COLUMBUS.csv -- Columbus PD, Ohio (OHCOP00)
- CORPUSCHRISTI.csv -- Corpus Christi PD, Texas (TX17802)
- DALLAS.csv -- Dallas PD, Texas (TXDPD00)
- DENVER.csv -- Denver PD, Colorado (CODPD00) ELPASO.csv -- El Paso PD, Texas (TX07102)
- FAIRFAX.csv -- Fairfax County PD, Virginia (VA02901)
- FORTWORTH.csv -- Fort Worth PD, Texas (TX22012)
- GREENVILLE.csv -- Greenville County Sheriff’s Office, South Carolina (SC02300)
- HENRICO.csv -- Henrico County PD, Virginia (VA04301)
- HILLSBOROUGH.csv -- Hillsborough Sheriff’s Office, Florida (FL02900)
- HONOLULU.csv -- Honolulu City and County PD, Hawaii (HI00200)
- HOWARD.csv -- Howard County PD, Maryland (MD01401)
- INDIANAPOLIS.csv -- Indianapolis, Indiana (INIPD00)
- KANSASCITY.csv -- Kansas City PD, Missouri (MOKPD00)
- KERN.csv -- Kern County Sheriff’s Office, California (CA01500)
- LEE.csv -- Lee County Sheriff’s Office, Florida (FL03600)
- LEXINGTON.csv -- Lexington PD, Kentucky (KY03402)
- LONGBEACH.csv -- Long Beach PD, California (CA01941)
- LOSANGELESCITY.csv -- Los Angeles PD, California (CA01942)
- LOUDOUN.csv -- Loudoun County Sheriff’s Office, Virginia (VA05300)
- LOUISVILLE.csv -- Louisville PD, Kentucky (KY05680)
- MARICOPA.csv -- Maricopa County PD, Arizona (AZ00700)
- MEMPHIS.csv -- Memphis PD, Tennessee (TNMPD00)
- MIAMI.csv -- Miami PD, Florida (FL01306)
- MIAMIDADE.csv -- Miami-Dade County PD, Florida (FL01300)
- MONTGOMERY.csv -- Montgomery County PD, Maryland (MD01604)
- Stanford Digital Repository
- Use and reproduction
- User agrees that, where applicable, content will not be used to identify or to otherwise infringe the privacy or confidentiality rights of individuals. Content distributed via the Stanford Digital Repository may be subject to additional license and use restrictions applied by the depositor.