From a 500-row sample across 7 columns.
forcetypetri_incident_numbertri_incident_number| tri_incident_number | forcetype | occurrence_date | incident_pct | patrol_borough | yearmonthshort | basisforencounter |
|---|---|---|---|---|---|---|
| 2024033962356 | Physical Force | 2024-08-31T00:00:00.000 | 14 | PBMS | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
| 2024090962120 | Physical Force | 2024-08-31T00:00:00.000 | 71 | PBBS | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
| 2024032962162 |
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% | 202212296207220250989622592025123962021 |
forcetype | categorical | Category of Type of force: Electrical Weapon; Firearm Impact; Weapon OC Spray; Physical Force | 0% | Physical ForceElectrical WeaponOC Sprayof 7 |
occurrence_date | datetime | Date incident occurred | 0% | 2020-06-01T00:00:00.0002026-06-14T00:00:00.0002024-07-04T00:00:00.000 |
incident_pct | integer | NYPD Precinct in which incident occurred | 0% |
GET /api/datasets/f4tj-796d GET /api/datasets/f4tj-796d/quality GET /api/datasets/f4tj-796d/related GET /api/columns?dataset=f4tj-796d
| Physical Force |
| 2024-08-31T00:00:00.000 |
| 13 |
| PBMS |
| 2024 Aug |
| CRIME/VIOLATION IN PROGRESS |
| 2024059962370 | Physical Force | 2024-08-31T00:00:00.000 | 40 | PBBX | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
| 2024096962122 | Physical Force | 2024-08-31T00:00:00.000 | 77 | PBBN | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
| 2024081962083 | Physical Force | 2024-08-31T00:00:00.000 | 62 | PBBS | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
| 2024080962100 | Physical Force | 2024-08-30T00:00:00.000 | 61 | PBBS | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
| 2024025962124 | Physical Force | 2024-08-30T00:00:00.000 | 6 | PBMS | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
| 2024092962284 | Physical Force | 2024-08-30T00:00:00.000 | 73 | PBBN | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
| 2024053962139 | Physical Force | 2024-08-30T00:00:00.000 | 34 | PBMN | 2024 Aug | CRIME/VIOLATION IN PROGRESS |
467540 |
patrol_borough | categorical | NYPD Patrol Borough in which incident occurred. Please refer to data dictionary for details. | 0% | PBBXPBBNPBMSof 8 |
yearmonthshort | text | Year and Month of incident for charting | 0% | 2025 May2024 Jun2025 Jul |
basisforencounter | categorical | Circumstances leading up to the incident | 0% | CRIME/VIOLATION IN PROGR…PERSON IN CRISISPRISONERof 19 |