Skip to content

Instantly share code, notes, and snippets.

@RobFaj

RobFaj/sanfran_comp_emp_2016-2022.csv

Last active April 2, 2023 05:24
Show Gist options
  • Save RobFaj/f0305d75d7538236af104b32a11c09d0 to your computer and use it in GitHub Desktop.
Save RobFaj/f0305d75d7538236af104b32a11c09d0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sanfran_comp_emp_2016-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 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