ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
7
8
9
10
11
12
Geographic-Specific ColumnsHHS Protect ColumnsDescription
13
StatestateThis is the state as listed for the facility in the underlying HHS data
14
Citycity This is the city as listed for the facility in the underlying HHS data
15
Hospital Namehospital_nameThis is the hospital name as listed for the facility in the underlying HHS data
16
CCNccnCMS Certification Number - a unique Medicare hospital identifier
17
CBSANot in HHS Protect
Core-Based Statistical Area - sets of counties that are combined by the Census Bureau to form a distinct geographic unit.
18
Principle CityNot in HHS ProtectCBSA Sheet Only: the first and/or largest city within the CBSA
19
Principle StateNot in HHS ProtectCBSA Sheet Only: the state of the princple city. CBSAs may span multiple states.
20
Metropolitan AreaNot in HHS ProtectCBSA Sheet Only: 1 = CBSA is a metropolitan area with at least 1 city of 50,000 people or more, 0 otherwise
21
Micropolitan AreaNot in HHS ProtectCBSA Sheet Only: 1 = CBSA is a metropolitan area with at least 1 city of 10,000 people or more but no cities > 50,000 people, 0 otherwise. A CBSA can only be 1 of metropolitan or micropolitan area.
22
FIPS Codefips_codeA unique county identifier established by the federal government. See: https://www.census.gov/library/reference/code-lists/ansi/ansi-codes-for-states.html
23
The following measures are summed across reporting hospitals at geographic levelsHHS Protect ColumnsDescription
24
Num HospitalsNot in HHS ProtectA count of the number of hospitals providing data for the calculations in the sheet. Not all hospitals may be reporting each element.
25
Total Hospital Bedsinpatient_beds_7_day_avgThe sum of the total reported average beds
26
Total ICU Bedstotal_staffed_adult_icu_beds_7_day_avgThe sum of the total reported average adult staffed ICU beds
27
Total COVID Hospitalizationstotal_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg +
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg		Sum of the average daily number of aggregated adult and pediatric patients hospitalized with confirmed or suspected COVID
28
ICU COVID Hospitalizations
staffed_icu_adult_patients_confirmed_covid_7_day_avg
The sum of the average # of adult patients with confirmed COVID in staffed ICU beds
29
Total Hospitalizationsinpatient_beds_used_7_day_avgSum of the average daily number of aggregated adult patients hospitalized for any reason
30
Total ICU Hospitalizationsstaffed_adult_icu_bed_occupancy_7_day_avgThe sum of the average # of adult patients in staffed ICU beds
31
The following measures are calculated at the facility level and then averaged within the geographic levelHHS Protect ColumnsDescription
32
% All Hospital Beds Occupied by COVID(total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg +
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg) / inpatient_beds_7_day_avg		Average hospital COVID occupancy rate
33
% ICU Beds Occupied by COVIDstaffed_icu_adult_patients_confirmed_covid_7_day_avg / total_staffed_adult_icu_beds_7_day_avgAverage ICU COVID occupancy rate
34
% All Hospital Beds Occupiedinpatient_beds_used_7_day_avg / inpatient_beds_7_day_avgAverage hospital overall occupancy rate
35
% All ICU Beds Occupiedstaffed_adult_icu_bed_occupancy_7_day_avg / total_staffed_adult_icu_beds_7_day_avgAverage ICU overall occupancy rate
36
37
README DATE: 8/22/2022
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100