Skip to content

Instantly share code, notes, and snippets.

@RobFaj

RobFaj/sf_nyc_austin_comp_2019_2022.csv

Created April 2, 2023 05:22
Show Gist options
  • Save RobFaj/1468676b68c7dad76356449a6ad3228c to your computer and use it in GitHub Desktop.
Save RobFaj/1468676b68c7dad76356449a6ad3228c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sf_nyc_austin_comp_2019_2022.csv
industry_code agglvl_code size_code year qtr disclosure_code qtrly_estabs month1_emplvl month2_emplvl month3_emplvl total_qtrly_wages taxable_qtrly_wages qtrly_contributions avg_wkly_wage lq_disclosure_code lq_qtrly_estabs lq_month1_emplvl lq_month2_emplvl lq_month3_emplvl lq_total_qtrly_wages lq_taxable_qtrly_wages lq_qtrly_contributions lq_avg_wkly_wage oty_disclosure_code oty_qtrly_estabs_chg oty_qtrly_estabs_pct_chg oty_month1_emplvl_chg oty_month1_emplvl_pct_chg oty_month2_emplvl_chg oty_month2_emplvl_pct_chg oty_month3_emplvl_chg oty_month3_emplvl_pct_chg oty_total_qtrly_wages_chg oty_total_qtrly_wages_pct_chg oty_taxable_qtrly_wages_chg oty_taxable_qtrly_wages_pct_chg oty_qtrly_contributions_chg oty_qtrly_contributions_pct_chg oty_avg_wkly_wage_chg oty_avg_wkly_wage_pct_chg area_title ownership_title
5415 76 0 2019 4 N 2 0 0 0 0 0 0 0 N 0.68 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2020 1 N 2 0 0 0 0 0 0 0 N 0.65 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2020 2 N 2 0 0 0 0 0 0 0 N 0.66 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2020 3 N 2 0 0 0 0 0 0 0 N 0.67 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2020 4 N 2 0 0 0 0 0 0 0 N 0.68 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2021 1 N 2 0 0 0 0 0 0 0 N 0.68 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2021 2 N 2 0 0 0 0 0 0 0 N 0.69 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2021 3 N 2 0 0 0 0 0 0 0 N 0.69 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2021 4 N 2 0 0 0 0 0 0 0 N 0.68 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2022 3 N 2 0 0 0 0 0 0 0 N 0.69 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2022 2 N 2 0 0 0 0 0 0 0 N 0.7 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2022 1 N 2 0 0 0 0 0 0 0 N 0.68 0.0 0.0 0.0 0.0 0.0 0.0 0.0 N 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 New York County, New York Local Government
5415 76 0 2019 4 3461 60949 60949 60868 2492146203 63303399 1679633 3147 0.95 1.61 1.59 1.6 0.99 1.49 1.25 0.62 131 3.9 1495 2.5 1298 2.2 984 1.6 256974491 11.5 2595019 4.3 -115983 -6.5 265 9.2 New York County, New York Private
5415 76 0 2020 1 3613 62808 63136 63276 3071300095 745320528 18144478 3746 0.98 1.66 1.67 1.7 0.93 1.31 1.15 0.55 225 6.6 3377 5.7 3434 5.8 3114 5.2 155904654 5.3 49178867 7.1 2132184 13.3 -6 -0.2 New York County, New York Private
5415 76 0 2020 2 3583 62237 61651 61169 2541556098 58551712 1634958 3169 0.97 1.77 1.81 1.86 1.19 1.49 1.58 0.66 153 4.5 2216 3.7 1485 2.5 271 0.4 118390613 4.9 -20995650 -26.4 -469320 -22.3 81 2.6 New York County, New York Private
5415 76 0 2020 3 3586 60838 60630 60495 2783075948 53246908 1361313 3530 0.96 1.81 1.81 1.83 1.32 2.14 1.86 0.73 73 2.1 -615 -1.0 -819 -1.3 -391 -0.6 374641157 15.6 -27675916 -34.2 -682996 -33.4 506 16.7 New York County, New York Private
5415 76 0 2020 4 3545 60371 60558 60411 3093007637 52169992 1384509 3936 0.94 1.78 1.78 1.78 1.12 1.85 1.47 0.63 84 2.4 -578 -0.9 -391 -0.6 -457 -0.8 600861434 24.1 -11133407 -17.6 -295124 -17.6 789 25.1 New York County, New York Private
5415 76 0 2021 1 3481 60498 60572 60955 3725587715 729931154 26897981 4723 0.93 1.79 1.78 1.8 1.0 1.4 1.28 0.56 -132 -3.7 -2310 -3.7 -2564 -4.1 -2321 -3.7 654287620 21.3 -15389374 -2.1 8753503 48.2 977 26.1 New York County, New York Private
5415 76 0 2021 2 3477 60683 60922 61828 3228044915 82606890 3244095 4061 0.92 1.77 1.78 1.79 1.31 1.35 1.35 0.74 -106 -3.0 -1554 -2.5 -729 -1.2 659 1.1 686488817 27.0 24055178 41.1 1609137 98.4 892 28.1 New York County, New York Private
5415 76 0 2021 3 3427 62175 62571 62545 3203533373 99056931 3748941 3947 0.89 1.74 1.76 1.76 1.3 1.93 1.65 0.74 -159 -4.4 1337 2.2 1941 3.2 2050 3.4 420457425 15.1 45810023 86.0 2387628 175.4 417 11.8 New York County, New York Private
5415 76 0 2021 4 3429 63503 64027 64452 3268448494 91617595 3603817 3929 0.85 1.72 1.71 1.72 0.99 1.61 1.36 0.58 -116 -3.3 3132 5.2 3469 5.7 4041 6.7 175440857 5.7 39447603 75.6 2219308 160.3 -7 -0.2 New York County, New York Private
5415 76 0 2022 3 3450 68276 68645 67376 3139997717 101105393 2794084 3547 0.82 1.71 1.73 1.73 1.19 1.73 1.53 0.69 23 0.7 6101 9.8 6074 9.7 4831 7.7 -63535656 -2.0 2048462 2.1 -954857 -25.5 -400 -10.1 New York County, New York Private
5415 76 0 2022 2 3381 66269 66376 67319 3101167950 102595635 2996897 3579 0.82 1.73 1.73 1.74 1.19 1.29 1.25 0.69 -96 -2.8 5586 9.2 5454 9.0 5491 8.9 -126876965 -3.9 19988745 24.2 -247198 -7.6 -482 -11.9 New York County, New York Private
5415 76 0 2022 1 3536 64570 65136 65518 3793658686 808166682 22457456 4484 0.86 1.72 1.72 1.73 0.93 1.37 1.28 0.54 55 1.6 4072 6.7 4564 7.5 4563 7.5 68070971 1.8 78235528 10.7 -4440525 -16.5 -239 -5.1 New York County, New York Private
5415 46 0 2019 4 3730 41261 41457 41479 1403402004 35848735 922828 2608 2.08 2.57 2.57 2.58 2.47 2.36 2.97 0.96 261 7.5 1221 3.0 1082 2.7 1044 2.6 15912031 1.1 662697 1.9 55003 6.3 -41 -1.5 Austin-Round Rock, TX MSA Private
5415 46 0 2020 1 3808 40035 40008 39911 1446970733 375798309 8722909 2784 2.1 2.47 2.46 2.48 2.43 2.16 2.55 0.98 236 6.6 974 2.5 714 1.8 661 1.7 65231656 4.7 9568013 2.6 -739430 -7.8 73 2.7 Austin-Round Rock, TX MSA Private
5415 46 0 2020 2 3868 39827 39906 39959 1304574885 34754676 727884 2515 2.09 2.43 2.44 2.48 2.34 1.78 2.5 0.96 281 7.8 98 0.2 171 0.4 144 0.4 17357489 1.3 -6861088 -16.5 -358383 -33.0 25 1.0 Austin-Round Rock, TX MSA Private
5415 46 0 2020 3 3990 41188 41370 41349 1373105777 33161368 702820 2557 2.09 2.52 2.54 2.57 2.35 2.73 3.38 0.93 312 8.5 642 1.6 363 0.9 928 2.3 31266988 2.3 -7187730 -17.8 -391566 -35.8 18 0.7 Austin-Round Rock, TX MSA Private
5415 46 0 2020 4 4154 42330 42526 42991 1694674262 39337423 793322 3059 2.12 2.56 2.56 2.57 2.52 2.77 2.9 0.98 424 11.4 1069 2.6 1069 2.6 1512 3.6 291272258 20.8 3488688 9.7 -129506 -14.0 451 17.3 Austin-Round Rock, TX MSA Private
5415 46 0 2021 1 4303 43813 44426 44723 1841378185 428422301 10776529 3196 2.1 2.59 2.62 2.64 2.6 2.32 2.65 0.99 495 13.0 3778 9.4 4418 11.0 4812 12.1 394407452 27.3 52623992 14.0 2053620 23.5 412 14.8 Austin-Round Rock, TX MSA Private
5415 46 0 2021 2 4476 46033 46384 47721 1907990704 61000160 1520224 3142 2.08 2.65 2.66 2.72 2.76 2.21 2.79 1.03 608 15.7 6206 15.6 6478 16.2 7762 19.4 603415819 46.3 26245484 75.5 792340 108.9 627 24.9 Austin-Round Rock, TX MSA Private
5415 46 0 2021 3 4646 49323 49885 49899 1811531170 64038095 1526713 2804 2.08 2.73 2.76 2.8 2.49 2.93 3.1 0.9 656 16.4 8135 19.8 8515 20.6 8550 20.7 438425393 31.9 30876727 93.1 823893 117.2 247 9.7 Austin-Round Rock, TX MSA Private
5415 46 0 2021 4 4803 51623 52335 52671 2225935086 60948077 1441198 3280 2.07 2.8 2.81 2.82 2.68 2.61 2.64 0.95 649 15.6 9293 22.0 9809 23.1 9680 22.5 531260824 31.3 21610654 54.9 647876 81.7 221 7.2 Austin-Round Rock, TX MSA Private
5415 46 0 2022 3 5104 58876 59392 58600 2332638572 66843880 1556314 3044 2.04 2.92 2.95 2.96 2.8 2.73 3.19 0.95 458 9.9 9553 19.4 9507 19.1 8701 17.4 521107402 28.8 2805785 4.4 29601 1.9 240 8.6 Austin-Round Rock, TX MSA Private
5415 46 0 2022 2 5007 56974 57539 57414 2247800767 78223568 1713039 3017 2.04 2.91 2.94 2.95 2.83 2.38 2.81 0.97 531 11.9 10941 23.8 11155 24.0 9693 20.3 339810063 17.8 17223408 28.2 192815 12.7 -125 -4.0 Austin-Round Rock, TX MSA Private
5415 46 0 2022 1 4919 54229 55132 55193 2292493776 543488400 12855941 3215 2.05 2.85 2.87 2.89 2.81 2.44 2.81 0.98 616 14.3 10416 23.8 10706 24.1 10470 23.4 451115591 24.5 115066099 26.9 2079412 19.3 19 0.6 Austin-Round Rock, TX MSA Private
5415 46 0 2019 4 6410 106596 107040 107251 5066556857 79391536 3283616 3644 1.11 2.89 2.89 2.92 2.57 3.02 2.54 0.89 306 5.0 6211 6.2 5709 5.6 5518 5.4 -58597413 -1.1 1973631 2.5 -93815 -2.8 -254 -6.5 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2020 1 6120 105660 105911 105372 5965935541 795273878 33381901 4344 1.08 2.85 2.85 2.88 2.77 2.2 1.93 0.97 251 4.3 5841 5.9 5011 5.0 4606 4.6 665577999 12.6 30370881 4.0 712870 2.2 287 7.1 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2020 2 6250 104481 104331 104062 5543478875 71960111 2713507 4089 1.09 2.92 2.93 2.98 2.85 2.62 2.59 0.97 293 4.9 2772 2.7 2190 2.1 139 0.1 -589930624 -9.6 -27020110 -27.3 -1443829 -34.7 -510 -11.1 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2020 3 6367 103377 103602 102897 5901133931 62771698 2440626 4395 1.09 2.96 2.96 2.99 2.89 3.41 3.05 0.97 245 4.0 -2851 -2.7 -3034 -2.8 -2654 -2.5 764064728 14.9 -35968858 -36.4 -1660565 -40.5 672 18.0 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2020 4 6606 103621 103373 103550 6544556429 59994934 2373444 4863 1.1 2.95 2.93 2.96 2.66 2.82 2.39 0.9 196 3.1 -2975 -2.8 -3667 -3.4 -3701 -3.5 1477999572 29.2 -19396602 -24.4 -910172 -27.7 1219 33.5 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2021 1 6233 101133 101662 102129 7149764304 761924476 28713252 5411 1.04 2.87 2.85 2.87 2.74 2.18 2.03 0.96 113 1.8 -4527 -4.3 -4249 -4.0 -3243 -3.1 1183828763 19.8 -33349402 -4.2 -4668649 -14.0 1067 24.6 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2021 2 6326 102601 102734 103484 6878348621 90039786 3425711 5140 1.03 2.83 2.83 2.84 2.78 2.36 2.49 0.98 76 1.2 -1880 -1.8 -1597 -1.5 -578 -0.6 1334869746 24.1 18079675 25.1 712204 26.2 1051 25.7 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2021 3 6389 105157 105662 105430 7295628190 93250310 3567515 5324 1.01 2.82 2.81 2.85 2.83 2.87 2.69 1.0 22 0.3 1780 1.7 2060 2.0 2533 2.5 1394494259 23.6 30478612 48.6 1126889 46.2 929 21.1 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2021 4 6533 107893 107398 108715 7653824362 93916546 3529035 5451 0.99 2.82 2.79 2.83 2.7 2.75 2.45 0.96 -73 -1.1 4272 4.1 4025 3.9 5165 5.0 1109267933 16.9 33921612 56.5 1155591 48.7 588 12.1 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2022 3 6410 111268 110976 109098 6314635516 71926371 2360886 4398 0.91 2.75 2.73 2.74 2.58 2.2 2.23 0.94 21 0.3 6111 5.8 5314 5.0 3668 3.5 -980992674 -13.4 -21323939 -22.9 -1206629 -33.8 -926 -17.4 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2022 2 6395 109433 109872 111087 6386643001 97165632 3171886 4461 0.93 2.76 2.76 2.8 2.66 2.24 2.42 0.96 69 1.1 6832 6.7 7138 6.9 7603 7.3 -491705620 -7.1 7125846 7.9 -253825 -7.4 -679 -13.2 San Francisco-Oakland-Hayward, CA MSA Private
5415 46 0 2022 1 6242 107167 107967 108200 6481621316 740162946 24048812 4626 0.95 2.74 2.73 2.75 2.45 1.92 1.93 0.9 9 0.1 6034 6.0 6305 6.2 6071 5.9 -668142988 -9.3 -21761530 -2.9 -4664440 -16.2 -785 -14.5 San Francisco-Oakland-Hayward, CA MSA Private
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment