From a 500-row sample across 8 columns.
inmateidgenderdischarged_dt+4inmateidgenderdischarged_dt+5genderrace| inmateid | admitted_dt | discharged_dt | race | gender | age | inmate_status_code | top_charge |
|---|---|---|---|---|---|---|---|
| 20190778 | 2018-05-30T15:38:41.000 | 2018-08-16T06:12:04.000 | UNKNOWN | M | 25 | CS | 220.09 |
| 20130019 | 2018-02-24T20:15:24.000 | 2018-08-22T11:24:00.000 | UNKNOWN | M | 25 | DE | — |
| 41370 |
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% | 2022-03-03T13:12:28.0002019-04-05T16:38:20.0002021-07-30T18:23:34.000 |
discharged_dt | datetime | This field has the inmate discharged date and time . | 0% | 2019-02-19T16:00:00.0002024-04-29T18:00:00.0002017-06-02T20:45:00.000 |
race | categorical | Race of the inmate. | 0% |
GET /api/datasets/94ri-3ium GET /api/datasets/94ri-3ium/quality GET /api/datasets/94ri-3ium/related GET /api/columns?dataset=94ri-3ium
| 2018-07-30T15:58:35.000 |
| 2018-08-06T13:21:01.000 |
| BLACK |
| M |
| 49 |
| DE |
| — |
| 20035180 | 2018-04-30T13:34:00.000 | 2018-08-01T21:42:02.000 | BLACK | M | 49 | DE | — |
| 20115029 | 2018-08-31T00:39:46.000 | 2018-08-31T13:01:03.000 | UNKNOWN | M | 38 | DE | — |
| 130066 | 2018-08-22T22:12:20.000 | 2018-08-31T08:32:03.000 | BLACK | M | 33 | DE | — |
| 20178922 | 2017-02-25T21:47:00.000 | 2018-08-09T03:30:04.000 | BLACK | M | 56 | SSR | — |
| 20107609 | 2018-07-25T19:04:01.000 | 2018-08-08T02:37:04.000 | UNKNOWN | M | 35 | SCO | CO |
| 131832 | 2018-08-13T01:13:19.000 | 2018-08-29T01:09:00.000 | UNKNOWN | M | 36 | CS | FOA 900.00 |
| 20185155 | 2018-04-06T01:26:59.000 | 2018-08-03T16:50:01.000 | UNKNOWN | M | 18 | DE | — |
BLACKUNKNOWNASIANof 3gender | categorical | Gender of the inmate (Male or female). | 0% | M MF of 4 |
age | integer | Calculated Age of the inmate. | 0% | 282927 |
inmate_status_code | categorical | Provides the inmate status example if an inmate id a detainee. | 0% | DECSSSRof 8 |
top_charge | coordinate | Top charge for the inmate. | 80% | 155.25220.03120.00 |