CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Infected_60plus
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47 | 47 | District of Columbia | MD | District of Columbia, District of Columbia | 10 | 3,114 | 1121 | 702,455 | 51,982 | 7,173 | 3,171 | 3.3 | 9.2 | 0 | ||||||
93 | 93 | Minnesota | MD | St Cloud, Minnesota | 4 | 711 | 256 | 199,801 | 14,785 | 2,040 | 902 | 4.1 | 11.5 | 0 | ||||||
102 | 102 | Combined | CBSA | St Louis, Missouri & Illinois | 43 | 9,555 | 3440 | 2,817,355 | 208,484 | 28,771 | 12,718 | 4.3 | 12.1 | 0 | ||||||
132 | 132 | Combined | CBSA | Louisville-Jefferson County, Kentucky & Indiana | 15 | 3,701 | 1332 | 1,222,216 | 90,444 | 12,481 | 5,517 | 4.9 | 13.5 | 0 | ||||||
154 | 154 | California | MD | San Francisco-San Mateo-Redwood City, California | 17 | 4,747 | 1709 | 1,652,850 | 122,311 | 16,879 | 7,461 | 5.1 | 14.2 | 0 | ||||||
159 | 159 | Florida | CBSA | Tampa-St Petersburg-Clearwater, Florida | 34 | 8,984 | 3234 | 3,142,663 | 232,557 | 32,093 | 14,186 | 5.2 | 14.3 | 0 | ||||||
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 | ||||||
183 | 183 | Florida | MD | Miami-Miami Beach-Kendall, Florida | 23 | 7,542 | 2715 | 2,761,581 | 204,357 | 28,201 | 12,466 | 5.4 | 15 | 0 | ||||||
191 | 191 | Florida | MD | West Palm Beach-Boca Raton-Boynton Beach, Florida | 15 | 3,987 | 1435 | 1,485,941 | 109,960 | 15,174 | 6,708 | 5.5 | 15.2 | 0 | ||||||
201 | 201 | Idaho | CBSA | Coeur dAlene, Idaho | 3 | 362 | 130 | 138,494 | 10,249 | 1,414 | 625 | 5.6 | 15.7 | 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 | ||||||
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 | ||||||
246 | 246 | Florida | CBSA | Port St Lucie, Florida | 4 | 1,088 | 392 | 482,040 | 35,671 | 4,923 | 2,176 | 6.5 | 18.1 | 0 | ||||||
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 | ||||||
290 | 290 | Delaware | MD | Wilmington, Delaware | 4 | 1,473 | 530 | 724,768 | 53,633 | 7,401 | 3,272 | 7.2 | 20.1 | 0 | ||||||
311 | 311 | Utah | CBSA | St George, Utah | 1 | 263 | 95 | 138,115 | 10,221 | 1,410 | 623 | 7.7 | 21.4 | 0 | ||||||
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 | ||||||
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 | ||||||
360 | 360 | California | MD | Oakland-Berkeley-Livermore, California | 20 | 4,372 | 1574 | 2,816,968 | 208,456 | 28,767 | 12,716 | 9.5 | 26.4 | 0 | ||||||
371 | 371 | California | MD | San Rafael, California | 3 | 391 | 141 | 259,666 | 19,215 | 2,652 | 1,172 | 9.8 | 27.1 | 0 | ||||||
423 | 423 | Michigan | CBSA | Grand Rapids-Wyoming, Michigan | 1 | 39 | 14 | 988,938 | 73,181 | 10,099 | 4,464 | 373.4 | 1040.2 | |||||||
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 | |||||||||||||
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
226 | 226 | Kansas | CBSA | Manhattan, Kansas | 5 | 326 | 117 | 134,680 | 9,966 | 1,375 | 608 | 6.1 | 16.9 | 16,988 | 12.60% | 1,257 | 173 | 77 | 0.8 | 2.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 |
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 |
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 |
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 |
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 |
16 | 16 | Ohio | CBSA | Weirton-Steubenville, Ohio | 3 | 359 | 129 | 67,349 | 4,984 | 688 | 304 | 2.8 | 7.7 | 18,775 | 27.90% | 1,389 | 192 | 85 | 0.8 | 2.1 |
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 |
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 |
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 |
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 |
6 | 6 | Montana | CBSA | Great Falls, Montana | 2 | 522 | 188 | 81,816 | 6,054 | 836 | 369 | 2.3 | 6.4 | 19,330 | 23.60% | 1,430 | 197 | 87 | 0.5 | 1.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 |
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 |
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 |
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 |
4 | 4 | Texas | CBSA | Texarkana, Texas | 5 | 672 | 242 | 93,635 | 6,929 | 956 | 423 | 2.1 | 5.7 | 20,099 | 21.50% | 1,487 | 205 | 91 | 0.4 | 1.2 |
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 |
78 | 78 | Indiana | CBSA | Kokomo, Indiana | 3 | 318 | 114 | 82,457 | 6,102 | 842 | 372 | 3.8 | 10.6 | 20,461 | 24.80% | 1,514 | 209 | 92 | 0.9 | 2.6 |
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 |
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 |
89 | 89 | Iowa | CBSA | Sioux City, Iowa | 3 | 374 | 135 | 102,397 | 7,577 | 1,046 | 462 | 4 | 11.2 | 20,666 | 20.20% | 1,529 | 211 | 93 | 0.8 | 2.3 |
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 |
7 | 7 | Georgia | CBSA | Rome, Georgia | 3 | 602 | 217 | 96,471 | 7,139 | 985 | 435 | 2.4 | 6.5 | 20,941 | 21.70% | 1,550 | 214 | 95 | 0.5 | 1.4 |
33 | 33 | New York | CBSA | Elmira, New York | 2 | 407 | 147 | 86,883 | 6,429 | 887 | 392 | 3.1 | 8.7 | 21,007 | 24.20% | 1,555 | 215 | 95 | 0.8 | 2.1 |
2 | 2 | West Virginia | CBSA | Wheeling, West Virginia | 4 | 614 | 221 | 74,912 | 5,543 | 765 | 338 | 1.8 | 5 | 21,297 | 28.40% | 1,576 | 217 | 96 | 0.5 | 1.4 |
10 | 10 | Texas | CBSA | Victoria, Texas | 5 | 565 | 203 | 99,028 | 7,328 | 1,011 | 447 | 2.6 | 7.2 | 21,342 | 21.60% | 1,579 | 218 | 96 | 0.6 | 1.5 |
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 |
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 |
70 | 70 | Texas | CBSA | Odessa, Texas | 4 | 620 | 223 | 155,744 | 11,525 | 1,590 | 703 | 3.7 | 10.3 | 21,622 | 13.90% | 1,600 | 221 | 98 | 0.5 | 1.4 |
63 | 63 | Oklahoma | CBSA | Lawton, Oklahoma | 2 | 530 | 191 | 129,066 | 9,551 | 1,318 | 583 | 3.6 | 10 | 21,927 | 17.00% | 1,623 | 224 | 99 | 0.6 | 1.7 |
84 | 84 | Iowa | CBSA | Dubuque, Iowa | 3 | 360 | 130 | 96,571 | 7,146 | 986 | 436 | 4 | 10.9 | 22,155 | 22.90% | 1,639 | 226 | 100 | 0.9 | 2.5 |
171 | 171 | Montana | CBSA | Missoula, Montana | 2 | 318 | 114 | 114,231 | 8,453 | 1,167 | 516 | 5.3 | 14.8 | 22,759 | 19.90% | 1,684 | 232 | 103 | 1.1 | 2.9 |
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 |
219 | 219 | Arizona | CBSA | Flagstaff, Arizona | 3 | 342 | 123 | 138,639.00 | 10,259 | 1,416 | 626 | 6 | 16.6 | 23,195.00 | 16.70% | 1,716 | 237 | 105 | 1 | 2.8 |
53 | 53 | Virginia | CBSA | Winchester, Virginia | 1 | 485 | 175 | 111,300.00 | 8,236 | 1,137 | 502 | 3.4 | 9.4 | 23,506.00 | 21.10% | 1,739 | 240 | 106 | 0.7 | 2 |
42 | 42 | Illinois | CBSA | Kankakee, Illinois | 2 | 500 | 180 | 110,801 | 8,199 | 1,131 | 500 | 3.3 | 9.1 | 23,667 | 21.40% | 1,751 | 242 | 107 | 0.7 | 1.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 |
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 |
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 |
27 | 27 | Ohio | CBSA | Lima, Ohio | 5 | 508 | 183 | 104,157 | 7,708 | 1,064 | 470 | 3 | 8.4 | 24,080 | 23.10% | 1,782 | 246 | 109 | 0.7 | 1.9 |
85 | 85 | Texas | CBSA | San Angelo, Texas | 2 | 445 | 160 | 119,637 | 8,853 | 1,222 | 540 | 4 | 11 | 24,166 | 20.20% | 1,788 | 247 | 109 | 0.8 | 2.2 |
23 | 23 | Maine | CBSA | Lewiston-Auburn, Maine | 2 | 540 | 194 | 107,317 | 7,941 | 1,096 | 484 | 2.9 | 8.1 | 24,289 | 22.60% | 1,797 | 248 | 110 | 0.7 | 1.8 |
96 | 96 | Wisconsin | CBSA | La Crosse-Onalaska, Wisconsin | 2 | 414 | 149 | 117,582.00 | 8,701 | 1,201 | 531 | 4.2 | 11.6 | 24,464.00 | 20.80% | 1,810 | 250 | 110 | 0.9 | 2.4 |
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 |
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 );