NYPD Officer Profile - Title Shield History

sh6y-4tgbPublic Safety5 columns

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.

View on NYC Open Data

Quality

A92.6 / 100

From a 500-row sample across 5 columns.

completeness98/ 25% weight

consistency70/ 20% weight

accuracy100/ 20% weight

timeliness100/ 15% weight

usability95/ 20% weight

Related datasets

NYPD Officer Profile - Department Recognition0.56
joins onexport_dateprofile_id
NYPD Officer Profile - Training0.54
joins onexport_dateprofile_id
NYPD Officer Profile - Disciplinary History Summary0.53
joins onexport_dateprofile_id
NYPD Officer Profile - Disciplinary History Charges0.51
joins onexport_dateprofile_id
NYPD Officer Profile - Members of Service0.45
joins on

Sample rows

profile_id	effective_date	title	shield_no	export_date
0001bbf0-8c91-42e8-9d98-e2eb0d03a07b	2026-04-22T00:00:00.000	POLICE OFFICER	12775	2026-10-11T00:00:00.000
0002c2da-7218-40ea-909f-aaec7ac45f1e	2019-01-03T00:00:00.000	POLICE OFFICER	24326	2026-10-11T00:00:00.000
00055a72-67ed-411e-8c54-595e6dd47a14	2015-06-18T00:00:00.000	POLICE OFFICER	30738	2026-10-11T00:00:00.000
00055a72-67ed-411e-8c54-595e6dd47a14

Columns

5 queryable · 5 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%	`b32a8214-2119-428f-b623-…8266a1fb-51a3-417a-b8d8-…ce094f83-e661-44bd-a0dd-…`
`effective_date`	datetime	Date Member of Service was appointed to their current TITLE	0%	`2011-07-06T00:00:00.0002025-12-17T00:00:00.0002026-04-22T00:00:00.000`
`title`	text	Current title/rank of Member of Service	0%	`POLICE OFFICERSERGEANTDETECTIVE`
`shield_no`	text	Shield/Badge number of Member of Service	9%

Query this from your own app

GET /api/datasets/sh6y-4tgb
GET /api/datasets/sh6y-4tgb/quality
GET /api/datasets/sh6y-4tgb/related
GET /api/columns?dataset=sh6y-4tgb