From a 500-row sample across 7 columns.
racegenderdischarged_dt+4racegenderdischarged_dt+4racegender| inmateid | admitted_dt | discharged_dt | race | gender | inmate_status_code | top_charge |
|---|---|---|---|---|---|---|
| 10008773 | 2018-08-23T10:15:28.000 | 2018-08-23T11:14:00.000 | UNKNOWN | M | DE | VTL 1192.3 |
| 20037818 | 2018-08-05T19:13:46.000 | 2018-08-10T16:46:05.000 | UNKNOWN | M | DE | — |
| 20197484 | 2018-08-14T02:08:36.000 | — |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
inmateid | integer | This is the primary key column that uniquely identifies each inmate record. | 0% | 200642612011782420043269 |
admitted_dt | datetime | This field has the inmate admitted date and time. | 0% | 2016-05-22T12:32:00.0002015-10-12T01:07:00.0002014-10-04T19:43:00.000 |
discharged_dt | datetime | This field has the inmate discharged date and time. | 28% | 2019-02-19T16:00:00.0002017-06-02T20:45:00.0002026-06-17T18:45:00.000 |
race | categorical | Race of the inmate. | 0% |
GET /api/datasets/6teu-xtgp GET /api/datasets/6teu-xtgp/quality GET /api/datasets/6teu-xtgp/related GET /api/columns?dataset=6teu-xtgp
| BLACK |
| F |
| DE |
| 120.05 |
| 20150289 | 2018-08-02T00:05:22.000 | — | UNKNOWN | M | DPV | — |
| 20122449 | 2018-08-23T18:34:24.000 | — | UNKNOWN | M | DE | 120.05 |
| 20197446 | 2018-08-12T20:18:01.000 | 2018-08-13T21:07:02.000 | UNKNOWN | M | DE | — |
| 20169029 | 2018-08-06T13:31:22.000 | 2018-08-20T00:36:02.000 | BLACK | F | DE | — |
| 20197430 | 2018-08-11T19:51:44.000 | 2018-08-28T17:26:02.000 | BLACK | F | DE | — |
| 20031992 | 2018-08-23T23:14:40.000 | — | BLACK | M | DE | 120.13 |
| 20126037 | 2018-08-13T20:34:10.000 | 2018-08-13T22:37:00.000 | UNKNOWN | M | DE | — |
BLACKUNKNOWNASIANof 3gender | categorical | Gender of the inmate (Male or female). | 0% | M MF of 4 |
inmate_status_code | categorical | provides the inmate status example if an inmate id a detainee. | 0% | DECSDPVof 8 |
top_charge | coordinate | Top charge for the inmate. | 61% | 155.25120.05220.03 |