Dataset: City Of Pittsburgh Property Tax Delinquency

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.7 MB
30158 rows
19 columns


CREATE TABLE tax_delinquency (
  "n__id" BIGINT,
  "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
);