About this Dataset

City Of Pittsburgh Property Tax Delinquency

This dataset contains all property in the City of Pittsburgh that is delinquent on property taxes for the given year.

NOTE: The data feed for this dataset stopped updating in late December. We are working to fix it.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:03:05.387843
Tags: _etl, abandoned, blight, delinquent, finance, fiscal-abandonment, pittsburgh, property-tax, real-estate, tax-delinquent, taxes, treasury

Tables

Tax Delinquency

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_prop_d1ef6370.tax_delinquency

1.78 MB
30,158 rows
19 columns

CREATE TABLE tax_delinquency (
  "n__id" BIGINT  -- Id,
  "pin" VARCHAR,
  "address" VARCHAR,
  "billing_city" VARCHAR,
  "current_delq_tax" DOUBLE,
  "current_delq_pi" DOUBLE,
  "prior_years" BIGINT,
  "prior_delq_tax" DOUBLE,
  "prior_delq_pi" DOUBLE,
  "state_description" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" DOUBLE,
  "ward" DOUBLE,
  "public_works_division" DOUBLE,
  "pli_division" DOUBLE,
  "police_zone" DOUBLE,
  "fire_zone" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);