CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Geography_Type 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
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                        
47 47 District of Columbia MD District of Columbia, District of Columbia 10 3,114 1121 702,455 51,982 7,173 3,171 3.3 9.2             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
93 93 Minnesota MD St Cloud, Minnesota 4 711 256 199,801 14,785 2,040 902 4.1 11.5             0
139 139 Pennsylvania MD Scranton-Wilkes-Barre, Pennsylvania 10 1,651 594 555485 41,106 5,673 2,507 5 13.8 152608 27.50% 11,293 1,558 689 1.4 3.8
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
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
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
191 191 Florida MD West Palm Beach-Boca Raton-Boynton Beach, Florida 15 3,987 1435 1,485,941 109,960 15,174 6,708 5.5 15.2             0
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
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
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
290 290 Delaware MD Wilmington, Delaware 4 1,473 530 724,768 53,633 7,401 3,272 7.2 20.1             0
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
322 322 California MD Anaheim-Santa Ana-Irvine, California 27 5,900 2124 3,185,968 235,762 32,535 14,381 8 22.1             0
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
371 371 California MD San Rafael, California 3 391 141 259,666 19,215 2,652 1,172 9.8 27.1             0
1 1 Pennsylvania CBSA Bloomsburg-Berwick, Pennsylvania 5 789 284 84,917.00 6,284 867 383 1.6 4.4 21,406.00 25.20% 1,584 219 97 0.4 1.1
2 2 West Virginia CBSA Wheeling, West Virginia 4 614 221 74,912 5,543 765 338 1.8 5 21,297 28.40% 1,576 217 96 0.5 1.4
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
4 4 Texas CBSA Texarkana, Texas 5 672 242 93,635 6,929 956 423 2.1 5.7 20,099 21.50% 1,487 205 91 0.4 1.2
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
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
7 7 Georgia CBSA Rome, Georgia 3 602 217 96,471 7,139 985 435 2.4 6.5 20,941 21.70% 1,550 214 95 0.5 1.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
9 9 Alabama CBSA Gadsden, Alabama 3 603 217 103,132 7,632 1,053 466 2.5 7 25,122 24.40% 1,859 257 113 0.6 1.7
10 10 Texas CBSA Victoria, Texas 5 565 203 99,028 7,328 1,011 447 2.6 7.2 21,342 21.60% 1,579 218 96 0.6 1.5
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
12 12 Texas CBSA Tyler, Texas 8 1,209 435 222,277 16,448 2,270 1,003 2.7 7.5 47,438 21.30% 3,510 484 214 0.6 1.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
14 14 Missouri CBSA Cape Girardeau, Missouri 3 484 174 90,360 6,687 923 408 2.7 7.6 20,121 22.30% 1,489 205 91 0.6 1.7
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
16 16 Ohio CBSA Weirton-Steubenville, Ohio 3 359 129 67,349 4,984 688 304 2.8 7.7 18,775 27.90% 1,389 192 85 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
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
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
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
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
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
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
25 25 Florida CBSA Gainesville, Florida 4 1,548 557 316,769.00 23,441 3,235 1,430 3 8.4 64,742.00 20.40% 4,791 661 292 0.6 1.7
26 26 Indiana CBSA Evansville, Indiana 7 1,302 469 269,011 19,907 2,747 1,214 3 8.4 60,428 22.50% 4,472 617 273 0.7 1.9
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
28 28 South Dakota CBSA Sioux Falls, South Dakota 8 1,210 436 250,564 18,542 2,559 1,131 3 8.5 44,671 17.80% 3,306 456 202 0.5 1.5
29 29 Minnesota CBSA Duluth, Minnesota 11 1,178 424 246,280 18,225 2,515 1,112 3.1 8.6 62,088 25.20% 4,595 634 280 0.8 2.2
30 30 Oklahoma CBSA Enid, Oklahoma 3 300 108 62,421 4,619 637 282 3.1 8.5 13,092 21.00% 969 134 59 0.6 1.8
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
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
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
34 34 District of Columbia CBSA Washington-Arlington-Alexandria, District of Columbia 10 3,114 1121 672,391 49,757 6,866 3,035 3.2 8.8 113,026 16.80% 8,364 1,154 510 0.5 1.5
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
36 36 Arkansas CBSA Hot Springs, Arkansas 3 449 162 97,994 7,252 1,001 442 3.2 8.9 28,731 29.30% 2,126 293 130 0.9 2.6
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
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
40 40 Michigan CBSA Ann Arbor, Michigan 5 1,641 591 361,509.00 26,752 3,692 1,632 3.2 9 65,781.00 18.20% 4,868 672 297 0.6 1.6
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
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
43 43 Mississippi CBSA Jackson, Mississippi 16 2670 961 596,832.00 44,166 6,095 2,694 3.3 9.1 112,915.00 18.90% 8,356 1,153 510 0.6 1.7
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
45 45 South Dakota CBSA Rapid City, South Dakota 5 605 218 135,192 10,004 1,381 610 3.3 9.1 29,786 22.00% 2,204 304 134 0.7 2
46 46 West Virginia CBSA Charleston, West Virginia 7 1,210 436 270,328 20,004 2,761 1,220 3.3 9.1 70,827 26.20% 5,241 723 320 0.9 2.4
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
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
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
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
52 52 Texas CBSA Sherman-Denison, Texas 5 556 200 126,146 9,335 1,288 569 3.3 9.3 29,807 23.60% 2,206 304 135 0.8 2.2
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
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
55 55 Alabama CBSA Birmingham-Hoover, Alabama 17 4,632 1668 1,079,170 79,859 11,020 4,871 3.4 9.5 226,516 21.00% 16,762 2,313 1,022 0.7 2
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
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
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
59 59 Indiana CBSA Fort Wayne, Indiana 10 1,697 611 401,228 29,691 4,097 1,811 3.5 9.7 79,036 19.70% 5,849 807 357 0.7 1.9
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
61 61 Georgia CBSA Augusta-Richmond County, Georgia 8 1,645 592 397,192 29,392 4,056 1,793 3.6 9.9 75,957 19.10% 5,621 776 343 0.7 1.9

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