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)

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
425 425 Illinois No clean match Chicago-Naperville-Evanston, Illinois 68 19,170   No clean match                        
426 426 Illinois No clean match Elgin, Illinois 7 1,065   No clean match                        
427 427 Illinois No clean match Lake County-Kenosha County, Illinois 5 844   No clean match                        
428 428 Indiana No clean match Gary, Indiana 14 2,965   No clean match                        
429 429 Maryland No clean match Frederick-Gaithersburg-Rockville, Maryland 8 1,905   No clean match                        
430 430 Maryland No clean match Wilmington, Maryland 1 109   No clean match                        
431 431 Massachusetts No clean match Boston, Massachusetts 26 6,569   No clean match                        
432 432 Massachusetts No clean match Cambridge-Newton-Framingham, Massachusetts 19 3,934   No clean match                        
433 433 Missouri No clean match St Joseph, Missouri 1 352   No clean match                        
434 434 New Hampshire No clean match Rockingham County-Strafford County, New Hampshire 6 719   No clean match                        
435 435 New Jersey No clean match Camden, New Jersey 12 3,278   No clean match                        
436 436 New Jersey No clean match New Brunswick-Lakewood, New Jersey 21 5,086   No clean match                        
437 437 New Jersey No clean match New York-Jersey City-White Plains, New Jersey 15 4,793   No clean match                        
438 438 New Jersey No clean match Newark, New Jersey 18 5,200   No clean match                        
439 439 New Jersey No clean match Wilmington, New Jersey 2 222   No clean match                        
440 440 New York No clean match Nassau County-Suffolk County, New York 20 7,497   No clean match                        
441 441 New York No clean match New York-Jersey City-White Plains, New York 55 24,992   No clean match                        
442 442 Tennessee No clean match Chattanooga Clarksville, Tennessee 5 1921   No clean match                        
443 443 Texas No clean match Dallas-Plano-Irving, Texas 80 10,748   No clean match                        
444 444 Texas No clean match Fort Worth-Arlington-Grapevine, Texas 40 5,595   No clean match                        
445 445 Washington No clean match Olympia-Tumwater, Washington 2 401   No clean match                        
446 446 Washington No clean match Seattle-Bellevue-Kent, Washington 22 5,239   No clean match                        
447 447 Washington No clean match Tacoma-Lakewood, Washington 6 1,463   No clean match                        
448 448 Wisconsin No clean match Lake County-Kenosha County, Wisconsin 2 273   No clean match                        
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
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
65 65 North Dakota CBSA Bismarck, North Dakota 3 505 182 124,253 9,195 1,269 561 3.6 10.1 25,840 20.80% 1,912 264 117 0.8 2.1
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
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
68 68 North Carolina CBSA Durham-Chapel Hill, North Carolina 8 2,425 873 608784 45,050 6,217 2,748 3.7 10.3 121204 19.90% 8,969 1,238 547 0.7 2
69 69 Pennsylvania CBSA Altoona, Pennsylvania 4 496 179 124,736.00 9,230 1,274 563 3.7 10.3 33,231.00 26.60% 2,459 339 150 1 2.7
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
71 71 West Virginia CBSA Beckley, West Virginia 4 483 174 121,699 9,006 1,243 549 3.7 10.3 32,408 26.60% 2,398 331 146 1 2.7
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
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
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
74 74 Louisiana CBSA Shreveport-Bossier City, Louisiana 10 1,573 566 403,931 29,891 4,125 1,823 3.8 10.5 84,575 20.90% 6,259 864 382 0.8 2.2
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
77 77 Wyoming CBSA Casper, Wyoming 4 315 113 81,023 5,996 827 366 3.8 10.6 16,036 19.80% 1,187 164 72 0.7 2.1
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
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
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
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
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
83 83 Virginia CBSA Roanoke, Virginia 3 1,182 426 313,069.00 23,167 3,197 1,413 3.9 10.8 81,216.00 25.90% 6,010 829 367 1 2.8
84 84 Iowa CBSA Dubuque, Iowa 3 360 130 96,571 7,146 986 436 4 10.9 22,155 22.90% 1,639 226 100 0.9 2.5
423 423 Michigan CBSA Grand Rapids-Wyoming, Michigan 1 39 14 988,938 73,181 10,099 4,464 373.4 1040.2              
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
86 86 Washington CBSA Wenatchee, Washington 4 430 155 115,723 8,564 1,182 522 4 11 27,556 23.80% 2,039 281 124 0.9 2.6
87 87 Georgia CBSA Columbus, Georgia 4 974 351 263,754 19,518 2,693 1,191 4 11.1 48,520 18.40% 3,590 495 219 0.7 2
88 88 New York CBSA Buffalo-Cheektowaga, New York 10 4,188 1508 1,136,670 84,114 11,608 5,131 4 11.1 269,308 23.70% 19,929 2,750 1,216 0.9 2.6
89 89 Iowa CBSA Sioux City, Iowa 3 374 135 102,397 7,577 1,046 462 4 11.2 20,666 20.20% 1,529 211 93 0.8 2.3
90 90 Ohio CBSA Toledo, Ohio 14 2,359 849 645,973 47,802 6,597 2,916 4 11.2 141,013 21.80% 10,435 1,440 637 0.9 2.4
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
92 92 Texas CBSA Amarillo, Texas 5 942 339 261,827 19,375 2,674 1,182 4.1 11.4 47,955 18.30% 3,549 490 216 0.7 2.1
93 93 Minnesota MD St Cloud, Minnesota 4 711 256 199,801 14,785 2,040 902 4.1 11.5             0
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
95 95 Nebraska CBSA Grand Island, Nebraska 4 267 96 75,447 5,583 770 341 4.2 11.6 15,817 21.00% 1,170 162 71 0.9 2.4
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
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
98 98 Pennsylvania CBSA Harrisburg-Carlisle, Pennsylvania 8 1,974 711 565,008.00 41,811 5,770 2,550 4.2 11.7 130,412.00 23.10% 9,650 1,332 589 1 2.7
99 99 Pennsylvania CBSA Erie, Pennsylvania 6 967 348 277,794.00 20,557 2,837 1,254 4.2 11.8 63,334.00 22.80% 4,687 647 286 1 2.7
100 100 Pennsylvania CBSA Allentown-Bethlehem-Easton, Pennsylvania 10 2,511 904 725,702.00 53,702 7,411 3,276 4.3 11.8 171,527.00 23.60% 12,693 1,752 774 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
101 101 Pennsylvania CBSA Williamsport, Pennsylvania 3 394 142 115,398.00 8,539 1,178 521 4.3 12 28,691.00 24.90% 2,123 293 130 1.1 3
103 103 Georgia CBSA Savannah, Georgia 7 1,284 462 377,476 27,933 3,855 1,704 4.3 12 70,060 18.60% 5,184 715 316 0.8 2.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
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
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
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
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
108 108 Illinois CBSA Peoria, Illinois 8 1,357 489 412,991 30,561 4,217 1,864 4.5 12.4 96,172 23.30% 7,117 982 434 1 2.9
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
110 110 Missouri CBSA Springfield, Missouri 5 1,501 540 455,133 33,680 4,648 2,054 4.5 12.4 97,033 21.30% 7,180 991 438 1 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
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
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
114 114 Alabama CBSA Tuscaloosa, Alabama 5 803 289 248,122 18,361 2,534 1,120 4.6 12.6 47,697 19.20% 3,530 487 215 0.9 2.4
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
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
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
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
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
120 120 Oklahoma CBSA Tulsa, Oklahoma 26 3,111 1120 977,869 72,362 9,986 4,414 4.6 12.9 198,300 20.30% 14,674 2,025 895 0.9 2.6
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
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
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
123 123 Louisiana CBSA Hammond, Louisiana 8 405 146 128,850 9,535 1,316 582 4.7 13 24,738 19.20% 1,831 253 112 0.9 2.5
124 124 Illinois CBSA Champaign-Urbana, Illinois 4 700 252 224,379 16,604 2,291 1,013 4.7 13.1 39,050 17.40% 2,890 399 176 0.8 2.3
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
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
127 127 New Jersey CBSA Atlantic City-Hammonton, New Jersey 4 841 303 272,926 20,197 2,787 1,232 4.8 13.3 62,613 22.90% 4,633 639 283 1.1 3
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
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
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
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
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
133 133 Michigan CBSA Flint, Michigan 4 1,242 447 410,881.00 30,405 4,196 1,855 4.9 13.5 93,094.00 22.70% 6,889 951 420 1.1 3.1
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

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