aha2018staffing_cbsa

Table actions

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

384 rows sorted by rowid 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
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
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
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
281 281 39300 Providence-Warwick, RI-MA 16 3219 789 4428 113 193 17834 5 4573 77 316 14002 791 6714 152 351 23974 1773 1621337 387233 0.238835602962247
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
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
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
277 277 38900 Portland-Vancouver-Hillsboro, OR-WA 19 4199 1140 8514 53 462 26763 222 4518 29 187 11721 1251 10775 68 556 31344 5838 2478810 519060 0.209398864777857
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
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
274 274 38340 Pittsfield, MA 2 300 75 355 57 24 2120 0 575 35 14 1731 75 643 75 31 2911 226 126348 39567 0.313158894481907
273 273 38300 Pittsburgh, PA 35 7400 1747 13452 284 877 39726 3 4240 83 269 12177 1749 15570 325 1012 43943 1302 2324743 641560 0.275970290049266
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
271 271 38060 Phoenix-Mesa-Chandler, AZ 46 9104 851 17361 212 1296 48597 1 4475 59 259 10150 851 19599 240 1426 52759 4091 4857962 1029136 0.211845214104186
270 270 37980 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD 69 16908 5113 31719 605 1489 109663 120 13184 240 851 38412 5173 38312 727 1914 123425 8587 6096372 1370514 0.224808131787233
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
267 267 37620 Parkersburg-Vienna, WV 2 279 18 494 38 31 1712 0 127 30 12 507 18 558 53 37 1948 47 90033 24996 0.277631535103795
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
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
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
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
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
261 261 36740 Orlando-Kissimmee-Sanford, FL 14 6665 498 11661 189 717 36240 40 4578 168 276 12962 518 13949 272 855 42182 997 2572962 524021 0.203664492518739
260 260 36540 Omaha-Council Bluffs, NE-IA 18 2551 12 4845 131 327 15209 1 2103 62 189 7529 13 5897 165 422 18956 1404 942198 183775 0.195049235935546
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
258 258 36420 Oklahoma City, OK 31 4225 139 6160 362 497 19461 7 2648 92 212 6262 143 7483 409 603 22343 1377 1396445 274396 0.196496102603396
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
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
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
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
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
252 252 35840 North Port-Sarasota-Bradenton, FL 9 2222 70 2850 172 169 9315 0 922 59 79 3011 70 3312 202 208 10749 117 821573 329526 0.401091564596208
251 251 35660 Niles, MI 2 344 39 814 28 51 2639 3 202 6 11 625 41 915 31 56 2908 31 154141 41569 0.269681655107986
250 250 35620 New York-Newark-Jersey City, NY-NJ-PA 129 47568 19312 90761 2425 3416 351486 286 24303 519 1521 86332 19458 102912 2688 4176 374778 40545 19303808 4217221 0.218465755564912
249 249 35380 New Orleans-Metairie, LA 29 4245 356 6628 836 533 22716 0 2673 229 297 7098 356 7959 948 682 25881 2145 1270399 286150 0.225244194934033
248 248 35300 New Haven-Milford, CT 9 2272 1482 4963 90 212 15513 1 2889 56 122 8129 1483 6408 118 273 18089 546 857620 205879 0.240058534082694
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
246 246 34980 Nashville-Davidson-Murfreesboro-Franklin, TN 28 5467 1454 10255 675 558 40655 7 3974 183 267 12261 1459 12241 766 692 45311 1579 1905898 362768 0.190339671902694
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
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
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
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
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
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
239 239 34100 Morristown, TN 2 185 1 231 13 17 656 0 130 5 13 321 1 296 15 24 811 0 141726 37014 0.261165911688752
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
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
236 236 33780 Monroe, MI 1 100 50 148 0 15 689 0 52 1 8 317 50 174 1 19 797 50 150439 38597 0.256562460532176
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
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
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
232 232 33540 Missoula, MT 2 318 16 399 55 30 1954 0 453 24 18 1442 16 626 68 39 2643 96 118791 25903 0.218055239875075
231 231 33460 Minneapolis-St. Paul-Bloomington, MN-WI 34 6452 450 5416 170 391 28312 25 17546 309 617 39783 462 14188 326 700 47676 3549 3614162 723958 0.200311441490448
230 230 33340 Milwaukee-Waukesha, WI 24 4030 172 7546 49 415 23573 0 4392 40 188 13864 172 9741 69 509 30047 1044 1576113 348103 0.220861702174907
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
228 228 33220 Midland, MI 1 270 24 381 55 21 1452 10 260 41 15 775 29 511 75 28 1811 142 83209 21017 0.252580850629139
227 227 33140 Michigan City-La Porte, IN 2 262 5 343 14 27 1417 0 197 5 12 568 5 441 17 33 1696 32 110007 27281 0.247993309516667
226 226 33100 Miami-Fort Lauderdale-Pompano Beach, FL 55 16532 2085 26116 774 1405 76940 0 4995 169 487 15172 2085 28613 860 1648 82391 3731 6198782 1501643 0.242248073895807
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
224 224 32820 Memphis, TN-MS-AR 17 3879 62 4787 103 346 14721 35 1716 37 140 4002 79 5642 120 416 16623 1040 1342349 268715 0.200182664865843
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
222 222 32580 McAllen-Edinburg-Mission, TX 8 2187 2 2650 183 181 8716 0 753 24 94 1735 2 3026 194 228 9583 228 865939 129577 0.149637561075318
221 221 31900 Mansfield, OH 2 274 15 391 19 21 1371 0 208 8 12 591 15 494 23 27 1648 137 121099 32031 0.264502597048696
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
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
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
217 217 31540 Madison, WI 11 1681 700 2696 38 181 12248 1 2316 29 104 6448 701 3855 52 233 14683 19 660422 135323 0.204903834215093
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
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
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
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
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
211 211 31080 Los Angeles-Long Beach-Anaheim, CA 116 27247 3652 49602 2319 3084 157159 23 20504 765 1800 54446 3663 59852 2701 3984 180232 3569 13291486 2601177 0.195702497072186
210 210 31020 Longview, WA 1 180 3 225 0 16 743 0 175 4 7 522 3 313 2 20 1001 84 108987 28418 0.260746694559902
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
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
207 207 30780 Little Rock-North Little Rock-Conway, AR 17 3103 5 5187 278 411 15536 5 3008 118 199 8966 7 6692 337 510 19995 918 741104 158221 0.21349365271271
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
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
204 204 30460 Lexington-Fayette, KY 11 2269 923 4083 107 304 13164 30 1403 30 64 3744 938 4786 123 336 14097 1239 516697 103516 0.200341786385444
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
202 202 30300 Lewiston, ID-WA 2 148 6 279 21 18 1060 0 90 6 6 287 6 325 24 21 1196 0 63018 17959 0.284982068615316
201 201 30140 Lebanon, PA 1 151 18 236 1 19 806 0 48 0 3 155 18 260 1 20 865 128 141314 36766 0.260172382071132
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
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
198 198 29820 Las Vegas-Henderson-Paradise, NV 24 4590 154 7047 288 527 20434 0 1430 72 169 4049 154 7760 324 612 22298 156 2231647 454888 0.203835104745509
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
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
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
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
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
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
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
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
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
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
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
186 186 28940 Knoxville, TN 11 2390 15 3761 237 235 12039 1 1026 45 91 3040 16 4276 260 280 13488 312 860164 214489 0.249358261912845
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

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