About this Dataset

Property Data With Geographic Identifiers

These datasets are clones of popular WPRDC datasets from various publishers that have been reverse-geocoded to add geographic identifiers (e.g., municipality and neighborhood).

Follow the links in the file descriptions for more information on the original datasets.

If you get a timeout error when trying to download either "Property Assessment Parcel Data" or "Property Assessment Data with Parcel Centroids", click on the Preview link and use the alternative download link (which should contain the term "downstream").
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:16.584891
Tags: _etl, assessment, parcel, property, real-estate, sales

Tables

Property Assessment Data With Parcel Centroids

@usgov.allegheny_county_city_of_pitts_property_with_geographi_3626329e.property_assessment_data_with_parcel_centroids

95.54 MB
544000 rows
89 columns


CREATE TABLE property_assessment_data_with_parcel_centroids (
  "n__id" BIGINT,
  "parid" VARCHAR,
  "propertyhousenum" BIGINT,
  "propertyfraction" VARCHAR,
  "propertyaddress" VARCHAR,
  "propertycity" VARCHAR,
  "propertystate" VARCHAR,
  "propertyunit" VARCHAR,
  "propertyzip" BIGINT,
  "municode" BIGINT,
  "munidesc" VARCHAR,
  "schoolcode" BIGINT,
  "schooldesc" VARCHAR,
  "legal1" VARCHAR,
  "legal2" VARCHAR,
  "legal3" VARCHAR,
  "neighcode" VARCHAR,
  "neighdesc" VARCHAR,
  "taxcode" VARCHAR,
  "taxdesc" VARCHAR,
  "taxsubcode" VARCHAR,
  "taxsubcode_desc" VARCHAR,
  "ownercode" BIGINT,
  "ownerdesc" VARCHAR,
  "class" VARCHAR,
  "classdesc" VARCHAR,
  "usecode" BIGINT,
  "usedesc" VARCHAR,
  "lotarea" BIGINT,
  "homesteadflag" VARCHAR,
  "cleangreen" VARCHAR,
  "farmsteadflag" VARCHAR,
  "abatementflag" VARCHAR,
  "recorddate" VARCHAR,
  "saledate" VARCHAR,
  "saleprice" DOUBLE,
  "salecode" VARCHAR,
  "saledesc" VARCHAR,
  "deedbook" VARCHAR,
  "deedpage" VARCHAR,
  "prevsaledate" VARCHAR,
  "prevsaleprice" DOUBLE,
  "prevsaledate2" VARCHAR,
  "prevsaleprice2" DOUBLE,
  "changenoticeaddress1" VARCHAR,
  "changenoticeaddress2" VARCHAR,
  "changenoticeaddress3" VARCHAR,
  "changenoticeaddress4" VARCHAR,
  "countybuilding" BIGINT,
  "countyland" BIGINT,
  "countytotal" BIGINT,
  "countyexemptbldg" BIGINT,
  "localbuilding" BIGINT,
  "localland" BIGINT,
  "localtotal" BIGINT,
  "fairmarketbuilding" BIGINT,
  "fairmarketland" BIGINT,
  "fairmarkettotal" BIGINT,
  "style" VARCHAR,
  "styledesc" VARCHAR,
  "stories" DOUBLE,
  "yearblt" DOUBLE,
  "exteriorfinish" DOUBLE,
  "extfinish_desc" VARCHAR,
  "roof" DOUBLE,
  "roofdesc" VARCHAR,
  "basement" DOUBLE,
  "basementdesc" VARCHAR,
  "grade" VARCHAR,
  "gradedesc" VARCHAR,
  "condition" DOUBLE,
  "conditiondesc" VARCHAR,
  "cdu" VARCHAR,
  "cdudesc" VARCHAR,
  "totalrooms" DOUBLE,
  "bedrooms" DOUBLE,
  "fullbaths" DOUBLE,
  "halfbaths" DOUBLE,
  "heatingcooling" VARCHAR,
  "heatingcoolingdesc" VARCHAR,
  "fireplaces" DOUBLE,
  "bsmtgarage" DOUBLE,
  "finishedlivingarea" DOUBLE,
  "cardnumber" DOUBLE,
  "alt_id" VARCHAR,
  "taxyear" BIGINT,
  "asofdate" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Property Sales Data With Parcel Centroids

@usgov.allegheny_county_city_of_pitts_property_with_geographi_3626329e.property_sales_data_with_parcel_centroids

11.78 MB
216464 rows
27 columns


CREATE TABLE property_sales_data_with_parcel_centroids (
  "n__id" BIGINT,
  "parid" VARCHAR,
  "propertyhousenum" DOUBLE,
  "propertyfraction" VARCHAR,
  "propertyaddressdir" VARCHAR,
  "propertyaddressstreet" VARCHAR,
  "propertyaddresssuf" VARCHAR,
  "propertyaddressunitdesc" VARCHAR,
  "propertyunitno" VARCHAR,
  "propertycity" VARCHAR,
  "propertystate" VARCHAR,
  "propertyzip" BIGINT,
  "schoolcode" BIGINT,
  "schooldesc" VARCHAR,
  "municode" BIGINT,
  "munidesc" VARCHAR,
  "recorddate" VARCHAR,
  "saledate" TIMESTAMP,
  "price" DOUBLE,
  "deedbook" VARCHAR,
  "deedpage" VARCHAR,
  "salecode" VARCHAR,
  "saledesc" VARCHAR,
  "instrtyp" VARCHAR,
  "instrtypdesc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);