NYPD Personnel Demographics
List of NYPD members of service
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
- Quarterly
- Actually updates about every
- —
- Publisher last updated the data
- Jul 27, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Jul 27, 2026, 11:20 AM
- Rows in our copy
- 49,987
- Rows at the source
- 49,987
- 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 8 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 |
|---|---|---|---|---|---|---|---|---|
mos_type | MOS_Type | Field categorizing members as either Civilian or Uniform | Not bound | Text | mos_type | text | — | |
gender | Gender | Field indicating member of service's gender | Not bound | Text | gender | text | — | |
ranklit | ranklit | Field indicating member of service's rank or title | Not bound | Text | ranklit | text | — | |
appdate | appdate | Field containing the date the member was appointed | Not bound | Calendar date | appdate | timestamp | — | |
race | Race | Field indicating member of service's race | Not bound | Text | race | text | — | |
yearsonjob_bins | YearsOnJob (bins) | Field used for charting purposes. Groups Years on Job into 5 year bins/groups | Not bound | Number | yearsonjob_bins | numeric | — | |
sex | sex | The publisher describes this column nowhere. | Not bound | Text | sex | text | — | |
yearsonjob | YearsOnJob | Calculate field determine the number of years the member has in service | Not bound | Number | yearsonjob | numeric | — |
Download
This file was produced on Aug 20, 2026, 9:14 AM.
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/5vr7-5fki
- Version
- Content hash:
82edc64769e2cf162861a3057b944a21c3c80178af364faa1b6e3b7793545786 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Jul 27, 2026, 11:20 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 5, 2026, 3:34 AM | full_replace | success | 49,987 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.45 |