Initiation by US Government | Demographics and Population Studies

About this Dataset

Initiation

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 Initiation results data presented here reflects all of the arrests that came through the door of the State's Attorneys Office (SAO). An initiation is how an arrest turns into a “case” in the courts. Most cases are initiated through a process known as felony review, in which SAO attorneys make a decision whether or not to prosecute. Cases may also be indicted by a grand jury or, in narcotics cases, filed directly by law enforcement (labeled "BOND SET (Narcotics)" in this data). Included in this data set are the defendant counts by initiation and year. This data includes felony cases handled by the Criminal, Narcotics, and Special Prosecution Bureaus. It does not include information about cases processed through the Juvenile Justice and Civil Actions Bureaus.
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:16.047269
Tags: states-attorney, states-attorney-case-level

Tables

Table 1

@usgov.cook_county_of_illinois_initiation.table_1

48.9 MB
1228260 rows
38 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,
  "charge_offense_title" VARCHAR,
  "charge_count" BIGINT,
  "chapter" VARCHAR,
  "act" VARCHAR,
  "section" VARCHAR,
  "class" VARCHAR,
  "aoic" VARCHAR,
  "event" VARCHAR,
  "event_date" VARCHAR,
  "finding_no_probable_cause" DOUBLE,
  "arraignment_date" VARCHAR,
  "bond_date_initial" VARCHAR,
  "bond_date_current" VARCHAR,
  "bond_type_initial" VARCHAR,
  "bond_type_current" VARCHAR,
  "bond_amount_initial" DOUBLE,
  "bond_amount_current" DOUBLE,
  "bond_electronic_monitor_flag_initial" VARCHAR,
  "bond_electroinic_monitor_flag_current" VARCHAR,
  "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,
  "updated_offense_category" VARCHAR
);