CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by Hospitals

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
296 296 Idaho CBSA Pocatello, Idaho 2 185 67 91,780 6,792 937 414 7.3 20.2 17,343 18.90% 1,283 177 78 1.4 3.8
301 301 Pennsylvania CBSA East Stroudsburg, Pennsylvania 2 329 118 167,306.00 12,381 1,709 755 7.5 20.9 37,614.00 22.50% 2,783 384 170 1.7 4.7
302 302 Washington CBSA Walla Walla, Washington 2 117 42 59,862 4,430 611 270 7.5 21 13,443 22.50% 995 137 61 1.7 4.7
309 309 Minnesota CBSA Mankato, Minnesota 2 189 68 99,244 7,344 1,013 448 7.7 21.5 19,046 19.20% 1,409 194 86 1.5 4.1
313 313 South Carolina CBSA Sumter, South Carolina 2 268 96 141,535 10,474 1,445 639 7.8 21.7 33,021 23.30% 2,444 337 149 1.8 5.1
325 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
326 326 West Virginia CBSA Hagerstown-Martinsburg, West Virginia 2 236 85 129,120 9,555 1,319 583 8.1 22.4 27,029 20.90% 2,000 276 122 1.7 4.7
329 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
334 334 Indiana CBSA Elkhart-Goshen, Indiana 2 352 127 202,924 15,016 2,072 916 8.5 23.5 38,669 19.10% 2,862 395 175 1.6 4.5
343 343 Wisconsin CBSA Racine, Wisconsin 2 333 120 195,101.00 14,437 1,992 881 8.6 23.9 42,061.00 21.60% 3,113 430 190 1.9 5.2
345 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
346 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
347 347 Oklahoma CBSA Fort Smith, Oklahoma 2 69 25 41,364 3,061 422 187 8.8 24.4 9,667 23.40% 715 99 44 2.1 5.7
349 349 California CBSA Hanford-Corcoran, California 2 248 89 150,183 11,114 1,534 678 8.9 24.9 20,569 13.70% 1,522 210 93 1.2 3.4
351 351 Illinois CBSA Danville, Illinois 2 130 47 79,207 5,861 809 358 9 24.8 19,371 24.50% 1,433 198 87 2.2 6.1
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
355 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
357 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
369 369 Wisconsin CBSA Fond du Lac, Wisconsin 2 155 56 102,082.00 7,554 1,042 461 9.7 26.8 24,000.00 23.50% 1,776 245 108 2.3 6.3
372 372 Virginia CBSA Kingsport-Bristol, Virginia 2 141 51 93,824.00 6,943 958 424 9.8 27.1 26,693.00 28.50% 1,975 273 120 2.8 7.7
373 373 Wisconsin CBSA Sheboygan, Wisconsin 2 173 62 115,094.00 8,517 1,175 520 9.8 27.3 27,003.00 23.50% 1,998 276 122 2.3 6.4
374 374 California CBSA El Centro, California 2 268 96 179,957 13,317 1,838 812 9.9 27.6 30,768 17.10% 2,277 314 139 1.7 4.7
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
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
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
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
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
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
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
439 439 New Jersey No clean match Wilmington, New Jersey 2 222   No clean match                        
445 445 Washington No clean match Olympia-Tumwater, Washington 2 401   No clean match                        
448 448 Wisconsin No clean match Lake County-Kenosha County, Wisconsin 2 273   No clean match                        
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
141 141 Iowa CBSA Davenport-Moline-Rock Island, Iowa 3 504 181 171,493 12,690 1,751 774 5 14 36,851 21.50% 2,727 376 166 1.1 3
176 176 Colorado CBSA Grand Junction, Colorado 3 412 148 148,798 11,011 1,520 672 5.3 14.8 35,763 24.00% 2,646 365 161 1.3 3.6
178 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
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
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
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
201 201 Idaho CBSA Coeur dAlene, Idaho 3 362 130 138,494 10,249 1,414 625 5.6 15.7             0
217 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
219 219 Arizona CBSA Flagstaff, Arizona 3 342 123 138,639.00 10,259 1,416 626 6 16.6 23,195.00 16.70% 1,716 237 105 1 2.8
222 222 Idaho CBSA Idaho Falls, Idaho 3 345 124 140,427 10,392 1,434 634 6 16.7 25,189 17.90% 1,864 257 114 1.1 3
224 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
227 227 North Carolina CBSA Rocky Mount, North Carolina 3 357 129 148157 10,964 1,513 669 6.1 16.9 35575 24.00% 2,633 363 161 1.5 4.1
228 228 Oregon CBSA Medford, Oregon 3 513 185 212,070 15,693 2,166 957 6.1 16.9 60,113 28.30% 4,448 614 271 1.7 4.8
244 244 Iowa CBSA Omaha-Council Bluffs, Iowa 3 278 100 122,416 9,059 1,250 553 6.5 18 28,628 23.40% 2,118 292 129 1.5 4.2
249 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
250 250 New York CBSA Watertown-Fort Drum, New York 3 261 94 116,567 8,626 1,190 526 6.6 18.3 19,760 17.00% 1,462 202 89 1.1 3.1
254 254 Washington CBSA Mount Vernon-Anacortes, Washington 3 270 97 121,725 9,008 1,243 549 6.6 18.5 31,915 26.20% 2,362 326 144 1.7 4.8
260 260 Georgia CBSA Valdosta, Georgia 3 315 113 143,969 10,654 1,470 650 6.7 18.8 24,673 17.10% 1,826 252 111 1.2 3.2
261 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
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
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
305 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
354 354 Missouri CBSA Jefferson City, Missouri 3 243 87 151,056 11,178 1,543 682 9.2 25.6 32,282 21.40% 2,389 330 146 2 5.5
356 356 South Carolina CBSA Hilton Head Island-Bluffton, South Carolina 3 331 119 206,781 15,302 2,112 933 9.2 25.6 63,228 30.60% 4,679 646 285 2.8 7.8
358 358 Wisconsin CBSA Janesville-Beloit, Wisconsin 3 256 92 161,226.00 11,931 1,646 728 9.3 25.8 34,912.00 21.70% 2,583 357 158 2 5.6
359 359 New York CBSA Kingston, New York 3 280 101 180,129 13,330 1,839 813 9.5 26.3 45,203 25.10% 3,345 462 204 2.4 6.6
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
371 371 California MD San Rafael, California 3 391 141 259,666 19,215 2,652 1,172 9.8 27.1             0
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
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
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
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
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
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
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
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
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
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
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

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