CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by PatientsPerBed_allages 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
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
375 375 California CBSA Stockton, California 7 1,077 388 724,153 53,587 7,395 3,269 9.9 27.5 123,774 17.10% 9,159 1,264 559 1.7 4.7
376 376 New Mexico CBSA Santa Fe, New Mexico 1 219 79 147,514 10,916 1,506 666 9.9 27.5 42,681 28.90% 3,158 436 193 2.9 8
371 371 California MD San Rafael, California 3 391 141 259,666 19,215 2,652 1,172 9.8 27.1             0
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
366 366 Idaho CBSA Logan, Idaho 1 20 7 13,120 971 134 59 9.7 27.6 2,458 18.70% 182 25 11 1.8 5.1
367 367 New York CBSA Ithaca, New York 1 159 57 104,415 7,727 1,066 471 9.7 27 18,998 18.20% 1,406 194 86 1.8 4.9
368 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
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
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
365 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
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
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
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
362 362 California CBSA Vallejo, California 4 672 242 434,981 32,189 4,442 1,964 9.5 26.5 90,069 20.70% 6,665 920 407 2 5.5
363 363 New Mexico CBSA Farmington, New Mexico 1 198 71 128,221 9,488 1,309 579 9.5 26.6 23,922 18.70% 1,770 244 108 1.8 5
364 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
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
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
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
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
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
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
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
352 352 California CBSA Santa Rosa-Petaluma, California 8 821 296 500,943 37,070 5,116 2,261 9 24.9 124,291 24.80% 9,198 1,269 561 2.2 6.2
348 348 New York CBSA Poughkeepsie-Newburgh-Middletown, New York 6 1,120 403 673,859 49,866 6,881 3,042 8.9 24.6 137,318 20.40% 10,162 1,402 620 1.8 5
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
350 350 North Carolina CBSA New Bern, North Carolina 1 208 75 125,953 9,321 1,286 569 8.9 24.7 31,787 25.20% 2,352 325 143 2.3 6.2
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
344 344 California CBSA San Jose-Sunnyvale-Santa Clara, California 11 3,321 1196 1,969,897 145,772 20,117 8,892 8.7 24.3 348,794 17.70% 25,811 3,562 1,574 1.5 4.3
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
337 337 Florida CBSA Panama City, Florida 5 308 111 180,117.00 13,329 1,839 813 8.6 23.9 40,210.00 22.30% 2,976 411 182 1.9 5.3
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
339 339 California CBSA Sacramento-Roseville-Folsom, California 17 3,875 1395 2,268,005 167,832 23,161 10,238 8.6 23.9 456,252 20.10% 33,763 4,659 2,060 1.7 4.8
340 340 California CBSA Riverside-San Bernardino-Ontario, California 38 7,640 2750 4,476,222 331,240 45,711 20,206 8.6 24 767,628 17.10% 56,804 7,839 3,465 1.5 4.1
341 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
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
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
331 331 California CBSA Fresno, California 8 1,692 609 971,616 71,900 9,922 4,386 8.5 23.5 157,757 16.20% 11,674 1,611 712 1.4 3.8
332 332 Virginia CBSA Staunton, Virginia 1 209 75 120,283.00 8,901 1,228 543 8.5 23.6 31,060.00 25.80% 2,298 317 140 2.2 6.1
333 333 Washington CBSA Longview, Washington 1 180 65 103,590 7,666 1,058 468 8.5 23.5 26,255 25.30% 1,943 268 119 2.1 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
335 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
336 336 Utah CBSA Ogden-Clearfield, Utah 9 1,108 399 642,274 47,528 6,559 2,899 8.5 23.7 95,645 14.90% 7,078 977 432 1.3 3.5
328 328 California CBSA San Diego-Chula Vista-Carlsbad, California 18 5,750 2070 3,283,665 242,991 33,533 14,822 8.4 23.4 604,412 18.40% 44,726 6,172 2,728 1.5 4.3
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
330 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
327 327 Combined CBSA Minneapolis-St Paul-Bloomington, Minnesota and Wisconsin 34 6452 2323 3,629,190 268,560 37,061 16,382 8.3 23             0
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
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
323 323 New Mexico CBSA Las Cruces, New Mexico 4 395 142 213,849 15,825 2,184 965 8 22.2 41,981 19.60% 3,107 429 190 1.6 4.4
324 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
317 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
318 318 Maryland CBSA Hagerstown-Martinsburg, Maryland 1 278 100 149,546 11,066 1,527 675 7.9 22 33,148 22.20% 2,453 339 150 1.8 4.9
319 319 Massachusetts CBSA Providence-Warwick, Massachusetts 5 1,032 372 557,016 41,219 5,688 2,514 7.9 22 124,173 22.30% 9,189 1,268 561 1.8 4.9
320 320 Oregon CBSA Portland-Vancouver-Hillsboro, Oregon 17 3,552 1279 1,913,065 141,567 19,536 8,636 7.9 22 374,979 19.60% 27,748 3,829 1,693 1.6 4.3
321 321 Virginia CBSA Harrisonburg, Virginia 1 244 88 131,717.00 9,747 1,345 595 7.9 22 25,590.00 19.40% 1,894 261 116 1.5 4.3
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
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
314 314 New Jersey CBSA Ocean City, New Jersey 1 178 64 94,549 6,997 966 427 7.8 21.8 31,925 33.80% 2,362 326 144 2.6 7.3
315 315 Pennsylvania CBSA Lancaster, Pennsylvania 5 1,007 363 536,494.00 39,701 5,479 2,422 7.8 21.8 122,633.00 22.90% 9,075 1,252 554 1.8 5
316 316 West Virginia CBSA Winchester, West Virginia 1 44 16 23,412 1,732 239 106 7.8 21.6 6,811 29.10% 504 70 31 2.3 6.3
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
307 307 Hawaii CBSA Urban Honolulu, Hawaii 11 1,895 682 990,060 73,264 10,110 4,469 7.7 21.4 218,287 22.00% 16,153 2,229 985 1.7 4.7
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
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
310 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
311 311 Utah CBSA St George, Utah 1 263 95 138,115 10,221 1,410 623 7.7 21.4             0
304 304 California CBSA Santa Maria-Santa Barbara, California 5 858 309 442,996 32,782 4,524 2,000 7.6 21.1 86,816 19.60% 6,424 887 392 1.5 4.1
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
300 300 Colorado CBSA Denver-Aurora-Lakewood, Colorado 26 5,527 1990 2,798,684 207,103 28,580 12,633 7.5 20.7 491,072 17.50% 36,339 5,015 2,217 1.3 3.6
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
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
298 298 Arizona CBSA Phoenix-Mesa-Chandler, Arizona 46 9104 3277 4,561,038.00 337,517 46,577 20,589 7.4 20.5 908,620.00 19.90% 67,238 9,279 4,102 1.5 4.1
299 299 Wisconsin CBSA Wausau-Weston, Wisconsin 4 325 117 163,287.00 12,083 1,667 737 7.4 20.5 38,558.00 23.60% 2,853 394 174 1.7 4.9
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
292 292 Massachusetts CBSA Worcester, Massachusetts 9 1,659 597 818,249 60,550 8,356 3,694 7.3 20.2 170,081 20.80% 12,586 1,737 768 1.5 4.2
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
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
295 295 Georgia CBSA Warner Robins, Georgia 4 358 129 177,368 13,125 1,811 801 7.3 20.2 30,723 17.30% 2,274 314 139 1.3 3.5
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
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
288 288 California CBSA Napa, California 2 289 104 141,005 10,434 1,440 636 7.2 20 33,686 23.90% 2,493 344 152 1.7 4.8
289 289 Kentucky CBSA Elizabethtown-Fort Knox, Kentucky 2 308 111 150,253 11,119 1,534 678 7.2 19.9 27,818 18.50% 2,059 284 126 1.3 3.7
290 290 Delaware MD Wilmington, Delaware 4 1,473 530 724,768 53,633 7,401 3,272 7.2 20.1             0
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
279 279 Ohio CBSA Springfield, Ohio 2 283 102 135,520 10,028 1,384 612 7.1 19.6 33,970 25.10% 2,514 347 153 1.8 4.9
280 280 Virginia CBSA Virginia Beach-Norfolk-Newport News, Virginia 18 3,556 1280 1,707,283.00 126,339 17,435 7,707 7.1 19.6 326,159.00 19.10% 24,136 3,331 1,472 1.4 3.8
281 281 California CBSA Modesto, California 6 1,113 401 535,684 39,641 5,470 2,418 7.1 19.7 92,698 17.30% 6,860 947 418 1.2 3.4
282 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
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
284 284 Pennsylvania CBSA State College, Pennsylvania 2 333 120 160,646.00 11,888 1,641 725 7.1 19.7 29,386.00 18.30% 2,175 300 133 1.3 3.6
285 285 Rhode Island CBSA Providence-Warwick, Rhode Island 11 2,187 787 1,056,138.00 78,154 10,785 4,767 7.1 19.8 237,693.00 22.50% 17,589 2,427 1,073 1.6 4.4
286 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
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
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

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