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.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- Annually
- Actually updates about every
- —
- Publisher last updated the data
- Jan 6, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Jan 6, 2026, 3:41 PM
- Rows in our copy
- 96,168
- Rows at the source
- 96,168
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 11 columns carry a concept; 11 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
agency_name | Agency Name | Name of the agency the employee works for. Includes Local Law 18 covered agencies only. | Not bound | Text | agency_name | text | — | |
employee_status | Employee Status | Whether an employee is a full-time, part-time, or seasonal. Full-time employees work a standard work week in a full-time title with a regular annual work schedule whereas part-time employees work fewer than 35 hours per week or are in titles having no standard hours per week or days per year. Seasonal employees such as lifeguards and many parks workers may work in either a part-time or full-time capacity. | Not bound | Text | employee_status | text | — | |
pay_band | Pay Band | A pay band represents the minimum and maximum pay range of a specified width that an employee’s pay falls in. | Not bound | Text | pay_band | text | — | |
eeo_4_job_category | Equal Employment Opportunity (EEO)-4 Job Category | EEO-4 Job Category is used by the U.S. Equal Employment Opportunity Commission (EEOC) to classify a group of employees with comparable job responsibilities at comparable levels within an organization. DCAS classifies and maps each civil service title to one of the eight EEO-4 Job Categories as part of its legal mandate to submit EEO-4 reports every two years. | Not bound | Text | eeo_4_job_category | text | — | |
Download
This file was produced on Aug 20, 2026, 9:10 AM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/423i-ukqr
- Version
- Content hash:
aba8c2a4897980099216d8dd14d1df3a0a5b28159c989a3409fe7b634d9dcfb8 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Jan 6, 2026, 3:41 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 3, 2026, 3:00 AM | full_replace | success | 96,168 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.31 |