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 physpriv

✎ 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
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
10 10 11100 Amarillo, TX 5 942 0 1378 66 75 3715 0 300 15 26 811 0 1528 73 88 4117 0 265947 52635 0.197915374115895
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
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
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
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
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
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
83 83 18580 Corpus Christi, TX 6 1239 202 2087 125 179 5932 0 342 19 54 873 202 2259 134 206 6165 0 429158 87490 0.203864311046281
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
216 216 31460 Madera, CA 2 464 26 814 23 95 2717 0 277 15 31 679 26 953 30 110 3026 0 157672 30515 0.193534679588006
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
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
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
244 244 34900 Napa, CA 2 289 1 393 15 24 1506 1 290 11 19 855 1 538 20 34 1932 0 139417 35898 0.257486533206137
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
254 254 36100 Ocala, FL 4 661 63 1472 55 93 4453 2 273 14 34 768 64 1609 63 110 4770 0 359977 129863 0.360753603702459
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
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
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
289 289 39820 Redding, CA 5 574 32 926 31 82 2582 0 341 24 53 1024 32 1098 43 108 3062 0 180040 50795 0.282131748500333
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
297 297 40580 Rocky Mount, NC 3 357 0 594 32 61 1889 0 198 12 35 555 0 694 38 78 2167 0 146021 38165 0.261366515775128
298 298 40660 Rome, GA 3 602 36 956 88 71 3699 0 182 17 28 590 36 1047 97 85 3957 0 97927 22408 0.228823511391138
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
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
309 309 41660 San Angelo, TX 2 445 0 517 55 22 1919 0 162 12 6 412 0 598 61 25 2125 0 121022 25672 0.212126720761514
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
314 314 42020 San Luis Obispo-Paso Robles, CA 4 390 8 521 23 35 1552 0 290 11 26 810 8 666 29 48 1948 0 284010 77194 0.271800288722228
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
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
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
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
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
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
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
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
339 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
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
358 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
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
362 362 47300 Visalia, CA 2 595 276 1270 74 71 4968 2 255 9 18 717 277 1398 79 80 5043 0 465861 75026 0.161048037934062
364 364 47460 Walla Walla, WA 2 117 2 273 25 19 1050 0 153 12 11 506 2 350 31 24 1301 0 60922 14908 0.244706345819244
365 365 47580 Warner Robins, GA 4 358 19 592 88 45 2238 0 269 37 24 805 19 727 107 57 2621 0 182766 34461 0.188552575424313
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
372 372 48540 Wheeling, WV-OH 6 799 44 1271 61 74 4117 0 305 14 27 875 44 1424 68 88 4509 0 140045 41087 0.293384269341997
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
225 225 32900 Merced, CA 2 230 23 400 31 25 1177 0 98 14 7 266 23 448 37 28 1286 1 274765 43769 0.159296125780212
264 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
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
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
229 229 33260 Midland, TX 4 372 1 361 37 46 1819 11 160 13 11 494 7 441 43 52 2057 2 178331 27460 0.153983323146284
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
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
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
235 235 33740 Monroe, LA 12 963 37 1074 88 79 3549 2 359 31 54 1055 38 1255 103 106 4038 8 202203 45008 0.222588191075306
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
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
215 215 31420 Macon-Bibb County, GA 5 1040 123 1736 110 119 5296 0 193 14 20 540 123 1833 118 129 5440 10 229737 53234 0.231717137422357
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
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
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
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
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
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
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
48 48 15180 Brownsville-Harlingen, TX 6 1081 0 1212 133 94 3305 0 266 27 76 783 0 1345 147 132 3696 16 423908 77280 0.182303707408211
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
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
217 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
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
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
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
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
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
11 11 11180 Ames, IA 3 297 0 357 13 16 1336 0 245 12 14 738 0 479 20 23 1705 23 124451 23260 0.186900868614957
99 99 20020 Dothan, AL 5 770 76 1208 110 74 4083 0 324 25 29 1006 76 1370 122 88 4507 23 148245 37837 0.255232891497184
7 7 10780 Alexandria, LA 6 773 0 1069 103 70 2930 0 272 19 53 739 0 1204 113 96 3299 25 153044 34176 0.223308329630694

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