About this Dataset

Offenders Released From Iowa Prisons

This dataset provides information on offenders released from Iowa prisons during the past 10 fiscal years. It includes the fiscal year when an offender was released from prison, their age groups, sex, race - ethnicity, closure type, convicting offense with description and the number of months served.
Organization: State of Iowa
Last updated: 2023-01-20T00:11:47.014841
Tags: months-served, prison, release, time-served

Tables

Table 1

@usgov.state_of_iowa_offenders_released_from_iowa_prisons.table_1

1.33 MB
54,202 rows
18 columns

CREATE TABLE table_1 (
  "record_id" BIGINT,
  "offender_number" BIGINT,
  "release_date" TIMESTAMP,
  "fiscal_year_released" DOUBLE,
  "closure_type" VARCHAR,
  "supervision_status" VARCHAR,
  "institution_name" VARCHAR,
  "sex" VARCHAR,
  "race_ethnicity" VARCHAR  -- Race & Ethnicity,
  "age_at_release" DOUBLE,
  "offense_code" VARCHAR,
  "offense_classification" VARCHAR,
  "offense_description" VARCHAR,
  "offense_type" VARCHAR,
  "offense_subtype" VARCHAR,
  "jurisdiction" VARCHAR,
  "admission_date" TIMESTAMP,
  "months_served" DOUBLE
);