aha2018staffing_cbsa
Data source: Big Local News · About: big-local-datasette
384 rows sorted by lpn_ft
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
75 | 75 | 17660 | Coeur d'Alene, ID | 3 | 362 | 12 | 687 | 26 | 45 | 2887 | 10 | 366 | 17 | 22 | 1424 | 17 | 869 | 34 | 56 | 3581 | 132 | 161505 | 41739 | 0.258437819262562 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
28 | 28 | 12980 | Battle Creek, MI | 3 | 301 | 2 | 619 | 29 | 41 | 2122 | 0 | 201 | 10 | 26 | 750 | 2 | 720 | 34 | 54 | 2492 | 157 | 134487 | 33022 | 0.245540461159815 |
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 |
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 |
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 |
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 |
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 |
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 |
328 | 328 | 43580 | Sioux City, IA-NE-SD | 4 | 414 | 2 | 789 | 30 | 30 | 2567 | 0 | 293 | 14 | 14 | 970 | 2 | 935 | 37 | 37 | 3050 | 73 | 143950 | 30889 | 0.214581451893018 |
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 |
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 |
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 |
279 | 279 | 39100 | Poughkeepsie-Newburgh-Middletown, NY | 6 | 1120 | 125 | 1644 | 31 | 98 | 5444 | 0 | 1286 | 12 | 52 | 3557 | 125 | 2287 | 37 | 124 | 7094 | 404 | 675669 | 148141 | 0.21925084619836 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
9 | 9 | 11020 | Altoona, PA | 4 | 496 | 1 | 808 | 37 | 29 | 2404 | 2 | 236 | 16 | 10 | 657 | 2 | 926 | 45 | 34 | 2720 | 173 | 122492 | 34563 | 0.282165365901447 |
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 |
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 |
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 |
47 | 47 | 14860 | Bridgeport-Stamford-Norwalk, CT | 6 | 1638 | 515 | 2828 | 38 | 102 | 10432 | 15 | 1434 | 12 | 57 | 4478 | 521 | 3547 | 44 | 130 | 12137 | 1525 | 943823 | 211110 | 0.223675413716343 |
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 |
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 |
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 |
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 |
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 |
25 | 25 | 12620 | Bangor, ME | 4 | 519 | 36 | 1300 | 39 | 48 | 4815 | 0 | 266 | 11 | 12 | 883 | 36 | 1432 | 44 | 54 | 5210 | 350 | 151096 | 39321 | 0.260238523852385 |
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 |
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 |
300 | 300 | 40980 | Saginaw, MI | 3 | 853 | 0 | 1218 | 39 | 124 | 5286 | 0 | 311 | 11 | 25 | 1342 | 0 | 1374 | 44 | 136 | 5958 | 235 | 190800 | 50115 | 0.262657232704403 |
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 |
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 |
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 |
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 |
256 | 256 | 36220 | Odessa, TX | 4 | 620 | 0 | 635 | 42 | 42 | 2078 | 0 | 203 | 23 | 32 | 571 | 0 | 737 | 55 | 58 | 2352 | 64 | 162124 | 23065 | 0.142267646986257 |
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 |
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 |
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 |
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 |
269 | 269 | 37900 | Peoria, IL | 8 | 1357 | 290 | 2365 | 43 | 131 | 7705 | 0 | 1100 | 32 | 68 | 3736 | 290 | 2915 | 58 | 165 | 9274 | 826 | 403217 | 100647 | 0.249610011482651 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
243 | 243 | 34820 | Myrtle Beach-Conway-North Myrtle Beach, SC-NC | 6 | 985 | 117 | 1321 | 47 | 77 | 3728 | 0 | 340 | 10 | 31 | 888 | 117 | 1490 | 52 | 92 | 4055 | 91 | 480891 | 167916 | 0.349176840489841 |
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 |
276 | 276 | 38860 | Portland-South Portland, ME | 7 | 1200 | 281 | 2249 | 48 | 128 | 11282 | 0 | 1355 | 34 | 67 | 4955 | 281 | 2927 | 65 | 162 | 13474 | 618 | 535420 | 144397 | 0.269689215942624 |
14 | 14 | 11500 | Anniston-Oxford, AL | 3 | 286 | 1 | 452 | 49 | 27 | 1523 | 0 | 233 | 25 | 32 | 675 | 1 | 567 | 61 | 43 | 1859 | 28 | 114277 | 28119 | 0.246060012075921 |
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 |
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 |
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 |
230 | 230 | 33340 | Milwaukee-Waukesha, WI | 24 | 4030 | 172 | 7546 | 49 | 415 | 23573 | 0 | 4392 | 40 | 188 | 13864 | 172 | 9741 | 69 | 509 | 30047 | 1044 | 1576113 | 348103 | 0.220861702174907 |
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 |
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 |
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 |
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 |
266 | 266 | 37460 | Panama City, FL | 5 | 308 | 7 | 772 | 50 | 69 | 2130 | 0 | 124 | 9 | 23 | 368 | 7 | 835 | 56 | 80 | 2305 | 28 | 185287 | 44185 | 0.238467890353883 |
334 | 334 | 44140 | Springfield, MA | 9 | 1636 | 349 | 2226 | 51 | 120 | 10962 | 0 | 1896 | 84 | 124 | 7050 | 349 | 3175 | 93 | 182 | 14132 | 1694 | 702724 | 170283 | 0.242318463578873 |
350 | 350 | 46060 | Tucson, AZ | 12 | 2654 | 25 | 3818 | 51 | 268 | 11187 | 0 | 1202 | 23 | 92 | 3108 | 25 | 4418 | 63 | 314 | 12712 | 1908 | 1039073 | 270651 | 0.260473518222493 |
80 | 80 | 17980 | Columbus, GA-AL | 6 | 1067 | 87 | 1065 | 52 | 67 | 3817 | 1 | 332 | 16 | 39 | 1056 | 87 | 1230 | 58 | 86 | 4255 | 55 | 317922 | 64226 | 0.202018105069797 |
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 |
92 | 92 | 19430 | Dayton-Kettering, OH | 11 | 1994 | 505 | 5298 | 53 | 400 | 15999 | 0 | 2406 | 30 | 210 | 6734 | 505 | 6502 | 68 | 505 | 18832 | 212 | 806548 | 197871 | 0.245330718072576 |
97 | 97 | 19780 | Des Moines-West Des Moines, IA | 9 | 1625 | 215 | 2743 | 53 | 124 | 10655 | 0 | 1448 | 12 | 49 | 4065 | 215 | 3466 | 58 | 148 | 12461 | 1183 | 692556 | 133229 | 0.192372891145265 |
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 |
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 |
218 | 218 | 31700 | Manchester-Nashua, NH | 5 | 841 | 0 | 1281 | 53 | 52 | 6503 | 0 | 1492 | 19 | 46 | 4357 | 0 | 2027 | 62 | 75 | 8669 | 256 | 415247 | 93846 | 0.226000428660532 |
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 |
277 | 277 | 38900 | Portland-Vancouver-Hillsboro, OR-WA | 19 | 4199 | 1140 | 8514 | 53 | 462 | 26763 | 222 | 4518 | 29 | 187 | 11721 | 1251 | 10775 | 68 | 556 | 31344 | 5838 | 2478810 | 519060 | 0.209398864777857 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );