\begin{tabular}{rlllrlllllllllllllll} \hline rowid & State & Geography\_Type & Metro & Hospitals & Total Beds & Estimated available beds (36\% of total) & Population\_allages & Infected\_allages & Severe\_allages & Critical\_allages & PatientsPerBed\_allages & PatientsPerAvailableBed\_allages & Population\_60plus & 60plus\_PercentOfTotalPopulation & Infected\_60plus & Severe\_60plus & Critical\_60plus & PatientsPerBed\_60plus & PatientsPerAvailableBed\_60plus \\ \hline 47 & District of Columbia & MD & District of Columbia, District of Columbia & 10 & 3,114 & 1121 & 702,455 & 51,982 & 7,173 & 3,171 & 3.3 & 9.2 & & & & & & & 0 \\ 93 & Minnesota & MD & St Cloud, Minnesota & 4 & 711 & 256 & 199,801 & 14,785 & 2,040 & 902 & 4.1 & 11.5 & & & & & & & 0 \\ 102 & Combined & CBSA & St Louis, Missouri \& Illinois & 43 & 9,555 & 3440 & 2,817,355 & 208,484 & 28,771 & 12,718 & 4.3 & 12.1 & & & & & & & 0 \\ 132 & Combined & CBSA & Louisville-Jefferson County, Kentucky \& Indiana & 15 & 3,701 & 1332 & 1,222,216 & 90,444 & 12,481 & 5,517 & 4.9 & 13.5 & & & & & & & 0 \\ 154 & California & MD & San Francisco-San Mateo-Redwood City, California & 17 & 4,747 & 1709 & 1,652,850 & 122,311 & 16,879 & 7,461 & 5.1 & 14.2 & & & & & & & 0 \\ 159 & Florida & CBSA & Tampa-St Petersburg-Clearwater, Florida & 34 & 8,984 & 3234 & 3,142,663 & 232,557 & 32,093 & 14,186 & 5.2 & 14.3 & & & & & & & 0 \\ 166 & Tennessee & CBSA & Nashville-Davidson-Murfreesboro-Franklin, Tennessee & 28 & 5,467 & 1968 & 1,930,961 & 142,891 & 19,719 & 8,716 & 5.2 & 14.4 & & & & & & & 0 \\ 183 & Florida & MD & Miami-Miami Beach-Kendall, Florida & 23 & 7,542 & 2715 & 2,761,581 & 204,357 & 28,201 & 12,466 & 5.4 & 15 & & & & & & & 0 \\ 191 & Florida & MD & West Palm Beach-Boca Raton-Boynton Beach, Florida & 15 & 3,987 & 1435 & 1,485,941 & 109,960 & 15,174 & 6,708 & 5.5 & 15.2 & & & & & & & 0 \\ 201 & Idaho & CBSA & Coeur dAlene, Idaho & 3 & 362 & 130 & 138,494 & 10,249 & 1,414 & 625 & 5.6 & 15.7 & & & & & & & 0 \\ 206 & Florida & MD & Fort Lauderdale-Pompano Beach-Sunrise, Florida & 17 & 5,003 & 1801 & 1,951,260 & 144,393 & 19,926 & 8,808 & 5.7 & 16 & & & & & & & 0 \\ 243 & Michigan & MD & Warren-Troy-Farmington Hills, Michigan & 24 & 5,847 & 2105 & 2,572,549 & 190,369 & 26,271 & 11,612 & 6.5 & 18 & & & & & & & 0 \\ 246 & Florida & CBSA & Port St Lucie, Florida & 4 & 1,088 & 392 & 482,040 & 35,671 & 4,923 & 2,176 & 6.5 & 18.1 & & & & & & & 0 \\ 272 & California & MD & Los Angeles-Long Beach-Glendale, California & 89 & 21,347 & 7685 & 10,105,518 & 747,808 & 103,198 & 45,616 & 7 & 19.4 & & & & & & & 0 \\ 290 & Delaware & MD & Wilmington, Delaware & 4 & 1,473 & 530 & 724,768 & 53,633 & 7,401 & 3,272 & 7.2 & 20.1 & & & & & & & 0 \\ 311 & Utah & CBSA & St George, Utah & 1 & 263 & 95 & 138,115 & 10,221 & 1,410 & 623 & 7.7 & 21.4 & & & & & & & 0 \\ 322 & California & MD & Anaheim-Santa Ana-Irvine, California & 27 & 5,900 & 2124 & 3,185,968 & 235,762 & 32,535 & 14,381 & 8 & 22.1 & & & & & & & 0 \\ 327 & Combined & CBSA & Minneapolis-St Paul-Bloomington, Minnesota and Wisconsin & 34 & 6452 & 2323 & 3,629,190 & 268,560 & 37,061 & 16,382 & 8.3 & 23 & & & & & & & 0 \\ 360 & California & MD & Oakland-Berkeley-Livermore, California & 20 & 4,372 & 1574 & 2,816,968 & 208,456 & 28,767 & 12,716 & 9.5 & 26.4 & & & & & & & 0 \\ 371 & California & MD & San Rafael, California & 3 & 391 & 141 & 259,666 & 19,215 & 2,652 & 1,172 & 9.8 & 27.1 & & & & & & & 0 \\ 423 & Michigan & CBSA & Grand Rapids-Wyoming, Michigan & 1 & 39 & 14 & 988,938 & 73,181 & 10,099 & 4,464 & 373.4 & 1040.2 & & & & & & & \\ 425 & Illinois & No clean match & Chicago-Naperville-Evanston, Illinois & 68 & 19,170 & & No clean match & & & & & & & & & & & & \\ 426 & Illinois & No clean match & Elgin, Illinois & 7 & 1,065 & & No clean match & & & & & & & & & & & & \\ 427 & Illinois & No clean match & Lake County-Kenosha County, Illinois & 5 & 844 & & No clean match & & & & & & & & & & & & \\ 428 & Indiana & No clean match & Gary, Indiana & 14 & 2,965 & & No clean match & & & & & & & & & & & & \\ 429 & Maryland & No clean match & Frederick-Gaithersburg-Rockville, Maryland & 8 & 1,905 & & No clean match & & & & & & & & & & & & \\ 430 & Maryland & No clean match & Wilmington, Maryland & 1 & 109 & & No clean match & & & & & & & & & & & & \\ 431 & Massachusetts & No clean match & Boston, Massachusetts & 26 & 6,569 & & No clean match & & & & & & & & & & & & \\ 432 & Massachusetts & No clean match & Cambridge-Newton-Framingham, Massachusetts & 19 & 3,934 & & No clean match & & & & & & & & & & & & \\ 433 & Missouri & No clean match & St Joseph, Missouri & 1 & 352 & & No clean match & & & & & & & & & & & & \\ 434 & New Hampshire & No clean match & Rockingham County-Strafford County, New Hampshire & 6 & 719 & & No clean match & & & & & & & & & & & & \\ 435 & New Jersey & No clean match & Camden, New Jersey & 12 & 3,278 & & No clean match & & & & & & & & & & & & \\ 436 & New Jersey & No clean match & New Brunswick-Lakewood, New Jersey & 21 & 5,086 & & No clean match & & & & & & & & & & & & \\ 437 & New Jersey & No clean match & New York-Jersey City-White Plains, New Jersey & 15 & 4,793 & & No clean match & & & & & & & & & & & & \\ 438 & New Jersey & No clean match & Newark, New Jersey & 18 & 5,200 & & No clean match & & & & & & & & & & & & \\ 439 & New Jersey & No clean match & Wilmington, New Jersey & 2 & 222 & & No clean match & & & & & & & & & & & & \\ 440 & New York & No clean match & Nassau County-Suffolk County, New York & 20 & 7,497 & & No clean match & & & & & & & & & & & & \\ 441 & New York & No clean match & New York-Jersey City-White Plains, New York & 55 & 24,992 & & No clean match & & & & & & & & & & & & \\ 442 & Tennessee & No clean match & Chattanooga Clarksville, Tennessee & 5 & 1921 & & No clean match & & & & & & & & & & & & \\ 443 & Texas & No clean match & Dallas-Plano-Irving, Texas & 80 & 10,748 & & No clean match & & & & & & & & & & & & \\ 444 & Texas & No clean match & Fort Worth-Arlington-Grapevine, Texas & 40 & 5,595 & & No clean match & & & & & & & & & & & & \\ 445 & Washington & No clean match & Olympia-Tumwater, Washington & 2 & 401 & & No clean match & & & & & & & & & & & & \\ 446 & Washington & No clean match & Seattle-Bellevue-Kent, Washington & 22 & 5,239 & & No clean match & & & & & & & & & & & & \\ 447 & Washington & No clean match & Tacoma-Lakewood, Washington & 6 & 1,463 & & No clean match & & & & & & & & & & & & \\ 448 & Wisconsin & No clean match & Lake County-Kenosha County, Wisconsin & 2 & 273 & & No clean match & & & & & & & & & & & & \\ 55 & Alabama & CBSA & Birmingham-Hoover, Alabama & 17 & 4,632 & 1668 & 1,079,170 & 79,859 & 11,020 & 4,871 & 3.4 & 9.5 & 226,516 & 21.00\% & 16,762 & 2,313 & 1,022 & 0.7 & 2 \\ 285 & Rhode Island & CBSA & Providence-Warwick, Rhode Island & 11 & 2,187 & 787 & 1,056,138.00 & 78,154 & 10,785 & 4,767 & 7.1 & 19.8 & 237,693.00 & 22.50\% & 17,589 & 2,427 & 1,073 & 1.6 & 4.4 \\ 268 & Florida & CBSA & Cape Coral-Fort Myers, Florida & 4 & 1,503 & 541 & 700,165.00 & 51,812 & 7,150 & 3,161 & 6.9 & 19.1 & 239,488.00 & 34.20\% & 17,722 & 2,446 & 1,081 & 2.3 & 6.5 \\ 195 & Arizona & CBSA & Tucson, Arizona & 12 & 2,654 & 955 & 1,007,257.00 & 74,537 & 10,286 & 4,547 & 5.6 & 15.5 & 245,814.00 & 24.40\% & 18,190 & 2,510 & 1,110 & 1.4 & 3.8 \\ 126 & Missouri & CBSA & Kansas City, Missouri & 22 & 3,783 & 1362 & 1,224,869 & 90,640 & 12,508 & 5,529 & 4.8 & 13.2 & 247,311 & 20.20\% & 18,301 & 2,526 & 1,116 & 1 & 2.7 \\ 157 & New York & CBSA & Rochester, New York & 10 & 3,108 & 1119 & 1,080,653 & 79,968 & 11,036 & 4,878 & 5.1 & 14.2 & 247,834 & 22.90\% & 18,340 & 2,531 & 1,119 & 1.2 & 3.3 \\ 125 & Oklahoma & CBSA & Oklahoma City, Oklahoma & 31 & 4,225 & 1521 & 1,353,504 & 100,159 & 13,822 & 6,110 & 4.7 & 13.1 & 248,954 & 18.40\% & 18,423 & 2,542 & 1,124 & 0.9 & 2.4 \\ 143 & Virginia & CBSA & Richmond, Virginia & 16 & 3,671 & 1322 & 1,247,321.00 & 92,302 & 12,738 & 5,630 & 5 & 13.9 & 255,608.00 & 20.50\% & 18,915 & 2,610 & 1,154 & 1 & 2.8 \\ 106 & Louisiana & CBSA & New Orleans-Metairie, Louisiana & 29 & 4,245 & 1528 & 1,260,660 & 93,289 & 12,874 & 5,691 & 4.4 & 12.1 & 259,419 & 20.60\% & 19,197 & 2,649 & 1,171 & 0.9 & 2.5 \\ 88 & New York & CBSA & Buffalo-Cheektowaga, New York & 10 & 4,188 & 1508 & 1,136,670 & 84,114 & 11,608 & 5,131 & 4 & 11.1 & 269,308 & 23.70\% & 19,929 & 2,750 & 1,216 & 0.9 & 2.6 \\ 273 & Connecticut & CBSA & Hartford-East Hartford-Middletown, Connecticut & 11 & 2,566 & 924 & 1,213,123 & 89,771 & 12,388 & 5,476 & 7 & 19.3 & 274,153 & 22.60\% & 20,287 & 2,800 & 1,238 & 1.6 & 4.4 \\ 153 & Florida & CBSA & North Port-Sarasota-Bradenton, Florida & 9 & 2,222 & 800 & 768,381.00 & 56,860 & 7,847 & 3,468 & 5.1 & 14.1 & 294,621.00 & 38.30\% & 21,802 & 3,009 & 1,330 & 2 & 5.4 \\ 330 & Texas & CBSA & Austin-Round Rock-Georgetown, Texas & 29 & 3,498 & 1259 & 2,000,590 & 148,044 & 20,430 & 9,031 & 8.4 & 23.4 & 296,071 & 14.80\% & 21,909 & 3,023 & 1,336 & 1.2 & 3.5 \\ 155 & Florida & CBSA & Jacksonville, Florida & 14 & 4,158 & 1497 & 1,447,884.00 & 107,143 & 14,786 & 6,536 & 5.1 & 14.2 & 297,685.00 & 20.60\% & 22,029 & 3,040 & 1,344 & 1.1 & 2.9 \\ 211 & Wisconsin & CBSA & Milwaukee-Waukesha, Wisconsin & 24 & 4,030 & 1451 & 1,575,101.00 & 116,557 & 16,085 & 7,110 & 5.8 & 16 & 320,694.00 & 20.40\% & 23,731 & 3,275 & 1,448 & 1.2 & 3.3 \\ 280 & Virginia & CBSA & Virginia Beach-Norfolk-Newport News, Virginia & 18 & 3,556 & 1280 & 1,707,283.00 & 126,339 & 17,435 & 7,707 & 7.1 & 19.6 & 326,159.00 & 19.10\% & 24,136 & 3,331 & 1,472 & 1.4 & 3.8 \\ 151 & Ohio & CBSA & Cincinnati, Ohio & 20 & 4,815 & 1733 & 1,654,238 & 122,414 & 16,893 & 7,467 & 5.1 & 14.1 & 338,018 & 20.40\% & 25,013 & 3,452 & 1,526 & 1 & 2.9 \\ 344 & California & CBSA & San Jose-Sunnyvale-Santa Clara, California & 11 & 3,321 & 1196 & 1,969,897 & 145,772 & 20,117 & 8,892 & 8.7 & 24.3 & 348,794 & 17.70\% & 25,811 & 3,562 & 1,574 & 1.5 & 4.3 \\ 170 & Ohio & CBSA & Columbus, Ohio & 23 & 5,668 & 2040 & 2,023,695 & 149,753 & 20,666 & 9,135 & 5.3 & 14.6 & 360,880 & 17.80\% & 26,705 & 3,685 & 1,629 & 0.9 & 2.6 \\ 187 & Indiana & CBSA & Indianapolis-Carmel-Anderson, Indiana & 28 & 5,395 & 1942 & 1,989,032 & 147,188 & 20,312 & 8,978 & 5.4 & 15.1 & 364,107 & 18.30\% & 26,944 & 3,718 & 1,644 & 1 & 2.8 \\ 277 & North Carolina & CBSA & Charlotte-Concord-Gastonia, North Carolina & 19 & 4,365 & 1571 & 2081923 & 154,062 & 21,261 & 9,398 & 7 & 19.5 & 364756 & 17.50\% & 26,992 & 3,725 & 1,647 & 1.2 & 3.4 \\ 320 & Oregon & CBSA & Portland-Vancouver-Hillsboro, Oregon & 17 & 3,552 & 1279 & 1,913,065 & 141,567 & 19,536 & 8,636 & 7.9 & 22 & 374,979 & 19.60\% & 27,748 & 3,829 & 1,693 & 1.6 & 4.3 \\ 150 & Michigan & MD & Detroit-Dearborn-Livonia, Michigan & 19 & 5,094 & 1834 & 1,753,893.00 & 129,788 & 17,911 & 7,917 & 5.1 & 14.1 & 386,924.00 & 22.10\% & 28,632 & 3,951 & 1,747 & 1.1 & 3.1 \\ 262 & Nevada & CBSA & Las Vegas-Henderson-Paradise, Nevada & 24 & 4,590 & 1652 & 2,112,436 & 156,320 & 21,572 & 9,536 & 6.8 & 18.8 & 405,618 & 19.20\% & 30,016 & 4,142 & 1,831 & 1.3 & 3.6 \\ 214 & Texas & CBSA & San Antonio-New Braunfels, Texas & 26 & 6,009 & 2163 & 2,377,507 & 175,936 & 24,279 & 10,732 & 5.8 & 16.2 & 414,889 & 17.50\% & 30,702 & 4,237 & 1,873 & 1 & 2.8 \\ 91 & Pennsylvania & MD & Philadelphia, Pennsylvania & 27 & 7,855 & 2828 & 2148889 & 159,018 & 21,944 & 9,700 & 4 & 11.2 & 436433 & 20.30\% & 32,296 & 4,457 & 1,970 & 0.8 & 2.3 \\ 84 & Iowa & CBSA & Dubuque, Iowa & 3 & 360 & 130 & 96,571 & 7,146 & 986 & 436 & 4 & 10.9 & 22,155 & 22.90\% & 1,639 & 226 & 100 & 0.9 & 2.5 \\ 171 & Montana & CBSA & Missoula, Montana & 2 & 318 & 114 & 114,231 & 8,453 & 1,167 & 516 & 5.3 & 14.8 & 22,759 & 19.90\% & 1,684 & 232 & 103 & 1.1 & 2.9 \\ 409 & North Carolina & CBSA & Jacksonville, North Carolina & 1 & 149 & 54 & 192,685 & 14,259 & 1,968 & 870 & 19 & 52.6 & 22,983 & 11.90\% & 1,701 & 235 & 104 & 2.3 & 6.3 \\ 219 & Arizona & CBSA & Flagstaff, Arizona & 3 & 342 & 123 & 138,639.00 & 10,259 & 1,416 & 626 & 6 & 16.6 & 23,195.00 & 16.70\% & 1,716 & 237 & 105 & 1 & 2.8 \\ 53 & Virginia & CBSA & Winchester, Virginia & 1 & 485 & 175 & 111,300.00 & 8,236 & 1,137 & 502 & 3.4 & 9.4 & 23,506.00 & 21.10\% & 1,739 & 240 & 106 & 0.7 & 2 \\ 42 & Illinois & CBSA & Kankakee, Illinois & 2 & 500 & 180 & 110,801 & 8,199 & 1,131 & 500 & 3.3 & 9.1 & 23,667 & 21.40\% & 1,751 & 242 & 107 & 0.7 & 1.9 \\ 131 & West Virginia & CBSA & Parkersburg-Vienna, West Virginia & 2 & 279 & 100 & 91,816 & 6,794 & 938 & 414 & 4.8 & 13.5 & 23,820 & 25.90\% & 1,763 & 243 & 108 & 1.3 & 3.5 \\ 363 & New Mexico & CBSA & Farmington, New Mexico & 1 & 198 & 71 & 128,221 & 9,488 & 1,309 & 579 & 9.5 & 26.6 & 23,922 & 18.70\% & 1,770 & 244 & 108 & 1.8 & 5 \\ 369 & Wisconsin & CBSA & Fond du Lac, Wisconsin & 2 & 155 & 56 & 102,082.00 & 7,554 & 1,042 & 461 & 9.7 & 26.8 & 24,000.00 & 23.50\% & 1,776 & 245 & 108 & 2.3 & 6.3 \\ 27 & Ohio & CBSA & Lima, Ohio & 5 & 508 & 183 & 104,157 & 7,708 & 1,064 & 470 & 3 & 8.4 & 24,080 & 23.10\% & 1,782 & 246 & 109 & 0.7 & 1.9 \\ 85 & Texas & CBSA & San Angelo, Texas & 2 & 445 & 160 & 119,637 & 8,853 & 1,222 & 540 & 4 & 11 & 24,166 & 20.20\% & 1,788 & 247 & 109 & 0.8 & 2.2 \\ 366 & Idaho & CBSA & Logan, Idaho & 1 & 20 & 7 & 13,120 & 971 & 134 & 59 & 9.7 & 27.6 & 2,458 & 18.70\% & 182 & 25 & 11 & 1.8 & 5.1 \\ 23 & Maine & CBSA & Lewiston-Auburn, Maine & 2 & 540 & 194 & 107,317 & 7,941 & 1,096 & 484 & 2.9 & 8.1 & 24,289 & 22.60\% & 1,797 & 248 & 110 & 0.7 & 1.8 \\ 96 & Wisconsin & CBSA & La Crosse-Onalaska, Wisconsin & 2 & 414 & 149 & 117,582.00 & 8,701 & 1,201 & 531 & 4.2 & 11.6 & 24,464.00 & 20.80\% & 1,810 & 250 & 110 & 0.9 & 2.4 \\ 97 & Alabama & CBSA & Auburn-Opelika, Alabama & 1 & 549 & 198 & 156,597 & 11,588 & 1,599 & 707 & 4.2 & 11.6 & 24,513 & 15.70\% & 1,814 & 250 & 111 & 0.7 & 1.8 \\ 260 & Georgia & CBSA & Valdosta, Georgia & 3 & 315 & 113 & 143,969 & 10,654 & 1,470 & 650 & 6.7 & 18.8 & 24,673 & 17.10\% & 1,826 & 252 & 111 & 1.2 & 3.2 \\ 355 & New Jersey & CBSA & Allentown-Bethlehem-Easton, New Jersey & 2 & 172 & 62 & 107,088 & 7,925 & 1,094 & 483 & 9.2 & 25.4 & 24,579 & 23.00\% & 1,819 & 251 & 111 & 2.1 & 5.8 \\ 123 & Louisiana & CBSA & Hammond, Louisiana & 8 & 405 & 146 & 128,850 & 9,535 & 1,316 & 582 & 4.7 & 13 & 24,738 & 19.20\% & 1,831 & 253 & 112 & 0.9 & 2.5 \\ 9 & Alabama & CBSA & Gadsden, Alabama & 3 & 603 & 217 & 103,132 & 7,632 & 1,053 & 466 & 2.5 & 7 & 25,122 & 24.40\% & 1,859 & 257 & 113 & 0.6 & 1.7 \\ 13 & Arkansas & CBSA & Jonesboro, Arkansas & 4 & 691 & 249 & 128,344 & 9,497 & 1,311 & 579 & 2.7 & 7.6 & 25,035 & 19.50\% & 1,853 & 256 & 113 & 0.5 & 1.5 \\ 222 & Idaho & CBSA & Idaho Falls, Idaho & 3 & 345 & 124 & 140,427 & 10,392 & 1,434 & 634 & 6 & 16.7 & 25,189 & 17.90\% & 1,864 & 257 & 114 & 1.1 & 3 \\ 5 & West Virginia & CBSA & Morgantown, West Virginia & 4 & 958 & 345 & 137,475 & 10,173 & 1,404 & 621 & 2.1 & 5.9 & 25,481 & 18.50\% & 1,886 & 260 & 115 & 0.4 & 1.1 \\ 113 & Indiana & CBSA & Muncie, Indiana & 2 & 376 & 135 & 115,938 & 8,579 & 1,184 & 523 & 4.5 & 12.6 & 25,540 & 22.00\% & 1,890 & 261 & 115 & 1 & 2.8 \\ 248 & Texas & CBSA & Midland, Texas & 4 & 372 & 134 & 165,430 & 12,242 & 1,689 & 747 & 6.5 & 18.2 & 25,575 & 15.50\% & 1,893 & 261 & 115 & 1 & 2.8 \\ 385 & Connecticut & CBSA & Worcester, Connecticut & 2 & 161 & 58 & 116,674 & 8,634 & 1,191 & 527 & 10.7 & 29.6 & 25,482 & 21.80\% & 1,886 & 260 & 115 & 2.3 & 6.5 \\ 234 & Indiana & CBSA & Michigan City-La Porte, Indiana & 2 & 262 & 94 & 110,839 & 8,202 & 1,132 & 500 & 6.2 & 17.4 & 25,713 & 23.20\% & 1,903 & 263 & 116 & 1.4 & 4 \\ 321 & Virginia & CBSA & Harrisonburg, Virginia & 1 & 244 & 88 & 131,717.00 & 9,747 & 1,345 & 595 & 7.9 & 22 & 25,590.00 & 19.40\% & 1,894 & 261 & 116 & 1.5 & 4.3 \\ 65 & North Dakota & CBSA & Bismarck, North Dakota & 3 & 505 & 182 & 124,253 & 9,195 & 1,269 & 561 & 3.6 & 10.1 & 25,840 & 20.80\% & 1,912 & 264 & 117 & 0.8 & 2.1 \\ 346 & Georgia & CBSA & Dalton, Georgia & 2 & 239 & 86 & 143,407 & 10,612 & 1,464 & 647 & 8.8 & 24.5 & 26,145 & 18.20\% & 1,935 & 267 & 118 & 1.6 & 4.5 \\ \hline \end{tabular}