Skip to content

Instantly share code, notes, and snippets.

@RobFaj

RobFaj/austin_comp_emp_2016-2022.csv

Last active April 2, 2023 05:24
Show Gist options
  • Save RobFaj/3acc0f3dfe86e733f8ee8d34dad27037 to your computer and use it in GitHub Desktop.
Save RobFaj/3acc0f3dfe86e733f8ee8d34dad27037 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
austin_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 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment