CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by PatientsPerBed_60plus
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
35 | 35 | Virginia | CBSA | Lynchburg, Virginia | 3 | 1,200 | 432 | 258,995.00 | 19,166 | 2,645 | 1,169 | 3.2 | 8.8 | 62,730.00 | 24.20% | 4,642 | 641 | 283 | 0.8 | 2.1 |
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 |
48 | 48 | Maryland | CBSA | Cumberland, Maryland | 1 | 321 | 116 | 72,591 | 5,372 | 741 | 328 | 3.3 | 9.2 | 18,311 | 25.20% | 1,355 | 187 | 83 | 0.8 | 2.3 |
49 | 49 | Michigan | CBSA | Saginaw, Michigan | 3 | 853 | 307 | 193,803.00 | 14,341 | 1,979 | 875 | 3.3 | 9.3 | 47,390.00 | 24.50% | 3,507 | 484 | 214 | 0.8 | 2.3 |
51 | 51 | Tennessee | CBSA | Johnson City, Tennessee | 5 | 886 | 319 | 200,767 | 14,857 | 2,050 | 906 | 3.3 | 9.3 | 50,534 | 25.20% | 3,740 | 516 | 228 | 0.8 | 2.3 |
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 |
64 | 64 | Illinois | CBSA | Springfield, Illinois | 2 | 855 | 308 | 210,550 | 15,581 | 2,150 | 950 | 3.6 | 10.1 | 48,347 | 23.00% | 3,578 | 494 | 218 | 0.8 | 2.3 |
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 |
73 | 73 | Missouri | CBSA | Joplin, Missouri | 5 | 697 | 251 | 176,759 | 13,080 | 1,805 | 798 | 3.7 | 10.4 | 37,664 | 21.30% | 2,787 | 385 | 170 | 0.8 | 2.2 |
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 |
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 |
79 | 79 | Louisiana | CBSA | Lake Charles, Louisiana | 8 | 791 | 285 | 205,559 | 15,211 | 2,099 | 928 | 3.8 | 10.6 | 40,933 | 19.90% | 3,029 | 418 | 185 | 0.8 | 2.1 |
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 |
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 |
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 |
91 | 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 |
94 | 94 | Michigan | CBSA | Kalamazoo-Portage, Michigan | 4 | 921 | 332 | 259,830.00 | 19,227 | 2,653 | 1,173 | 4.2 | 11.5 | 51,450.00 | 19.80% | 3,807 | 525 | 232 | 0.8 | 2.3 |
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 |
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 |
124 | 124 | Illinois | CBSA | Champaign-Urbana, Illinois | 4 | 700 | 252 | 224,379 | 16,604 | 2,291 | 1,013 | 4.7 | 13.1 | 39,050 | 17.40% | 2,890 | 399 | 176 | 0.8 | 2.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 |
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 |
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 |
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 |
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 |
50 | 50 | Nevada | CBSA | Carson City, Nevada | 2 | 240 | 86 | 54,219 | 4,012 | 554 | 245 | 3.3 | 9.3 | 14,410 | 26.60% | 1,066 | 147 | 65 | 0.9 | 2.5 |
56 | 56 | Tennessee | CBSA | Kingsport-Bristol, Tennessee | 6 | 916 | 330 | 212,921 | 15,756 | 2,174 | 961 | 3.4 | 9.5 | 58,976 | 27.70% | 4,364 | 602 | 266 | 0.9 | 2.6 |
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 |
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 |
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 |
78 | 78 | Indiana | CBSA | Kokomo, Indiana | 3 | 318 | 114 | 82,457 | 6,102 | 842 | 372 | 3.8 | 10.6 | 20,461 | 24.80% | 1,514 | 209 | 92 | 0.9 | 2.6 |
80 | 80 | Ohio | CBSA | Cleveland-Elyria, Ohio | 31 | 7,853 | 2827 | 2,062,764 | 152,645 | 21,065 | 9,311 | 3.9 | 10.7 | 491,925 | 23.80% | 36,402 | 5,024 | 2,221 | 0.9 | 2.6 |
81 | 81 | Virginia | CBSA | Charlottesville, Virginia | 3 | 806 | 290 | 211,777.00 | 15,671 | 2,163 | 956 | 3.9 | 10.8 | 47,131.00 | 22.30% | 3,488 | 481 | 213 | 0.9 | 2.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 |
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 |
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 |
90 | 90 | Ohio | CBSA | Toledo, Ohio | 14 | 2,359 | 849 | 645,973 | 47,802 | 6,597 | 2,916 | 4 | 11.2 | 141,013 | 21.80% | 10,435 | 1,440 | 637 | 0.9 | 2.4 |
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 |
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 |
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 |
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 |
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 |
114 | 114 | Alabama | CBSA | Tuscaloosa, Alabama | 5 | 803 | 289 | 248,122 | 18,361 | 2,534 | 1,120 | 4.6 | 12.6 | 47,697 | 19.20% | 3,530 | 487 | 215 | 0.9 | 2.4 |
115 | 115 | Kansas | CBSA | Kansas City, Kansas | 19 | 2,793 | 1005 | 863,961 | 63,933 | 8,823 | 3,900 | 4.6 | 12.7 | 162,913 | 18.90% | 12,056 | 1,664 | 735 | 0.9 | 2.4 |
120 | 120 | Oklahoma | CBSA | Tulsa, Oklahoma | 26 | 3,111 | 1120 | 977,869 | 72,362 | 9,986 | 4,414 | 4.6 | 12.9 | 198,300 | 20.30% | 14,674 | 2,025 | 895 | 0.9 | 2.6 |
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 |
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 |
135 | 135 | California | CBSA | Madera, California | 2 | 464 | 167 | 154,440 | 11,429 | 1,577 | 697 | 4.9 | 13.6 | 28,392 | 18.40% | 2,101 | 290 | 128 | 0.9 | 2.5 |
145 | 145 | Louisiana | CBSA | Baton Rouge, Louisiana | 18 | 2,495 | 898 | 851,622 | 63,020 | 8,697 | 3,844 | 5 | 14 | 157,542 | 18.50% | 11,658 | 1,609 | 711 | 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 |
156 | 156 | Nebraska | CBSA | Omaha-Council Bluffs, Nebraska | 15 | 2,273 | 818 | 791,774 | 58,591 | 8,086 | 3,574 | 5.1 | 14.3 | 138,052 | 17.40% | 10,216 | 1,410 | 623 | 0.9 | 2.5 |
170 | 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 |
178 | 178 | Georgia | CBSA | Athens-Clarke County, Georgia | 3 | 561 | 202 | 202,780 | 15,006 | 2,071 | 915 | 5.3 | 14.8 | 35,109 | 17.30% | 2,598 | 359 | 158 | 0.9 | 2.6 |
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 |
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 |
239 | 239 | Texas | CBSA | Killeen-Temple, Texas | 6 | 1,008 | 363 | 432,797 | 32,027 | 4,420 | 1,954 | 6.3 | 17.6 | 62,605 | 14.50% | 4,633 | 639 | 283 | 0.9 | 2.5 |
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 |
275 | 275 | Texas | CBSA | Laredo, Texas | 4 | 569 | 205 | 269,624 | 19,952 | 2,753 | 1,217 | 7 | 19.4 | 34,315 | 12.70% | 2,539 | 350 | 155 | 0.9 | 2.5 |
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 |
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 |
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 |
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 |
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 |
100 | 100 | Pennsylvania | CBSA | Allentown-Bethlehem-Easton, Pennsylvania | 10 | 2,511 | 904 | 725,702.00 | 53,702 | 7,411 | 3,276 | 4.3 | 11.8 | 171,527.00 | 23.60% | 12,693 | 1,752 | 774 | 1 | 2.8 |
104 | 104 | Maine | CBSA | Bangor, Maine | 4 | 519 | 187 | 152,284 | 11,269 | 1,555 | 687 | 4.3 | 12 | 36,356 | 23.90% | 2,690 | 371 | 164 | 1 | 2.9 |
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 |
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 |
111 | 111 | Montana | CBSA | Billings, Montana | 5 | 576 | 207 | 176,140 | 13,034 | 1,799 | 795 | 4.5 | 12.5 | 41,033 | 23.30% | 3,036 | 419 | 185 | 1 | 2.9 |
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 |
116 | 116 | Michigan | CBSA | Midland, Michigan | 1 | 270 | 97 | 83,489.00 | 6,178 | 853 | 377 | 4.6 | 12.7 | 19,242.00 | 23.00% | 1,424 | 196 | 87 | 1 | 2.9 |
118 | 118 | Iowa | CBSA | Waterloo-Cedar Falls, Iowa | 6 | 546 | 197 | 170,055 | 12,584 | 1,737 | 768 | 4.6 | 12.7 | 37,828 | 22.20% | 2,799 | 386 | 171 | 1 | 2.8 |
119 | 119 | Georgia | CBSA | Albany, Georgia | 2 | 479 | 172 | 150,525 | 11,139 | 1,537 | 679 | 4.6 | 12.9 | 31,240 | 20.80% | 2,312 | 319 | 141 | 1 | 2.7 |
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 |
134 | 134 | Texas | CBSA | Wichita Falls, Texas | 6 | 456 | 164 | 150,940 | 11,170 | 1,541 | 681 | 4.9 | 13.5 | 30,983 | 20.50% | 2,293 | 316 | 140 | 1 | 2.8 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
168 | 168 | Florida | CBSA | Orlando-Kissimmee-Sanford, Florida | 14 | 6,665 | 2399 | 2,390,859.00 | 176,924 | 24,415 | 10,792 | 5.3 | 14.7 | 463,617.00 | 19.40% | 34,308 | 4,734 | 2,093 | 1 | 2.8 |
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 |
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 |
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 |
214 | 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 |
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 |
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 |
248 | 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 |
258 | 258 | Texas | CBSA | College Station-Bryan, Texas | 6 | 546 | 197 | 248,554 | 18,393 | 2,538 | 1,122 | 6.7 | 18.6 | 35,714 | 14.40% | 2,643 | 365 | 161 | 1 | 2.7 |
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 |
127 | 127 | New Jersey | CBSA | Atlantic City-Hammonton, New Jersey | 4 | 841 | 303 | 272,926 | 20,197 | 2,787 | 1,232 | 4.8 | 13.3 | 62,613 | 22.90% | 4,633 | 639 | 283 | 1.1 | 3 |
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 |
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 |
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 |
142 | 142 | New York | CBSA | Syracuse, New York | 6 | 1,943 | 699 | 659,262 | 48,785 | 6,732 | 2,976 | 5 | 13.9 | 145,821 | 22.10% | 10,791 | 1,489 | 658 | 1.1 | 3.1 |
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 |
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 |
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 );