aha2018staffing_cbsa

Table actions

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

384 rows sorted by resid_ft

✎ 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
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
4 4 10540 Albany-Lebanon, OR 2 95 0 279 12 19 1249 0 140 2 8 587 0 348 13 23 1528 241 127335 32441 0.254768916637217
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
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
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
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
26 26 12700 Barnstable Town, MA 3 414 0 286 6 15 1593 0 882 12 54 2966 0 727 12 42 3076 225 213413 84732 0.397032982995413
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
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
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
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
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
49 49 15260 Brunswick, GA 1 532 0 335 12 24 1419 0 17 0 3 89 0 343 12 26 1463 98 118456 32606 0.275258323765786
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
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
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
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
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
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
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
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
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
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
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
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
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
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
89 89 19180 Danville, IL 2 130 0 170 5 12 470 0 29 3 2 114 0 184 6 13 527 889 76806 20155 0.262414394708747
91 91 19340 Davenport-Moline-Rock Island, IA-IL 8 1082 0 1195 31 78 3502 0 667 12 34 2121 0 1527 38 95 4561 1095 381451 95065 0.24921942792128
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
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
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
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
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
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
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
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
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
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
132 132 23900 Gettysburg, PA 1 76 0 184 2 12 615 0 36 1 2 141 0 202 3 13 685 239 102811 28621 0.278384608650825
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
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
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
139 139 24420 Grants Pass, OR 1 121 0 221 11 22 751 0 80 5 8 283 0 261 13 26 893 54 87393 29751 0.34042772304418
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
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
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
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
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
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
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
158 158 26300 Hot Springs, AR 3 449 0 535 37 42 1441 0 190 3 19 434 0 630 38 52 1658 117 99154 30920 0.311838150755391
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
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
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
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
193 193 29460 Lakeland-Winter Haven, FL 5 1617 0 2456 22 157 6908 0 863 4 61 1847 0 2887 24 188 7831 157 708009 186244 0.263053153279125
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
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
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
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
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
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
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
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
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
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
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
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
255 255 36140 Ocean City, NJ 1 178 0 164 0 13 731 0 82 0 6 345 0 205 0 16 895 37 92560 32579 0.35197709593777
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
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
263 263 36980 Owensboro, KY 1 360 0 589 11 22 1977 0 189 0 11 576 0 684 11 28 2265 82 119114 28304 0.237621102473261
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
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
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
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
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
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
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
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
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
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
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
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
338 338 44420 Staunton, VA 1 209 0 390 72 14 1688 0 138 5 8 518 0 459 75 18 1947 132 123007 33919 0.27574853463624
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
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
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
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
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
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
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
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
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
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
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
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
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

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