aha2018staffing_cbsa

Table actions

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

384 rows sorted by rn_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
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
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
330 330 43780 South Bend-Mishawaka, IN-MI 4 758 55 1078 12 58 2981 21 1020 6 45 3100 66 1588 15 80 4460 218 322424 74833 0.232095005334591
194 194 29540 Lancaster, PA 5 1007 67 1245 54 74 5704 0 996 30 56 3043 67 1743 70 102 7157 344 543557 132272 0.243345224143926
77 77 17820 Colorado Springs, CO 5 1069 7 1488 11 78 4293 5 971 13 78 3862 10 1973 17 117 6202 186 738939 138419 0.18732128091764
44 44 14500 Boulder, CO 5 640 0 935 6 47 3314 0 958 10 56 2951 0 1413 11 75 4788 207 326078 66402 0.203638393267868
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
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
35 35 13780 Binghamton, NY 2 618 115 823 174 31 5140 0 947 36 15 2634 115 1296 191 38 6342 350 240219 63467 0.26420474650215
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
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
165 165 26980 Iowa City, IA 3 1038 562 2292 36 113 8466 25 921 7 42 3100 575 2753 39 134 9353 67 173401 30830 0.177795975801754
373 373 48620 Wichita, KS 16 1898 29 2550 78 98 6748 0 914 26 56 2548 29 3008 91 126 7994 203 637578 135566 0.212626533537857
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
265 265 37340 Palm Bay-Melbourne-Titusville, FL 9 1556 33 2125 49 143 5526 0 909 14 74 2445 33 2579 56 180 6714 0 596849 189071 0.316781966628075
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
16 16 11700 Asheville, NC 6 1267 226 1994 83 111 7811 6 889 29 61 2607 229 2439 97 142 8868 145 459585 135574 0.294992221243078
52 52 15540 Burlington-South Burlington, VT 2 555 337 1337 59 76 6788 0 886 28 16 2513 337 1781 74 84 7664 0 221083 48642 0.220016916723583
26 26 12700 Barnstable Town, MA 3 414 0 286 6 15 1593 0 882 12 54 2966 0 727 12 42 3076 225 213413 84732 0.397032982995413
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
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
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
376 376 48900 Wilmington, NC 2 772 83 1836 28 89 5341 0 852 6 20 1888 83 2262 31 99 6194 27 294436 71799 0.243852653887432
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
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
234 234 33700 Modesto, CA 6 1113 23 2152 58 108 5222 0 836 28 68 2295 23 2570 73 142 6342 0 549815 101480 0.184571173940325
306 306 41500 Salinas, CA 4 740 11 1119 42 67 4052 0 831 22 30 2042 11 1534 53 82 5061 0 435594 82744 0.189956702801232
95 95 19660 Deltona-Daytona Beach-Ormond Beach, FL 6 1537 39 1944 94 108 7179 0 827 36 48 2765 39 2359 114 132 8520 136 659605 219617 0.332952297208178
66 66 16820 Charlottesville, VA 3 806 777 2478 147 133 8876 3 779 17 39 1784 778 2868 156 152 8986 83 218233 52938 0.24257559580815
179 179 28020 Kalamazoo-Portage, MI 4 921 72 1785 49 92 7046 1 776 11 45 2468 73 2173 54 114 8199 553 264870 54926 0.207369653037339
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
296 296 40420 Rockford, IL 4 864 5 1463 12 96 4771 0 775 8 41 2310 5 1850 15 116 5919 1121 337658 80277 0.237746477204746
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
317 317 42200 Santa Maria-Santa Barbara, CA 5 858 77 1032 38 73 4007 0 752 23 32 1934 77 1408 50 89 4893 0 446527 92919 0.208092679725974
307 307 41540 Salisbury, MD-DE 6 741 3 1463 94 104 5946 0 750 37 64 2543 3 1838 112 136 7211 109 409979 131196 0.320006634486157
238 238 34060 Morgantown, WV 4 958 379 2034 107 134 7325 7 744 35 48 2456 382 2406 125 158 8139 67 140259 28135 0.200593188315901
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
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
195 195 29620 Lansing-East Lansing, MI 7 1203 264 1961 25 108 7786 4 724 11 53 2325 266 2324 31 134 8677 379 550085 120842 0.219678776916295
257 257 36260 Ogden-Clearfield, UT 9 1108 20 1591 61 147 4599 0 720 19 68 2115 20 1952 72 181 5629 0 675067 105736 0.156630378910538
60 60 16300 Cedar Rapids, IA 4 734 0 957 38 37 3626 0 687 38 38 2087 0 1300 57 56 4670 91 272295 61670 0.226482307791182
146 146 25060 Gulfport-Biloxi, MS 8 1191 0 2087 90 105 5955 0 684 34 46 1606 0 2429 108 128 6722 179 415978 92767 0.223009389919659
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
91 91 19340 Davenport-Moline-Rock Island, IA-IL 8 1082 0 1195 31 78 3502 0 667 12 34 2121 0 1527 38 95 4561 1095 381451 95065 0.24921942792128
288 288 39740 Reading, PA 5 1080 135 1706 61 122 6687 0 663 10 72 2287 135 2037 65 158 7688 75 420152 99405 0.236592947314305
237 237 33860 Montgomery, AL 8 1098 3 1771 61 83 5010 1 661 18 58 1753 3 2100 70 112 5882 76 373225 80112 0.21464800053587
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
356 356 46540 Utica-Rome, NY 4 687 37 851 95 60 3827 0 652 40 34 1815 37 1178 116 77 4695 120 291410 76117 0.26120242956659
15 15 11540 Appleton, WI 3 352 0 398 18 21 1249 0 621 36 24 1399 0 709 36 33 1947 118 237524 50245 0.211536518414981
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
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
290 290 39900 Reno, NV 7 1260 21 2041 39 157 6226 0 593 10 44 1686 21 2339 44 179 7048 0 469764 108245 0.230424213009085
333 333 44100 Springfield, IL 2 855 285 1348 12 70 5560 0 588 11 45 1894 285 1642 18 92 6217 0 207636 51680 0.248897108401241
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
112 112 21500 Erie, PA 6 967 47 1569 49 89 4084 0 580 18 48 1597 47 1858 58 113 4835 223 272061 68330 0.251156909663642
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
274 274 38340 Pittsfield, MA 2 300 75 355 57 24 2120 0 575 35 14 1731 75 643 75 31 2911 226 126348 39567 0.313158894481907
282 282 39340 Provo-Orem, UT 7 748 10 1553 29 102 4047 0 575 18 47 1743 10 1840 38 126 4898 15 633768 69452 0.109585842137817
262 262 36780 Oshkosh-Neenah, WI 4 375 0 484 7 23 1636 0 574 20 35 1483 0 772 17 40 2374 43 171020 38939 0.227686820254941
119 119 22220 Fayetteville-Springdale-Rogers, AR 9 1135 8 1699 151 96 5491 0 570 27 31 1634 8 1985 164 112 6296 195 526050 93561 0.177855717137154
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
108 108 21140 Elkhart-Goshen, IN 2 352 9 590 20 39 2025 0 561 5 39 1797 9 870 22 58 2912 118 205560 41859 0.203633975481611
268 268 37860 Pensacola-Ferry Pass-Brent, FL 7 1348 17 2332 53 125 5401 0 559 19 50 1378 17 2612 63 150 6074 183 494883 114044 0.230446388338254
349 349 45940 Trenton-Princeton, NJ 5 755 67 1361 31 66 4060 0 557 8 67 1966 67 1639 35 100 4974 415 369811 78636 0.212638347696526
33 33 13460 Bend, OR 2 307 7 667 9 36 2824 0 555 1 13 1205 7 945 9 42 3419 111 191996 52594 0.273932790266464
144 144 24780 Greenville, NC 1 974 397 1548 74 75 6583 0 552 21 7 1556 397 1824 85 78 6962 0 179914 33747 0.187572951521282
32 32 13380 Bellingham, WA 1 255 3 372 1 10 1039 0 548 8 14 1260 3 646 5 17 1666 128 225685 53428 0.236737044996344
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
131 131 23580 Gainesville, GA 1 887 0 1372 29 73 4423 0 542 3 57 1448 0 1643 31 102 5001 0 202148 41397 0.204785602627778
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
380 380 49420 Yakima, WA 4 486 8 810 39 40 3176 0 528 23 36 1815 8 1074 50 58 4071 97 251446 47524 0.189002807759917
259 259 36500 Olympia-Lacey-Tumwater, WA 2 401 3 877 27 51 2291 0 526 13 31 1259 3 1140 33 66 2918 222 286419 68112 0.237805452850544
161 161 26580 Huntington-Ashland, WV-KY-OH 7 1393 98 2592 152 145 9098 1 523 22 44 1619 98 2855 164 167 9804 137 359228 94082 0.261900520004009
245 245 34940 Naples-Marco Island, FL 3 956 38 1455 41 84 3790 1 517 20 65 1570 39 1713 50 116 4532 226 378488 147922 0.390823487138298
240 240 34580 Mount Vernon-Anacortes, WA 3 270 29 301 9 33 2121 0 509 7 17 1202 29 555 12 42 2692 244 128206 35758 0.278910503408577
12 12 11260 Anchorage, AK 5 839 82 1577 50 92 5347 1 496 10 25 1283 82 1825 54 104 5902 0 399148 68725 0.172179241785002
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
223 223 32780 Medford, OR 3 513 0 911 15 79 2789 0 488 14 27 1354 0 1156 23 92 3459 340 219564 64189 0.292347561531034
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
315 315 42100 Santa Cruz-Watsonville, CA 3 359 8 366 10 30 1133 1 484 14 26 1260 8 608 17 43 1753 0 274255 63603 0.231911906802064
62 62 16580 Champaign-Urbana, IL 4 700 82 1551 47 63 4267 0 483 21 19 1334 82 1792 56 72 4852 1280 226379 42320 0.186943135184801
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
177 177 27900 Joplin, MO 5 697 26 1062 74 105 4484 0 476 9 53 1517 26 1300 79 132 5216 373 178902 40421 0.225939341091771
17 17 12020 Athens-Clarke County, GA 3 561 52 1141 36 69 3663 0 472 11 43 1338 52 1377 41 90 4273 77 211306 39019 0.184656375114763
190 190 29200 Lafayette-West Lafayette, IN 4 451 5 946 53 60 3144 0 469 7 15 1249 5 1181 57 68 3762 206 230091 41190 0.179016128401372
176 176 27860 Jonesboro, AR 4 691 37 903 29 74 2807 4 468 25 33 1220 39 1138 42 90 3375 0 132532 26505 0.199989436513446
19 19 12100 Atlantic City-Hammonton, NJ 4 841 54 1151 26 61 4210 0 467 20 33 1361 54 1383 36 78 4835 311 265429 66883 0.251980755682311
381 381 49620 York-Hanover, PA 6 958 158 1738 65 128 5824 0 466 17 43 1709 158 1972 75 150 6520 139 448273 108873 0.242872089106415
278 278 38940 Port St. Lucie, FL 4 1088 23 1590 69 92 5527 0 457 22 38 1481 23 1819 80 111 6243 164 482040 162528 0.337167040079661
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
232 232 33540 Missoula, MT 2 318 16 399 55 30 1954 0 453 24 18 1442 16 626 68 39 2643 96 118791 25903 0.218055239875075
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
172 172 27500 Janesville-Beloit, WI 3 256 8 588 32 28 2126 1 444 21 33 1510 9 810 42 44 2870 6 163129 37943 0.232595062803058
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
371 371 48300 Wenatchee, WA 4 430 13 813 30 41 2661 0 433 18 28 1168 13 1030 38 55 3230 0 119943 30505 0.254329139674679
352 352 46220 Tuscaloosa, AL 5 803 0 1198 59 86 3758 0 432 22 49 1498 0 1413 69 110 4490 364 251808 51164 0.20318655483543
331 331 43900 Spartanburg, SC 3 795 66 1637 16 89 4786 0 424 1 34 1231 66 1850 17 106 5336 483 313888 69698 0.222047354470384
363 363 47380 Waco, TX 3 542 24 951 83 55 3280 1 411 38 22 1203 25 1156 102 66 3851 209 271942 54698 0.201138478057821
124 124 22540 Fond du Lac, WI 2 155 0 163 9 10 986 0 409 21 7 1207 0 368 19 14 1590 105 103066 26428 0.256418217452894
70 70 17020 Chico, CA 3 476 0 1287 49 91 4048 0 406 21 25 1219 0 1491 61 104 4656 0 231256 58032 0.250942678244024

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