CoronavirusHospitalCapacity_metros

Table actions
AHA hospital beds data at state and metro areas provided by USA TODAY for use by journalists in Coronavirus reporting. Please cite the data from the American Hospital Association, U.S. Census, CDC and World Health Organization as the source of your analysis. If possible, in a tagline or credit of any story, share that "The figures come from a USA TODAY analysis of data from the American Hospital Association, U.S. Census, CDC and World Health Organization that was shared publicly via biglocalnews.stanford.edu." We ask this because it helps us show the impact we can have and that makes it easier to create ongoing support for Big Local News. Questions can be directed to Jayme Fraser, USA Today jfraser@gatehousemedia.com or biglocalnews@stanford.edu

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

448 rows sorted by State 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
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
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
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
107 107 Wisconsin CBSA Eau Claire, Wisconsin 6 554 199 165,833.00 12,272 1,693 749 4.4 12.3 35,231.00 21.20% 2,607 360 159 0.9 2.6
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
211 211 Wisconsin CBSA Milwaukee-Waukesha, Wisconsin 24 4,030 1451 1,575,101.00 116,557 16,085 7,110 5.8 16 320,694.00 20.40% 23,731 3,275 1,448 1.2 3.3
255 255 Wisconsin CBSA Oshkosh-Neenah, Wisconsin 4 375 135 169,540.00 12,546 1,731 765 6.7 18.5 35,586.00 21.00% 2,633 363 161 1.4 3.9
256 256 Wisconsin CBSA Green Bay, Wisconsin 6 698 251 315,847.00 23,373 3,225 1,426 6.7 18.5 65,088.00 20.60% 4,817 665 294 1.4 3.8
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
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
358 358 Wisconsin CBSA Janesville-Beloit, Wisconsin 3 256 92 161,226.00 11,931 1,646 728 9.3 25.8 34,912.00 21.70% 2,583 357 158 2 5.6
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
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
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
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
448 448 Wisconsin No clean match Lake County-Kenosha County, Wisconsin 2 273   No clean match                        
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
5 5 West Virginia CBSA Morgantown, West Virginia 4 958 345 137,475 10,173 1,404 621 2.1 5.9 25,481 18.50% 1,886 260 115 0.4 1.1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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                        
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
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
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
83 83 Virginia CBSA Roanoke, Virginia 3 1,182 426 313,069.00 23,167 3,197 1,413 3.9 10.8 81,216.00 25.90% 6,010 829 367 1 2.8
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
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
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
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
368 368 Virginia CBSA Blacksburg-Christiansburg, Virginia 4 252 91 166,269.00 12,304 1,698 751 9.7 26.9 33,140.00 19.90% 2,452 338 150 1.9 5.4
372 372 Virginia CBSA Kingsport-Bristol, Virginia 2 141 51 93,824.00 6,943 958 424 9.8 27.1 26,693.00 28.50% 1,975 273 120 2.8 7.7
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
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
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
311 311 Utah CBSA St George, Utah 1 263 95 138,115 10,221 1,410 623 7.7 21.4             0
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
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
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
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
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
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
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
54 54 Texas CBSA Abilene, Texas 6 731 263 169,000 12,506 1,726 763 3.4 9.5 33,416 19.80% 2,473 341 151 0.7 1.9
57 57 Texas CBSA Lubbock, Texas 9 1,332 480 309,722 22,919 3,163 1,398 3.4 9.5 51,984 16.80% 3,847 531 235 0.6 1.6
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
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
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
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
152 152 Texas CBSA Corpus Christi, Texas 6 1,239 446 425,351 31,476 4,344 1,920 5.1 14 81,128 19.10% 6,003 828 366 1 2.7
199 199 Texas CBSA Beaumont-Port Arthur, Texas 9 1,035 373 394,476 29,191 4,028 1,781 5.6 15.6 79,511 20.20% 5,884 812 359 1.1 3.1
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
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
207 207 Texas CBSA Brownsville-Harlingen, Texas 6 1,081 389 420,201 31,095 4,291 1,897 5.7 15.9 71,392 17.00% 5,283 729 322 1 2.7
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
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
239 239 Texas CBSA Killeen-Temple, Texas 6 1,008 363 432,797 32,027 4,420 1,954 6.3 17.6 62,605 14.50% 4,633 639 283 0.9 2.5
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
248 248 Texas CBSA Midland, Texas 4 372 134 165,430 12,242 1,689 747 6.5 18.2 25,575 15.50% 1,893 261 115 1 2.8
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
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
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
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
424 424 Texas CBSA Dallas-Fort Worth-Arlington, Texas 1 10 4 7,040,347 520,986 71,896 31,780 10367.6 25919 1,078,937 15.30% 79,841 11,018 4,870 1588.8 3972
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                        
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
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
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
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
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
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
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
388 388 Tennessee CBSA Morristown, Tennessee 2 185 67 139,294 10,308 1,422 629 11.1 30.6 34,544 24.80% 2,556 353 156 2.7 7.6
442 442 Tennessee No clean match Chattanooga Clarksville, Tennessee 5 1921   No clean match                        
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
45 45 South Dakota CBSA Rapid City, South Dakota 5 605 218 135,192 10,004 1,381 610 3.3 9.1 29,786 22.00% 2,204 304 134 0.7 2
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
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
147 147 South Carolina CBSA Myrtle Beach-Conway-North Myrtle Beach, South Carolina 4 906 326 310,186 22,954 3,168 1,400 5 14 90,290 29.10% 6,681 922 408 1.5 4.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

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