Baselight

Crime In India

State-wise data from 2001 is classified according to 40+factors. (75+ csv files)

@kaggle.rajanand_crime_in_india

N 25 Complaints Against Police
@kaggle.rajanand_crime_in_india.n_25_complaints_against_police

  • 36.4 KB
  • 350 rows
  • 22 columns
area_name

Area Name

year

Year

sub_group

Sub Group

cpa_cases_registered

CPA - Cases Registered

cpa_cases_reported_for_dept_action

CPA - Cases Reported For Dept. Action

cpa_complaints_cases_declared_false_unsubstantiated

CPA - Complaints/Cases Declared False/Unsubstantiated

cpa_complaints_received_alleged

CPA - Complaints Received/Alleged

cpa_no_of_departmental_enquiries

CPA - No Of Departmental Enquiries

cpa_no_of_magisterial_enquiries

CPA - No Of Magisterial Enquiries

cpa_cases_sent_for_trials_charge_sheeted

CPA- Cases Sent For Trials/Charge-sheeted

cpa_no_of_judicial_enquiries

CPA- No Of Judicial Enquiries

cpb_police_personnel_acquitted

CPB - Police Personnel Acquitted

cpb_police_personnel_convicted

CPB - Police Personnel Convicted

cpb_police_personnel_sent_up_for_trial

CPB - Police Personnel Sent Up For Trial

cpb_police_personnel_trial_completed

CPB - Police Personnel Trial Completed

cpb_police_personnel_cases_withdrawn_or_otherwise_disposed_of

CPB- Police Personnel Cases Withdrawn Or Otherwise Disposed Of

cpc_police_personnel_cases_trial_completed

CPC - Police Personnel Cases Trial Completed

cpc_police_personnel_cases_withdrawn_or_otherwise_disposed_of

CPC - Police Personnel Cases Withdrawn Or Otherwise Disposed Of

cpc_police_personnel_disciplinary_action_initiated

CPC - Police Personnel Disciplinary Action Initiated

cpc_police_personnel_dismissal_removal_from_service

CPC - Police Personnel Dismissal/Removal From Service

cpc_police_personnel_major_punishment_awarded

CPC - Police Personnel Major Punishment Awarded

cpc_police_personnel_minor_punishment_awarded

CPC - Police Personnel Minor Punishment Awarded

Andaman & Nicobar Islands2001Complaints Against Police Personnel10410451516257321120
Andhra Pradesh2001Complaints Against Police Personnel30787210932291602969303923123921516234761506472481085
Arunachal Pradesh2001Complaints Against Police Personnel2439554441717184310741715
Assam2001Complaints Against Police Personnel1731525239117117144561102
Bihar2001Complaints Against Police Personnel111212531518818165371411385334701557
Chandigarh2001Complaints Against Police Personnel614252122114114131115717
Chhattisgarh2001Complaints Against Police Personnel1375120082618748513124306122441312636
Dadra & Nagar Haveli2001Complaints Against Police Personnel
Daman & Diu2001Complaints Against Police Personnel
Delhi2001Complaints Against Police Personnel18499368657242855991034871864

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
);

Share link

Anyone who has the link will be able to view this.