Dataset: Condemned And Dead-End Properties

About this Dataset

Condemned And Dead-End Properties

This dataset contains condemned properties in the City of Pittsburgh and is maintained by the Department of Permits, Licenses, and Inspections (PLI). Some of the properties are labelled as "dead-end", which means that they are condemned properties for which PLI cannot locate the owner. Properties are classified as "dead end" if multiple attempts to make contact with the owner fail.

This dataset contains information about the property condition, location, and owner of each property condemned in the City of Pittsburgh.

Motivation/Collection

These pages provide more information about how and why the data on condemned properties is collected:

Notes

Currently, some parcel_id values appear in multiple records, leading to the same property appearing multiple times, with different values for fields like latest_inspection_score . This will be fixed soon.
The numerical range for latest_inspection_score is currently 0-62, but the system is being adjusted, and eventually these scores will be adjusted to a 1-4 scale.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-02-14T22:44:32.960987
Tags: _etl, condemned, parcel_id, pli, properties

Tables

Condemned Properties

@usgov.allegheny_county_city_of_pitts_condemned_and_dead_end__2ac4fcb0.condemned_properties

154.75 KB
4322 rows
10 columns


CREATE TABLE condemned_properties (
  "n__id" BIGINT,
  "reserved_id" VARCHAR,
  "parcel_id" VARCHAR,
  "address" VARCHAR,
  "owner" VARCHAR,
  "property_type" VARCHAR,
  "date" TIMESTAMP,
  "latest_inspection_result" VARCHAR,
  "latest_inspection_score" DOUBLE,
  "inspection_status" VARCHAR
);