aha2018staffing_cbsa

Table actions

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

384 rows sorted by pop2018_60plus

✎ 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
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
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
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
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
287 287 39660 Rapid City, SD 5 605 24 638 66 32 2928 0 372 11 14 1088 24 825 72 39 3448 315 140023 34681 0.247680738164444
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
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
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
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
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
370 370 48260 Weirton-Steubenville, WV-OH 4 526 0 643 61 60 2875 0 203 25 48 757 0 745 74 84 3252 90 117064 35525 0.303466479874257
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
240 240 34580 Mount Vernon-Anacortes, WA 3 270 29 301 9 33 2121 0 509 7 17 1202 29 555 12 42 2692 244 128206 35758 0.278910503408577
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
123 123 22520 Florence-Muscle Shoals, AL 3 601 3 696 22 45 2042 0 187 8 21 637 3 789 26 56 2358 40 147149 39744 0.270093578617592
367 367 47940 Waterloo-Cedar Falls, IA 6 546 6 589 109 33 2780 0 661 104 21 2113 6 919 160 44 3830 308 169659 39879 0.235053843297438
137 137 24300 Grand Junction, CO 3 412 27 696 18 42 2379 0 267 4 8 749 27 829 19 46 2722 90 153207 40055 0.261443667717532
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
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
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
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
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
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
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
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
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
369 369 48140 Wausau-Weston, WI 4 325 0 768 8 46 2032 0 321 12 33 1070 0 929 14 62 2566 263 163117 41668 0.255448543070312
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
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
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
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
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
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
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
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
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
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
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
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
344 344 45460 Terre Haute, IN 5 493 29 806 20 58 2426 0 323 9 36 897 29 968 24 76 2846 109 186652 44347 0.237591882219317
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
34 34 13740 Billings, MT 5 576 34 1036 109 80 4522 0 454 43 41 1804 34 1265 132 100 5377 408 180385 44549 0.246966211159465
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
66 66 16820 Charlottesville, VA 3 806 777 2478 147 133 8876 3 779 17 39 1784 778 2868 156 152 8986 83 218233 52938 0.24257559580815
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
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
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
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
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
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
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
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
126 126 22900 Fort Smith, AR-OK 8 851 0 939 161 77 3328 0 212 32 17 591 0 1045 176 86 3623 316 250148 57993 0.231834753825735
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
348 348 45820 Topeka, KS 4 701 0 1219 286 79 4872 0 434 76 21 1560 0 1436 323 90 5653 321 232594 59239 0.25468842704455
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
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
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
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
223 223 32780 Medford, OR 3 513 0 911 15 79 2789 0 488 14 27 1354 0 1156 23 92 3459 340 219564 64189 0.292347561531034

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