CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by PatientsPerAvailableBed_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
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
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
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
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
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
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
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
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
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
146 146 Mississippi CBSA Gulfport-Biloxi, Mississippi 8 1,191 429 406,063.00 30,049 4,147 1,833 5 13.9 83,387.00 20.50% 6,171 852 376 1 2.9
420 420 Georgia CBSA Hinesville, Georgia 1 25 9 79,977 5,918 817 361 47.1 130.9 9,845 12.30% 729 101 44 5.8 16.1
141 141 Iowa CBSA Davenport-Moline-Rock Island, Iowa 3 504 181 171,493 12,690 1,751 774 5 14 36,851 21.50% 2,727 376 166 1.1 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
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
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
148 148 Colorado CBSA Pueblo, Colorado 2 475 171 163,368 12,089 1,668 737 5.1 14.1 39,318 24.10% 2,910 402 177 1.2 3.4
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
150 150 Michigan MD Detroit-Dearborn-Livonia, Michigan 19 5,094 1834 1,753,893.00 129,788 17,911 7,917 5.1 14.1 386,924.00 22.10% 28,632 3,951 1,747 1.1 3.1
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
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
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
155 155 Florida CBSA Jacksonville, Florida 14 4,158 1497 1,447,884.00 107,143 14,786 6,536 5.1 14.2 297,685.00 20.60% 22,029 3,040 1,344 1.1 2.9
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
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
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
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
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
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
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
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
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
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
164 164 Indiana CBSA Columbus, Indiana 1 229 82 81,024 5,996 827 366 5.2 14.5 16,862 20.80% 1,248 172 76 1.1 3
167 167 Michigan CBSA Jackson, Michigan 2 448 161 158,989.00 11,765 1,624 718 5.2 14.5 36,118.00 22.70% 2,673 369 163 1.2 3.3
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
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
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
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
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
174 174 Ohio CBSA Canton-Massillon, Ohio 5 1,118 402 402,098 29,755 4,106 1,815 5.3 14.7 101,911 25.30% 7,541 1,041 460 1.3 3.7
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
175 175 Arkansas CBSA Pine Bluff, Arkansas 1 258 93 93,590 6,926 956 422 5.3 14.8 20,606 22.00% 1,525 210 93 1.2 3.3
176 176 Colorado CBSA Grand Junction, Colorado 3 412 148 148,798 11,011 1,520 672 5.3 14.8 35,763 24.00% 2,646 365 161 1.3 3.6
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
178 178 Georgia CBSA Athens-Clarke County, Georgia 3 561 202 202,780 15,006 2,071 915 5.3 14.8 35,109 17.30% 2,598 359 158 0.9 2.6
179 179 Iowa CBSA Cedar Rapids, Iowa 4 734 264 266,122 19,693 2,718 1,201 5.3 14.8 56,966 21.40% 4,215 582 257 1.1 3.2
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
182 182 New York CBSA Glens Falls, New York 1 349 126 126,884 9,389 1,296 573 5.4 14.8 33,378 26.30% 2,470 341 151 1.4 3.9
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
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
184 184 Illinois CBSA Davenport-Moline-Rock Island, Illinois 5 578 208 211,648 15,662 2,161 955 5.4 15 53,321 25.20% 3,946 545 241 1.4 3.8
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
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
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
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
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
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
190 190 Florida CBSA Naples-Marco Island, Florida 3 956 344 356,774.00 26,401 3,643 1,610 5.5 15.3 132,129.00 37.00% 9,778 1,349 596 2 5.7
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
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
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
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
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
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
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
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
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
201 201 Idaho CBSA Coeur dAlene, Idaho 3 362 130 138,494 10,249 1,414 625 5.6 15.7             0
203 203 Pennsylvania CBSA Reading, Pennsylvania 5 1,080 389 415,500.00 30,747 4,243 1,876 5.7 15.7 93,051.00 22.40% 6,886 950 420 1.3 3.5
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
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
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
206 206 Florida MD Fort Lauderdale-Pompano Beach-Sunrise, Florida 17 5,003 1801 1,951,260 144,393 19,926 8,808 5.7 16             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
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
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
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
212 212 Illinois CBSA Rockford, Illinois 4 864 311 341,150 25,245 3,484 1,540 5.8 16.2 75,762 22.20% 5,606 774 342 1.3 3.6
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
213 213 New York CBSA Binghamton, New York 2 618 222 245,446 18,163 2,506 1,108 5.8 16.3 60,335 24.60% 4,465 616 272 1.4 4
215 215 Arizona CBSA Lake Havasu City-Kingman, Arizona 4 512 184 204,691.00 15,147 2,090 924 5.9 16.4 73,559.00 35.90% 5,443 751 332 2.1 5.9
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
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
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
219 219 Arizona CBSA Flagstaff, Arizona 3 342 123 138,639.00 10,259 1,416 626 6 16.6 23,195.00 16.70% 1,716 237 105 1 2.8
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
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
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
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
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
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
226 226 Kansas CBSA Manhattan, Kansas 5 326 117 134,680 9,966 1,375 608 6.1 16.9 16,988 12.60% 1,257 173 77 0.8 2.1
227 227 North Carolina CBSA Rocky Mount, North Carolina 3 357 129 148157 10,964 1,513 669 6.1 16.9 35575 24.00% 2,633 363 161 1.5 4.1
228 228 Oregon CBSA Medford, Oregon 3 513 185 212,070 15,693 2,166 957 6.1 16.9 60,113 28.30% 4,448 614 271 1.7 4.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
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
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
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
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

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