From a 500-row sample across 9 columns.
export_dateprofile_id| profile_id | name | rank | command | shield | appointment_date | arrests_total | department_recognitions | export_date |
|---|---|---|---|---|---|---|---|---|
| 903b73df-0c8f-453b-9105-d46b5c4dee97 | MORANRODRIGUEZ, DIANA | POLICE OFFICER | 043 DOMESTIC VIOLENCE SQUAD | 5756 | 2021-10-12T00:00:00.000 | 100 | 0 | 2026-10-11T00:00:00.000 |
| 4d876bed-9355-49c4-8690-ba73b9f318c0 | DIAZ, NIASHIA C | POLICE OFFICER | 081 PRECINCT | 15305 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
profile_id | text | Primary Key | 0% | 9012c7b7-063a-4195-aba1-…6228f07c-c362-4046-991e-…f2569f52-5fc6-4e2d-91f3-… |
name | text | Officer's name | 0% | ISLAM, MD SSINGH, GURPREETRAHMAN, MD M |
rank | text | Rank of Member of Service as of EXPORT_DATE | 0% | POLICE OFFICERSERGEANTDETECTIVE 3RD GRADE |
command | text | Command where Member of Service is assigned as of EXPORT_DATE | 0% | RTS RECRUITS |
GET /api/datasets/pmsy-ewrc GET /api/datasets/pmsy-ewrc/quality GET /api/datasets/pmsy-ewrc/related GET /api/columns?dataset=pmsy-ewrc
| 2018-07-02T00:00:00.000 |
| 118 |
| 48 |
| 2026-10-11T00:00:00.000 |
| b236f479-03d0-4dee-bb5b-5e4262df6dde | COSME, JAYLISE | SERGEANT | 023 PRECINCT | 1337 | 2017-07-05T00:00:00.000 | 134 | 1 | 2026-10-11T00:00:00.000 |
| 5f5973a5-62c8-4ef3-ac4d-a186a4b6f8b7 | BRAVOCHACHA, BRIGET N | POLICE OFFICER | 041 PCT FIELD TRAINING UNIT | 6589 | 2025-12-17T00:00:00.000 | 6 | 0 | 2026-10-11T00:00:00.000 |
| 0816e64b-c959-4bdc-9711-ac1b8e3dba56 | VENTURA, MELVIN J | DETECTIVE SPECIALIST | 042 DOMESTIC VIOLENCE SQUAD | 7886 | 2014-07-09T00:00:00.000 | 363 | 1 | 2026-10-11T00:00:00.000 |
| a7fda3a6-a748-4e61-baf5-88279a21bc8d | ISLAM, SYED S | POLICE OFFICER | 115 PCT ROOSEVELT AVE TF | 16574 | 2005-07-11T00:00:00.000 | 145 | 0 | 2026-10-11T00:00:00.000 |
| 31119d4c-a385-4bcf-8058-af1cdd7d8e7c | FINELLI, MARK | LIEUTENANT | 109TH DET SQUAD | — | 2012-07-11T00:00:00.000 | 115 | 19 | 2026-10-11T00:00:00.000 |
| 0bdd5f6a-b3f3-4d23-94bb-27bc857e8f61 | COLLADO, DANIEL K | SERGEANT | EXTENDED LEAVE SERVICES GROUP | 4043 | 2017-07-05T00:00:00.000 | 88 | 6 | 2026-10-11T00:00:00.000 |
| 66617c50-ff66-46b5-a3f9-069c63cd4e6d | CONTRERAS, DAISY J | POLICE OFFICER | 108 PRECINCT | 21182 | 2019-07-01T00:00:00.000 | 62 | 1 | 2026-10-11T00:00:00.000 |
| f20d7ed8-6237-4864-81ff-25d9b8a28f24 | MASCIA, NICHOLAS A | POLICE OFFICER | 115 PRECINCT | 28664 | 2023-07-05T00:00:00.000 | 25 | 0 | 2026-10-11T00:00:00.000 |
EXTENDED LEAVE SERVICES …INTEL CIS FIO PROGRAMshield | text | Shield/Badge number of Member of Service | 9% | 356343854832 |
appointment_date | datetime | Date Member of Service started their employment at the NYPD | 0% | 2011-07-06T00:00:00.0002025-12-17T00:00:00.0002026-04-22T00:00:00.000 |
arrests_total | integer | Count of arrests enforced by Member of Service | 0% | 0314 |
department_recognitions | integer | Count of Department Recognitions given to Member of Service | 0% | 012 |
export_date | datetime | Date data was exported/updated | 0% | 2026-10-04T00:00:00.000of 1 |