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
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
383 383 49700 Yuba City, CA 2 233 17 425 19 22 1456 0 203 7 11 548 17 526 22 28 1711 0 174848 34725 0.198601070644217
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
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
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
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
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
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
376 376 48900 Wilmington, NC 2 772 83 1836 28 89 5341 0 852 6 20 1888 83 2262 31 99 6194 27 294436 71799 0.243852653887432
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
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
373 373 48620 Wichita, KS 16 1898 29 2550 78 98 6748 0 914 26 56 2548 29 3008 91 126 7994 203 637578 135566 0.212626533537857
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
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
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
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
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
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
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
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
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
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
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
361 361 47260 Virginia Beach-Norfolk-Newport News, VA-NC 18 3556 86 6481 401 355 21401 1 2291 104 156 6855 87 7627 454 433 24678 2245 1765042 367457 0.208185980843515
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
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
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
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
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
355 355 46520 Urban Honolulu, HI 11 1895 27 3237 91 165 11066 0 1185 30 99 3629 27 3830 105 214 12824 456 980080 230662 0.235350175495878
354 354 46340 Tyler, TX 8 1209 81 2198 308 122 7355 0 385 42 43 1032 81 2390 330 144 7781 220 230221 51905 0.225457278006785
353 353 46300 Twin Falls, ID 2 249 0 428 72 21 1672 0 306 24 5 745 0 581 84 24 2040 50 110096 22445 0.203867533788694
352 352 46220 Tuscaloosa, AL 5 803 0 1198 59 86 3758 0 432 22 49 1498 0 1413 69 110 4490 364 251808 51164 0.20318655483543
351 351 46140 Tulsa, OK 26 3111 12 4615 193 299 13751 0 861 47 83 2628 12 5047 218 340 15051 419 993797 214858 0.216199082911299
350 350 46060 Tucson, AZ 12 2654 25 3818 51 268 11187 0 1202 23 92 3108 25 4418 63 314 12712 1908 1039073 270651 0.260473518222493
349 349 45940 Trenton-Princeton, NJ 5 755 67 1361 31 66 4060 0 557 8 67 1966 67 1639 35 100 4974 415 369811 78636 0.212638347696526
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
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
346 346 45540 The Villages, FL 1 40 0 36 4 11 126 0 12 1 4 42 0 42 4 13 147 0 128754 85511 0.66414247324355
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
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
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
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
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
340 340 44940 Sumter, SC 2 268 0 436 5 23 1467 1 182 1 21 443 1 527 5 34 1688 54 140212 34565 0.246519556100762
339 339 44700 Stockton, CA 7 1077 52 1779 88 126 6232 1 1348 40 67 3380 52 2453 108 160 7860 0 752660 135610 0.180174315095794
338 338 44420 Staunton, VA 1 209 0 390 72 14 1688 0 138 5 8 518 0 459 75 18 1947 132 123007 33919 0.27574853463624
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
336 336 44220 Springfield, OH 2 283 15 427 19 21 1445 0 177 6 10 476 15 515 22 26 1667 0 134585 35338 0.262570122970613
335 335 44180 Springfield, MO 5 1501 27 3367 384 206 15409 0 1080 76 55 4388 27 3906 422 234 17576 922 466978 104586 0.223963441532578
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
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
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
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
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
329 329 43620 Sioux Falls, SD 8 1210 0 3142 320 124 10655 38 1318 145 67 5170 19 3803 394 158 13219 716 265653 50762 0.191083857513373
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
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
326 326 43340 Shreveport-Bossier City, LA 10 1573 75 2668 357 165 10864 0 330 32 42 964 75 2833 374 186 11268 313 397543 89873 0.226071141989672
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
324 324 43100 Sheboygan, WI 2 173 0 236 1 11 721 0 195 1 9 584 0 333 1 16 1009 1 115456 29110 0.252130681818182
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
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
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
320 320 42540 Scranton-Wilkes-Barre, PA 10 1651 58 2111 152 114 7635 3 776 63 49 2442 60 2498 183 138 8796 2831 555485 149548 0.269220591015059
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
318 318 42220 Santa Rosa-Petaluma, CA 8 821 17 799 56 51 2890 0 1252 50 102 3287 17 1426 82 102 4514 0 499942 134766 0.269563269339243
317 317 42200 Santa Maria-Santa Barbara, CA 5 858 77 1032 38 73 4007 0 752 23 32 1934 77 1408 50 89 4893 0 446527 92919 0.208092679725974
316 316 42140 Santa Fe, NM 1 219 18 451 20 24 1552 0 267 8 15 744 18 585 24 32 1904 0 150056 48487 0.3231260329477
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
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
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
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
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
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
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
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
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
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
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
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
303 303 41140 St. Joseph, MO-KS 1 352 0 669 154 31 3155 0 250 37 9 854 0 794 173 36 3582 176 126490 29366 0.232160645110285
302 302 41100 St. George, UT 1 263 0 684 0 36 2048 0 177 0 13 566 0 772 0 42 2330 0 171700 46937 0.273366336633663
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
286 286 39580 Raleigh-Cary, NC 5 1867 8 4389 74 190 13993 0 2546 24 99 5485 8 5662 87 240 16723 585 1362540 237582 0.174366991060813
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

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