CoronavirusHospitalCapacity_metros

Table actions

Data source: Big Local News · About: big-local-datasette

448 rows sorted by Metro descending

✎ View and edit SQL

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
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
387 387 California CBSA Yuba City, California 2 233 84 170,227 12,597 1,738 768 10.8 29.8 31,546 18.50% 2,334 322 142 2 5.5
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
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
265 265 Pennsylvania CBSA York-Hanover, Pennsylvania 6 958 345 442,216.00 32,724 4,516 1,996 6.8 18.9 99,386.00 22.50% 7,355 1,015 449 1.5 4.2
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
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
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
180 180 North Carolina CBSA Winston-Salem, North Carolina 7 1,813 653 658195 48,706 6,721 2,971 5.3 14.8 146789 22.30% 10,862 1,499 663 1.2 3.3
316 316 West Virginia CBSA Winchester, West Virginia 1 44 16 23,412 1,732 239 106 7.8 21.6 6,811 29.10% 504 70 31 2.3 6.3
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
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
439 439 New Jersey No clean match Wilmington, New Jersey 2 222   No clean match                        
430 430 Maryland No clean match Wilmington, Maryland 1 109   No clean match                        
290 290 Delaware MD Wilmington, Delaware 4 1,473 530 724,768 53,633 7,401 3,272 7.2 20.1             0
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
137 137 Kansas CBSA Wichita, Kansas 16 1,898 683 634,763 46,972 6,482 2,865 4.9 13.7 125,055 19.70% 9,254 1,277 564 1 2.7
134 134 Texas CBSA Wichita Falls, Texas 6 456 164 150,940 11,170 1,541 681 4.9 13.5 30,983 20.50% 2,293 316 140 1 2.8
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
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
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
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
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
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
299 299 Wisconsin CBSA Wausau-Weston, Wisconsin 4 325 117 163,287.00 12,083 1,667 737 7.4 20.5 38,558.00 23.60% 2,853 394 174 1.7 4.9
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
118 118 Iowa CBSA Waterloo-Cedar Falls, Iowa 6 546 197 170,055 12,584 1,737 768 4.6 12.7 37,828 22.20% 2,799 386 171 1 2.8
416 416 West Virginia CBSA Washington-Arlington-Alexandria, West Virginia 1 25 9 55,673 4,120 569 251 32.8 91.1 11,916 21.40% 882 122 54 7 19.6
384 384 Virginia CBSA Washington-Arlington-Alexandria, Virginia 19 4,079 1468 2,937,931.00 217,407 30,002 13,262 10.6 29.5 475,124.00 16.20% 35,159 4,852 2,145 1.7 4.8
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
34 34 District of Columbia CBSA Washington-Arlington-Alexandria, District of Columbia 10 3,114 1121 672,391 49,757 6,866 3,035 3.2 8.8 113,026 16.80% 8,364 1,154 510 0.5 1.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
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
302 302 Washington CBSA Walla Walla, Washington 2 117 42 59,862 4,430 611 270 7.5 21 13,443 22.50% 995 137 61 1.7 4.7
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
392 392 California CBSA Visalia, California 2 595 214 458,809 33,952 4,685 2,071 11.4 31.6 69,266 15.10% 5,126 707 313 1.7 4.8
280 280 Virginia CBSA Virginia Beach-Norfolk-Newport News, Virginia 18 3,556 1280 1,707,283.00 126,339 17,435 7,707 7.1 19.6 326,159.00 19.10% 24,136 3,331 1,472 1.4 3.8
225 225 New Jersey CBSA Vineland-Bridgeton, New Jersey 2 376 135 154,952 11,466 1,582 699 6.1 16.9 30,141 19.50% 2,230 308 136 1.2 3.3
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
362 362 California CBSA Vallejo, California 4 672 242 434,981 32,189 4,442 1,964 9.5 26.5 90,069 20.70% 6,665 920 407 2 5.5
260 260 Georgia CBSA Valdosta, Georgia 3 315 113 143,969 10,654 1,470 650 6.7 18.8 24,673 17.10% 1,826 252 111 1.2 3.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
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
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
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
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
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
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
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
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
90 90 Ohio CBSA Toledo, Ohio 14 2,359 849 645,973 47,802 6,597 2,916 4 11.2 141,013 21.80% 10,435 1,440 637 0.9 2.4
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
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
417 417 Arkansas CBSA Texarkana, Arkansas 1 25 9 56,254 4,163 574 254 33.1 92 13,063 23.20% 967 133 59 7.7 21.3
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
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
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
447 447 Washington No clean match Tacoma-Lakewood, Washington 6 1,463   No clean match                        
142 142 New York CBSA Syracuse, New York 6 1,943 699 659,262 48,785 6,732 2,976 5 13.9 145,821 22.10% 10,791 1,489 658 1.1 3.1
313 313 South Carolina CBSA Sumter, South Carolina 2 268 96 141,535 10,474 1,445 639 7.8 21.7 33,021 23.30% 2,444 337 149 1.8 5.1
375 375 California CBSA Stockton, California 7 1,077 388 724,153 53,587 7,395 3,269 9.9 27.5 123,774 17.10% 9,159 1,264 559 1.7 4.7
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
284 284 Pennsylvania CBSA State College, Pennsylvania 2 333 120 160,646.00 11,888 1,641 725 7.1 19.7 29,386.00 18.30% 2,175 300 133 1.3 3.6
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
433 433 Missouri No clean match St Joseph, Missouri 1 352   No clean match                        
311 311 Utah CBSA St George, Utah 1 263 95 138,115 10,221 1,410 623 7.7 21.4             0
93 93 Minnesota MD St Cloud, Minnesota 4 711 256 199,801 14,785 2,040 902 4.1 11.5             0
279 279 Ohio CBSA Springfield, Ohio 2 283 102 135,520 10,028 1,384 612 7.1 19.6 33,970 25.10% 2,514 347 153 1.8 4.9
110 110 Missouri CBSA Springfield, Missouri 5 1,501 540 455,133 33,680 4,648 2,054 4.5 12.4 97,033 21.30% 7,180 991 438 1 2.6
237 237 Massachusetts CBSA Springfield, Massachusetts 9 1,636 589 701,311 51,897 7,162 3,166 6.3 17.5 158,285 22.60% 11,713 1,616 714 1.4 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
144 144 Washington CBSA Spokane-Spokane Valley, Washington 9 1,578 568 534,622 39,562 5,460 2,413 5 13.9 118,253 22.10% 8,751 1,208 534 1.1 3.1
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
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
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
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
194 194 South Dakota CBSA Sioux City, South Dakota 1 40 14 14,929 1,105 152 67 5.5 15.6 3,448 23.10% 255 35 16 1.3 3.6
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
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
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
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
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
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
128 128 Florida CBSA Sebastian-Vero Beach, Florida 3 454 163 147,981.00 10,951 1,511 668 4.8 13.4 57,277.00 38.70% 4,238 585 259 1.9 5.2
446 446 Washington No clean match Seattle-Bellevue-Kent, Washington 22 5,239   No clean match                        
139 139 Pennsylvania MD Scranton-Wilkes-Barre, Pennsylvania 10 1,651 594 555485 41,106 5,673 2,507 5 13.8 152608 27.50% 11,293 1,558 689 1.4 3.8
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
352 352 California CBSA Santa Rosa-Petaluma, California 8 821 296 500,943 37,070 5,116 2,261 9 24.9 124,291 24.80% 9,198 1,269 561 2.2 6.2
304 304 California CBSA Santa Maria-Santa Barbara, California 5 858 309 442,996 32,782 4,524 2,000 7.6 21.1 86,816 19.60% 6,424 887 392 1.5 4.1
376 376 New Mexico CBSA Santa Fe, New Mexico 1 219 79 147,514 10,916 1,506 666 9.9 27.5 42,681 28.90% 3,158 436 193 2.9 8
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
371 371 California MD San Rafael, California 3 391 141 259,666 19,215 2,652 1,172 9.8 27.1             0
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
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
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
328 328 California CBSA San Diego-Chula Vista-Carlsbad, California 18 5,750 2070 3,283,665 242,991 33,533 14,822 8.4 23.4 604,412 18.40% 44,726 6,172 2,728 1.5 4.3
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);