aha2018staffing_cbsa
Data source: Big Local News · About: big-local-datasette
384 rows sorted by pop2018_60pluspct
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
219 | 219 | 31740 | Manhattan, KS | 5 | 326 | 0 | 285 | 17 | 16 | 914 | 0 | 115 | 23 | 7 | 334 | 0 | 343 | 29 | 20 | 1081 | 27 | 130574 | 18452 | 0.141314503653101 |
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 |
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 |
222 | 222 | 32580 | McAllen-Edinburg-Mission, TX | 8 | 2187 | 2 | 2650 | 183 | 181 | 8716 | 0 | 753 | 24 | 94 | 1735 | 2 | 3026 | 194 | 228 | 9583 | 228 | 865939 | 129577 | 0.149637561075318 |
76 | 76 | 17780 | College Station-Bryan, TX | 6 | 546 | 0 | 827 | 58 | 39 | 2350 | 0 | 331 | 25 | 18 | 974 | 0 | 991 | 70 | 48 | 2836 | 295 | 262431 | 39623 | 0.150984449245707 |
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 |
308 | 308 | 41620 | Salt Lake City, UT | 17 | 2817 | 1017 | 6559 | 90 | 390 | 21639 | 3 | 2751 | 30 | 150 | 7512 | 1018 | 7935 | 105 | 465 | 24263 | 1637 | 1222540 | 190032 | 0.155440312791402 |
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 |
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 |
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 |
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 |
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 |
22 | 22 | 12420 | Austin-Round Rock-Georgetown, TX | 29 | 3498 | 314 | 6660 | 150 | 182 | 18658 | 0 | 2501 | 86 | 108 | 7448 | 314 | 7915 | 195 | 236 | 22030 | 698 | 2168316 | 344145 | 0.158715334849717 |
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 |
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 |
87 | 87 | 19100 | Dallas-Fort Worth-Arlington, TX | 121 | 16353 | 2094 | 31211 | 975 | 2041 | 86730 | 194 | 10342 | 202 | 1015 | 26443 | 2191 | 36384 | 1078 | 2548 | 97506 | 3023 | 7470158 | 1223097 | 0.163731075032148 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
286 | 286 | 39580 | Raleigh-Cary, NC | 5 | 1867 | 8 | 4389 | 74 | 190 | 13993 | 0 | 2546 | 24 | 99 | 5485 | 8 | 5662 | 87 | 240 | 16723 | 585 | 1362540 | 237582 | 0.174366991060813 |
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 |
18 | 18 | 12060 | Atlanta-Sandy Springs-Alpharetta, GA | 44 | 10632 | 819 | 19687 | 757 | 1217 | 62460 | 20 | 6042 | 210 | 483 | 16993 | 830 | 22705 | 861 | 1458 | 69905 | 2000 | 5949951 | 1053699 | 0.177093727326494 |
213 | 213 | 31180 | Lubbock, TX | 9 | 1332 | 0 | 2725 | 190 | 148 | 7523 | 0 | 231 | 29 | 9 | 754 | 0 | 2841 | 203 | 152 | 7902 | 35 | 319068 | 56653 | 0.177557761981772 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
310 | 310 | 41700 | San Antonio-New Braunfels, TX | 26 | 6009 | 468 | 9285 | 634 | 609 | 25970 | 0 | 1589 | 119 | 180 | 4327 | 468 | 10078 | 692 | 699 | 27654 | 262 | 2518036 | 461018 | 0.183086341895032 |
357 | 357 | 46660 | Valdosta, GA | 3 | 315 | 11 | 596 | 105 | 28 | 2370 | 7 | 282 | 28 | 21 | 853 | 15 | 738 | 120 | 38 | 2782 | 26 | 146174 | 26924 | 0.184191443074692 |
292 | 292 | 40140 | Riverside-San Bernardino-Ontario, CA | 38 | 7640 | 627 | 13602 | 856 | 914 | 39098 | 20 | 4852 | 182 | 483 | 12234 | 636 | 16026 | 949 | 1156 | 44519 | 1320 | 4622361 | 851542 | 0.184222305440878 |
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 |
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 |
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 |
78 | 78 | 17860 | Columbia, MO | 5 | 1028 | 400 | 1427 | 252 | 106 | 6304 | 0 | 400 | 50 | 26 | 1877 | 400 | 1627 | 276 | 119 | 6809 | 27 | 207745 | 38413 | 0.184904570507112 |
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 |
366 | 366 | 47900 | Washington-Arlington-Alexandria, DC-VA-MD-WV | 44 | 9986 | 1903 | 17286 | 380 | 933 | 55874 | 26 | 7487 | 103 | 424 | 19789 | 1915 | 21031 | 433 | 1145 | 63766 | 2951 | 6263245 | 1166337 | 0.18621928409315 |
96 | 96 | 19740 | Denver-Aurora-Lakewood, CO | 26 | 5527 | 443 | 11163 | 193 | 522 | 33958 | 10 | 3745 | 65 | 295 | 9831 | 449 | 13035 | 226 | 670 | 38403 | 1006 | 2932415 | 546718 | 0.186439504640373 |
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 |
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 |
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 |
77 | 77 | 17820 | Colorado Springs, CO | 5 | 1069 | 7 | 1488 | 11 | 78 | 4293 | 5 | 971 | 13 | 78 | 3862 | 10 | 1973 | 17 | 117 | 6202 | 186 | 738939 | 138419 | 0.18732128091764 |
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 |
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 |
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 |
313 | 313 | 41940 | San Jose-Sunnyvale-Santa Clara, CA | 11 | 3321 | 1692 | 6375 | 125 | 337 | 24372 | 15 | 5856 | 103 | 333 | 13647 | 1698 | 9305 | 179 | 504 | 29456 | 2067 | 1999107 | 377024 | 0.188596208206964 |
368 | 368 | 48060 | Watertown-Fort Drum, NY | 3 | 261 | 12 | 502 | 81 | 22 | 1978 | 6 | 217 | 30 | 13 | 845 | 15 | 610 | 97 | 28 | 2384 | 53 | 111755 | 21088 | 0.188698492237484 |
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 |
82 | 82 | 18140 | Columbus, OH | 23 | 5668 | 1458 | 11642 | 276 | 645 | 42623 | 39 | 4236 | 121 | 285 | 13145 | 1477 | 13759 | 333 | 788 | 47659 | 3364 | 2106541 | 400030 | 0.189898986062934 |
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 |
246 | 246 | 34980 | Nashville-Davidson-Murfreesboro-Franklin, TN | 28 | 5467 | 1454 | 10255 | 675 | 558 | 40655 | 7 | 3974 | 183 | 267 | 12261 | 1459 | 12241 | 766 | 692 | 45311 | 1579 | 1905898 | 362768 | 0.190339671902694 |
329 | 329 | 43620 | Sioux Falls, SD | 8 | 1210 | 0 | 3142 | 320 | 124 | 10655 | 38 | 1318 | 145 | 67 | 5170 | 19 | 3803 | 394 | 158 | 13219 | 716 | 265653 | 50762 | 0.191083857513373 |
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 |
321 | 321 | 42660 | Seattle-Tacoma-Bellevue, WA | 28 | 6702 | 1131 | 11026 | 308 | 398 | 41786 | 150 | 8058 | 200 | 382 | 20923 | 1206 | 15055 | 407 | 589 | 50985 | 10929 | 3939363 | 758420 | 0.192523512050045 |
65 | 65 | 16740 | Charlotte-Concord-Gastonia, NC-SC | 23 | 4906 | 128 | 8957 | 286 | 583 | 26663 | 1 | 3864 | 68 | 270 | 9455 | 128 | 10891 | 321 | 718 | 31252 | 1013 | 2594090 | 499968 | 0.192733482647094 |
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 |
13 | 13 | 11460 | Ann Arbor, MI | 5 | 1641 | 1504 | 6062 | 122 | 313 | 19930 | 35 | 2483 | 26 | 74 | 6077 | 1521 | 7304 | 135 | 350 | 21448 | 327 | 370963 | 71921 | 0.193876478247157 |
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 |
260 | 260 | 36540 | Omaha-Council Bluffs, NE-IA | 18 | 2551 | 12 | 4845 | 131 | 327 | 15209 | 1 | 2103 | 62 | 189 | 7529 | 13 | 5897 | 165 | 422 | 18956 | 1404 | 942198 | 183775 | 0.195049235935546 |
211 | 211 | 31080 | Los Angeles-Long Beach-Anaheim, CA | 116 | 27247 | 3652 | 49602 | 2319 | 3084 | 157159 | 23 | 20504 | 765 | 1800 | 54446 | 3663 | 59852 | 2701 | 3984 | 180232 | 3569 | 13291486 | 2601177 | 0.195702497072186 |
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 |
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 |
258 | 258 | 36420 | Oklahoma City, OK | 31 | 4225 | 139 | 6160 | 362 | 497 | 19461 | 7 | 2648 | 92 | 212 | 6262 | 143 | 7483 | 409 | 603 | 22343 | 1377 | 1396445 | 274396 | 0.196496102603396 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
224 | 224 | 32820 | Memphis, TN-MS-AR | 17 | 3879 | 62 | 4787 | 103 | 346 | 14721 | 35 | 1716 | 37 | 140 | 4002 | 79 | 5642 | 120 | 416 | 16623 | 1040 | 1342349 | 268715 | 0.200182664865843 |
231 | 231 | 33460 | Minneapolis-St. Paul-Bloomington, MN-WI | 34 | 6452 | 450 | 5416 | 170 | 391 | 28312 | 25 | 17546 | 309 | 617 | 39783 | 462 | 14188 | 326 | 700 | 47676 | 3549 | 3614162 | 723958 | 0.200311441490448 |
204 | 204 | 30460 | Lexington-Fayette, KY | 11 | 2269 | 923 | 4083 | 107 | 304 | 13164 | 30 | 1403 | 30 | 64 | 3744 | 938 | 4786 | 123 | 336 | 14097 | 1239 | 516697 | 103516 | 0.200341786385444 |
319 | 319 | 42340 | Savannah, GA | 7 | 1284 | 145 | 1478 | 69 | 100 | 5307 | 5 | 1021 | 41 | 85 | 2960 | 148 | 1988 | 90 | 142 | 6626 | 120 | 389494 | 78071 | 0.200442112073613 |
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 |
238 | 238 | 34060 | Morgantown, WV | 4 | 958 | 379 | 2034 | 107 | 134 | 7325 | 7 | 744 | 35 | 48 | 2456 | 382 | 2406 | 125 | 158 | 8139 | 67 | 140259 | 28135 | 0.200593188315901 |
27 | 27 | 12940 | Baton Rouge, LA | 18 | 2495 | 98 | 3365 | 487 | 213 | 12596 | 2 | 1750 | 157 | 116 | 4797 | 99 | 4241 | 565 | 271 | 14895 | 349 | 853610 | 171355 | 0.200741556448495 |
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 |
363 | 363 | 47380 | Waco, TX | 3 | 542 | 24 | 951 | 83 | 55 | 3280 | 1 | 411 | 38 | 22 | 1203 | 25 | 1156 | 102 | 66 | 3851 | 209 | 271942 | 54698 | 0.201138478057821 |
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 |
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 |
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 |
342 | 342 | 45220 | Tallahassee, FL | 4 | 798 | 77 | 1498 | 118 | 99 | 4966 | 0 | 379 | 20 | 29 | 1613 | 77 | 1688 | 129 | 114 | 5688 | 132 | 385145 | 77822 | 0.202058964805463 |
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 |
42 | 42 | 14260 | Boise City, ID | 9 | 1405 | 11 | 3309 | 136 | 210 | 13851 | 0 | 1456 | 39 | 98 | 4584 | 11 | 4036 | 156 | 259 | 16083 | 958 | 730426 | 148259 | 0.202976071498003 |
352 | 352 | 46220 | Tuscaloosa, AL | 5 | 803 | 0 | 1198 | 59 | 86 | 3758 | 0 | 432 | 22 | 49 | 1498 | 0 | 1413 | 69 | 110 | 4490 | 364 | 251808 | 51164 | 0.20318655483543 |
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 |
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 );