aha2018staffing_cbsa

Table actions

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

384 rows sorted by resid_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
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
69 69 16980 Chicago-Naperville-Elgin, IL-IN-WI 96 24317 6477 40583 569 2151 137919 842 19098 285 1250 61967 6897 50135 718 2776 161826 9238 9498716 1961714 0.206524123892113
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
43 43 14460 Boston-Cambridge-Newton, MA-NH 51 11222 5082 20710 540 903 99035 43 16581 260 633 49695 5102 28998 674 1220 118049 8248 4875390 1072179 0.219916560521312
98 98 19820 Detroit-Warren-Dearborn, MI 43 10941 3720 20504 121 947 59594 1 8551 66 485 25879 3720 24781 153 1190 68644 4838 4326442 1003600 0.231968901929114
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
74 74 17460 Cleveland-Elyria, OH 31 7853 2858 16723 821 791 60864 5 5527 236 376 16804 2860 19486 942 979 65744 13360 2057009 526756 0.256078607337158
312 312 41860 San Francisco-Oakland-Berkeley, CA 40 9510 2228 12196 614 743 47506 21 13004 324 643 30219 2238 18695 776 1064 60323 2817 4729484 1015533 0.214723847252681
87 87 19100 Dallas-Fort Worth-Arlington, TX 121 16353 2094 31211 975 2041 86730 194 10342 202 1015 26443 2191 36384 1078 2548 97506 3023 7470158 1223097 0.163731075032148
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
366 366 47900 Washington-Arlington-Alexandria, DC-VA-MD-WV 44 9986 1903 17286 380 933 55874 26 7487 103 424 19789 1915 21031 433 1145 63766 2951 6263245 1166337 0.18621928409315
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
313 313 41940 San Jose-Sunnyvale-Santa Clara, CA 11 3321 1692 6375 125 337 24372 15 5856 103 333 13647 1698 9305 179 504 29456 2067 1999107 377024 0.188596208206964
71 71 17140 Cincinnati, OH-KY-IN 28 5820 1587 9902 255 680 36231 48 6684 136 415 17148 1611 13244 323 888 43025 4468 2212945 480288 0.217035669661921
103 103 20500 Durham-Chapel Hill, NC 8 2425 1563 7307 76 362 23381 0 1024 35 61 2695 1563 7819 93 392 23156 112 635527 136957 0.215501465712708
13 13 11460 Ann Arbor, MI 5 1641 1504 6062 122 313 19930 35 2483 26 74 6077 1521 7304 135 350 21448 327 370963 71921 0.193876478247157
24 24 12580 Baltimore-Columbia-Towson, MD 24 7143 1495 14759 194 740 51473 15 5633 66 445 16928 1502 17575 227 962 58252 3366 2802789 613056 0.218730700027722
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
82 82 18140 Columbus, OH 23 5668 1458 11642 276 645 42623 39 4236 121 285 13145 1477 13759 333 788 47659 3364 2106541 400030 0.189898986062934
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
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
304 304 41180 St. Louis, MO-IL 43 9555 1227 16192 252 738 46968 52 5092 100 286 14950 1252 18740 306 881 53189 3191 2805465 655939 0.233807586264666
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
321 321 42660 Seattle-Tacoma-Bellevue, WA 28 6702 1131 11026 308 398 41786 150 8058 200 382 20923 1206 15055 407 589 50985 10929 3939363 758420 0.192523512050045
160 160 26420 Houston-The Woodlands-Sugar Land, TX 89 16014 1085 32008 817 1809 98540 81 5328 150 597 15234 1126 34673 893 2108 104078 4563 6997384 1147394 0.163974708262402
378 378 49180 Winston-Salem, NC 7 1813 1082 3512 139 195 13508 16 1239 36 66 3391 1090 4130 158 228 14088 1561 671456 161446 0.240441667063814
299 299 40900 Sacramento-Roseville-Folsom, CA 17 3875 1044 6253 238 359 21664 30 4806 104 284 11369 1060 8655 289 501 26266 1133 2345210 504257 0.215015712878591
308 308 41620 Salt Lake City, UT 17 2817 1017 6559 90 390 21639 3 2751 30 150 7512 1018 7935 105 465 24263 1637 1222540 190032 0.155440312791402
291 291 40060 Richmond, VA 16 3671 998 6231 405 362 20727 2 2108 80 149 5437 999 7285 445 436 22368 29 1282442 282927 0.220615825121136
164 164 26900 Indianapolis-Carmel-Anderson, IN 28 5395 927 9141 303 659 34800 8 4191 115 340 12494 932 11238 361 829 40076 5265 2048703 401536 0.195995222343112
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
36 36 13820 Birmingham-Hoover, AL 17 4632 891 8735 210 504 23191 3 1990 42 173 5167 893 9730 230 590 24880 1678 1088090 243658 0.223931843873209
311 311 41740 San Diego-Chula Vista-Carlsbad, CA 18 5750 876 11754 378 690 33196 2 5728 150 398 14799 878 14616 450 889 39693 0 3343364 657318 0.196603779905508
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
18 18 12060 Atlanta-Sandy Springs-Alpharetta, GA 44 10632 819 19687 757 1217 62460 20 6042 210 483 16993 830 22705 861 1458 69905 2000 5949951 1053699 0.177093727326494
150 150 25420 Harrisburg-Carlisle, PA 8 1974 801 3587 386 202 14878 0 1526 84 79 4666 801 4349 427 242 16403 1677 574659 141035 0.245423807858225
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
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
295 295 40380 Rochester, NY 10 3108 712 6810 865 258 25616 329 1993 225 74 8185 876 7809 979 295 28771 3307 1071082 264448 0.246897996605302
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
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
64 64 16700 Charleston-North Charleston, SC 7 1957 660 4326 102 190 12784 0 299 7 23 857 660 4474 104 202 12553 323 787643 168125 0.213453303082742
341 341 45060 Syracuse, NY 6 1943 655 2937 356 183 12276 0 1212 139 72 3589 655 3542 425 219 13414 61 650502 155593 0.239189118557668
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
292 292 40140 Riverside-San Bernardino-Ontario, CA 38 7640 627 13602 856 914 39098 20 4852 182 483 12234 636 16026 949 1156 44519 1320 4622361 851542 0.184222305440878
168 168 27140 Jackson, MS 16 2670 626 3769 239 276 12775 0 1143 46 123 2933 626 4341 261 338 13617 731 597788 123645 0.206837541068071
170 170 27260 Jacksonville, FL 14 4158 599 6345 85 395 18741 0 1893 30 116 4396 599 7293 101 453 20318 1267 1534701 339920 0.221489397609046
8 8 10900 Allentown-Bethlehem-Easton, PA-NJ 12 2683 588 4130 74 227 16570 10 2355 47 130 6686 593 5308 99 292 19315 2773 842913 209670 0.248744532353873
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
5 5 10580 Albany-Schenectady-Troy, NY 8 2453 525 4421 230 240 16047 3 846 40 51 2897 527 4842 249 266 16968 706 883169 213350 0.241573243626078
2 2 10420 Akron, OH 8 1912 518 3832 238 193 15098 230 1939 102 120 5862 633 4802 289 253 17319 1244 704845 174214 0.247166398286148
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
92 92 19430 Dayton-Kettering, OH 11 1994 505 5298 53 400 15999 0 2406 30 210 6734 505 6502 68 505 18832 212 806548 197871 0.245330718072576
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
310 310 41700 San Antonio-New Braunfels, TX 26 6009 468 9285 634 609 25970 0 1589 119 180 4327 468 10078 692 699 27654 262 2518036 461018 0.183086341895032
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
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
96 96 19740 Denver-Aurora-Lakewood, CO 26 5527 443 11163 193 522 33958 10 3745 65 295 9831 449 13035 226 670 38403 1006 2932415 546718 0.186439504640373
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
143 143 24660 Greensboro-High Point, NC 6 1636 405 3248 144 198 11548 5 891 32 62 2510 408 3693 159 229 12374 215 767711 172942 0.225269665277689
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
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
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
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
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
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
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
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
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
22 22 12420 Austin-Round Rock-Georgetown, TX 29 3498 314 6660 150 182 18658 0 2501 86 108 7448 314 7915 195 236 22030 698 2168316 344145 0.158715334849717
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
145 145 24860 Greenville-Anderson, SC 14 2096 299 3568 69 274 11173 0 2174 32 156 5134 299 4656 86 352 13442 7251 906626 206572 0.227846984313267
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
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
79 79 17900 Columbia, SC 8 2064 281 3726 119 242 11711 3 1570 67 104 4133 283 4510 153 294 13493 1452 832666 174465 0.209525788251232
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
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
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
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
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
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
67 67 16860 Chattanooga, TN-GA 6 1956 214 3131 228 202 9603 0 1327 61 125 3261 214 3794 259 264 11018 573 560793 138452 0.246886105925003
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
152 152 25540 Hartford-East Hartford-Middletown, CT 11 2566 202 4048 88 183 16648 8 2745 46 148 8777 206 5420 111 257 20794 909 1206300 291049 0.241274144076929
343 343 45300 Tampa-St. Petersburg-Clearwater, FL 34 8984 202 14212 322 874 42973 0 4043 83 354 11684 202 16233 363 1051 48577 986 3142663 828833 0.263735882593838
138 138 24340 Grand Rapids-Kentwood, MI 11 2491 193 4081 249 302 16454 0 2071 93 100 7334 193 5117 296 352 19845 1514 1072458 217480 0.202786496067911
347 347 45780 Toledo, OH 14 2359 193 4760 144 296 12265 1 1032 65 93 3788 193 5274 176 342 13964 1225 643640 151599 0.235533838791871
382 382 49660 Youngstown-Warren-Boardman, OH-PA 13 1575 190 3336 140 201 7661 0 584 36 94 1597 190 3627 158 248 8267 711 538952 156380 0.290155709599371
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
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
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
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
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
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
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
181 181 28140 Kansas City, MO-KS 41 6576 137 11178 371 680 38170 22 5827 83 314 16003 148 14091 412 837 45824 2693 2143651 448252 0.209106799567653
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
65 65 16740 Charlotte-Concord-Gastonia, NC-SC 23 4906 128 8957 286 583 26663 1 3864 68 270 9455 128 10891 321 718 31252 1013 2594090 499968 0.192733482647094
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
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

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