From a 500-row sample across 7 columns.
tri_incident_numbertri_incident_numberage| tri_incident_number | subject_injury_level | subject_injured | subject_race | subject_gender | force_against_mos | subject_used_force |
|---|---|---|---|---|---|---|
| 2020020962067 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 2020020962143 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 2020024962080 | No Injury |
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% | 202509496235620220719620152025129962130 |
subject_injury_level | categorical | Level of injury suffered by the subject as a result of the incident. "Death, No Injury, Physical Injury, Serious Physical Injury, Substantial Physical Injury" Please refer to data dictionary for injury level detail. | 0% | No InjuryPhysical InjurySubstantial Physical Inj…of 5 |
subject_injured | categorical | Flag (Y/N) whether the subject was injured. | 0% | NYof 2 |
age | integer | Age of the subject involved in the incident. Age ranges or blank values occurs when the “Civilian/Subject Info” “Age Type” field on the TRI report is set to “Range” instead of “Exact” or when a civilian or subject refuses to identify themselves/give date of birth this option is used. |
GET /api/datasets/dufe-vxb7 GET /api/datasets/dufe-vxb7/quality GET /api/datasets/dufe-vxb7/related GET /api/columns?dataset=dufe-vxb7
| N |
| BLACK |
| MALE |
| Physical Force |
| Y |
| 2020025962038 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 2020025962049 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 2020025962140 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 2020026962081 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 2020032962033 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 2020032962062 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 2020032962112 | No Injury | N | BLACK | MALE | Physical Force | Y |
| 4% |
302729 |
subject_race | categorical | Race of the subject involved in the incident. Please refer to data dictionary for details on subject race. | 0% | BLACKHISPANICWHITEof 6 |
subject_gender | categorical | Gender of the subject involved in the incident | 0% | MALEFEMALEUNKof 3 |
force_against_mos | categorical | Type of force used by subject against the member of service; "Cutting Instrument, Displayed Weapon, Impact Weapon, No Force Physical Force " Please refer to data dictionary for force type detail. | 0% | Physical ForceNo ForceImpact Weaponof 6 |
subject_used_force | categorical | Flag (Y/N) whether the subject used force. "Y=Yes N=No" | 0% | YNof 2 |