State's Attorney Felony Cases - Average Case Length And Sum Of Length, By Offense Type
Cook County of Illinois
@usgov.cook_county_of_illinois_states_attorney_felony_cases_a_fae7c643
Cook County of Illinois
@usgov.cook_county_of_illinois_states_attorney_felony_cases_a_fae7c643
Sum of Length is an internal calculation used to produce the Average Case Length in a specific offense category. Neither should be read to be associated with any individual case. Rather, the Sum of Length is the number of days in total spent on all the cases in which defendants were charged in a specific charge category combined. The Average Case Length in a particular charge category is then derived by dividing the Sum of Length by the number of defendants.
Organization: Cook County of Illinois
Last updated: 2020-11-10T16:57:56.084672
Tags: inactive, states-attorney-baseline-data-report
CREATE TABLE table_1 (
"year" BIGINT,
"offense_type" VARCHAR,
"average_case_length" DOUBLE,
"sum_of_length" DOUBLE,
"defendant_count" BIGINT
);Anyone who has the link will be able to view this.