CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Estimated available beds (36% of total)
This data as json, copyable, CSV (advanced)
Geography_Type ✖
- CBSA 408
- No clean match 24
- MD 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
423 | 423 | Michigan | CBSA | Grand Rapids-Wyoming, Michigan | 1 | 39 | 14 | 988,938 | 73,181 | 10,099 | 4,464 | 373.4 | 1040.2 | |||||||
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
325 | 325 | Kentucky | CBSA | Clarksville, Kentucky | 2 | 158 | 57 | 86,724 | 6,418 | 886 | 391 | 8.1 | 22.4 | 15,571 | 18.00% | 1,152 | 159 | 70 | 1.5 | 4 |
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 |
389 | 389 | Utah | CBSA | Logan, Utah | 2 | 159 | 57 | 120,288 | 8,901 | 1,228 | 543 | 11.1 | 31.1 | 15,104 | 12.60% | 1,118 | 154 | 68 | 1.4 | 3.9 |
385 | 385 | Connecticut | CBSA | Worcester, Connecticut | 2 | 161 | 58 | 116,674 | 8,634 | 1,191 | 527 | 10.7 | 29.6 | 25,482 | 21.80% | 1,886 | 260 | 115 | 2.3 | 6.5 |
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 |
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 |
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 |
355 | 355 | New Jersey | CBSA | Allentown-Bethlehem-Easton, New Jersey | 2 | 172 | 62 | 107,088 | 7,925 | 1,094 | 483 | 9.2 | 25.4 | 24,579 | 23.00% | 1,819 | 251 | 111 | 2.1 | 5.8 |
373 | 373 | Wisconsin | CBSA | Sheboygan, Wisconsin | 2 | 173 | 62 | 115,094.00 | 8,517 | 1,175 | 520 | 9.8 | 27.3 | 27,003.00 | 23.50% | 1,998 | 276 | 122 | 2.3 | 6.4 |
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 |
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 |
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 |
296 | 296 | Idaho | CBSA | Pocatello, Idaho | 2 | 185 | 67 | 91,780 | 6,792 | 937 | 414 | 7.3 | 20.2 | 17,343 | 18.90% | 1,283 | 177 | 78 | 1.4 | 3.8 |
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 |
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 |
309 | 309 | Minnesota | CBSA | Mankato, Minnesota | 2 | 189 | 68 | 99,244 | 7,344 | 1,013 | 448 | 7.7 | 21.5 | 19,046 | 19.20% | 1,409 | 194 | 86 | 1.5 | 4.1 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
407 | 407 | California | CBSA | Merced, California | 2 | 230 | 83 | 267,390 | 19,787 | 2,731 | 1,207 | 17.1 | 47.4 | 40,383 | 15.10% | 2,988 | 412 | 182 | 2.6 | 7.2 |
387 | 387 | California | CBSA | Yuba City, California | 2 | 233 | 84 | 170,227 | 12,597 | 1,738 | 768 | 10.8 | 29.8 | 31,546 | 18.50% | 2,334 | 322 | 142 | 2 | 5.5 |
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 |
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 |
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 |
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 |
346 | 346 | Georgia | CBSA | Dalton, Georgia | 2 | 239 | 86 | 143,407 | 10,612 | 1,464 | 647 | 8.8 | 24.5 | 26,145 | 18.20% | 1,935 | 267 | 118 | 1.6 | 4.5 |
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 |
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 |
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 |
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 |
368 | 368 | Virginia | CBSA | Blacksburg-Christiansburg, Virginia | 4 | 252 | 91 | 166,269.00 | 12,304 | 1,698 | 751 | 9.7 | 26.9 | 33,140.00 | 19.90% | 2,452 | 338 | 150 | 1.9 | 5.4 |
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 |
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 |
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 |
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 |
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 |
250 | 250 | New York | CBSA | Watertown-Fort Drum, New York | 3 | 261 | 94 | 116,567 | 8,626 | 1,190 | 526 | 6.6 | 18.3 | 19,760 | 17.00% | 1,462 | 202 | 89 | 1.1 | 3.1 |
311 | 311 | Utah | CBSA | St George, Utah | 1 | 263 | 95 | 138,115 | 10,221 | 1,410 | 623 | 7.7 | 21.4 | 0 | ||||||
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 |
313 | 313 | South Carolina | CBSA | Sumter, South Carolina | 2 | 268 | 96 | 141,535 | 10,474 | 1,445 | 639 | 7.8 | 21.7 | 33,021 | 23.30% | 2,444 | 337 | 149 | 1.8 | 5.1 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
244 | 244 | Iowa | CBSA | Omaha-Council Bluffs, Iowa | 3 | 278 | 100 | 122,416 | 9,059 | 1,250 | 553 | 6.5 | 18 | 28,628 | 23.40% | 2,118 | 292 | 129 | 1.5 | 4.2 |
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 |
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 |
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 |
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 |
217 | 217 | Alabama | CBSA | Anniston-Oxford, Alabama | 3 | 286 | 103 | 115,527 | 8,549 | 1,180 | 521 | 5.9 | 16.5 | 27,115 | 23.50% | 2,007 | 277 | 122 | 1.4 | 3.9 |
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 |
224 | 224 | Iowa | CBSA | Ames, Iowa | 3 | 297 | 107 | 122,269 | 9,048 | 1,249 | 552 | 6.1 | 16.8 | 21,471 | 17.60% | 1,589 | 219 | 97 | 1.1 | 3 |
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 |
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 |
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 |
249 | 249 | Michigan | CBSA | Battle Creek, Michigan | 3 | 301 | 108 | 134,327.00 | 9,940 | 1,372 | 606 | 6.6 | 18.3 | 31,227.00 | 23.20% | 2,311 | 319 | 141 | 1.5 | 4.3 |
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 |
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 |
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 );