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

1. hospital_pk - This unique key for the given hospital that will match the ccn column if it exists, otherwise, it is a derived unique key.
2. collection_week - This date indicates the start of the period of reporting (the starting Friday).
3. state - [FAQ - 1. d)] The two digit state/territory code for the hospital.
4. ccn - [FAQ - 1. b)] CMS Certification Number (CCN) of the given facility
5. hospital_name - [FAQ - 1. a)] The name of the facility reporting.
6. address - The address of the facility reporting.
7. city - The city of the facility reporting.
8. zip - The 5-digit zip code of the facility reporting.
9. hospital_subtype - The sub-type of the facility reporting. Valid values are: Children's Hospitals, Critical Access Hospitals, Long Term, Psychiatric, Rehabilitation & Short Term. Some facilities are not designated with this field.
10. fips_code - The Federal Information Processing Standard (FIPS) code of the location of the hospital.
11. is_metro_micro - This is based on whether the facility serves a Metropolitan or Micropolitan area. True if yes, and false if no.
12. total_beds_7_day_avg - [FAQ - 2. a)] Average of total number of all staffed inpatient and outpatient beds in the hospital, including all overflow, observation, and active surge/expansion beds used for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period.
13. all_adult_hospital_beds_7_day_avg - [FAQ - 2. b)] Average of all staffed inpatient and outpatient adult beds in the hospital, including all overflow and active surge/expansion beds for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period.
14. all_adult_hospital_inpatient_beds_7_day_avg - [FAQ - 3. b)] Average of total number of staffed inpatient adult beds in the hospital including all overflow and active surge/expansion beds used for inpatients (including all designated ICU beds) reported during the 7-day period.
15. inpatient_beds_used_7_day_avg - [FAQ - 4. a)] Average of total number of staffed inpatient beds that are occupied reported during the 7-day period.
16. all_adult_hospital_inpatient_bed_occupied_7_day_avg - [FAQ - 4. b)] Average of total number of staffed inpatient adult beds that are occupied reported during the 7-day period.
17. total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg - [FAQ - 9. a)] Average number of patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed or suspected COVID19, including those in observation beds reported during the 7-day period.
18. total_adult_patients_hospitalized_confirmed_covid_7_day_avg - [FAQ - 9. b)] Average number of patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed COVID-19, including those in observation beds. This average includes patients who have both laboratory-confirmed COVID-19 and laboratory-confirmed influenza.
19. total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg - [FAQ - 10. a)] Average number of patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who are suspected or laboratory-confirmed-positive for COVID-19. This average includes those in observation beds reported in the 7-day period.
20. total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg - [FAQ - 10. b)] Average number of patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field reported in the 7-day period.
21. inpatient_beds_7_day_avg - [FAQ - 3. a)] Average number of total number of staffed inpatient beds in your hospital including all overflow, observation, and active surge/expansion beds used for inpatients (including all ICU beds) reported in the 7-day period.
22. total_icu_beds_7_day_avg - [FAQ - 5. a)] Average of total staffed inpatient ICU beds reported in the 7-day period.
23. total_staffed_adult_icu_beds_7_day_avg - [FAQ - 5. b)] Average of total number of staffed adult ICU beds reported in the 7-day period.
24. icu_beds_used_7_day_avg - [FAQ - 6. a)] Average of total number of staffed adult ICU beds that are occupied reported in the 7-day period.
25. staffed_adult_icu_bed_occupancy_7_day_avg - [FAQ - 6. b)] Average of total number of staffed inpatient adult ICU beds that are occupied reported in the 7-day period.
26. staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg - [FAQ - 12. a)] Average number of patients currently hospitalized in a designated adult ICU bed who have suspected or laboratory-confirmed COVID-19 reported in the 7-day period.
27. staffed_icu_adult_patients_confirmed_covid_7_day_avg - [FAQ - 12. b)] Average number of patients currently hospitalized in a designated adult ICU bed who have laboratory-confirmed COVID-19. Including patients who have both laboratory-confirmed COVID-19 and laboratory-confirmed influenza in this field reported in the 7-day period.
28. total_patients_hospitalized_confirmed_influenza_7_day_avg - [FAQ - 33] Average number of patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed influenza. Including those in observation beds reported in the 7-day period.
29. icu_patients_confirmed_influenza_7_day_avg - [FAQ - 35] Average of patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza in the 7-day period.
30. total_patients_hospitalized_confirmed_influenza_and_covid_7_day_avg - [FAQ - 36] Average number of patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed COVID-19 and laboratory-confirmed influenza reported in the 7-day period.
31. total_beds_7_day_sum - [FAQ - 2. a)] Sum of reports of total number of all staffed inpatient and outpatient beds in the hospital, including all overflow, observation, and active surge/expansion beds used for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period.
32. all_adult_hospital_beds_7_day_sum - [FAQ - 2. b)] Sum of reports of all staffed inpatient and outpatient adult beds in the hospital, including all overflow and active surge/expansion beds for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period.
33. all_adult_hospital_inpatient_beds_7_day_sum - [FAQ - 3. b)] Sum of reports of all staffed inpatient adult beds in the hospital, including all overflow and active surge/expansion beds for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period.
34. inpatient_beds_used_7_day_sum - [FAQ - 4. a)] Sum of reports of total number of staffed inpatient beds that are occupied reported during the 7-day period.
35. all_adult_hospital_inpatient_bed_occupied_7_day_sum - [FAQ - 4. b)] Sum of reports of total number of staffed inpatient adult beds that are occupied reported during the 7-day period.
36. total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum - [FAQ - 9. a)] Sum of reports of patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed or suspected COVID19. Including those in observation beds reported during the 7-day period.
37. total_adult_patients_hospitalized_confirmed_covid_7_day_sum - [FAQ - 9. b)] Sum of reports of patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field during the 7-day period.
38. total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum - [FAQ - 10. a)] Sum of reports of patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who are suspected or laboratory-confirmed-positive for COVID-19. Including those in observation beds reported in the 7-day period.
39. total_pediatric_patients_hospitalized_confirmed_covid_7_day_sum - [FAQ - 10. b)] Sum of reports of patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field reported in the 7-day period.
40. inpatient_beds_7_day_sum - [FAQ - 3. a)] Sum of reports of total number of staffed inpatient beds in your hospital including all overflow, observation, and active surge/expansion beds used for inpatients (including all ICU beds) reported in the 7-day period.
41. total_icu_beds_7_day_sum - [FAQ - 5. a)] Sum of reports of total number of staffed inpatient ICU beds reported in the 7-day period.
42. total_staffed_adult_icu_beds_7_day_sum - [FAQ - 5. b)] Sum of reports of total number of staffed inpatient adult ICU beds reported in the 7-day period.
43. icu_beds_used_7_day_sum - [FAQ - 6. a)] Sum of reports of total staffed inpatient ICU beds occupied in the 7-day period.
44. staffed_adult_icu_bed_occupancy_7_day_sum - [FAQ - 6. b)] Sum of reports of total number of staffed inpatient adult ICU beds that are occupied reported in the 7-day period.
45. staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_sum - [FAQ - 12. a)] Sum of reports of patients currently hospitalized in a designated adult ICU bed who have suspected or laboratory-confirmed COVID-19 reported in the 7-day period.
46. staffed_icu_adult_patients_confirmed_covid_7_day_sum - [FAQ - 12. b)] Sum of reports of patients currently hospitalized in a designated adult ICU bed who have laboratory-confirmed COVID-19. Including patients who have both laboratory-confirmed COVID-19 and laboratory-confirmed influenza in this field reported in the 7-day period.
47. total_patients_hospitalized_confirmed_influenza_7_day_sum - [FAQ - 33] Sum of reports of patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed influenza. Including those in observation beds reported in the 7-day period.
48. icu_patients_confirmed_influenza_7_day_sum - [FAQ - 35] Sum of reports of patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza reported in the 7-day period.
49. total_patients_hospitalized_confirmed_influenza_and_covid_7_day_sum - [FAQ - 36] Sum of reports of patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed COVID-19 and laboratory-confirmed influenza reported in the 7-day period.
50. total_beds_7_day_coverage - [FAQ - 2. a)] Number of times in the 7 day period that the facility reported total number of all staffed inpatient and outpatient beds in your hospital, including all overflow, observation, and active surge/expansion beds used for inpatients and for outpatients (including all ICU, ED, and observation).
51. all_adult_hospital_beds_7_day_coverage - [FAQ - 2. b)] Number of times in the 7-day period that the facility reported total number of all staffed inpatient and outpatient adult beds in your hospital, including all overflow and active surge/expansion beds for inpatients and for outpatients (including all ICU, ED, and observation).
52. all_adult_hospital_inpatient_beds_7_day_coverage - [FAQ - 3. b)] Number of times in the 7-day period that the facility reported total number of staffed inpatient adult beds in your hospital including all overflow and active surge/expansion beds used for inpatients (including all designated ICU beds).
53. inpatient_beds_used_7_day_coverage - [FAQ - 4. a)] Number of times in the 7-day period that the facility reported total number of staffed inpatient beds that are occupied.
54. all_adult_hospital_inpatient_bed_occupied_7_day_coverage - [FAQ - 4. b)] Number of times in the 7-day period that the facility reported total number of staffed inpatient adult beds that are occupied.
55. total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage - [FAQ - 9. a)] Number of times in the 7-day period that the facility reported patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed or suspected COVID19. Including those in observation beds.
56. total_adult_patients_hospitalized_confirmed_covid_7_day_coverage - [FAQ - 9. b)] Number of times in the 7-day period that the facility reported patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field.
57. total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage - [FAQ - 10. a)] Number of times in the 7-day period that the facility reported Patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who are suspected or laboratory-confirmed-positive for COVID-19. Including those in observation beds.
58. total_pediatric_patients_hospitalized_confirmed_covid_7_day_coverage - [FAQ - 10. b)] Number of times in the 7-day period that the facility reported patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field.
59. inpatient_beds_7_day_coverage - [FAQ - 3. a)] Number of times in the 7-day period that the facility reported total number of staffed inpatient beds in your hospital including all overflow, observation, and active surge/expansion beds used for inpatients (including all ICU beds).
60. total_icu_beds_7_day_coverage - [FAQ - 5. a)] Number of times in the 7-day period that the facility reported total number of staffed inpatient ICU beds.
61. total_staffed_adult_icu_beds_7_day_coverage - [FAQ - 5. b)] Number of times in the 7-day period that the facility reported total number of staffed inpatient adult ICU beds.
62. icu_beds_used_7_day_coverage - [FAQ - 6. a)] Number of times in the 7-day period that the facility reported total number of staffed inpatient ICU beds.
63. staffed_adult_icu_bed_occupancy_7_day_coverage - [FAQ - 6. b)] Number of times in the 7-day period that the facility reported total number of staffed inpatient adult ICU beds that are occupied.
64. staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_coverage - [FAQ - 12. a)] Number of times in the 7-day period that the facility reported patients currently hospitalized in a designated adult ICU bed who have suspected or laboratory-confirmed COVID-19.
65. staffed_icu_adult_patients_confirmed_covid_7_day_coverage - [FAQ - 12. b)] Number of times in the 7-day period that the facility reported patients currently hospitalized in a designated adult ICU bed who have laboratory-confirmed COVID-19. Including patients who have both laboratory-confirmed COVID-19 and laboratory-confirmed influenza in this field.
66. total_patients_hospitalized_confirmed_influenza_7_day_coverage - [FAQ - 33] Number of times in the 7-day period that the facility reported patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed influenza. Including those in observation beds.
67. icu_patients_confirmed_influenza_7_day_coverage - [FAQ - 35] Number of times in the 7-day period that the facility reported patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza.
68. total_patients_hospitalized_confirmed_influenza_and_covid_7_day_coverage - [FAQ - 36] Number of times in the 7-day period that the facility reported patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed COVID-19 and laboratory-confirmed influenza.
69. previous_day_admission_adult_covid_confirmed_7_day_sum - [FAQ - 17. a)] Sum of number of patients who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in the 7-day period.
70. previous_day_admission_adult_covid_confirmed_18-19_7_day_sum - [FAQ - 17. a1)] Sum of number of patients age 18-19 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in the 7-day period.
71. previous_day_admission_adult_covid_confirmed_20-29_7_day_sum - [FAQ - 17. a2)] Sum of number of patients age 20-29 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in the 7-day period.
72. previous_day_admission_adult_covid_confirmed_30-39_7_day_sum - [FAQ - 17. a3)] Sum of number of patients age 30-39 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
73. previous_day_admission_adult_covid_confirmed_40-49_7_day_sum - [FAQ - 17. a4)] Sum of number of patients age 40-49 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
74. previous_day_admission_adult_covid_confirmed_50-59_7_day_sum - [FAQ - 17. a5)] Sum of number of patients age 50-59 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
75. previous_day_admission_adult_covid_confirmed_60-69_7_day_sum - [FAQ - 17. a6)] Sum of number of patients age 60-69 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
76. previous_day_admission_adult_covid_confirmed_70-79_7_day_sum - [FAQ - 17. a7)] Sum of number of patients age 70-79 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
77. previous_day_admission_adult_covid_confirmed_80+_7_day_sum - [FAQ - 17. a8)] Sum of number of patients 80 or older who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
78. previous_day_admission_adult_covid_confirmed_unknown_7_day_sum - [FAQ - 17. a9)] Sum of number of patients age unknown who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
79. previous_day_admission_pediatric_covid_confirmed_7_day_sum - [FAQ - 18. a)] Sum of number of pediatric patients who were admitted to an inpatient bed, including NICU, PICU, newborn, and nursery, on the previous calendar day who had confirmed COVID-19 at the time of admission.
80. previous_day_covid_ED_visits_7_day_sum - [FAQ - 20] Sum of total number of ED visits who were seen on the previous calendar day who had a visit related to COVID-19 (meets suspected or confirmed definition or presents for COVID diagnostic testing – do not count patients who present for pre-procedure screening) reported in 7-day period.
81. previous_day_admission_adult_covid_suspected_7_day_sum - [FAQ - 17. b)] Sum of number of patients who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
82. previous_day_admission_adult_covid_suspected_18-19_7_day_sum - [FAQ - 17. b1)] Sum of number of patients age 18-19 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
83. previous_day_admission_adult_covid_suspected_20-29_7_day_sum - [FAQ - 17. b2)] Sum of number of patients age 20-29 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
84. previous_day_admission_adult_covid_suspected_30-39_7_day_sum - [FAQ - 17. b3)] Sum of number of patients age 30-39 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
85. previous_day_admission_adult_covid_suspected_40-49_7_day_sum - [FAQ - 17. b4)] Sum of number of patients age 40-49 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
86. previous_day_admission_adult_covid_suspected_50-59_7_day_sum - [FAQ - 17. b5)] Sum of number of patients age 50-59 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
87. previous_day_admission_adult_covid_suspected_60-69_7_day_sum - [FAQ - 17. b6)] Sum of number of patients age 60-69 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
88. previous_day_admission_adult_covid_suspected_70-79_7_day_sum - [FAQ - 17. b7)] Sum of number of patients age 70-79 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
89. previous_day_admission_adult_covid_suspected_80+_7_day_sum - [FAQ - 17. b8)] Sum of number of patients 80 or older who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
90. previous_day_admission_adult_covid_suspected_unknown_7_day_sum - [FAQ - 17. b9)] Sum of number of patients age unknown who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
91. previous_day_admission_pediatric_covid_suspected_7_day_sum - [FAQ - 18. b)] Sum of number of pediatrics patients who were admitted to an inpatient bed, including NICU, PICU, newborn, and nursery, on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
92. previous_day_total_ED_visits_7_day_sum - [FAQ - 19] Sum of total number of patient visits to the ED who were seen on the previous calendar day regardless of reason for visit. Including all patients who are triaged even if they leave before being seen by a provider reported in the 7-day period.
93. previous_day_admission_influenza_confirmed_7_day_sum - [FAQ - 34] Sum of number of patients (all ages) who were admitted to an inpatient bed on the previous calendar day who had laboratory-confirmed influenza at the time of admission reported in 7-day period.

For the Frequently Asked Questions identifier, please refer to the COVID-19 Guidance for Hospital Reporting and FAQs For Hospitals, Hospital Laboratory, and Acute Care Facility Data Reporting.