From a 500-row sample across 8 columns.
tri_incident_numberforcetypetri_incident_numberracerace| tri_incident_number | forcetype | injurylevel | member_injured | rank_grouped | assignment | member_gender | race |
|---|---|---|---|---|---|---|---|
| 2022062962121 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 2023020962075 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
tri_incident_number | text | Internal identifier for each report number | 0% | 202509496235620250449621312022139962240 |
forcetype | categorical | Type of force employed by member of service; "Electrical Weapon, Firearm, Impact Weapon. OC Spray, Physical Force" Please refer to data dictionary for detail. | 0% | Physical ForceElectrical WeaponOC Sprayof 7 |
injurylevel | categorical | Level of Injury sustained by the NYPD member of Service. Please refer to data dictionary for detail. | 0% | No InjuryPhysical InjurySubstantial Physical Inj…of 4 |
member_injured | categorical | Flag (Y/N) whether member of service was injured |
GET /api/datasets/v5jd-6wqn GET /api/datasets/v5jd-6wqn/quality GET /api/datasets/v5jd-6wqn/related GET /api/columns?dataset=v5jd-6wqn
race| 2023020962083 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 2023020962134 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 2023020962135 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 2023020962140 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 2023020962149 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 2023020962155 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 2023020962155 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 2023020962177 | Physical Force | No Injury | N | Police Officer | SECTOR/RESPONSE AUTO | MALE | HISPANIC |
| 0% |
NYof 2 |
rank_grouped | categorical | Rank/title of the member of service involved in the incident | 0% | Police OfficerSergeantDetectiveof 10 |
assignment | categorical | Duties member of Service was performing at the time of the incident. Please refer to data dictionary for detail | 0% | SECTOR/RESPONSE AUTOOTHERFIXED POSTof 8 |
member_gender | categorical | Gender of the member of service. Blank values occur if the member of the service completing the report leaves the “Gender” section empty; often the result of a complaint made by a member of the public in which an officer’s identity is unknown. | 0% | MALEFEMALEof 2 |
race | categorical | Race of the member of service | 0% | WHITEHISPANICBLACKof 6 |