CoronavirusHospitalCapacity_metros
Data source: Big Local News · About: big-local-datasette
448 rows sorted by Infected_allages descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
366 | 366 | Idaho | CBSA | Logan, Idaho | 1 | 20 | 7 | 13,120 | 971 | 134 | 59 | 9.7 | 27.6 | 2,458 | 18.70% | 182 | 25 | 11 | 1.8 | 5.1 |
379 | 379 | North Carolina | CBSA | Raleigh-Cary, North Carolina | 5 | 1,867 | 672 | 1,273,985 | 94,275 | 13,010 | 5,751 | 10 | 27.9 | 205,440 | 16.10% | 15,203 | 2,098 | 927 | 1.6 | 4.5 |
106 | 106 | Louisiana | CBSA | New Orleans-Metairie, Louisiana | 29 | 4,245 | 1528 | 1,260,660 | 93,289 | 12,874 | 5,691 | 4.4 | 12.1 | 259,419 | 20.60% | 19,197 | 2,649 | 1,171 | 0.9 | 2.5 |
143 | 143 | Virginia | CBSA | Richmond, Virginia | 16 | 3,671 | 1322 | 1,247,321.00 | 92,302 | 12,738 | 5,630 | 5 | 13.9 | 255,608.00 | 20.50% | 18,915 | 2,610 | 1,154 | 1 | 2.8 |
126 | 126 | Missouri | CBSA | Kansas City, Missouri | 22 | 3,783 | 1362 | 1,224,869 | 90,640 | 12,508 | 5,529 | 4.8 | 13.2 | 247,311 | 20.20% | 18,301 | 2,526 | 1,116 | 1 | 2.7 |
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 | ||||||
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 |
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 |
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 |
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 |
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 |
123 | 123 | Louisiana | CBSA | Hammond, Louisiana | 8 | 405 | 146 | 128,850 | 9,535 | 1,316 | 582 | 4.7 | 13 | 24,738 | 19.20% | 1,831 | 253 | 112 | 0.9 | 2.5 |
13 | 13 | Arkansas | CBSA | Jonesboro, Arkansas | 4 | 691 | 249 | 128,344 | 9,497 | 1,311 | 579 | 2.7 | 7.6 | 25,035 | 19.50% | 1,853 | 256 | 113 | 0.5 | 1.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 |
236 | 236 | Massachusetts | CBSA | Pittsfield, Massachusetts | 2 | 300 | 108 | 127,751 | 9,454 | 1,305 | 577 | 6.3 | 17.4 | 37,339 | 29.20% | 2,763 | 381 | 169 | 1.8 | 5.1 |
182 | 182 | New York | CBSA | Glens Falls, New York | 1 | 349 | 126 | 126,884 | 9,389 | 1,296 | 573 | 5.4 | 14.8 | 33,378 | 26.30% | 2,470 | 341 | 151 | 1.4 | 3.9 |
395 | 395 | Arizona | CBSA | Sierra Vista-Douglas, Arizona | 4 | 160 | 58 | 126,516.00 | 9,362 | 1,292 | 571 | 11.6 | 32.1 | 35,231.00 | 27.80% | 2,607 | 360 | 159 | 3.2 | 8.9 |
52 | 52 | Texas | CBSA | Sherman-Denison, Texas | 5 | 556 | 200 | 126,146 | 9,335 | 1,288 | 569 | 3.3 | 9.3 | 29,807 | 23.60% | 2,206 | 304 | 135 | 0.8 | 2.2 |
350 | 350 | North Carolina | CBSA | New Bern, North Carolina | 1 | 208 | 75 | 125,953 | 9,321 | 1,286 | 569 | 8.9 | 24.7 | 31,787 | 25.20% | 2,352 | 325 | 143 | 2.3 | 6.2 |
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 |
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 |
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 |
413 | 413 | North Carolina | CBSA | Myrtle Beach-Conway-North Myrtle Beach, North Carolina | 2 | 79 | 28 | 122,586 | 9,071 | 1,252 | 553 | 22.9 | 64.5 | 46,285 | 37.80% | 3,425 | 473 | 209 | 8.6 | 24.4 |
244 | 244 | Iowa | CBSA | Omaha-Council Bluffs, Iowa | 3 | 278 | 100 | 122,416 | 9,059 | 1,250 | 553 | 6.5 | 18 | 28,628 | 23.40% | 2,118 | 292 | 129 | 1.5 | 4.2 |
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 |
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 |
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 |
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 |
230 | 230 | Utah | CBSA | Salt Lake City, Utah | 17 | 2,817 | 1014 | 1,170,057 | 86,584 | 11,949 | 5,282 | 6.1 | 17 | 172,787 | 14.80% | 12,786 | 1,765 | 780 | 0.9 | 2.5 |
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 |
247 | 247 | Ohio | CBSA | Mansfield, Ohio | 2 | 274 | 99 | 121,533 | 8,993 | 1,241 | 549 | 6.5 | 18.1 | 30,674 | 25.20% | 2,270 | 313 | 138 | 1.6 | 4.6 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
130 | 130 | Kentucky | CBSA | Owensboro, Kentucky | 1 | 360 | 130 | 117,319 | 8,682 | 1,198 | 530 | 4.8 | 13.3 | 26,490 | 22.60% | 1,960 | 271 | 120 | 1.1 | 3 |
419 | 419 | Florida | CBSA | The Villages, Florida | 1 | 40 | 14 | 116,754.00 | 8,640 | 1,192 | 527 | 43 | 122.8 | 74,936.00 | 64.20% | 5,545 | 765 | 338 | 27.6 | 78.8 |
385 | 385 | Connecticut | CBSA | Worcester, Connecticut | 2 | 161 | 58 | 116,674 | 8,634 | 1,191 | 527 | 10.7 | 29.6 | 25,482 | 21.80% | 1,886 | 260 | 115 | 2.3 | 6.5 |
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 |
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 |
113 | 113 | Indiana | CBSA | Muncie, Indiana | 2 | 376 | 135 | 115,938 | 8,579 | 1,184 | 523 | 4.5 | 12.6 | 25,540 | 22.00% | 1,890 | 261 | 115 | 1 | 2.8 |
86 | 86 | Washington | CBSA | Wenatchee, Washington | 4 | 430 | 155 | 115,723 | 8,564 | 1,182 | 522 | 4 | 11 | 27,556 | 23.80% | 2,039 | 281 | 124 | 0.9 | 2.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 |
101 | 101 | Pennsylvania | CBSA | Williamsport, Pennsylvania | 3 | 394 | 142 | 115,398.00 | 8,539 | 1,178 | 521 | 4.3 | 12 | 28,691.00 | 24.90% | 2,123 | 293 | 130 | 1.1 | 3 |
373 | 373 | Wisconsin | CBSA | Sheboygan, Wisconsin | 2 | 173 | 62 | 115,094.00 | 8,517 | 1,175 | 520 | 9.8 | 27.3 | 27,003.00 | 23.50% | 1,998 | 276 | 122 | 2.3 | 6.4 |
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 |
138 | 138 | Pennsylvania | CBSA | Youngstown-Warren-Boardman, Pennsylvania | 4 | 340 | 122 | 113,623.00 | 8,408 | 1,160 | 513 | 4.9 | 13.7 | 31,083.00 | 27.40% | 2,300 | 317 | 140 | 1.3 | 3.7 |
15 | 15 | Kentucky | CBSA | Huntington-Ashland, Kentucky | 2 | 599 | 216 | 111,883 | 8,279 | 1,143 | 505 | 2.8 | 7.6 | 28,722 | 25.70% | 2,125 | 293 | 130 | 0.7 | 2 |
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 |
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 |
234 | 234 | Indiana | CBSA | Michigan City-La Porte, Indiana | 2 | 262 | 94 | 110,839 | 8,202 | 1,132 | 500 | 6.2 | 17.4 | 25,713 | 23.20% | 1,903 | 263 | 116 | 1.4 | 4 |
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 |
157 | 157 | New York | CBSA | Rochester, New York | 10 | 3,108 | 1119 | 1,080,653 | 79,968 | 11,036 | 4,878 | 5.1 | 14.2 | 247,834 | 22.90% | 18,340 | 2,531 | 1,119 | 1.2 | 3.3 |
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 |
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 |
232 | 232 | Michigan | CBSA | Grand Rapids-Kentwood, Michigan | 11 | 2,491 | 897 | 1,043,722.00 | 77,235 | 10,658 | 4,711 | 6.2 | 17.1 | 197,462.00 | 18.90% | 14,612 | 2,016 | 891 | 1.2 | 3.2 |
112 | 112 | Tennessee | CBSA | Memphis, Tennessee | 13 | 3,406 | 1226 | 1,038,617 | 76,858 | 10,606 | 4,688 | 4.5 | 12.5 | 191,995 | 18.50% | 14,208 | 1,961 | 867 | 0.8 | 2.3 |
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 | ||||||
195 | 195 | Arizona | CBSA | Tucson, Arizona | 12 | 2,654 | 955 | 1,007,257.00 | 74,537 | 10,286 | 4,547 | 5.6 | 15.5 | 245,814.00 | 24.40% | 18,190 | 2,510 | 1,110 | 1.4 | 3.8 |
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 |
423 | 423 | Michigan | CBSA | Grand Rapids-Wyoming, Michigan | 1 | 39 | 14 | 988,938 | 73,181 | 10,099 | 4,464 | 373.4 | 1040.2 | |||||||
120 | 120 | Oklahoma | CBSA | Tulsa, Oklahoma | 26 | 3,111 | 1120 | 977,869 | 72,362 | 9,986 | 4,414 | 4.6 | 12.9 | 198,300 | 20.30% | 14,674 | 2,025 | 895 | 0.9 | 2.6 |
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 |
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 |
24 | 24 | Illinois | CBSA | Decatur, Illinois | 2 | 534 | 192 | 107,587 | 7,961 | 1,099 | 486 | 3 | 8.3 | 27,263 | 25.30% | 2,017 | 278 | 123 | 0.8 | 2.1 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
9 | 9 | Alabama | CBSA | Gadsden, Alabama | 3 | 603 | 217 | 103,132 | 7,632 | 1,053 | 466 | 2.5 | 7 | 25,122 | 24.40% | 1,859 | 257 | 113 | 0.6 | 1.7 |
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 |
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 |
411 | 411 | Pennsylvania | CBSA | Gettysburg, Pennsylvania | 1 | 76 | 27 | 101,589.00 | 7,518 | 1,037 | 459 | 19.7 | 55.4 | 26,312.00 | 25.90% | 1,947 | 269 | 119 | 5.1 | 14.4 |
177 | 177 | Florida | CBSA | Sebring-Avon Park, Florida | 2 | 277 | 100 | 100,177.00 | 7,413 | 1,023 | 452 | 5.3 | 14.8 | 41,387.00 | 41.30% | 3,063 | 423 | 187 | 2.2 | 6.1 |
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 |
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 |
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 |
36 | 36 | Arkansas | CBSA | Hot Springs, Arkansas | 3 | 449 | 162 | 97,994 | 7,252 | 1,001 | 442 | 3.2 | 8.9 | 28,731 | 29.30% | 2,126 | 293 | 130 | 0.9 | 2.6 |
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 |
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 |
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 |
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 |
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 |
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 |
231 | 231 | South Carolina | CBSA | Greenville-Anderson, South Carolina | 14 | 2,096 | 755 | 872,463 | 64,562 | 8,910 | 3,938 | 6.1 | 17 | 187,692 | 21.50% | 13,889 | 1,917 | 847 | 1.3 | 3.7 |
115 | 115 | Kansas | CBSA | Kansas City, Kansas | 19 | 2,793 | 1005 | 863,961 | 63,933 | 8,823 | 3,900 | 4.6 | 12.7 | 162,913 | 18.90% | 12,056 | 1,664 | 735 | 0.9 | 2.4 |
196 | 196 | Connecticut | CBSA | New Haven-Milford, Connecticut | 9 | 2,272 | 818 | 862,127 | 63,797 | 8,804 | 3,892 | 5.6 | 15.5 | 194,911 | 22.60% | 14,423 | 1,990 | 880 | 1.3 | 3.5 |
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 |
393 | 393 | California | CBSA | Oxnard-Thousand Oaks-Ventura, California | 7 | 1,087 | 391 | 847,834 | 62,740 | 8,658 | 3,827 | 11.5 | 31.9 | 167,777 | 19.80% | 12,415 | 1,713 | 757 | 2.3 | 6.3 |
162 | 162 | Tennessee | CBSA | Knoxville, Tennessee | 11 | 2,390 | 860 | 839,548 | 62,127 | 8,573 | 3,790 | 5.2 | 14.4 | 198,586 | 23.70% | 14,695 | 2,028 | 896 | 1.2 | 3.4 |
205 | 205 | Texas | CBSA | McAllen-Edinburg-Mission, Texas | 8 | 2,187 | 787 | 839,539 | 62,126 | 8,573 | 3,790 | 5.7 | 15.7 | 119,536 | 14.20% | 8,846 | 1,221 | 540 | 0.8 | 2.2 |
245 | 245 | Texas | CBSA | El Paso, Texas | 12 | 1,897 | 683 | 838,527 | 62,051 | 8,563 | 3,785 | 6.5 | 18.1 | 133,833 | 16.00% | 9,904 | 1,367 | 604 | 1 | 2.9 |
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 |
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 |
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 );