Name: Iowa Prison Admissions
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

Iowa Prison Admissions

This dataset provides de-identified individual admission data for offenders admitted to Iowa Penitentiaries and Correctional Facilities during the past 10 Fiscal Years. Dataset includes information regarding age, gender, race, years served, and offense committed.
Organization: State of Iowa
Last updated: 2023-01-20T00:18:02.298584
Tags: offenders, prison-admissions, prisons

Tables

Table 1

@usgov.state_of_iowa_iowa_prison_admissions.table_1

1.17 MB
49,602 rows
16 columns

CREATE TABLE table_1 (
  "record_id" BIGINT,
  "offender_number" BIGINT,
  "admission_date" TIMESTAMP,
  "fiscal_year_admitted" DOUBLE,
  "admission_type" VARCHAR,
  "sex" VARCHAR,
  "race_ethnicity" VARCHAR  -- Race & Ethnicity,
  "supervising_institution" VARCHAR,
  "offense_code" VARCHAR,
  "offense_classification" VARCHAR,
  "offense_description" VARCHAR,
  "offense_type" VARCHAR,
  "offense_subtype" VARCHAR,
  "age_at_admission" BIGINT,
  "date_of_release" TIMESTAMP,
  "months_served" DOUBLE
);