aha2018staffing_cbsa

Table actions

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

384 rows sorted by lpn_pt descending

✎ View and edit SQL

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
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
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
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
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
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
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
116 116 22020 Fargo, ND-MN 3 708 4 1368 198 79 4916 0 1414 259 78 4073 4 2075 328 118 6948 695 245471 42663 0.173800571146897
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
329 329 43620 Sioux Falls, SD 8 1210 0 3142 320 124 10655 38 1318 145 67 5170 19 3803 394 158 13219 716 265653 50762 0.191083857513373
102 102 20260 Duluth, MN-WI 12 1203 6 717 115 31 5241 11 2083 142 72 5994 11 1759 187 67 8227 1466 289457 78056 0.269663542425991
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
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
135 135 24220 Grand Forks, ND-MN 4 485 29 389 111 26 2889 0 484 135 9 1494 29 631 178 30 3606 248 102299 20557 0.200950155915503
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
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
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
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
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
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
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
54 54 15940 Canton-Massillon, OH 5 1118 104 1826 210 103 7910 1 948 109 109 3392 105 2300 264 158 9489 213 398655 107137 0.268746158959501
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
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
367 367 47940 Waterloo-Cedar Falls, IA 6 546 6 589 109 33 2780 0 661 104 21 2113 6 919 160 44 3830 308 169659 39879 0.235053843297438
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
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
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
214 214 31340 Lynchburg, VA 3 1200 20 939 114 62 4622 1 315 100 20 1299 20 1097 165 72 5230 296 263353 67364 0.255793554658576
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
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
301 301 41060 St. Cloud, MN 4 711 15 1251 198 41 4259 0 563 93 17 2046 15 1532 245 50 5264 19 199801 41144 0.205924895270794
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
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
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
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
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
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
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
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
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
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
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
348 348 45820 Topeka, KS 4 701 0 1219 286 79 4872 0 434 76 21 1560 0 1436 323 90 5653 321 232594 59239 0.25468842704455
142 142 24580 Green Bay, WI 6 698 0 1243 133 56 5081 0 1280 75 48 3402 0 1883 170 80 6761 135 321591 71939 0.223697180580302
189 189 29180 Lafayette, LA 18 1415 74 1869 215 119 6437 0 612 75 76 1836 74 2177 254 157 7276 73 489364 100160 0.204673821531621
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
188 188 29100 La Crosse-Onalaska, WI-MN 2 414 17 714 60 30 3832 0 1200 71 64 2958 17 1314 96 62 5293 718 136808 32318 0.236228875504357
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
37 37 13900 Bismarck, ND 3 505 0 1024 109 84 3535 0 450 67 43 1536 0 1249 143 106 4303 289 128320 29161 0.227252182044888
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
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
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
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
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
320 320 42540 Scranton-Wilkes-Barre, PA 10 1651 58 2111 152 114 7635 3 776 63 49 2442 60 2498 183 138 8796 2831 555485 149548 0.269220591015059
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
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
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
63 63 16620 Charleston, WV 7 1210 175 2105 243 122 8269 0 542 61 30 1750 175 2377 275 137 8967 267 260342 73219 0.281241597590861
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
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
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
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
191 191 29340 Lake Charles, LA 8 791 3 1130 223 81 4059 0 360 53 36 1189 3 1310 248 99 4636 113 210080 44365 0.21118145468393
105 105 20740 Eau Claire, WI 6 554 10 648 43 38 2639 0 1214 52 39 3024 10 1254 69 58 4131 552 168669 38513 0.228334785882409
78 78 17860 Columbia, MO 5 1028 400 1427 252 106 6304 0 400 50 26 1877 400 1627 276 119 6809 27 207745 38413 0.184904570507112
318 318 42220 Santa Rosa-Petaluma, CA 8 821 17 799 56 51 2890 0 1252 50 102 3287 17 1426 82 102 4514 0 499942 134766 0.269563269339243
30 30 13140 Beaumont-Port Arthur, TX 9 1035 0 1427 146 114 4085 0 336 49 46 935 0 1594 169 137 4552 19 395780 84425 0.2133129516398
169 169 27180 Jackson, TN 2 700 0 902 100 72 4076 0 306 49 22 598 0 1055 124 83 4376 0 178254 42613 0.23905774905472
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
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
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
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
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
34 34 13740 Billings, MT 5 576 34 1036 109 80 4522 0 454 43 41 1804 34 1265 132 100 5377 408 180385 44549 0.246966211159465
41 41 14100 Bloomsburg-Berwick, PA 5 789 445 1648 163 82 7457 40 538 43 45 1897 465 1917 185 104 7940 945 83696 22605 0.270084591856242
184 184 28700 Kingsport-Bristol, TN-VA 8 1057 30 1911 170 129 7186 3 677 43 59 2230 31 2250 192 158 8266 95 306616 89926 0.293285412372479
3 3 10500 Albany, GA 2 479 21 649 53 71 2426 0 854 42 67 2210 21 1076 74 104 3506 0 149917 32634 0.217680449848916
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
220 220 31860 Mankato, MN 2 189 0 273 44 13 1226 0 494 42 3 1006 0 520 65 14 1729 137 101647 20664 0.203291784312375
354 354 46340 Tyler, TX 8 1209 81 2198 308 122 7355 0 385 42 43 1032 81 2390 330 144 7781 220 230221 51905 0.225457278006785
228 228 33220 Midland, MI 1 270 24 381 55 21 1452 10 260 41 15 775 29 511 75 28 1811 142 83209 21017 0.252580850629139
319 319 42340 Savannah, GA 7 1284 145 1478 69 100 5307 5 1021 41 85 2960 148 1988 90 142 6626 120 389494 78071 0.200442112073613
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
174 174 27740 Johnson City, TN 5 886 89 1068 76 71 3857 2 476 40 34 1569 90 1307 96 88 4546 0 202719 53981 0.266284857364135
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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