aha2018staffing_cbsa

Table actions

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

384 rows sorted by rn_ft descending

✎ 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
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
269 269 37900 Peoria, IL 8 1357 290 2365 43 131 7705 0 1100 32 68 3736 290 2915 58 165 9274 826 403217 100647 0.249610011482651
268 268 37860 Pensacola-Ferry Pass-Brent, FL 7 1348 17 2332 53 125 5401 0 559 19 50 1378 17 2612 63 150 6074 183 494883 114044 0.230446388338254
165 165 26980 Iowa City, IA 3 1038 562 2292 36 113 8466 25 921 7 42 3100 575 2753 39 134 9353 67 173401 30830 0.177795975801754
276 276 38860 Portland-South Portland, ME 7 1200 281 2249 48 128 11282 0 1355 34 67 4955 281 2927 65 162 13474 618 535420 144397 0.269689215942624
334 334 44140 Springfield, MA 9 1636 349 2226 51 120 10962 0 1896 84 124 7050 349 3175 93 182 14132 1694 702724 170283 0.242318463578873
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
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
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
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
320 320 42540 Scranton-Wilkes-Barre, PA 10 1651 58 2111 152 114 7635 3 776 63 49 2442 60 2498 183 138 8796 2831 555485 149548 0.269220591015059
63 63 16620 Charleston, WV 7 1210 175 2105 243 122 8269 0 542 61 30 1750 175 2377 275 137 8967 267 260342 73219 0.281241597590861
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
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
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
114 114 21780 Evansville, IN-KY 8 1423 37 2071 48 155 7181 0 957 25 66 3133 37 2550 60 188 8626 417 314672 76462 0.242989525601261
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
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
238 238 34060 Morgantown, WV 4 958 379 2034 107 134 7325 7 744 35 48 2456 382 2406 125 158 8139 67 140259 28135 0.200593188315901
55 55 15980 Cape Coral-Fort Myers, FL 4 1503 304 2006 100 108 7404 1 96 2 14 318 305 2054 101 115 7240 83 754610 270256 0.358139966340229
16 16 11700 Asheville, NC 6 1267 226 1994 83 111 7811 6 889 29 61 2607 229 2439 97 142 8868 145 459585 135574 0.294992221243078
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
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
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
95 95 19660 Deltona-Daytona Beach-Ormond Beach, FL 6 1537 39 1944 94 108 7179 0 827 36 48 2765 39 2359 114 132 8520 136 659605 219617 0.332952297208178
184 184 28700 Kingsport-Bristol, TN-VA 8 1057 30 1911 170 129 7186 3 677 43 59 2230 31 2250 192 158 8266 95 306616 89926 0.293285412372479
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
376 376 48900 Wilmington, NC 2 772 83 1836 28 89 5341 0 852 6 20 1888 83 2262 31 99 6194 27 294436 71799 0.243852653887432
54 54 15940 Canton-Massillon, OH 5 1118 104 1826 210 103 7910 1 948 109 109 3392 105 2300 264 158 9489 213 398655 107137 0.268746158959501
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
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
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
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
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
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
332 332 44060 Spokane-Spokane Valley, WA 9 1578 13 1716 16 175 5564 7 1768 13 84 3877 16 2602 23 217 7486 441 559891 131042 0.234049127419444
288 288 39740 Reading, PA 5 1080 135 1706 61 122 6687 0 663 10 72 2287 135 2037 65 158 7688 75 420152 99405 0.236592947314305
119 119 22220 Fayetteville-Springdale-Rogers, AR 9 1135 8 1699 151 96 5491 0 570 27 31 1634 8 1985 164 112 6296 195 526050 93561 0.177855717137154
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
41 41 14100 Bloomsburg-Berwick, PA 5 789 445 1648 163 82 7457 40 538 43 45 1897 465 1917 185 104 7940 945 83696 22605 0.270084591856242
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
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
183 183 28660 Killeen-Temple, TX 6 1008 387 1616 246 159 6194 23 735 112 80 2353 398 1983 302 199 6971 1890 451679 71446 0.158178706559304
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
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
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
112 112 21500 Erie, PA 6 967 47 1569 49 89 4084 0 580 18 48 1597 47 1858 58 113 4835 223 272061 68330 0.251156909663642
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
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
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
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
77 77 17820 Colorado Springs, CO 5 1069 7 1488 11 78 4293 5 971 13 78 3862 10 1973 17 117 6202 186 738939 138419 0.18732128091764
319 319 42340 Savannah, GA 7 1284 145 1478 69 100 5307 5 1021 41 85 2960 148 1988 90 142 6626 120 389494 78071 0.200442112073613
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
296 296 40420 Rockford, IL 4 864 5 1463 12 96 4771 0 775 8 41 2310 5 1850 15 116 5919 1121 337658 80277 0.237746477204746
307 307 41540 Salisbury, MD-DE 6 741 3 1463 94 104 5946 0 750 37 64 2543 3 1838 112 136 7211 109 409979 131196 0.320006634486157
245 245 34940 Naples-Marco Island, FL 3 956 38 1455 41 84 3790 1 517 20 65 1570 39 1713 50 116 4532 226 378488 147922 0.390823487138298
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
194 194 29540 Lancaster, PA 5 1007 67 1245 54 74 5704 0 996 30 56 3043 67 1743 70 102 7157 344 543557 132272 0.243345224143926
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
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
205 205 30620 Lima, OH 5 508 46 1222 84 59 2710 1 180 15 35 550 46 1311 91 76 2940 172 102663 25056 0.244060664504252
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
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
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
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
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
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
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
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
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
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
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
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
330 330 43780 South Bend-Mishawaka, IN-MI 4 758 55 1078 12 58 2981 21 1020 6 45 3100 66 1588 15 80 4460 218 322424 74833 0.232095005334591
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
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
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
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
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
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
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
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
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
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

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