CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Infected_allages
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
11 | 11 | North Carolina | CBSA | Greenville, North Carolina | 1 | 974 | 351 | 176484 | 13,060 | 1,802 | 797 | 2.7 | 7.4 | 30269 | 17.20% | 2,240 | 309 | 137 | 0.5 | 1.3 |
73 | 73 | Missouri | CBSA | Joplin, Missouri | 5 | 697 | 251 | 176,759 | 13,080 | 1,805 | 798 | 3.7 | 10.4 | 37,664 | 21.30% | 2,787 | 385 | 170 | 0.8 | 2.2 |
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 |
76 | 76 | Tennessee | CBSA | Jackson, Tennessee | 2 | 700 | 252 | 178,760 | 13,228 | 1,825 | 807 | 3.8 | 10.4 | 40,244 | 22.50% | 2,978 | 411 | 182 | 0.8 | 2.4 |
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 |
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 |
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 |
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 |
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 |
197 | 197 | Indiana | CBSA | Terre Haute, Indiana | 5 | 493 | 177 | 187,704 | 13,890 | 1,917 | 847 | 5.6 | 15.6 | 41,436 | 22.10% | 3,066 | 423 | 187 | 1.2 | 3.4 |
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 |
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 |
38 | 38 | Georgia | CBSA | Gainesville, Georgia | 1 | 887 | 319 | 192,865 | 14,272 | 1,970 | 871 | 3.2 | 8.9 | 36,793 | 19.10% | 2,723 | 376 | 166 | 0.6 | 1.7 |
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 |
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 |
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 |
93 | 93 | Minnesota | MD | St Cloud, Minnesota | 4 | 711 | 256 | 199,801 | 14,785 | 2,040 | 902 | 4.1 | 11.5 | 0 | ||||||
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 |
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 |
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 |
166 | 166 | Tennessee | CBSA | Nashville-Davidson-Murfreesboro-Franklin, Tennessee | 28 | 5,467 | 1968 | 1,930,961 | 142,891 | 19,719 | 8,716 | 5.2 | 14.4 | 0 | ||||||
206 | 206 | Florida | MD | Fort Lauderdale-Pompano Beach-Sunrise, Florida | 17 | 5,003 | 1801 | 1,951,260 | 144,393 | 19,926 | 8,808 | 5.7 | 16 | 0 | ||||||
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 |
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 |
187 | 187 | Indiana | CBSA | Indianapolis-Carmel-Anderson, Indiana | 28 | 5,395 | 1942 | 1,989,032 | 147,188 | 20,312 | 8,978 | 5.4 | 15.1 | 364,107 | 18.30% | 26,944 | 3,718 | 1,644 | 1 | 2.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 |
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 |
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 |
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 |
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 |
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 |
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 |
31 | 31 | Louisiana | CBSA | Monroe, Louisiana | 12 | 963 | 347 | 205,260 | 15,189 | 2,096 | 927 | 3.1 | 8.7 | 42,814 | 20.90% | 3,168 | 437 | 193 | 0.7 | 1.8 |
79 | 79 | Louisiana | CBSA | Lake Charles, Louisiana | 8 | 791 | 285 | 205,559 | 15,211 | 2,099 | 928 | 3.8 | 10.6 | 40,933 | 19.90% | 3,029 | 418 | 185 | 0.8 | 2.1 |
17 | 17 | South Carolina | CBSA | Florence, South Carolina | 7 | 1,098 | 395 | 206,109 | 15,252 | 2,105 | 930 | 2.8 | 7.7 | 46,691 | 22.70% | 3,455 | 477 | 211 | 0.6 | 1.7 |
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 |
82 | 82 | Arkansas | CBSA | Fort Smith, Arkansas | 6 | 782 | 282 | 207,284 | 15,339 | 2,117 | 936 | 3.9 | 10.8 | 45,036 | 21.70% | 3,333 | 460 | 203 | 0.8 | 2.4 |
64 | 64 | Illinois | CBSA | Springfield, Illinois | 2 | 855 | 308 | 210,550 | 15,581 | 2,150 | 950 | 3.6 | 10.1 | 48,347 | 23.00% | 3,578 | 494 | 218 | 0.8 | 2.3 |
186 | 186 | Louisiana | CBSA | Houma-Thibodaux, Louisiana | 7 | 577 | 208 | 211,179 | 15,627 | 2,157 | 953 | 5.4 | 15 | 40,792 | 19.30% | 3,019 | 417 | 184 | 1 | 2.9 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
3 | 3 | Minnesota | CBSA | Rochester, Minnesota | 4 | 1,576 | 567 | 214,485 | 15,872 | 2,190 | 968 | 2 | 5.6 | 45,493 | 21.20% | 3,366 | 465 | 205 | 0.4 | 1.2 |
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 |
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 |
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 |
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 |
91 | 91 | Pennsylvania | MD | Philadelphia, Pennsylvania | 27 | 7,855 | 2828 | 2148889 | 159,018 | 21,944 | 9,700 | 4 | 11.2 | 436433 | 20.30% | 32,296 | 4,457 | 1,970 | 0.8 | 2.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 |
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 |
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 |
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 |
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 |
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 |
214 | 214 | Texas | CBSA | San Antonio-New Braunfels, Texas | 26 | 6,009 | 2163 | 2,377,507 | 175,936 | 24,279 | 10,732 | 5.8 | 16.2 | 414,889 | 17.50% | 30,702 | 4,237 | 1,873 | 1 | 2.8 |
168 | 168 | Florida | CBSA | Orlando-Kissimmee-Sanford, Florida | 14 | 6,665 | 2399 | 2,390,859.00 | 176,924 | 24,415 | 10,792 | 5.3 | 14.7 | 463,617.00 | 19.40% | 34,308 | 4,734 | 2,093 | 1 | 2.8 |
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 |
418 | 418 | Maryland | CBSA | Washington-Arlington-Alexandria, Maryland | 6 | 863 | 311 | 2,437,309 | 180,361 | 24,890 | 11,002 | 41.6 | 115.4 | 459,996 | 18.90% | 34,040 | 4,697 | 2,076 | 7.8 | 21.8 |
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 |
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 |
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 |
243 | 243 | Michigan | MD | Warren-Troy-Farmington Hills, Michigan | 24 | 5,847 | 2105 | 2,572,549 | 190,369 | 26,271 | 11,612 | 6.5 | 18 | 0 | ||||||
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 |
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 |
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 |
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 );