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

448 rows sorted by Metro

View and edit SQL

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
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
189 Ohio CBSA Akron, Ohio 8 1,912 688 703,398 52,051 7,183 3,175 5.4 15.1 161,110 22.90% 11,922 1,645 727 1.2 3.4
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
408 Oregon CBSA Albany-Lebanon, Oregon 2 95 34 121,074 8,959 1,236 547 18.8 52.4 29,548 24.40% 2,187 302 133 4.6 12.8
172 New York CBSA Albany-Schenectady-Troy, New York 8 2,453 883 881,862 65,258 9,006 3,981 5.3 14.7 199,326 22.60% 14,750 2,036 900 1.2 3.3
286 New Mexico CBSA Albuquerque, New Mexico 10 1,870 673 905,049 66,974 9,242 4,085 7.1 19.8 193,195 21.30% 14,296 1,973 872 1.5 4.2
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
355 New Jersey CBSA Allentown-Bethlehem-Easton, New Jersey 2 172 62 107,088 7,925 1,094 483 9.2 25.4 24,579 23.00% 1,819 251 111 2.1 5.8
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
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
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
224 Iowa CBSA Ames, Iowa 3 297 107 122,269 9,048 1,249 552 6.1 16.8 21,471 17.60% 1,589 219 97 1.1 3
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
276 Alaska CBSA Anchorage, Alaska 5 839 302 399,360 29,553 4,078 1,803 7 19.5 59,966 15.00% 4,437 612 271 1.1 2.9
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
217 Alabama CBSA Anniston-Oxford, Alabama 3 286 103 115,527 8,549 1,180 521 5.9 16.5 27,115 23.50% 2,007 277 122 1.4 3.9
370 Wisconsin CBSA Appleton, Wisconsin 3 352 127 233,025.00 17,244 2,380 1,052 9.7 27 45,170.00 19.40% 3,343 461 204 1.9 5.2
161 North Carolina CBSA Asheville, North Carolina 6 1,267 456 445625 32,976 4,551 2,012 5.2 14.4 125064 28.10% 9,255 1,277 565 1.5 4
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
317 Georgia CBSA Atlanta-Sandy Springs-Alpharetta, Georgia 44 10,632 3828 5,700,990 421,873 58,219 25,734 7.9 21.9 933,559 16.40% 69,083 9,534 4,214 1.3 3.6
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
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
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
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
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
324 California CBSA Bakersfield, California 11 1,617 582 878,744 65,027 8,974 3,967 8 22.2 130,831 14.90% 9,681 1,336 591 1.2 3.3
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
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
305 Massachusetts CBSA Barnstable Town, Massachusetts 3 414 149 213,900 15,829 2,184 966 7.6 21.1 80,676 37.70% 5,970 824 364 2.9 8
145 Louisiana CBSA Baton Rouge, Louisiana 18 2,495 898 851,622 63,020 8,697 3,844 5 14 157,542 18.50% 11,658 1,609 711 0.9 2.6
249 Michigan CBSA Battle Creek, Michigan 3 301 108 134,327.00 9,940 1,372 606 6.6 18.3 31,227.00 23.20% 2,311 319 141 1.5 4.3
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
199 Texas CBSA Beaumont-Port Arthur, Texas 9 1,035 373 394,476 29,191 4,028 1,781 5.6 15.6 79,511 20.20% 5,884 812 359 1.1 3.1
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
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
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 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
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
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
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
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
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
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
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
282 Idaho CBSA Boise City, Idaho 9 1,405 506 677,346 50,124 6,917 3,058 7.1 19.7 127,603 18.80% 9,443 1,303 576 1.3 3.7
431 Massachusetts No clean match Boston, Massachusetts 26 6,569   No clean match                        
294 Colorado CBSA Boulder, Colorado 5 640 230 316,782 23,442 3,235 1,430 7.3 20.3 59,425 18.80% 4,397 607 268 1.4 3.8
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
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
335 Connecticut CBSA Bridgeport-Stamford-Norwalk, Connecticut 6 1,638 590 947,328 70,102 9,674 4,276 8.5 23.6 197,334 20.80% 14,603 2,015 891 1.8 4.9
207 Texas CBSA Brownsville-Harlingen, Texas 6 1,081 389 420,201 31,095 4,291 1,897 5.7 15.9 71,392 17.00% 5,283 729 322 1 2.7
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
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
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
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
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
432 Massachusetts No clean match Cambridge-Newton-Framingham, Massachusetts 19 3,934   No clean match                        
435 New Jersey No clean match Camden, New Jersey 12 3,278   No clean match                        
174 Ohio CBSA Canton-Massillon, Ohio 5 1,118 402 402,098 29,755 4,106 1,815 5.3 14.7 101,911 25.30% 7,541 1,041 460 1.3 3.7
268 Florida CBSA Cape Coral-Fort Myers, Florida 4 1,503 541 700,165.00 51,812 7,150 3,161 6.9 19.1 239,488.00 34.20% 17,722 2,446 1,081 2.3 6.5
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
160 Illinois CBSA Carbondale-Marion, Illinois 4 398 143 139,491 10,322 1,424 630 5.2 14.4 30,856 22.10% 2,283 315 139 1.1 3.2
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
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
179 Iowa CBSA Cedar Rapids, Iowa 4 734 264 266,122 19,693 2,718 1,201 5.3 14.8 56,966 21.40% 4,215 582 257 1.1 3.2
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
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
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
198 South Carolina CBSA Charleston-North Charleston, South Carolina 7 1,957 705 744,195 55,070 7,600 3,359 5.6 15.5 147,202 19.80% 10,893 1,503 664 1.1 3.1
277 North Carolina CBSA Charlotte-Concord-Gastonia, North Carolina 19 4,365 1571 2081923 154,062 21,261 9,398 7 19.5 364756 17.50% 26,992 3,725 1,647 1.2 3.4
380 South Carolina CBSA Charlotte-Concord-Gastonia, South Carolina 4 541 195 370,632 27,427 3,785 1,673 10.1 28 79,346 21.40% 5,872 810 358 2.2 6
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
442 Tennessee No clean match Chattanooga Clarksville, Tennessee 5 1921   No clean match                        
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
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
425 Illinois No clean match Chicago-Naperville-Evanston, Illinois 68 19,170   No clean match                        
271 California CBSA Chico, California 3 476 171 225,207 16,665 2,300 1,017 7 19.4 53,616 23.80% 3,968 548 242 1.7 4.6
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
269 Kentucky CBSA Cincinnati, Kentucky 7 941 339 439,785 32,544 4,491 1,985 6.9 19.1 84,358 19.20% 6,242 861 381 1.3 3.7
151 Ohio CBSA Cincinnati, Ohio 20 4,815 1733 1,654,238 122,414 16,893 7,467 5.1 14.1 338,018 20.40% 25,013 3,452 1,526 1 2.9
325 Kentucky CBSA Clarksville, Kentucky 2 158 57 86,724 6,418 886 391 8.1 22.4 15,571 18.00% 1,152 159 70 1.5 4
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
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
201 Idaho CBSA Coeur dAlene, Idaho 3 362 130 138,494 10,249 1,414 625 5.6 15.7             0
258 Texas CBSA College Station-Bryan, Texas 6 546 197 248,554 18,393 2,538 1,122 6.7 18.6 35,714 14.40% 2,643 365 161 1 2.7
365 Colorado CBSA Colorado Springs, Colorado 5 1,069 385 698,595 51,696 7,134 3,153 9.6 26.7 122,967 17.60% 9,100 1,256 555 1.7 4.7
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
209 South Carolina CBSA Columbia, South Carolina 8 2,064 743 808,377 59,820 8,255 3,649 5.8 16 159,048 19.70% 11,770 1,624 718 1.1 3.2
357 Alabama CBSA Columbus, Alabama 2 93 33 58,480 4,328 597 264 9.3 26.1 10,680 18.30% 790 109 48 1.7 4.8
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
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
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
152 Texas CBSA Corpus Christi, Texas 6 1,239 446 425,351 31,476 4,344 1,920 5.1 14 81,128 19.10% 6,003 828 366 1 2.7
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
270 Florida CBSA Crestview-Fort Walton Beach-Destin, Florida 5 558 201 261,048.00 19,318 2,666 1,178 6.9 19.1 58,298.00 22.30% 4,314 595 263 1.5 4.3
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
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
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
443 Texas No clean match Dallas-Plano-Irving, Texas 80 10,748   No clean match                        
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

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