CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Critical_allages
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
425 | 425 | Illinois | No clean match | Chicago-Naperville-Evanston, Illinois | 68 | 19,170 | No clean match | |||||||||||||
426 | 426 | Illinois | No clean match | Elgin, Illinois | 7 | 1,065 | No clean match | |||||||||||||
427 | 427 | Illinois | No clean match | Lake County-Kenosha County, Illinois | 5 | 844 | No clean match | |||||||||||||
428 | 428 | Indiana | No clean match | Gary, Indiana | 14 | 2,965 | No clean match | |||||||||||||
429 | 429 | Maryland | No clean match | Frederick-Gaithersburg-Rockville, Maryland | 8 | 1,905 | No clean match | |||||||||||||
430 | 430 | Maryland | No clean match | Wilmington, Maryland | 1 | 109 | No clean match | |||||||||||||
431 | 431 | Massachusetts | No clean match | Boston, Massachusetts | 26 | 6,569 | No clean match | |||||||||||||
432 | 432 | Massachusetts | No clean match | Cambridge-Newton-Framingham, Massachusetts | 19 | 3,934 | No clean match | |||||||||||||
433 | 433 | Missouri | No clean match | St Joseph, Missouri | 1 | 352 | No clean match | |||||||||||||
434 | 434 | New Hampshire | No clean match | Rockingham County-Strafford County, New Hampshire | 6 | 719 | No clean match | |||||||||||||
435 | 435 | New Jersey | No clean match | Camden, New Jersey | 12 | 3,278 | No clean match | |||||||||||||
436 | 436 | New Jersey | No clean match | New Brunswick-Lakewood, New Jersey | 21 | 5,086 | No clean match | |||||||||||||
437 | 437 | New Jersey | No clean match | New York-Jersey City-White Plains, New Jersey | 15 | 4,793 | No clean match | |||||||||||||
438 | 438 | New Jersey | No clean match | Newark, New Jersey | 18 | 5,200 | No clean match | |||||||||||||
439 | 439 | New Jersey | No clean match | Wilmington, New Jersey | 2 | 222 | No clean match | |||||||||||||
440 | 440 | New York | No clean match | Nassau County-Suffolk County, New York | 20 | 7,497 | No clean match | |||||||||||||
441 | 441 | New York | No clean match | New York-Jersey City-White Plains, New York | 55 | 24,992 | No clean match | |||||||||||||
442 | 442 | Tennessee | No clean match | Chattanooga Clarksville, Tennessee | 5 | 1921 | No clean match | |||||||||||||
443 | 443 | Texas | No clean match | Dallas-Plano-Irving, Texas | 80 | 10,748 | No clean match | |||||||||||||
444 | 444 | Texas | No clean match | Fort Worth-Arlington-Grapevine, Texas | 40 | 5,595 | No clean match | |||||||||||||
445 | 445 | Washington | No clean match | Olympia-Tumwater, Washington | 2 | 401 | No clean match | |||||||||||||
446 | 446 | Washington | No clean match | Seattle-Bellevue-Kent, Washington | 22 | 5,239 | No clean match | |||||||||||||
447 | 447 | Washington | No clean match | Tacoma-Lakewood, Washington | 6 | 1,463 | No clean match | |||||||||||||
448 | 448 | Wisconsin | No clean match | Lake County-Kenosha County, Wisconsin | 2 | 273 | No clean match | |||||||||||||
12 | 12 | Texas | CBSA | Tyler, Texas | 8 | 1,209 | 435 | 222,277 | 16,448 | 2,270 | 1,003 | 2.7 | 7.5 | 47,438 | 21.30% | 3,510 | 484 | 214 | 0.6 | 1.6 |
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 |
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 |
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 |
41 | 41 | Georgia | CBSA | Macon-Bibb County, Georgia | 5 | 1,040 | 374 | 229,966 | 17,017 | 2,348 | 1,038 | 3.3 | 9.1 | 50,113 | 21.80% | 3,708 | 512 | 226 | 0.7 | 2 |
370 | 370 | Wisconsin | CBSA | Appleton, Wisconsin | 3 | 352 | 127 | 233,025.00 | 17,244 | 2,380 | 1,052 | 9.7 | 27 | 45,170.00 | 19.40% | 3,343 | 461 | 204 | 1.9 | 5.2 |
136 | 136 | Kansas | CBSA | Topeka, Kansas | 4 | 701 | 252 | 233,382 | 17,270 | 2,383 | 1,053 | 4.9 | 13.6 | 55,557 | 23.80% | 4,111 | 567 | 251 | 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 |
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 |
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 |
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 |
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 |
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 |
28 | 28 | South Dakota | CBSA | Sioux Falls, South Dakota | 8 | 1,210 | 436 | 250,564 | 18,542 | 2,559 | 1,131 | 3 | 8.5 | 44,671 | 17.80% | 3,306 | 456 | 202 | 0.5 | 1.5 |
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 |
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 |
371 | 371 | California | MD | San Rafael, California | 3 | 391 | 141 | 259,666 | 19,215 | 2,652 | 1,172 | 9.8 | 27.1 | 0 | ||||||
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 |
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 |
92 | 92 | Texas | CBSA | Amarillo, Texas | 5 | 942 | 339 | 261,827 | 19,375 | 2,674 | 1,182 | 4.1 | 11.4 | 47,955 | 18.30% | 3,549 | 490 | 216 | 0.7 | 2.1 |
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 |
87 | 87 | Georgia | CBSA | Columbus, Georgia | 4 | 974 | 351 | 263,754 | 19,518 | 2,693 | 1,191 | 4 | 11.1 | 48,520 | 18.40% | 3,590 | 495 | 219 | 0.7 | 2 |
179 | 179 | Iowa | CBSA | Cedar Rapids, Iowa | 4 | 734 | 264 | 266,122 | 19,693 | 2,718 | 1,201 | 5.3 | 14.8 | 56,966 | 21.40% | 4,215 | 582 | 257 | 1.1 | 3.2 |
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 |
185 | 185 | Indiana | CBSA | South Bend-Mishawaka, Indiana | 3 | 733 | 264 | 268,613 | 19,877 | 2,743 | 1,213 | 5.4 | 15 | 57,385 | 21.40% | 4,246 | 586 | 259 | 1.2 | 3.2 |
26 | 26 | Indiana | CBSA | Evansville, Indiana | 7 | 1,302 | 469 | 269,011 | 19,907 | 2,747 | 1,214 | 3 | 8.4 | 60,428 | 22.50% | 4,472 | 617 | 273 | 0.7 | 1.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 |
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 |
353 | 353 | Connecticut | CBSA | Norwich-New London, Connecticut | 2 | 435 | 157 | 270,772 | 20,037 | 2,765 | 1,222 | 9.2 | 25.4 | 63,495 | 23.40% | 4,699 | 648 | 287 | 2.1 | 6 |
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 |
390 | 390 | California | CBSA | Santa Cruz-Watsonville, California | 3 | 359 | 129 | 273,263 | 20,221 | 2,791 | 1,234 | 11.2 | 31.2 | 57,232 | 20.90% | 4,235 | 584 | 258 | 2.3 | 6.5 |
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 |
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 |
361 | 361 | Washington | CBSA | Kennewick-Richland, Washington | 4 | 434 | 156 | 279,653 | 20,694 | 2,856 | 1,262 | 9.5 | 26.4 | 48,923 | 17.50% | 3,620 | 500 | 221 | 1.7 | 4.6 |
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 |
204 | 204 | Texas | CBSA | Longview, Texas | 4 | 735 | 265 | 283,540 | 20,982 | 2,896 | 1,280 | 5.7 | 15.8 | 59,948 | 21.10% | 4,436 | 612 | 271 | 1.2 | 3.3 |
401 | 401 | Colorado | CBSA | Greeley, Colorado | 3 | 316 | 114 | 285,729 | 21,144 | 2,918 | 1,290 | 13.3 | 36.9 | 48,279 | 16.90% | 3,573 | 493 | 218 | 2.2 | 6.2 |
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 |
193 | 193 | South Carolina | CBSA | Spartanburg, South Carolina | 3 | 795 | 286 | 297,732 | 22,032 | 3,040 | 1,344 | 5.5 | 15.3 | 63,159 | 21.20% | 4,674 | 645 | 285 | 1.2 | 3.3 |
57 | 57 | Texas | CBSA | Lubbock, Texas | 9 | 1,332 | 480 | 309,722 | 22,919 | 3,163 | 1,398 | 3.4 | 9.5 | 51,984 | 16.80% | 3,847 | 531 | 235 | 0.6 | 1.6 |
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 |
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 |
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 |
25 | 25 | Florida | CBSA | Gainesville, Florida | 4 | 1,548 | 557 | 316,769.00 | 23,441 | 3,235 | 1,430 | 3 | 8.4 | 64,742.00 | 20.40% | 4,791 | 661 | 292 | 0.6 | 1.7 |
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 |
32 | 32 | Nebraska | CBSA | Lincoln, Nebraska | 8 | 1,526 | 549 | 323,402 | 23,932 | 3,303 | 1,460 | 3.1 | 8.7 | 59,068 | 18.30% | 4,371 | 603 | 267 | 0.6 | 1.6 |
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 |
212 | 212 | Illinois | CBSA | Rockford, Illinois | 4 | 864 | 311 | 341,150 | 25,245 | 3,484 | 1,540 | 5.8 | 16.2 | 75,762 | 22.20% | 5,606 | 774 | 342 | 1.3 | 3.6 |
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 |
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 |
40 | 40 | Michigan | CBSA | Ann Arbor, Michigan | 5 | 1,641 | 591 | 361,509.00 | 26,752 | 3,692 | 1,632 | 3.2 | 9 | 65,781.00 | 18.20% | 4,868 | 672 | 297 | 0.6 | 1.6 |
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 |
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 |
380 | 380 | South Carolina | CBSA | Charlotte-Concord-Gastonia, South Carolina | 4 | 541 | 195 | 370,632 | 27,427 | 3,785 | 1,673 | 10.1 | 28 | 79,346 | 21.40% | 5,872 | 810 | 358 | 2.2 | 6 |
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 |
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 |
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 |
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 |
199 | 199 | Texas | CBSA | Beaumont-Port Arthur, Texas | 9 | 1,035 | 373 | 394,476 | 29,191 | 4,028 | 1,781 | 5.6 | 15.6 | 79,511 | 20.20% | 5,884 | 812 | 359 | 1.1 | 3.1 |
61 | 61 | Georgia | CBSA | Augusta-Richmond County, Georgia | 8 | 1,645 | 592 | 397,192 | 29,392 | 4,056 | 1,793 | 3.6 | 9.9 | 75,957 | 19.10% | 5,621 | 776 | 343 | 0.7 | 1.9 |
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 |
59 | 59 | Indiana | CBSA | Fort Wayne, Indiana | 10 | 1,697 | 611 | 401,228 | 29,691 | 4,097 | 1,811 | 3.5 | 9.7 | 79,036 | 19.70% | 5,849 | 807 | 357 | 0.7 | 1.9 |
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 |
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 |
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 |
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 |
391 | 391 | Oregon | CBSA | Salem, Oregon | 4 | 534 | 192 | 410,119 | 30,349 | 4,188 | 1,851 | 11.3 | 31.5 | 87,239 | 21.30% | 6,456 | 891 | 394 | 2.4 | 6.7 |
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 |
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 |
203 | 203 | Pennsylvania | CBSA | Reading, Pennsylvania | 5 | 1,080 | 389 | 415,500.00 | 30,747 | 4,243 | 1,876 | 5.7 | 15.7 | 93,051.00 | 22.40% | 6,886 | 950 | 420 | 1.3 | 3.5 |
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 |
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 |
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 |
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 |
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 |
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 |
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 );