aha2018staffing_cbsa

Table actions

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

384 rows sorted by hospbeds

✎ 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
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
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
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
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
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
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
360 360 47220 Vineland-Bridgeton, NJ 2 376 149 527 37 29 1687 0 76 2 2 240 149 565 38 30 1658 0 150972 32008 0.212012823569934
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
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
375 375 48700 Williamsport, PA 3 394 16 564 94 33 1855 0 143 30 14 479 16 635 109 40 2073 441 113664 30241 0.266056095157658
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
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
57 57 16060 Carbondale-Marion, IL 4 398 11 906 40 63 2661 0 122 6 15 430 11 967 43 70 2866 351 136931 32944 0.240588325507007
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
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
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
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
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
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
188 188 29100 La Crosse-Onalaska, WI-MN 2 414 17 714 60 30 3832 0 1200 71 64 2958 17 1314 96 62 5293 718 136808 32318 0.236228875504357
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3 3 10500 Albany, GA 2 479 21 649 53 71 2426 0 854 42 67 2210 21 1076 74 104 3506 0 149917 32634 0.217680449848916
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
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
135 135 24220 Grand Forks, ND-MN 4 485 29 389 111 26 2889 0 484 135 9 1494 29 631 178 30 3606 248 102299 20557 0.200950155915503
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
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
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
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
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
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
192 192 29420 Lake Havasu City-Kingman, AZ 4 512 24 880 63 61 3144 0 155 8 13 476 24 957 67 68 3354 16 209550 81693 0.389849677881174
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
325 325 43300 Sherman-Denison, TX 5 556 21 911 55 53 2827 0 82 6 9 225 21 951 58 58 2918 0 133991 32757 0.244471643617855
85 85 18880 Crestview-Fort Walton Beach-Destin, FL 5 558 11 725 29 45 1947 0 203 5 15 483 11 826 31 52 2177 3 278644 66492 0.238627065359383
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
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
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
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
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
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
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
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
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
129 129 23460 Gadsden, AL 3 603 9 703 27 50 1752 0 182 7 22 467 9 794 31 61 1976 25 102501 26509 0.258621867103736
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
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
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
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
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
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
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
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
358 358 46700 Vallejo, CA 4 672 2 540 9 41 2349 0 1530 23 83 3104 2 1304 20 82 3899 0 446610 99517 0.222827522894696
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
284 284 39460 Punta Gorda, FL 3 681 15 723 16 50 2012 0 198 5 29 533 15 821 18 64 2262 0 184998 91684 0.495594546968075
356 356 46540 Utica-Rome, NY 4 687 37 851 95 60 3827 0 652 40 34 1815 37 1178 116 77 4695 120 291410 76117 0.26120242956659
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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