aha2018staffing_cbsa
Data source: Big Local News · About: big-local-datasette
384 rows sorted by hospitals
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
90 | 90 | 19300 | Daphne-Fairhope-Foley, AL | 3 | 298 | 15 | 758 | 19 | 22 | 1739 | 0 | 83 | 4 | 5 | 259 | 15 | 800 | 21 | 24 | 1854 | 0 | 218022 | 60236 | 0.276284044729431 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
155 | 155 | 25940 | Hilton Head Island-Bluffton, SC | 3 | 331 | 19 | 560 | 22 | 33 | 1795 | 0 | 200 | 2 | 20 | 612 | 19 | 660 | 23 | 43 | 2081 | 56 | 217686 | 72926 | 0.335005466589491 |
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 |
163 | 163 | 26820 | Idaho Falls, ID | 3 | 345 | 17 | 661 | 29 | 34 | 1843 | 0 | 151 | 8 | 12 | 406 | 17 | 736 | 33 | 40 | 2029 | 0 | 148904 | 27223 | 0.182822489657766 |
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 |
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 |
173 | 173 | 27620 | Jefferson City, MO | 3 | 243 | 8 | 497 | 135 | 29 | 2029 | 0 | 72 | 22 | 7 | 374 | 8 | 534 | 146 | 32 | 2208 | 140 | 151520 | 34578 | 0.228207497360084 |
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 |
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 |
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 |
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 |
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 |
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 |
240 | 240 | 34580 | Mount Vernon-Anacortes, WA | 3 | 270 | 29 | 301 | 9 | 33 | 2121 | 0 | 509 | 7 | 17 | 1202 | 29 | 555 | 12 | 42 | 2692 | 244 | 128206 | 35758 | 0.278910503408577 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
38 | 38 | 13980 | Blacksburg-Christiansburg, VA | 4 | 252 | 4 | 584 | 40 | 38 | 1800 | 0 | 169 | 6 | 14 | 509 | 4 | 670 | 44 | 45 | 2050 | 296 | 168234 | 35213 | 0.209309652032288 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
162 | 162 | 26620 | Huntsville, AL | 4 | 1269 | 1 | 2879 | 125 | 139 | 8509 | 0 | 1239 | 33 | 72 | 2856 | 1 | 3499 | 142 | 175 | 9925 | 226 | 462693 | 98780 | 0.213489289874712 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
327 | 327 | 43420 | Sierra Vista-Douglas, AZ | 4 | 160 | 6 | 264 | 11 | 20 | 1012 | 0 | 71 | 2 | 8 | 205 | 6 | 300 | 13 | 24 | 1106 | 15 | 126770 | 36908 | 0.29114143724856 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );