aha2018staffing_cbsa

Table actions

Data source: Big Local News · About: big-local-datasette

384 rows sorted by pop2018_60pluspct

✎ 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 ▼
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
44 44 14500 Boulder, CO 5 640 0 935 6 47 3314 0 958 10 56 2951 0 1413 11 75 4788 207 326078 66402 0.203638393267868
261 261 36740 Orlando-Kissimmee-Sanford, FL 14 6665 498 11661 189 717 36240 40 4578 168 276 12962 518 13949 272 855 42182 997 2572962 524021 0.203664492518739
198 198 29820 Las Vegas-Henderson-Paradise, NV 24 4590 154 7047 288 527 20434 0 1430 72 169 4049 154 7760 324 612 22298 156 2231647 454888 0.203835104745509
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
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
189 189 29180 Lafayette, LA 18 1415 74 1869 215 119 6437 0 612 75 76 1836 74 2177 254 157 7276 73 489364 100160 0.204673821531621
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
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
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
1 1 10180 Abilene, TX 6 731 0 1002 140 66 3299 0 359 28 38 931 0 1182 153 85 3706 94 171451 35194 0.205271476981762
148 148 25220 Hammond, LA 8 405 0 592 107 47 2274 0 290 33 30 918 0 737 123 62 2734 123 133777 27520 0.205715481734528
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
69 69 16980 Chicago-Naperville-Elgin, IL-IN-WI 96 24317 6477 40583 569 2151 137919 842 19098 285 1250 61967 6897 50135 718 2776 161826 9238 9498716 1961714 0.206524123892113
168 168 27140 Jackson, MS 16 2670 626 3769 239 276 12775 0 1143 46 123 2933 626 4341 261 338 13617 731 597788 123645 0.206837541068071
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
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
361 361 47260 Virginia Beach-Norfolk-Newport News, VA-NC 18 3556 86 6481 401 355 21401 1 2291 104 156 6855 87 7627 454 433 24678 2245 1765042 367457 0.208185980843515
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
181 181 28140 Kansas City, MO-KS 41 6576 137 11178 371 680 38170 22 5827 83 314 16003 148 14091 412 837 45824 2693 2143651 448252 0.209106799567653
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
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
79 79 17900 Columbia, SC 8 2064 281 3726 119 242 11711 3 1570 67 104 4133 283 4510 153 294 13493 1452 832666 174465 0.209525788251232
127 127 23060 Fort Wayne, IN 10 1697 29 2209 63 86 6412 0 1723 39 119 4656 29 3071 84 146 8709 682 409425 85904 0.209816205654271
159 159 26380 Houma-Thibodaux, LA 7 577 0 858 136 100 3704 0 284 28 56 1125 0 1000 150 128 4263 306 209136 44016 0.210465916915309
191 191 29340 Lake Charles, LA 8 791 3 1130 223 81 4059 0 360 53 36 1189 3 1310 248 99 4636 113 210080 44365 0.21118145468393
15 15 11540 Appleton, WI 3 352 0 398 18 21 1249 0 621 36 24 1399 0 709 36 33 1947 118 237524 50245 0.211536518414981
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
271 271 38060 Phoenix-Mesa-Chandler, AZ 46 9104 851 17361 212 1296 48597 1 4475 59 259 10150 851 19599 240 1426 52759 4091 4857962 1029136 0.211845214104186
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
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
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
373 373 48620 Wichita, KS 16 1898 29 2550 78 98 6748 0 914 26 56 2548 29 3008 91 126 7994 203 637578 135566 0.212626533537857
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
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
64 64 16700 Charleston-North Charleston, SC 7 1957 660 4326 102 190 12784 0 299 7 23 857 660 4474 104 202 12553 323 787643 168125 0.213453303082742
162 162 26620 Huntsville, AL 4 1269 1 2879 125 139 8509 0 1239 33 72 2856 1 3499 142 175 9925 226 462693 98780 0.213489289874712
207 207 30780 Little Rock-North Little Rock-Conway, AR 17 3103 5 5187 278 411 15536 5 3008 118 199 8966 7 6692 337 510 19995 918 741104 158221 0.21349365271271
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
237 237 33860 Montgomery, AL 8 1098 3 1771 61 83 5010 1 661 18 58 1753 3 2100 70 112 5882 76 373225 80112 0.21464800053587
312 312 41860 San Francisco-Oakland-Berkeley, CA 40 9510 2228 12196 614 743 47506 21 13004 324 643 30219 2238 18695 776 1064 60323 2817 4729484 1015533 0.214723847252681
299 299 40900 Sacramento-Roseville-Folsom, CA 17 3875 1044 6253 238 359 21664 30 4806 104 284 11369 1060 8655 289 501 26266 1133 2345210 504257 0.215015712878591
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
103 103 20500 Durham-Chapel Hill, NC 8 2425 1563 7307 76 362 23381 0 1024 35 61 2695 1563 7819 93 392 23156 112 635527 136957 0.215501465712708
351 351 46140 Tulsa, OK 26 3111 12 4615 193 299 13751 0 861 47 83 2628 12 5047 218 340 15051 419 993797 214858 0.216199082911299
71 71 17140 Cincinnati, OH-KY-IN 28 5820 1587 9902 255 680 36231 48 6684 136 415 17148 1611 13244 323 888 43025 4468 2212945 480288 0.217035669661921
374 374 48660 Wichita Falls, TX 6 456 0 603 69 42 2387 0 209 17 27 603 0 707 78 56 2688 29 151306 32919 0.217565727730559
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
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
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
250 250 35620 New York-Newark-Jersey City, NY-NJ-PA 129 47568 19312 90761 2425 3416 351486 286 24303 519 1521 86332 19458 102912 2688 4176 374778 40545 19303808 4217221 0.218465755564912
24 24 12580 Baltimore-Columbia-Towson, MD 24 7143 1495 14759 194 740 51473 15 5633 66 445 16928 1502 17575 227 962 58252 3366 2802789 613056 0.218730700027722
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
195 195 29620 Lansing-East Lansing, MI 7 1203 264 1961 25 108 7786 4 724 11 53 2325 266 2324 31 134 8677 379 550085 120842 0.219678776916295
43 43 14460 Boston-Cambridge-Newton, MA-NH 51 11222 5082 20710 540 903 99035 43 16581 260 633 49695 5102 28998 674 1220 118049 8248 4875390 1072179 0.219916560521312
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
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
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
291 291 40060 Richmond, VA 16 3671 998 6231 405 362 20727 2 2108 80 149 5437 999 7285 445 436 22368 29 1282442 282927 0.220615825121136
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
305 305 41420 Salem, OR 4 534 1 1225 7 78 4175 0 390 0 12 1029 1 1420 7 84 4688 174 432102 95446 0.220887660783796
170 170 27260 Jacksonville, FL 14 4158 599 6345 85 395 18741 0 1893 30 116 4396 599 7293 101 453 20318 1267 1534701 339920 0.221489397609046
331 331 43900 Spartanburg, SC 3 795 66 1637 16 89 4786 0 424 1 34 1231 66 1850 17 106 5336 483 313888 69698 0.222047354470384
59 59 16220 Casper, WY 4 315 0 386 14 31 1413 0 131 8 11 299 0 452 19 36 1561 31 79115 17595 0.222397775390255
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
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
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
146 146 25060 Gulfport-Biloxi, MS 8 1191 0 2087 90 105 5955 0 684 34 46 1606 0 2429 108 128 6722 179 415978 92767 0.223009389919659
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
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
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
21 21 12260 Augusta-Richmond County, GA-SC 10 1969 23 3081 157 236 8967 0 934 29 56 2063 23 3548 172 264 9970 230 604167 135030 0.223497807725347
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
142 142 24580 Green Bay, WI 6 698 0 1243 133 56 5081 0 1280 75 48 3402 0 1883 170 80 6761 135 321591 71939 0.223697180580302
111 111 21420 Enid, OK 3 300 0 269 21 28 877 0 87 5 9 265 0 312 23 32 1007 97 60913 13635 0.223843842857846
36 36 13820 Birmingham-Hoover, AL 17 4632 891 8735 210 504 23191 3 1990 42 173 5167 893 9730 230 590 24880 1678 1088090 243658 0.223931843873209
335 335 44180 Springfield, MO 5 1501 27 3367 384 206 15409 0 1080 76 55 4388 27 3906 422 234 17576 922 466978 104586 0.223963441532578
270 270 37980 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD 69 16908 5113 31719 605 1489 109663 120 13184 240 851 38412 5173 38312 727 1914 123425 8587 6096372 1370514 0.224808131787233
212 212 31140 Louisville-Jefferson County, KY-IN 15 3701 0 6542 190 443 17372 5 2752 119 216 6904 3 7917 249 551 20820 519 1264908 284540 0.224949166263475
379 379 49340 Worcester, MA-CT 11 1820 631 2070 131 170 11616 11 3159 93 161 7802 637 3649 176 250 14862 1398 947866 213269 0.224999103248771
249 249 35380 New Orleans-Metairie, LA 29 4245 356 6628 836 533 22716 0 2673 229 297 7098 356 7959 948 682 25881 2145 1270399 286150 0.225244194934033
143 143 24660 Greensboro-High Point, NC 6 1636 405 3248 144 198 11548 5 891 32 62 2510 408 3693 159 229 12374 215 767711 172942 0.225269665277689
354 354 46340 Tyler, TX 8 1209 81 2198 308 122 7355 0 385 42 43 1032 81 2390 330 144 7781 220 230221 51905 0.225457278006785
177 177 27900 Joplin, MO 5 697 26 1062 74 105 4484 0 476 9 53 1517 26 1300 79 132 5216 373 178902 40421 0.225939341091771
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
326 326 43340 Shreveport-Bossier City, LA 10 1573 75 2668 357 165 10864 0 330 32 42 964 75 2833 374 186 11268 313 397543 89873 0.226071141989672
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
37 37 13900 Bismarck, ND 3 505 0 1024 109 84 3535 0 450 67 43 1536 0 1249 143 106 4303 289 128320 29161 0.227252182044888
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
262 262 36780 Oshkosh-Neenah, WI 4 375 0 484 7 23 1636 0 574 20 35 1483 0 772 17 40 2374 43 171020 38939 0.227686820254941
145 145 24860 Greenville-Anderson, SC 14 2096 299 3568 69 274 11173 0 2174 32 156 5134 299 4656 86 352 13442 7251 906626 206572 0.227846984313267
173 173 27620 Jefferson City, MO 3 243 8 497 135 29 2029 0 72 22 7 374 8 534 146 32 2208 140 151520 34578 0.228207497360084
233 233 33660 Mobile, AL 7 1458 422 2404 91 156 8165 2 580 23 53 1767 423 2692 103 182 8615 293 430135 98194 0.228286468201844
359 359 47020 Victoria, TX 5 565 20 670 84 49 2189 0 112 17 28 354 20 726 93 63 2346 47 99619 22743 0.228299822323051
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
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
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
147 147 25180 Hagerstown-Martinsburg, MD-WV 3 514 0 889 10 59 2700 0 305 27 22 882 0 1042 24 70 3141 68 285836 65737 0.229981527869128
294 294 40340 Rochester, MN 4 1576 1338 1947 68 166 28724 2 4939 115 64 10626 1339 4416 125 198 32698 2119 219802 50575 0.230093447739329
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

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