CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Metro

✎ 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
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
44 44 Pennsylvania CBSA Johnstown, Pennsylvania 3 608 219 135,871.00 10,054 1,388 613 3.3 9.1 39,200.00 28.90% 2,901 400 177 0.9 2.6
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
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
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
94 94 Michigan CBSA Kalamazoo-Portage, Michigan 4 921 332 259,830.00 19,227 2,653 1,173 4.2 11.5 51,450.00 19.80% 3,807 525 232 0.8 2.3
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
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
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
361 361 Washington CBSA Kennewick-Richland, Washington 4 434 156 279,653 20,694 2,856 1,262 9.5 26.4 48,923 17.50% 3,620 500 221 1.7 4.6
239 239 Texas CBSA Killeen-Temple, Texas 6 1,008 363 432,797 32,027 4,420 1,954 6.3 17.6 62,605 14.50% 4,633 639 283 0.9 2.5
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
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
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
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
78 78 Indiana CBSA Kokomo, Indiana 3 318 114 82,457 6,102 842 372 3.8 10.6 20,461 24.80% 1,514 209 92 0.9 2.6
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
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
291 291 Indiana CBSA Lafayette-West Lafayette, Indiana 4 451 162 223,029 16,504 2,278 1,007 7.3 20.3 37,876 17.00% 2,803 387 171 1.2 3.4
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
427 427 Illinois No clean match Lake County-Kenosha County, Illinois 5 844   No clean match                        
448 448 Wisconsin No clean match Lake County-Kenosha County, Wisconsin 2 273   No clean match                        
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
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
315 315 Pennsylvania CBSA Lancaster, Pennsylvania 5 1,007 363 536,494.00 39,701 5,479 2,422 7.8 21.8 122,633.00 22.90% 9,075 1,252 554 1.8 5
253 253 Michigan CBSA Lansing-East Lansing, Michigan 7 1203 433 540,709.00 40,012 5,522 2,441 6.6 18.4 110,858.00 20.50% 8,203 1,132 500 1.4 3.8
275 275 Texas CBSA Laredo, Texas 4 569 205 269,624 19,952 2,753 1,217 7 19.4 34,315 12.70% 2,539 350 155 0.9 2.5
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
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
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
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
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
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
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
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
39 39 Kentucky CBSA Lexington-Fayette, Kentucky 11 2,269 817 500,689 37,051 5,113 2,260 3.2 9 93,464 18.70% 6,916 954 422 0.6 1.7
27 27 Ohio CBSA Lima, Ohio 5 508 183 104,157 7,708 1,064 470 3 8.4 24,080 23.10% 1,782 246 109 0.7 1.9
32 32 Nebraska CBSA Lincoln, Nebraska 8 1,526 549 323,402 23,932 3,303 1,460 3.1 8.7 59,068 18.30% 4,371 603 267 0.6 1.6
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
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
389 389 Utah CBSA Logan, Utah 2 159 57 120,288 8,901 1,228 543 11.1 31.1 15,104 12.60% 1,118 154 68 1.4 3.9
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
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
272 272 California MD Los Angeles-Long Beach-Glendale, California 89 21,347 7685 10,105,518 747,808 103,198 45,616 7 19.4             0
132 132 Combined CBSA Louisville-Jefferson County, Kentucky & Indiana 15 3,701 1332 1,222,216 90,444 12,481 5,517 4.9 13.5             0
57 57 Texas CBSA Lubbock, Texas 9 1,332 480 309,722 22,919 3,163 1,398 3.4 9.5 51,984 16.80% 3,847 531 235 0.6 1.6
35 35 Virginia CBSA Lynchburg, Virginia 3 1,200 432 258,995.00 19,166 2,645 1,169 3.2 8.8 62,730.00 24.20% 4,642 641 283 0.8 2.1
41 41 Georgia CBSA Macon-Bibb County, Georgia 5 1,040 374 229,966 17,017 2,348 1,038 3.3 9.1 50,113 21.80% 3,708 512 226 0.7 2
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
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
283 283 New Hampshire CBSA Manchester-Nashua, New Hampshire 5 841 303 406,371 30,071 4,150 1,834 7.1 19.7 84,563 20.80% 6,258 864 382 1.5 4.1
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
309 309 Minnesota CBSA Mankato, Minnesota 2 189 68 99,244 7,344 1,013 448 7.7 21.5 19,046 19.20% 1,409 194 86 1.5 4.1
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
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
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
308 308 Mississippi CBSA Memphis, Mississippi 4 473 170 247,857.00 18,341 2,531 1,119 7.7 21.5 45,237.00 18.30% 3,348 462 204 1.4 3.9
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
407 407 California CBSA Merced, California 2 230 83 267,390 19,787 2,731 1,207 17.1 47.4 40,383 15.10% 2,988 412 182 2.6 7.2
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
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
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
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
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
327 327 Combined CBSA Minneapolis-St Paul-Bloomington, Minnesota and Wisconsin 34 6452 2323 3,629,190 268,560 37,061 16,382 8.3 23             0
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
105 105 Alabama CBSA Mobile, Alabama 7 1,458 525 431,074 31,899 4,402 1,946 4.4 12.1 92,206 21.40% 6,823 942 416 0.9 2.6
281 281 California CBSA Modesto, California 6 1,113 401 535,684 39,641 5,470 2,418 7.1 19.7 92,698 17.30% 6,860 947 418 1.2 3.4
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
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
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
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
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
388 388 Tennessee CBSA Morristown, Tennessee 2 185 67 139,294 10,308 1,422 629 11.1 30.6 34,544 24.80% 2,556 353 156 2.7 7.6
254 254 Washington CBSA Mount Vernon-Anacortes, Washington 3 270 97 121,725 9,008 1,243 549 6.6 18.5 31,915 26.20% 2,362 326 144 1.7 4.8
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
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
413 413 North Carolina CBSA Myrtle Beach-Conway-North Myrtle Beach, North Carolina 2 79 28 122,586 9,071 1,252 553 22.9 64.5 46,285 37.80% 3,425 473 209 8.6 24.4
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
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
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
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
440 440 New York No clean match Nassau County-Suffolk County, New York 20 7,497   No clean match                        
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
436 436 New Jersey No clean match New Brunswick-Lakewood, New Jersey 21 5,086   No clean match                        
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
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
437 437 New Jersey No clean match New York-Jersey City-White Plains, New Jersey 15 4,793   No clean match                        
441 441 New York No clean match New York-Jersey City-White Plains, New York 55 24,992   No clean match                        
438 438 New Jersey No clean match Newark, New Jersey 18 5,200   No clean match                        
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
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
353 353 Connecticut CBSA Norwich-New London, Connecticut 2 435 157 270,772 20,037 2,765 1,222 9.2 25.4 63,495 23.40% 4,699 648 287 2.1 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
306 306 Florida CBSA Ocala, Florida 4 661 238 343,778.00 25,440 3,511 1,552 7.7 21.3 119,425.00 34.70% 8,837 1,220 539 2.7 7.4
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
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
336 336 Utah CBSA Ogden-Clearfield, Utah 9 1,108 399 642,274 47,528 6,559 2,899 8.5 23.7 95,645 14.90% 7,078 977 432 1.3 3.5
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
445 445 Washington No clean match Olympia-Tumwater, Washington 2 401   No clean match                        

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