About this Dataset

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.
Organization: City of New York
Last updated: 2025-09-07T16:27:12.624390
Tags: charges, discipline, nypd, officer, police, profile, recognition, training

Tables

Table 1

@usgov.city_of_new_york_nypd_officer_profile_members_of_service.table_1

2.38 MB
37,728 rows
9 columns

CREATE TABLE table_1 (
  "profile_id" VARCHAR,
  "name" VARCHAR,
  "rank" VARCHAR,
  "command" VARCHAR,
  "shield" DOUBLE,
  "appointment_date" TIMESTAMP,
  "arrests_total" BIGINT,
  "department_recognitions" BIGINT,
  "export_date" TIMESTAMP
);