aha2018staffing_cbsa

Table actions

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

384 rows sorted by rn_pt

✎ 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
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
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
280 280 39150 Prescott Valley-Prescott, AZ 3 320 0 441 2 37 1938 0 216 1 15 606 0 549 2 44 2241 161 231993 95260 0.410615837546823
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
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
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
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
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
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
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
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
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
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
94 94 19500 Decatur, IL 2 534 21 468 83 24 2196 0 249 22 19 942 21 593 94 34 2646 87 104712 28506 0.272232408892964
303 303 41140 St. Joseph, MO-KS 1 352 0 669 154 31 3155 0 250 37 9 854 0 794 173 36 3582 176 126490 29366 0.232160645110285
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
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
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
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
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
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
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
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
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
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
56 56 16020 Cape Girardeau, MO-IL 3 484 0 996 136 66 3839 0 265 20 24 993 0 1128 146 78 4336 220 96982 23372 0.24099317399105
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
214 214 31340 Lynchburg, VA 3 1200 20 939 114 62 4622 1 315 100 20 1299 20 1097 165 72 5230 296 263353 67364 0.255793554658576
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
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
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
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
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
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
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
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
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
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
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
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
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
154 154 25860 Hickory-Lenoir-Morganton, NC 4 759 36 1292 100 73 4388 0 357 17 14 986 36 1470 109 80 4843 264 368416 95831 0.260116281594719
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
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
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
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
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
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
203 203 30340 Lewiston-Auburn, ME 2 540 41 756 14 40 2648 4 377 5 30 1030 43 945 17 55 3118 158 107679 26645 0.247448434699431
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
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
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
253 253 35980 Norwich-New London, CT 2 435 0 218 0 22 1520 0 398 1 28 1300 0 417 0 36 2146 190 266784 67616 0.253448482667626
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
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
121 121 22420 Flint, MI 4 1242 378 2463 19 127 6710 0 402 13 51 1498 378 2665 26 152 7067 79 406892 99868 0.245441050696499
140 140 24500 Great Falls, MT 2 522 0 491 59 30 2189 0 402 29 21 1426 0 692 74 40 2902 216 81643 20533 0.251497372708009
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
124 124 22540 Fond du Lac, WI 2 155 0 163 9 10 986 0 409 21 7 1207 0 368 19 14 1590 105 103066 26428 0.256418217452894
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
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
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
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
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
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
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
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
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
278 278 38940 Port St. Lucie, FL 4 1088 23 1590 69 92 5527 0 457 22 38 1481 23 1819 80 111 6243 164 482040 162528 0.337167040079661
381 381 49620 York-Hanover, PA 6 958 158 1738 65 128 5824 0 466 17 43 1709 158 1972 75 150 6520 139 448273 108873 0.242872089106415
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
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
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

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