CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by PatientsPerBed_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                        
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
377 377 Alabama CBSA Daphne-Fairhope-Foley, Alabama 3 298 107 203,360 15,049 2,077 918 10 28 53,519 26.30% 3,960 547 242 2.6 7.4
378 378 North Carolina CBSA Fayetteville, North Carolina 3 754 271 514090 38,043 5,250 2,321 10 27.9 80286 15.60% 5,941 820 362 1.6 4.4
379 379 North Carolina CBSA Raleigh-Cary, North Carolina 5 1,867 672 1,273,985 94,275 13,010 5,751 10 27.9 205,440 16.10% 15,203 2,098 927 1.6 4.5
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
381 381 Arizona CBSA Prescott Valley-Prescott, Arizona 3 320 115 220,972.00 16,352 2,257 997 10.2 28.3 85,127.00 38.50% 6,299 869 384 3.9 10.9
382 382 Oregon CBSA Grants Pass, Oregon 1 121 44 84,514 6,254 863 381 10.3 28.3 28,339 33.50% 2,097 289 128 3.4 9.5
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
384 384 Virginia CBSA Washington-Arlington-Alexandria, Virginia 19 4,079 1468 2,937,931.00 217,407 30,002 13,262 10.6 29.5 475,124.00 16.20% 35,159 4,852 2,145 1.7 4.8
385 385 Connecticut CBSA Worcester, Connecticut 2 161 58 116,674 8,634 1,191 527 10.7 29.6 25,482 21.80% 1,886 260 115 2.3 6.5
386 386 Washington CBSA Portland-Vancouver-Hillsboro, Washington 2 647 233 468,972 34,704 4,789 2,117 10.7 29.6 96,088 20.50% 7,111 981 434 2.2 6.1
387 387 California CBSA Yuba City, California 2 233 84 170,227 12,597 1,738 768 10.8 29.8 31,546 18.50% 2,334 322 142 2 5.5
424 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
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
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
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
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
392 392 California CBSA Visalia, California 2 595 214 458,809 33,952 4,685 2,071 11.4 31.6 69,266 15.10% 5,126 707 313 1.7 4.8
393 393 California CBSA Oxnard-Thousand Oaks-Ventura, California 7 1,087 391 847,834 62,740 8,658 3,827 11.5 31.9 167,777 19.80% 12,415 1,713 757 2.3 6.3
394 394 Utah CBSA Provo-Orem, Utah 7 748 269 587,190 43,452 5,996 2,651 11.6 32.1 61,165 10.40% 4,526 625 276 1.2 3.3
395 395 Arizona CBSA Sierra Vista-Douglas, Arizona 4 160 58 126,516.00 9,362 1,292 571 11.6 32.1 35,231.00 27.80% 2,607 360 159 3.2 8.9
396 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
422 422 Ohio CBSA Huntington-Ashland, Ohio 1 8 3 61,057 4,518 624 276 112.4 300 14,970 24.50% 1,108 153 68 27.6 73.7
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
398 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
399 399 Delaware CBSA Salisbury, Delaware 2 254 91 215,551 15,951 2,201 973 12.5 34.9 71,832 33.30% 5,316 734 324 4.2 11.6
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
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
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
403 403 Alabama CBSA Decatur, Alabama 2 153 55 152,445 11,281 1,557 688 14.7 40.8 34,449 22.60% 2,549 352 156 3.3 9.2
404 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
405 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
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
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
408 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
409 409 North Carolina CBSA Jacksonville, North Carolina 1 149 54 192,685 14,259 1,968 870 19 52.6 22,983 11.90% 1,701 235 104 2.3 6.3
410 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
411 411 Pennsylvania CBSA Gettysburg, Pennsylvania 1 76 27 101,589.00 7,518 1,037 459 19.7 55.4 26,312.00 25.90% 1,947 269 119 5.1 14.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
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
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
414 414 Wisconsin CBSA Duluth, Wisconsin 1 25 9 43,503.00 3,219 444 196 25.6 71.1 10,444.00 24.00% 773 107 47 6.2 17.1
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

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