Civil List

  • pay
  • payroll
  • salary

Civil List

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.


NameSocrata field nameColumn name in sgr mountData typeDescription
PAY CLASSpcpcTextThe 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.
AGENCY CODEdptdptNumberThe one (1) to three (3) digit number used to identify a City agency (“DPT”).
TITLE CODEttlttlTextThe title code that corresponds to and represents an employee’s civil service title.
EMPLOYEE NAMEnamenameTextAn employee’s first initial, middle initial (where applicable), and last name.
AGENCY NAMEaddressaddressTextThe name of the employing City agency.
SALARY RATEsal_ratesal_rateTextThe employee’s regular gross salary rate in dollars and cents. The regular gross salaries listed reflect annual, prorated annual, hourly, or daily rates.
CALENDAR YEARcalendar_yearcalendar_yearTextThe one-year period, that begins on January 1 and ends on December 31, for which data in corresponding columns are current.

Upstream Metadata