About this Dataset

Allegheny County Assets

This dataset contains lists of various kinds of assets (open prior to or as of March 1, 2020), derived from a variety of local, state, and federal data sources. Some of this data still needs to be verified, as this is a work in progress. Some geocoding is either missing or incorrect. Improvements are pending.

This data was assembled to support 2020 Census outreach efforts, and can also be used to support COVID-19 response efforts.

A companion map displaying this data has also been created to support Census outreach. It too is a work in progress, and we'll be adding new features in the coming weeks.

Types of assets reflected in the data include (Note - we'll add additional source info. in coming days):

Allegheny County Housing Authority community sites, Allegheny County Health Department clinics, affordable housing properties, apartment buildings, banks, barbershops, bars, bus stops, child care centers, coffee shops, community nonprofit organizations, dentists, doctor's offices, faith-based facilities, family support centers, farmers' markets, food banks, gas stations, hair salons, health centers, homeless shelters, laundromats, libraries, museums, nail salons, nursing homes, park and rides, parks and facilities, pharmacies, polling places, post offices, public buildings, recreation centers, restaurants, schools, senior centers, supermarkets, universities, VA facilities, veterans social orgs, WIC offices, and WIC vendors.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2020-11-30T02:49:55.494412
Tags: _etl, assets, businesses, child, civic, early-childhood, faith, fast-food, food, grocery, health, housing, medical, museums, parks, pharmacy, post-offices, restaurant, restaurants, schools, supermarket, supermarkets, transportation

Tables

Allegheny County Supermarkets (open As Of March 1, 2020)

@usgov.allegheny_county_city_of_pitts_allegheny_county_assets.allegheny_county_supermarkets_open_as_of_march_1_2020

17.97 KB
133 rows
12 columns


CREATE TABLE allegheny_county_supermarkets_open_as_of_march_1_2020 (
  "name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "localizability" VARCHAR,
  "data_source_name" VARCHAR,
  "data_source_url" VARCHAR,
  "primary_key_from_rocket" BIGINT,
  "asset_type" VARCHAR
);

Data Sources By Asset Type

@usgov.allegheny_county_city_of_pitts_allegheny_county_assets.data_sources_by_asset_type

7.74 KB
43 rows
4 columns


CREATE TABLE data_sources_by_asset_type (
  "asset_type" VARCHAR,
  "count" BIGINT,
  "concat_data_source_name" VARCHAR,
  "concat_data_source_url" VARCHAR
);