Iowa Probation Revocations

State of Iowa

@usgov.state_of_iowa_iowa_probation_revocations

Table List

1 table(355.67 KB)

Table 1

@usgov.state_of_iowa_iowa_probation_revocations.table_1

355.67 KB
17444 rows
13 columns

record_id Record ID	offender_number Offender Number	revocation_date Revocation Date	fiscal_year_revoked Fiscal Year Revoked	revocation_type Revocation Type	status_revoked Status Revoked	sex Sex	race_ethnicity Race & Ethnicity	age Age	offense_classification Offense Classification	offense_description Offense Description	offense_type Offense Type	offense_subtype Offense Subtype
	20229803	Wed Jun 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	3. New Arrest	Probation	Male	White	33	D Felony	Possession of a Controlled Substance - 3rd and subsequent	Drug	Drug Possession
1	18368447	Mon Oct 05 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	9. Need to Review	Probation	Female	White	28	D Felony	THEFT 2ND DEGREE	Property	Theft
2	19460591	Fri Apr 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2019	4. New Arrest ICON	Probation	Male	Black	37	Aggravated Misdemeanor	OPER VEH WH INT (OWI) / AGR MISD / 2ND OFF -	Public Order	OWI
3	19772666	Fri Aug 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	1. New Fel/Agg Conv	Probation	Male	White	22	Aggravated Misdemeanor	OPERATE VEHICLE NO CONSENT	Property	Theft
4	18482687	Fri Oct 25 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		4. New Arrest ICON	Probation	Female	White	37	Aggravated Misdemeanor	OPERATING WHILE UNDER THE INFLUENCE 2ND OFFENSE	Public Order	OWI
5	18872825	Wed Feb 11 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2015	4. New Arrest ICON	Probation	Male	White	33	D Felony	Possession of a Controlled Substance - 3rd and subsequent	Drug	Drug Possession
6	18394631	Tue Jul 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	4. New Arrest ICON	Probation	Female	White	40	Aggravated Misdemeanor	ATTEMPTED BURGLARY 3RD DEGREE	Property	Burglary
7	18405842	Wed Jan 20 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	4. New Arrest ICON	Probation	Male	White	24	Aggravated Misdemeanor	UNAUTH. USE OF CREDIT CARD $1K	Property	Forgery/Fraud
8	18513905	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	3. New Arrest	Probation	Female	White	45	D Felony	Possession of a Controlled Substance - 3rd and subsequent	Drug	Drug Possession
9	19255796	Mon Jul 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2018	4. New Arrest ICON	Probation	Male	White	32	D Felony	OPER VEH WH INT (OWI)/CLASS D FEL/3RD AND SUBSEQUENT OFF	Public Order	OWI


CREATE TABLE table_1 (
  "record_id" BIGINT,
  "offender_number" BIGINT,
  "revocation_date" TIMESTAMP,
  "fiscal_year_revoked" DOUBLE,
  "revocation_type" VARCHAR,
  "status_revoked" VARCHAR,
  "sex" VARCHAR,
  "race_ethnicity" VARCHAR,
  "age" BIGINT,
  "offense_classification" VARCHAR,
  "offense_description" VARCHAR,
  "offense_type" VARCHAR,
  "offense_subtype" VARCHAR
);