CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Population_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
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
288 288 California CBSA Napa, California 2 289 104 141,005 10,434 1,440 636 7.2 20 33,686 23.90% 2,493 344 152 1.7 4.8
235 235 Florida CBSA Homosassa Springs, Florida 2 332 120 141,373.00 10,462 1,444 638 6.3 17.4 61,636.00 43.60% 4,561 629 278 2.7 7.6
313 313 South Carolina CBSA Sumter, South Carolina 2 268 96 141,535 10,474 1,445 639 7.8 21.7 33,021 23.30% 2,444 337 149 1.8 5.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
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
62 62 Alabama CBSA Florence-Muscle Shoals, Alabama 3 601 216 147,025 10,880 1,501 664 3.6 10 37,514 25.50% 2,776 383 169 0.9 2.6
376 376 New Mexico CBSA Santa Fe, New Mexico 1 219 79 147,514 10,916 1,506 666 9.9 27.5 42,681 28.90% 3,158 436 193 2.9 8
18 18 Alabama CBSA Dothan, Alabama 5 770 277 147,790 10,936 1,509 667 2.8 7.9 35,024 23.70% 2,592 358 158 0.7 1.9
128 128 Florida CBSA Sebastian-Vero Beach, Florida 3 454 163 147,981.00 10,951 1,511 668 4.8 13.4 57,277.00 38.70% 4,238 585 259 1.9 5.2
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
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
318 318 Maryland CBSA Hagerstown-Martinsburg, Maryland 1 278 100 149,546 11,066 1,527 675 7.9 22 33,148 22.20% 2,453 339 150 1.8 4.9
412 412 Michigan CBSA Monroe, Michigan 1 100 36 149,619.00 11,072 1,528 675 22 61.2 35,206.00 23.50% 2,605 360 159 5.2 14.4
349 349 California CBSA Hanford-Corcoran, California 2 248 89 150,183 11,114 1,534 678 8.9 24.9 20,569 13.70% 1,522 210 93 1.2 3.4
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
93 93 Minnesota MD St Cloud, Minnesota 4 711 256 199,801 14,785 2,040 902 4.1 11.5             0
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
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
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
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
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
121 121 Pennsylvania CBSA Pittsburgh, Pennsylvania 35 7,400 2664 2,348,143.00 173,763 23,979 10,600 4.7 13 608,340.00 25.90% 45,017 6,212 2,746 1.2 3.4
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
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
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
243 243 Michigan MD Warren-Troy-Farmington Hills, Michigan 24 5,847 2105 2,572,549 190,369 26,271 11,612 6.5 18             0
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
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
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
360 360 California MD Oakland-Berkeley-Livermore, California 20 4,372 1574 2,816,968 208,456 28,767 12,716 9.5 26.4             0
102 102 Combined CBSA St Louis, Missouri & Illinois 43 9,555 3440 2,817,355 208,484 28,771 12,718 4.3 12.1             0
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
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
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
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
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
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
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
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
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
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
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

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