About this Dataset

Sentencing

A Note from the State's Attorney's Office as of 12/30/2024:

The Cook County State's Attorney's Office believes data transparency is an important accountability and public safety tool and is committed to providing Cook County residents with this critical information. Currently, we are working to make sure that the data we share is valid, accurate, and presented in a format that is useful to the public. Our goal is to have resumed updating the Cook County open data site within the first 100 days of the new administration.

Dataset Description:

The sentencing data presented in this report reflects the judgment imposed by the court on people that have been found guilty. Each row represents a charge that has been sentenced.

Please use this link for more instructions and data glossary:
https://www.cookcountystatesattorney.org/resources/how-read-data
Organization: Cook County of Illinois
Last updated: 2020-11-10T16:57:49.015111
Tags: states-attorney, states-attorney-case-level

Tables

Table 1

@usgov.cook_county_of_illinois_sentencing.table_1

18.39 MB
305884 rows
41 columns


CREATE TABLE table_1 (
  "case_id" BIGINT,
  "case_participant_id" BIGINT,
  "received_date" VARCHAR,
  "offense_category" VARCHAR,
  "primary_charge_flag" BOOLEAN,
  "charge_id" BIGINT,
  "charge_version_id" BIGINT,
  "disposition_charged_offense_title" VARCHAR,
  "charge_count" BIGINT,
  "disposition_date" VARCHAR,
  "disposition_charged_chapter" VARCHAR,
  "disposition_charged_act" VARCHAR,
  "disposition_charged_section" VARCHAR,
  "disposition_charged_class" VARCHAR,
  "disposition_charged_aoic" VARCHAR,
  "charge_disposition" VARCHAR,
  "charge_disposition_reason" VARCHAR,
  "sentence_judge" VARCHAR,
  "sentence_court_name" VARCHAR,
  "sentence_court_facility" VARCHAR,
  "sentence_phase" VARCHAR,
  "sentence_date" VARCHAR,
  "sentence_type" VARCHAR,
  "current_sentence_flag" BOOLEAN,
  "commitment_type" VARCHAR,
  "commitment_term" VARCHAR,
  "commitment_unit" VARCHAR,
  "length_of_case_in_days" DOUBLE,
  "age_at_incident" DOUBLE,
  "race" VARCHAR,
  "gender" VARCHAR,
  "incident_city" VARCHAR,
  "incident_begin_date" VARCHAR,
  "incident_end_date" VARCHAR,
  "law_enforcement_agency" VARCHAR,
  "law_enforcement_unit" VARCHAR,
  "arrest_date" VARCHAR,
  "felony_review_date" VARCHAR,
  "felony_review_result" VARCHAR,
  "arraignment_date" VARCHAR,
  "updated_offense_category" VARCHAR
);