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

Civil List

ye3c-m4gaCity Government7 columns
The Civil List reports the agency code (DPT), first initial and last name (NAME), agency name (ADDRESS), title code (TTL #), pay class (PC), and salary (SAL-RATE) of individuals who were employed by the City of New York at any given time during the indicated year.
View on NYC Open Data↗

Quality

A93.7 / 100

From a 500-row sample across 7 columns.

completeness100/ 25% weight
consistency79/ 20% weight
accuracy95/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Civil Service List Certification0.38
  • Greenbook0.36
    joins onagency_name
  • Civil Service List (Active)0.35
  • NYC Civil Service Titles0.34
  • DSNY Monthly Tonnage Data0.33
  • Annual Examination Schedule of Each Fiscal Year0.33
  • City Record Online0.32
    joins onagency_name

Sample rows

calendar_yeardptagency_namenamettlpcsal_rate
2025998N.Y.C. TRANSIT AUTHORITYS J A0081704$90,940.00
2025846DEPARTMENT OF PARKS & RECRK A GARD71210U$29.08
202556POLICE DEPARTMENTJ K A'GARD70210

Columns

7 queryable · 7 profiled

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

FieldTypeDescriptionNullValues
calendar_yearcategoricalThe one-year period, that begins on January 1 and ends on December 31, for which data in corresponding columns are current.0%201920182017of 12
dptintegerThe one (1) to three (3) digit number used to identify a City agency (“DPT”).0%5699857
agency_nametextThe name of the employing City agency.0%POLICE DEPARTMENTN.Y.C. TRANSIT AUTHORITYFIRE DEPARTMENT
nametextAn employee’s first initial, middle initial (where applicable), and last name.0%

Query this from your own app

GET /api/datasets/ye3c-m4ga
GET /api/datasets/ye3c-m4ga/quality
GET /api/datasets/ye3c-m4ga/related
GET /api/columns?dataset=ye3c-m4ga
  • Jobs NYC Postings0.31
    • D
    $55,942.00
    2025846DEPARTMENT OF PARKS & RECRJ K A'GARD71205U$22.72
    2025466CUNY MANHATTAN COMMUNITY CE K A'HEARN04687N$58.92
    2025996N.Y.C. HOUSING AUTHORITYL S AADAMS90645A$52,086.00
    202557FIRE DEPARTMENTY AALA53053A$39,386.00
    2025464CUNY QUEENSBOROUGH COMMUNIA AALAI04024B$118,070.00
    2025841DEPARTMENT OF TRANSPORTATIN B AAMER20310A$82,381.00
    2025740DEPARTMENT OF EDUCATIONA AAMIR54503G$41,248.00
    J RODRIGUEZ
    A RODRIGUEZ
    J RIVERA
    ttltextThe title code that corresponds to and represents an employee’s civil service title.0%702101270270310
    pctextThe one (1) to two (2) digit pay class code that identifies how an employee is paid. The pay classes for N.Y.C. Transit Authority range from 0 – 07; all other agencies have pay classes with a one (1) to two (2) digit pay class code that ranges from A – X.0%ADX
    sal_ratetextThe employee’s regular gross salary rate in dollars and cents. The regular gross salaries listed reflect annual, prorated annual, hourly, or daily rates.0%$85,292.00$15.00$109,352.00