search

Police-Data-Accessibility-Project / data-projects

A place to track data requests and responses.
MIT License
0 stars 0 forks source link

Comparative data for arrest rates by race #6

Closed josh-chamberlain closed 1 month ago

josh-chamberlain commented 1 month ago

From the requestor:

I am looking for arrest rates by race in other cities. Do you have a listing or source? I only need Black and white arrests for the latest year available. I have Chicago arrests from the latest police annual report as well as Pittsburgh’s. If you find Black and white population along with the arrest data, as in Pittsburgh’s reports, that would be helpful too since I am calculating black/white arrest rate ratios.

How to help:

Start by checking the arrest records in our database: https://data-sources.pdap.io/search/arrest/all

Comment on this issue if you find any sources which seem to contain enough demographic info to answer the question for the most recent reported year. A list of URLs is fine for now.

BBarr-PDAP commented 1 month ago

1.) Arrest Records for Charleston Police Department - SC https://www.arcgis.com/apps/MapSeries/index.html?appid=fad2a3f085c644d0b014b507d23bcd9a (Downloadable CSV Spreadsheet for each year, including 2024).

2.) Arrest Records for Dougherty County Sheriff's Office - GA http://66.110.195.53/p2c_dcso/jailinmates.aspx (No option to download arrest records, but provides arrest records for 2024 by race specifically).

3.) Arrest Records for Tucson Police Department - AZ https://data-cotgis.opendata.arcgis.com/datasets/9991acc4853843c18c5d7c894f6b7cb7_11/explore (Downloadable CSV Spreadsheet, mostly 2020-22).

4.) Arrest Records for Bridgeport Police Department - CT https://www.bridgeportct.gov/government/departments/police-department/bridgeport-police-blotter (PDF Monthly Arrest/Crime Reports including Race of offenders).

5.) Arrest Records for Oakland Police Department - CA https://app.powerbigov.us/view?r=eyJrIjoiMzZkODc3OWYtOWY2Yy00MWZkLTg4YjEtOGZkNTRjNjYzM2Q2IiwidCI6Ijk4OWEyMTgwLTZmYmMtNDdmMS04MDMyLTFhOWVlOTY5YzU4ZCJ9&pageName=ReportSection0c973751e9159c87efbb (Provides total numbers of arrests by race and type of offense).

6.) Arrest Records for Colorado Springs Police Department - CO https://policedata.coloradosprings.gov/Arrest/Arrest-Data-Subject-Level/34jw-x9zp/data_preview (Downloadable CSV Spreadsheet ranges from 2015 to Present).

7.) Arrest Records for Manchester Police Department - NH https://www.manchesternh.gov/Portals/2/Departments/police_blog/Police%20Log.pdf (PDF file of 2024 arrest records including Race).

8.) Arrest Records for Pittsfield Police Department - MA https://www.pittsfieldpd.org/open-data-portal/ (Downloadable CSV Spreadsheet for 2024 YTD arrest records including Race).

9.) Arrest Records for Chicago Police Department - IL https://data.cityofchicago.org/Public-Safety/Arrests/dpt3-jri9/data_preview (I believe the requestor may have this data, but includes a downloadable CSV spreadsheet from 2015 to 2024 arrest records including Race).

10.) Arrest Records for Durham Police Department - NC https://www.arcgis.com/sharing/rest/content/items/623d73fa151b4206b4467cdc1f903ed4/data (Excel Spreadsheet download for arrest records from 2018 to 2023 including Race).

11.) Arrest Records for Baltimore Police Department - MD https://data.baltimorecity.gov/datasets/bpd-arrests/explore (Downloadable CSV for 2024 arrest records including Race).

12.) Arrest Records for Washington Metropolitan Police Department - DC https://opendata.dc.gov/datasets/adult-arrests/explore (Downloadable CSV of arrest records from 2013 to 2023).

13.) Arrest Records for Los Angeles Police Department - CA https://data.lacity.org/Public-Safety/Arrest-Data-from-2020-to-Present/amvf-fr72/about_data (Downloadable CSV from 2020 to Present of arrest records including Race).

14.) Arrest Records for New York City Police Department - NY https://data.cityofnewyork.us/Public-Safety/NYPD-Arrests-Data-Historic-/8h9b-rp9u/data_preview (Downloadable CSV arrest records for 2023 including Race).

15.) Arrest Records for Dallas Police Department - TX https://www.dallasopendata.com/Public-Safety/Police-Arrests/sdr7-6v3j/about_data (Downloadable CSV of arrest records from 2018 to 2024 including Race).

16.) Arrest Records for Chattanooga Police Department - TN https://internal.chattadata.org/Public-Safety/Public-CPD-Arrest-Charges/v9y9-uavb/about_data (Downloadable CSV of arrest records from 2021 to 2024 including Race).

17.) Arrest Records for Phoenix Police Department - AZ https://phoenixopendata.com/dataset/arrests/resource/1eaee7f1-ccd0-4057-af55-e5749a934258 (Downloadable CSV of arrest records from 2018 to Present including Race).

18.) Arrest Records for Providence Police Department - RI https://data.providenceri.gov/Public-Safety/Providence-Police-Department-Arrests-and-Citations/vank-fyx9/about_data (Downloadable CSV of arrest records for 2024 including Race).

I believe this concludes the list from the database. There were a few sources which had graphs displaying number of arrests by race that I did not include except one I believe. Also, there were several URLs which did not properly load; I tried to manually find the arrest records but I could not for a lot of them. Hope this helps!

josh-chamberlain commented 1 month ago

Wow. That is extremely helpful. Exactly what I need.

nice work @BBarr-PDAP !