aha2018staffing_cbsa

Table actions
Data provided by Big Local News includes hospital staffing aggregated by U.S. metropolitan area and states. Compiled from the American Hospital Association (AHA) 2018 Annual Survey, the data provides counts for medical residents/interns, registered nurses, licensed practical nurses, respiratory therapists and some physicians. Please cite the data source as: American Hospital Association 2018 Annual Survey provided via Big Local News. See the README file for additional details and data definitions.

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

384 rows sorted by lpn_pt

✎ 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
46 46 14740 Bremerton-Silverdale-Port Orchard, WA 1 232 23 565 24 30 1943 0 0 0 0 0 23 565 24 30 1919 0 269805 66522 0.246555845888697
49 49 15260 Brunswick, GA 1 532 0 335 12 24 1419 0 17 0 3 89 0 343 12 26 1463 98 118456 32606 0.275258323765786
51 51 15500 Burlington, NC 1 197 0 461 4 13 1315 0 142 0 11 316 0 532 4 18 1473 49 166436 38481 0.231205989088899
104 104 20700 East Stroudsburg, PA 2 329 0 368 3 13 1350 0 206 0 16 664 0 471 3 21 1682 469 169507 41945 0.247452907549541
117 117 22140 Farmington, NM 1 198 0 371 1 15 1546 0 109 0 2 257 0 426 1 16 1675 75 125043 26585 0.212606863239046
133 133 24020 Glens Falls, NY 1 349 0 506 38 19 2154 0 0 0 0 0 0 506 38 19 2154 130 125462 35876 0.285951124643318
201 201 30140 Lebanon, PA 1 151 18 236 1 19 806 0 48 0 3 155 18 260 1 20 865 128 141314 36766 0.260172382071132
247 247 35100 New Bern, NC 1 208 0 666 3 36 1993 0 22 0 0 53 0 677 3 36 2020 0 125219 34199 0.273113505138996
255 255 36140 Ocean City, NJ 1 178 0 164 0 13 731 0 82 0 6 345 0 205 0 16 895 37 92560 32579 0.35197709593777
263 263 36980 Owensboro, KY 1 360 0 589 11 22 1977 0 189 0 11 576 0 684 11 28 2265 82 119114 28304 0.237621102473261
302 302 41100 St. George, UT 1 263 0 684 0 36 2048 0 177 0 13 566 0 772 0 42 2330 0 171700 46937 0.273366336633663
305 305 41420 Salem, OR 4 534 1 1225 7 78 4175 0 390 0 12 1029 1 1420 7 84 4688 174 432102 95446 0.220887660783796
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
53 53 15680 California-Lexington Park, MD 1 109 0 258 0 14 738 0 158 1 10 478 0 337 1 19 962 235 112664 21186 0.188045870908187
58 58 16180 Carson City, NV 2 240 0 409 5 28 1480 0 90 1 3 243 0 455 6 30 1602 22 55414 15350 0.277005810805934
88 88 19140 Dalton, GA 2 239 0 396 24 24 1216 0 45 1 8 261 0 419 25 28 1346 56 143983 28429 0.197446920817041
120 120 22380 Flagstaff, AZ 3 342 1 583 13 38 2038 0 322 1 5 851 1 744 13 40 2464 63 142854 25978 0.181850000700015
132 132 23900 Gettysburg, PA 1 76 0 184 2 12 615 0 36 1 2 141 0 202 3 13 685 239 102811 28621 0.278384608650825
196 196 29700 Laredo, TX 4 569 0 755 36 47 1951 0 63 1 10 141 0 786 37 52 2022 15 275910 37131 0.134576492334457
236 236 33780 Monroe, MI 1 100 50 148 0 15 689 0 52 1 8 317 50 174 1 19 797 50 150439 38597 0.256562460532176
253 253 35980 Norwich-New London, CT 2 435 0 218 0 22 1520 0 398 1 28 1300 0 417 0 36 2146 190 266784 67616 0.253448482667626
280 280 39150 Prescott Valley-Prescott, AZ 3 320 0 441 2 37 1938 0 216 1 15 606 0 549 2 44 2241 161 231993 95260 0.410615837546823
324 324 43100 Sheboygan, WI 2 173 0 236 1 11 721 0 195 1 9 584 0 333 1 16 1009 1 115456 29110 0.252130681818182
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
340 340 44940 Sumter, SC 2 268 0 436 5 23 1467 1 182 1 21 443 1 527 5 34 1688 54 140212 34565 0.246519556100762
346 346 45540 The Villages, FL 1 40 0 36 4 11 126 0 12 1 4 42 0 42 4 13 147 0 128754 85511 0.66414247324355
4 4 10540 Albany-Lebanon, OR 2 95 0 279 12 19 1249 0 140 2 8 587 0 348 13 23 1528 241 127335 32441 0.254768916637217
55 55 15980 Cape Coral-Fort Myers, FL 4 1503 304 2006 100 108 7404 1 96 2 14 318 305 2054 101 115 7240 83 754610 270256 0.358139966340229
61 61 16540 Chambersburg-Waynesboro, PA 2 329 0 474 9 32 1868 0 107 2 14 510 0 527 10 39 2123 314 154835 40788 0.263428811315271
134 134 24140 Goldsboro, NC 1 274 0 411 13 29 1447 0 60 2 1 181 0 441 14 30 1537 0 123248 28151 0.228409385953525
155 155 25940 Hilton Head Island-Bluffton, SC 3 331 19 560 22 33 1795 0 200 2 20 612 19 660 23 43 2081 56 217686 72926 0.335005466589491
327 327 43420 Sierra Vista-Douglas, AZ 4 160 6 264 11 20 1012 0 71 2 8 205 6 300 13 24 1106 15 126770 36908 0.29114143724856
360 360 47220 Vineland-Bridgeton, NJ 2 376 149 527 37 29 1687 0 76 2 2 240 149 565 38 30 1658 0 150972 32008 0.212012823569934
73 73 17420 Cleveland, TN 1 186 0 329 14 26 775 0 0 3 5 132 0 329 15 28 841 20 123625 29592 0.239369059656218
89 89 19180 Danville, IL 2 130 0 170 5 12 470 0 29 3 2 114 0 184 6 13 527 889 76806 20155 0.262414394708747
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
158 158 26300 Hot Springs, AR 3 449 0 535 37 42 1441 0 190 3 19 434 0 630 38 52 1658 117 99154 30920 0.311838150755391
178 178 27980 Kahului-Wailuku-Lahaina, HI 4 367 0 412 10 10 1167 0 96 3 5 233 0 460 11 12 1283 0 167207 42301 0.252985819971652
209 209 30980 Longview, TX 4 735 0 1135 53 62 2855 0 127 3 4 337 0 1198 55 64 3023 21 286143 65064 0.227382812090458
68 68 16940 Cheyenne, WY 1 238 0 452 14 22 1833 0 51 4 3 188 0 478 16 24 1927 85 98976 22083 0.223114694471387
90 90 19300 Daphne-Fairhope-Foley, AL 3 298 15 758 19 22 1739 0 83 4 5 259 15 800 21 24 1854 0 218022 60236 0.276284044729431
137 137 24300 Grand Junction, CO 3 412 27 696 18 42 2379 0 267 4 8 749 27 829 19 46 2722 90 153207 40055 0.261443667717532
156 156 25980 Hinesville, GA 1 25 0 45 11 4 220 0 28 4 3 101 0 59 13 6 271 0 80495 11217 0.139350270203118
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
210 210 31020 Longview, WA 1 180 3 225 0 16 743 0 175 4 7 522 3 313 2 20 1001 84 108987 28418 0.260746694559902
345 345 45500 Texarkana, TX-AR 6 697 0 894 116 61 2274 0 111 4 25 280 0 949 117 74 2415 1 150242 34781 0.231499846913646
384 384 49740 Yuma, AZ 2 447 18 463 7 21 1997 0 285 4 3 703 18 605 9 22 2323 47 212128 49960 0.235518177704028
85 85 18880 Crestview-Fort Walton Beach-Destin, FL 5 558 11 725 29 45 1947 0 203 5 15 483 11 826 31 52 2177 3 278644 66492 0.238627065359383
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
111 111 21420 Enid, OK 3 300 0 269 21 28 877 0 87 5 9 265 0 312 23 32 1007 97 60913 13635 0.223843842857846
139 139 24420 Grants Pass, OR 1 121 0 221 11 22 751 0 80 5 8 283 0 261 13 26 893 54 87393 29751 0.34042772304418
157 157 26140 Homosassa Springs, FL 2 332 17 553 19 31 1477 0 156 5 15 415 17 631 21 38 1668 0 147929 66680 0.450756781969729
171 171 27340 Jacksonville, NC 1 149 0 209 12 10 780 0 153 5 2 300 0 285 14 11 930 0 197683 25872 0.130876200786107
203 203 30340 Lewiston-Auburn, ME 2 540 41 756 14 40 2648 4 377 5 30 1030 43 945 17 55 3118 158 107679 26645 0.247448434699431
227 227 33140 Michigan City-La Porte, IN 2 262 5 343 14 27 1417 0 197 5 12 568 5 441 17 33 1696 32 110007 27281 0.247993309516667
239 239 34100 Morristown, TN 2 185 1 231 13 17 656 0 130 5 13 321 1 296 15 24 811 0 141726 37014 0.261165911688752
283 283 39380 Pueblo, CO 2 475 36 835 25 51 2735 4 259 5 20 749 38 965 27 61 3069 39 167529 42322 0.252624918670797
284 284 39460 Punta Gorda, FL 3 681 15 723 16 50 2012 0 198 5 29 533 15 821 18 64 2262 0 184998 91684 0.495594546968075
338 338 44420 Staunton, VA 1 209 0 390 72 14 1688 0 138 5 8 518 0 459 75 18 1947 132 123007 33919 0.27574853463624
29 29 13020 Bay City, MI 2 348 11 492 13 32 1809 1 135 6 19 686 11 560 16 42 2141 67 103923 29071 0.279735958353781
38 38 13980 Blacksburg-Christiansburg, VA 4 252 4 584 40 38 1800 0 169 6 14 509 4 670 44 45 2050 296 168234 35213 0.209309652032288
57 57 16060 Carbondale-Marion, IL 4 398 11 906 40 63 2661 0 122 6 15 430 11 967 43 70 2866 351 136931 32944 0.240588325507007
84 84 18700 Corvallis, OR 1 168 105 335 5 18 1492 1 283 6 4 741 105 476 8 20 1734 190 92101 20498 0.222560015635009
166 166 27060 Ithaca, NY 1 159 0 267 10 9 1054 0 272 6 5 782 0 403 13 12 1441 9 102793 20715 0.201521504382594
180 180 28100 Kankakee, IL 2 500 22 684 28 24 2311 0 260 6 28 1075 22 815 32 38 2826 124 110024 25510 0.231858503599215
202 202 30300 Lewiston, ID-WA 2 148 6 279 21 18 1060 0 90 6 6 287 6 325 24 21 1196 0 63018 17959 0.284982068615316
251 251 35660 Niles, MI 2 344 39 814 28 51 2639 3 202 6 11 625 41 915 31 56 2908 31 154141 41569 0.269681655107986
325 325 43300 Sherman-Denison, TX 5 556 21 911 55 53 2827 0 82 6 9 225 21 951 58 58 2918 0 133991 32757 0.244471643617855
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
336 336 44220 Springfield, OH 2 283 15 427 19 21 1445 0 177 6 10 476 15 515 22 26 1667 0 134585 35338 0.262570122970613
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
39 39 14010 Bloomington, IL 3 377 22 536 9 31 1511 0 256 7 16 842 22 664 12 39 1910 884 172828 32306 0.186925729627144
45 45 14540 Bowling Green, KY 4 680 30 723 29 43 2311 3 246 7 19 698 31 846 32 52 2626 0 177432 35569 0.200465530456738
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
81 81 18020 Columbus, IN 1 229 0 214 16 14 1250 0 207 7 14 680 0 318 20 21 1590 3 82753 18456 0.223025147124576
129 129 23460 Gadsden, AL 3 603 9 703 27 50 1752 0 182 7 22 467 9 794 31 61 1976 25 102501 26509 0.258621867103736
149 149 25260 Hanford-Corcoran, CA 2 248 12 592 43 37 2139 0 118 7 9 368 12 651 46 42 2309 0 151366 22032 0.145554483833886
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
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
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
242 242 34740 Muskegon, MI 2 397 100 706 8 55 3097 0 304 7 60 1469 100 858 11 85 3723 0 173588 41700 0.240223978616033
272 272 38220 Pine Bluff, AR 1 258 0 389 55 31 1152 0 100 7 11 413 0 439 59 36 1357 14 89515 21462 0.239758699659275
377 377 49020 Winchester, VA-WV 2 529 0 881 28 40 2408 0 259 7 17 809 0 1010 31 48 2813 10 139810 34073 0.243709319791145
383 383 49700 Yuba City, CA 2 233 17 425 19 22 1456 0 203 7 11 548 17 526 22 28 1711 0 174848 34725 0.198601070644217
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
59 59 16220 Casper, WY 4 315 0 386 14 31 1413 0 131 8 11 299 0 452 19 36 1561 31 79115 17595 0.222397775390255
72 72 17300 Clarksville, TN-KY 3 405 20 723 35 41 2195 0 178 8 15 501 20 811 38 48 2425 0 305825 48212 0.157645712417232
93 93 19460 Decatur, AL 2 153 8 258 34 17 1106 0 75 8 6 248 8 295 38 20 1220 0 152046 37102 0.244018257632559
109 109 21300 Elmira, NY 2 407 38 981 45 53 3398 0 243 8 14 700 38 1102 49 60 3707 0 84254 22089 0.262171528948181
123 123 22520 Florence-Muscle Shoals, AL 3 601 3 696 22 45 2042 0 187 8 21 637 3 789 26 56 2358 40 147149 39744 0.270093578617592
163 163 26820 Idaho Falls, ID 3 345 17 661 29 34 1843 0 151 8 12 406 17 736 33 40 2029 0 148904 27223 0.182822489657766
192 192 29420 Lake Havasu City-Kingman, AZ 4 512 24 880 63 61 3144 0 155 8 13 476 24 957 67 68 3354 16 209550 81693 0.389849677881174
199 199 29940 Lawrence, KS 1 142 0 264 39 10 1315 0 122 8 11 499 0 325 43 16 1564 85 121436 21084 0.173622319575744
208 208 30860 Logan, UT-ID 3 179 0 344 24 14 1070 0 194 8 4 609 0 441 28 16 1373 0 140794 19324 0.137250166910522
221 221 31900 Mansfield, OH 2 274 15 391 19 21 1371 0 208 8 12 591 15 494 23 27 1648 137 121099 32031 0.264502597048696
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
316 316 42140 Santa Fe, NM 1 219 18 451 20 24 1552 0 267 8 15 744 18 585 24 32 1904 0 150056 48487 0.3231260329477
322 322 42680 Sebastian-Vero Beach, FL 3 454 25 676 32 39 2236 0 223 8 17 637 25 788 36 48 2529 0 157413 64734 0.4112366831202
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
100 100 20100 Dover, DE 1 374 0 484 21 18 2015 0 194 9 11 819 0 581 26 24 2424 114 178550 41347 0.231570988518622

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