CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Hospitals
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
97 | 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 |
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 |
122 | 122 | West Virginia | CBSA | Weirton-Steubenville, West Virginia | 1 | 167 | 60 | 52,988 | 3,921 | 541 | 239 | 4.7 | 13 | 15,450 | 29.20% | 1,143 | 158 | 70 | 1.4 | 3.8 |
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 |
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 |
164 | 164 | Indiana | CBSA | Columbus, Indiana | 1 | 229 | 82 | 81,024 | 5,996 | 827 | 366 | 5.2 | 14.5 | 16,862 | 20.80% | 1,248 | 172 | 76 | 1.1 | 3 |
175 | 175 | Arkansas | CBSA | Pine Bluff, Arkansas | 1 | 258 | 93 | 93,590 | 6,926 | 956 | 422 | 5.3 | 14.8 | 20,606 | 22.00% | 1,525 | 210 | 93 | 1.2 | 3.3 |
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 |
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 |
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 |
223 | 223 | Wyoming | CBSA | Cheyenne, Wyoming | 1 | 238 | 86 | 97,031 | 7,180 | 991 | 438 | 6 | 16.6 | 20,072 | 20.70% | 1,485 | 205 | 91 | 1.2 | 3.4 |
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 |
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 |
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 |
310 | 310 | Oregon | CBSA | Corvallis, Oregon | 1 | 168 | 60 | 88,249 | 6,530 | 901 | 398 | 7.7 | 21.7 | 18,413 | 20.90% | 1,363 | 188 | 83 | 1.6 | 4.5 |
311 | 311 | Utah | CBSA | St George, Utah | 1 | 263 | 95 | 138,115 | 10,221 | 1,410 | 623 | 7.7 | 21.4 | 0 | ||||||
314 | 314 | New Jersey | CBSA | Ocean City, New Jersey | 1 | 178 | 64 | 94,549 | 6,997 | 966 | 427 | 7.8 | 21.8 | 31,925 | 33.80% | 2,362 | 326 | 144 | 2.6 | 7.3 |
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 |
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 |
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 |
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 |
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 |
341 | 341 | Indiana | CBSA | Bloomington, Indiana | 1 | 282 | 102 | 165,393 | 12,239 | 1,689 | 747 | 8.6 | 23.9 | 29,188 | 17.60% | 2,160 | 298 | 132 | 1.5 | 4.2 |
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 |
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 |
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 |
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 |
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 |
376 | 376 | New Mexico | CBSA | Santa Fe, New Mexico | 1 | 219 | 79 | 147,514 | 10,916 | 1,506 | 666 | 9.9 | 27.5 | 42,681 | 28.90% | 3,158 | 436 | 193 | 2.9 | 8 |
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 |
396 | 396 | North Carolina | CBSA | Burlington, North Carolina | 1 | 197 | 71 | 157,844 | 11,680 | 1,612 | 713 | 11.8 | 32.7 | 35,388 | 22.40% | 2,619 | 361 | 160 | 2.6 | 7.3 |
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 |
398 | 398 | Washington | CBSA | Bellingham, Washington | 1 | 255 | 92 | 212,738 | 15,743 | 2,172 | 960 | 12.3 | 34 | 47,353 | 22.30% | 3,504 | 484 | 214 | 2.7 | 7.6 |
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 |
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 |
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 |
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 |
406 | 406 | Washington | CBSA | Bremerton-Silverdale-Port Orchard, Washington | 1 | 232 | 84 | 258,903 | 19,159 | 2,644 | 1,169 | 16.4 | 45.4 | 59,433 | 23.00% | 4,398 | 607 | 268 | 3.8 | 10.4 |
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 |
410 | 410 | Indiana | CBSA | Cincinnati, Indiana | 1 | 64 | 23 | 85,535 | 6,330 | 873 | 386 | 19.7 | 54.7 | 19,991 | 23.40% | 1,479 | 204 | 90 | 4.6 | 12.8 |
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 |
412 | 412 | Michigan | CBSA | Monroe, Michigan | 1 | 100 | 36 | 149,619.00 | 11,072 | 1,528 | 675 | 22 | 61.2 | 35,206.00 | 23.50% | 2,605 | 360 | 159 | 5.2 | 14.4 |
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 |
415 | 415 | Michigan | CBSA | South Bend-Mishawaka, Michigan | 1 | 25 | 9 | 51,397.00 | 3,803 | 525 | 232 | 30.3 | 84.1 | 13,966.00 | 27.20% | 1,033 | 143 | 63 | 8.2 | 22.9 |
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 |
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 |
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 |
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 |
421 | 421 | Georgia | CBSA | Chattanooga, Georgia | 1 | 35 | 13 | 150,761 | 11,156 | 1,540 | 681 | 63.4 | 170.8 | 35,414 | 23.50% | 2,621 | 362 | 160 | 14.9 | 40.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 |
423 | 423 | Michigan | CBSA | Grand Rapids-Wyoming, Michigan | 1 | 39 | 14 | 988,938 | 73,181 | 10,099 | 4,464 | 373.4 | 1040.2 | |||||||
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 |
430 | 430 | Maryland | No clean match | Wilmington, Maryland | 1 | 109 | No clean match | |||||||||||||
433 | 433 | Missouri | No clean match | St Joseph, Missouri | 1 | 352 | No clean match | |||||||||||||
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
131 | 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 |
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 |
148 | 148 | Colorado | CBSA | Pueblo, Colorado | 2 | 475 | 171 | 163,368 | 12,089 | 1,668 | 737 | 5.1 | 14.1 | 39,318 | 24.10% | 2,910 | 402 | 177 | 1.2 | 3.4 |
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 |
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 |
173 | 173 | North Carolina | CBSA | Wilmington, North Carolina | 2 | 772 | 278 | 277496 | 20,535 | 2,834 | 1,253 | 5.3 | 14.7 | 62601 | 22.60% | 4,632 | 639 | 283 | 1.2 | 3.3 |
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 |
192 | 192 | Ohio | CBSA | Wheeling, Ohio | 2 | 185 | 67 | 68,889 | 5,098 | 703 | 311 | 5.5 | 15.1 | 18,587 | 27.00% | 1,375 | 190 | 84 | 1.5 | 4.1 |
210 | 210 | Vermont | CBSA | Burlington-South Burlington, Vermont | 2 | 555 | 200 | 216,751 | 16,040 | 2,213 | 978 | 5.8 | 16 | 43,969 | 20.30% | 3,254 | 449 | 198 | 1.2 | 3.2 |
213 | 213 | New York | CBSA | Binghamton, New York | 2 | 618 | 222 | 245,446 | 18,163 | 2,506 | 1,108 | 5.8 | 16.3 | 60,335 | 24.60% | 4,465 | 616 | 272 | 1.4 | 4 |
225 | 225 | New Jersey | CBSA | Vineland-Bridgeton, New Jersey | 2 | 376 | 135 | 154,952 | 11,466 | 1,582 | 699 | 6.1 | 16.9 | 30,141 | 19.50% | 2,230 | 308 | 136 | 1.2 | 3.3 |
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 |
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 |
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 |
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 |
241 | 241 | Michigan | CBSA | Muskegon, Michigan | 2 | 397 | 143 | 172,707.00 | 12,780 | 1,764 | 780 | 6.4 | 17.8 | 37,993.00 | 22.00% | 2,811 | 388 | 172 | 1.4 | 3.9 |
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 |
252 | 252 | Michigan | CBSA | Niles, Michigan | 2 | 344 | 124 | 154,948.00 | 11,466 | 1,582 | 699 | 6.6 | 18.4 | 39,067.00 | 25.20% | 2,891 | 399 | 176 | 1.7 | 4.6 |
259 | 259 | Arizona | CBSA | Yuma, Arizona | 2 | 447 | 161 | 204,281.00 | 15,117 | 2,086 | 922 | 6.7 | 18.7 | 45,739.00 | 22.40% | 3,385 | 467 | 206 | 1.5 | 4.2 |
267 | 267 | Pennsylvania | CBSA | Chambersburg-Waynesboro, Pennsylvania | 2 | 329 | 118 | 153,003.00 | 11,322 | 1,562 | 691 | 6.8 | 19.1 | 38,030.00 | 24.90% | 2,814 | 388 | 172 | 1.7 | 4.7 |
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 |
284 | 284 | Pennsylvania | CBSA | State College, Pennsylvania | 2 | 333 | 120 | 160,646.00 | 11,888 | 1,641 | 725 | 7.1 | 19.7 | 29,386.00 | 18.30% | 2,175 | 300 | 133 | 1.3 | 3.6 |
288 | 288 | California | CBSA | Napa, California | 2 | 289 | 104 | 141,005 | 10,434 | 1,440 | 636 | 7.2 | 20 | 33,686 | 23.90% | 2,493 | 344 | 152 | 1.7 | 4.8 |
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 |
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 );