CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Critical_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                        
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
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
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
271 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
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
370 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
136 136 Kansas CBSA Topeka, Kansas 4 701 252 233,382 17,270 2,383 1,053 4.9 13.6 55,557 23.80% 4,111 567 251 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
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
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
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
303 303 Washington CBSA Yakima, Washington 4 486 175 248,279 18,373 2,535 1,121 7.5 20.9 44,560 17.90% 3,297 455 201 1.4 3.7
258 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
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
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
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
371 371 California MD San Rafael, California 3 391 141 259,666 19,215 2,652 1,172 9.8 27.1             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
270 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
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
287 287 Texas CBSA Waco, Texas 3 542 195 263,009 19,463 2,686 1,187 7.1 19.9 50,698 19.30% 3,752 518 229 1.4 3.8
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
179 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
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
185 185 Indiana CBSA South Bend-Mishawaka, Indiana 3 733 264 268,613 19,877 2,743 1,213 5.4 15 57,385 21.40% 4,246 586 259 1.2 3.2
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
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
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
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
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
390 390 California CBSA Santa Cruz-Watsonville, California 3 359 129 273,263 20,221 2,791 1,234 11.2 31.2 57,232 20.90% 4,235 584 258 2.3 6.5
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
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
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
383 383 California CBSA San Luis Obispo-Paso Robles, California 4 390 140 280,119 20,729 2,861 1,264 10.6 29.5 70,097 25.00% 5,187 716 316 2.6 7.4
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
401 401 Colorado CBSA Greeley, Colorado 3 316 114 285,729 21,144 2,918 1,290 13.3 36.9 48,279 16.90% 3,573 493 218 2.2 6.2
238 238 New York CBSA Utica-Rome, New York 4 687 247 295,267 21,850 3,015 1,333 6.3 17.6 72,494 24.60% 5,365 740 327 1.6 4.3
193 193 South Carolina CBSA Spartanburg, South Carolina 3 795 286 297,732 22,032 3,040 1,344 5.5 15.3 63,159 21.20% 4,674 645 285 1.2 3.3
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
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
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
256 256 Wisconsin CBSA Green Bay, Wisconsin 6 698 251 315,847.00 23,373 3,225 1,426 6.7 18.5 65,088.00 20.60% 4,817 665 294 1.4 3.8
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
294 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
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
312 312 Colorado CBSA Fort Collins, Colorado 5 627 226 330,976 24,492 3,380 1,494 7.8 21.6 67,199 20.30% 4,973 686 303 1.6 4.4
212 212 Illinois CBSA Rockford, Illinois 4 864 311 341,150 25,245 3,484 1,540 5.8 16.2 75,762 22.20% 5,606 774 342 1.3 3.6
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
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
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
342 342 Oregon CBSA Eugene-Springfield, Oregon 5 619 223 363,471 26,897 3,712 1,641 8.6 24 90,330 24.90% 6,684 922 408 2.1 6
278 278 North Carolina CBSA Hickory-Lenoir-Morganton, North Carolina 4 759 273 364,044 26,939 3,718 1,643 7.1 19.6 88,691 24.40% 6,563 906 400 1.7 4.8
380 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
293 293 New Jersey CBSA Trenton-Princeton, New Jersey 5 755 272 373,362 27,629 3,813 1,685 7.3 20.2 75,299 20.20% 5,572 769 340 1.5 4.1
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
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
274 274 Florida CBSA Tallahassee, Florida 4 798 287 377,674.00 27,948 3,857 1,705 7 19.4 70,580.00 18.70% 5,223 721 319 1.3 3.6
199 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
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
276 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
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
174 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
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
146 146 Mississippi CBSA Gulfport-Biloxi, Mississippi 8 1,191 429 406,063.00 30,049 4,147 1,833 5 13.9 83,387.00 20.50% 6,171 852 376 1 2.9
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
391 391 Oregon CBSA Salem, Oregon 4 534 192 410,119 30,349 4,188 1,851 11.3 31.5 87,239 21.30% 6,456 891 394 2.4 6.7
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
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
203 203 Pennsylvania CBSA Reading, Pennsylvania 5 1,080 389 415,500.00 30,747 4,243 1,876 5.7 15.7 93,051.00 22.40% 6,886 950 420 1.3 3.5
207 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
152 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
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
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
338 338 California CBSA Salinas, California 4 740 266 433,168 32,054 4,424 1,955 8.6 24 76,257 17.60% 5,643 779 344 1.5 4.2
165 165 Ohio CBSA Youngstown-Warren-Boardman, Ohio 9 1,235 445 435,198 32,205 4,444 1,964 5.2 14.4 117,766 27.10% 8,715 1,203 532 1.4 3.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
);