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 hospitals

✎ 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
20 20 12220 Auburn-Opelika, AL 1 549 3 664 50 28 2690 5 155 11 10 699 5 742 56 33 3034 41 163941 27736 0.169182815769088
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
40 40 14020 Bloomington, IN 1 282 0 425 15 33 1364 0 270 11 10 698 0 560 21 38 1711 251 167762 32651 0.194626911934765
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
228 228 33220 Midland, MI 1 270 24 381 55 21 1452 10 260 41 15 775 29 511 75 28 1811 142 83209 21017 0.252580850629139
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
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
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
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
303 303 41140 St. Joseph, MO-KS 1 352 0 669 154 31 3155 0 250 37 9 854 0 794 173 36 3582 176 126490 29366 0.232160645110285
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
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
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
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
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
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
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
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
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
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
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
86 86 19060 Cumberland, MD-WV 2 346 0 472 35 19 1573 0 226 29 30 713 0 585 50 34 1929 35 97915 26699 0.272675279579227
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
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
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
94 94 19500 Decatur, IL 2 534 21 468 83 24 2196 0 249 22 19 942 21 593 94 34 2646 87 104712 28506 0.272232408892964
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
241 241 34620 Muncie, IN 2 376 61 467 15 53 1541 0 307 16 31 867 61 621 23 68 1898 187 114772 26426 0.230247795629596
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
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
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
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
267 267 37620 Parkersburg-Vienna, WV 2 279 18 494 38 31 1712 0 127 30 12 507 18 558 53 37 1948 47 90033 24996 0.277631535103795
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
275 275 38540 Pocatello, ID 2 185 0 356 43 20 1077 0 156 20 9 429 0 434 53 24 1292 46 94906 19169 0.201978800075865
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
285 285 39540 Racine, WI 2 333 0 487 21 18 1478 0 360 14 32 1164 0 667 28 34 2047 118 196584 46130 0.234657957921296
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
323 323 42700 Sebring-Avon Park, FL 2 277 2 279 45 21 1642 0 74 13 5 421 2 316 52 24 1851 30 105424 44740 0.424381544999241
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
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
337 337 44300 State College, PA 2 333 0 338 10 13 1490 0 120 9 4 599 0 398 14 15 1790 106 162805 32339 0.198636405515801
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
353 353 46300 Twin Falls, ID 2 249 0 428 72 21 1672 0 306 24 5 745 0 581 84 24 2040 50 110096 22445 0.203867533788694
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
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
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
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

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