aha2018staffing_cbsa
Data source: Big Local News · About: big-local-datasette
384 rows sorted by resp_fte descending
This data as json, copyable, CSV (advanced)
Link | rowid | CBSACODE | CBSANAME | hospitals | hospbeds | resid_ft | rn_ft | lpn_ft | resp_ft | tot_ft | resid_pt | rn_pt | lpn_pt | resp_pt | tot_pt | resid_fte | rn_fte | lpn_fte | resp_fte ▲ | tot_fte | physpriv | pop2018_tot | pop2018_60plus | pop2018_60pluspct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
250 | 250 | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 129 | 47568 | 19312 | 90761 | 2425 | 3416 | 351486 | 286 | 24303 | 519 | 1521 | 86332 | 19458 | 102912 | 2688 | 4176 | 374778 | 40545 | 19303808 | 4217221 | 0.218465755564912 |
211 | 211 | 31080 | Los Angeles-Long Beach-Anaheim, CA | 116 | 27247 | 3652 | 49602 | 2319 | 3084 | 157159 | 23 | 20504 | 765 | 1800 | 54446 | 3663 | 59852 | 2701 | 3984 | 180232 | 3569 | 13291486 | 2601177 | 0.195702497072186 |
69 | 69 | 16980 | Chicago-Naperville-Elgin, IL-IN-WI | 96 | 24317 | 6477 | 40583 | 569 | 2151 | 137919 | 842 | 19098 | 285 | 1250 | 61967 | 6897 | 50135 | 718 | 2776 | 161826 | 9238 | 9498716 | 1961714 | 0.206524123892113 |
87 | 87 | 19100 | Dallas-Fort Worth-Arlington, TX | 121 | 16353 | 2094 | 31211 | 975 | 2041 | 86730 | 194 | 10342 | 202 | 1015 | 26443 | 2191 | 36384 | 1078 | 2548 | 97506 | 3023 | 7470158 | 1223097 | 0.163731075032148 |
160 | 160 | 26420 | Houston-The Woodlands-Sugar Land, TX | 89 | 16014 | 1085 | 32008 | 817 | 1809 | 98540 | 81 | 5328 | 150 | 597 | 15234 | 1126 | 34673 | 893 | 2108 | 104078 | 4563 | 6997384 | 1147394 | 0.163974708262402 |
270 | 270 | 37980 | Philadelphia-Camden-Wilmington, PA-NJ-DE-MD | 69 | 16908 | 5113 | 31719 | 605 | 1489 | 109663 | 120 | 13184 | 240 | 851 | 38412 | 5173 | 38312 | 727 | 1914 | 123425 | 8587 | 6096372 | 1370514 | 0.224808131787233 |
226 | 226 | 33100 | Miami-Fort Lauderdale-Pompano Beach, FL | 55 | 16532 | 2085 | 26116 | 774 | 1405 | 76940 | 0 | 4995 | 169 | 487 | 15172 | 2085 | 28613 | 860 | 1648 | 82391 | 3731 | 6198782 | 1501643 | 0.242248073895807 |
18 | 18 | 12060 | Atlanta-Sandy Springs-Alpharetta, GA | 44 | 10632 | 819 | 19687 | 757 | 1217 | 62460 | 20 | 6042 | 210 | 483 | 16993 | 830 | 22705 | 861 | 1458 | 69905 | 2000 | 5949951 | 1053699 | 0.177093727326494 |
271 | 271 | 38060 | Phoenix-Mesa-Chandler, AZ | 46 | 9104 | 851 | 17361 | 212 | 1296 | 48597 | 1 | 4475 | 59 | 259 | 10150 | 851 | 19599 | 240 | 1426 | 52759 | 4091 | 4857962 | 1029136 | 0.211845214104186 |
43 | 43 | 14460 | Boston-Cambridge-Newton, MA-NH | 51 | 11222 | 5082 | 20710 | 540 | 903 | 99035 | 43 | 16581 | 260 | 633 | 49695 | 5102 | 28998 | 674 | 1220 | 118049 | 8248 | 4875390 | 1072179 | 0.219916560521312 |
98 | 98 | 19820 | Detroit-Warren-Dearborn, MI | 43 | 10941 | 3720 | 20504 | 121 | 947 | 59594 | 1 | 8551 | 66 | 485 | 25879 | 3720 | 24781 | 153 | 1190 | 68644 | 4838 | 4326442 | 1003600 | 0.231968901929114 |
292 | 292 | 40140 | Riverside-San Bernardino-Ontario, CA | 38 | 7640 | 627 | 13602 | 856 | 914 | 39098 | 20 | 4852 | 182 | 483 | 12234 | 636 | 16026 | 949 | 1156 | 44519 | 1320 | 4622361 | 851542 | 0.184222305440878 |
366 | 366 | 47900 | Washington-Arlington-Alexandria, DC-VA-MD-WV | 44 | 9986 | 1903 | 17286 | 380 | 933 | 55874 | 26 | 7487 | 103 | 424 | 19789 | 1915 | 21031 | 433 | 1145 | 63766 | 2951 | 6263245 | 1166337 | 0.18621928409315 |
312 | 312 | 41860 | San Francisco-Oakland-Berkeley, CA | 40 | 9510 | 2228 | 12196 | 614 | 743 | 47506 | 21 | 13004 | 324 | 643 | 30219 | 2238 | 18695 | 776 | 1064 | 60323 | 2817 | 4729484 | 1015533 | 0.214723847252681 |
343 | 343 | 45300 | Tampa-St. Petersburg-Clearwater, FL | 34 | 8984 | 202 | 14212 | 322 | 874 | 42973 | 0 | 4043 | 83 | 354 | 11684 | 202 | 16233 | 363 | 1051 | 48577 | 986 | 3142663 | 828833 | 0.263735882593838 |
273 | 273 | 38300 | Pittsburgh, PA | 35 | 7400 | 1747 | 13452 | 284 | 877 | 39726 | 3 | 4240 | 83 | 269 | 12177 | 1749 | 15570 | 325 | 1012 | 43943 | 1302 | 2324743 | 641560 | 0.275970290049266 |
74 | 74 | 17460 | Cleveland-Elyria, OH | 31 | 7853 | 2858 | 16723 | 821 | 791 | 60864 | 5 | 5527 | 236 | 376 | 16804 | 2860 | 19486 | 942 | 979 | 65744 | 13360 | 2057009 | 526756 | 0.256078607337158 |
24 | 24 | 12580 | Baltimore-Columbia-Towson, MD | 24 | 7143 | 1495 | 14759 | 194 | 740 | 51473 | 15 | 5633 | 66 | 445 | 16928 | 1502 | 17575 | 227 | 962 | 58252 | 3366 | 2802789 | 613056 | 0.218730700027722 |
311 | 311 | 41740 | San Diego-Chula Vista-Carlsbad, CA | 18 | 5750 | 876 | 11754 | 378 | 690 | 33196 | 2 | 5728 | 150 | 398 | 14799 | 878 | 14616 | 450 | 889 | 39693 | 0 | 3343364 | 657318 | 0.196603779905508 |
71 | 71 | 17140 | Cincinnati, OH-KY-IN | 28 | 5820 | 1587 | 9902 | 255 | 680 | 36231 | 48 | 6684 | 136 | 415 | 17148 | 1611 | 13244 | 323 | 888 | 43025 | 4468 | 2212945 | 480288 | 0.217035669661921 |
304 | 304 | 41180 | St. Louis, MO-IL | 43 | 9555 | 1227 | 16192 | 252 | 738 | 46968 | 52 | 5092 | 100 | 286 | 14950 | 1252 | 18740 | 306 | 881 | 53189 | 3191 | 2805465 | 655939 | 0.233807586264666 |
261 | 261 | 36740 | Orlando-Kissimmee-Sanford, FL | 14 | 6665 | 498 | 11661 | 189 | 717 | 36240 | 40 | 4578 | 168 | 276 | 12962 | 518 | 13949 | 272 | 855 | 42182 | 997 | 2572962 | 524021 | 0.203664492518739 |
181 | 181 | 28140 | Kansas City, MO-KS | 41 | 6576 | 137 | 11178 | 371 | 680 | 38170 | 22 | 5827 | 83 | 314 | 16003 | 148 | 14091 | 412 | 837 | 45824 | 2693 | 2143651 | 448252 | 0.209106799567653 |
164 | 164 | 26900 | Indianapolis-Carmel-Anderson, IN | 28 | 5395 | 927 | 9141 | 303 | 659 | 34800 | 8 | 4191 | 115 | 340 | 12494 | 932 | 11238 | 361 | 829 | 40076 | 5265 | 2048703 | 401536 | 0.195995222343112 |
82 | 82 | 18140 | Columbus, OH | 23 | 5668 | 1458 | 11642 | 276 | 645 | 42623 | 39 | 4236 | 121 | 285 | 13145 | 1477 | 13759 | 333 | 788 | 47659 | 3364 | 2106541 | 400030 | 0.189898986062934 |
65 | 65 | 16740 | Charlotte-Concord-Gastonia, NC-SC | 23 | 4906 | 128 | 8957 | 286 | 583 | 26663 | 1 | 3864 | 68 | 270 | 9455 | 128 | 10891 | 321 | 718 | 31252 | 1013 | 2594090 | 499968 | 0.192733482647094 |
231 | 231 | 33460 | Minneapolis-St. Paul-Bloomington, MN-WI | 34 | 6452 | 450 | 5416 | 170 | 391 | 28312 | 25 | 17546 | 309 | 617 | 39783 | 462 | 14188 | 326 | 700 | 47676 | 3549 | 3614162 | 723958 | 0.200311441490448 |
310 | 310 | 41700 | San Antonio-New Braunfels, TX | 26 | 6009 | 468 | 9285 | 634 | 609 | 25970 | 0 | 1589 | 119 | 180 | 4327 | 468 | 10078 | 692 | 699 | 27654 | 262 | 2518036 | 461018 | 0.183086341895032 |
246 | 246 | 34980 | Nashville-Davidson-Murfreesboro-Franklin, TN | 28 | 5467 | 1454 | 10255 | 675 | 558 | 40655 | 7 | 3974 | 183 | 267 | 12261 | 1459 | 12241 | 766 | 692 | 45311 | 1579 | 1905898 | 362768 | 0.190339671902694 |
249 | 249 | 35380 | New Orleans-Metairie, LA | 29 | 4245 | 356 | 6628 | 836 | 533 | 22716 | 0 | 2673 | 229 | 297 | 7098 | 356 | 7959 | 948 | 682 | 25881 | 2145 | 1270399 | 286150 | 0.225244194934033 |
96 | 96 | 19740 | Denver-Aurora-Lakewood, CO | 26 | 5527 | 443 | 11163 | 193 | 522 | 33958 | 10 | 3745 | 65 | 295 | 9831 | 449 | 13035 | 226 | 670 | 38403 | 1006 | 2932415 | 546718 | 0.186439504640373 |
198 | 198 | 29820 | Las Vegas-Henderson-Paradise, NV | 24 | 4590 | 154 | 7047 | 288 | 527 | 20434 | 0 | 1430 | 72 | 169 | 4049 | 154 | 7760 | 324 | 612 | 22298 | 156 | 2231647 | 454888 | 0.203835104745509 |
258 | 258 | 36420 | Oklahoma City, OK | 31 | 4225 | 139 | 6160 | 362 | 497 | 19461 | 7 | 2648 | 92 | 212 | 6262 | 143 | 7483 | 409 | 603 | 22343 | 1377 | 1396445 | 274396 | 0.196496102603396 |
36 | 36 | 13820 | Birmingham-Hoover, AL | 17 | 4632 | 891 | 8735 | 210 | 504 | 23191 | 3 | 1990 | 42 | 173 | 5167 | 893 | 9730 | 230 | 590 | 24880 | 1678 | 1088090 | 243658 | 0.223931843873209 |
321 | 321 | 42660 | Seattle-Tacoma-Bellevue, WA | 28 | 6702 | 1131 | 11026 | 308 | 398 | 41786 | 150 | 8058 | 200 | 382 | 20923 | 1206 | 15055 | 407 | 589 | 50985 | 10929 | 3939363 | 758420 | 0.192523512050045 |
277 | 277 | 38900 | Portland-Vancouver-Hillsboro, OR-WA | 19 | 4199 | 1140 | 8514 | 53 | 462 | 26763 | 222 | 4518 | 29 | 187 | 11721 | 1251 | 10775 | 68 | 556 | 31344 | 5838 | 2478810 | 519060 | 0.209398864777857 |
212 | 212 | 31140 | Louisville-Jefferson County, KY-IN | 15 | 3701 | 0 | 6542 | 190 | 443 | 17372 | 5 | 2752 | 119 | 216 | 6904 | 3 | 7917 | 249 | 551 | 20820 | 519 | 1264908 | 284540 | 0.224949166263475 |
207 | 207 | 30780 | Little Rock-North Little Rock-Conway, AR | 17 | 3103 | 5 | 5187 | 278 | 411 | 15536 | 5 | 3008 | 118 | 199 | 8966 | 7 | 6692 | 337 | 510 | 19995 | 918 | 741104 | 158221 | 0.21349365271271 |
230 | 230 | 33340 | Milwaukee-Waukesha, WI | 24 | 4030 | 172 | 7546 | 49 | 415 | 23573 | 0 | 4392 | 40 | 188 | 13864 | 172 | 9741 | 69 | 509 | 30047 | 1044 | 1576113 | 348103 | 0.220861702174907 |
92 | 92 | 19430 | Dayton-Kettering, OH | 11 | 1994 | 505 | 5298 | 53 | 400 | 15999 | 0 | 2406 | 30 | 210 | 6734 | 505 | 6502 | 68 | 505 | 18832 | 212 | 806548 | 197871 | 0.245330718072576 |
313 | 313 | 41940 | San Jose-Sunnyvale-Santa Clara, CA | 11 | 3321 | 1692 | 6375 | 125 | 337 | 24372 | 15 | 5856 | 103 | 333 | 13647 | 1698 | 9305 | 179 | 504 | 29456 | 2067 | 1999107 | 377024 | 0.188596208206964 |
299 | 299 | 40900 | Sacramento-Roseville-Folsom, CA | 17 | 3875 | 1044 | 6253 | 238 | 359 | 21664 | 30 | 4806 | 104 | 284 | 11369 | 1060 | 8655 | 289 | 501 | 26266 | 1133 | 2345210 | 504257 | 0.215015712878591 |
308 | 308 | 41620 | Salt Lake City, UT | 17 | 2817 | 1017 | 6559 | 90 | 390 | 21639 | 3 | 2751 | 30 | 150 | 7512 | 1018 | 7935 | 105 | 465 | 24263 | 1637 | 1222540 | 190032 | 0.155440312791402 |
170 | 170 | 27260 | Jacksonville, FL | 14 | 4158 | 599 | 6345 | 85 | 395 | 18741 | 0 | 1893 | 30 | 116 | 4396 | 599 | 7293 | 101 | 453 | 20318 | 1267 | 1534701 | 339920 | 0.221489397609046 |
291 | 291 | 40060 | Richmond, VA | 16 | 3671 | 998 | 6231 | 405 | 362 | 20727 | 2 | 2108 | 80 | 149 | 5437 | 999 | 7285 | 445 | 436 | 22368 | 29 | 1282442 | 282927 | 0.220615825121136 |
361 | 361 | 47260 | Virginia Beach-Norfolk-Newport News, VA-NC | 18 | 3556 | 86 | 6481 | 401 | 355 | 21401 | 1 | 2291 | 104 | 156 | 6855 | 87 | 7627 | 454 | 433 | 24678 | 2245 | 1765042 | 367457 | 0.208185980843515 |
260 | 260 | 36540 | Omaha-Council Bluffs, NE-IA | 18 | 2551 | 12 | 4845 | 131 | 327 | 15209 | 1 | 2103 | 62 | 189 | 7529 | 13 | 5897 | 165 | 422 | 18956 | 1404 | 942198 | 183775 | 0.195049235935546 |
224 | 224 | 32820 | Memphis, TN-MS-AR | 17 | 3879 | 62 | 4787 | 103 | 346 | 14721 | 35 | 1716 | 37 | 140 | 4002 | 79 | 5642 | 120 | 416 | 16623 | 1040 | 1342349 | 268715 | 0.200182664865843 |
103 | 103 | 20500 | Durham-Chapel Hill, NC | 8 | 2425 | 1563 | 7307 | 76 | 362 | 23381 | 0 | 1024 | 35 | 61 | 2695 | 1563 | 7819 | 93 | 392 | 23156 | 112 | 635527 | 136957 | 0.215501465712708 |
138 | 138 | 24340 | Grand Rapids-Kentwood, MI | 11 | 2491 | 193 | 4081 | 249 | 302 | 16454 | 0 | 2071 | 93 | 100 | 7334 | 193 | 5117 | 296 | 352 | 19845 | 1514 | 1072458 | 217480 | 0.202786496067911 |
145 | 145 | 24860 | Greenville-Anderson, SC | 14 | 2096 | 299 | 3568 | 69 | 274 | 11173 | 0 | 2174 | 32 | 156 | 5134 | 299 | 4656 | 86 | 352 | 13442 | 7251 | 906626 | 206572 | 0.227846984313267 |
281 | 281 | 39300 | Providence-Warwick, RI-MA | 16 | 3219 | 789 | 4428 | 113 | 193 | 17834 | 5 | 4573 | 77 | 316 | 14002 | 791 | 6714 | 152 | 351 | 23974 | 1773 | 1621337 | 387233 | 0.238835602962247 |
13 | 13 | 11460 | Ann Arbor, MI | 5 | 1641 | 1504 | 6062 | 122 | 313 | 19930 | 35 | 2483 | 26 | 74 | 6077 | 1521 | 7304 | 135 | 350 | 21448 | 327 | 370963 | 71921 | 0.193876478247157 |
347 | 347 | 45780 | Toledo, OH | 14 | 2359 | 193 | 4760 | 144 | 296 | 12265 | 1 | 1032 | 65 | 93 | 3788 | 193 | 5274 | 176 | 342 | 13964 | 1225 | 643640 | 151599 | 0.235533838791871 |
50 | 50 | 15380 | Buffalo-Cheektowaga, NY | 10 | 4188 | 60 | 6371 | 455 | 274 | 19204 | 5 | 2157 | 181 | 134 | 7531 | 62 | 7450 | 546 | 341 | 22824 | 1000 | 1130152 | 286559 | 0.253557928491035 |
351 | 351 | 46140 | Tulsa, OK | 26 | 3111 | 12 | 4615 | 193 | 299 | 13751 | 0 | 861 | 47 | 83 | 2628 | 12 | 5047 | 218 | 340 | 15051 | 419 | 993797 | 214858 | 0.216199082911299 |
168 | 168 | 27140 | Jackson, MS | 16 | 2670 | 626 | 3769 | 239 | 276 | 12775 | 0 | 1143 | 46 | 123 | 2933 | 626 | 4341 | 261 | 338 | 13617 | 731 | 597788 | 123645 | 0.206837541068071 |
204 | 204 | 30460 | Lexington-Fayette, KY | 11 | 2269 | 923 | 4083 | 107 | 304 | 13164 | 30 | 1403 | 30 | 64 | 3744 | 938 | 4786 | 123 | 336 | 14097 | 1239 | 516697 | 103516 | 0.200341786385444 |
350 | 350 | 46060 | Tucson, AZ | 12 | 2654 | 25 | 3818 | 51 | 268 | 11187 | 0 | 1202 | 23 | 92 | 3108 | 25 | 4418 | 63 | 314 | 12712 | 1908 | 1039073 | 270651 | 0.260473518222493 |
295 | 295 | 40380 | Rochester, NY | 10 | 3108 | 712 | 6810 | 865 | 258 | 25616 | 329 | 1993 | 225 | 74 | 8185 | 876 | 7809 | 979 | 295 | 28771 | 3307 | 1071082 | 264448 | 0.246897996605302 |
79 | 79 | 17900 | Columbia, SC | 8 | 2064 | 281 | 3726 | 119 | 242 | 11711 | 3 | 1570 | 67 | 104 | 4133 | 283 | 4510 | 153 | 294 | 13493 | 1452 | 832666 | 174465 | 0.209525788251232 |
8 | 8 | 10900 | Allentown-Bethlehem-Easton, PA-NJ | 12 | 2683 | 588 | 4130 | 74 | 227 | 16570 | 10 | 2355 | 47 | 130 | 6686 | 593 | 5308 | 99 | 292 | 19315 | 2773 | 842913 | 209670 | 0.248744532353873 |
186 | 186 | 28940 | Knoxville, TN | 11 | 2390 | 15 | 3761 | 237 | 235 | 12039 | 1 | 1026 | 45 | 91 | 3040 | 16 | 4276 | 260 | 280 | 13488 | 312 | 860164 | 214489 | 0.249358261912845 |
6 | 6 | 10740 | Albuquerque, NM | 10 | 1870 | 20 | 4483 | 125 | 201 | 14508 | 0 | 1512 | 62 | 146 | 3654 | 20 | 5240 | 156 | 274 | 16280 | 579 | 915927 | 212806 | 0.232339476836036 |
248 | 248 | 35300 | New Haven-Milford, CT | 9 | 2272 | 1482 | 4963 | 90 | 212 | 15513 | 1 | 2889 | 56 | 122 | 8129 | 1483 | 6408 | 118 | 273 | 18089 | 546 | 857620 | 205879 | 0.240058534082694 |
130 | 130 | 23540 | Gainesville, FL | 4 | 1548 | 682 | 3227 | 56 | 244 | 9676 | 0 | 849 | 19 | 57 | 2415 | 682 | 3652 | 65 | 272 | 10193 | 0 | 328982 | 70849 | 0.215358287079536 |
27 | 27 | 12940 | Baton Rouge, LA | 18 | 2495 | 98 | 3365 | 487 | 213 | 12596 | 2 | 1750 | 157 | 116 | 4797 | 99 | 4241 | 565 | 271 | 14895 | 349 | 853610 | 171355 | 0.200741556448495 |
5 | 5 | 10580 | Albany-Schenectady-Troy, NY | 8 | 2453 | 525 | 4421 | 230 | 240 | 16047 | 3 | 846 | 40 | 51 | 2897 | 527 | 4842 | 249 | 266 | 16968 | 706 | 883169 | 213350 | 0.241573243626078 |
21 | 21 | 12260 | Augusta-Richmond County, GA-SC | 10 | 1969 | 23 | 3081 | 157 | 236 | 8967 | 0 | 934 | 29 | 56 | 2063 | 23 | 3548 | 172 | 264 | 9970 | 230 | 604167 | 135030 | 0.223497807725347 |
67 | 67 | 16860 | Chattanooga, TN-GA | 6 | 1956 | 214 | 3131 | 228 | 202 | 9603 | 0 | 1327 | 61 | 125 | 3261 | 214 | 3794 | 259 | 264 | 11018 | 573 | 560793 | 138452 | 0.246886105925003 |
42 | 42 | 14260 | Boise City, ID | 9 | 1405 | 11 | 3309 | 136 | 210 | 13851 | 0 | 1456 | 39 | 98 | 4584 | 11 | 4036 | 156 | 259 | 16083 | 958 | 730426 | 148259 | 0.202976071498003 |
152 | 152 | 25540 | Hartford-East Hartford-Middletown, CT | 11 | 2566 | 202 | 4048 | 88 | 183 | 16648 | 8 | 2745 | 46 | 148 | 8777 | 206 | 5420 | 111 | 257 | 20794 | 909 | 1206300 | 291049 | 0.241274144076929 |
2 | 2 | 10420 | Akron, OH | 8 | 1912 | 518 | 3832 | 238 | 193 | 15098 | 230 | 1939 | 102 | 120 | 5862 | 633 | 4802 | 289 | 253 | 17319 | 1244 | 704845 | 174214 | 0.247166398286148 |
379 | 379 | 49340 | Worcester, MA-CT | 11 | 1820 | 631 | 2070 | 131 | 170 | 11616 | 11 | 3159 | 93 | 161 | 7802 | 637 | 3649 | 176 | 250 | 14862 | 1398 | 947866 | 213269 | 0.224999103248771 |
382 | 382 | 49660 | Youngstown-Warren-Boardman, OH-PA | 13 | 1575 | 190 | 3336 | 140 | 201 | 7661 | 0 | 584 | 36 | 94 | 1597 | 190 | 3627 | 158 | 248 | 8267 | 711 | 538952 | 156380 | 0.290155709599371 |
150 | 150 | 25420 | Harrisburg-Carlisle, PA | 8 | 1974 | 801 | 3587 | 386 | 202 | 14878 | 0 | 1526 | 84 | 79 | 4666 | 801 | 4349 | 427 | 242 | 16403 | 1677 | 574659 | 141035 | 0.245423807858225 |
286 | 286 | 39580 | Raleigh-Cary, NC | 5 | 1867 | 8 | 4389 | 74 | 190 | 13993 | 0 | 2546 | 24 | 99 | 5485 | 8 | 5662 | 87 | 240 | 16723 | 585 | 1362540 | 237582 | 0.174366991060813 |
22 | 22 | 12420 | Austin-Round Rock-Georgetown, TX | 29 | 3498 | 314 | 6660 | 150 | 182 | 18658 | 0 | 2501 | 86 | 108 | 7448 | 314 | 7915 | 195 | 236 | 22030 | 698 | 2168316 | 344145 | 0.158715334849717 |
335 | 335 | 44180 | Springfield, MO | 5 | 1501 | 27 | 3367 | 384 | 206 | 15409 | 0 | 1080 | 76 | 55 | 4388 | 27 | 3906 | 422 | 234 | 17576 | 922 | 466978 | 104586 | 0.223963441532578 |
217 | 217 | 31540 | Madison, WI | 11 | 1681 | 700 | 2696 | 38 | 181 | 12248 | 1 | 2316 | 29 | 104 | 6448 | 701 | 3855 | 52 | 233 | 14683 | 19 | 660422 | 135323 | 0.204903834215093 |
143 | 143 | 24660 | Greensboro-High Point, NC | 6 | 1636 | 405 | 3248 | 144 | 198 | 11548 | 5 | 891 | 32 | 62 | 2510 | 408 | 3693 | 159 | 229 | 12374 | 215 | 767711 | 172942 | 0.225269665277689 |
222 | 222 | 32580 | McAllen-Edinburg-Mission, TX | 8 | 2187 | 2 | 2650 | 183 | 181 | 8716 | 0 | 753 | 24 | 94 | 1735 | 2 | 3026 | 194 | 228 | 9583 | 228 | 865939 | 129577 | 0.149637561075318 |
378 | 378 | 49180 | Winston-Salem, NC | 7 | 1813 | 1082 | 3512 | 139 | 195 | 13508 | 16 | 1239 | 36 | 66 | 3391 | 1090 | 4130 | 158 | 228 | 14088 | 1561 | 671456 | 161446 | 0.240441667063814 |
341 | 341 | 45060 | Syracuse, NY | 6 | 1943 | 655 | 2937 | 356 | 183 | 12276 | 0 | 1212 | 139 | 72 | 3589 | 655 | 3542 | 425 | 219 | 13414 | 61 | 650502 | 155593 | 0.239189118557668 |
206 | 206 | 30700 | Lincoln, NE | 8 | 1526 | 16 | 1766 | 70 | 176 | 5251 | 3 | 911 | 26 | 85 | 2601 | 17 | 2222 | 84 | 218 | 6531 | 0 | 334590 | 65706 | 0.19637765623599 |
332 | 332 | 44060 | Spokane-Spokane Valley, WA | 9 | 1578 | 13 | 1716 | 16 | 175 | 5564 | 7 | 1768 | 13 | 84 | 3877 | 16 | 2602 | 23 | 217 | 7486 | 441 | 559891 | 131042 | 0.234049127419444 |
355 | 355 | 46520 | Urban Honolulu, HI | 11 | 1895 | 27 | 3237 | 91 | 165 | 11066 | 0 | 1185 | 30 | 99 | 3629 | 27 | 3830 | 105 | 214 | 12824 | 456 | 980080 | 230662 | 0.235350175495878 |
252 | 252 | 35840 | North Port-Sarasota-Bradenton, FL | 9 | 2222 | 70 | 2850 | 172 | 169 | 9315 | 0 | 922 | 59 | 79 | 3011 | 70 | 3312 | 202 | 208 | 10749 | 117 | 821573 | 329526 | 0.401091564596208 |
83 | 83 | 18580 | Corpus Christi, TX | 6 | 1239 | 202 | 2087 | 125 | 179 | 5932 | 0 | 342 | 19 | 54 | 873 | 202 | 2259 | 134 | 206 | 6165 | 0 | 429158 | 87490 | 0.203864311046281 |
23 | 23 | 12540 | Bakersfield, CA | 11 | 1617 | 21 | 2523 | 193 | 172 | 8020 | 0 | 732 | 61 | 63 | 2353 | 21 | 2889 | 222 | 204 | 9172 | 11 | 896764 | 142190 | 0.158558996569889 |
64 | 64 | 16700 | Charleston-North Charleston, SC | 7 | 1957 | 660 | 4326 | 102 | 190 | 12784 | 0 | 299 | 7 | 23 | 857 | 660 | 4474 | 104 | 202 | 12553 | 323 | 787643 | 168125 | 0.213453303082742 |
293 | 293 | 40220 | Roanoke, VA | 3 | 1182 | 335 | 2725 | 121 | 183 | 8632 | 3 | 595 | 19 | 37 | 1812 | 337 | 3022 | 130 | 202 | 9200 | 688 | 314172 | 85918 | 0.273474402556561 |
183 | 183 | 28660 | Killeen-Temple, TX | 6 | 1008 | 387 | 1616 | 246 | 159 | 6194 | 23 | 735 | 112 | 80 | 2353 | 398 | 1983 | 302 | 199 | 6971 | 1890 | 451679 | 71446 | 0.158178706559304 |
294 | 294 | 40340 | Rochester, MN | 4 | 1576 | 1338 | 1947 | 68 | 166 | 28724 | 2 | 4939 | 115 | 64 | 10626 | 1339 | 4416 | 125 | 198 | 32698 | 2119 | 219802 | 50575 | 0.230093447739329 |
114 | 114 | 21780 | Evansville, IN-KY | 8 | 1423 | 37 | 2071 | 48 | 155 | 7181 | 0 | 957 | 25 | 66 | 3133 | 37 | 2550 | 60 | 188 | 8626 | 417 | 314672 | 76462 | 0.242989525601261 |
193 | 193 | 29460 | Lakeland-Winter Haven, FL | 5 | 1617 | 0 | 2456 | 22 | 157 | 6908 | 0 | 863 | 4 | 61 | 1847 | 0 | 2887 | 24 | 188 | 7831 | 157 | 708009 | 186244 | 0.263053153279125 |
326 | 326 | 43340 | Shreveport-Bossier City, LA | 10 | 1573 | 75 | 2668 | 357 | 165 | 10864 | 0 | 330 | 32 | 42 | 964 | 75 | 2833 | 374 | 186 | 11268 | 313 | 397543 | 89873 | 0.226071141989672 |
110 | 110 | 21340 | El Paso, TX | 12 | 1897 | 0 | 3025 | 96 | 168 | 8737 | 0 | 402 | 11 | 32 | 1372 | 0 | 3225 | 100 | 184 | 9424 | 104 | 845553 | 145163 | 0.171678179842068 |
233 | 233 | 33660 | Mobile, AL | 7 | 1458 | 422 | 2404 | 91 | 156 | 8165 | 2 | 580 | 23 | 53 | 1767 | 423 | 2692 | 103 | 182 | 8615 | 293 | 430135 | 98194 | 0.228286468201844 |
334 | 334 | 44140 | Springfield, MA | 9 | 1636 | 349 | 2226 | 51 | 120 | 10962 | 0 | 1896 | 84 | 124 | 7050 | 349 | 3175 | 93 | 182 | 14132 | 1694 | 702724 | 170283 | 0.242318463578873 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [aha2018staffing_cbsa] ( [CBSACODE] INTEGER, [CBSANAME] TEXT, [hospitals] INTEGER, [hospbeds] INTEGER, [resid_ft] INTEGER, [rn_ft] INTEGER, [lpn_ft] INTEGER, [resp_ft] INTEGER, [tot_ft] INTEGER, [resid_pt] INTEGER, [rn_pt] INTEGER, [lpn_pt] INTEGER, [resp_pt] INTEGER, [tot_pt] INTEGER, [resid_fte] INTEGER, [rn_fte] INTEGER, [lpn_fte] INTEGER, [resp_fte] INTEGER, [tot_fte] INTEGER, [physpriv] INTEGER, [pop2018_tot] INTEGER, [pop2018_60plus] INTEGER, [pop2018_60pluspct] TEXT );