CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Metro
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54 | 54 | Texas | CBSA | Abilene, Texas | 6 | 731 | 263 | 169,000 | 12,506 | 1,726 | 763 | 3.4 | 9.5 | 33,416 | 19.80% | 2,473 | 341 | 151 | 0.7 | 1.9 |
189 | 189 | Ohio | CBSA | Akron, Ohio | 8 | 1,912 | 688 | 703,398 | 52,051 | 7,183 | 3,175 | 5.4 | 15.1 | 161,110 | 22.90% | 11,922 | 1,645 | 727 | 1.2 | 3.4 |
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 |
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 |
172 | 172 | New York | CBSA | Albany-Schenectady-Troy, New York | 8 | 2,453 | 883 | 881,862 | 65,258 | 9,006 | 3,981 | 5.3 | 14.7 | 199,326 | 22.60% | 14,750 | 2,036 | 900 | 1.2 | 3.3 |
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 |
22 | 22 | Louisiana | CBSA | Alexandria, Louisiana | 6 | 773 | 278 | 154,385 | 11,424 | 1,577 | 697 | 2.9 | 8.2 | 32,243 | 20.90% | 2,386 | 329 | 146 | 0.6 | 1.7 |
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 |
100 | 100 | Pennsylvania | CBSA | Allentown-Bethlehem-Easton, Pennsylvania | 10 | 2,511 | 904 | 725,702.00 | 53,702 | 7,411 | 3,276 | 4.3 | 11.8 | 171,527.00 | 23.60% | 12,693 | 1,752 | 774 | 1 | 2.8 |
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 |
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 |
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 |
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 | ||||||
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 |
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 |
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 |
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 |
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 |
178 | 178 | Georgia | CBSA | Athens-Clarke County, Georgia | 3 | 561 | 202 | 202,780 | 15,006 | 2,071 | 915 | 5.3 | 14.8 | 35,109 | 17.30% | 2,598 | 359 | 158 | 0.9 | 2.6 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
208 | 208 | Maryland | CBSA | Baltimore-Columbia-Towson, Maryland | 24 | 7,143 | 2571 | 2,792,050 | 206,612 | 28,512 | 12,603 | 5.8 | 16 | 572,610 | 20.50% | 42,373 | 5,847 | 2,585 | 1.2 | 3.3 |
104 | 104 | Maine | CBSA | Bangor, Maine | 4 | 519 | 187 | 152,284 | 11,269 | 1,555 | 687 | 4.3 | 12 | 36,356 | 23.90% | 2,690 | 371 | 164 | 1 | 2.9 |
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 |
145 | 145 | Louisiana | CBSA | Baton Rouge, Louisiana | 18 | 2,495 | 898 | 851,622 | 63,020 | 8,697 | 3,844 | 5 | 14 | 157,542 | 18.50% | 11,658 | 1,609 | 711 | 0.9 | 2.6 |
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 |
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 |
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 |
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 |
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 |
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 |
111 | 111 | Montana | CBSA | Billings, Montana | 5 | 576 | 207 | 176,140 | 13,034 | 1,799 | 795 | 4.5 | 12.5 | 41,033 | 23.30% | 3,036 | 419 | 185 | 1 | 2.9 |
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 |
55 | 55 | Alabama | CBSA | Birmingham-Hoover, Alabama | 17 | 4,632 | 1668 | 1,079,170 | 79,859 | 11,020 | 4,871 | 3.4 | 9.5 | 226,516 | 21.00% | 16,762 | 2,313 | 1,022 | 0.7 | 2 |
65 | 65 | North Dakota | CBSA | Bismarck, North Dakota | 3 | 505 | 182 | 124,253 | 9,195 | 1,269 | 561 | 3.6 | 10.1 | 25,840 | 20.80% | 1,912 | 264 | 117 | 0.8 | 2.1 |
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 |
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 |
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 |
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 |
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 |
431 | 431 | Massachusetts | No clean match | Boston, Massachusetts | 26 | 6,569 | No clean match | |||||||||||||
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 |
67 | 67 | Kentucky | CBSA | Bowling Green, Kentucky | 4 | 680 | 245 | 169,250 | 12,525 | 1,728 | 764 | 3.7 | 10.2 | 32,441 | 19.20% | 2,401 | 331 | 146 | 0.7 | 1.9 |
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 |
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 |
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 |
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 |
88 | 88 | New York | CBSA | Buffalo-Cheektowaga, New York | 10 | 4,188 | 1508 | 1,136,670 | 84,114 | 11,608 | 5,131 | 4 | 11.1 | 269,308 | 23.70% | 19,929 | 2,750 | 1,216 | 0.9 | 2.6 |
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 |
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 |
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 |
432 | 432 | Massachusetts | No clean match | Cambridge-Newton-Framingham, Massachusetts | 19 | 3,934 | No clean match | |||||||||||||
435 | 435 | New Jersey | No clean match | Camden, New Jersey | 12 | 3,278 | No clean match | |||||||||||||
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 |
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 |
14 | 14 | Missouri | CBSA | Cape Girardeau, Missouri | 3 | 484 | 174 | 90,360 | 6,687 | 923 | 408 | 2.7 | 7.6 | 20,121 | 22.30% | 1,489 | 205 | 91 | 0.6 | 1.7 |
160 | 160 | Illinois | CBSA | Carbondale-Marion, Illinois | 4 | 398 | 143 | 139,491 | 10,322 | 1,424 | 630 | 5.2 | 14.4 | 30,856 | 22.10% | 2,283 | 315 | 139 | 1.1 | 3.2 |
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 |
77 | 77 | Wyoming | CBSA | Casper, Wyoming | 4 | 315 | 113 | 81,023 | 5,996 | 827 | 366 | 3.8 | 10.6 | 16,036 | 19.80% | 1,187 | 164 | 72 | 0.7 | 2.1 |
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 |
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 |
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 |
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 |
198 | 198 | South Carolina | CBSA | Charleston-North Charleston, South Carolina | 7 | 1,957 | 705 | 744,195 | 55,070 | 7,600 | 3,359 | 5.6 | 15.5 | 147,202 | 19.80% | 10,893 | 1,503 | 664 | 1.1 | 3.1 |
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 |
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 |
81 | 81 | Virginia | CBSA | Charlottesville, Virginia | 3 | 806 | 290 | 211,777.00 | 15,671 | 2,163 | 956 | 3.9 | 10.8 | 47,131.00 | 22.30% | 3,488 | 481 | 213 | 0.9 | 2.4 |
442 | 442 | Tennessee | No clean match | Chattanooga Clarksville, Tennessee | 5 | 1921 | No clean match | |||||||||||||
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 |
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 |
425 | 425 | Illinois | No clean match | Chicago-Naperville-Evanston, Illinois | 68 | 19,170 | No clean match | |||||||||||||
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 |
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 |
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 |
151 | 151 | Ohio | CBSA | Cincinnati, Ohio | 20 | 4,815 | 1733 | 1,654,238 | 122,414 | 16,893 | 7,467 | 5.1 | 14.1 | 338,018 | 20.40% | 25,013 | 3,452 | 1,526 | 1 | 2.9 |
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 |
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 |
80 | 80 | Ohio | CBSA | Cleveland-Elyria, Ohio | 31 | 7,853 | 2827 | 2,062,764 | 152,645 | 21,065 | 9,311 | 3.9 | 10.7 | 491,925 | 23.80% | 36,402 | 5,024 | 2,221 | 0.9 | 2.6 |
201 | 201 | Idaho | CBSA | Coeur dAlene, Idaho | 3 | 362 | 130 | 138,494 | 10,249 | 1,414 | 625 | 5.6 | 15.7 | 0 | ||||||
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 |
365 | 365 | Colorado | CBSA | Colorado Springs, Colorado | 5 | 1,069 | 385 | 698,595 | 51,696 | 7,134 | 3,153 | 9.6 | 26.7 | 122,967 | 17.60% | 9,100 | 1,256 | 555 | 1.7 | 4.7 |
21 | 21 | Missouri | CBSA | Columbia, Missouri | 5 | 1,028 | 370 | 202,353 | 14,974 | 2,066 | 913 | 2.9 | 8.1 | 34,828 | 17.20% | 2,577 | 356 | 157 | 0.5 | 1.4 |
209 | 209 | South Carolina | CBSA | Columbia, South Carolina | 8 | 2,064 | 743 | 808,377 | 59,820 | 8,255 | 3,649 | 5.8 | 16 | 159,048 | 19.70% | 11,770 | 1,624 | 718 | 1.1 | 3.2 |
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 |
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 |
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 |
170 | 170 | Ohio | CBSA | Columbus, Ohio | 23 | 5,668 | 2040 | 2,023,695 | 149,753 | 20,666 | 9,135 | 5.3 | 14.6 | 360,880 | 17.80% | 26,705 | 3,685 | 1,629 | 0.9 | 2.6 |
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 |
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 |
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 |
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 |
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 |
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 |
443 | 443 | Texas | No clean match | Dallas-Plano-Irving, Texas | 80 | 10,748 | No clean match | |||||||||||||
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 |
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 );