About this Dataset

Allegheny County Kane Regional Center Census

Total number of residents in each Kane Regional Center facility by race and gender. The Kane Regional Centers are skilled nursing and rehabilitation centers run by Allegheny County.

A census of residents recorded once a week.

NOTE: The feed updating this dataset is currently not functioning. We're working to update the available data and get a new feed working.

The reports from the legacy system broke before that system was taken offline, and so the reports from September 2019 to February 2020 cannot be run.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:08:34.162550
Tags: _etl, aging, census, nursing, nursing-homes, seniors

Tables

Kane Census (supplement)

@usgov.allegheny_county_city_of_pitts_allegheny_county_kane_r_f3a9da50.kane_census_supplement

18.88 kB
10,107 rows
5 columns

CREATE TABLE kane_census_supplement (
  "facility" VARCHAR,
  "date" TIMESTAMP,
  "race" VARCHAR,
  "sex" VARCHAR,
  "patient_count" BIGINT
);

Kane Facility Code Lookup

@usgov.allegheny_county_city_of_pitts_allegheny_county_kane_r_f3a9da50.kane_facility_code_lookup

2.29 kB
4 rows
2 columns

CREATE TABLE kane_facility_code_lookup (
  "code" BIGINT,
  "name" VARCHAR
);