CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Population_allages
This data as json, copyable, CSV (advanced)
Suggested facets: Geography_Type
Link | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
195 | 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 |
112 | 112 | Tennessee | CBSA | Memphis, Tennessee | 13 | 3,406 | 1226 | 1,038,617 | 76,858 | 10,606 | 4,688 | 4.5 | 12.5 | 191,995 | 18.50% | 14,208 | 1,961 | 867 | 0.8 | 2.3 |
232 | 232 | Michigan | CBSA | Grand Rapids-Kentwood, Michigan | 11 | 2,491 | 897 | 1,043,722.00 | 77,235 | 10,658 | 4,711 | 6.2 | 17.1 | 197,462.00 | 18.90% | 14,612 | 2,016 | 891 | 1.2 | 3.2 |
285 | 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 |
55 | 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 |
157 | 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 |
88 | 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 |
230 | 230 | Utah | CBSA | Salt Lake City, Utah | 17 | 2,817 | 1014 | 1,170,057 | 86,584 | 11,949 | 5,282 | 6.1 | 17 | 172,787 | 14.80% | 12,786 | 1,765 | 780 | 0.9 | 2.5 |
273 | 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 |
132 | 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 | ||||||
126 | 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 |
143 | 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 | 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 |
379 | 379 | North Carolina | CBSA | Raleigh-Cary, North Carolina | 5 | 1,867 | 672 | 1,273,985 | 94,275 | 13,010 | 5,751 | 10 | 27.9 | 205,440 | 16.10% | 15,203 | 2,098 | 927 | 1.6 | 4.5 |
125 | 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 |
155 | 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 |
191 | 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 | ||||||
211 | 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 |
154 | 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 | ||||||
151 | 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 |
280 | 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 |
150 | 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 |
320 | 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 |
166 | 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 | ||||||
206 | 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 | ||||||
344 | 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 |
187 | 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 |
272 | 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 | ||||||
264 | 264 | Alaska | CBSA | Fairbanks, Alaska | 1 | 217 | 78 | 100,031 | 7,402 | 1,022 | 452 | 6.8 | 18.9 | 13,950 | 13.90% | 1,032 | 142 | 63 | 0.9 | 2.6 |
177 | 177 | Florida | CBSA | Sebring-Avon Park, Florida | 2 | 277 | 100 | 100,177.00 | 7,413 | 1,023 | 452 | 5.3 | 14.8 | 41,387.00 | 41.30% | 3,063 | 423 | 187 | 2.2 | 6.1 |
411 | 411 | Pennsylvania | CBSA | Gettysburg, Pennsylvania | 1 | 76 | 27 | 101,589.00 | 7,518 | 1,037 | 459 | 19.7 | 55.4 | 26,312.00 | 25.90% | 1,947 | 269 | 119 | 5.1 | 14.4 |
369 | 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 |
89 | 89 | Iowa | CBSA | Sioux City, Iowa | 3 | 374 | 135 | 102,397 | 7,577 | 1,046 | 462 | 4 | 11.2 | 20,666 | 20.20% | 1,529 | 211 | 93 | 0.8 | 2.3 |
9 | 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 |
333 | 333 | Washington | CBSA | Longview, Washington | 1 | 180 | 65 | 103,590 | 7,666 | 1,058 | 468 | 8.5 | 23.5 | 26,255 | 25.30% | 1,943 | 268 | 119 | 2.1 | 6 |
27 | 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 |
367 | 367 | New York | CBSA | Ithaca, New York | 1 | 159 | 57 | 104,415 | 7,727 | 1,066 | 471 | 9.7 | 27 | 18,998 | 18.20% | 1,406 | 194 | 86 | 1.8 | 4.9 |
233 | 233 | Idaho | CBSA | Twin Falls, Idaho | 2 | 249 | 90 | 105,287 | 7,791 | 1,075 | 475 | 6.2 | 17.2 | 20,766 | 19.70% | 1,537 | 212 | 94 | 1.2 | 3.4 |
109 | 109 | Michigan | CBSA | Bay City, Michigan | 2 | 348 | 125 | 105,350.00 | 7,796 | 1,076 | 476 | 4.5 | 12.4 | 27,300.00 | 25.90% | 2,020 | 279 | 123 | 1.2 | 3.2 |
355 | 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 |
23 | 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 |
24 | 24 | Illinois | CBSA | Decatur, Illinois | 2 | 534 | 192 | 107,587 | 7,961 | 1,099 | 486 | 3 | 8.3 | 27,263 | 25.30% | 2,017 | 278 | 123 | 0.8 | 2.1 |
42 | 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 |
234 | 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 |
404 | 404 | Maryland | CBSA | California-Lexington Park, Maryland | 1 | 109 | 39 | 110,979 | 8,212 | 1,133 | 501 | 15 | 41.9 | 18,983 | 17.10% | 1,405 | 194 | 86 | 2.6 | 7.2 |
53 | 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 |
15 | 15 | Kentucky | CBSA | Huntington-Ashland, Kentucky | 2 | 599 | 216 | 111,883 | 8,279 | 1,143 | 505 | 2.8 | 7.6 | 28,722 | 25.70% | 2,125 | 293 | 130 | 0.7 | 2 |
138 | 138 | Pennsylvania | CBSA | Youngstown-Warren-Boardman, Pennsylvania | 4 | 340 | 122 | 113,623.00 | 8,408 | 1,160 | 513 | 4.9 | 13.7 | 31,083.00 | 27.40% | 2,300 | 317 | 140 | 1.3 | 3.7 |
171 | 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 |
373 | 373 | Wisconsin | CBSA | Sheboygan, Wisconsin | 2 | 173 | 62 | 115,094.00 | 8,517 | 1,175 | 520 | 9.8 | 27.3 | 27,003.00 | 23.50% | 1,998 | 276 | 122 | 2.3 | 6.4 |
101 | 101 | Pennsylvania | CBSA | Williamsport, Pennsylvania | 3 | 394 | 142 | 115,398.00 | 8,539 | 1,178 | 521 | 4.3 | 12 | 28,691.00 | 24.90% | 2,123 | 293 | 130 | 1.1 | 3 |
217 | 217 | Alabama | CBSA | Anniston-Oxford, Alabama | 3 | 286 | 103 | 115,527 | 8,549 | 1,180 | 521 | 5.9 | 16.5 | 27,115 | 23.50% | 2,007 | 277 | 122 | 1.4 | 3.9 |
86 | 86 | Washington | CBSA | Wenatchee, Washington | 4 | 430 | 155 | 115,723 | 8,564 | 1,182 | 522 | 4 | 11 | 27,556 | 23.80% | 2,039 | 281 | 124 | 0.9 | 2.6 |
113 | 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 |
37 | 37 | Georgia | CBSA | Brunswick, Georgia | 1 | 532 | 192 | 115,939 | 8,579 | 1,184 | 523 | 3.2 | 8.9 | 28,946 | 25.00% | 2,142 | 296 | 131 | 0.8 | 2.2 |
250 | 250 | New York | CBSA | Watertown-Fort Drum, New York | 3 | 261 | 94 | 116,567 | 8,626 | 1,190 | 526 | 6.6 | 18.3 | 19,760 | 17.00% | 1,462 | 202 | 89 | 1.1 | 3.1 |
385 | 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 |
419 | 419 | Florida | CBSA | The Villages, Florida | 1 | 40 | 14 | 116,754.00 | 8,640 | 1,192 | 527 | 43 | 122.8 | 74,936.00 | 64.20% | 5,545 | 765 | 338 | 27.6 | 78.8 |
130 | 130 | Kentucky | CBSA | Owensboro, Kentucky | 1 | 360 | 130 | 117,319 | 8,682 | 1,198 | 530 | 4.8 | 13.3 | 26,490 | 22.60% | 1,960 | 271 | 120 | 1.1 | 3 |
96 | 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 |
397 | 397 | Kansas | CBSA | Lawrence, Kansas | 1 | 142 | 51 | 117,806 | 8,718 | 1,203 | 532 | 12.2 | 34 | 18,450 | 15.70% | 1,365 | 188 | 83 | 1.9 | 5.3 |
85 | 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 |
332 | 332 | Virginia | CBSA | Staunton, Virginia | 1 | 209 | 75 | 120,283.00 | 8,901 | 1,228 | 543 | 8.5 | 23.6 | 31,060.00 | 25.80% | 2,298 | 317 | 140 | 2.2 | 6.1 |
389 | 389 | Utah | CBSA | Logan, Utah | 2 | 159 | 57 | 120,288 | 8,901 | 1,228 | 543 | 11.1 | 31.1 | 15,104 | 12.60% | 1,118 | 154 | 68 | 1.4 | 3.9 |
364 | 364 | Tennessee | CBSA | Cleveland, Tennessee | 1 | 186 | 67 | 120,388 | 8,909 | 1,229 | 543 | 9.5 | 26.4 | 27,276 | 22.70% | 2,018 | 279 | 123 | 2.2 | 6 |
408 | 408 | Oregon | CBSA | Albany-Lebanon, Oregon | 2 | 95 | 34 | 121,074 | 8,959 | 1,236 | 547 | 18.8 | 52.4 | 29,548 | 24.40% | 2,187 | 302 | 133 | 4.6 | 12.8 |
247 | 247 | Ohio | CBSA | Mansfield, Ohio | 2 | 274 | 99 | 121,533 | 8,993 | 1,241 | 549 | 6.5 | 18.1 | 30,674 | 25.20% | 2,270 | 313 | 138 | 1.6 | 4.6 |
71 | 71 | West Virginia | CBSA | Beckley, West Virginia | 4 | 483 | 174 | 121,699 | 9,006 | 1,243 | 549 | 3.7 | 10.3 | 32,408 | 26.60% | 2,398 | 331 | 146 | 1 | 2.7 |
254 | 254 | Washington | CBSA | Mount Vernon-Anacortes, Washington | 3 | 270 | 97 | 121,725 | 9,008 | 1,243 | 549 | 6.6 | 18.5 | 31,915 | 26.20% | 2,362 | 326 | 144 | 1.7 | 4.8 |
224 | 224 | Iowa | CBSA | Ames, Iowa | 3 | 297 | 107 | 122,269 | 9,048 | 1,249 | 552 | 6.1 | 16.8 | 21,471 | 17.60% | 1,589 | 219 | 97 | 1.1 | 3 |
244 | 244 | Iowa | CBSA | Omaha-Council Bluffs, Iowa | 3 | 278 | 100 | 122,416 | 9,059 | 1,250 | 553 | 6.5 | 18 | 28,628 | 23.40% | 2,118 | 292 | 129 | 1.5 | 4.2 |
413 | 413 | North Carolina | CBSA | Myrtle Beach-Conway-North Myrtle Beach, North Carolina | 2 | 79 | 28 | 122,586 | 9,071 | 1,252 | 553 | 22.9 | 64.5 | 46,285 | 37.80% | 3,425 | 473 | 209 | 8.6 | 24.4 |
65 | 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 |
69 | 69 | Pennsylvania | CBSA | Altoona, Pennsylvania | 4 | 496 | 179 | 124,736.00 | 9,230 | 1,274 | 563 | 3.7 | 10.3 | 33,231.00 | 26.60% | 2,459 | 339 | 150 | 1 | 2.7 |
257 | 257 | North Carolina | CBSA | Goldsboro, North Carolina | 1 | 274 | 99 | 124496 | 9,213 | 1,271 | 562 | 6.7 | 18.5 | 26321 | 21.10% | 1,948 | 269 | 119 | 1.4 | 3.9 |
350 | 350 | North Carolina | CBSA | New Bern, North Carolina | 1 | 208 | 75 | 125,953 | 9,321 | 1,286 | 569 | 8.9 | 24.7 | 31,787 | 25.20% | 2,352 | 325 | 143 | 2.3 | 6.2 |
52 | 52 | Texas | CBSA | Sherman-Denison, Texas | 5 | 556 | 200 | 126,146 | 9,335 | 1,288 | 569 | 3.3 | 9.3 | 29,807 | 23.60% | 2,206 | 304 | 135 | 0.8 | 2.2 |
395 | 395 | Arizona | CBSA | Sierra Vista-Douglas, Arizona | 4 | 160 | 58 | 126,516.00 | 9,362 | 1,292 | 571 | 11.6 | 32.1 | 35,231.00 | 27.80% | 2,607 | 360 | 159 | 3.2 | 8.9 |
182 | 182 | New York | CBSA | Glens Falls, New York | 1 | 349 | 126 | 126,884 | 9,389 | 1,296 | 573 | 5.4 | 14.8 | 33,378 | 26.30% | 2,470 | 341 | 151 | 1.4 | 3.9 |
236 | 236 | Massachusetts | CBSA | Pittsfield, Massachusetts | 2 | 300 | 108 | 127,751 | 9,454 | 1,305 | 577 | 6.3 | 17.4 | 37,339 | 29.20% | 2,763 | 381 | 169 | 1.8 | 5.1 |
363 | 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 |
13 | 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 |
123 | 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 |
63 | 63 | Oklahoma | CBSA | Lawton, Oklahoma | 2 | 530 | 191 | 129,066 | 9,551 | 1,318 | 583 | 3.6 | 10 | 21,927 | 17.00% | 1,623 | 224 | 99 | 0.6 | 1.7 |
326 | 326 | West Virginia | CBSA | Hagerstown-Martinsburg, West Virginia | 2 | 236 | 85 | 129,120 | 9,555 | 1,319 | 583 | 8.1 | 22.4 | 27,029 | 20.90% | 2,000 | 276 | 122 | 1.7 | 4.7 |
366 | 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 |
321 | 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 |
249 | 249 | Michigan | CBSA | Battle Creek, Michigan | 3 | 301 | 108 | 134,327.00 | 9,940 | 1,372 | 606 | 6.6 | 18.3 | 31,227.00 | 23.20% | 2,311 | 319 | 141 | 1.5 | 4.3 |
226 | 226 | Kansas | CBSA | Manhattan, Kansas | 5 | 326 | 117 | 134,680 | 9,966 | 1,375 | 608 | 6.1 | 16.9 | 16,988 | 12.60% | 1,257 | 173 | 77 | 0.8 | 2.1 |
45 | 45 | South Dakota | CBSA | Rapid City, South Dakota | 5 | 605 | 218 | 135,192 | 10,004 | 1,381 | 610 | 3.3 | 9.1 | 29,786 | 22.00% | 2,204 | 304 | 134 | 0.7 | 2 |
279 | 279 | Ohio | CBSA | Springfield, Ohio | 2 | 283 | 102 | 135,520 | 10,028 | 1,384 | 612 | 7.1 | 19.6 | 33,970 | 25.10% | 2,514 | 347 | 153 | 1.8 | 4.9 |
44 | 44 | Pennsylvania | CBSA | Johnstown, Pennsylvania | 3 | 608 | 219 | 135,871.00 | 10,054 | 1,388 | 613 | 3.3 | 9.1 | 39,200.00 | 28.90% | 2,901 | 400 | 177 | 0.9 | 2.6 |
5 | 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 |
402 | 402 | Pennsylvania | CBSA | Lebanon, Pennsylvania | 1 | 151 | 54 | 137,616.00 | 10,184 | 1,405 | 621 | 13.4 | 37.5 | 34,280.00 | 24.90% | 2,537 | 350 | 155 | 3.3 | 9.4 |
311 | 311 | Utah | CBSA | St George, Utah | 1 | 263 | 95 | 138,115 | 10,221 | 1,410 | 623 | 7.7 | 21.4 | 0 | ||||||
201 | 201 | Idaho | CBSA | Coeur dAlene, Idaho | 3 | 362 | 130 | 138,494 | 10,249 | 1,414 | 625 | 5.6 | 15.7 | 0 | ||||||
219 | 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 |
388 | 388 | Tennessee | CBSA | Morristown, Tennessee | 2 | 185 | 67 | 139,294 | 10,308 | 1,422 | 629 | 11.1 | 30.6 | 34,544 | 24.80% | 2,556 | 353 | 156 | 2.7 | 7.6 |
160 | 160 | Illinois | CBSA | Carbondale-Marion, Illinois | 4 | 398 | 143 | 139,491 | 10,322 | 1,424 | 630 | 5.2 | 14.4 | 30,856 | 22.10% | 2,283 | 315 | 139 | 1.1 | 3.2 |
194 | 194 | South Dakota | CBSA | Sioux City, South Dakota | 1 | 40 | 14 | 14,929 | 1,105 | 152 | 67 | 5.5 | 15.6 | 3,448 | 23.10% | 255 | 35 | 16 | 1.3 | 3.6 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [CoronavirusHospitalCapacity_metros] ( [State] TEXT, [Geography_Type] TEXT, [Metro] TEXT, [Hospitals] INTEGER, [Total Beds] TEXT, [Estimated available beds (36% of total)] INTEGER, [Population_allages] TEXT, [Infected_allages] TEXT, [Severe_allages] TEXT, [Critical_allages] TEXT, [PatientsPerBed_allages] TEXT, [PatientsPerAvailableBed_allages] TEXT, [Population_60plus] TEXT, [60plus_PercentOfTotalPopulation] TEXT, [Infected_60plus] TEXT, [Severe_60plus] TEXT, [Critical_60plus] TEXT, [PatientsPerBed_60plus] TEXT, [PatientsPerAvailableBed_60plus] TEXT );