NYPD Officer Profile - Department Recognition

i9n8-a8edPublic Safety4 columns

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.

View on NYC Open Data

Quality

A94.0 / 100

From a 500-row sample across 4 columns.

completeness100/ 25% weight

consistency75/ 20% weight

accuracy100/ 20% weight

timeliness100/ 15% weight

usability95/ 20% weight

Related datasets

NYPD Officer Profile - Training0.69
joins onexport_datedateprofile_id
NYPD Officer Profile - Disciplinary History Summary0.66
joins onexport_datedateprofile_id
NYPD Officer Profile - Title Shield History0.56
joins onexport_dateprofile_id
NYPD Officer Profile - Disciplinary History Charges0.55
joins onexport_datedateprofile_id
NYPD Officer Profile - Members of Service0.39

Sample rows

profile_id	date	award	export_date
9c4ab19d-0615-460a-89d3-231cfaaa3b0c	2020-08-06T00:00:00.000	MERITORIOUS POLICE DUTY	2026-10-11T00:00:00.000
c7789464-c23a-4719-9a5d-6615541e95b4	2009-09-30T00:00:00.000	EXCELLENT POLICE DUTY	2026-10-11T00:00:00.000
a1d033ba-ea94-43b6-b0bb-28fce657a617	2018-10-05T00:00:00.000	MERITORIOUS POLICE DUTY	2026-10-11T00:00:00.000
9bdf0ca1-68ea-47e4-b671-e9ec108e19cf	2022-11-17T00:00:00.000	EXCELLENT POLICE DUTY	2026-10-11T00:00:00.000

Columns

4 queryable · 4 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`profile_id`	text	Foreign Key to join to MOS table	0%	`014f2e04-5e91-4da4-b7f9-…e37de8ba-9e35-4e43-a7c1-…3fe9145d-0567-49b9-ae23-…`
`date`	datetime	Date award/recognition granted	0%	`2025-07-28T00:00:00.0002023-01-01T00:00:00.0002020-01-01T00:00:00.000`
`award`	categorical	Type of award/recognition	0%	`EXCELLENT POLICE DUTYMERITORIOUS POLICE DUTYCOMMENDATION`of 14
`export_date`	datetime	Date data was exported/updated	0%

Query this from your own app

GET /api/datasets/i9n8-a8ed
GET /api/datasets/i9n8-a8ed/quality
GET /api/datasets/i9n8-a8ed/related
GET /api/columns?dataset=i9n8-a8ed