Name: Sentencing [Archived From February 13, 2018]
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Sentencing [Archived From February 13, 2018]

This is an archived version of the Sentencing dataset as it was originally released on February 13, 2018.
Organization: Cook County of Illinois
Last updated: 2020-11-10T16:57:45.141230
Tags: archived, inactive, states-attorney, states-attorney-case-level

Tables

Table 1

@usgov.cook_county_of_illinois_sentencing_archived_from_febru_49cfb442.table_1

10.79 MB
189288 rows
36 columns


CREATE TABLE table_1 (
  "case_id" BIGINT,
  "case_participant_id" BIGINT,
  "charge_id" BIGINT,
  "charge_version_id" BIGINT,
  "primary_charge" BOOLEAN,
  "offense_title" VARCHAR,
  "chapter" VARCHAR,
  "act" VARCHAR,
  "section" VARCHAR,
  "class" VARCHAR,
  "aoic" VARCHAR,
  "dispo_date" VARCHAR,
  "sentence_phase" VARCHAR,
  "sentence_date" VARCHAR,
  "sentence_judge" VARCHAR,
  "sentence_type" VARCHAR,
  "commitment_type" VARCHAR,
  "commitment_term" DOUBLE,
  "commitment_unit" VARCHAR,
  "charge_disposition" VARCHAR,
  "charge_disposition_reason" VARCHAR,
  "court_name" VARCHAR,
  "court_facility" VARCHAR,
  "length_of_case_in_days" DOUBLE,
  "age_at_incident" DOUBLE,
  "gender" VARCHAR,
  "race" VARCHAR,
  "offense_type" VARCHAR,
  "incident_begin_date" VARCHAR,
  "incident_end_date" VARCHAR,
  "arrest_date" VARCHAR,
  "law_enforcement_agency" VARCHAR,
  "unit" VARCHAR,
  "incident_city" VARCHAR,
  "received_date" VARCHAR,
  "arraignment_date" VARCHAR
);