From a 267-row sample across 5 columns.
incident_typefacilityreason+2incident_typefacilityincident_id+1| incident_id | reported_dt | incident_type | reason |
|---|---|---|---|
| 75250 | 2016-01-06T18:55:00.000 | Use of Force | Assault on Staff |
| 76064 | 2016-01-31T14:10:00.000 | Use of Force | Assault on Staff |
| 76092 | 2016-02-01T09:03:00.000 | Use of Force | Assault on Staff |
| 76567 | 2016-02-17T14:41:00.000 | Use of Force | Assault on Staff |
| 79909 | 2016-06-03T11:16: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% | 225011214374117939 |
reported_dt | datetime | This field has the reported date and time of the incident. | 0% | 2016-01-06T18:55:00.0002020-05-12T12:33:00.0002026-03-24T12:20: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/7hi3-kaps GET /api/datasets/7hi3-kaps/quality GET /api/datasets/7hi3-kaps/related GET /api/columns?dataset=7hi3-kaps
| Use of Force |
| Assault on Staff |
| 80035 | 2016-06-07T12:23:00.000 | Use of Force | Assault on Staff |
| 80256 | 2016-06-13T20:00:00.000 | Use of Force | Assault on Staff |
| 80658 | 2016-06-24T20:02:00.000 | Use of Force | Assault on Staff |
| 81400 | 2016-07-20T07:31:00.000 | Use of Force | Assault on Staff |
| 81558 | 2016-07-24T14:55:00.000 | Use of Force | Assault on Staff |
facility | text | — | 15% | OBCCGRVCAMKC |