CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Infected_60plus

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
8 8 Iowa CBSA Iowa City, Iowa 3 1,038 374 166,520 12,322 1,701 752 2.4 6.6 27,038 16.20% 2,001 276 122 0.4 1.1
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
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
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
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
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
60 60 North Dakota CBSA Fargo, North Dakota 3 708 255 170,620 12,626 1,742 770 3.5 9.9 27,710 16.20% 2,051 283 125 0.6 1.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
382 382 Oregon CBSA Grants Pass, Oregon 1 121 44 84,514 6,254 863 381 10.3 28.3 28,339 33.50% 2,097 289 128 3.4 9.5
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
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
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
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
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
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
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
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
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
261 261 Illinois CBSA Bloomington, Illinois 3 377 136 173,231 12,819 1,769 782 6.8 18.8 29,727 17.20% 2,200 304 134 1.2 3.2
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
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
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
11 11 North Carolina CBSA Greenville, North Carolina 1 974 351 176484 13,060 1,802 797 2.7 7.4 30269 17.20% 2,240 309 137 0.5 1.3
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
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
374 374 California CBSA El Centro, California 2 268 96 179,957 13,317 1,838 812 9.9 27.6 30,768 17.10% 2,277 314 139 1.7 4.7
160 160 Illinois CBSA Carbondale-Marion, Illinois 4 398 143 139,491 10,322 1,424 630 5.2 14.4 30,856 22.10% 2,283 315 139 1.1 3.2
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
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
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
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
119 119 Georgia CBSA Albany, Georgia 2 479 172 150,525 11,139 1,537 679 4.6 12.9 31,240 20.80% 2,312 319 141 1 2.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
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

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