From a 500-row sample across 12 columns.
inmateidagetop_charge+5| inmateid | admitted_dt | custody_level | bradh | race | gender | age | inmate_status_code | sealed | srg_flg | top_charge | infraction |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20250155 | 2026-04-23T12:20:47.000 | MIN | Y | B | M | 40 | DE | N | N | 120.10 | Y |
| 20244415 | 2026-04-19T12:46:32.000 | MAX |
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% | 202485752022287920248313 |
admitted_dt | datetime | This field has the admitted date and time of the incident. | 0% | 2026-09-17T12:26:00.0002026-09-11T19:22:00.0002026-06-25T01:12:00.000 |
discharged_dt | datetime | This field has the inmate discharged date and time. | 100% | — |
custody_level | categorical | This has the level of cutody provided for the inmate. Values are MIN,MED,Max custody levels. | 2% | MEDMINMAXof 3 |
GET /api/datasets/7479-ugqb GET /api/datasets/7479-ugqb/quality GET /api/datasets/7479-ugqb/related GET /api/columns?dataset=7479-ugqb
| Y |
| B |
| M |
| 22 |
| DE |
| N |
| Y |
| 160.15 |
| Y |
| 20239360 | 2026-05-26T11:12:59.000 | MIN | N | O | M | 47 | DE | N | N | 140.20 | N |
| 20099946 | 2026-07-10T01:36:00.000 | MIN | N | B | M | 44 | DE | N | N | 110-125.27 | N |
| 20249120 | 2026-03-03T12:43:21.000 | MED | Y | B | M | 26 | DE | N | N | 120.60 | Y |
| 20244289 | 2026-04-17T16:17:34.000 | MIN | Y | B | M | 27 | CS | N | N | — | N |
| 20057180 | 2026-07-23T21:21:00.000 | MIN | N | O | M | 35 | DE | N | N | 155.35 | N |
| 20240996 | 2026-06-29T11:44:26.000 | MED | N | B | M | 21 | DE | N | Y | 120.10 | Y |
| 20229798 | 2025-07-13T20:02:52.000 | MED | Y | B | M | 29 | DE | N | N | 110-125.25 | Y |
| 20232432 | 2024-07-05T11:57:31.000 | MIN | Y | O | M | 48 | DE | N | N | 120.10 | N |
bradh | categorical | BRADH has values Y or N. The inmate is under mental observation. | 0% | YNof 2 |
race | categorical | Race of the inmate. | 0% | BOWof 8 |
gender | categorical | Gender of the inmate (Male or female). | 0% | MFof 2 |
age | integer | Calculated Age of the inmate. | 0% | 323634 |
inmate_status_code | categorical | provides the inmate status example if an inmate id a detainee. | 0% | DECSDEPof 7 |
sealed | text | Sealed=Y implies that the inmate information is not to be shown in public. | 0% | Nof 1 |
srg_flg | categorical | SRG_FLG=Y means that the inmate is an approved gang affiliation. | 0% | NYof 2 |
top_charge | coordinate | Top charge for the inmate. | 5% | 125.25110-125.25120.05 |
infraction | categorical | Indicates whether the inmate has infraction. | 0% | NYof 2 |