About this Dataset

Pennsylvania Vacant Addresses

Mail carriers routinely collect data on address no longer receiving mail due to vacancy. This vacancy data is reported quarterly at census tract geographies in the United States for residential, commercial, and industrial properties along with counts of total mailing addresses.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:07:50.442110
Tags: _etl, achd-dash, pennsylvania-vacant-addresses, postal, postal-service, social-determinants-of-health, usps, vacant-addresses, vacant-property

Tables

Vacant Property Rates 2016 Quarter 2 Data

@usgov.allegheny_county_city_of_pitts_pennsylvania_vacant_addresses.vacant_property_rates_2016_quarter_2_data

15.96 kB
393 rows
5 columns

CREATE TABLE vacant_property_rates_2016_quarter_2_data (
  "geoid" BIGINT,
  "tract1" BIGINT,
  "residentalbuildings" BIGINT,
  "residentialvacancies" BIGINT,
  "percent_of_vacant_properties" VARCHAR
);