Dataset: City Treasury Sales

About this Dataset

City Treasury Sales

A listing of all the properties currently available for sale at the City's Treasurer Sale.

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:07.121322
Tags: _etl, delinquency, finance, property, real-estate, sale, treasury

Tables

City Treasury Sales

@usgov.allegheny_county_city_of_pitts_city_treasury_sales.city_treasury_sales

23.98 KB
62 rows
24 columns


CREATE TABLE city_treasury_sales (
  "n__id" BIGINT,
  "pin" VARCHAR,
  "address" VARCHAR,
  "treasury_sale_date" TIMESTAMP,
  "treasury_sale_flag" VARCHAR,
  "total_tax_due" DOUBLE,
  "city_tax_due" DOUBLE,
  "county_tax_due" DOUBLE,
  "school_tax_due" DOUBLE,
  "library_tax_due" DOUBLE,
  "pwsa_tax_due" DOUBLE,
  "parks_tax_due" DOUBLE,
  "demo_cost_due" BIGINT,
  "clean_lien_due" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "neighborhood_name" VARCHAR,
  "council_district" BIGINT,
  "ward" BIGINT,
  "police_zone" BIGINT,
  "fire_zone" VARCHAR,
  "dpw_streets" BIGINT,
  "dpw_enviro" VARCHAR,
  "dpw_parks" VARCHAR
);