COVID-19 Reported Patient Impact and Hospital Capacity by Facility

This dataset provides facility-level data for hospital utilization overall, and for COVID patients, on a weekly basis (Friday to Thursday) since July 31. The data come directly from the U.S. Department of Health and Human Services. We have not reviewed the data for accuracy.

The data is released each Monday with data for the prior week. This data was updated Mar 21, 2022.

Numbers smaller than 4 have been replaced, by HHS, with the value -999999. See the data dictionary for more details.

The 'collection_week' date is the start of a seven day period including Friday and ending and including reports for the following Thursday

Data source: U.S. Department of Health & Human Services

This database can be queried directly using Structured Query Language (SQL) supported by SQLite. For more on that syntax, see here. Read more about datasette, the technology powering these interactive queries.

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidcbsacodemetrodivisioncodecsacodecbsatitlemetropolitanmicropolitanstatismetropolitandivisiontitlecsatitlecountycountyequivalentstatenamefipsstatecodefipscountycodecentraloutlyingcounty
1 33860     Montgomery, AL Metropolitan Statistical Area     Autauga County Alabama 1 1 Central
2 19300   380 Daphne-Fairhope-Foley, AL Metropolitan Statistical Area   Mobile-Daphne-Fairhope, AL Baldwin County Alabama 1 3 Central
3 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Bibb County Alabama 1 7 Outlying
4 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Blount County Alabama 1 9 Outlying
5 11500     Anniston-Oxford-Jacksonville, AL Metropolitan Statistical Area     Calhoun County Alabama 1 15 Central
6 46740   194 Valley, AL Micropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Chambers County Alabama 1 17 Central
7 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Chilton County Alabama 1 21 Outlying
8 21460   222 Enterprise, AL Micropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Coffee County Alabama 1 31 Central
9 22520     Florence-Muscle Shoals, AL Metropolitan Statistical Area     Colbert County Alabama 1 33 Central
10 45180   142 Talladega-Sylacauga, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Coosa County Alabama 1 37 Outlying
11 18980   142 Cullman, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Cullman County Alabama 1 43 Central
12 37120   222 Ozark, AL Micropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Dale County Alabama 1 45 Central
13 42820     Selma, AL Micropolitan Statistical Area     Dallas County Alabama 1 47 Central
14 33860     Montgomery, AL Metropolitan Statistical Area     Elmore County Alabama 1 51 Central
15 23460     Gadsden, AL Metropolitan Statistical Area     Etowah County Alabama 1 55 Central
16 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Geneva County Alabama 1 61 Outlying
17 46220     Tuscaloosa, AL Metropolitan Statistical Area     Hale County Alabama 1 65 Outlying
18 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Henry County Alabama 1 67 Outlying
19 20020   222 Dothan, AL Metropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Houston County Alabama 1 69 Central
20 42460   174 Scottsboro, AL Micropolitan Statistical Area   Chattanooga-Cleveland-Dalton, TN-GA-AL Jackson County Alabama 1 71 Central
21 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Jefferson County Alabama 1 73 Central
22 22520     Florence-Muscle Shoals, AL Metropolitan Statistical Area     Lauderdale County Alabama 1 77 Central
23 19460   290 Decatur, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Lawrence County Alabama 1 79 Outlying
24 12220   194 Auburn-Opelika, AL Metropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Lee County Alabama 1 81 Central
25 26620   290 Huntsville, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Limestone County Alabama 1 83 Outlying
26 33860     Montgomery, AL Metropolitan Statistical Area     Lowndes County Alabama 1 85 Outlying
27 26620   290 Huntsville, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Madison County Alabama 1 89 Central
28 10700   290 Albertville, AL Micropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Marshall County Alabama 1 95 Central
29 33660   380 Mobile, AL Metropolitan Statistical Area   Mobile-Daphne-Fairhope, AL Mobile County Alabama 1 97 Central
30 33860     Montgomery, AL Metropolitan Statistical Area     Montgomery County Alabama 1 101 Central
31 19460   290 Decatur, AL Metropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Morgan County Alabama 1 103 Central
32 46220     Tuscaloosa, AL Metropolitan Statistical Area     Pickens County Alabama 1 107 Outlying
33 45980     Troy, AL Micropolitan Statistical Area     Pike County Alabama 1 109 Central
34 17980   194 Columbus, GA-AL Metropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Russell County Alabama 1 113 Central
35 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL St. Clair County Alabama 1 115 Outlying
36 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Shelby County Alabama 1 117 Central
37 45180   142 Talladega-Sylacauga, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Talladega County Alabama 1 121 Central
38 46220     Tuscaloosa, AL Metropolitan Statistical Area     Tuscaloosa County Alabama 1 125 Central
39 13820   142 Birmingham-Hoover, AL Metropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Walker County Alabama 1 127 Outlying
40 11260     Anchorage, AK Metropolitan Statistical Area     Anchorage Municipality Alaska 2 20 Central
41 21820     Fairbanks, AK Metropolitan Statistical Area     Fairbanks North Star Borough Alaska 2 90 Central
42 27940     Juneau, AK Micropolitan Statistical Area     Juneau City and Borough Alaska 2 110 Central
43 28540     Ketchikan, AK Micropolitan Statistical Area     Ketchikan Gateway Borough Alaska 2 130 Central
44 11260     Anchorage, AK Metropolitan Statistical Area     Matanuska-Susitna Borough Alaska 2 170 Outlying
45 43420     Sierra Vista-Douglas, AZ Metropolitan Statistical Area     Cochise County Arizona 4 3 Central
46 22380     Flagstaff, AZ Metropolitan Statistical Area     Coconino County Arizona 4 5 Central
47 37740     Payson, AZ Micropolitan Statistical Area     Gila County Arizona 4 7 Central
48 40940     Safford, AZ Micropolitan Statistical Area     Graham County Arizona 4 9 Central
49 38060     Phoenix-Mesa-Scottsdale, AZ Metropolitan Statistical Area     Maricopa County Arizona 4 13 Central
50 29420   332 Lake Havasu City-Kingman, AZ Metropolitan Statistical Area   Las Vegas-Henderson, NV-AZ Mohave County Arizona 4 15 Central
51 43320     Show Low, AZ Micropolitan Statistical Area     Navajo County Arizona 4 17 Central
52 46060   536 Tucson, AZ Metropolitan Statistical Area   Tucson-Nogales, AZ Pima County Arizona 4 19 Central
53 38060     Phoenix-Mesa-Scottsdale, AZ Metropolitan Statistical Area     Pinal County Arizona 4 21 Central
54 35700   536 Nogales, AZ Micropolitan Statistical Area   Tucson-Nogales, AZ Santa Cruz County Arizona 4 23 Central
55 39140     Prescott, AZ Metropolitan Statistical Area     Yavapai County Arizona 4 25 Central
56 49740     Yuma, AZ Metropolitan Statistical Area     Yuma County Arizona 4 27 Central
57 34260     Mountain Home, AR Micropolitan Statistical Area     Baxter County Arkansas 5 5 Central
58 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Benton County Arkansas 5 7 Central
59 25460     Harrison, AR Micropolitan Statistical Area     Boone County Arkansas 5 9 Central
60 15780     Camden, AR Micropolitan Statistical Area     Calhoun County Arkansas 5 13 Outlying
61 11660     Arkadelphia, AR Micropolitan Statistical Area     Clark County Arkansas 5 19 Central
62 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Cleveland County Arkansas 5 25 Outlying
63 31620     Magnolia, AR Micropolitan Statistical Area     Columbia County Arkansas 5 27 Central
64 27860   308 Jonesboro, AR Metropolitan Statistical Area   Jonesboro-Paragould, AR Craighead County Arkansas 5 31 Central
65 22900     Fort Smith, AR-OK Metropolitan Statistical Area     Crawford County Arkansas 5 33 Central
66 32820   368 Memphis, TN-MS-AR Metropolitan Statistical Area   Memphis-Forrest City, TN-MS-AR Crittenden County Arkansas 5 35 Central
67 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Faulkner County Arkansas 5 45 Outlying
68 26300   284 Hot Springs, AR Metropolitan Statistical Area   Hot Springs-Malvern, AR Garland County Arkansas 5 51 Central
69 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Grant County Arkansas 5 53 Outlying
70 37500   308 Paragould, AR Micropolitan Statistical Area   Jonesboro-Paragould, AR Greene County Arkansas 5 55 Central
71 31680   284 Malvern, AR Micropolitan Statistical Area   Hot Springs-Malvern, AR Hot Spring County Arkansas 5 59 Central
72 12900     Batesville, AR Micropolitan Statistical Area     Independence County Arkansas 5 63 Central
73 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Jefferson County Arkansas 5 69 Central
74 38220   340 Pine Bluff, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Lincoln County Arkansas 5 79 Outlying
75 45500     Texarkana, TX-AR Metropolitan Statistical Area     Little River County Arkansas 5 81 Outlying
76 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Lonoke County Arkansas 5 85 Central
77 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Madison County Arkansas 5 87 Outlying
78 45500     Texarkana, TX-AR Metropolitan Statistical Area     Miller County Arkansas 5 91 Central
79 14180     Blytheville, AR Micropolitan Statistical Area     Mississippi County Arkansas 5 93 Central
80 25460     Harrison, AR Micropolitan Statistical Area     Newton County Arkansas 5 101 Outlying
81 15780     Camden, AR Micropolitan Statistical Area     Ouachita County Arkansas 5 103 Central
82 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Perry County Arkansas 5 105 Outlying
83 25760     Helena-West Helena, AR Micropolitan Statistical Area     Phillips County Arkansas 5 107 Central
84 27860   308 Jonesboro, AR Metropolitan Statistical Area   Jonesboro-Paragould, AR Poinsett County Arkansas 5 111 Outlying
85 40780     Russellville, AR Micropolitan Statistical Area     Pope County Arkansas 5 115 Central
86 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Pulaski County Arkansas 5 119 Central
87 22620   368 Forrest City, AR Micropolitan Statistical Area   Memphis-Forrest City, TN-MS-AR St. Francis County Arkansas 5 123 Central
88 30780   340 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area   Little Rock-North Little Rock, AR Saline County Arkansas 5 125 Central
89 22900     Fort Smith, AR-OK Metropolitan Statistical Area     Sebastian County Arkansas 5 131 Central
90 20980     El Dorado, AR Micropolitan Statistical Area     Union County Arkansas 5 139 Central
91 22220     Fayetteville-Springdale-Rogers, AR-MO Metropolitan Statistical Area     Washington County Arkansas 5 143 Central
92 42620   340 Searcy, AR Micropolitan Statistical Area   Little Rock-North Little Rock, AR White County Arkansas 5 145 Central
93 40780     Russellville, AR Micropolitan Statistical Area     Yell County Arkansas 5 149 Outlying
94 41860 36084 488 San Francisco-Oakland-Hayward, CA Metropolitan Statistical Area Oakland-Hayward-Berkeley, CA San Jose-San Francisco-Oakland, CA Alameda County California 6 1 Central
95 17020     Chico, CA Metropolitan Statistical Area     Butte County California 6 7 Central
96 41860 36084 488 San Francisco-Oakland-Hayward, CA Metropolitan Statistical Area Oakland-Hayward-Berkeley, CA San Jose-San Francisco-Oakland, CA Contra Costa County California 6 13 Outlying
97 18860     Crescent City, CA Micropolitan Statistical Area     Del Norte County California 6 15 Central
98 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA El Dorado County California 6 17 Central
99 23420   260 Fresno, CA Metropolitan Statistical Area   Fresno-Madera, CA Fresno County California 6 19 Central
100 21700     Eureka-Arcata-Fortuna, CA Micropolitan Statistical Area     Humboldt County California 6 23 Central
101 20940     El Centro, CA Metropolitan Statistical Area     Imperial County California 6 25 Central
Powered by Datasette · Queries took 2.654ms · Data source: U.S. Department of Health & Human Services