pa-gov/covid19-aggregate-hospitalizations-current-daily-kayn-sjhx

  • covid
  • covid-19
  • covid19
  • death
  • doh
  • + 3

COVID-19 Aggregate Hospitalizations Current Daily County Health

COVID-19 Aggregate Hospitalizations Current Daily County Health

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Pediatric beds, percent availableped_percentped_percentNumberPediatric beds, percent available
14-day average Airborne isolation beds availableaii_avail_meanaii_avail_meanNumberAirborne isolation beds available, 14-day average
COVID-ICU Meancovid_icu_meancovid_icu_meanNumberThe mean for COVID Patients in Intensive Care Unit (ICU), 14-day average.
LongitudelongitudelongitudeTextThis is a longitude generic point within the county to help create map visualizations
Total VentilatorsventsventsNumberTotal ventilators
Pennsylvania County Boundaries:@computed_region_nmsq_hqvv:@computed_region_nmsq_hqvvNumberThis column was automatically created in order to record in what polygon from the dataset 'Pennsylvania County Boundaries' (nmsq-hqvv) the point in column 'georeference_latitude__longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Pa Senatorial Districts (2020-01):@computed_region_d3gw_znnf:@computed_region_d3gw_znnfNumberThis column was automatically created in order to record in what polygon from the dataset 'Pa Senatorial Districts (2020-01)' (d3gw-znnf) the point in column 'georeference_latitude__longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Georeference Latitude & Longitudegeoreference_latitude__longitudegeoreference_latitude__longitudePointGeoreferenced column for use in creating mapping visualizations with both a generic latitude and longitude of the county
14-day average Adult ICU beds availableicu_avail_meanicu_avail_meanNumberAdult ICU beds available, 14-day average
14-day average Pediatric ICU beds availablepic_avail_meanpic_avail_meanNumberPediatric ICU beds available, 14-day average
14-day average Medical/surgical beds totalmed_total_meanmed_total_meanNumberMedical/surgical beds total, 14-day average
14-day average Total ventilatorsvents_meanvents_meanNumberTotal ventilators, 14-day average
Pediatric ICU beds, percent availablepic_percentpic_percentNumberPediatric ICU beds, percent available
CountycountycountyTextCounty, region, or state name
Medical/surgical beds, percent availablemed_percentmed_percentNumberMedical/surgical beds, percent available
Date of datadatedateCalendar dateDate of data, always 12:00 UTC
Airborn Isolation Beds Totalaii_totalaii_totalNumberAirborn isolation beds total
Adult ICU beds, percent availableicu_percenticu_percentNumberAdult ICU beds, percent available
Airborn Isolation Beds Availableaii_availaii_availNumberAirborn isolation beds available
Medical/Surgical Beds Availablemed_availmed_availNumberMedical/surgical beds available
14-day average Pediatric beds totalped_total_meanped_total_meanNumberPediatric beds total, 14-day average
14-day average COVID-19 patients on ventilatorscovid_vents_meancovid_vents_meanNumberCOVID-19 patients on ventilators, 14-day average
14-day average Pediatric ICU beds totalpic_total_meanpic_total_meanNumberPediatric ICU beds total, 14-day average
14-day average Airborne isolation beds totalaii_total_meanaii_total_meanNumberAirborne isolation beds total, 14-day average
Total Ventilators in usevents_usevents_useNumberTotal ventilators in use
COVID-19 Patients on Ventilatorscovid_ventscovid_ventsNumberCOVID-19 patients on ventilators
Pediatric ICU Beds Totalpic_totalpic_totalNumberPediatrics ICU beds total
Adult ICU Beds Totalicu_totalicu_totalNumberAdult ICU beds total
Airborn isolation beds, percent availableaii_percentaii_percentNumberAirborn isolation beds, percent available
Pediatric Beds Totalped_totalped_totalNumberPediatrics beds total
COVID-19 Patients Hospitalizedcovid_patientscovid_patientsNumberCOVID-19 patients hospitalized
14-day average Adult ICU beds totalicu_total_meanicu_total_meanNumberAdult ICU beds total, 14-day average
LatitudelatitudelatitudeTextThis is a latitude generic point within the county to help create map visualizations
14-day average Medical/surgical beds availablemed_avail_meanmed_avail_meanNumberMedical/surgical beds available, 14-day average
Pediatric ICU Beds Availablepic_availpic_availNumberPediatrics ICU beds available
Pediatric Beds Availableped_availped_availNumberPediatrics beds available
COVID-ICUcovid_icucovid_icuNumberCOVID Patients in Intensive Care Unit (ICU).
County FIPScounty_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
14-day average Pediatric beds availableped_avail_meanped_avail_meanNumberPediatric beds available, 14-day average
Medical/Surgical Beds Totalmed_totalmed_totalNumberMedical/surgical beds total
Adult ICU Beds Availableicu_availicu_availNumberAdult ICU beds available
14-day average COVID-19 patients hospitalizedcovid_patients_meancovid_patients_meanNumberCOVID-19 patients hospitalized, 14-day average
Pa School Districts (2019-06):@computed_region_rayf_jjgk:@computed_region_rayf_jjgkNumberThis column was automatically created in order to record in what polygon from the dataset 'Pa School Districts (2019-06)' (rayf-jjgk) the point in column 'georeference_latitude__longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Pa House Districts (2020-01):@computed_region_r6rf_p9et:@computed_region_r6rf_p9etNumberThis column was automatically created in order to record in what polygon from the dataset 'Pa House Districts (2020-01)' (r6rf-p9et) the point in column 'georeference_latitude__longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Municipality Boundary:@computed_region_amqz_jbr4:@computed_region_amqz_jbr4NumberThis column was automatically created in order to record in what polygon from the dataset 'Municipality Boundary' (amqz-jbr4) the point in column 'georeference_latitude__longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
14-day average Total ventilators in usevents_use_meanvents_use_meanNumberTotal ventilators in use, 14-day average

Upstream Metadata