COMPAS Recidivism Racial Bias
Racial Bias in inmate COMPAS reoffense risk scores for Florida (ProPublica)
@kaggle.danofer_compass
Racial Bias in inmate COMPAS reoffense risk scores for Florida (ProPublica)
@kaggle.danofer_compass
CREATE TABLE compas_scores_raw (
"person_id" BIGINT,
"assessmentid" BIGINT,
"case_id" BIGINT,
"agency_text" VARCHAR,
"lastname" VARCHAR,
"firstname" VARCHAR,
"middlename" VARCHAR,
"sex_code_text" VARCHAR,
"ethnic_code_text" VARCHAR,
"dateofbirth" TIMESTAMP,
"scaleset_id" BIGINT,
"scaleset" VARCHAR,
"assessmentreason" VARCHAR,
"language" VARCHAR,
"legalstatus" VARCHAR,
"custodystatus" VARCHAR,
"maritalstatus" VARCHAR,
"screening_date" VARCHAR,
"recsupervisionlevel" BIGINT,
"recsupervisionleveltext" VARCHAR,
"scale_id" BIGINT,
"displaytext" VARCHAR,
"rawscore" DOUBLE,
"decilescore" BIGINT,
"scoretext" VARCHAR,
"assessmenttype" VARCHAR,
"iscompleted" BIGINT,
"isdeleted" BIGINT
);
CREATE TABLE cox_violent_parsed (
"id" DOUBLE,
"name" VARCHAR,
"first" VARCHAR,
"last" VARCHAR,
"compas_screening_date" TIMESTAMP,
"sex" VARCHAR,
"dob" TIMESTAMP,
"age" BIGINT,
"age_cat" VARCHAR,
"race" VARCHAR,
"juv_fel_count" BIGINT,
"decile_score" BIGINT,
"juv_misd_count" BIGINT,
"juv_other_count" BIGINT,
"priors_count" BIGINT,
"days_b_screening_arrest" DOUBLE,
"c_jail_in" VARCHAR,
"c_jail_out" VARCHAR,
"c_case_number" VARCHAR,
"c_offense_date" TIMESTAMP,
"c_arrest_date" TIMESTAMP,
"c_days_from_compas" DOUBLE,
"c_charge_degree" VARCHAR,
"c_charge_desc" VARCHAR,
"is_recid" BIGINT,
"r_case_number" VARCHAR,
"r_charge_degree" VARCHAR,
"r_days_from_arrest" DOUBLE,
"r_offense_date" TIMESTAMP,
"r_charge_desc" VARCHAR,
"r_jail_in" TIMESTAMP,
"r_jail_out" TIMESTAMP,
"violent_recid" VARCHAR,
"is_violent_recid" BIGINT,
"vr_case_number" VARCHAR,
"vr_charge_degree" VARCHAR,
"vr_offense_date" TIMESTAMP,
"vr_charge_desc" VARCHAR,
"type_of_assessment" VARCHAR,
"decile_score_1" BIGINT,
"score_text" VARCHAR,
"screening_date" TIMESTAMP,
"v_type_of_assessment" VARCHAR,
"v_decile_score" BIGINT,
"v_score_text" VARCHAR,
"v_screening_date" TIMESTAMP,
"in_custody" TIMESTAMP,
"out_custody" TIMESTAMP,
"priors_count_1" BIGINT,
"start" BIGINT,
"end" BIGINT,
"event" BIGINT
);
CREATE TABLE cox_violent_parsed_filt (
"id" DOUBLE,
"name" VARCHAR,
"first" VARCHAR,
"last" VARCHAR,
"sex" VARCHAR,
"dob" TIMESTAMP,
"age" BIGINT,
"age_cat" VARCHAR,
"race" VARCHAR,
"juv_fel_count" BIGINT,
"decile_score" BIGINT,
"juv_misd_count" BIGINT,
"juv_other_count" BIGINT,
"priors_count" BIGINT,
"days_b_screening_arrest" DOUBLE,
"c_jail_in" VARCHAR,
"c_jail_out" VARCHAR,
"c_days_from_compas" DOUBLE,
"c_charge_degree" VARCHAR,
"c_charge_desc" VARCHAR,
"is_recid" BIGINT,
"r_charge_degree" VARCHAR,
"r_days_from_arrest" DOUBLE,
"r_offense_date" TIMESTAMP,
"r_charge_desc" VARCHAR,
"r_jail_in" TIMESTAMP,
"violent_recid" VARCHAR,
"is_violent_recid" BIGINT,
"vr_charge_degree" VARCHAR,
"vr_offense_date" TIMESTAMP,
"vr_charge_desc" VARCHAR,
"type_of_assessment" VARCHAR,
"decile_score_1" BIGINT,
"score_text" VARCHAR,
"screening_date" TIMESTAMP,
"v_type_of_assessment" VARCHAR,
"v_decile_score" BIGINT,
"v_score_text" VARCHAR,
"priors_count_1" BIGINT,
"event" BIGINT
);
Anyone who has the link will be able to view this.