From a 500-row sample across 5 columns.
incident_typeincident_idfacility+2incident_typeincident_idfacility+1incident_idfacilityincident_typeincident_idfacility+1| incident_id | reported_dt | incident_type | reason |
|---|---|---|---|
| 75250 | 2016-01-06T18:55:00.000 | Use of Force | Assault on Staff |
| 75326 | 2016-01-08T11:09:00.000 | Use of Force | Assault on Staff |
| 75523 | 2016-01-14T08:45:00.000 | Use of Force | Assault on Staff |
| 75545 | 2016-01-15T13:08:00.000 | Use of Force | Assault on Staff |
| 75861 | 2016-01-25T13:53:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
incident_id | text | This is the primary key column that uniquely identifies each incident record. | 0% | 100029100041100062 |
reported_dt | datetime | This field has the reported date and time of the incident. | 0% | 2021-10-06T12:20:00.0002025-07-16T19:34:00.0002018-10-18T19:34:00.000 |
incident_type | text | This field has the incident description. | 0% | Use of Forceof 1 |
reason | text | This field has the reason for the Use Of Force. In this case it is the Assault on staff. | 0% | Assault on Staff |
GET /api/datasets/erra-pzy8 GET /api/datasets/erra-pzy8/quality GET /api/datasets/erra-pzy8/related GET /api/columns?dataset=erra-pzy8
| Use of Force |
| Assault on Staff |
| 75939 | 2016-01-27T14:06:00.000 | Use of Force | Assault on Staff |
| 76064 | 2016-01-31T14:10:00.000 | Use of Force | Assault on Staff |
| 76077 | 2016-01-31T21:17:00.000 | Use of Force | Assault on Staff |
| 76079 | 2016-01-31T19:14:00.000 | Use of Force | Assault on Staff |
| 76092 | 2016-02-01T09:03:00.000 | Use of Force | Assault on Staff |
facility | text | — | 14% | GRVCAMKCOBCC |