Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Local Law 18 Pay and Demographics Report - Agency Report Table

423i-ukqrCity Government11 columns
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.
View on NYC Open Data↗

Quality

A91.2 / 100

From a 500-row sample across 11 columns.

completeness100/ 25% weight
consistency86/ 20% weight
accuracy94/ 20% weight
timeliness75/ 15% weight
usability95/ 20% weight

Related datasets

  • Summer Youth Employment Program (SYEP) for NYCHA Residents by Council District - Local Law 1630.33
  • New York City Seasonally Adjusted Employment0.32
  • New York City Employment Forecast0.30
  • NYC Zoning Tax Lot Database0.29
  • 2020 Neighborhood Tabulation Areas (NTAs)0.29
  • 2020 Census Tracts0.28
  • NYC Civil Service Titles0.28
  • Civil List

Sample rows

data_yearagency_nameeeo_4_job_categorypay_bandlower_pay_band_boundupper_pay_band_boundemployee_statusraceethnicitygendernumber_of_employees
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT30000-349993000034999Full-TimeBlack or African AmericanNon-Hispanic or LatinoFemale<5
2018ADMINISTRATION FOR CHILDREN'S SERVICES

Columns

11 queryable · 11 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
data_yearcategoricalThe year corresponding to the data. E.g. 2020 reflects pay and demographic data as of 12/31/2020 for full-time employees and as of 6/30/2020 for employees in seasonal titles.0%202220192021of 5
agency_nametextName of the agency the employee works for. Includes Local Law 18 covered agencies only.0%POLICE DEPARTMENTDEPARTMENT OF EDUCATION …DEPARTMENT OF HEALTH AND…
eeo_4_job_categorycategoricalEEO-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.0%PROFESSIONALSOFFICIALS AND ADMINISTRA…

Query this from your own app

GET /api/datasets/423i-ukqr
GET /api/datasets/423i-ukqr/quality
GET /api/datasets/423i-ukqr/related
GET /api/columns?dataset=423i-ukqr
0.28
joins onagency_name
ADMINISTRATIVE SUPPORT
30000-34999
30000
34999
Full-Time
Native Hawaiian or Pacific Islander
Hispanic or Latino
Female
<5
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT30000-349993000034999Full-TimeUnknown or Choose Not to DiscloseHispanic or LatinoFemale<5
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT30000-349993000034999Full-TimeUnknown or Choose Not to DiscloseUnknown or Choose Not to DiscloseFemale<5
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT30000-349993000034999Full-TimeWhiteNon-Hispanic or LatinoFemale<5
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT30000-349993000034999Full-TimeWhiteNon-Hispanic or LatinoMale<5
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT35000-399993500039999Full-TimeBlack or African AmericanNon-Hispanic or LatinoFemale34
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT35000-399993500039999Full-TimeBlack or African AmericanNon-Hispanic or LatinoMale8
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT35000-399993500039999Full-TimeTwo or More RacesNon-Hispanic or LatinoFemale<5
2018ADMINISTRATION FOR CHILDREN'S SERVICESADMINISTRATIVE SUPPORT35000-399993500039999Full-TimeUnknown or Choose Not to DiscloseHispanic or LatinoFemale<5
PARA-PROFESSIONALS
of 8
pay_bandtextA pay band represents the minimum and maximum pay range of a specified width that an employee’s pay falls in.0%60000-6499950000-5499965000-69999
lower_pay_band_boundintegerThe lower bound of the pay band that employee's pay falls in.0%600005000065000
upper_pay_band_boundintegerThe upper bound of the pay band that an employee's pay falls in.0%649995499969999
employee_statuscategoricalWhether 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.0%Full-TimePart-TimeSeasonalof 3
racecategoricalRace category self-identified by the employee.0%Unknown or Choose Not to…WhiteBlack or African America…of 7
ethnicitycategoricalWhether the employee is Hispanic or Latino, which is self-identified by the employee.0%Non-Hispanic or LatinoHispanic or LatinoUnknown or Choose Not to…of 3
gendercategoricalGender category self-identified by the employee.0%MaleFemaleUnknown or Choose Not to…of 5
number_of_employeestextTotal number of employees in this group.0%<556