CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Infected_60plus descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
302 | 302 | Washington | CBSA | Walla Walla, Washington | 2 | 117 | 42 | 59,862 | 4,430 | 611 | 270 | 7.5 | 21 | 13,443 | 22.50% | 995 | 137 | 61 | 1.7 | 4.7 |
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 |
417 | 417 | Arkansas | CBSA | Texarkana, Arkansas | 1 | 25 | 9 | 56,254 | 4,163 | 574 | 254 | 33.1 | 92 | 13,063 | 23.20% | 967 | 133 | 59 | 7.7 | 21.3 |
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 |
190 | 190 | Florida | CBSA | Naples-Marco Island, Florida | 3 | 956 | 344 | 356,774.00 | 26,401 | 3,643 | 1,610 | 5.5 | 15.3 | 132,129.00 | 37.00% | 9,778 | 1,349 | 596 | 2 | 5.7 |
324 | 324 | California | CBSA | Bakersfield, California | 11 | 1,617 | 582 | 878,744 | 65,027 | 8,974 | 3,967 | 8 | 22.2 | 130,831 | 14.90% | 9,681 | 1,336 | 591 | 1.2 | 3.3 |
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 |
242 | 242 | Maine | CBSA | Portland-South Portland, Maine | 7 | 1,200 | 432 | 525,776 | 38,907 | 5,369 | 2,373 | 6.5 | 17.9 | 130,042 | 24.70% | 9,623 | 1,328 | 587 | 1.6 | 4.4 |
282 | 282 | Idaho | CBSA | Boise City, Idaho | 9 | 1,405 | 506 | 677,346 | 50,124 | 6,917 | 3,058 | 7.1 | 19.7 | 127,603 | 18.80% | 9,443 | 1,303 | 576 | 1.3 | 3.7 |
161 | 161 | North Carolina | CBSA | Asheville, North Carolina | 6 | 1,267 | 456 | 445625 | 32,976 | 4,551 | 2,012 | 5.2 | 14.4 | 125064 | 28.10% | 9,255 | 1,277 | 565 | 1.5 | 4 |
137 | 137 | Kansas | CBSA | Wichita, Kansas | 16 | 1,898 | 683 | 634,763 | 46,972 | 6,482 | 2,865 | 4.9 | 13.7 | 125,055 | 19.70% | 9,254 | 1,277 | 564 | 1 | 2.7 |
352 | 352 | California | CBSA | Santa Rosa-Petaluma, California | 8 | 821 | 296 | 500,943 | 37,070 | 5,116 | 2,261 | 9 | 24.9 | 124,291 | 24.80% | 9,198 | 1,269 | 561 | 2.2 | 6.2 |
319 | 319 | Massachusetts | CBSA | Providence-Warwick, Massachusetts | 5 | 1,032 | 372 | 557,016 | 41,219 | 5,688 | 2,514 | 7.9 | 22 | 124,173 | 22.30% | 9,189 | 1,268 | 561 | 1.8 | 4.9 |
375 | 375 | California | CBSA | Stockton, California | 7 | 1,077 | 388 | 724,153 | 53,587 | 7,395 | 3,269 | 9.9 | 27.5 | 123,774 | 17.10% | 9,159 | 1,264 | 559 | 1.7 | 4.7 |
365 | 365 | Colorado | CBSA | Colorado Springs, Colorado | 5 | 1,069 | 385 | 698,595 | 51,696 | 7,134 | 3,153 | 9.6 | 26.7 | 122,967 | 17.60% | 9,100 | 1,256 | 555 | 1.7 | 4.7 |
315 | 315 | Pennsylvania | CBSA | Lancaster, Pennsylvania | 5 | 1,007 | 363 | 536,494.00 | 39,701 | 5,479 | 2,422 | 7.8 | 21.8 | 122,633.00 | 22.90% | 9,075 | 1,252 | 554 | 1.8 | 5 |
200 | 200 | Wisconsin | CBSA | Madison, Wisconsin | 11 | 1,681 | 605 | 640,072.00 | 47,365 | 6,536 | 2,889 | 5.6 | 15.6 | 122,030.00 | 19.10% | 9,030 | 1,246 | 551 | 1.1 | 3 |
416 | 416 | West Virginia | CBSA | Washington-Arlington-Alexandria, West Virginia | 1 | 25 | 9 | 55,673 | 4,120 | 569 | 251 | 32.8 | 91.1 | 11,916 | 21.40% | 882 | 122 | 54 | 7 | 19.6 |
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 |
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 |
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 |
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 |
205 | 205 | Texas | CBSA | McAllen-Edinburg-Mission, Texas | 8 | 2,187 | 787 | 839,539 | 62,126 | 8,573 | 3,790 | 5.7 | 15.7 | 119,536 | 14.20% | 8,846 | 1,221 | 540 | 0.8 | 2.2 |
306 | 306 | Florida | CBSA | Ocala, Florida | 4 | 661 | 238 | 343,778.00 | 25,440 | 3,511 | 1,552 | 7.7 | 21.3 | 119,425.00 | 34.70% | 8,837 | 1,220 | 539 | 2.7 | 7.4 |
144 | 144 | Washington | CBSA | Spokane-Spokane Valley, Washington | 9 | 1,578 | 568 | 534,622 | 39,562 | 5,460 | 2,413 | 5 | 13.9 | 118,253 | 22.10% | 8,751 | 1,208 | 534 | 1.1 | 3.1 |
165 | 165 | Ohio | CBSA | Youngstown-Warren-Boardman, Ohio | 9 | 1,235 | 445 | 435,198 | 32,205 | 4,444 | 1,964 | 5.2 | 14.4 | 117,766 | 27.10% | 8,715 | 1,203 | 532 | 1.4 | 3.9 |
34 | 34 | District of Columbia | CBSA | Washington-Arlington-Alexandria, District of Columbia | 10 | 3,114 | 1121 | 672,391 | 49,757 | 6,866 | 3,035 | 3.2 | 8.8 | 113,026 | 16.80% | 8,364 | 1,154 | 510 | 0.5 | 1.5 |
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 |
253 | 253 | Michigan | CBSA | Lansing-East Lansing, Michigan | 7 | 1203 | 433 | 540,709.00 | 40,012 | 5,522 | 2,441 | 6.6 | 18.4 | 110,858.00 | 20.50% | 8,203 | 1,132 | 500 | 1.4 | 3.8 |
357 | 357 | Alabama | CBSA | Columbus, Alabama | 2 | 93 | 33 | 58,480 | 4,328 | 597 | 264 | 9.3 | 26.1 | 10,680 | 18.30% | 790 | 109 | 48 | 1.7 | 4.8 |
424 | 424 | Texas | CBSA | Dallas-Fort Worth-Arlington, Texas | 1 | 10 | 4 | 7,040,347 | 520,986 | 71,896 | 31,780 | 10367.6 | 25919 | 1,078,937 | 15.30% | 79,841 | 11,018 | 4,870 | 1588.8 | 3972 |
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 |
129 | 129 | Idaho | CBSA | Lewiston, Idaho | 1 | 123 | 44 | 40,014 | 2,961 | 409 | 181 | 4.8 | 13.4 | 10,185 | 25.50% | 754 | 104 | 46 | 1.2 | 3.4 |
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 |
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 |
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 |
163 | 163 | Florida | CBSA | Pensacola-Ferry Pass-Brent, Florida | 7 | 1,348 | 485 | 476,702.00 | 35,276 | 4,868 | 2,152 | 5.2 | 14.5 | 102,496.00 | 21.50% | 7,585 | 1,047 | 463 | 1.1 | 3.1 |
174 | 174 | Ohio | CBSA | Canton-Massillon, Ohio | 5 | 1,118 | 402 | 402,098 | 29,755 | 4,106 | 1,815 | 5.3 | 14.7 | 101,911 | 25.30% | 7,541 | 1,041 | 460 | 1.3 | 3.7 |
265 | 265 | Pennsylvania | CBSA | York-Hanover, Pennsylvania | 6 | 958 | 345 | 442,216.00 | 32,724 | 4,516 | 1,996 | 6.8 | 18.9 | 99,386.00 | 22.50% | 7,355 | 1,015 | 449 | 1.5 | 4.2 |
169 | 169 | Nevada | CBSA | Reno, Nevada | 7 | 1,260 | 454 | 449,442 | 33,259 | 4,590 | 2,029 | 5.3 | 14.6 | 97,068 | 21.60% | 7,183 | 991 | 438 | 1.1 | 3.1 |
110 | 110 | Missouri | CBSA | Springfield, Missouri | 5 | 1,501 | 540 | 455,133 | 33,680 | 4,648 | 2,054 | 4.5 | 12.4 | 97,033 | 21.30% | 7,180 | 991 | 438 | 1 | 2.6 |
108 | 108 | Illinois | CBSA | Peoria, Illinois | 8 | 1,357 | 489 | 412,991 | 30,561 | 4,217 | 1,864 | 4.5 | 12.4 | 96,172 | 23.30% | 7,117 | 982 | 434 | 1 | 2.9 |
386 | 386 | Washington | CBSA | Portland-Vancouver-Hillsboro, Washington | 2 | 647 | 233 | 468,972 | 34,704 | 4,789 | 2,117 | 10.7 | 29.6 | 96,088 | 20.50% | 7,111 | 981 | 434 | 2.2 | 6.1 |
336 | 336 | Utah | CBSA | Ogden-Clearfield, Utah | 9 | 1,108 | 399 | 642,274 | 47,528 | 6,559 | 2,899 | 8.5 | 23.7 | 95,645 | 14.90% | 7,078 | 977 | 432 | 1.3 | 3.5 |
317 | 317 | Georgia | CBSA | Atlanta-Sandy Springs-Alpharetta, Georgia | 44 | 10,632 | 3828 | 5,700,990 | 421,873 | 58,219 | 25,734 | 7.9 | 21.9 | 933,559 | 16.40% | 69,083 | 9,534 | 4,214 | 1.3 | 3.6 |
298 | 298 | Arizona | CBSA | Phoenix-Mesa-Chandler, Arizona | 46 | 9104 | 3277 | 4,561,038.00 | 337,517 | 46,577 | 20,589 | 7.4 | 20.5 | 908,620.00 | 19.90% | 67,238 | 9,279 | 4,102 | 1.5 | 4.1 |
39 | 39 | Kentucky | CBSA | Lexington-Fayette, Kentucky | 11 | 2,269 | 817 | 500,689 | 37,051 | 5,113 | 2,260 | 3.2 | 9 | 93,464 | 18.70% | 6,916 | 954 | 422 | 0.6 | 1.7 |
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 |
203 | 203 | Pennsylvania | CBSA | Reading, Pennsylvania | 5 | 1,080 | 389 | 415,500.00 | 30,747 | 4,243 | 1,876 | 5.7 | 15.7 | 93,051.00 | 22.40% | 6,886 | 950 | 420 | 1.3 | 3.5 |
281 | 281 | California | CBSA | Modesto, California | 6 | 1,113 | 401 | 535,684 | 39,641 | 5,470 | 2,418 | 7.1 | 19.7 | 92,698 | 17.30% | 6,860 | 947 | 418 | 1.2 | 3.4 |
105 | 105 | Alabama | CBSA | Mobile, Alabama | 7 | 1,458 | 525 | 431,074 | 31,899 | 4,402 | 1,946 | 4.4 | 12.1 | 92,206 | 21.40% | 6,823 | 942 | 416 | 0.9 | 2.6 |
149 | 149 | Louisiana | CBSA | Lafayette, Louisiana | 18 | 1,415 | 509 | 487,633 | 36,085 | 4,980 | 2,201 | 5.1 | 14.1 | 90,414 | 18.50% | 6,691 | 923 | 408 | 0.9 | 2.6 |
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 |
147 | 147 | South Carolina | CBSA | Myrtle Beach-Conway-North Myrtle Beach, South Carolina | 4 | 906 | 326 | 310,186 | 22,954 | 3,168 | 1,400 | 5 | 14 | 90,290 | 29.10% | 6,681 | 922 | 408 | 1.5 | 4.1 |
362 | 362 | California | CBSA | Vallejo, California | 4 | 672 | 242 | 434,981 | 32,189 | 4,442 | 1,964 | 9.5 | 26.5 | 90,069 | 20.70% | 6,665 | 920 | 407 | 2 | 5.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 |
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 |
391 | 391 | Oregon | CBSA | Salem, Oregon | 4 | 534 | 192 | 410,119 | 30,349 | 4,188 | 1,851 | 11.3 | 31.5 | 87,239 | 21.30% | 6,456 | 891 | 394 | 2.4 | 6.7 |
304 | 304 | California | CBSA | Santa Maria-Santa Barbara, California | 5 | 858 | 309 | 442,996 | 32,782 | 4,524 | 2,000 | 7.6 | 21.1 | 86,816 | 19.60% | 6,424 | 887 | 392 | 1.5 | 4.1 |
381 | 381 | Arizona | CBSA | Prescott Valley-Prescott, Arizona | 3 | 320 | 115 | 220,972.00 | 16,352 | 2,257 | 997 | 10.2 | 28.3 | 85,127.00 | 38.50% | 6,299 | 869 | 384 | 3.9 | 10.9 |
74 | 74 | Louisiana | CBSA | Shreveport-Bossier City, Louisiana | 10 | 1,573 | 566 | 403,931 | 29,891 | 4,125 | 1,823 | 3.8 | 10.5 | 84,575 | 20.90% | 6,259 | 864 | 382 | 0.8 | 2.2 |
283 | 283 | New Hampshire | CBSA | Manchester-Nashua, New Hampshire | 5 | 841 | 303 | 406,371 | 30,071 | 4,150 | 1,834 | 7.1 | 19.7 | 84,563 | 20.80% | 6,258 | 864 | 382 | 1.5 | 4.1 |
269 | 269 | Kentucky | CBSA | Cincinnati, Kentucky | 7 | 941 | 339 | 439,785 | 32,544 | 4,491 | 1,985 | 6.9 | 19.1 | 84,358 | 19.20% | 6,242 | 861 | 381 | 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 |
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 |
72 | 72 | Florida | CBSA | Punta Gorda, Florida | 3 | 681 | 245 | 173,236.00 | 12,819 | 1,769 | 782 | 3.7 | 10.4 | 81,236.00 | 46.90% | 6,011 | 830 | 367 | 1.8 | 4.9 |
83 | 83 | Virginia | CBSA | Roanoke, Virginia | 3 | 1,182 | 426 | 313,069.00 | 23,167 | 3,197 | 1,413 | 3.9 | 10.8 | 81,216.00 | 25.90% | 6,010 | 829 | 367 | 1 | 2.8 |
152 | 152 | Texas | CBSA | Corpus Christi, Texas | 6 | 1,239 | 446 | 425,351 | 31,476 | 4,344 | 1,920 | 5.1 | 14 | 81,128 | 19.10% | 6,003 | 828 | 366 | 1 | 2.7 |
340 | 340 | California | CBSA | Riverside-San Bernardino-Ontario, California | 38 | 7,640 | 2750 | 4,476,222 | 331,240 | 45,711 | 20,206 | 8.6 | 24 | 767,628 | 17.10% | 56,804 | 7,839 | 3,465 | 1.5 | 4.1 |
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 |
405 | 405 | West Virginia | CBSA | Cumberland, West Virginia | 1 | 25 | 9 | 27,421 | 2,029 | 280 | 124 | 16.2 | 44.9 | 7,414 | 27.00% | 549 | 76 | 33 | 4.4 | 12.1 |
316 | 316 | West Virginia | CBSA | Winchester, West Virginia | 1 | 44 | 16 | 23,412 | 1,732 | 239 | 106 | 7.8 | 21.6 | 6,811 | 29.10% | 504 | 70 | 31 | 2.3 | 6.3 |
305 | 305 | Massachusetts | CBSA | Barnstable Town, Massachusetts | 3 | 414 | 149 | 213,900 | 15,829 | 2,184 | 966 | 7.6 | 21.1 | 80,676 | 37.70% | 5,970 | 824 | 364 | 2.9 | 8 |
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 |
199 | 199 | Texas | CBSA | Beaumont-Port Arthur, Texas | 9 | 1,035 | 373 | 394,476 | 29,191 | 4,028 | 1,781 | 5.6 | 15.6 | 79,511 | 20.20% | 5,884 | 812 | 359 | 1.1 | 3.1 |
380 | 380 | South Carolina | CBSA | Charlotte-Concord-Gastonia, South Carolina | 4 | 541 | 195 | 370,632 | 27,427 | 3,785 | 1,673 | 10.1 | 28 | 79,346 | 21.40% | 5,872 | 810 | 358 | 2.2 | 6 |
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 |
338 | 338 | California | CBSA | Salinas, California | 4 | 740 | 266 | 433,168 | 32,054 | 4,424 | 1,955 | 8.6 | 24 | 76,257 | 17.60% | 5,643 | 779 | 344 | 1.5 | 4.2 |
61 | 61 | Georgia | CBSA | Augusta-Richmond County, Georgia | 8 | 1,645 | 592 | 397,192 | 29,392 | 4,056 | 1,793 | 3.6 | 9.9 | 75,957 | 19.10% | 5,621 | 776 | 343 | 0.7 | 1.9 |
212 | 212 | Illinois | CBSA | Rockford, Illinois | 4 | 864 | 311 | 341,150 | 25,245 | 3,484 | 1,540 | 5.8 | 16.2 | 75,762 | 22.20% | 5,606 | 774 | 342 | 1.3 | 3.6 |
293 | 293 | New Jersey | CBSA | Trenton-Princeton, New Jersey | 5 | 755 | 272 | 373,362 | 27,629 | 3,813 | 1,685 | 7.3 | 20.2 | 75,299 | 20.20% | 5,572 | 769 | 340 | 1.5 | 4.1 |
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 |
215 | 215 | Arizona | CBSA | Lake Havasu City-Kingman, Arizona | 4 | 512 | 184 | 204,691.00 | 15,147 | 2,090 | 924 | 5.9 | 16.4 | 73,559.00 | 35.90% | 5,443 | 751 | 332 | 2.1 | 5.9 |
140 | 140 | Alabama | CBSA | Montgomery, Alabama | 8 | 1,098 | 395 | 373,507 | 27,640 | 3,814 | 1,686 | 5 | 13.9 | 73,147 | 19.60% | 5,413 | 747 | 330 | 1 | 2.7 |
238 | 238 | New York | CBSA | Utica-Rome, New York | 4 | 687 | 247 | 295,267 | 21,850 | 3,015 | 1,333 | 6.3 | 17.6 | 72,494 | 24.60% | 5,365 | 740 | 327 | 1.6 | 4.3 |
399 | 399 | Delaware | CBSA | Salisbury, Delaware | 2 | 254 | 91 | 215,551 | 15,951 | 2,201 | 973 | 12.5 | 34.9 | 71,832 | 33.30% | 5,316 | 734 | 324 | 4.2 | 11.6 |
207 | 207 | Texas | CBSA | Brownsville-Harlingen, Texas | 6 | 1,081 | 389 | 420,201 | 31,095 | 4,291 | 1,897 | 5.7 | 15.9 | 71,392 | 17.00% | 5,283 | 729 | 322 | 1 | 2.7 |
46 | 46 | West Virginia | CBSA | Charleston, West Virginia | 7 | 1,210 | 436 | 270,328 | 20,004 | 2,761 | 1,220 | 3.3 | 9.1 | 70,827 | 26.20% | 5,241 | 723 | 320 | 0.9 | 2.4 |
274 | 274 | Florida | CBSA | Tallahassee, Florida | 4 | 798 | 287 | 377,674.00 | 27,948 | 3,857 | 1,705 | 7 | 19.4 | 70,580.00 | 18.70% | 5,223 | 721 | 319 | 1.3 | 3.6 |
383 | 383 | California | CBSA | San Luis Obispo-Paso Robles, California | 4 | 390 | 140 | 280,119 | 20,729 | 2,861 | 1,264 | 10.6 | 29.5 | 70,097 | 25.00% | 5,187 | 716 | 316 | 2.6 | 7.4 |
103 | 103 | Georgia | CBSA | Savannah, Georgia | 7 | 1,284 | 462 | 377,476 | 27,933 | 3,855 | 1,704 | 4.3 | 12 | 70,060 | 18.60% | 5,184 | 715 | 316 | 0.8 | 2.2 |
392 | 392 | California | CBSA | Visalia, California | 2 | 595 | 214 | 458,809 | 33,952 | 4,685 | 2,071 | 11.4 | 31.6 | 69,266 | 15.10% | 5,126 | 707 | 313 | 1.7 | 4.8 |
400 | 400 | Washington | CBSA | Lewiston, Washington | 1 | 25 | 9 | 22,259 | 1,647 | 227 | 100 | 13.1 | 36.3 | 6,373 | 28.60% | 472 | 65 | 29 | 3.8 | 10.4 |
121 | 121 | Pennsylvania | CBSA | Pittsburgh, Pennsylvania | 35 | 7,400 | 2664 | 2,348,143.00 | 173,763 | 23,979 | 10,600 | 4.7 | 13 | 608,340.00 | 25.90% | 45,017 | 6,212 | 2,746 | 1.2 | 3.4 |
328 | 328 | California | CBSA | San Diego-Chula Vista-Carlsbad, California | 18 | 5,750 | 2070 | 3,283,665 | 242,991 | 33,533 | 14,822 | 8.4 | 23.4 | 604,412 | 18.40% | 44,726 | 6,172 | 2,728 | 1.5 | 4.3 |
208 | 208 | Maryland | CBSA | Baltimore-Columbia-Towson, Maryland | 24 | 7,143 | 2571 | 2,792,050 | 206,612 | 28,512 | 12,603 | 5.8 | 16 | 572,610 | 20.50% | 42,373 | 5,847 | 2,585 | 1.2 | 3.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 |
40 | 40 | Michigan | CBSA | Ann Arbor, Michigan | 5 | 1,641 | 591 | 361,509.00 | 26,752 | 3,692 | 1,632 | 3.2 | 9 | 65,781.00 | 18.20% | 4,868 | 672 | 297 | 0.6 | 1.6 |
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 |
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 |
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 );