Dataset: Police Incident Blotter (Archive)

About this Dataset

Police Incident Blotter (Archive)

The Police Blotter Archive contains crime incident data after it has been validated and processed to meet Uniform Crime Reporting (UCR) standards, published on a nightly basis. This data validation process creates a data publishing delay of approximately thirty days. Users who require the most recent incident data should use the 30 Day Police Blotter. The 30 Day Police Blotter dataset contains more recent data, but has not yet been run through quality control and standardization procedures by the Police Bureau. 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, and does not contain incidents that solely involve other police departments operating within the city (campus police, Port Authority, etc.)

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:58:45.569306
Tags: _etl, archive, arrests, blotter, crimes, incident, police, public-safety, safety, ucr

Tables

Blotter Data (UCR Coded)

@usgov.allegheny_county_city_of_pitts_police_incident_blotter_archive.blotter_data_ucr_coded

17.68 MB
340996 rows
16 columns


CREATE TABLE blotter_data_ucr_coded (
  "n__id" BIGINT,
  "pk" BIGINT,
  "ccr" DOUBLE,
  "hierarchy" BIGINT,
  "incidenttime" TIMESTAMP,
  "incidentlocation" VARCHAR,
  "clearedflag" VARCHAR,
  "incidentneighborhood" VARCHAR,
  "incidentzone" VARCHAR,
  "incidenthierarchydesc" VARCHAR,
  "offenses" VARCHAR,
  "incidenttract" DOUBLE,
  "council_district" DOUBLE,
  "public_works_division" DOUBLE,
  "x" VARCHAR,
  "y" VARCHAR
);

Historical Blotter Data

@usgov.allegheny_county_city_of_pitts_police_incident_blotter_archive.historical_blotter_data

22.38 MB
495251 rows
13 columns


CREATE TABLE historical_blotter_data (
  "pk" BIGINT,
  "ccr" VARCHAR,
  "hierarchy" BIGINT,
  "incidenttime" TIMESTAMP,
  "incidentlocation" VARCHAR,
  "clearedflag" VARCHAR,
  "incidentneighborhood" VARCHAR,
  "incidentzone" VARCHAR,
  "hierarchydesc" VARCHAR,
  "offenses" VARCHAR,
  "incidenttract" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);