NYPD Officer Profile - Department Recognition
Table containing information related to the Uniformed Member of Service’s Departmental awards and recognitions. This information includes the type of award and the date the award was bestowed.
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:28 AM
- Rows in our copy
- 142,734
- Rows at the source
- 142,561
- Our copy trails the source by
- 18 days
Columns
Each source column, with the name and type we use to store it.
0 of 4 columns carry a concept; 4 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 |
|---|---|---|---|---|---|---|---|---|
profile_id | PROFILE_ID | Foreign Key to join to MOS table | Not bound | Text | profile_id | text | — | |
award | AWARD | Type of award/recognition | Not bound | Text | award | text | — | |
export_date | EXPORT_DATE | Date data was exported/updated | Not bound | Calendar date | export_date | timestamp | — | |
date | DATE | Date award/recognition granted | Not bound | Calendar date | 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/i9n8-a8ed
- Version
- Content hash:
9b1d7eb8203878eb4c34757ee596f6151c0e1fd6c29bb42702a372c4c9317534 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Sep 17, 2026, 11:28 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 10, 2026, 11:30 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 8, 2026, 7:30 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 6, 2026, 11:16 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 6, 2026, 7:00 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 11:00 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 5, 2026, 6:45 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:24 PM | full_replace | success | 142,734 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.81 |
| Aug 31, 2026, 3:36 PM | full_replace | success | 142,583 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |