Civil List

Source Metadata

name Civil List
description 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.
attribution Department of Citywide Administrative Services (DCAS)
id ye3c-m4ga
assetType dataset
category City Government
createdAt 2015-07-01 18:39:33
provenance official
rowsUpdatedAt 2025-07-30 16:19:12
Columns
Name Data Type Description Field Name
CALENDAR YEAR text The one-year period, that begins on January 1 and ends on December 31, for which data in corresponding columns are current. calendar_year
AGENCY CODE number The one (1) to three (3) digit number used to identify a City agency (“DPT”). dpt
EMPLOYEE NAME text An employee’s first initial, middle initial (where applicable), and last name. name
AGENCY NAME text The name of the employing City agency. agency_name
TITLE CODE text The title code that corresponds to and represents an employee’s civil service title. ttl
PAY CLASS text The 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. pc
SALARY RATE text The employee’s regular gross salary rate in dollars and cents. The regular gross salaries listed reflect annual, prorated annual, hourly, or daily rates. sal_rate

Databook Transformation

Normalized Fields AGENCY NAME, TITLE CODE
Next Update Scheduled
Activity
Source Data Last Updated 2025-07-30 16:19:12
Transformed Data Last Updated 06/07/2025 07:22
Columns Added Calculating...
Added Column Names Calculating...

Data Previews

Loading data...

Loading data...