Crime In India
State-wise data from 2001 is classified according to 40+factors. (75+ csv files)
@kaggle.rajanand_crime_in_india
State-wise data from 2001 is classified according to 40+factors. (75+ csv files)
@kaggle.rajanand_crime_in_india
CREATE TABLE n_25_complaints_against_police (
"area_name" VARCHAR,
"year" BIGINT,
"sub_group" VARCHAR,
"cpa_cases_registered" BIGINT,
"cpa_cases_reported_for_dept_action" BIGINT,
"cpa_complaints_cases_declared_false_unsubstantiated" BIGINT,
"cpa_complaints_received_alleged" BIGINT,
"cpa_no_of_departmental_enquiries" BIGINT,
"cpa_no_of_magisterial_enquiries" BIGINT,
"cpa_cases_sent_for_trials_charge_sheeted" BIGINT,
"cpa_no_of_judicial_enquiries" BIGINT,
"cpb_police_personnel_acquitted" BIGINT,
"cpb_police_personnel_convicted" BIGINT,
"cpb_police_personnel_sent_up_for_trial" BIGINT,
"cpb_police_personnel_trial_completed" BIGINT,
"cpb_police_personnel_cases_withdrawn_or_otherwise_disposed_of" BIGINT,
"cpc_police_personnel_cases_trial_completed" BIGINT,
"cpc_police_personnel_cases_withdrawn_or_otherwise_disposed_of" BIGINT,
"cpc_police_personnel_disciplinary_action_initiated" BIGINT,
"cpc_police_personnel_dismissal_removal_from_service" BIGINT,
"cpc_police_personnel_major_punishment_awarded" BIGINT,
"cpc_police_personnel_minor_punishment_awarded" BIGINT
);
Anyone who has the link will be able to view this.