From a 500-row sample across 7 columns.
dateexport_dateprofile_idexport_dateprofile_idexport_dateprofile_id| profile_id | date | case_number | charge_description | disposition | penalty_and_quantity | export_date |
|---|---|---|---|---|---|---|
| ea74f5c2-aec5-4b42-8f14-5457cea8a02c | 2022-08-22T00:00:00.000 | 2021-24184 | Made or caused to be made false or inaccurate entries in Department records. | PLEADED GUILTY | DISMISSAL PROBATION (12 month(s) ), SUSPENDED W/O PAY (30 day(s) ), VACATION DAYS (30 day(s) ) | 2026-10-11T00:00:00.000 |
| 5044736b-423d-4c8d-b134-0bfb184b176e | 2016-05-18T00:00:00.000 | 2015-14477 | WHILE ON-DUTY, FRISKED A PERSON KNOWN TO THE DEPARTMENT WITHOUT SUFFICIENT LEGAL AUTHORITY. | GUILTY |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
profile_id | text | Foreign Key to join to MOS table | 0% | fb31aef6-c7ac-4821-b588-…ed4dbe14-96a3-4800-a16a-…969c9a06-f94d-4039-9e97-… |
date | datetime | Date charges were approved | 0% | 2022-08-16T00:00:00.0002022-06-24T00:00:00.0002018-01-27T00:00:00.000 |
case_number | text | Internal number assigned to the case for tracking | 0% | 2019-214982017-180402017-18258 |
charge_description | text | Description of charges filed | 0% |
GET /api/datasets/uafj-ik29 GET /api/datasets/uafj-ik29/quality GET /api/datasets/uafj-ik29/related GET /api/columns?dataset=uafj-ik29
| VACATION DAYS (5 day(s) ) |
| 2026-10-11T00:00:00.000 |
| d520a689-8342-4d01-b5c3-7907f9366daa | 2022-04-06T00:00:00.000 | 2022-24896 | Left the scene of an accident. | PLEADED GUILTY | VACATION DAYS (30 day(s) ) | 2026-10-11T00:00:00.000 |
| d16687d1-e450-480d-9449-9cdd56182270 | 2016-05-27T00:00:00.000 | 2015-14422 | WHILE OFF-DUTY, WRONGFULLY OPERATED A MOTOR VEHICLE WHILE UNDER THE INFLUENCE OF AN INTOXICANT. | GUILTY | COUNSELING, DISMISSAL PROBATION (12 month(s) ), ORDERED BREATH TESTING, PRE-TRIAL SUSPENSION DAYS (31 day(s) ), VACATION DAYS (14 day(s) ) | 2026-10-11T00:00:00.000 |
| cb6c0e88-3e8d-4f6e-9a1e-28fe07f6a329 | 2016-09-12T00:00:00.000 | 2016-16258 | WHILE OFF-DUTY WRONGFULLY CONSUMED AN INTOXICANT TO THE EXTENT THAT HE WAS UNFIT FOR DUTY. | GUILTY | COUNSELING, DISMISSAL PROBATION (12 month(s) ), ORDERED BREATH TESTING, PRE-TRIAL SUSPENSION DAYS (30 day(s) ) | 2026-10-11T00:00:00.000 |
| 48502364-7b36-4eb5-a956-57802aa92d09 | 2024-07-23T00:00:00.000 | 2022-27596 | Made computer inquiries unrelated to official Department business. | PLEADED GUILTY | DISMISSAL PROBATION (12 month(s) ), VACATION DAYS (40 day(s) ) | 2026-10-11T00:00:00.000 |
| 07a5fbc2-c615-41ba-ad2c-af87f9877301 | 2022-07-06T00:00:00.000 | 2021-23879 | failed to obey lawful order/direction | PLEADED GUILTY | PRE-TRIAL SUSPENSION DAYS (30 day(s) ), VACATION DAYS (10 day(s) ) | 2026-10-11T00:00:00.000 |
| cd7d6c41-c10e-4656-8b4d-0b0b2f2f7e4f | 2010-04-28T00:00:00.000 | 2010-428 | WRONGFULLY PLACED HANDCUFFS ON A PERSON KNOWN TO THE DEPARTMENT. | GUILTY | DISMISSAL PROBATION (12 month(s) ), PRE-TRIAL SUSPENSION DAYS (30 day(s) ) | 2026-10-11T00:00:00.000 |
| 6a1fff89-a174-448d-a1dd-f97ead47b3e5 | 2014-12-10T00:00:00.000 | 2014-11220 | SEARCHED A PERSON KNOWN TO THE DEPARTMENT WITHOUT SUFFICIENT LEGAL AUTHORITY. | GUILTY | VACATION DAYS (25 day(s) ) | 2026-10-11T00:00:00.000 |
| e9639482-9190-4050-82e2-c63c9934efa4 | 2020-11-30T00:00:00.000 | 2020-22770 | Wrongfully disseminated confidential Department information. Off Duty. | GUILTY | SUSPENDED W/O PAY (15 day(s) ), VACATION DAYS (30 day(s) ) | 2026-10-11T00:00:00.000 |
Failed to make proper no…Unfit for duty.Made computer inquiries …disposition | categorical | Outcome of hearing | 0% | GUILTYPLEADED GUILTYNOLO CONTENDREof 3 |
penalty_and_quantity | text | Explanation of penalty where appropriate | 1% | VACATION DAYS (10 day(s)…VACATION DAYS (20 day(s)…VACATION DAYS (15 day(s)… |
export_date | datetime | Date data was exported/updated | 0% | 2026-10-04T00:00:00.000of 1 |