Dispositions by US Government | Demographics and Population Studies

About this Dataset

Dispositions

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 disposition data presented in this data reflects the culmination of the fact-finding process that leads to the resolution of a case. Each row represents a charge that has been disposed of.

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:21.082960
Tags: states-attorney, states-attorney-case-level

Tables

Table 1

@usgov.cook_county_of_illinois_dispositions.table_1

42.32 MB
1080014 rows
33 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,
  "judge" VARCHAR,
  "disposition_court_name" VARCHAR,
  "disposition_court_facility" VARCHAR,
  "age_at_incident" DOUBLE,
  "race" VARCHAR,
  "gender" VARCHAR,
  "incident_city" VARCHAR,
  "incident_begin_date" TIMESTAMP,
  "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
);