CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Critical_allages

✎ View and edit SQL

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
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
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
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
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
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
400 400 Washington CBSA Lewiston, Washington 1 25 9 22,259 1,647 227 100 13.1 36.3 6,373 28.60% 472 65 29 3.8 10.4
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
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
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
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
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
300 300 Colorado CBSA Denver-Aurora-Lakewood, Colorado 26 5,527 1990 2,798,684 207,103 28,580 12,633 7.5 20.7 491,072 17.50% 36,339 5,015 2,217 1.3 3.6
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
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
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
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
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
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
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
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
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
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
347 347 Oklahoma CBSA Fort Smith, Oklahoma 2 69 25 41,364 3,061 422 187 8.8 24.4 9,667 23.40% 715 99 44 2.1 5.7
414 414 Wisconsin CBSA Duluth, Wisconsin 1 25 9 43,503.00 3,219 444 196 25.6 71.1 10,444.00 24.00% 773 107 47 6.2 17.1
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
158 158 Alabama CBSA Huntsville, Alabama 4 1,269 457 444,908 32,923 4,543 2,008 5.2 14.3 88,439 19.90% 6,544 903 399 1 2.8
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
169 169 Nevada CBSA Reno, Nevada 7 1,260 454 449,442 33,259 4,590 2,029 5.3 14.6 97,068 21.60% 7,183 991 438 1.1 3.1
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
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
386 386 Washington CBSA Portland-Vancouver-Hillsboro, Washington 2 647 233 468,972 34,704 4,789 2,117 10.7 29.6 96,088 20.50% 7,111 981 434 2.2 6.1
163 163 Florida CBSA Pensacola-Ferry Pass-Brent, Florida 7 1,348 485 476,702.00 35,276 4,868 2,152 5.2 14.5 102,496.00 21.50% 7,585 1,047 463 1.1 3.1
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
149 149 Louisiana CBSA Lafayette, Louisiana 18 1,415 509 487,633 36,085 4,980 2,201 5.1 14.1 90,414 18.50% 6,691 923 408 0.9 2.6
240 240 Arkansas CBSA Fayetteville-Springdale-Rogers, Arkansas 9 1,135 409 491,413 36,365 5,018 2,218 6.4 17.7 83,204 16.90% 6,157 850 376 1.1 3
39 39 Kentucky CBSA Lexington-Fayette, Kentucky 11 2,269 817 500,689 37,051 5,113 2,260 3.2 9 93,464 18.70% 6,916 954 422 0.6 1.7
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
378 378 North Carolina CBSA Fayetteville, North Carolina 3 754 271 514090 38,043 5,250 2,321 10 27.9 80286 15.60% 5,941 820 362 1.6 4.4
242 242 Maine CBSA Portland-South Portland, Maine 7 1,200 432 525,776 38,907 5,369 2,373 6.5 17.9 130,042 24.70% 9,623 1,328 587 1.6 4.4
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
281 281 California CBSA Modesto, California 6 1,113 401 535,684 39,641 5,470 2,418 7.1 19.7 92,698 17.30% 6,860 947 418 1.2 3.4
315 315 Pennsylvania CBSA Lancaster, Pennsylvania 5 1,007 363 536,494.00 39,701 5,479 2,422 7.8 21.8 122,633.00 22.90% 9,075 1,252 554 1.8 5
253 253 Michigan CBSA Lansing-East Lansing, Michigan 7 1203 433 540,709.00 40,012 5,522 2,441 6.6 18.4 110,858.00 20.50% 8,203 1,132 500 1.4 3.8
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
319 319 Massachusetts CBSA Providence-Warwick, Massachusetts 5 1,032 372 557,016 41,219 5,688 2,514 7.9 22 124,173 22.30% 9,189 1,268 561 1.8 4.9
98 98 Pennsylvania CBSA Harrisburg-Carlisle, Pennsylvania 8 1,974 711 565,008.00 41,811 5,770 2,550 4.2 11.7 130,412.00 23.10% 9,650 1,332 589 1 2.7
181 181 Florida CBSA Palm Bay-Melbourne-Titusville, Florida 9 1,556 560 568,183.00 42,046 5,802 2,565 5.4 14.9 170,919.00 30.10% 12,648 1,745 772 1.6 4.5
394 394 Utah CBSA Provo-Orem, Utah 7 748 269 587,190 43,452 5,996 2,651 11.6 32.1 61,165 10.40% 4,526 625 276 1.2 3.3
43 43 Mississippi CBSA Jackson, Mississippi 16 2670 961 596,832.00 44,166 6,095 2,694 3.3 9.1 112,915.00 18.90% 8,356 1,153 510 0.6 1.7
68 68 North Carolina CBSA Durham-Chapel Hill, North Carolina 8 2,425 873 608784 45,050 6,217 2,748 3.7 10.3 121204 19.90% 8,969 1,238 547 0.7 2
220 220 Florida CBSA Deltona-Daytona Beach-Ormond Beach, Florida 6 1,537 553 623,675.00 46,152 6,369 2,815 6 16.6 199,527.00 32.00% 14,765 2,038 901 1.9 5.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
200 200 Wisconsin CBSA Madison, Wisconsin 11 1,681 605 640,072.00 47,365 6,536 2,889 5.6 15.6 122,030.00 19.10% 9,030 1,246 551 1.1 3
336 336 Utah CBSA Ogden-Clearfield, Utah 9 1,108 399 642,274 47,528 6,559 2,899 8.5 23.7 95,645 14.90% 7,078 977 432 1.3 3.5
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
218 218 Florida CBSA Lakeland-Winter Haven, Florida 5 1,617 582 652,256.00 48,267 6,661 2,944 5.9 16.5 169,578.00 26.00% 12,549 1,732 765 1.5 4.3
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
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
221 221 Iowa CBSA Des Moines-West Des Moines, Iowa 9 1,625 585 659,902 48,833 6,739 2,979 6 16.6 120,848 18.30% 8,943 1,234 546 1.1 3
340 340 California CBSA Riverside-San Bernardino-Ontario, California 38 7,640 2750 4,476,222 331,240 45,711 20,206 8.6 24 767,628 17.10% 56,804 7,839 3,465 1.5 4.1
298 298 Arizona CBSA Phoenix-Mesa-Chandler, Arizona 46 9104 3277 4,561,038.00 337,517 46,577 20,589 7.4 20.5 908,620.00 19.90% 67,238 9,279 4,102 1.5 4.1
202 202 Kentucky CBSA Evansville, Kentucky 1 121 44 46,252 3,423 472 209 5.6 15.5 10,871 23.50% 804 111 49 1.3 3.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
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
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
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
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
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
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
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
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
30 30 Oklahoma CBSA Enid, Oklahoma 3 300 108 62,421 4,619 637 282 3.1 8.5 13,092 21.00% 969 134 59 0.6 1.8
229 229 Texas CBSA Houston-The Woodlands-Sugar Land, Texas 89 16,014 5765 6,636,208 491,079 67,769 29,956 6.1 17 1,011,707 15.20% 74,866 10,332 4,567 0.9 2.6
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
348 348 New York CBSA Poughkeepsie-Newburgh-Middletown, New York 6 1,120 403 673,859 49,866 6,881 3,042 8.9 24.6 137,318 20.40% 10,162 1,402 620 1.8 5
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
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
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
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
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
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
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
290 290 Delaware MD Wilmington, Delaware 4 1,473 530 724,768 53,633 7,401 3,272 7.2 20.1             0
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
58 58 Arkansas CBSA Little Rock-North Little Rock-Conway, Arkansas 17 3,103 1117 730,346 54,046 7,458 3,297 3.5 9.6 144,815 19.80% 10,716 1,479 654 0.7 1.9
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
263 263 North Carolina CBSA Greensboro-High Point, North Carolina 6 1,636 589 751590 55,618 7,675 3,393 6.8 18.8 159515 21.20% 11,804 1,629 720 1.4 4
153 153 Florida CBSA North Port-Sarasota-Bradenton, Florida 9 2,222 800 768,381.00 56,860 7,847 3,468 5.1 14.1 294,621.00 38.30% 21,802 3,009 1,330 2 5.4
156 156 Nebraska CBSA Omaha-Council Bluffs, Nebraska 15 2,273 818 791,774 58,591 8,086 3,574 5.1 14.3 138,052 17.40% 10,216 1,410 623 0.9 2.5
216 216 Ohio CBSA Dayton-Kettering, Ohio 11 1,994 718 800,893 59,266 8,179 3,615 5.9 16.4 186,578 23.30% 13,807 1,905 842 1.4 3.8
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
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
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
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
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
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
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

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