Employer Compliance with Local Law 32 Since Enactment

Local Law 32 made it an unlawful discriminatory practice to exclude the minimum and maximum pay from job postings for any position located within New York City. The range for the listed maximum and minimum pay would extend from the lowest pay to the highest pay that the employer in good faith believes it would pay for the advertised job, promotion, or transfer. Temporary staffing firms are exempt from this legislation, as they already provide this information after interviews in compliance with the NY State Wage Theft Prevention Act.

To better understand the state of pay transparency in New York City following the bill's enactment, The Data Team analyzed job listings from Indeed and Google for Jobs. To learn more about the project, including the methodology, findings, and recommendations, please view webpage.

---

Scripts

Indeed

To re-rerun the analysis, locate the following folders in /code/indeed:

• 00_load_dependencies.R loads in all the libraries needed to run the analysis.
• 01_analysis.R performs various analyses on the cleaned dataset.

Google for Jobs

To re-rerun the analysis, locate the following folders in /code/google_for_jobs:

• clean_google_job_functions.py contains functions that clean the raw Google for Jobs data.
• 001_clean-google-jobs.ipynb runs the cleaning code in clean_google_job_functions.py to prepare the raw Google for Jobs data for analysis. This notebook generates google-jobs-data-cleaned.csv.
• 002_analyze-google-jobs.ipynb performs various analyses on the cleaned dataset. It also generates CSVs that are used to make visuals for the webpage (salary_not_found.csv, salary_not_scraped.csv, example_table.csv, and bad_salary_ratios.csv).
• pay_transparency_visuals.Rmd generates visuals for the Data Team's webpage, including salary_not_scraped.html, salary_spreads.html, and example_table.html.

The CSV files mentioned above can be found in /data/output/, with the exception of google-jobs-cronjob.csv, google-jobs-extra-cols-cronjob.csv, and google-jobs-data-cleaned.csv, which are too large to fit on GitHub. However, google-jobs-data-cleaned.csv can be generated using 001_clean-google-jobs.ipynb. To gain access to google-jobs-cronjob.csv and google-jobs-extra-cols-cronjob.csv without running your own cronjob, please reach out to the Data Team.

The visuals created in pay_transparency_visuals.Rmd can be found in /visuals/.