CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Metro
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
351 | 351 | Illinois | CBSA | Danville, Illinois | 2 | 130 | 47 | 79,207 | 5,861 | 809 | 358 | 9 | 24.8 | 19,371 | 24.50% | 1,433 | 198 | 87 | 2.2 | 6.1 |
377 | 377 | Alabama | CBSA | Daphne-Fairhope-Foley, Alabama | 3 | 298 | 107 | 203,360 | 15,049 | 2,077 | 918 | 10 | 28 | 53,519 | 26.30% | 3,960 | 547 | 242 | 2.6 | 7.4 |
184 | 184 | Illinois | CBSA | Davenport-Moline-Rock Island, Illinois | 5 | 578 | 208 | 211,648 | 15,662 | 2,161 | 955 | 5.4 | 15 | 53,321 | 25.20% | 3,946 | 545 | 241 | 1.4 | 3.8 |
141 | 141 | Iowa | CBSA | Davenport-Moline-Rock Island, Iowa | 3 | 504 | 181 | 171,493 | 12,690 | 1,751 | 774 | 5 | 14 | 36,851 | 21.50% | 2,727 | 376 | 166 | 1.1 | 3 |
216 | 216 | Ohio | CBSA | Dayton-Kettering, Ohio | 11 | 1,994 | 718 | 800,893 | 59,266 | 8,179 | 3,615 | 5.9 | 16.4 | 186,578 | 23.30% | 13,807 | 1,905 | 842 | 1.4 | 3.8 |
403 | 403 | Alabama | CBSA | Decatur, Alabama | 2 | 153 | 55 | 152,445 | 11,281 | 1,557 | 688 | 14.7 | 40.8 | 34,449 | 22.60% | 2,549 | 352 | 156 | 3.3 | 9.2 |
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 |
220 | 220 | Florida | CBSA | Deltona-Daytona Beach-Ormond Beach, Florida | 6 | 1,537 | 553 | 623,675.00 | 46,152 | 6,369 | 2,815 | 6 | 16.6 | 199,527.00 | 32.00% | 14,765 | 2,038 | 901 | 1.9 | 5.3 |
300 | 300 | Colorado | CBSA | Denver-Aurora-Lakewood, Colorado | 26 | 5,527 | 1990 | 2,798,684 | 207,103 | 28,580 | 12,633 | 7.5 | 20.7 | 491,072 | 17.50% | 36,339 | 5,015 | 2,217 | 1.3 | 3.6 |
221 | 221 | Iowa | CBSA | Des Moines-West Des Moines, Iowa | 9 | 1,625 | 585 | 659,902 | 48,833 | 6,739 | 2,979 | 6 | 16.6 | 120,848 | 18.30% | 8,943 | 1,234 | 546 | 1.1 | 3 |
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 |
47 | 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 | ||||||
18 | 18 | Alabama | CBSA | Dothan, Alabama | 5 | 770 | 277 | 147,790 | 10,936 | 1,509 | 667 | 2.8 | 7.9 | 35,024 | 23.70% | 2,592 | 358 | 158 | 0.7 | 1.9 |
266 | 266 | Delaware | CBSA | Dover, Delaware | 1 | 374 | 135 | 173,145 | 12,813 | 1,768 | 782 | 6.8 | 18.9 | 36,849 | 21.30% | 2,727 | 376 | 166 | 1.5 | 4 |
84 | 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 |
29 | 29 | Minnesota | CBSA | Duluth, Minnesota | 11 | 1,178 | 424 | 246,280 | 18,225 | 2,515 | 1,112 | 3.1 | 8.6 | 62,088 | 25.20% | 4,595 | 634 | 280 | 0.8 | 2.2 |
414 | 414 | Wisconsin | CBSA | Duluth, Wisconsin | 1 | 25 | 9 | 43,503.00 | 3,219 | 444 | 196 | 25.6 | 71.1 | 10,444.00 | 24.00% | 773 | 107 | 47 | 6.2 | 17.1 |
68 | 68 | North Carolina | CBSA | Durham-Chapel Hill, North Carolina | 8 | 2,425 | 873 | 608784 | 45,050 | 6,217 | 2,748 | 3.7 | 10.3 | 121204 | 19.90% | 8,969 | 1,238 | 547 | 0.7 | 2 |
301 | 301 | Pennsylvania | CBSA | East Stroudsburg, Pennsylvania | 2 | 329 | 118 | 167,306.00 | 12,381 | 1,709 | 755 | 7.5 | 20.9 | 37,614.00 | 22.50% | 2,783 | 384 | 170 | 1.7 | 4.7 |
107 | 107 | Wisconsin | CBSA | Eau Claire, Wisconsin | 6 | 554 | 199 | 165,833.00 | 12,272 | 1,693 | 749 | 4.4 | 12.3 | 35,231.00 | 21.20% | 2,607 | 360 | 159 | 0.9 | 2.6 |
374 | 374 | California | CBSA | El Centro, California | 2 | 268 | 96 | 179,957 | 13,317 | 1,838 | 812 | 9.9 | 27.6 | 30,768 | 17.10% | 2,277 | 314 | 139 | 1.7 | 4.7 |
245 | 245 | Texas | CBSA | El Paso, Texas | 12 | 1,897 | 683 | 838,527 | 62,051 | 8,563 | 3,785 | 6.5 | 18.1 | 133,833 | 16.00% | 9,904 | 1,367 | 604 | 1 | 2.9 |
426 | 426 | Illinois | No clean match | Elgin, Illinois | 7 | 1,065 | No clean match | |||||||||||||
289 | 289 | Kentucky | CBSA | Elizabethtown-Fort Knox, Kentucky | 2 | 308 | 111 | 150,253 | 11,119 | 1,534 | 678 | 7.2 | 19.9 | 27,818 | 18.50% | 2,059 | 284 | 126 | 1.3 | 3.7 |
334 | 334 | Indiana | CBSA | Elkhart-Goshen, Indiana | 2 | 352 | 127 | 202,924 | 15,016 | 2,072 | 916 | 8.5 | 23.5 | 38,669 | 19.10% | 2,862 | 395 | 175 | 1.6 | 4.5 |
33 | 33 | New York | CBSA | Elmira, New York | 2 | 407 | 147 | 86,883 | 6,429 | 887 | 392 | 3.1 | 8.7 | 21,007 | 24.20% | 1,555 | 215 | 95 | 0.8 | 2.1 |
30 | 30 | Oklahoma | CBSA | Enid, Oklahoma | 3 | 300 | 108 | 62,421 | 4,619 | 637 | 282 | 3.1 | 8.5 | 13,092 | 21.00% | 969 | 134 | 59 | 0.6 | 1.8 |
99 | 99 | Pennsylvania | CBSA | Erie, Pennsylvania | 6 | 967 | 348 | 277,794.00 | 20,557 | 2,837 | 1,254 | 4.2 | 11.8 | 63,334.00 | 22.80% | 4,687 | 647 | 286 | 1 | 2.7 |
342 | 342 | Oregon | CBSA | Eugene-Springfield, Oregon | 5 | 619 | 223 | 363,471 | 26,897 | 3,712 | 1,641 | 8.6 | 24 | 90,330 | 24.90% | 6,684 | 922 | 408 | 2.1 | 6 |
26 | 26 | Indiana | CBSA | Evansville, Indiana | 7 | 1,302 | 469 | 269,011 | 19,907 | 2,747 | 1,214 | 3 | 8.4 | 60,428 | 22.50% | 4,472 | 617 | 273 | 0.7 | 1.9 |
202 | 202 | Kentucky | CBSA | Evansville, Kentucky | 1 | 121 | 44 | 46,252 | 3,423 | 472 | 209 | 5.6 | 15.5 | 10,871 | 23.50% | 804 | 111 | 49 | 1.3 | 3.6 |
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 |
60 | 60 | North Dakota | CBSA | Fargo, North Dakota | 3 | 708 | 255 | 170,620 | 12,626 | 1,742 | 770 | 3.5 | 9.9 | 27,710 | 16.20% | 2,051 | 283 | 125 | 0.6 | 1.6 |
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 |
378 | 378 | North Carolina | CBSA | Fayetteville, North Carolina | 3 | 754 | 271 | 514090 | 38,043 | 5,250 | 2,321 | 10 | 27.9 | 80286 | 15.60% | 5,941 | 820 | 362 | 1.6 | 4.4 |
240 | 240 | Arkansas | CBSA | Fayetteville-Springdale-Rogers, Arkansas | 9 | 1,135 | 409 | 491,413 | 36,365 | 5,018 | 2,218 | 6.4 | 17.7 | 83,204 | 16.90% | 6,157 | 850 | 376 | 1.1 | 3 |
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 |
133 | 133 | Michigan | CBSA | Flint, Michigan | 4 | 1,242 | 447 | 410,881.00 | 30,405 | 4,196 | 1,855 | 4.9 | 13.5 | 93,094.00 | 22.70% | 6,889 | 951 | 420 | 1.1 | 3.1 |
17 | 17 | South Carolina | CBSA | Florence, South Carolina | 7 | 1,098 | 395 | 206,109 | 15,252 | 2,105 | 930 | 2.8 | 7.7 | 46,691 | 22.70% | 3,455 | 477 | 211 | 0.6 | 1.7 |
62 | 62 | Alabama | CBSA | Florence-Muscle Shoals, Alabama | 3 | 601 | 216 | 147,025 | 10,880 | 1,501 | 664 | 3.6 | 10 | 37,514 | 25.50% | 2,776 | 383 | 169 | 0.9 | 2.6 |
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 |
312 | 312 | Colorado | CBSA | Fort Collins, Colorado | 5 | 627 | 226 | 330,976 | 24,492 | 3,380 | 1,494 | 7.8 | 21.6 | 67,199 | 20.30% | 4,973 | 686 | 303 | 1.6 | 4.4 |
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 | ||||||
82 | 82 | Arkansas | CBSA | Fort Smith, Arkansas | 6 | 782 | 282 | 207,284 | 15,339 | 2,117 | 936 | 3.9 | 10.8 | 45,036 | 21.70% | 3,333 | 460 | 203 | 0.8 | 2.4 |
347 | 347 | Oklahoma | CBSA | Fort Smith, Oklahoma | 2 | 69 | 25 | 41,364 | 3,061 | 422 | 187 | 8.8 | 24.4 | 9,667 | 23.40% | 715 | 99 | 44 | 2.1 | 5.7 |
59 | 59 | Indiana | CBSA | Fort Wayne, Indiana | 10 | 1,697 | 611 | 401,228 | 29,691 | 4,097 | 1,811 | 3.5 | 9.7 | 79,036 | 19.70% | 5,849 | 807 | 357 | 0.7 | 1.9 |
444 | 444 | Texas | No clean match | Fort Worth-Arlington-Grapevine, Texas | 40 | 5,595 | No clean match | |||||||||||||
429 | 429 | Maryland | No clean match | Frederick-Gaithersburg-Rockville, Maryland | 8 | 1,905 | No clean match | |||||||||||||
331 | 331 | California | CBSA | Fresno, California | 8 | 1,692 | 609 | 971,616 | 71,900 | 9,922 | 4,386 | 8.5 | 23.5 | 157,757 | 16.20% | 11,674 | 1,611 | 712 | 1.4 | 3.8 |
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 |
25 | 25 | Florida | CBSA | Gainesville, Florida | 4 | 1,548 | 557 | 316,769.00 | 23,441 | 3,235 | 1,430 | 3 | 8.4 | 64,742.00 | 20.40% | 4,791 | 661 | 292 | 0.6 | 1.7 |
38 | 38 | Georgia | CBSA | Gainesville, Georgia | 1 | 887 | 319 | 192,865 | 14,272 | 1,970 | 871 | 3.2 | 8.9 | 36,793 | 19.10% | 2,723 | 376 | 166 | 0.6 | 1.7 |
428 | 428 | Indiana | No clean match | Gary, Indiana | 14 | 2,965 | No clean match | |||||||||||||
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 |
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 |
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 |
75 | 75 | Minnesota | CBSA | Grand Forks, Minnesota | 2 | 123 | 44 | 31,564 | 2,336 | 322 | 142 | 3.8 | 10.5 | 7,554 | 23.90% | 559 | 77 | 34 | 0.9 | 2.5 |
20 | 20 | North Dakota | CBSA | Grand Forks, North Dakota | 2 | 362 | 130 | 70,130 | 5,190 | 716 | 317 | 2.9 | 7.9 | 11,680 | 16.70% | 864 | 119 | 53 | 0.5 | 1.3 |
95 | 95 | Nebraska | CBSA | Grand Island, Nebraska | 4 | 267 | 96 | 75,447 | 5,583 | 770 | 341 | 4.2 | 11.6 | 15,817 | 21.00% | 1,170 | 162 | 71 | 0.9 | 2.4 |
176 | 176 | Colorado | CBSA | Grand Junction, Colorado | 3 | 412 | 148 | 148,798 | 11,011 | 1,520 | 672 | 5.3 | 14.8 | 35,763 | 24.00% | 2,646 | 365 | 161 | 1.3 | 3.6 |
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 |
423 | 423 | Michigan | CBSA | Grand Rapids-Wyoming, Michigan | 1 | 39 | 14 | 988,938 | 73,181 | 10,099 | 4,464 | 373.4 | 1040.2 | |||||||
382 | 382 | Oregon | CBSA | Grants Pass, Oregon | 1 | 121 | 44 | 84,514 | 6,254 | 863 | 381 | 10.3 | 28.3 | 28,339 | 33.50% | 2,097 | 289 | 128 | 3.4 | 9.5 |
6 | 6 | Montana | CBSA | Great Falls, Montana | 2 | 522 | 188 | 81,816 | 6,054 | 836 | 369 | 2.3 | 6.4 | 19,330 | 23.60% | 1,430 | 197 | 87 | 0.5 | 1.5 |
401 | 401 | Colorado | CBSA | Greeley, Colorado | 3 | 316 | 114 | 285,729 | 21,144 | 2,918 | 1,290 | 13.3 | 36.9 | 48,279 | 16.90% | 3,573 | 493 | 218 | 2.2 | 6.2 |
256 | 256 | Wisconsin | CBSA | Green Bay, Wisconsin | 6 | 698 | 251 | 315,847.00 | 23,373 | 3,225 | 1,426 | 6.7 | 18.5 | 65,088.00 | 20.60% | 4,817 | 665 | 294 | 1.4 | 3.8 |
263 | 263 | North Carolina | CBSA | Greensboro-High Point, North Carolina | 6 | 1,636 | 589 | 751590 | 55,618 | 7,675 | 3,393 | 6.8 | 18.8 | 159515 | 21.20% | 11,804 | 1,629 | 720 | 1.4 | 4 |
11 | 11 | North Carolina | CBSA | Greenville, North Carolina | 1 | 974 | 351 | 176484 | 13,060 | 1,802 | 797 | 2.7 | 7.4 | 30269 | 17.20% | 2,240 | 309 | 137 | 0.5 | 1.3 |
231 | 231 | South Carolina | CBSA | Greenville-Anderson, South Carolina | 14 | 2,096 | 755 | 872,463 | 64,562 | 8,910 | 3,938 | 6.1 | 17 | 187,692 | 21.50% | 13,889 | 1,917 | 847 | 1.3 | 3.7 |
146 | 146 | Mississippi | CBSA | Gulfport-Biloxi, Mississippi | 8 | 1,191 | 429 | 406,063.00 | 30,049 | 4,147 | 1,833 | 5 | 13.9 | 83,387.00 | 20.50% | 6,171 | 852 | 376 | 1 | 2.9 |
318 | 318 | Maryland | CBSA | Hagerstown-Martinsburg, Maryland | 1 | 278 | 100 | 149,546 | 11,066 | 1,527 | 675 | 7.9 | 22 | 33,148 | 22.20% | 2,453 | 339 | 150 | 1.8 | 4.9 |
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 |
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 |
349 | 349 | California | CBSA | Hanford-Corcoran, California | 2 | 248 | 89 | 150,183 | 11,114 | 1,534 | 678 | 8.9 | 24.9 | 20,569 | 13.70% | 1,522 | 210 | 93 | 1.2 | 3.4 |
98 | 98 | Pennsylvania | CBSA | Harrisburg-Carlisle, Pennsylvania | 8 | 1,974 | 711 | 565,008.00 | 41,811 | 5,770 | 2,550 | 4.2 | 11.7 | 130,412.00 | 23.10% | 9,650 | 1,332 | 589 | 1 | 2.7 |
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 |
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 |
19 | 19 | Mississippi | CBSA | Hattiesburg, Mississippi | 4 | 873 | 314 | 167,571.00 | 12,400 | 1,711 | 756 | 2.8 | 7.9 | 31,999.00 | 19.10% | 2,368 | 327 | 144 | 0.5 | 1.5 |
278 | 278 | North Carolina | CBSA | Hickory-Lenoir-Morganton, North Carolina | 4 | 759 | 273 | 364,044 | 26,939 | 3,718 | 1,643 | 7.1 | 19.6 | 88,691 | 24.40% | 6,563 | 906 | 400 | 1.7 | 4.8 |
356 | 356 | South Carolina | CBSA | Hilton Head Island-Bluffton, South Carolina | 3 | 331 | 119 | 206,781 | 15,302 | 2,112 | 933 | 9.2 | 25.6 | 63,228 | 30.60% | 4,679 | 646 | 285 | 2.8 | 7.8 |
420 | 420 | Georgia | CBSA | Hinesville, Georgia | 1 | 25 | 9 | 79,977 | 5,918 | 817 | 361 | 47.1 | 130.9 | 9,845 | 12.30% | 729 | 101 | 44 | 5.8 | 16.1 |
235 | 235 | Florida | CBSA | Homosassa Springs, Florida | 2 | 332 | 120 | 141,373.00 | 10,462 | 1,444 | 638 | 6.3 | 17.4 | 61,636.00 | 43.60% | 4,561 | 629 | 278 | 2.7 | 7.6 |
36 | 36 | Arkansas | CBSA | Hot Springs, Arkansas | 3 | 449 | 162 | 97,994 | 7,252 | 1,001 | 442 | 3.2 | 8.9 | 28,731 | 29.30% | 2,126 | 293 | 130 | 0.9 | 2.6 |
186 | 186 | Louisiana | CBSA | Houma-Thibodaux, Louisiana | 7 | 577 | 208 | 211,179 | 15,627 | 2,157 | 953 | 5.4 | 15 | 40,792 | 19.30% | 3,019 | 417 | 184 | 1 | 2.9 |
229 | 229 | Texas | CBSA | Houston-The Woodlands-Sugar Land, Texas | 89 | 16,014 | 5765 | 6,636,208 | 491,079 | 67,769 | 29,956 | 6.1 | 17 | 1,011,707 | 15.20% | 74,866 | 10,332 | 4,567 | 0.9 | 2.6 |
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 |
422 | 422 | Ohio | CBSA | Huntington-Ashland, Ohio | 1 | 8 | 3 | 61,057 | 4,518 | 624 | 276 | 112.4 | 300 | 14,970 | 24.50% | 1,108 | 153 | 68 | 27.6 | 73.7 |
66 | 66 | West Virginia | CBSA | Huntington-Ashland, West Virginia | 4 | 786 | 283 | 193,807 | 14,342 | 1,979 | 875 | 3.6 | 10.1 | 47,104 | 24.30% | 3,486 | 481 | 213 | 0.9 | 2.5 |
158 | 158 | Alabama | CBSA | Huntsville, Alabama | 4 | 1,269 | 457 | 444,908 | 32,923 | 4,543 | 2,008 | 5.2 | 14.3 | 88,439 | 19.90% | 6,544 | 903 | 399 | 1 | 2.8 |
222 | 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 |
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 |
8 | 8 | Iowa | CBSA | Iowa City, Iowa | 3 | 1,038 | 374 | 166,520 | 12,322 | 1,701 | 752 | 2.4 | 6.6 | 27,038 | 16.20% | 2,001 | 276 | 122 | 0.4 | 1.1 |
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 |
167 | 167 | Michigan | CBSA | Jackson, Michigan | 2 | 448 | 161 | 158,989.00 | 11,765 | 1,624 | 718 | 5.2 | 14.5 | 36,118.00 | 22.70% | 2,673 | 369 | 163 | 1.2 | 3.3 |
43 | 43 | Mississippi | CBSA | Jackson, Mississippi | 16 | 2670 | 961 | 596,832.00 | 44,166 | 6,095 | 2,694 | 3.3 | 9.1 | 112,915.00 | 18.90% | 8,356 | 1,153 | 510 | 0.6 | 1.7 |
76 | 76 | Tennessee | CBSA | Jackson, Tennessee | 2 | 700 | 252 | 178,760 | 13,228 | 1,825 | 807 | 3.8 | 10.4 | 40,244 | 22.50% | 2,978 | 411 | 182 | 0.8 | 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 |
409 | 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 |
358 | 358 | Wisconsin | CBSA | Janesville-Beloit, Wisconsin | 3 | 256 | 92 | 161,226.00 | 11,931 | 1,646 | 728 | 9.3 | 25.8 | 34,912.00 | 21.70% | 2,583 | 357 | 158 | 2 | 5.6 |
354 | 354 | Missouri | CBSA | Jefferson City, Missouri | 3 | 243 | 87 | 151,056 | 11,178 | 1,543 | 682 | 9.2 | 25.6 | 32,282 | 21.40% | 2,389 | 330 | 146 | 2 | 5.5 |
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 );