CoronavirusHospitalCapacity_metros

Table actions

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

448 rows sorted by 60plus_PercentOfTotalPopulation

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
47 47 District of Columbia MD District of Columbia, District of Columbia 10 3,114 1121 702,455 51,982 7,173 3,171 3.3 9.2             0
93 93 Minnesota MD St Cloud, Minnesota 4 711 256 199,801 14,785 2,040 902 4.1 11.5             0
102 102 Combined CBSA St Louis, Missouri & Illinois 43 9,555 3440 2,817,355 208,484 28,771 12,718 4.3 12.1             0
132 132 Combined CBSA Louisville-Jefferson County, Kentucky & Indiana 15 3,701 1332 1,222,216 90,444 12,481 5,517 4.9 13.5             0
154 154 California MD San Francisco-San Mateo-Redwood City, California 17 4,747 1709 1,652,850 122,311 16,879 7,461 5.1 14.2             0
159 159 Florida CBSA Tampa-St Petersburg-Clearwater, Florida 34 8,984 3234 3,142,663 232,557 32,093 14,186 5.2 14.3             0
166 166 Tennessee CBSA Nashville-Davidson-Murfreesboro-Franklin, Tennessee 28 5,467 1968 1,930,961 142,891 19,719 8,716 5.2 14.4             0
183 183 Florida MD Miami-Miami Beach-Kendall, Florida 23 7,542 2715 2,761,581 204,357 28,201 12,466 5.4 15             0
191 191 Florida MD West Palm Beach-Boca Raton-Boynton Beach, Florida 15 3,987 1435 1,485,941 109,960 15,174 6,708 5.5 15.2             0
201 201 Idaho CBSA Coeur dAlene, Idaho 3 362 130 138,494 10,249 1,414 625 5.6 15.7             0
206 206 Florida MD Fort Lauderdale-Pompano Beach-Sunrise, Florida 17 5,003 1801 1,951,260 144,393 19,926 8,808 5.7 16             0
243 243 Michigan MD Warren-Troy-Farmington Hills, Michigan 24 5,847 2105 2,572,549 190,369 26,271 11,612 6.5 18             0
246 246 Florida CBSA Port St Lucie, Florida 4 1,088 392 482,040 35,671 4,923 2,176 6.5 18.1             0
272 272 California MD Los Angeles-Long Beach-Glendale, California 89 21,347 7685 10,105,518 747,808 103,198 45,616 7 19.4             0
290 290 Delaware MD Wilmington, Delaware 4 1,473 530 724,768 53,633 7,401 3,272 7.2 20.1             0
311 311 Utah CBSA St George, Utah 1 263 95 138,115 10,221 1,410 623 7.7 21.4             0
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
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
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
371 371 California MD San Rafael, California 3 391 141 259,666 19,215 2,652 1,172 9.8 27.1             0
423 423 Michigan CBSA Grand Rapids-Wyoming, Michigan 1 39 14 988,938 73,181 10,099 4,464 373.4 1040.2              
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                        
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
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
420 420 Georgia CBSA Hinesville, Georgia 1 25 9 79,977 5,918 817 361 47.1 130.9 9,845 12.30% 729 101 44 5.8 16.1
226 226 Kansas CBSA Manhattan, Kansas 5 326 117 134,680 9,966 1,375 608 6.1 16.9 16,988 12.60% 1,257 173 77 0.8 2.1
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
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
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
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
264 264 Alaska CBSA Fairbanks, Alaska 1 217 78 100,031 7,402 1,022 452 6.8 18.9 13,950 13.90% 1,032 142 63 0.9 2.6
205 205 Texas CBSA McAllen-Edinburg-Mission, Texas 8 2,187 787 839,539 62,126 8,573 3,790 5.7 15.7 119,536 14.20% 8,846 1,221 540 0.8 2.2
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
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
230 230 Utah CBSA Salt Lake City, Utah 17 2,817 1014 1,170,057 86,584 11,949 5,282 6.1 17 172,787 14.80% 12,786 1,765 780 0.9 2.5
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
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
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
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
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
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
229 229 Texas CBSA Houston-The Woodlands-Sugar Land, Texas 89 16,014 5765 6,636,208 491,079 67,769 29,956 6.1 17 1,011,707 15.20% 74,866 10,332 4,567 0.9 2.6
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
248 248 Texas CBSA Midland, Texas 4 372 134 165,430 12,242 1,689 747 6.5 18.2 25,575 15.50% 1,893 261 115 1 2.8
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
97 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
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
245 245 Texas CBSA El Paso, Texas 12 1,897 683 838,527 62,051 8,563 3,785 6.5 18.1 133,833 16.00% 9,904 1,367 604 1 2.9
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
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
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
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
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
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
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
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
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
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
240 240 Arkansas CBSA Fayetteville-Springdale-Rogers, Arkansas 9 1,135 409 491,413 36,365 5,018 2,218 6.4 17.7 83,204 16.90% 6,157 850 376 1.1 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
63 63 Oklahoma CBSA Lawton, Oklahoma 2 530 191 129,066 9,551 1,318 583 3.6 10 21,927 17.00% 1,623 224 99 0.6 1.7
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
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
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
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
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
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
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
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
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
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
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
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
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
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
156 156 Nebraska CBSA Omaha-Council Bluffs, Nebraska 15 2,273 818 791,774 58,591 8,086 3,574 5.1 14.3 138,052 17.40% 10,216 1,410 623 0.9 2.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
);