Skip to content

Instantly share code, notes, and snippets.

@RobFaj

RobFaj/nyc_comp_emp_2016-2022.csv

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