CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by 60plus_PercentOfTotalPopulation 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
128 | 128 | Florida | CBSA | Sebastian-Vero Beach, Florida | 3 | 454 | 163 | 147,981.00 | 10,951 | 1,511 | 668 | 4.8 | 13.4 | 57,277.00 | 38.70% | 4,238 | 585 | 259 | 1.9 | 5.2 |
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 |
153 | 153 | Florida | CBSA | North Port-Sarasota-Bradenton, Florida | 9 | 2,222 | 800 | 768,381.00 | 56,860 | 7,847 | 3,468 | 5.1 | 14.1 | 294,621.00 | 38.30% | 21,802 | 3,009 | 1,330 | 2 | 5.4 |
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 |
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 |
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 |
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 |
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 |
268 | 268 | Florida | CBSA | Cape Coral-Fort Myers, Florida | 4 | 1,503 | 541 | 700,165.00 | 51,812 | 7,150 | 3,161 | 6.9 | 19.1 | 239,488.00 | 34.20% | 17,722 | 2,446 | 1,081 | 2.3 | 6.5 |
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 |
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 |
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 |
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 |
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 |
181 | 181 | Florida | CBSA | Palm Bay-Melbourne-Titusville, Florida | 9 | 1,556 | 560 | 568,183.00 | 42,046 | 5,802 | 2,565 | 5.4 | 14.9 | 170,919.00 | 30.10% | 12,648 | 1,745 | 772 | 1.6 | 4.5 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
372 | 372 | Virginia | CBSA | Kingsport-Bristol, Virginia | 2 | 141 | 51 | 93,824.00 | 6,943 | 958 | 424 | 9.8 | 27.1 | 26,693.00 | 28.50% | 1,975 | 273 | 120 | 2.8 | 7.7 |
2 | 2 | West Virginia | CBSA | Wheeling, West Virginia | 4 | 614 | 221 | 74,912 | 5,543 | 765 | 338 | 1.8 | 5 | 21,297 | 28.40% | 1,576 | 217 | 96 | 0.5 | 1.4 |
228 | 228 | Oregon | CBSA | Medford, Oregon | 3 | 513 | 185 | 212,070 | 15,693 | 2,166 | 957 | 6.1 | 16.9 | 60,113 | 28.30% | 4,448 | 614 | 271 | 1.7 | 4.8 |
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 |
16 | 16 | Ohio | CBSA | Weirton-Steubenville, Ohio | 3 | 359 | 129 | 67,349 | 4,984 | 688 | 304 | 2.8 | 7.7 | 18,775 | 27.90% | 1,389 | 192 | 85 | 0.8 | 2.1 |
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 |
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 |
139 | 139 | Pennsylvania | MD | Scranton-Wilkes-Barre, Pennsylvania | 10 | 1,651 | 594 | 555485 | 41,106 | 5,673 | 2,507 | 5 | 13.8 | 152608 | 27.50% | 11,293 | 1,558 | 689 | 1.4 | 3.8 |
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 |
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 |
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 |
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 |
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 |
117 | 117 | California | CBSA | Redding, California | 5 | 574 | 207 | 178,919 | 13,240 | 1,827 | 808 | 4.6 | 12.7 | 47,900 | 26.80% | 3,545 | 489 | 216 | 1.2 | 3.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 |
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 |
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 |
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 |
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 |
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 |
218 | 218 | Florida | CBSA | Lakeland-Winter Haven, Florida | 5 | 1,617 | 582 | 652,256.00 | 48,267 | 6,661 | 2,944 | 5.9 | 16.5 | 169,578.00 | 26.00% | 12,549 | 1,732 | 765 | 1.5 | 4.3 |
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 |
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 |
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 |
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 |
329 | 329 | Oregon | CBSA | Bend, Oregon | 2 | 307 | 111 | 175,321 | 12,974 | 1,790 | 791 | 8.4 | 23.3 | 45,371 | 25.90% | 3,357 | 463 | 205 | 2.2 | 6 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
1 | 1 | Pennsylvania | CBSA | Bloomsburg-Berwick, Pennsylvania | 5 | 789 | 284 | 84,917.00 | 6,284 | 867 | 383 | 1.6 | 4.4 | 21,406.00 | 25.20% | 1,584 | 219 | 97 | 0.4 | 1.1 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
359 | 359 | New York | CBSA | Kingston, New York | 3 | 280 | 101 | 180,129 | 13,330 | 1,839 | 813 | 9.5 | 26.3 | 45,203 | 25.10% | 3,345 | 462 | 204 | 2.4 | 6.6 |
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 |
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 |
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 |
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 |
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 |
345 | 345 | South Carolina | CBSA | Augusta-Richmond County, South Carolina | 2 | 324 | 117 | 192,327 | 14,232 | 1,964 | 868 | 8.7 | 24.2 | 47,819 | 24.90% | 3,539 | 488 | 216 | 2.2 | 6 |
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 |
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 |
188 | 188 | Maryland | CBSA | Salisbury, Maryland | 4 | 487 | 175 | 179,374 | 13,274 | 1,832 | 810 | 5.4 | 15.1 | 44,502 | 24.80% | 3,293 | 454 | 201 | 1.3 | 3.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 |
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 |
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 |
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 |
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 |
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 |
297 | 297 | Pennsylvania | MD | Montgomery County-Bucks County-Chester County, Pennsylvania | 23 | 3,971 | 1430 | 1978845 | 146,435 | 20,208 | 8,933 | 7.3 | 20.4 | 485398 | 24.50% | 35,919 | 4,957 | 2,191 | 1.8 | 5 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
227 | 227 | North Carolina | CBSA | Rocky Mount, North Carolina | 3 | 357 | 129 | 148157 | 10,964 | 1,513 | 669 | 6.1 | 16.9 | 35575 | 24.00% | 2,633 | 363 | 161 | 1.5 | 4.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 );