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.
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
- 427.92 days
- Publisher last updated the data
- Oct 1, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 1, 2026, 10:19 AM
- Rows in our copy
- 3,529,631
- Rows at the source
- 3,529,631
- 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 7 columns carry a concept; 7 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 |
|---|---|---|---|---|---|---|---|---|
dpt | AGENCY CODE | The one (1) to three (3) digit number used to identify a City agency (“DPT”). | Not bound | Number | dpt | numeric | — | |
name | EMPLOYEE NAME | An employee’s first initial, middle initial (where applicable), and last name. | Not bound | Text | name | text | — | |
ttl | TITLE CODE | The title code that corresponds to and represents an employee’s civil service title. | Not bound | Text | ttl | text | — | |
calendar_year | CALENDAR YEAR | The one-year period, that begins on January 1 and ends on December 31, for which data in corresponding columns are current. | Not bound | Text | calendar_year | text | — | |
sal_rate | SALARY RATE | The employee’s regular gross salary rate in dollars and cents. The regular gross salaries listed reflect annual, prorated annual, hourly, or daily rates. | Not bound | Text | sal_rate | text | — | |
pc | PAY CLASS | 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. | Not bound | Text | pc | text | — | |
agency_name | AGENCY NAME | The name of the employing City agency. | Not bound | Text | agency_name | text | — |
Download
This file was produced on Oct 1, 2026, 10:01 PM.
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/ye3c-m4ga
- Version
- Content hash:
23ab5ceeb21a95b694e4962ab9d559e5f77c6ebc5cd0efad043c903c40f5f33d - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 1, 2026, 10:19 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 1, 2026, 4:09 PM | full_replace | success | 3,529,631 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 1, 2026, 3:43 AM | full_replace | success | 3,237,466 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Sep 1, 2026, 1:15 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |