COVID-19 Aggregate Hospitalizations Current Daily County Health

data.pa.gov | Last Updated 17 Jun 2021

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 9-11 am every day.

Tags: covid, covid-19, health, doh, hospital, covid19, virus, death

This dataset has the following 41 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
CountycountytextCounty, region, or state name
Date of datadatecalendar_dateDate of data, always 12:00 UTC
Airborn Isolation Beds Availableaii_availnumberAirborn isolation beds available
Airborn Isolation Beds Totalaii_totalnumberAirborn isolation beds total
Adult ICU Beds Availableicu_availnumberAdult ICU beds available
Adult ICU Beds Totalicu_totalnumberAdult ICU beds total
Medical/Surgical Beds Availablemed_availnumberMedical/surgical beds available
Medical/Surgical Beds Totalmed_totalnumberMedical/surgical beds total
Pediatric Beds Availableped_availnumberPediatrics beds available
Pediatric Beds Totalped_totalnumberPediatrics beds total
Pediatric ICU Beds Availablepic_availnumberPediatrics ICU beds available
Pediatric ICU Beds Totalpic_totalnumberPediatrics ICU beds total
COVID-19 Patients Hospitalizedcovid_patientsnumberCOVID-19 patients hospitalized
COVID-19 Patients on Ventilatorscovid_ventsnumberCOVID-19 patients on ventilators
Total Ventilators in usevents_usenumberTotal ventilators in use
Total VentilatorsventsnumberTotal ventilators
14-day average Airborne isolation beds availableaii_avail_meannumberAirborne isolation beds available, 14-day average
14-day average Airborne isolation beds totalaii_total_meannumberAirborne isolation beds total, 14-day average
14-day average Adult ICU beds availableicu_avail_meannumberAdult ICU beds available, 14-day average
14-day average Adult ICU beds totalicu_total_meannumberAdult ICU beds total, 14-day average
14-day average Medical/surgical beds availablemed_avail_meannumberMedical/surgical beds available, 14-day average
14-day average Medical/surgical beds totalmed_total_meannumberMedical/surgical beds total, 14-day average
14-day average Pediatric beds availableped_avail_meannumberPediatric beds available, 14-day average
14-day average Pediatric beds totalped_total_meannumberPediatric beds total, 14-day average
14-day average Pediatric ICU beds availablepic_avail_meannumberPediatric ICU beds available, 14-day average
14-day average Pediatric ICU beds totalpic_total_meannumberPediatric ICU beds total, 14-day average
14-day average COVID-19 patients hospitalizedcovid_patients_meannumberCOVID-19 patients hospitalized, 14-day average
14-day average COVID-19 patients on ventilatorscovid_vents_meannumberCOVID-19 patients on ventilators, 14-day average
14-day average Total ventilators in usevents_use_meannumberTotal ventilators in use, 14-day average
14-day average Total ventilatorsvents_meannumberTotal ventilators, 14-day average
Airborn isolation beds, percent availableaii_percentnumberAirborn isolation beds, percent available
Adult ICU beds, percent availableicu_percentnumberAdult ICU beds, percent available
Medical/surgical beds, percent availablemed_percentnumberMedical/surgical beds, percent available
Pediatric beds, percent availableped_percentnumberPediatric beds, percent available
Pediatric ICU beds, percent availablepic_percentnumberPediatric ICU beds, percent available
COVID-ICUcovid_icunumberCOVID Patients in Intensive Care Unit (ICU).
COVID-ICU Meancovid_icu_meannumberThe mean for COVID Patients in Intensive Care Unit (ICU), 14-day average.
County FIPScounty_fipstextThis is the 5-digit Federal Information Processing Standard (FIPS) code that designate the State association. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/geo/reference/codes/cou.html
LatitudelatitudetextThis is a latitude generic point within the county to help create map visualizations
LongitudelongitudetextThis is a longitude generic point within the county to help create map visualizations
Georeference Latitude & Longitudegeoreference_latitude__longitudepointGeoreferenced column for use in creating mapping visualizations with both a generic latitude and longitude of the county