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

✎ 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
101 101 20220 Dubuque, IA 3 360 0 533 16 25 1549 0 189 15 15 759 0 628 24 32 1929 10 96854 23859 0.246339851735602
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
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
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
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
106 106 20940 El Centro, CA 2 268 13 346 40 21 1447 0 160 13 14 514 13 426 46 28 1691 0 181827 32641 0.179516793435518
107 107 21060 Elizabethtown-Fort Knox, KY 2 308 36 584 43 36 2278 1 258 11 16 752 37 714 49 44 2614 0 153378 31433 0.204938126719608
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
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
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
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
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
113 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
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
115 115 21820 Fairbanks, AK 1 217 0 244 16 11 1119 0 113 9 3 348 0 301 21 12 1293 60 98971 15476 0.156369037394792
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
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
118 118 22180 Fayetteville, NC 3 754 81 1118 158 85 5496 0 338 35 18 1257 81 1287 175 94 6042 313 521308 88378 0.169531255994537
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
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
121 121 22420 Flint, MI 4 1242 378 2463 19 127 6710 0 402 13 51 1498 378 2665 26 152 7067 79 406892 99868 0.245441050696499
122 122 22500 Florence, SC 7 1098 42 1990 50 125 5627 0 171 17 16 519 42 2076 58 133 5845 97 204961 49879 0.243358492591273
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
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
125 125 22660 Fort Collins, CO 5 627 27 1028 45 61 3499 0 258 10 18 753 27 1157 50 70 3845 360 350518 77143 0.220082848812329
126 126 22900 Fort Smith, AR-OK 8 851 0 939 161 77 3328 0 212 32 17 591 0 1045 176 86 3623 316 250148 57993 0.231834753825735
127 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
128 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
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
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
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
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
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
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
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
136 136 24260 Grand Island, NE 4 267 0 228 26 18 876 0 145 26 6 450 0 300 39 21 1101 22 75808 16699 0.220280181511186
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
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
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
140 140 24500 Great Falls, MT 2 522 0 491 59 30 2189 0 402 29 21 1426 0 692 74 40 2902 216 81643 20533 0.251497372708009
141 141 24540 Greeley, CO 3 316 39 533 7 30 1546 0 185 11 22 498 39 624 12 41 1755 182 314305 55417 0.176315998790983
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
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
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
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
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
147 147 25180 Hagerstown-Martinsburg, MD-WV 3 514 0 889 10 59 2700 0 305 27 22 882 0 1042 24 70 3141 68 285836 65737 0.229981527869128
148 148 25220 Hammond, LA 8 405 0 592 107 47 2274 0 290 33 30 918 0 737 123 62 2734 123 133777 27520 0.205715481734528
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
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
151 151 25500 Harrisonburg, VA 1 244 0 560 109 17 1833 0 208 17 11 638 0 664 118 22 2139 101 135277 28163 0.208187644610688
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
153 153 25620 Hattiesburg, MS 4 873 71 1061 67 76 3896 0 339 9 37 1032 71 1231 72 94 4338 63 168267 33638 0.19990847878669
154 154 25860 Hickory-Lenoir-Morganton, NC 4 759 36 1292 100 73 4388 0 357 17 14 986 36 1470 109 80 4843 264 368416 95831 0.260116281594719
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
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
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
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
159 159 26380 Houma-Thibodaux, LA 7 577 0 858 136 100 3704 0 284 28 56 1125 0 1000 150 128 4263 306 209136 44016 0.210465916915309
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
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
162 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
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
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
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
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
167 167 27100 Jackson, MI 2 448 108 830 34 49 3311 1 254 16 16 841 108 957 42 57 3624 197 158823 39429 0.248257494191647
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
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
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
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
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
173 173 27620 Jefferson City, MO 3 243 8 497 135 29 2029 0 72 22 7 374 8 534 146 32 2208 140 151520 34578 0.228207497360084
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
175 175 27780 Johnstown, PA 3 608 89 575 33 43 2401 0 139 14 31 529 89 644 40 58 2577 114 131730 40355 0.306346314431033
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
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
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
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
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
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
182 182 28420 Kennewick-Richland, WA 4 434 53 1019 47 63 3666 0 306 10 21 914 53 1172 52 74 4067 103 296224 55112 0.186048395808577
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
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
185 185 28740 Kingston, NY 3 280 7 332 22 18 1229 0 176 9 12 562 7 419 26 24 1503 0 178599 48489 0.271496480943342
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
187 187 29020 Kokomo, IN 3 318 7 322 22 19 1156 0 241 11 17 726 7 442 27 28 1510 12 82366 21623 0.262523371293981
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
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
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
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
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
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
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
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
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
197 197 29740 Las Cruces, NM 4 395 26 726 28 47 2212 0 264 14 39 715 26 859 35 66 2541 71 217522 46053 0.211716516030562
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
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
200 200 30020 Lawton, OK 2 530 26 349 167 19 1868 0 74 18 8 221 26 386 176 23 1952 121 126198 23327 0.184844450783689

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