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)

Query parameters

This data as json, CSV

rowidcbsacodemetrodivisioncodecsacodecbsatitlemetropolitanmicropolitanstatismetropolitandivisiontitlecsatitlecountycountyequivalentstatenamefipsstatecodefipscountycodecentraloutlyingcounty
6 46740   194 Valley, AL Micropolitan Statistical Area   Columbus-Auburn-Opelika, GA-AL Chambers County Alabama 1 17 Central
8 21460   222 Enterprise, AL Micropolitan Statistical Area   Dothan-Enterprise-Ozark, AL Coffee County Alabama 1 31 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
20 42460   174 Scottsboro, AL Micropolitan Statistical Area   Chattanooga-Cleveland-Dalton, TN-GA-AL Jackson County Alabama 1 71 Central
28 10700   290 Albertville, AL Micropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Marshall County Alabama 1 95 Central
33 45980     Troy, AL Micropolitan Statistical Area     Pike County Alabama 1 109 Central
37 45180   142 Talladega-Sylacauga, AL Micropolitan Statistical Area   Birmingham-Hoover-Talladega, AL Talladega County Alabama 1 121 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
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
51 43320     Show Low, AZ Micropolitan Statistical Area     Navajo County Arizona 4 17 Central
54 35700   536 Nogales, AZ Micropolitan Statistical Area   Tucson-Nogales, AZ Santa Cruz County Arizona 4 23 Central
57 34260     Mountain Home, AR Micropolitan Statistical Area     Baxter County Arkansas 5 5 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
63 31620     Magnolia, AR Micropolitan Statistical Area     Columbia County Arkansas 5 27 Central
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
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
83 25760     Helena-West Helena, AR Micropolitan Statistical Area     Phillips County Arkansas 5 107 Central
85 40780     Russellville, AR Micropolitan Statistical Area     Pope County Arkansas 5 115 Central
87 22620   368 Forrest City, AR Micropolitan Statistical Area   Memphis-Forrest City, TN-MS-AR St. Francis County Arkansas 5 123 Central
90 20980     El Dorado, AR Micropolitan Statistical Area     Union County Arkansas 5 139 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
97 18860     Crescent City, CA Micropolitan Statistical Area     Del Norte County California 6 15 Central
100 21700     Eureka-Arcata-Fortuna, CA Micropolitan Statistical Area     Humboldt County California 6 23 Central
104 17340     Clearlake, CA Micropolitan Statistical Area     Lake County California 6 33 Central
105 45000     Susanville, CA Micropolitan Statistical Area     Lassen County California 6 35 Central
109 46380     Ukiah, CA Micropolitan Statistical Area     Mendocino County California 6 45 Central
113 46020   472 Truckee-Grass Valley, CA Micropolitan Statistical Area   Sacramento-Roseville, CA Nevada County California 6 57 Central
133 39780   454 Red Bluff, CA Micropolitan Statistical Area   Redding-Red Bluff, CA Tehama County California 6 103 Central
135 43760     Sonora, CA Micropolitan Statistical Area     Tuolumne County California 6 109 Central
146 20780   233 Edwards, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Eagle County Colorado 8 37 Central
149 15860   444 Cañon City, CO Micropolitan Statistical Area   Pueblo-Cañon City, CO Fremont County Colorado 8 43 Central
150 24060   233 Glenwood Springs, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Garfield County Colorado 8 45 Central
153 20420     Durango, CO Micropolitan Statistical Area     La Plata County Colorado 8 67 Central
155 44540     Sterling, CO Micropolitan Statistical Area     Logan County Colorado 8 75 Central
157 18780   525 Craig, CO Micropolitan Statistical Area   Steamboat Springs-Craig, CO Moffat County Colorado 8 81 Central
158 33940     Montrose, CO Micropolitan Statistical Area     Montrose County Colorado 8 85 Central
159 22820     Fort Morgan, CO Micropolitan Statistical Area     Morgan County Colorado 8 87 Central
161 24060   233 Glenwood Springs, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Pitkin County Colorado 8 97 Outlying
163 44460   525 Steamboat Springs, CO Micropolitan Statistical Area   Steamboat Springs-Craig, CO Routt County Colorado 8 107 Central
164 14720     Breckenridge, CO Micropolitan Statistical Area     Summit County Colorado 8 117 Central
169 45860   408 Torrington, CT Micropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Litchfield County Connecticut 9 5 Central
188 29380   264 Lake City, FL Micropolitan Statistical Area   Gainesville-Lake City, FL Columbia County Florida 12 23 Central
189 11580   412 Arcadia, FL Micropolitan Statistical Area   North Port-Sarasota, FL DeSoto County Florida 12 27 Central
196 48100     Wauchula, FL Micropolitan Statistical Area     Hardee County Florida 12 49 Central
197 17500     Clewiston, FL Micropolitan Statistical Area     Hendry County Florida 12 51 Central
210 28580     Key West, FL Micropolitan Statistical Area     Monroe County Florida 12 87 Central
213 36380   370 Okeechobee, FL Micropolitan Statistical Area   Miami-Fort Lauderdale-Port St. Lucie, FL Okeechobee County Florida 12 93 Central
220 37260   300 Palatka, FL Micropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Putnam County Florida 12 107 Central
231 33300     Milledgeville, GA Micropolitan Statistical Area     Baldwin County Georgia 13 9 Central
234 22340     Fitzgerald, GA Micropolitan Statistical Area     Ben Hill County Georgia 13 17 Central
239 44340   496 Statesboro, GA Micropolitan Statistical Area   Savannah-Hinesville-Statesboro, GA Bulloch County Georgia 13 31 Central
242 41220   300 St. Marys, GA Micropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Camden County Georgia 13 39 Central
247 44900   470 Summerville, GA Micropolitan Statistical Area   Rome-Summerville, GA Chattooga County Georgia 13 55 Central
252 20060     Douglas, GA Micropolitan Statistical Area     Coffee County Georgia 13 69 Central
253 34220     Moultrie, GA Micropolitan Statistical Area     Colquitt County Georgia 13 71 Central
257 18380     Cordele, GA Micropolitan Statistical Area     Crisp County Georgia 13 81 Central
260 12460   533 Bainbridge, GA Micropolitan Statistical Area   Tallahassee-Bainbridge, FL-GA Decatur County Georgia 13 87 Central
271 15660   122 Calhoun, GA Micropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Gordon County Georgia 13 129 Central
273 18460     Cornelia, GA Micropolitan Statistical Area     Habersham County Georgia 13 137 Central
275 33300     Milledgeville, GA Micropolitan Statistical Area     Hancock County Georgia 13 141 Outlying
281 27600   122 Jefferson, GA Micropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Jackson County Georgia 13 157 Central
283 20140     Dublin, GA Micropolitan Statistical Area     Johnson County Georgia 13 167 Outlying
287 20140     Dublin, GA Micropolitan Statistical Area     Laurens County Georgia 13 175 Central
299 47080     Vidalia, GA Micropolitan Statistical Area     Montgomery County Georgia 13 209 Outlying
309 48180     Waycross, GA Micropolitan Statistical Area     Pierce County Georgia 13 229 Outlying
311 16340   122 Cedartown, GA Micropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Polk County Georgia 13 233 Central
315 11140     Americus, GA Micropolitan Statistical Area     Schley County Georgia 13 249 Outlying
317 45740     Toccoa, GA Micropolitan Statistical Area     Stephens County Georgia 13 257 Central
318 11140     Americus, GA Micropolitan Statistical Area     Sumter County Georgia 13 261 Central
320 45620     Thomasville, GA Micropolitan Statistical Area     Thomas County Georgia 13 275 Central
321 45700     Tifton, GA Micropolitan Statistical Area     Tift County Georgia 13 277 Central
322 47080     Vidalia, GA Micropolitan Statistical Area     Toombs County Georgia 13 279 Central
323 29300   122 LaGrange, GA Micropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Troup County Georgia 13 285 Central
325 45580   122 Thomaston, GA Micropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Upson County Georgia 13 293 Central
328 48180     Waycross, GA Micropolitan Statistical Area     Ware County Georgia 13 299 Central
329 27700     Jesup, GA Micropolitan Statistical Area     Wayne County Georgia 13 305 Central
332 25900     Hilo, HI Micropolitan Statistical Area     Hawaii County Hawaii 15 1 Central
335 28180     Kapaa, HI Micropolitan Statistical Area     Kauai County Hawaii 15 7 Central
339 13940   292 Blackfoot, ID Micropolitan Statistical Area   Idaho Falls-Rexburg-Blackfoot, ID Bingham County Idaho 16 11 Central
340 25200     Hailey, ID Micropolitan Statistical Area     Blaine County Idaho 16 13 Central
342 41760     Sandpoint, ID Micropolitan Statistical Area     Bonner County Idaho 16 17 Central
345 25200     Hailey, ID Micropolitan Statistical Area     Camas County Idaho 16 25 Outlying
347 15420     Burley, ID Micropolitan Statistical Area     Cassia County Idaho 16 31 Central
348 34300   147 Mountain Home, ID Micropolitan Statistical Area   Boise City-Mountain Home-Ontario, ID-OR Elmore County Idaho 16 39 Central
350 39940   292 Rexburg, ID Micropolitan Statistical Area   Idaho Falls-Rexburg-Blackfoot, ID Fremont County Idaho 16 43 Outlying
353 46300     Twin Falls, ID Micropolitan Statistical Area     Jerome County Idaho 16 53 Outlying
355 34140   446 Moscow, ID Micropolitan Statistical Area   Pullman-Moscow, WA-ID Latah County Idaho 16 57 Central
356 25200     Hailey, ID Micropolitan Statistical Area     Lincoln County Idaho 16 63 Outlying
357 39940   292 Rexburg, ID Micropolitan Statistical Area   Idaho Falls-Rexburg-Blackfoot, ID Madison County Idaho 16 65 Central
Powered by Datasette · Queries took 2.513ms · Data source: U.S. Department of Health & Human Services