From a 500-row sample across 7 columns.
| index | admit_date | designation_date | discharge_date | designation_days | los_days | discharge_facility |
|---|---|---|---|---|---|---|
| 1 | 2018-10-24T00:00:00.000 | 2019-01-02T00:00:00.000 | 2019-01-04T00:00:00.000 | 2 | 72 | AMKC |
| 2 | 2018-12-09T00:00:00.000 | 2019-01-02T00:00:00.000 | 2019-01-04T00:00:00.000 | 2 | 26 | AMKC |
| 3 | 2018-05-14T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
index | integer | This is the primary key column that uniquely identifies each incident. | 0% | 20413301070 |
admit_date | datetime | The date an individual was admitted into Department of Correction custody | 0% | 2019-07-10T00:00:00.0002019-04-10T00:00:00.0002019-01-09T00:00:00.000 |
designation_date | datetime | The date a court found an individual unfit to stand trial under Section 730 of the Criminal Procedure Law | 0% | 2019-01-08T00:00:00.0002019-02-04T00:00:00.0002019-11-22T00:00:00.000 |
discharge_date | datetime | The date the individual was discharged from DOC | 0% |
GET /api/datasets/q9w2-yi4x GET /api/datasets/q9w2-yi4x/quality GET /api/datasets/q9w2-yi4x/related GET /api/columns?dataset=q9w2-yi4x
| 2019-01-04T00:00:00.000 |
| 2019-01-09T00:00:00.000 |
| 5 |
| 240 |
| AMKC |
| 4 | 2018-03-07T00:00:00.000 | 2019-01-04T00:00:00.000 | 2019-01-22T00:00:00.000 | 18 | 321 | GRVC |
| 5 | 2018-11-01T00:00:00.000 | 2019-01-04T00:00:00.000 | 2019-01-24T00:00:00.000 | 20 | 84 | AMKC |
| 6 | 2018-07-01T00:00:00.000 | 2019-01-04T00:00:00.000 | 2019-01-28T00:00:00.000 | 24 | 211 | MDC |
| 7 | 2018-09-10T00:00:00.000 | 2019-01-07T00:00:00.000 | 2019-01-14T00:00:00.000 | 7 | 126 | GRVC |
| 8 | 2018-11-13T00:00:00.000 | 2019-01-07T00:00:00.000 | 2019-01-29T00:00:00.000 | 22 | 77 | AMKC |
| 9 | 2018-12-24T00:00:00.000 | 2019-01-08T00:00:00.000 | 2019-01-09T00:00:00.000 | 1 | 16 | GRVC |
| 10 | 2018-10-18T00:00:00.000 | 2019-01-08T00:00:00.000 | 2019-01-09T00:00:00.000 | 1 | 83 | GRVC |
2022-04-07T00:00:00.0002022-03-31T00:00:00.0002019-04-01T00:00:00.000 |
designation_days | integer | The number of days an induvial was designated unfit to when they were discharged | 0% | 142 |
los_days | integer | The total length of stay or time in DOC custody in days from admission date to discharge date | 0% | 4950105 |
discharge_facility | categorical | The last facility an individual was housed in before being discharged. | 0% | AMKCBHPWGRVCof 14 |