CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by 60plus_PercentOfTotalPopulation

✎ 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
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
277 277 North Carolina CBSA Charlotte-Concord-Gastonia, North Carolina 19 4,365 1571 2081923 154,062 21,261 9,398 7 19.5 364756 17.50% 26,992 3,725 1,647 1.2 3.4
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
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
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
338 338 California CBSA Salinas, California 4 740 266 433,168 32,054 4,424 1,955 8.6 24 76,257 17.60% 5,643 779 344 1.5 4.2
341 341 Indiana CBSA Bloomington, Indiana 1 282 102 165,393 12,239 1,689 747 8.6 23.9 29,188 17.60% 2,160 298 132 1.5 4.2
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
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
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
170 170 Ohio CBSA Columbus, Ohio 23 5,668 2040 2,023,695 149,753 20,666 9,135 5.3 14.6 360,880 17.80% 26,705 3,685 1,629 0.9 2.6
222 222 Idaho CBSA Idaho Falls, Idaho 3 345 124 140,427 10,392 1,434 634 6 16.7 25,189 17.90% 1,864 257 114 1.1 3
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
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
40 40 Michigan CBSA Ann Arbor, Michigan 5 1,641 591 361,509.00 26,752 3,692 1,632 3.2 9 65,781.00 18.20% 4,868 672 297 0.6 1.6
346 346 Georgia CBSA Dalton, Georgia 2 239 86 143,407 10,612 1,464 647 8.8 24.5 26,145 18.20% 1,935 267 118 1.6 4.5
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
32 32 Nebraska CBSA Lincoln, Nebraska 8 1,526 549 323,402 23,932 3,303 1,460 3.1 8.7 59,068 18.30% 4,371 603 267 0.6 1.6
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
187 187 Indiana CBSA Indianapolis-Carmel-Anderson, Indiana 28 5,395 1942 1,989,032 147,188 20,312 8,978 5.4 15.1 364,107 18.30% 26,944 3,718 1,644 1 2.8
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
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
308 308 Mississippi CBSA Memphis, Mississippi 4 473 170 247,857.00 18,341 2,531 1,119 7.7 21.5 45,237.00 18.30% 3,348 462 204 1.4 3.9
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
87 87 Georgia CBSA Columbus, Georgia 4 974 351 263,754 19,518 2,693 1,191 4 11.1 48,520 18.40% 3,590 495 219 0.7 2
125 125 Oklahoma CBSA Oklahoma City, Oklahoma 31 4,225 1521 1,353,504 100,159 13,822 6,110 4.7 13.1 248,954 18.40% 18,423 2,542 1,124 0.9 2.4
135 135 California CBSA Madera, California 2 464 167 154,440 11,429 1,577 697 4.9 13.6 28,392 18.40% 2,101 290 128 0.9 2.5
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
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
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
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
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
289 289 Kentucky CBSA Elizabethtown-Fort Knox, Kentucky 2 308 111 150,253 11,119 1,534 678 7.2 19.9 27,818 18.50% 2,059 284 126 1.3 3.7
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
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
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
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
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
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
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
294 294 Colorado CBSA Boulder, Colorado 5 640 230 316,782 23,442 3,235 1,430 7.3 20.3 59,425 18.80% 4,397 607 268 1.4 3.8
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
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
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
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
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
19 19 Mississippi CBSA Hattiesburg, Mississippi 4 873 314 167,571.00 12,400 1,711 756 2.8 7.9 31,999.00 19.10% 2,368 327 144 0.5 1.5
38 38 Georgia CBSA Gainesville, Georgia 1 887 319 192,865 14,272 1,970 871 3.2 8.9 36,793 19.10% 2,723 376 166 0.6 1.7
61 61 Georgia CBSA Augusta-Richmond County, Georgia 8 1,645 592 397,192 29,392 4,056 1,793 3.6 9.9 75,957 19.10% 5,621 776 343 0.7 1.9
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
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
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
334 334 Indiana CBSA Elkhart-Goshen, Indiana 2 352 127 202,924 15,016 2,072 916 8.5 23.5 38,669 19.10% 2,862 395 175 1.6 4.5
67 67 Kentucky CBSA Bowling Green, Kentucky 4 680 245 169,250 12,525 1,728 764 3.7 10.2 32,441 19.20% 2,401 331 146 0.7 1.9
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
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
262 262 Nevada CBSA Las Vegas-Henderson-Paradise, Nevada 24 4,590 1652 2,112,436 156,320 21,572 9,536 6.8 18.8 405,618 19.20% 30,016 4,142 1,831 1.3 3.6
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
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
186 186 Louisiana CBSA Houma-Thibodaux, Louisiana 7 577 208 211,179 15,627 2,157 953 5.4 15 40,792 19.30% 3,019 417 184 1 2.9
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
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
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
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
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
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
140 140 Alabama CBSA Montgomery, Alabama 8 1,098 395 373,507 27,640 3,814 1,686 5 13.9 73,147 19.60% 5,413 747 330 1 2.7
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
320 320 Oregon CBSA Portland-Vancouver-Hillsboro, Oregon 17 3,552 1279 1,913,065 141,567 19,536 8,636 7.9 22 374,979 19.60% 27,748 3,829 1,693 1.6 4.3
323 323 New Mexico CBSA Las Cruces, New Mexico 4 395 142 213,849 15,825 2,184 965 8 22.2 41,981 19.60% 3,107 429 190 1.6 4.4
59 59 Indiana CBSA Fort Wayne, Indiana 10 1,697 611 401,228 29,691 4,097 1,811 3.5 9.7 79,036 19.70% 5,849 807 357 0.7 1.9
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
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
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
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
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
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
94 94 Michigan CBSA Kalamazoo-Portage, Michigan 4 921 332 259,830.00 19,227 2,653 1,173 4.2 11.5 51,450.00 19.80% 3,807 525 232 0.8 2.3
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
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
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
79 79 Louisiana CBSA Lake Charles, Louisiana 8 791 285 205,559 15,211 2,099 928 3.8 10.6 40,933 19.90% 3,029 418 185 0.8 2.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
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
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
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
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
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
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
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
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
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
91 91 Pennsylvania MD Philadelphia, Pennsylvania 27 7,855 2828 2148889 159,018 21,944 9,700 4 11.2 436433 20.30% 32,296 4,457 1,970 0.8 2.3
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
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
312 312 Colorado CBSA Fort Collins, Colorado 5 627 226 330,976 24,492 3,380 1,494 7.8 21.6 67,199 20.30% 4,973 686 303 1.6 4.4
25 25 Florida CBSA Gainesville, Florida 4 1,548 557 316,769.00 23,441 3,235 1,430 3 8.4 64,742.00 20.40% 4,791 661 292 0.6 1.7
151 151 Ohio CBSA Cincinnati, Ohio 20 4,815 1733 1,654,238 122,414 16,893 7,467 5.1 14.1 338,018 20.40% 25,013 3,452 1,526 1 2.9
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
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

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