COVID-19 Estimated Patient Impact and Hospital Capacity by State
COVID-19 Estimated Patient Impact and Hospital Capacity by State
By HHS
State-aggregated data for estimated patient impact and hospital utilization.
Product type
Dataset
Update frequency
Weekly
Updated
Oct 16, 2022
Delivery method
Download
Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.
Dataset file name: COVID-19_Estimated_Patient_Impact_and_Hospital_Capacity_by_State.csv
Key Statistics
Total records
1,612
Missing values
1%
Duplicate rows
0%
Columns
Columns
30
Categorical
1
Numeric
27
Date/time
1
Correlations
Correlations
162
Correlated columns
Total UL (All Inpatient) and Count UL (All Inpatient), Total UL (All Inpatient) and Total LL (All Inpatient), Count UL (All Inpatient) and Count UL (COVID-19 Inpatient), Count LL (All Inpatient) and Count LL (COVID-19 Inpatient), Total Staffed Adult ICU Beds (ICU) and Count LL (ICU), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Count UL (All Inpatient), Total UL (COVID-19 Inpatient) and Total Inpatient Beds (All Inpatient), Total LL (COVID-19 Inpatient) and Total UL (ICU), Percentage of Inpatient Beds Occupied Estimated (All Inpatient) and Percentage LL (All Inpatient), Total UL (ICU) and Total Inpatient Beds (All Inpatient), Total LL (ICU) and Total LL (All Inpatient), Total LL (COVID-19 Inpatient) and Total UL (COVID-19 Inpatient), Percentage LL (ICU) and Percentage UL (ICU), Inpatient Beds Occupied Estimated (All Inpatient) and Count UL (All Inpatient), Inpatient Beds Occupied Estimated (All Inpatient) and Count LL (ICU), Total UL (All Inpatient) and Total LL (ICU), Total LL (COVID-19 Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Count LL (All Inpatient) and Count LL (ICU), Total Staffed Adult ICU Beds (ICU) and Count LL (COVID-19 Inpatient), Total Staffed Adult ICU Beds (ICU) and Staffed Adult ICU Beds Occupied Estimated (ICU), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Staffed Adult ICU Beds Occupied Estimated (ICU) and Count UL (ICU), Count LL (COVID-19 Inpatient) and Count UL (ICU), Inpatient Beds Occupied Estimated (All Inpatient) and Count LL (COVID-19 Inpatient), Total Staffed Adult ICU Beds (ICU) and Total UL (ICU), Total Inpatient Beds (All Inpatient) and Total LL (All Inpatient), Inpatient Beds Occupied Estimated (All Inpatient) and Staffed Adult ICU Beds Occupied Estimated (ICU), Total Staffed Adult ICU Beds (ICU) and Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient), Count UL (All Inpatient) and Count LL (ICU), Total UL (COVID-19 Inpatient) and Staffed Adult ICU Beds Occupied Estimated (ICU), Percentage of Staffed Adult ICU Beds Occupied Estimated (ICU) and Percentage LL (ICU), Total LL (COVID-19 Inpatient) and Count LL (All Inpatient), Total UL (ICU) and Total Inpatient Beds (COVID-19 Inpatient), Count UL (All Inpatient) and Total LL (All Inpatient), Inpatient Beds Occupied Estimated (All Inpatient) and Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient), Total UL (ICU) and Staffed Adult ICU Beds Occupied Estimated (ICU), Inpatient Beds Occupied Estimated (All Inpatient) and Total Staffed Adult ICU Beds (ICU), Count LL (COVID-19 Inpatient) and Total UL (ICU), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Count LL (All Inpatient), Count UL (All Inpatient) and Count LL (COVID-19 Inpatient), Count UL (All Inpatient) and Staffed Adult ICU Beds Occupied Estimated (ICU), Count LL (All Inpatient) and Count UL (COVID-19 Inpatient), Total UL (COVID-19 Inpatient) and Count LL (ICU), Total LL (ICU) and Total Inpatient Beds (All Inpatient), Total LL (COVID-19 Inpatient) and Inpatient Beds Occupied Estimated (All Inpatient), Count LL (ICU) and Total Inpatient Beds (COVID-19 Inpatient), Count UL (All Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Total UL (COVID-19 Inpatient) and Total LL (All Inpatient), Percentage of Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Percentage LL (COVID-19 Inpatient), Total UL (ICU) and Count LL (ICU), Total Inpatient Beds (COVID-19 Inpatient) and Total LL (All Inpatient), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Count LL (ICU), Total Staffed Adult ICU Beds (ICU) and Count UL (All Inpatient), Total Inpatient Beds (All Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Count LL (ICU) and Count UL (COVID-19 Inpatient), Count LL (All Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Percentage LL (All Inpatient) and Percentage UL (All Inpatient), Total Staffed Adult ICU Beds (ICU) and Total LL (All Inpatient), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Total LL (All Inpatient), Percentage of Staffed Adult ICU Beds Occupied Estimated (ICU) and Percentage UL (ICU), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Total UL (COVID-19 Inpatient), Total LL (COVID-19 Inpatient) and Total LL (All Inpatient), Count LL (COVID-19 Inpatient) and Count UL (COVID-19 Inpatient), Total LL (ICU) and Staffed Adult ICU Beds Occupied Estimated (ICU), Total Staffed Adult ICU Beds (ICU) and Total Inpatient Beds (COVID-19 Inpatient), Inpatient Beds Occupied Estimated (All Inpatient) and Total UL (ICU), Count LL (All Inpatient) and Total LL (All Inpatient), Total LL (COVID-19 Inpatient) and Count UL (All Inpatient), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Total UL (ICU), Total UL (All Inpatient) and Count LL (COVID-19 Inpatient), Total UL (All Inpatient) and Staffed Adult ICU Beds Occupied Estimated (ICU), Total Staffed Adult ICU Beds (ICU) and Total LL (ICU), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Count UL (COVID-19 Inpatient), Percentage of Inpatient Beds Occupied Estimated (All Inpatient) and Percentage UL (All Inpatient), Total UL (COVID-19 Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Count LL (All Inpatient) and Total Inpatient Beds (All Inpatient), Total UL (All Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Inpatient Beds Occupied Estimated (All Inpatient) and Count UL (ICU), Count LL (ICU) and Total LL (All Inpatient), Total LL (ICU) and Count UL (ICU), Inpatient Beds Occupied Estimated (All Inpatient) and Total LL (ICU), Total Staffed Adult ICU Beds (ICU) and Total Inpatient Beds (All Inpatient), Total UL (ICU) and Total LL (All Inpatient), Total LL (COVID-19 Inpatient) and Total LL (ICU), Count UL (All Inpatient) and Total UL (ICU), Total LL (ICU) and Count UL (All Inpatient), Count LL (COVID-19 Inpatient) and Total Inpatient Beds (All Inpatient), Total LL (ICU) and Total UL (COVID-19 Inpatient), Total LL (ICU) and Total Inpatient Beds (COVID-19 Inpatient), Count UL (All Inpatient) and Total Inpatient Beds (All Inpatient), Total UL (All Inpatient) and Count UL (ICU), Inpatient Beds Occupied Estimated (All Inpatient) and Total UL (COVID-19 Inpatient), Total UL (ICU) and Count UL (COVID-19 Inpatient), Total LL (ICU) and Count UL (COVID-19 Inpatient), Staffed Adult ICU Beds Occupied Estimated (ICU) and Count LL (COVID-19 Inpatient), Total Staffed Adult ICU Beds (ICU) and Count UL (ICU), Total UL (All Inpatient) and Total UL (ICU), Total UL (COVID-19 Inpatient) and Count UL (All Inpatient), Staffed Adult ICU Beds Occupied Estimated (ICU) and Count LL (ICU), Count LL (COVID-19 Inpatient) and Count LL (ICU), Total Staffed Adult ICU Beds (ICU) and Count LL (All Inpatient), Total Staffed Adult ICU Beds (ICU) and Total LL (COVID-19 Inpatient), Count LL (All Inpatient) and Count UL (ICU), Total LL (COVID-19 Inpatient) and Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient), Count UL (ICU) and Total Inpatient Beds (All Inpatient), Percentage LL (COVID-19 Inpatient) and Percentage UL (COVID-19 Inpatient), Inpatient Beds Occupied Estimated (All Inpatient) and Count LL (All Inpatient), Count LL (All Inpatient) and Staffed Adult ICU Beds Occupied Estimated (ICU), Total UL (COVID-19 Inpatient) and Count LL (All Inpatient), Total UL (All Inpatient) and Total Inpatient Beds (All Inpatient), Total LL (COVID-19 Inpatient) and Staffed Adult ICU Beds Occupied Estimated (ICU), Count UL (COVID-19 Inpatient) and Total LL (All Inpatient), Count LL (ICU) and Count UL (ICU), Total LL (COVID-19 Inpatient) and Count LL (COVID-19 Inpatient), Total LL (COVID-19 Inpatient) and Total UL (All Inpatient), Count LL (All Inpatient) and Total UL (ICU), Total UL (All Inpatient) and Count UL (COVID-19 Inpatient), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Staffed Adult ICU Beds Occupied Estimated (ICU), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Count LL (COVID-19 Inpatient), Count LL (All Inpatient) and Count UL (All Inpatient), Total Staffed Adult ICU Beds (ICU) and Total UL (COVID-19 Inpatient), Total UL (All Inpatient) and Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient), Staffed Adult ICU Beds Occupied Estimated (ICU) and Count UL (COVID-19 Inpatient), Total UL (ICU) and Count UL (ICU), Inpatient Beds Occupied Estimated (All Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Total LL (COVID-19 Inpatient) and Count LL (ICU), Total UL (COVID-19 Inpatient) and Count UL (ICU), Count UL (ICU) and Total Inpatient Beds (COVID-19 Inpatient), Total Staffed Adult ICU Beds (ICU) and Count UL (COVID-19 Inpatient), Total UL (COVID-19 Inpatient) and Count LL (COVID-19 Inpatient), Count LL (COVID-19 Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Staffed Adult ICU Beds Occupied Estimated (ICU) and Total Inpatient Beds (COVID-19 Inpatient), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Count UL (ICU), Inpatient Beds Occupied Estimated (All Inpatient) and Count UL (COVID-19 Inpatient), Total LL (COVID-19 Inpatient) and Total Inpatient Beds (All Inpatient), Total UL (COVID-19 Inpatient) and Total UL (ICU), Total UL (All Inpatient) and Count LL (ICU), Count LL (All Inpatient) and Total LL (ICU), Count UL (COVID-19 Inpatient) and Total Inpatient Beds (All Inpatient), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Total Inpatient Beds (All Inpatient), Staffed Adult ICU Beds Occupied Estimated (ICU) and Total LL (All Inpatient), Inpatient Beds Occupied Estimated (All Inpatient) and Total Inpatient Beds (All Inpatient), Count LL (COVID-19 Inpatient) and Total LL (All Inpatient), Total LL (COVID-19 Inpatient) and Count UL (COVID-19 Inpatient), Count UL (ICU) and Total LL (All Inpatient), Total UL (All Inpatient) and Count LL (All Inpatient), Total LL (ICU) and Count LL (ICU), Staffed Adult ICU Beds Occupied Estimated (ICU) and Total Inpatient Beds (All Inpatient), Inpatient Beds Occupied Estimated (All Inpatient) and Total LL (All Inpatient), Count UL (All Inpatient) and Count UL (ICU), Total UL (All Inpatient) and Total Staffed Adult ICU Beds (ICU), Total LL (ICU) and Count LL (COVID-19 Inpatient), Total UL (COVID-19 Inpatient) and Count UL (COVID-19 Inpatient), Count UL (COVID-19 Inpatient) and Total Inpatient Beds (COVID-19 Inpatient), Count LL (ICU) and Total Inpatient Beds (All Inpatient), Total UL (All Inpatient) and Inpatient Beds Occupied Estimated (All Inpatient), Total LL (ICU) and Total UL (ICU), Total UL (All Inpatient) and Total UL (COVID-19 Inpatient), Percentage of Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Percentage UL (COVID-19 Inpatient), Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) and Total LL (ICU), Count UL (COVID-19 Inpatient) and Count UL (ICU), Total LL (COVID-19 Inpatient) and Count UL (ICU)
Column name | Type | Unique values | Min value | Max value |
|---|---|---|---|---|
Count LL (All Inpatient) | numeric | 1,505 | 68 | 540842 |
Count UL (All Inpatient) | numeric | 1,498 | 556 | 541951 |
Percentage LL (All Inpatient) | numeric | 1,180 | -13.79 | 91.24 |
Inpatient Beds Occupied Estimated (All Inpatient) | numeric | 1,498 | 312 | 541397 |
Percentage UL (All Inpatient) | numeric | 1,207 | 43.13 | 137.62 |
Percentage of Inpatient Beds Occupied Estimated (All Inpatient) | numeric | 1,194 | 42.15 | 91.24 |
Total Inpatient Beds (All Inpatient) | numeric | 1,331 | 676 | 719565 |
Total LL (All Inpatient) | numeric | 1,385 | 280 | 719046 |
Total UL (All Inpatient) | numeric | 1,373 | 1046 | 720084 |
Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) | numeric | 1,298 | 9 | 112877 |
Count LL (COVID-19 Inpatient) | numeric | 1,292 | 7 | 112661 |
Count UL (COVID-19 Inpatient) | numeric | 1,298 | 9 | 113208 |
Percentage of Inpatient Beds Occupied by COVID-19 Patients Estimated (COVID-19 Inpatient) | numeric | 1,112 | 0.77 | 26.39 |
Total Inpatient Beds (COVID-19 Inpatient) | numeric | 1,331 | 676 | 719565 |
Percentage LL (COVID-19 Inpatient) | numeric | 1,098 | -11.34 | 26.39 |
Total LL (COVID-19 Inpatient) | numeric | 1,385 | 280 | 719046 |
Percentage UL (COVID-19 Inpatient) | numeric | 1,116 | 0.77 | 42.74 |
Total UL (COVID-19 Inpatient) | numeric | 1,373 | 1046 | 720084 |
Staffed Adult ICU Beds Occupied Estimated (ICU) | numeric | 1,106 | 27 | 68631 |
Count LL (ICU) | numeric | 1,124 | 5 | 68602 |
Count UL (ICU) | numeric | 1,126 | 49 | 68676 |
Percentage of Staffed Adult ICU Beds Occupied Estimated (ICU) | numeric | 1,237 | 43.55 | 103.7 |
Percentage LL (ICU) | numeric | 1,268 | -19.22 | 103.7 |
Total Staffed Adult ICU Beds (ICU) | numeric | 985 | 62 | 87158 |
Percentage UL (ICU) | numeric | 1,266 | 43.55 | 155.59 |
Total UL (ICU) | numeric | 1,001 | 93 | 87433 |
Total LL (ICU) | numeric | 1,012 | 28 | 86902 |
state | categorical | 52 | 2 | 2 |
geocoded_state | text | 52 | 3 | 29 |
collection_date | date | 31 | 2020/11/01 | 2020/12/12 |