CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Critical_allages 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
381 381 Arizona CBSA Prescott Valley-Prescott, Arizona 3 320 115 220,972.00 16,352 2,257 997 10.2 28.3 85,127.00 38.50% 6,299 869 384 3.9 10.9
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
399 399 Delaware CBSA Salisbury, Delaware 2 254 91 215,551 15,951 2,201 973 12.5 34.9 71,832 33.30% 5,316 734 324 4.2 11.6
3 3 Minnesota CBSA Rochester, Minnesota 4 1,576 567 214,485 15,872 2,190 968 2 5.6 45,493 21.20% 3,366 465 205 0.4 1.2
305 305 Massachusetts CBSA Barnstable Town, Massachusetts 3 414 149 213,900 15,829 2,184 966 7.6 21.1 80,676 37.70% 5,970 824 364 2.9 8
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
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
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
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
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
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
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
64 64 Illinois CBSA Springfield, Illinois 2 855 308 210,550 15,581 2,150 950 3.6 10.1 48,347 23.00% 3,578 494 218 0.8 2.3
82 82 Arkansas CBSA Fort Smith, Arkansas 6 782 282 207,284 15,339 2,117 936 3.9 10.8 45,036 21.70% 3,333 460 203 0.8 2.4
356 356 South Carolina CBSA Hilton Head Island-Bluffton, South Carolina 3 331 119 206,781 15,302 2,112 933 9.2 25.6 63,228 30.60% 4,679 646 285 2.8 7.8
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
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
31 31 Louisiana CBSA Monroe, Louisiana 12 963 347 205,260 15,189 2,096 927 3.1 8.7 42,814 20.90% 3,168 437 193 0.7 1.8
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
259 259 Arizona CBSA Yuma, Arizona 2 447 161 204,281.00 15,117 2,086 922 6.7 18.7 45,739.00 22.40% 3,385 467 206 1.5 4.2
377 377 Alabama CBSA Daphne-Fairhope-Foley, Alabama 3 298 107 203,360 15,049 2,077 918 10 28 53,519 26.30% 3,960 547 242 2.6 7.4
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
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
21 21 Missouri CBSA Columbia, Missouri 5 1,028 370 202,353 14,974 2,066 913 2.9 8.1 34,828 17.20% 2,577 356 157 0.5 1.4
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
93 93 Minnesota MD St Cloud, Minnesota 4 711 256 199,801 14,785 2,040 902 4.1 11.5             0
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
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
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
80 80 Ohio CBSA Cleveland-Elyria, Ohio 31 7,853 2827 2,062,764 152,645 21,065 9,311 3.9 10.7 491,925 23.80% 36,402 5,024 2,221 0.9 2.6
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
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
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
49 49 Michigan CBSA Saginaw, Michigan 3 853 307 193,803.00 14,341 1,979 875 3.3 9.3 47,390.00 24.50% 3,507 484 214 0.8 2.3
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
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
409 409 North Carolina CBSA Jacksonville, North Carolina 1 149 54 192,685 14,259 1,968 870 19 52.6 22,983 11.90% 1,701 235 104 2.3 6.3
345 345 South Carolina CBSA Augusta-Richmond County, South Carolina 2 324 117 192,327 14,232 1,964 868 8.7 24.2 47,819 24.90% 3,539 488 216 2.2 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
337 337 Florida CBSA Panama City, Florida 5 308 111 180,117.00 13,329 1,839 813 8.6 23.9 40,210.00 22.30% 2,976 411 182 1.9 5.3
359 359 New York CBSA Kingston, New York 3 280 101 180,129 13,330 1,839 813 9.5 26.3 45,203 25.10% 3,345 462 204 2.4 6.6
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
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
117 117 California CBSA Redding, California 5 574 207 178,919 13,240 1,827 808 4.6 12.7 47,900 26.80% 3,545 489 216 1.2 3.4
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
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
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
297 297 Pennsylvania MD Montgomery County-Bucks County-Chester County, Pennsylvania 23 3,971 1430 1978845 146,435 20,208 8,933 7.3 20.4 485398 24.50% 35,919 4,957 2,191 1.8 5
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
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
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
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
73 73 Missouri CBSA Joplin, Missouri 5 697 251 176,759 13,080 1,805 798 3.7 10.4 37,664 21.30% 2,787 385 170 0.8 2.2
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
111 111 Montana CBSA Billings, Montana 5 576 207 176,140 13,034 1,799 795 4.5 12.5 41,033 23.30% 3,036 419 185 1 2.9
329 329 Oregon CBSA Bend, Oregon 2 307 111 175,321 12,974 1,790 791 8.4 23.3 45,371 25.90% 3,357 463 205 2.2 6
72 72 Florida CBSA Punta Gorda, Florida 3 681 245 173,236.00 12,819 1,769 782 3.7 10.4 81,236.00 46.90% 6,011 830 367 1.8 4.9
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
266 266 Delaware CBSA Dover, Delaware 1 374 135 173,145 12,813 1,768 782 6.8 18.9 36,849 21.30% 2,727 376 166 1.5 4
241 241 Michigan CBSA Muskegon, Michigan 2 397 143 172,707.00 12,780 1,764 780 6.4 17.8 37,993.00 22.00% 2,811 388 172 1.4 3.9
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
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
118 118 Iowa CBSA Waterloo-Cedar Falls, Iowa 6 546 197 170,055 12,584 1,737 768 4.6 12.7 37,828 22.20% 2,799 386 171 1 2.8
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
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
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
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
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
301 301 Pennsylvania CBSA East Stroudsburg, Pennsylvania 2 329 118 167,306.00 12,381 1,709 755 7.5 20.9 37,614.00 22.50% 2,783 384 170 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
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
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
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
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
251 251 Hawaii CBSA Kahului-Wailuku-Lahaina, Hawaii 4 367 132 164,094 12,143 1,676 741 6.6 18.3 37,939 23.10% 2,807 387 171 1.5 4.2
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
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
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
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
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
396 396 North Carolina CBSA Burlington, North Carolina 1 197 71 157,844 11,680 1,612 713 11.8 32.7 35,388 22.40% 2,619 361 160 2.6 7.3
97 97 Alabama CBSA Auburn-Opelika, Alabama 1 549 198 156,597 11,588 1,599 707 4.2 11.6 24,513 15.70% 1,814 250 111 0.7 1.8
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
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
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
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
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
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
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
252 252 Michigan CBSA Niles, Michigan 2 344 124 154,948.00 11,466 1,582 699 6.6 18.4 39,067.00 25.20% 2,891 399 176 1.7 4.6
22 22 Louisiana CBSA Alexandria, Louisiana 6 773 278 154,385 11,424 1,577 697 2.9 8.2 32,243 20.90% 2,386 329 146 0.6 1.7
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
267 267 Pennsylvania CBSA Chambersburg-Waynesboro, Pennsylvania 2 329 118 153,003.00 11,322 1,562 691 6.8 19.1 38,030.00 24.90% 2,814 388 172 1.7 4.7
403 403 Alabama CBSA Decatur, Alabama 2 153 55 152,445 11,281 1,557 688 14.7 40.8 34,449 22.60% 2,549 352 156 3.3 9.2
104 104 Maine CBSA Bangor, Maine 4 519 187 152,284 11,269 1,555 687 4.3 12 36,356 23.90% 2,690 371 164 1 2.9
354 354 Missouri CBSA Jefferson City, Missouri 3 243 87 151,056 11,178 1,543 682 9.2 25.6 32,282 21.40% 2,389 330 146 2 5.5
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
421 421 Georgia CBSA Chattanooga, Georgia 1 35 13 150,761 11,156 1,540 681 63.4 170.8 35,414 23.50% 2,621 362 160 14.9 40.2
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
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

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