About this Dataset

Pittsburgh Police Arrest Data

Arrest data contains information on people taken into custody by City of Pittsburgh police officers. More serious crimes such as felony offenses are more likely to result in an arrest. However, arrests can occur as a result of other offenses, such as parole violations or a failure to appear for trial. All data is reported at the block/intersection level, with the exception of sex crimes, which are reported at the police zone level. This dataset only contains information reported by City of Pittsburgh Police. It does not contain information about incidents that solely involve other police departments operating within the city (for example, campus police or Port Authority police). More documentation is available in our Crime Data Guide.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:11.481411
Tags: _etl, arrest, custody, failure-to-appear-for-trial, felony, offenses, parole-violation, police, public-safety

Tables

Arrests

@usgov.allegheny_county_city_of_pitts_pittsburgh_police_arrest_data.arrests

4.6 MB
66,485 rows
17 columns

CREATE TABLE arrests (
  "n__id" BIGINT  -- Id,
  "pk" BIGINT,
  "ccr" BIGINT,
  "age" DOUBLE,
  "gender" VARCHAR,
  "race" VARCHAR,
  "arresttime" TIMESTAMP,
  "arrestlocation" VARCHAR,
  "offenses" VARCHAR,
  "incidentlocation" VARCHAR,
  "incidentneighborhood" VARCHAR,
  "incidentzone" VARCHAR,
  "incidenttract" DOUBLE,
  "council_district" DOUBLE,
  "public_works_division" DOUBLE,
  "x" VARCHAR,
  "y" VARCHAR
);