aha2018staffing_cbsa

Table actions

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

384 rows sorted by lpn_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
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
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
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
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
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
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
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
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
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
28 28 12980 Battle Creek, MI 3 301 2 619 29 41 2122 0 201 10 26 750 2 720 34 54 2492 157 134487 33022 0.245540461159815
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
113 113 21660 Eugene-Springfield, OR 5 619 3 913 16 22 2876 0 1183 10 9 2730 3 1504 20 26 4239 478 379611 99276 0.261520345827703
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
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
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
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
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
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
20 20 12220 Auburn-Opelika, AL 1 549 3 664 50 28 2690 5 155 11 10 699 5 742 56 33 3034 41 163941 27736 0.169182815769088
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
31 31 13220 Beckley, WV 4 483 7 428 115 41 1665 0 73 12 2 209 7 464 120 42 1761 57 117272 33304 0.283989358073538
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
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
97 97 19780 Des Moines-West Des Moines, IA 9 1625 215 2743 53 124 10655 0 1448 12 49 4065 215 3466 58 148 12461 1183 692556 133229 0.192372891145265
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
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
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
364 364 47460 Walla Walla, WA 2 117 2 273 25 19 1050 0 153 12 11 506 2 350 31 24 1301 0 60922 14908 0.244706345819244
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
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
106 106 20940 El Centro, CA 2 268 13 346 40 21 1447 0 160 13 14 514 13 426 46 28 1691 0 181827 32641 0.179516793435518
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
229 229 33260 Midland, TX 4 372 1 361 37 46 1819 11 160 13 11 494 7 441 43 52 2057 2 178331 27460 0.153983323146284
259 259 36500 Olympia-Lacey-Tumwater, WA 2 401 3 877 27 51 2291 0 526 13 31 1259 3 1140 33 66 2918 222 286419 68112 0.237805452850544
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
200 200 30020 Lawton, OK 2 530 26 349 167 19 1868 0 74 18 8 221 26 386 176 23 1952 121 126198 23327 0.184844450783689
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
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
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
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
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
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
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
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
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
293 293 40220 Roanoke, VA 3 1182 335 2725 121 183 8632 3 595 19 37 1812 337 3022 130 202 9200 688 314172 85918 0.273474402556561
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
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
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
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
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
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
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
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
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

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