Local Law 18 Pay and Demographics Report - Agency Report Table

The Agency Report Table aggregates pay and employment characteristics in accordance with the requirements of Local Law 18 of 2019. The Table is a point-in-time snapshot of employees who were either active or on temporary leave (parental leave, military leave, illness, etc.) as of December 31st of each year the data is available (see Column "Data Year"). In addition, the Table contains snapshot data of active employees in seasonal titles as of June 30th. To protect the privacy of employees, the sign “<5” is used instead of the actual number for groups of less than five (5) employees, in accordance with the Citywide Privacy Protection Policies and Protocols. The Pay and Demographics Report, and the list of agencies included is available on the MODA Open Source Analytics Library: https://modaprojects.cityofnewyork.us/local-law-18/

Each row represents a group of employees with a common agency, EEO-4 Job Category, pay band, employee status and demographic attributes, which include race, ethnicity and gender.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/local-law-18-pay-and-demographics-report-agency-423i-ukqr\".\"local_law_18_pay_and_demographics_report_agency\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.