From a 22-row sample across 4 columns.
reported_dtincident_idfacility+1reported_dtincident_idfacility+1reported_dtincident_idfacility+1incident_idfacility| incident_id | reported_dt | incident_type | facility |
|---|---|---|---|
| 64622 | 2015-01-01T17:20:00.000 | Suicide | — |
| 68923 | 2015-06-10T12:28:00.000 | Suicide | — |
| 77047 | 2016-01-29T14:20:00.000 | Suicide | — |
| 77355 | 2016-03-14T22:11:00.000 | Suicide | — |
| 90911 | 2017-04-16T14:06:00.000 | Suicide |
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% | 1093919091177047 |
reported_dt | datetime | This field has the reported date and time of the incident. | 0% | 2022-08-25T17:16:00.0002021-03-19T06:21:00.0002022-09-14T07:18:00.000 |
incident_type | text | This field has the incident description. | 0% | Suicideof 1 |
facility | categorical | — | 23% | AMKCGRVCOBCCof 7 |
GET /api/datasets/f64t-5yiv GET /api/datasets/f64t-5yiv/quality GET /api/datasets/f64t-5yiv/related GET /api/columns?dataset=f64t-5yiv
| — |
| 97125 | 2017-10-08T19:10:00.000 | Suicide | RMSC |
| 109391 | 2018-08-27T09:07:00.000 | Suicide | AMKC |
| 141237 | 2020-10-29T06:00:00.000 | Suicide | AMKC |
| 142321 | 2020-11-22T17:23:00.000 | Suicide | MDC |
| 144934 | 2021-01-22T19:52:00.000 | Suicide | OBCC |