NYPD Officer Profile - Members of Service
This is the main table of the Officer Profile dataset. It contains the current list of active uniform members of service (UMOS). Each row in the table is an individual UMOS. As this data is a snapshot of current uniformed members, UMOS that retire, resign or are terminated are no longer included. UMOS may be designated a civilian title, e.g. Deputy Commissioner, but still retain the UMOPS status. The term rank is application to uniform MOS and the term title is reserved for civilians.
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
- Weekly
- Actually updates about every
- 7.02 days
- Publisher last updated the data
- Oct 5, 2026
Our mirror
Whether our copy of this data is current with the source.
Sync error
- We last synced
- Sep 17, 2026, 11:27 AM
- Rows in our copy
- 34,105
- Rows at the source
- 33,954
- Our copy trails the source by
- 18 days
Columns
Each source column, with the name and type we use to store it.
0 of 9 columns carry a concept; 9 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 |
|---|---|---|---|---|---|---|---|---|
department_recognitions | DEPARTMENT_RECOGNITIONS | Count of Department Recognitions given to Member of Service | Not bound | Number | department_recognitions | numeric | — | |
arrests_total | ARRESTS_TOTAL | Count of arrests enforced by Member of Service | Not bound | Number | arrests_total | numeric | — | |
command | COMMAND | Command where Member of Service is assigned as of EXPORT_DATE | Not bound | Text | command | text | — | |
profile_id | PROFILE_ID | Primary Key | Not bound | Text | profile_id | text | — | |
rank | RANK | Rank of Member of Service as of EXPORT_DATE | Not bound | Text | rank | text | — | |
shield | SHIELD | Shield/Badge number of Member of Service | Not bound | Text | shield | text | — | |
appointment_date | APPOINTMENT_DATE | Date Member of Service started their employment at the NYPD | Not bound | Calendar date | appointment_date | timestamp | — | |
Download
This file was produced on Sep 17, 2026, 10:02 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/pmsy-ewrc
- Version
- Content hash:
a18295ecbd3add16c98a254c12630273aee8d19f81f14a60d29417d4fb2d463d - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Sep 17, 2026, 11:27 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 11, 2026, 12:30 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 8, 2026, 8:30 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 7, 2026, 12:15 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 6, 2026, 8:00 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 11:35 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 7:30 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 4:45 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 3:31 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 17, 2026, 3:30 PM | full_replace | success | 34,105 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.81 |
| Aug 31, 2026, 3:36 PM | full_replace | success | 34,210 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |