aha2018staffing_cbsa
Data source: Big Local News · About: big-local-datasette
384 rows sorted by physpriv
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 |
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 );