Tyler Data & Insights

Close
Author
Jere Matthews
Description
Weekly updates have finished with the June 28th update. “Note: Beginning 7/13/2022, the hospitals are no longer reporting data on airborne isolation beds resulting in null values being displayed for the airborne isolation bed metrics.” This dataset contains aggregate hospitalization data related to COVID-19 patient which includes availability of ICU beds, patients on ventilators, ventilators in use, and total patients hospitalized data at the state and county level for Pennsylvania residents. Data will be updated between 11:30 am to 1:30pm each Wednesday.
Category
Covid 19
Tags
covid, health, doh, hospital, virus, death
Rating
Current value: 0 out of 5
Data Provided By
Department of Health
Source Link
https://www.health.pa.gov/topics/disease/coronavirus/Pages/Cases.aspx
License
Public Domain U.S. Government
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

County
county
Date of data
date
Adult ICU Beds Available
icu_avail
Adult ICU Beds Total
icu_total
Medical/Surgical Beds Available
med_avail
Medical/Surgical Beds Total
med_total
Pediatric Beds Available
ped_avail
Pediatric Beds Total
ped_total
Pediatric ICU Beds Available
pic_avail
Pediatric ICU Beds Total
pic_total
COVID-19 Patients Hospitalized
covid_patients
COVID-19 Patients on Ventilators
covid_vents
Total Ventilators in use
vents_use
Total Ventilators
vents
14-day average Adult ICU beds available
icu_avail_mean
14-day average Adult ICU beds total
icu_total_mean
14-day average Medical/surgical beds available
med_avail_mean
14-day average Medical/surgical beds total
med_total_mean
14-day average Pediatric beds available
ped_avail_mean
14-day average Pediatric beds total
ped_total_mean
14-day average Pediatric ICU beds available
pic_avail_mean
14-day average Pediatric ICU beds total
pic_total_mean
14-day average COVID-19 patients hospitalized
covid_patients_mean
14-day average COVID-19 patients on ventilators
covid_vents_mean
14-day average Total ventilators in use
vents_use_mean
14-day average Total ventilators
vents_mean
Adult ICU beds, percent available
icu_percent
Medical/surgical beds, percent available
med_percent
Pediatric beds, percent available
ped_percent
Pediatric ICU beds, percent available
pic_percent
COVID-ICU
covid_icu
COVID-ICU Mean
covid_icu_mean
County FIPS
county_fips
Latitude
latitude
Longitude
longitude
Georeference Latitude & Longitude
georeference_latitude__longitude
Pennsylvania County Boundaries
:@computed_region_nmsq_hqvv
Pa Senatorial Districts (2020-01)
:@computed_region_d3gw_znnf
Municipality Boundary
:@computed_region_amqz_jbr4
Pa House Districts (2020-01)
:@computed_region_r6rf_p9et
Pa School Districts (2019-06)
:@computed_region_rayf_jjgk

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.