CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Hospitals

✎ 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
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
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
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
48 48 Maryland CBSA Cumberland, Maryland 1 321 116 72,591 5,372 741 328 3.3 9.2 18,311 25.20% 1,355 187 83 0.8 2.3
53 53 Virginia CBSA Winchester, Virginia 1 485 175 111,300.00 8,236 1,137 502 3.4 9.4 23,506.00 21.10% 1,739 240 106 0.7 2
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
116 116 Michigan CBSA Midland, Michigan 1 270 97 83,489.00 6,178 853 377 4.6 12.7 19,242.00 23.00% 1,424 196 87 1 2.9
122 122 West Virginia CBSA Weirton-Steubenville, West Virginia 1 167 60 52,988 3,921 541 239 4.7 13 15,450 29.20% 1,143 158 70 1.4 3.8
129 129 Idaho CBSA Lewiston, Idaho 1 123 44 40,014 2,961 409 181 4.8 13.4 10,185 25.50% 754 104 46 1.2 3.4
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
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
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
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
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
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
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
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
264 264 Alaska CBSA Fairbanks, Alaska 1 217 78 100,031 7,402 1,022 452 6.8 18.9 13,950 13.90% 1,032 142 63 0.9 2.6
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
310 310 Oregon CBSA Corvallis, Oregon 1 168 60 88,249 6,530 901 398 7.7 21.7 18,413 20.90% 1,363 188 83 1.6 4.5
311 311 Utah CBSA St George, Utah 1 263 95 138,115 10,221 1,410 623 7.7 21.4             0
314 314 New Jersey CBSA Ocean City, New Jersey 1 178 64 94,549 6,997 966 427 7.8 21.8 31,925 33.80% 2,362 326 144 2.6 7.3
316 316 West Virginia CBSA Winchester, West Virginia 1 44 16 23,412 1,732 239 106 7.8 21.6 6,811 29.10% 504 70 31 2.3 6.3
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
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
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
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
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
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
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
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
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
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
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
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
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
397 397 Kansas CBSA Lawrence, Kansas 1 142 51 117,806 8,718 1,203 532 12.2 34 18,450 15.70% 1,365 188 83 1.9 5.3
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
400 400 Washington CBSA Lewiston, Washington 1 25 9 22,259 1,647 227 100 13.1 36.3 6,373 28.60% 472 65 29 3.8 10.4
402 402 Pennsylvania CBSA Lebanon, Pennsylvania 1 151 54 137,616.00 10,184 1,405 621 13.4 37.5 34,280.00 24.90% 2,537 350 155 3.3 9.4
404 404 Maryland CBSA California-Lexington Park, Maryland 1 109 39 110,979 8,212 1,133 501 15 41.9 18,983 17.10% 1,405 194 86 2.6 7.2
405 405 West Virginia CBSA Cumberland, West Virginia 1 25 9 27,421 2,029 280 124 16.2 44.9 7,414 27.00% 549 76 33 4.4 12.1
406 406 Washington CBSA Bremerton-Silverdale-Port Orchard, Washington 1 232 84 258,903 19,159 2,644 1,169 16.4 45.4 59,433 23.00% 4,398 607 268 3.8 10.4
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
410 410 Indiana CBSA Cincinnati, Indiana 1 64 23 85,535 6,330 873 386 19.7 54.7 19,991 23.40% 1,479 204 90 4.6 12.8
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
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
414 414 Wisconsin CBSA Duluth, Wisconsin 1 25 9 43,503.00 3,219 444 196 25.6 71.1 10,444.00 24.00% 773 107 47 6.2 17.1
415 415 Michigan CBSA South Bend-Mishawaka, Michigan 1 25 9 51,397.00 3,803 525 232 30.3 84.1 13,966.00 27.20% 1,033 143 63 8.2 22.9
416 416 West Virginia CBSA Washington-Arlington-Alexandria, West Virginia 1 25 9 55,673 4,120 569 251 32.8 91.1 11,916 21.40% 882 122 54 7 19.6
417 417 Arkansas CBSA Texarkana, Arkansas 1 25 9 56,254 4,163 574 254 33.1 92 13,063 23.20% 967 133 59 7.7 21.3
419 419 Florida CBSA The Villages, Florida 1 40 14 116,754.00 8,640 1,192 527 43 122.8 74,936.00 64.20% 5,545 765 338 27.6 78.8
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
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
422 422 Ohio CBSA Huntington-Ashland, Ohio 1 8 3 61,057 4,518 624 276 112.4 300 14,970 24.50% 1,108 153 68 27.6 73.7
423 423 Michigan CBSA Grand Rapids-Wyoming, Michigan 1 39 14 988,938 73,181 10,099 4,464 373.4 1040.2              
424 424 Texas CBSA Dallas-Fort Worth-Arlington, Texas 1 10 4 7,040,347 520,986 71,896 31,780 10367.6 25919 1,078,937 15.30% 79,841 11,018 4,870 1588.8 3972
430 430 Maryland No clean match Wilmington, Maryland 1 109   No clean match                        
433 433 Missouri No clean match St Joseph, Missouri 1 352   No clean match                        
6 6 Montana CBSA Great Falls, Montana 2 522 188 81,816 6,054 836 369 2.3 6.4 19,330 23.60% 1,430 197 87 0.5 1.5
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
20 20 North Dakota CBSA Grand Forks, North Dakota 2 362 130 70,130 5,190 716 317 2.9 7.9 11,680 16.70% 864 119 53 0.5 1.3
23 23 Maine CBSA Lewiston-Auburn, Maine 2 540 194 107,317 7,941 1,096 484 2.9 8.1 24,289 22.60% 1,797 248 110 0.7 1.8
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
33 33 New York CBSA Elmira, New York 2 407 147 86,883 6,429 887 392 3.1 8.7 21,007 24.20% 1,555 215 95 0.8 2.1
42 42 Illinois CBSA Kankakee, Illinois 2 500 180 110,801 8,199 1,131 500 3.3 9.1 23,667 21.40% 1,751 242 107 0.7 1.9
50 50 Nevada CBSA Carson City, Nevada 2 240 86 54,219 4,012 554 245 3.3 9.3 14,410 26.60% 1,066 147 65 0.9 2.5
63 63 Oklahoma CBSA Lawton, Oklahoma 2 530 191 129,066 9,551 1,318 583 3.6 10 21,927 17.00% 1,623 224 99 0.6 1.7
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
75 75 Minnesota CBSA Grand Forks, Minnesota 2 123 44 31,564 2,336 322 142 3.8 10.5 7,554 23.90% 559 77 34 0.9 2.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
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
96 96 Wisconsin CBSA La Crosse-Onalaska, Wisconsin 2 414 149 117,582.00 8,701 1,201 531 4.2 11.6 24,464.00 20.80% 1,810 250 110 0.9 2.4
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
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
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
131 131 West Virginia CBSA Parkersburg-Vienna, West Virginia 2 279 100 91,816 6,794 938 414 4.8 13.5 23,820 25.90% 1,763 243 108 1.3 3.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
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
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
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
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
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
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
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
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
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
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
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
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
236 236 Massachusetts CBSA Pittsfield, Massachusetts 2 300 108 127,751 9,454 1,305 577 6.3 17.4 37,339 29.20% 2,763 381 169 1.8 5.1
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
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
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
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
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
279 279 Ohio CBSA Springfield, Ohio 2 283 102 135,520 10,028 1,384 612 7.1 19.6 33,970 25.10% 2,514 347 153 1.8 4.9
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
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
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
);