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

384 rows sorted by rn_pt descending

View and edit SQL

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 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 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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
127 23060 Fort Wayne, IN 10 1697 29 2209 63 86 6412 0 1723 39 119 4656 29 3071 84 146 8709 682 409425 85904 0.209816205654271
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
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
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
358 46700 Vallejo, CA 4 672 2 540 9 41 2349 0 1530 23 83 3104 2 1304 20 82 3899 0 446610 99517 0.222827522894696
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
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
218 31700 Manchester-Nashua, NH 5 841 0 1281 53 52 6503 0 1492 19 46 4357 0 2027 62 75 8669 256 415247 93846 0.226000428660532
128 23420 Fresno, CA 8 1692 217 2084 98 117 7509 12 1463 39 96 3929 223 2815 117 165 9236 0 994400 170928 0.171890587288817
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
97 19780 Des Moines-West Des Moines, IA 9 1625 215 2743 53 124 10655 0 1448 12 49 4065 215 3466 58 148 12461 1183 692556 133229 0.192372891145265
47 14860 Bridgeport-Stamford-Norwalk, CT 6 1638 515 2828 38 102 10432 15 1434 12 57 4478 521 3547 44 130 12137 1525 943823 211110 0.223675413716343
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
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
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
276 38860 Portland-South Portland, ME 7 1200 281 2249 48 128 11282 0 1355 34 67 4955 281 2927 65 162 13474 618 535420 144397 0.269689215942624
339 44700 Stockton, CA 7 1077 52 1779 88 126 6232 1 1348 40 67 3380 52 2453 108 160 7860 0 752660 135610 0.180174315095794
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
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
279 39100 Poughkeepsie-Newburgh-Middletown, NY 6 1120 125 1644 31 98 5444 0 1286 12 52 3557 125 2287 37 124 7094 404 675669 148141 0.21925084619836
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
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
162 26620 Huntsville, AL 4 1269 1 2879 125 139 8509 0 1239 33 72 2856 1 3499 142 175 9925 226 462693 98780 0.213489289874712
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
264 37100 Oxnard-Thousand Oaks-Ventura, CA 7 1087 82 1697 94 104 5809 39 1235 36 92 3405 101 2315 113 150 7406 1 850967 185478 0.21796144856381
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
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
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
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
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
113 21660 Eugene-Springfield, OR 5 619 3 913 16 22 2876 0 1183 10 9 2730 3 1504 20 26 4239 478 379611 99276 0.261520345827703
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
269 37900 Peoria, IL 8 1357 290 2365 43 131 7705 0 1100 32 68 3736 290 2915 58 165 9274 826 403217 100647 0.249610011482651
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
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
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

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