About this Dataset

Allegheny County Sheriff Sales

List of properties up for auction at a Sheriff Sale. Datasets labeled "Current" contain this month's postings, while those labeled "Archive" contain a running list of all postings uploaded to the WPRDC.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:16.584558
Tags: _etl, foreclosure, property, real-estate, sheriff-sale, tax-lien

Tables

Archive Bid List

@usgov.allegheny_county_city_of_pitts_allegheny_county_sheriff_sales.archive_bid_list

1.09 MB
10631 rows
25 columns


CREATE TABLE archive_bid_list (
  "n__id" BIGINT,
  "salenumber" VARCHAR,
  "docketnumber" VARCHAR,
  "id" DOUBLE,
  "attorneyname" VARCHAR,
  "plaintiff" VARCHAR,
  "defendant" VARCHAR,
  "saletype" VARCHAR,
  "saledate" TIMESTAMP,
  "salestatus" VARCHAR,
  "ppdate" TIMESTAMP,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "address" VARCHAR,
  "municipality" VARCHAR,
  "coststaxes" DOUBLE,
  "servicecompleted" DOUBLE,
  "delivered3129" VARCHAR,
  "readyforsale" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additionalnotes" VARCHAR,
  "recorddate" TIMESTAMP
);

Archive Postponement List

@usgov.allegheny_county_city_of_pitts_allegheny_county_sheriff_sales.archive_postponement_list

829.35 KB
6831 rows
26 columns


CREATE TABLE archive_postponement_list (
  "n__id" BIGINT,
  "salenumber" VARCHAR,
  "docketnumber" VARCHAR,
  "attorneyname" VARCHAR,
  "plaintiff" VARCHAR,
  "defendant" VARCHAR,
  "saletype" VARCHAR,
  "saledate" TIMESTAMP,
  "salestatus" VARCHAR,
  "ppdate" TIMESTAMP,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "address" VARCHAR,
  "municipality" VARCHAR,
  "coststaxes" DOUBLE,
  "servicescomplete" DOUBLE,
  "delivered3129" VARCHAR,
  "readyforsale" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additionalnotes" VARCHAR,
  "salemonthnum" DOUBLE,
  "saleyear" DOUBLE,
  "recorddate" TIMESTAMP
);

Archive Postponement Sales Results

@usgov.allegheny_county_city_of_pitts_allegheny_county_sheriff_sales.archive_postponement_sales_results

950.12 KB
7426 rows
26 columns


CREATE TABLE archive_postponement_sales_results (
  "n__id" BIGINT,
  "salenumber" VARCHAR,
  "docketnumber" VARCHAR,
  "attorneyname" VARCHAR,
  "plaintiff" VARCHAR,
  "defendant" VARCHAR,
  "saletype" VARCHAR,
  "saledate" TIMESTAMP,
  "salestatus" VARCHAR,
  "ppdate" TIMESTAMP,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "address" VARCHAR,
  "municipality" VARCHAR,
  "coststaxes" DOUBLE,
  "servicescomplete" DOUBLE,
  "delivered3129" VARCHAR,
  "readyforsale" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additionalnotes" VARCHAR,
  "salemonthnum" DOUBLE,
  "saleyear" DOUBLE,
  "recorddate" TIMESTAMP
);

Archive Sales Results

@usgov.allegheny_county_city_of_pitts_allegheny_county_sheriff_sales.archive_sales_results

1.6 MB
13452 rows
25 columns


CREATE TABLE archive_sales_results (
  "n__id" BIGINT,
  "salenumber" VARCHAR,
  "docketnumber" VARCHAR,
  "id" DOUBLE,
  "attorneyname" VARCHAR,
  "plaintiff" VARCHAR,
  "defendant" VARCHAR,
  "saletype" VARCHAR,
  "saledate" TIMESTAMP,
  "salestatus" VARCHAR,
  "ppdate" TIMESTAMP,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "address" VARCHAR,
  "municipality" VARCHAR,
  "coststaxes" DOUBLE,
  "servicecompleted" DOUBLE,
  "delivered3129" VARCHAR,
  "readyforsale" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additionalnotes" VARCHAR,
  "recorddate" TIMESTAMP
);

Current Bid List

@usgov.allegheny_county_city_of_pitts_allegheny_county_sheriff_sales.current_bid_list

37.42 KB
108 rows
25 columns


CREATE TABLE current_bid_list (
  "n__id" BIGINT,
  "salenumber" VARCHAR,
  "docketnumber" VARCHAR,
  "id" BIGINT,
  "attorneyname" VARCHAR,
  "plaintiff" VARCHAR,
  "defendant" VARCHAR,
  "saletype" VARCHAR,
  "saledate" TIMESTAMP,
  "salestatus" VARCHAR,
  "ppdate" TIMESTAMP,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "address" VARCHAR,
  "municipality" BIGINT,
  "coststaxes" DOUBLE,
  "servicecompleted" BIGINT,
  "delivered3129" BOOLEAN,
  "readyforsale" BOOLEAN,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additionalnotes" VARCHAR,
  "recorddate" TIMESTAMP
);

Current Postponement List

@usgov.allegheny_county_city_of_pitts_allegheny_county_sheriff_sales.current_postponement_list

27.14 KB
63 rows
26 columns


CREATE TABLE current_postponement_list (
  "n__id" BIGINT,
  "salenumber" VARCHAR,
  "docketnumber" VARCHAR,
  "attorneyname" VARCHAR,
  "plaintiff" VARCHAR,
  "defendant" VARCHAR,
  "saletype" VARCHAR,
  "saledate" TIMESTAMP,
  "salestatus" VARCHAR,
  "ppdate" TIMESTAMP,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "address" VARCHAR,
  "municipality" BIGINT,
  "coststaxes" DOUBLE,
  "servicecompleted" VARCHAR,
  "delivered3129" VARCHAR,
  "readyforsale" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additionalnotes" VARCHAR,
  "salemonthnum" VARCHAR,
  "saleyear" VARCHAR,
  "recorddate" TIMESTAMP
);

Current Postponement Sales Results

@usgov.allegheny_county_city_of_pitts_allegheny_county_sheriff_sales.current_postponement_sales_results

46.37 KB
205 rows
26 columns


CREATE TABLE current_postponement_sales_results (
  "n__id" BIGINT,
  "salenumber" VARCHAR,
  "docketnumber" VARCHAR,
  "attorneyname" VARCHAR,
  "plaintiff" VARCHAR,
  "defendant" VARCHAR,
  "saletype" VARCHAR,
  "saledate" TIMESTAMP,
  "salestatus" VARCHAR,
  "ppdate" TIMESTAMP,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "address" VARCHAR,
  "municipality" BIGINT,
  "coststaxes" DOUBLE,
  "servicecompleted" VARCHAR,
  "delivered3129" VARCHAR,
  "readyforsale" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additionalnotes" VARCHAR,
  "salemonthnum" VARCHAR,
  "saleyear" VARCHAR,
  "recorddate" TIMESTAMP
);