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
1379 10100     Aberdeen, SD Micropolitan Statistical Area     Brown County South Dakota 46 13 Central
1384 10100     Aberdeen, SD Micropolitan Statistical Area     Edmunds County South Dakota 46 45 Outlying
1712 10140     Aberdeen, WA Micropolitan Statistical Area     Grays Harbor County Washington 53 27 Central
1480 10180     Abilene, TX Metropolitan Statistical Area     Callahan County Texas 48 59 Outlying
1527 10180     Abilene, TX Metropolitan Statistical Area     Jones County Texas 48 253 Outlying
1567 10180     Abilene, TX Metropolitan Statistical Area     Taylor County Texas 48 441 Central
1249 10220     Ada, OK Micropolitan Statistical Area     Pontotoc County Oklahoma 40 123 Central
1809 10260   434 Adjuntas, PR Micropolitan Statistical Area   Ponce-Coamo-Santa Isabel, PR Adjuntas Municipio Puerto Rico 72 1 Central
746 10300   220 Adrian, MI Micropolitan Statistical Area   Detroit-Warren-Ann Arbor, MI Lenawee County Michigan 26 91 Central
1810 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Aguada Municipio Puerto Rico 72 3 Central
1811 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Aguadilla Municipio Puerto Rico 72 5 Central
1814 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Añasco Municipio Puerto Rico 72 11 Central
1844 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Isabela Municipio Puerto Rico 72 71 Central
1849 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Lares Municipio Puerto Rico 72 81 Central
1856 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Moca Municipio Puerto Rico 72 99 Central
1865 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Rincón Municipio Puerto Rico 72 117 Central
1872 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     San Sebastián Municipio Puerto Rico 72 131 Central
1877 10380     Aguadilla-Isabela, PR Metropolitan Statistical Area     Utuado Municipio Puerto Rico 72 141 Central
1206 10420   184 Akron, OH Metropolitan Statistical Area   Cleveland-Akron-Canton, OH Portage County Ohio 39 133 Central
1214 10420   184 Akron, OH Metropolitan Statistical Area   Cleveland-Akron-Canton, OH Summit County Ohio 39 153 Central
1003 10460     Alamogordo, NM Micropolitan Statistical Area     Otero County New Mexico 35 35 Central
230 10500     Albany, GA Metropolitan Statistical Area     Baker County Georgia 13 7 Outlying
262 10500     Albany, GA Metropolitan Statistical Area     Dougherty County Georgia 13 95 Central
288 10500     Albany, GA Metropolitan Statistical Area     Lee County Georgia 13 177 Central
319 10500     Albany, GA Metropolitan Statistical Area     Terrell County Georgia 13 273 Outlying
331 10500     Albany, GA Metropolitan Statistical Area     Worth County Georgia 13 321 Outlying
1274 10540   440 Albany, OR Metropolitan Statistical Area   Portland-Vancouver-Salem, OR-WA Linn County Oregon 41 43 Central
1013 10580   104 Albany-Schenectady-Troy, NY Metropolitan Statistical Area   Albany-Schenectady, NY Albany County New York 36 1 Central
1047 10580   104 Albany-Schenectady-Troy, NY Metropolitan Statistical Area   Albany-Schenectady, NY Rensselaer County New York 36 83 Central
1051 10580   104 Albany-Schenectady-Troy, NY Metropolitan Statistical Area   Albany-Schenectady, NY Saratoga County New York 36 91 Central
1052 10580   104 Albany-Schenectady-Troy, NY Metropolitan Statistical Area   Albany-Schenectady, NY Schenectady County New York 36 93 Central
1053 10580   104 Albany-Schenectady-Troy, NY Metropolitan Statistical Area   Albany-Schenectady, NY Schoharie County New York 36 95 Outlying
1126 10620   172 Albemarle, NC Micropolitan Statistical Area   Charlotte-Concord, NC-SC Stanly County North Carolina 37 167 Central
783 10660     Albert Lea, MN Micropolitan Statistical Area     Freeborn County Minnesota 27 47 Central
28 10700   290 Albertville, AL Micropolitan Statistical Area   Huntsville-Decatur-Albertville, AL Marshall County Alabama 1 95 Central
992 10740   106 Albuquerque, NM Metropolitan Statistical Area   Albuquerque-Santa Fe-Las Vegas, NM Bernalillo County New Mexico 35 1 Central
1006 10740   106 Albuquerque, NM Metropolitan Statistical Area   Albuquerque-Santa Fe-Las Vegas, NM Sandoval County New Mexico 35 43 Central
1011 10740   106 Albuquerque, NM Metropolitan Statistical Area   Albuquerque-Santa Fe-Las Vegas, NM Torrance County New Mexico 35 57 Outlying
1012 10740   106 Albuquerque, NM Metropolitan Statistical Area   Albuquerque-Santa Fe-Las Vegas, NM Valencia County New Mexico 35 61 Outlying
644 10780     Alexandria, LA Metropolitan Statistical Area     Grant Parish Louisiana 22 43 Outlying
658 10780     Alexandria, LA Metropolitan Statistical Area     Rapides Parish Louisiana 22 79 Central
781 10820     Alexandria, MN Micropolitan Statistical Area     Douglas County Minnesota 27 41 Central
1525 10860   204 Alice, TX Micropolitan Statistical Area   Corpus Christi-Kingsville-Alice, TX Jim Wells County Texas 48 249 Central
991 10900   408 Allentown-Bethlehem-Easton, PA-NJ Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Warren County New Jersey 34 41 Central
1295 10900   408 Allentown-Bethlehem-Easton, PA-NJ Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Carbon County Pennsylvania 42 25 Central
1314 10900   408 Allentown-Bethlehem-Easton, PA-NJ Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Lehigh County Pennsylvania 42 77 Central
1323 10900   408 Allentown-Bethlehem-Easton, PA-NJ Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Northampton County Pennsylvania 42 95 Central
733 10940   394 Alma, MI Micropolitan Statistical Area   Mount Pleasant-Alma, MI Gratiot County Michigan 26 57 Central
718 10980     Alpena, MI Micropolitan Statistical Area     Alpena County Michigan 26 7 Central
1290 11020     Altoona, PA Metropolitan Statistical Area     Blair County Pennsylvania 42 13 Central
1235 11060     Altus, OK Micropolitan Statistical Area     Jackson County Oklahoma 40 65 Central
1465 11100   108 Amarillo, TX Metropolitan Statistical Area   Amarillo-Borger, TX Armstrong County Texas 48 11 Outlying
1482 11100   108 Amarillo, TX Metropolitan Statistical Area   Amarillo-Borger, TX Carson County Texas 48 65 Outlying
1551 11100   108 Amarillo, TX Metropolitan Statistical Area   Amarillo-Borger, TX Oldham County Texas 48 359 Outlying
1555 11100   108 Amarillo, TX Metropolitan Statistical Area   Amarillo-Borger, TX Potter County Texas 48 375 Central
1556 11100   108 Amarillo, TX Metropolitan Statistical Area   Amarillo-Borger, TX Randall County Texas 48 381 Central
315 11140     Americus, GA Micropolitan Statistical Area     Schley County Georgia 13 249 Outlying
318 11140     Americus, GA Micropolitan Statistical Area     Sumter County Georgia 13 261 Central
528 11180   218 Ames, IA Metropolitan Statistical Area   Des Moines-Ames-West Des Moines, IA Story County Iowa 19 169 Central
1034 11220   104 Amsterdam, NY Micropolitan Statistical Area   Albany-Schenectady, NY Montgomery County New York 36 57 Central
40 11260     Anchorage, AK Metropolitan Statistical Area     Anchorage Municipality Alaska 2 20 Central
44 11260     Anchorage, AK Metropolitan Statistical Area     Matanuska-Susitna Borough Alaska 2 170 Outlying
1461 11380     Andrews, TX Micropolitan Statistical Area     Andrews County Texas 48 3 Central
484 11420   258 Angola, IN Micropolitan Statistical Area   Fort Wayne-Huntington-Auburn, IN Steuben County Indiana 18 151 Central
765 11460   220 Ann Arbor, MI Metropolitan Statistical Area   Detroit-Warren-Ann Arbor, MI Washtenaw County Michigan 26 161 Central
5 11500     Anniston-Oxford-Jacksonville, AL Metropolitan Statistical Area     Calhoun County Alabama 1 15 Central
1761 11540   118 Appleton, WI Metropolitan Statistical Area   Appleton-Oshkosh-Neenah, WI Calumet County Wisconsin 55 15 Central
1785 11540   118 Appleton, WI Metropolitan Statistical Area   Appleton-Oshkosh-Neenah, WI Outagamie County Wisconsin 55 87 Central
189 11580   412 Arcadia, FL Micropolitan Statistical Area   North Port-Sarasota, FL DeSoto County Florida 12 27 Central
1226 11620     Ardmore, OK Micropolitan Statistical Area     Carter County Oklahoma 40 19 Central
1815 11640   490 Arecibo, PR Metropolitan Statistical Area   San Juan-Carolina, PR Arecibo Municipio Puerto Rico 72 13 Central
1822 11640   490 Arecibo, PR Metropolitan Statistical Area   San Juan-Carolina, PR Camuy Municipio Puerto Rico 72 27 Central
1841 11640   490 Arecibo, PR Metropolitan Statistical Area   San Juan-Carolina, PR Hatillo Municipio Puerto Rico 72 65 Central
1864 11640   490 Arecibo, PR Metropolitan Statistical Area   San Juan-Carolina, PR Quebradillas Municipio Puerto Rico 72 115 Central
61 11660     Arkadelphia, AR Micropolitan Statistical Area     Clark County Arkansas 5 19 Central
538 11680   556 Arkansas City-Winfield, KS Micropolitan Statistical Area   Wichita-Arkansas City-Winfield, KS Cowley County Kansas 20 35 Central
1069 11700   120 Asheville, NC Metropolitan Statistical Area   Asheville-Brevard, NC Buncombe County North Carolina 37 21 Central
1094 11700   120 Asheville, NC Metropolitan Statistical Area   Asheville-Brevard, NC Haywood County North Carolina 37 87 Central
1095 11700   120 Asheville, NC Metropolitan Statistical Area   Asheville-Brevard, NC Henderson County North Carolina 37 89 Central
1105 11700   120 Asheville, NC Metropolitan Statistical Area   Asheville-Brevard, NC Madison County North Carolina 37 115 Outlying
1153 11740   360 Ashland, OH Micropolitan Statistical Area   Mansfield-Ashland-Bucyrus, OH Ashland County Ohio 39 5 Central
1154 11780   184 Ashtabula, OH Micropolitan Statistical Area   Cleveland-Akron-Canton, OH Ashtabula County Ohio 39 7 Central
1261 11820     Astoria, OR Micropolitan Statistical Area     Clatsop County Oregon 41 7 Central
535 11860   312 Atchison, KS Micropolitan Statistical Area   Kansas City-Overland Park-Kansas City, MO-KS Atchison County Kansas 20 5 Central
1155 11900     Athens, OH Micropolitan Statistical Area     Athens County Ohio 39 9 Central
1428 11940   174 Athens, TN Micropolitan Statistical Area   Chattanooga-Cleveland-Dalton, TN-GA-AL McMinn County Tennessee 47 107 Central
1514 11980   206 Athens, TX Micropolitan Statistical Area   Dallas-Fort Worth, TX-OK Henderson County Texas 48 213 Central
249 12020   122 Athens-Clarke County, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Clarke County Georgia 13 59 Central
295 12020   122 Athens-Clarke County, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Madison County Georgia 13 195 Outlying
304 12020   122 Athens-Clarke County, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Oconee County Georgia 13 219 Central
305 12020   122 Athens-Clarke County, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Oglethorpe County Georgia 13 221 Outlying
232 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Barrow County Georgia 13 13 Outlying
233 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Bartow County Georgia 13 15 Outlying
241 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Butts County Georgia 13 35 Outlying
243 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Carroll County Georgia 13 45 Outlying
248 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Cherokee County Georgia 13 57 Central
250 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Clayton County Georgia 13 63 Central
251 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Cobb County Georgia 13 67 Central
255 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Coweta County Georgia 13 77 Central
259 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA Dawson County Georgia 13 85 Outlying
261 12060   122 Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area   Atlanta--Athens-Clarke County--Sandy Springs, GA DeKalb County Georgia 13 89 Central
Powered by Datasette · Queries took 2.897ms · Data source: U.S. Department of Health & Human Services