COVID-19 Reported Patient Impact and Hospital Capacity by State Data Dictionary

Primary tabs

Data Dictionary
Note: As additional elements are added, the data dictionary will be updated. - September 9, 2020 release 2.2

  1. state: The two digit state code
  2. hospital_onset_covid: Total current inpatients with onset of suspected or laboratory-confirmed COVID-19 fourteen or more days after admission for a condition other than COVID-19 in this state.
  3. hospital_onset_covid_coverage: Number of hospitals reporting "hospital_onset_covid" in this state
  4. inpatient_beds: Reported total number of staffed inpatient beds including all overflow and surge/expansion beds used for inpatients (includes all ICU beds) in this state
  5. inpatient_beds_coverage: Number of hospitals reporting "inpatient_beds" in this state
  6. inpatient_beds_used: Reported total number of staffed inpatient beds that are occupied in this state
  7. inpatient_beds_used_coverage: Number of hospitals reporting "inpatient_beds_used" in this state
  8. inpatient_beds_used_covid: Reported patients currently hospitalized in an inpatient bed who have suspected or confirmed COVID-19 in this state
  9. inpatient_beds_used_covid_coverage: Number of hospitals reporting "inpatient_beds_used_covid" in this state
  10. staffed_adult_icu_bed_occupancy: Reported total number of staffed inpatient adult ICU beds that are occupied in this state
  11. staffed_adult_icu_bed_occupancy_coverage: Number of hospitals reporting "staffed_adult_icu_bed_occupancy" in this state
  12. staffed_icu_adult_patients_confirmed_and_suspected_covid: Reported patients currently hospitalized in an adult ICU bed who have suspected or confirmed COVID-19 in this state
  13. staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage: Number of hospitals reporting "staffed_icu_adult_patients_confirmed_and_suspected_covid" in this state
  14. staffed_icu_adult_patients_confirmed_covid: Reported patients currently hospitalized in an adult ICU bed who have confirmed COVID-19 in this state
  15. staffed_icu_adult_patients_confirmed_covid_coverage: Number of hospitals reporting "staffed_icu_adult_patients_confirmed_covid" in this state
  16. total_adult_patients_hospitalized_confirmed_and_suspected_covid: Reported patients currently hospitalized in an adult inpatient
    bed who have laboratory-confirmed or suspected COVID-19. This include those in observation beds.
  17. total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage: Number of hospitals reporting "total_adult_patients_hospitalized_confirmed_and_suspected_covid" in this state
  18. total_adult_patients_hospitalized_confirmed_covid: Reported patients currently hospitalized in an adult inpatient
    bed who have laboratory-confirmed COVID-19. This include those in observation beds.
  19. total_adult_patients_hospitalized_confirmed_covid_coverage: Number of hospitals reporting "total_adult_patients_hospitalized_confirmed_covid" in this state
  20. total_pediatric_patients_hospitalized_confirmed_and_suspected_covid: Reported patients currently hospitalized in a pediatric inpatient
    bed, including NICU, newborn, and nursery, who are suspected or laboratory-confirmed-positive for COVID-19. This include those in observation beds.
  21. total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage: Number of hospitals reporting "total_pediatric_patients_hospitalized_confirmed_and_suspected_covid" in this state
  22. total_pediatric_patients_hospitalized_confirmed_covid: Reported patients currently hospitalized in a pediatric inpatient
    bed, including NICU, newborn, and nursery, who are laboratory-confirmed-positive for COVID-19. This include those in observation beds.
  23. total_pediatric_patients_hospitalized_confirmed_covid_coverage: Number of hospitals reporting "total_pediatric_patients_hospitalized_confirmed_covid" in this state
  24. total_staffed_adult_icu_beds: Reported total number of staffed inpatient adult ICU beds in this state
  25. total_staffed_adult_icu_beds_coverage: Number of hospitals reporting "total_staffed_adult_icu_beds" in this state
  26. inpatient_beds_utilization: Percentage of inpatient beds that are being utilized in this state. This number only accounts for hospitals in the state that report both "inpatient_beds_used" and "inpatient_beds" fields.
  27. inpatient_beds_utilization_coverage: Number of hospitals reporting both "inpatient_beds_used" and "inpatient_beds"
  28. inpatient_beds_utilization_numerator: Sum of "inpatient_beds_used" for hospitals reporting both "inpatient_beds_used" and "inpatient_beds"
  29. inpatient_beds_utilization_denominator: Sum of "inpatient_beds" for hospitals reporting both "inpatient_beds_used" and "inpatient_beds"
  30. percent_of_inpatients_with_covid: Percentage of inpatient population who have suspected or confirmed COVID-19 in this state. This number only accounts for hospitals in the state that report both "inpatient_beds_used_covid" and "inpatient_beds_used" fields.
  31. percent_of_inpatients_with_covid_coverage: Number of hospitals reporting both "inpatient_beds_used_covid" and "inpatient_beds_used".
  32. percent_of_inpatients_with_covid_numerator: Sum of "inpatient_beds_used_covid" for hospitals reporting both "inpatient_beds_used_covid" and "inpatient_beds_used".
  33. percent_of_inpatients_with_covid_denominator: Sum of "inpatient_beds_used" for hospitals reporting both "inpatient_beds_used_covid" and "inpatient_beds_used".
  34. inpatient_bed_covid_utilization: Percentage of total (used/available) inpatient beds currently utilized by patients who have suspected or confirmed COVID-19 in this state. This number only accounts for hospitals in the state that report both "inpatient_beds_used_covid" and "inpatient_beds" fields.
  35. inpatient_bed_covid_utilization_coverage: Number of hospitals reporting both "inpatient_beds_used_covid" and "inpatient_beds".
  36. inpatient_bed_covid_utilization_numerator: Sum of "inpatient_beds_used_covid" for hospitals reporting both "inpatient_beds_used_covid" and "inpatient_beds".
  37. inpatient_bed_covid_utilization_denominator: Sum of "inpatient_beds" for hospitals reporting both "inpatient_beds_used_covid" and "inpatient_beds".
  38. adult_icu_bed_covid_utilization: Percentage of total staffed adult ICU beds currently utilized by patients who have suspected or confirmed COVID-19 in this state. This number only accounts for hospitals in the state that report both "staffed_icu_adult_patients_confirmed_and_suspected_covid" and "total_staffed_adult_icu_beds" fields.
  39. adult_icu_bed_covid_utilization_coverage: Number of hospitals reporting both both "staffed_icu_adult_patients_confirmed_and_suspected_covid" and "total_staffed_adult_icu_beds".
  40. adult_icu_bed_covid_utilization_numerator: Sum of "staffed_icu_adult_patients_confirmed_and_suspected_covid" for hospitals reporting both "staffed_icu_adult_patients_confirmed_and_suspected_covid" and "total_staffed_adult_icu_beds".
  41. adult_icu_bed_covid_utilization_denominator: Sum of "total_staffed_adult_icu_beds" for hospitals reporting both "staffed_icu_adult_patients_confirmed_and_suspected_covid" and "total_staffed_adult_icu_beds".
  42. adult_icu_bed_utilization: Percentage of staffed adult ICU beds that are being utilized in this state. This number only accounts for hospitals in the state that report both "staffed_adult_icu_bed_occupancy" and "total_staffed_adult_icu_beds" fields.
  43. adult_icu_bed_utilization_coverage: Number of hospitals reporting both both "staffed_adult_icu_bed_occupancy" and "total_staffed_adult_icu_beds".
  44. adult_icu_bed_utilization_numerator: Sum of "staffed_adult_icu_bed_occupancy" for hospitals reporting both "staffed_adult_icu_bed_occupancy" and "total_staffed_adult_icu_beds".
  45. adult_icu_bed_utilization_denominator: Sum of "total_staffed_adult_icu_beds" for hospitals reporting both "staffed_adult_icu_bed_occupancy" and "total_staffed_adult_icu_beds".
  46. reporting_cutoff_start: Look back date start - The latest reports from each hospital is summed for this report starting with this date.