CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348 | 348 | New York | CBSA | Poughkeepsie-Newburgh-Middletown, New York | 6 | 1,120 | 403 | 673,859 | 49,866 | 6,881 | 3,042 | 8.9 | 24.6 | 137,318 | 20.40% | 10,162 | 1,402 | 620 | 1.8 | 5 |
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 |
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 |
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 |
344 | 344 | California | CBSA | San Jose-Sunnyvale-Santa Clara, California | 11 | 3,321 | 1196 | 1,969,897 | 145,772 | 20,117 | 8,892 | 8.7 | 24.3 | 348,794 | 17.70% | 25,811 | 3,562 | 1,574 | 1.5 | 4.3 |
343 | 343 | Wisconsin | CBSA | Racine, Wisconsin | 2 | 333 | 120 | 195,101.00 | 14,437 | 1,992 | 881 | 8.6 | 23.9 | 42,061.00 | 21.60% | 3,113 | 430 | 190 | 1.9 | 5.2 |
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 |
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 |
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 |
339 | 339 | California | CBSA | Sacramento-Roseville-Folsom, California | 17 | 3,875 | 1395 | 2,268,005 | 167,832 | 23,161 | 10,238 | 8.6 | 23.9 | 456,252 | 20.10% | 33,763 | 4,659 | 2,060 | 1.7 | 4.8 |
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 |
337 | 337 | Florida | CBSA | Panama City, Florida | 5 | 308 | 111 | 180,117.00 | 13,329 | 1,839 | 813 | 8.6 | 23.9 | 40,210.00 | 22.30% | 2,976 | 411 | 182 | 1.9 | 5.3 |
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 |
335 | 335 | Connecticut | CBSA | Bridgeport-Stamford-Norwalk, Connecticut | 6 | 1,638 | 590 | 947,328 | 70,102 | 9,674 | 4,276 | 8.5 | 23.6 | 197,334 | 20.80% | 14,603 | 2,015 | 891 | 1.8 | 4.9 |
334 | 334 | Indiana | CBSA | Elkhart-Goshen, Indiana | 2 | 352 | 127 | 202,924 | 15,016 | 2,072 | 916 | 8.5 | 23.5 | 38,669 | 19.10% | 2,862 | 395 | 175 | 1.6 | 4.5 |
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 |
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 |
331 | 331 | California | CBSA | Fresno, California | 8 | 1,692 | 609 | 971,616 | 71,900 | 9,922 | 4,386 | 8.5 | 23.5 | 157,757 | 16.20% | 11,674 | 1,611 | 712 | 1.4 | 3.8 |
330 | 330 | Texas | CBSA | Austin-Round Rock-Georgetown, Texas | 29 | 3,498 | 1259 | 2,000,590 | 148,044 | 20,430 | 9,031 | 8.4 | 23.4 | 296,071 | 14.80% | 21,909 | 3,023 | 1,336 | 1.2 | 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 |
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 |
327 | 327 | Combined | CBSA | Minneapolis-St Paul-Bloomington, Minnesota and Wisconsin | 34 | 6452 | 2323 | 3,629,190 | 268,560 | 37,061 | 16,382 | 8.3 | 23 | 0 | ||||||
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 |
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 |
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 |
323 | 323 | New Mexico | CBSA | Las Cruces, New Mexico | 4 | 395 | 142 | 213,849 | 15,825 | 2,184 | 965 | 8 | 22.2 | 41,981 | 19.60% | 3,107 | 429 | 190 | 1.6 | 4.4 |
322 | 322 | California | MD | Anaheim-Santa Ana-Irvine, California | 27 | 5,900 | 2124 | 3,185,968 | 235,762 | 32,535 | 14,381 | 8 | 22.1 | 0 | ||||||
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 |
320 | 320 | Oregon | CBSA | Portland-Vancouver-Hillsboro, Oregon | 17 | 3,552 | 1279 | 1,913,065 | 141,567 | 19,536 | 8,636 | 7.9 | 22 | 374,979 | 19.60% | 27,748 | 3,829 | 1,693 | 1.6 | 4.3 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
311 | 311 | Utah | CBSA | St George, Utah | 1 | 263 | 95 | 138,115 | 10,221 | 1,410 | 623 | 7.7 | 21.4 | 0 | ||||||
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 |
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 |
308 | 308 | Mississippi | CBSA | Memphis, Mississippi | 4 | 473 | 170 | 247,857.00 | 18,341 | 2,531 | 1,119 | 7.7 | 21.5 | 45,237.00 | 18.30% | 3,348 | 462 | 204 | 1.4 | 3.9 |
307 | 307 | Hawaii | CBSA | Urban Honolulu, Hawaii | 11 | 1,895 | 682 | 990,060 | 73,264 | 10,110 | 4,469 | 7.7 | 21.4 | 218,287 | 22.00% | 16,153 | 2,229 | 985 | 1.7 | 4.7 |
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 |
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 |
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 |
303 | 303 | Washington | CBSA | Yakima, Washington | 4 | 486 | 175 | 248,279 | 18,373 | 2,535 | 1,121 | 7.5 | 20.9 | 44,560 | 17.90% | 3,297 | 455 | 201 | 1.4 | 3.7 |
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 |
301 | 301 | Pennsylvania | CBSA | East Stroudsburg, Pennsylvania | 2 | 329 | 118 | 167,306.00 | 12,381 | 1,709 | 755 | 7.5 | 20.9 | 37,614.00 | 22.50% | 2,783 | 384 | 170 | 1.7 | 4.7 |
300 | 300 | Colorado | CBSA | Denver-Aurora-Lakewood, Colorado | 26 | 5,527 | 1990 | 2,798,684 | 207,103 | 28,580 | 12,633 | 7.5 | 20.7 | 491,072 | 17.50% | 36,339 | 5,015 | 2,217 | 1.3 | 3.6 |
299 | 299 | Wisconsin | CBSA | Wausau-Weston, Wisconsin | 4 | 325 | 117 | 163,287.00 | 12,083 | 1,667 | 737 | 7.4 | 20.5 | 38,558.00 | 23.60% | 2,853 | 394 | 174 | 1.7 | 4.9 |
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 |
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 |
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 |
295 | 295 | Georgia | CBSA | Warner Robins, Georgia | 4 | 358 | 129 | 177,368 | 13,125 | 1,811 | 801 | 7.3 | 20.2 | 30,723 | 17.30% | 2,274 | 314 | 139 | 1.3 | 3.5 |
294 | 294 | Colorado | CBSA | Boulder, Colorado | 5 | 640 | 230 | 316,782 | 23,442 | 3,235 | 1,430 | 7.3 | 20.3 | 59,425 | 18.80% | 4,397 | 607 | 268 | 1.4 | 3.8 |
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 |
292 | 292 | Massachusetts | CBSA | Worcester, Massachusetts | 9 | 1,659 | 597 | 818,249 | 60,550 | 8,356 | 3,694 | 7.3 | 20.2 | 170,081 | 20.80% | 12,586 | 1,737 | 768 | 1.5 | 4.2 |
291 | 291 | Indiana | CBSA | Lafayette-West Lafayette, Indiana | 4 | 451 | 162 | 223,029 | 16,504 | 2,278 | 1,007 | 7.3 | 20.3 | 37,876 | 17.00% | 2,803 | 387 | 171 | 1.2 | 3.4 |
290 | 290 | Delaware | MD | Wilmington, Delaware | 4 | 1,473 | 530 | 724,768 | 53,633 | 7,401 | 3,272 | 7.2 | 20.1 | 0 | ||||||
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 |
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 |
287 | 287 | Texas | CBSA | Waco, Texas | 3 | 542 | 195 | 263,009 | 19,463 | 2,686 | 1,187 | 7.1 | 19.9 | 50,698 | 19.30% | 3,752 | 518 | 229 | 1.4 | 3.8 |
286 | 286 | New Mexico | CBSA | Albuquerque, New Mexico | 10 | 1,870 | 673 | 905,049 | 66,974 | 9,242 | 4,085 | 7.1 | 19.8 | 193,195 | 21.30% | 14,296 | 1,973 | 872 | 1.5 | 4.2 |
285 | 285 | Rhode Island | CBSA | Providence-Warwick, Rhode Island | 11 | 2,187 | 787 | 1,056,138.00 | 78,154 | 10,785 | 4,767 | 7.1 | 19.8 | 237,693.00 | 22.50% | 17,589 | 2,427 | 1,073 | 1.6 | 4.4 |
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 |
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 |
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 |
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 |
280 | 280 | Virginia | CBSA | Virginia Beach-Norfolk-Newport News, Virginia | 18 | 3,556 | 1280 | 1,707,283.00 | 126,339 | 17,435 | 7,707 | 7.1 | 19.6 | 326,159.00 | 19.10% | 24,136 | 3,331 | 1,472 | 1.4 | 3.8 |
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 |
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 |
277 | 277 | North Carolina | CBSA | Charlotte-Concord-Gastonia, North Carolina | 19 | 4,365 | 1571 | 2081923 | 154,062 | 21,261 | 9,398 | 7 | 19.5 | 364756 | 17.50% | 26,992 | 3,725 | 1,647 | 1.2 | 3.4 |
276 | 276 | Alaska | CBSA | Anchorage, Alaska | 5 | 839 | 302 | 399,360 | 29,553 | 4,078 | 1,803 | 7 | 19.5 | 59,966 | 15.00% | 4,437 | 612 | 271 | 1.1 | 2.9 |
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 |
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 |
273 | 273 | Connecticut | CBSA | Hartford-East Hartford-Middletown, Connecticut | 11 | 2,566 | 924 | 1,213,123 | 89,771 | 12,388 | 5,476 | 7 | 19.3 | 274,153 | 22.60% | 20,287 | 2,800 | 1,238 | 1.6 | 4.4 |
272 | 272 | California | MD | Los Angeles-Long Beach-Glendale, California | 89 | 21,347 | 7685 | 10,105,518 | 747,808 | 103,198 | 45,616 | 7 | 19.4 | 0 | ||||||
271 | 271 | California | CBSA | Chico, California | 3 | 476 | 171 | 225,207 | 16,665 | 2,300 | 1,017 | 7 | 19.4 | 53,616 | 23.80% | 3,968 | 548 | 242 | 1.7 | 4.6 |
270 | 270 | Florida | CBSA | Crestview-Fort Walton Beach-Destin, Florida | 5 | 558 | 201 | 261,048.00 | 19,318 | 2,666 | 1,178 | 6.9 | 19.1 | 58,298.00 | 22.30% | 4,314 | 595 | 263 | 1.5 | 4.3 |
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 |
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 |
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 |
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 |
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 |
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 |
263 | 263 | North Carolina | CBSA | Greensboro-High Point, North Carolina | 6 | 1,636 | 589 | 751590 | 55,618 | 7,675 | 3,393 | 6.8 | 18.8 | 159515 | 21.20% | 11,804 | 1,629 | 720 | 1.4 | 4 |
262 | 262 | Nevada | CBSA | Las Vegas-Henderson-Paradise, Nevada | 24 | 4,590 | 1652 | 2,112,436 | 156,320 | 21,572 | 9,536 | 6.8 | 18.8 | 405,618 | 19.20% | 30,016 | 4,142 | 1,831 | 1.3 | 3.6 |
261 | 261 | Illinois | CBSA | Bloomington, Illinois | 3 | 377 | 136 | 173,231 | 12,819 | 1,769 | 782 | 6.8 | 18.8 | 29,727 | 17.20% | 2,200 | 304 | 134 | 1.2 | 3.2 |
260 | 260 | Georgia | CBSA | Valdosta, Georgia | 3 | 315 | 113 | 143,969 | 10,654 | 1,470 | 650 | 6.7 | 18.8 | 24,673 | 17.10% | 1,826 | 252 | 111 | 1.2 | 3.2 |
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 |
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 |
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 |
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 |
255 | 255 | Wisconsin | CBSA | Oshkosh-Neenah, Wisconsin | 4 | 375 | 135 | 169,540.00 | 12,546 | 1,731 | 765 | 6.7 | 18.5 | 35,586.00 | 21.00% | 2,633 | 363 | 161 | 1.4 | 3.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 |
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 |
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 |
251 | 251 | Hawaii | CBSA | Kahului-Wailuku-Lahaina, Hawaii | 4 | 367 | 132 | 164,094 | 12,143 | 1,676 | 741 | 6.6 | 18.3 | 37,939 | 23.10% | 2,807 | 387 | 171 | 1.5 | 4.2 |
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 |
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 |
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 );