NYPD Officer Profile - Title Shield History
Table containing information related to the Uniformed Member of Service’s rank/title. This information includes rank/title and the date rank/title became effective as well as shield numbers where appropriate. 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
- 53,620
- Rows at the source
- 53,556
- Our copy trails the source by
- 18 days
Columns
Each source column, with the name and type we use to store it.
0 of 5 columns carry a concept; 5 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 |
|---|---|---|---|---|---|---|---|---|
title | TITLE | Current title/rank of Member of Service | Not bound | Text | title | text | — | |
effective_date | EFFECTIVE_DATE | Date Member of Service was appointed to their current TITLE | Not bound | Calendar date | effective_date | timestamp | — | |
shield_no | SHIELD_NO | Shield/Badge number of Member of Service | Not bound | Text | shield_no | text | — | |
profile_id | PROFILE_ID | Foreign Key to join to MOS table | Not bound | Text | profile_id | text | — | |
export_date | EXPORT_DATE | Date data was exported/updated | Not bound | Calendar date | export_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/sh6y-4tgb
- Version
- Content hash:
e2da79a1959b6856b9498293f84d0d96296ea58b8bd83a8725b473d3d68f2e86 - 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:15 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 6, 2026, 12:00 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 7:45 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 5:00 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 3:57 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 | 53,620 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.81 |
| Aug 31, 2026, 3:37 PM | full_replace | success | 53,216 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |