NYPD Officer Profile - Members Of Service
City of New York
@usgov.city_of_new_york_nypd_officer_profile_members_of_service
City of New York
@usgov.city_of_new_york_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
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
);Anyone who has the link will be able to view this.