Baselight
Sign In

Crime In India

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

@kaggle.rajanand_crime_in_india

Loading...
Loading...

About this Dataset

Crime In India

Context

This dataset contains complete information about various aspects of crimes happened in India from 2001. There are many factors that can be analysed from this dataset. Over all, I hope this dataset helps us to understand better about India.

Content

  1. I : Cases Reported and their Disposal by Police and Court

  2. Indian Penal Code

  3. Special & Local Laws

  4. IA : SC/ST Cases Reported and their Disposal by Police and Court

  5. Crime against SCs

  6. Crime against STs

  7. IB : Children Cases Reported and their Disposal by Police and Court

  8. Abetment of Suicide (Section 305 IPC)

  9. Buying of Girls for Prostitution (Section 373 IPC)

  10. Child Marriage Restraint Act, 1929

  11. Exposure and Abandonment (Section 317 IPC)

  12. Foeticide (Section 315 and 316 IPC)

  13. Infanticide (Section 315 IPC)

  14. Kidnapping & Abduction (Section 360,361,363,363-A, 363 read with Section 384, 366, 367 & 369 IPC)

  15. Murder (Section 302, 315 IPC)

  16. Other Crimes against Children

  17. Other Murder of Children (Section 302 IPC)

  18. Procuration of Minor Girls (Section 366-A IPC)

  19. Rape (Section 376 IPC)

  20. Selling of Girls for Prostitution (Section 372 IPC)

  21. Total Crimes against Children

  22. II : Persons Arrested and their Disposal by Police and Court

  23. Indian Penal Code

  24. Special and Local Laws

  25. IIA : SC/ST Persons Arrested and their Disposal by Police and Court

  26. Crime against SCs

  27. Crime against STs

  28. IIB : Children Persons Arrested and their Disposal by Police and Court

  29. Abetment of suicide (Section 305 IPC)

  30. Buying of girls for prostitution (Section 373 IPC)

  31. Child Marriage Restraint Act, 1929

  32. Exposure and Abandonment (Section 317 IPC)

  33. Foeticide (Section 315 and 316 IPC)

  34. Kidnapping & Abduction (Section 360,361,363,363-A, 366, 367 & 369 IPC)

  35. Murder - Infanticide (Section 315 IPC)

  36. Murder - Other Murder of Children

  37. Murder (Section 302, 315 IPC)

  38. Other Crimes against Children

  39. Procuration of minor girls (Section 366-A IPC)

  40. Rape (Section 376 IPC)

  41. Selling of girls for prostitution (Section 372 IPC)

  42. Total Crimes against Children

  43. IV : Persons Arrested by Sex and Age Group

  44. Indian Penal Code

  45. Special & Local Laws

  46. V : Juveniles Apprehended

  47. Indian Penal Code

  48. Special & Local Laws

  49. VI : Juveniles Arrested and their Disposal

  50. VII : Property Stolen & Recovered (Crime Head)

  51. Dacoity

  52. Robbery

  53. Burglary

  54. Theft

  55. Criminal Breach of Trust

  56. Other Property

  57. Total Property Stolen & Recovered

  58. VIII : Property Stolen & Recovered (Nature of Property)

  59. Communation and Electricity Wire

  60. Cattle

  61. Cycle

  62. Motor Vehicles

    • Motor Vehicles - Motor Cycle/Scooters
    • Motor Vehicles - Motor Car/Taxi/Jeep
    • Motor Vehicles - Other Motor Vehicles

  63. Fire Arms

  64. Explosives/Explosive Substances

  65. Electronic Components

  66. Cultural Property including Antiques

  67. Other kinds of Property

  68. Total Property Stolen & Recovered

  69. IX : Police Strength (Actual & Sanctioned)

  70. A) Actual Civil Police (Incl. District Armed Police and Women Police)

  71. A) Acual Armed Police (Incl. Women Police)

  72. A) Actual Police Strength (Incl. Women)

  73. B) Acual Women Civil Police (Incl. District Armed Force)

  74. B) Actual Women Armed Police

  75. B) Actual Women Police Strength

  76. C) Sanctioned Civil Police (Incl. District Armed Police)

  77. C) Santioned Armed Police (Incl. Women Police)

  78. C) Santioned Police Strength (Incl. Women)

  79. D) Sanctioned Women Civil Police (Incl. District Armed Police)

  80. D) Sanctioned Women Armed Police

  81. D) Sanctioned Women Police Strength

  82. X : Police Personnel Killed or Injured on duty

  83. Constables

  84. Head Constables

  85. Assistant Sub-Inspectos

  86. Sub-Inspectors

  87. Inspectors

  88. Gazetted Officers

  89. Total Police Killed or Injured

  90. X-B : Age Profile of Police Personnel Killed on Duty

  91. X-C : Natural Deaths and Suicides of Police Personnel

  92. Natural Deaths of Police Personnel (while in service)

  93. Police Personnel Committed Suicide

  94. XI : Casualties under Police Firing and LathiCharge

  95. Riot Control

  96. Anti Dacoity Operations

  97. Against Extremists & Terrorists

  98. Against Others

  99. Total Casualties

  100. XII : Cases Reported Value of Property Stolen under Dacoity, Robbery, Burglary and Theft by Place of Occurance

  101. Residential Premises

  102. Highways

  103. River and Sea

  104. Railways
    4.1 In Running Trains
    4.2 Others

  105. Banks

  106. Commercial Establishments (Shops etc.)

  107. Other Places

  108. Total

  109. XIII : Particulars of Juveniles Arrested

  110. Education

  111. Economic Setup

  112. Family Background

  113. Recidivism

  114. XIV : Motive/Cause of Murder and Culpable Homicide not Amounting to Murder

  115. XV : Victims of Rape(Age Group-wise)

  116. Incest Rape Cases

  117. Other Rape Cases (Otherthan Incest)

  118. Total Rape Cases

  119. XV-A : Rape Offenders relation, nearness to Rape Victims

  120. XVI : Persons Arrested under Recidivism

  121. XVII : Anti Corruption - Cases

  122. XVIII : Anti Corruption - Arrests

  123. XIX : Complaints/Cases Against Police Personnel

  124. Complaints Received/Cases Registered

  125. Police Personnel Involved/Action Taken

  126. Departmental Action/Punishments

  127. *XX : Police Budget and Infrastructure

  128. Equipments and Transport Support

  129. Distribution of Police Stations by Crime Incidences

  130. Distribution of Police Stations by Police Strength

  131. Organisational Set Up

  132. SCs/STs and Muslims in Police Force (Actual)

  133. XXI : 1. Nature of Complaints Received by Police

  134. XXI : 2. Trial of Violent Crimes by Courts

  135. Murder

  136. Attempt to Murder

  137. C H Not Amounting to Murder

  138. Rape

  139. Kidnapping & Abduction
    5.1 Kidnapping & Abduction of Women & Girls
    5.2 Kidnapping & Abduction of Others

  140. Dacoity

  141. Preparation & Assembly for Dacoity

  142. Robbery

  143. Riots

  144. Arson

  145. Dowry Deaths

  146. Total Trials (Sum of 1-11 Above)

  147. XXI : 3. Period of Trials by Courts

  148. District/Session Judge

  149. Additional Session Judge

  150. Chief Judicial Magistrate

  151. Judicial Magistrate (I)

  152. Judicial Magistrate (II)

  153. Special Judicial Magistrate

  154. Other courts

  155. Total Trials (Sum of 1-7 Above)

  156. XXI : 4.1 Autho Theft (Stolen & Recovered)

  157. Motor Cycles/ Scooters

  158. Motor Car/Taxi/Jeep

  159. Buses

  160. Goods carrying vehicles (Trucks/Tempo etc)

  161. Other Motor vehicles

  162. Total (Sum of 1-5 Above)

  163. XXI : 4.2 Serious Fraud

  164. Criminal Breach of Trust

  165. Cheating

  166. XXI : 5.1 Victims of Murder (Age & Sex-Wise)

  167. Male Victims

  168. Female Victims

  169. Total

  170. XXI : 5.2 Victims of CH not Amounting to Murder (Age & Sex-wise)

  171. Male Victims

  172. Female Victims

  173. Total

  174. XXI : 5.3 Use of FireArms in Murder Cases

  175. XXI : 6. Human Rights Violation by Police

  176. Disappearance of Persons

  177. Illegal Detention/Arrests

  178. Fake Encounter Killings

  179. Violation Against Terrorists/Extremists

  180. Extortion

  181. Torture

  182. False Implication

  183. Failure in Taking Action

  184. Indignity to Women

  185. Atrocities on SC/ST

  186. Others

  187. Total (Sum of 1-11 Above)

  188. XXI : 7. Police Housing

  189. For Officers (Dy.SP & Above)

  190. Upper SubOrdinates (ASI to Inspectos)

  191. Lower SubOrdinates (Constables, Head Constables & Class-IV Subordinate Staff)

  192. XXI : 8. Home Guards and Auxilliary force

  193. XXI : 9. Unidentified Deadbodies Recovered & Inquest conducted

  194. XXI : 10. Victims of Kidnapping & Abduction for Specific Purpose

  195. For Adoption

  196. For Begging

  197. for Camel Racing

  198. For Illicit Intercourse

  199. For Marriage

  200. For Prostitution

  201. For Ransom

  202. For Revenge

  203. For Sale

  204. For Selling Bodyparts

  205. For Slavery

  206. For Unlawful Activity

  207. Other Purposes

  208. Total (Sum of 1-13 Above)

  209. XXI : 11. Custodial Deaths

  210. Deaths in Custody/Lockup of Persons Remanded to Police Custody by Court

  211. Deaths in Custody/Lockup of Persons Not Remanded to Police Custody by Court

  212. Deaths in Custody during production/process in courts/journey connected with investigation

  213. Deaths during Hospitalisation/Treatment

  214. Deaths due to Other Reasons

  215. XXI : 12. Escapes from Police Custody

  216. Cases under Crime Against Women

  217. Rape

  218. Kidnapping & Abduction of Women & Girls

  219. Dowry Deaths

  220. Molestation

  221. Sexual Harassment

  222. Cruelty by Husband and Relatives

  223. Importation of Girls

  224. Immoral Traffic Prevention Act, 1956

  225. Dowry Prohibition Act, 1961

  226. Indecent Representation of Women(Prohibition) Act, 1986

  227. Sati Prevention Act, 1987

  228. Total Crimes Against Women

  229. Arrests under Crime Against Women

  230. Rape

  231. Kidnapping & Abduction of Women & Girls

  232. Dowry Deaths

  233. Molestation

  234. Sexual Harassment

  235. Cruelty by Husband and Relatives

  236. Importation of Girls

  237. Immoral Traffic Prevention Act, 1956

  238. Dowry Prohibition, 1961

  239. Indecent Representation of Women(Prohibition) Act, 1986

  240. Sati Prevention Act, 1987

  241. Total Crimes Against Women

Some of the data contains district level data. The districts are police districts and also include special police unit. Therefore these may be different from revenue districts. Most of the data is from 2001 to 2010. But there are few files which has data only from 2011 and few are having 2001-14.

Inspiration

There could be many things one can understand by analyzing this dataset. Few inspirations for you to start with.

  1. What is the major reason people being kidnapped in each and every state?
  2. Offenders relation to the rape victim
  3. Juveniles family background, education and economic setup.
  4. Which state has more crime against children and women?
  5. Age group wise murder victim
  6. Crime by place of occurrence.
  7. Anti corruption cases vs arrests.
  8. Which state has more number of complaints against police?
  9. Which state is the safest for foreigners?

Acknowledgements

National Crime Records Bureau (NCRB), Govt of India has published this dataset on their website and also has shared on Open Govt Data Platform India portal under Govt. Open Data License - India.

Tables

N 10 Property Stolen And Recovered

@kaggle.rajanand_crime_in_india.n_10_property_stolen_and_recovered
  • 56.82 KB
  • 2449 rows
  • 8 columns
Loading... 

CREATE TABLE n_10_property_stolen_and_recovered (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cases_property_recovered" BIGINT,
  "cases_property_stolen" BIGINT,
  "value_of_property_recovered" BIGINT,
  "value_of_property_stolen" BIGINT
);

N 20 Victims Of Rape

@kaggle.rajanand_crime_in_india.n_20_victims_of_rape
  • 24.48 KB
  • 1050 rows
  • 11 columns
Loading... 

CREATE TABLE n_20_victims_of_rape (
  "area_name" VARCHAR,
  "year" BIGINT,
  "subgroup" VARCHAR,
  "rape_cases_reported" BIGINT,
  "victims_above_50_yrs" BIGINT,
  "victims_between_10_14_yrs" BIGINT,
  "victims_between_14_18_yrs" BIGINT,
  "victims_between_18_30_yrs" BIGINT,
  "victims_between_30_50_yrs" BIGINT,
  "victims_of_rape_total" BIGINT,
  "victims_upto_10_yrs" BIGINT
);

N 25 Complaints Against Police

@kaggle.rajanand_crime_in_india.n_25_complaints_against_police
  • 36.4 KB
  • 350 rows
  • 22 columns
Loading... 

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

N 28 Trial Of Violent Crimes By Courts

@kaggle.rajanand_crime_in_india.n_28_trial_of_violent_crimes_by_courts
  • 34.61 KB
  • 4473 rows
  • 7 columns
Loading... 

CREATE TABLE n_28_trial_of_violent_crimes_by_courts (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "trial_of_violent_crimes_by_courts_by_confession" DOUBLE,
  "trial_of_violent_crimes_by_courts_by_trial" DOUBLE,
  "trial_of_violent_crimes_by_courts_total" DOUBLE
);

N 29 Period Of Trials By Courts

@kaggle.rajanand_crime_in_india.n_29_period_of_trials_by_courts
  • 54.56 KB
  • 1786 rows
  • 11 columns
Loading... 

CREATE TABLE n_29_period_of_trials_by_courts (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "pt_1_3_years" DOUBLE,
  "pt_3_5_years" DOUBLE,
  "pt_5_10_years" DOUBLE,
  "pt_6_12_months" DOUBLE,
  "pt_less_than_6_months" DOUBLE,
  "pt_over_10_years" DOUBLE,
  "pt_total" DOUBLE
);

N 30 Auto Theft

@kaggle.rajanand_crime_in_india.n_30_auto_theft
  • 19.99 KB
  • 1865 rows
  • 7 columns
Loading... 

CREATE TABLE n_30_auto_theft (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "auto_theft_coordinated_traced" DOUBLE,
  "auto_theft_recovered" DOUBLE,
  "auto_theft_stolen" BIGINT
);

N 31 Serious Fraud

@kaggle.rajanand_crime_in_india.n_31_serious_fraud
  • 9.95 KB
  • 448 rows
  • 9 columns
Loading... 

CREATE TABLE n_31_serious_fraud (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "loss_of_property_1_10_crores" DOUBLE,
  "loss_of_property_10_25_crores" DOUBLE,
  "loss_of_property_25_50_crores" DOUBLE,
  "loss_of_property_50_100_crores" DOUBLE,
  "loss_of_property_above_100_crores" DOUBLE
);

N 32 Murder Victim Age Sex

@kaggle.rajanand_crime_in_india.n_32_murder_victim_age_sex
  • 25.5 KB
  • 1018 rows
  • 11 columns
Loading... 

CREATE TABLE n_32_murder_victim_age_sex (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "victims_above_50_yrs" DOUBLE,
  "victims_total" BIGINT,
  "victims_upto_10_15_yrs" DOUBLE,
  "victims_upto_10_yrs" DOUBLE,
  "victims_upto_15_18_yrs" DOUBLE,
  "victims_upto_18_30_yrs" DOUBLE,
  "victims_upto_30_50_yrs" DOUBLE
);

N 33 Ch Not Murder Victim Age Sex

@kaggle.rajanand_crime_in_india.n_33_ch_not_murder_victim_age_sex
  • 17.47 KB
  • 936 rows
  • 10 columns
Loading... 

CREATE TABLE n_33_ch_not_murder_victim_age_sex (
  "area_name" VARCHAR,
  "year" BIGINT,
  "sub_group_name" VARCHAR,
  "victims_above_50_yrs" DOUBLE,
  "victims_total" DOUBLE,
  "victims_upto_10_15_yrs" DOUBLE,
  "victims_upto_10_yrs" DOUBLE,
  "victims_upto_15_18_yrs" DOUBLE,
  "victims_upto_18_30_yrs" DOUBLE,
  "victims_upto_30_50_yrs" DOUBLE
);

N 35 Human Rights Violation By Police

@kaggle.rajanand_crime_in_india.n_35_human_rights_violation_by_police
  • 10.23 KB
  • 2267 rows
  • 7 columns
Loading... 

CREATE TABLE n_35_human_rights_violation_by_police (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cases_registered_under_human_rights_violations" DOUBLE,
  "policemen_chargesheeted" DOUBLE,
  "policemen_convicted" DOUBLE
);

N 39 Specific Purpose Of Kidnapping And Abduction

@kaggle.rajanand_crime_in_india.n_39_specific_purpose_of_kidnapping_and_abduction
  • 71.75 KB
  • 3569 rows
  • 20 columns
Loading... 

CREATE TABLE n_39_specific_purpose_of_kidnapping_and_abduction (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "k_a_cases_reported" DOUBLE,
  "k_a_female_10_15_years" DOUBLE,
  "k_a_female_15_18_years" DOUBLE,
  "k_a_female_18_30_years" DOUBLE,
  "k_a_female_30_50_years" DOUBLE,
  "k_a_female_above_50_years" DOUBLE,
  "k_a_female_total" DOUBLE,
  "k_a_female_upto_10_years" DOUBLE,
  "k_a_grand_total" DOUBLE,
  "k_a_male_10_15_years" DOUBLE,
  "k_a_male_15_18_years" DOUBLE,
  "k_a_male_18_30_years" DOUBLE,
  "k_a_male_30_50_years" DOUBLE,
  "k_a_male_above_50_years" DOUBLE,
  "k_a_male_total" DOUBLE,
  "k_a_male_upto_10_years" DOUBLE
);

N 40–01 Custodial Death Person Remanded

@kaggle.rajanand_crime_in_india.n_40_01_custodial_death_person_remanded
  • 11.69 KB
  • 211 rows
  • 11 columns
Loading... 

CREATE TABLE n_40_01_custodial_death_person_remanded (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cd_deaths_reported" DOUBLE,
  "cd_no_of_autopsy_conducted" DOUBLE,
  "cd_no_of_cases_registered_in_connection_with_deaths" DOUBLE,
  "cd_no_of_judicial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_magisterial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_policemen_charge_sheeted" DOUBLE,
  "cd_no_of_policemen_convicted" DOUBLE
);

N 40–02 Custodial Death Person Not Remanded

@kaggle.rajanand_crime_in_india.n_40_02_custodial_death_person_not_remanded
  • 11.91 KB
  • 228 rows
  • 11 columns
Loading... 

CREATE TABLE n_40_02_custodial_death_person_not_remanded (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cd_deaths_reported" BIGINT,
  "cd_no_of_autopsy_conducted" DOUBLE,
  "cd_no_of_cases_registered_in_connection_with_deaths" DOUBLE,
  "cd_no_of_judicial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_magisterial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_policemen_charge_sheeted" DOUBLE,
  "cd_no_of_policemen_convicted" DOUBLE
);

N 40–03 Custodial Death During Production

@kaggle.rajanand_crime_in_india.n_40_03_custodial_death_during_production
  • 11.8 KB
  • 204 rows
  • 11 columns
Loading... 

CREATE TABLE n_40_03_custodial_death_during_production (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cd_deaths_reported" BIGINT,
  "cd_no_of_autopsy_conducted" DOUBLE,
  "cd_no_of_cases_registered_in_connection_with_deaths" DOUBLE,
  "cd_no_of_judicial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_magisterial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_policemen_charge_sheeted" DOUBLE,
  "cd_no_of_policemen_convicted" DOUBLE
);

N 40–04 Custodial Death During Hospitalization Or Treatment

@kaggle.rajanand_crime_in_india.n_40_04_custodial_death_during_hospitalization_or_treatment
  • 5.38 KB
  • 213 rows
  • 5 columns
Loading... 

CREATE TABLE n_40_04_custodial_death_during_hospitalization_or_treatment (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cd_hospitalisation_treatment" BIGINT
);

N 40–05 Custodial Death Others

@kaggle.rajanand_crime_in_india.n_40_05_custodial_death_others
  • 9.64 KB
  • 233 rows
  • 10 columns
Loading... 

CREATE TABLE n_40_05_custodial_death_others (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cd_accidents" DOUBLE,
  "cd_by_mob_attackriots" DOUBLE,
  "cd_by_other_criminals" DOUBLE,
  "cd_by_suicide" DOUBLE,
  "cd_illnessnatural_death" DOUBLE,
  "cd_while_escaping_from_custody" DOUBLE
);

Share link

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