About this Dataset

Allegheny County Human Services Community Profiles

The Allegheny County data warehouse was created to support integrated social services for people and to improve decision-making to create better systems to serve people in the County. The warehouse is managed by the Allegheny County Department of Human Services (DHS).

This resource uses information from the warehouse and provides Municipality and Pittsburgh Neighborhood level information for specific community indicators and for individuals receiving specific DHS services.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:19.405364
Tags: _etl, human-services, programs, social-services

Tables

Municipality Profiles

@usgov.allegheny_county_city_of_pitts_allegheny_county_human__dc8ac222.municipality_profiles

150.94 KB
17292 rows
9 columns


CREATE TABLE municipality_profiles (
  "n__id" BIGINT,
  "metric_name" VARCHAR,
  "report_group" VARCHAR,
  "calendar_year" BIGINT,
  "kpi_count" DOUBLE,
  "geo_area_name" VARCHAR,
  "population_name" VARCHAR,
  "acs_5_yr_est" BIGINT,
  "kpi_population" DOUBLE
);

Pittsburgh Neighborhood Profiles

@usgov.allegheny_county_city_of_pitts_allegheny_county_human__dc8ac222.pittsburgh_neighborhood_profiles

85.72 KB
11119 rows
6 columns


CREATE TABLE pittsburgh_neighborhood_profiles (
  "n__id" BIGINT,
  "metric_name" VARCHAR,
  "report_group" VARCHAR,
  "calendar_year" BIGINT,
  "kpi_count" DOUBLE,
  "geo_area_name" VARCHAR
);