Name: Crime Trends In India (2001 - 2020)
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Crime Trends In India (2001 - 2020)

Crime Trends in India from 2001 to 2020

A Statistical Overview of Criminal Victimization and Offender Action

By Rajanand Ilangovan [source]

About this dataset

This Dataset provides an up-to-date analysis of crime trends in India from 2001 to the present. It contains complete information about different types of crimes such as rape, murder, and theft that were committed across India. By analyzing this dataset we can determine the areas where crimes were most prevalent, what type of offenders were usually involved in the crime and which year had the highest number of registered cases. Additionally, we can also analyse which group experienced most complaints and what kind of punishments or consequences they faced like departmental enquiries, magisterial enquiries or police personnel trials completed. This data set is perfect for further research into crime trends in India and will help us better understand why certain types of crimes take place more frequently than others

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

• Area Name (state or UT) where the crime was reported.
• Year in which the crime was reported.
• Subgroup (type of crime).
• Number of cases registered, number of cases reported for departmental action etc., related to a particular type of crime and state/UT.
• Number of complaints/cases declared false/unsubstantiated, number of police personnel convictions etc., related to a particular type of crime and state/UT.
• Number of cases in which offenders were others known persons to the victims, neighbours or relatives to the victims etc., related to a particular type of crime and state/UT.

By studying this dataset one might explore different angles by analysing factors like:

• What are the top states with high rate criminal activities? Which areas are relatively safer?
• Are any states witnessing higher incidences than national average levels? Alternatively, are there any regions which have recorded lower rates than national average levels?
• What is trend between sub crimes across India both regional & time wise? How has it changed over time ?                                                (2001-20) ;
                            Movement among crimes on monthly basis during period 2001 - 2020
      Comparison among ages , genders & professions involved with Crime Rates && Timeline comparison between Types Of Crime , Crimes Involving Police Personnel Contractors in Crimes as timeline .                                       Immigration Report .    Is absolute difference btw urban & rural up from previous years ?    Open conversations about what government efforts need more focus & why . Fundamentals impacting reducing / increasing rate behind closed doors . Any impactful key insights about SelfDefence Degree given out that year highlighting decreasing / increasing amount if increase thenwhat extra activity got curated btw that law was enacted vs before enactment if possible Outliers Analysis on same murders done by pediphiles or sexual assault against women under minorities if exists

Research Ideas

Analyzing crime trends over time by analyzing the Year, Sub_group and Area_Name columns to understand different types of crimes and patterns of criminal activity in India.

Evaluating the effectiveness of police response to different types of crimes, such as comparing the CPA_-Cases_Registered, CPA-_Cases_Reported_for_Dept.Action and CPB-_Police_PersonnelAcquitted data fields across different time periods, sub-groups and areas to assess how well law enforcement is responding to crimes reported.

Tracking changes in punishment awarded for different crimes by analyzing the CPC_-Police-Personnel_-Major-Punishment_-awarded data field for changes over time or from one geographical area to another

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

You are free to:

Share - copy and redistribute the material in any medium or format for any purpose, even commercially.

Adapt - remix, transform, and build upon the material for any purpose, even commercially.

You must:

Give appropriate credit - Provide a link to the license, and indicate if changes were made.

ShareAlike - You must distribute your contributions under the same license as the original.

Columns

File: 25_Complaints_against_police.csv

Column name	Description
Area_Name	The name of the area where the crime was reported. (String)
Year	The year in which the crime was reported. (Integer)
Sub_group	The type of crime reported. (String)
CPA_-_Cases_Registered	The number of cases registered for the crime. (Integer)
CPA_-_Cases_Reported_for_Dept._Action	The number of cases reported to the department for action. (Integer)
CPA_-_Complaints/Cases_Declared_False/Unsubstantiated	The number of complaints/cases declared false or unsubstantiated. (Integer)
CPA_-_Complaints_Received/Alleged	The number of complaints received or alleged. (Integer)
CPA_-_No_of_Departmental_Enquiries	The number of departmental enquiries conducted. (Integer)
CPA_-_No_of_Magisterial_Enquiries	The number of magisterial enquiries conducted. (Integer)
CPA-_Cases_Sent_for_Trials/Charge-sheeted	The number of cases sent for trial or charge-sheeted. (Integer)
CPA-_No_of_Judicial_Enquiries	The number of judicial enquiries conducted. (Integer)
CPB_-_Police_Personnel_Acquitted	The number of police personnel acquitted. (Integer)
CPB_-_Police_Personnel_Convicted	The number of police personnel convicted. (Integer)
CPB_-_Police_Personnel_sent_up_for_Trial	The number of police personnel sent up for trial. (Integer)
CPB_-_Police_Personnel_Trial_Completed	The number of police personnel trials completed. (Integer)
CPB-_Police_Personnel_Cases_Withdrawn_or_Otherwise_disposed_of	The number of police personnel cases withdrawn or otherwise disposed of. (Integer)
CPC_-_Police_personnel_Cases_Trial_Completed	The number of police personnel cases trial completed. (Integer)

File: 21_Offenders_known_to_the_victim.csv

Column name	Description
Area_Name	The name of the area where the crime was reported. (String)
Year	The year in which the crime was reported. (Integer)
No_of_Cases_in_which_offenders_were_known_to_the_Victims	The number of cases in which the offender was known to the victim. (Integer)
No_of_Cases_in_which_offenders_were_Neighbours	The number of cases in which the offender was a neighbour of the victim. (Integer)
No_of_Cases_in_which_offenders_were_Other_Known_persons	The number of cases in which the offender was an acquaintance of the victim. (Integer)
No_of_Cases_in_which_offenders_were_Parentsclose_family_members	The number of cases in which the offender was a parent or close family member of the victim. (Integer)
No_of_Cases_in_which_offenders_were_Relatives	The number of cases in which the offender was a relative of the victim. (Integer)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Rajanand Ilangovan.

Tables

N 01 District Wise Crimes Committed Ipc 2001–2012

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_01_district_wise_crimes_committed_ipc_2001_2012

488.04 kB
9,017 rows
34 columns

CREATE TABLE n_01_district_wise_crimes_committed_ipc_2001_2012 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "attempt_to_murder" BIGINT,
  "culpable_homicide_not_amounting_to_murder" BIGINT,
  "rape" BIGINT,
  "custodial_rape" BIGINT,
  "other_rape" BIGINT,
  "kidnapping_abduction" BIGINT  -- KIDNAPPING \u0026 ABDUCTION,
  "kidnapping_and_abduction_of_women_and_girls" BIGINT,
  "kidnapping_and_abduction_of_others" BIGINT,
  "dacoity" BIGINT,
  "preparation_and_assembly_for_dacoity" BIGINT,
  "robbery" BIGINT,
  "burglary" BIGINT,
  "theft" BIGINT,
  "auto_theft" BIGINT,
  "other_theft" BIGINT,
  "riots" BIGINT,
  "criminal_breach_of_trust" BIGINT,
  "cheating" BIGINT,
  "counterfieting" BIGINT,
  "arson" BIGINT,
  "hurt_grevious_hurt" BIGINT,
  "dowry_deaths" BIGINT,
  "assault_on_women_with_intent_to_outrage_her_modesty" BIGINT,
  "insult_to_modesty_of_women" BIGINT,
  "cruelty_by_husband_or_his_relatives" BIGINT,
  "importation_of_girls_from_foreign_countries" BIGINT,
  "causing_death_by_negligence" BIGINT,
  "other_ipc_crimes" BIGINT,
  "total_ipc_crimes" BIGINT
);

N 01 District Wise Crimes Committed Ipc 2013

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_01_district_wise_crimes_committed_ipc_2013

91.62 kB
823 rows
34 columns

CREATE TABLE n_01_district_wise_crimes_committed_ipc_2013 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "attempt_to_murder" BIGINT,
  "culpable_homicide_not_amounting_to_murder" BIGINT,
  "rape" BIGINT,
  "custodial_rape" BIGINT,
  "other_rape" BIGINT,
  "kidnapping_abduction" BIGINT  -- KIDNAPPING \u0026 ABDUCTION,
  "kidnapping_and_abduction_of_women_and_girls" BIGINT,
  "kidnapping_and_abduction_of_others" BIGINT,
  "dacoity" BIGINT,
  "preparation_and_assembly_for_dacoity" BIGINT,
  "robbery" BIGINT,
  "burglary" BIGINT,
  "theft" BIGINT,
  "auto_theft" BIGINT,
  "other_theft" BIGINT,
  "riots" BIGINT,
  "criminal_breach_of_trust" BIGINT,
  "cheating" BIGINT,
  "counterfieting" BIGINT,
  "arson" BIGINT,
  "hurt_grevious_hurt" BIGINT,
  "dowry_deaths" BIGINT,
  "assault_on_women_with_intent_to_outrage_her_modesty" BIGINT,
  "insult_to_modesty_of_women" BIGINT,
  "cruelty_by_husband_or_his_relatives" BIGINT,
  "importation_of_girls_from_foreign_countries" BIGINT,
  "causing_death_by_negligence" BIGINT,
  "other_ipc_crimes" BIGINT,
  "total_ipc_crimes" BIGINT
);

N 01 District Wise Crimes Committed Ipc 2014

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_01_district_wise_crimes_committed_ipc_2014

182.01 kB
838 rows
92 columns

CREATE TABLE n_01_district_wise_crimes_committed_ipc_2014 (
  "index" BIGINT,
  "states_uts" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "attempt_to_commit_murder" BIGINT,
  "culpable_homicide_not_amounting_to_murder" BIGINT,
  "attempt_to_commit_culpable_homicide" BIGINT,
  "rape" BIGINT,
  "custodial_rape" BIGINT,
  "custodial_gang_rape" BIGINT,
  "custodial_other_rape" BIGINT,
  "rape_other_than_custodial" BIGINT,
  "rape_gang_rape" BIGINT,
  "rape_others" BIGINT,
  "attempt_to_commit_rape" BIGINT,
  "kidnapping_abduction_total" BIGINT  -- Kidnapping \u0026 Abduction Total,
  "kidnapping_abduction" BIGINT  -- Kidnapping \u0026 Abduction,
  "kidnapping_abduction_in_order_to_murder" BIGINT  -- Kidnapping \u0026 Abduction In Order To Murder,
  "kidnapping_for_ransom" BIGINT,
  "kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- Kidnapping \u0026 Abduction Of Women To Compel Her For Marriage,
  "other_kidnapping" BIGINT,
  "dacoity" BIGINT,
  "dacoity_with_murder" BIGINT,
  "other_dacoity" BIGINT,
  "making_preparation_and_assembly_for_committing_dacoity" BIGINT,
  "robbery" BIGINT,
  "criminal_trespass_burglary" BIGINT,
  "criminal_trespass_or_burglary" BIGINT,
  "house_trespass_house_breaking" BIGINT  -- House Trespass \u0026 House Breaking,
  "theft" BIGINT,
  "auto_theft" BIGINT,
  "other_thefts" BIGINT,
  "unlawful_assembly" BIGINT,
  "riots" BIGINT,
  "riots_communal" BIGINT,
  "riots_industrial" BIGINT,
  "riots_political" BIGINT,
  "riots_caste_conflict" BIGINT,
  "riots_sc_sts_vs_non_scs_sts" BIGINT,
  "riots_other_caste_conflict" BIGINT,
  "riots_agrarian" BIGINT,
  "riots_students" BIGINT,
  "riots_sectarian" BIGINT,
  "riots_others" BIGINT,
  "criminal_breach_of_trust" BIGINT,
  "cheating" BIGINT,
  "forgery" BIGINT,
  "counterfeiting" BIGINT,
  "counterfeit_offences_related_to_counterfeit_coin" BIGINT,
  "counterfeiting_government_stamp" BIGINT,
  "counterfeit_currency_bank_notes" BIGINT  -- Counterfeit Currency \u0026 Bank Notes,
  "counterfeiting_currency_notes_bank_notes" BIGINT,
  "using_forged_or_counterfeiting_currency_bank_notes" BIGINT,
  "possession_of_forged_or_counterfeiting_currency_bank_notes" BIGINT,
  "making_or_possessing_materials_for_forged_currency_bank_notes" BIGINT,
  "making_or_using_documents_resembling_currency" BIGINT,
  "arson" BIGINT,
  "grievous_hurt" BIGINT,
  "hurt" BIGINT,
  "acid_attack" BIGINT,
  "attempt_to_acid_attack" BIGINT,
  "dowry_deaths" BIGINT,
  "assault_on_women_with_intent_to_outrage_her_modesty" BIGINT,
  "sexual_harassment" BIGINT,
  "assault_or_use_of_criminal_force_to_women_with_intent__10cddfcd" BIGINT  -- Assault Or Use Of Criminal Force To Women With Intent To Disrobe,
  "voyeurism" BIGINT,
  "stalking" BIGINT,
  "other_assault_on_women" BIGINT,
  "insult_to_the_modesty_of_women" BIGINT,
  "at_office_premises" BIGINT,
  "other_places_related_to_work" BIGINT,
  "in_public_transport_system" BIGINT,
  "places_other_than_231_232_233" BIGINT  -- Places Other Than 231, 232 \u0026 233,
  "cruelty_by_husband_or_his_relatives" BIGINT,
  "importation_of_girls_from_foreign_country" BIGINT,
  "causing_death_by_negligence" BIGINT,
  "deaths_due_to_negligent_driving_act" BIGINT,
  "deaths_due_to_other_causes" BIGINT,
  "offences_against_state" BIGINT,
  "sedition" BIGINT,
  "other_offences_against_state" BIGINT,
  "offences_promoting_enmity_between_different_groups" BIGINT,
  "promoting_enmity_between_different_groups" BIGINT,
  "imputation_assertions_prejudicial_to_national_integration" BIGINT  -- Imputation, Assertions Prejudicial To National Integration,
  "extortion" BIGINT,
  "disclosure_of_identity_of_victims" BIGINT,
  "incidence_of_rash_driving" BIGINT,
  "humantrafficking" BIGINT,
  "unnatural_offence" BIGINT,
  "other_ipc_crimes" BIGINT,
  "total_cognizable_ipc_crimes" BIGINT
);

N 02–01 District Wise Crimes Committed Against Sc 2001–2012

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_02_01_district_wise_crimes_committed_against_sc_2001_2012

127.05 kB
9,018 rows
14 columns

CREATE TABLE n_02_01_district_wise_crimes_committed_against_sc_2001_2012 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "rape" BIGINT,
  "kidnapping_and_abduction" BIGINT,
  "dacoity" BIGINT,
  "robbery" BIGINT,
  "arson" BIGINT,
  "hurt" BIGINT,
  "prevention_of_atrocities_poa_act" BIGINT  -- Prevention Of Atrocities (POA) Act,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "other_crimes_against_scs" BIGINT
);

N 02–01 District Wise Crimes Committed Against Sc 2013

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_02_01_district_wise_crimes_committed_against_sc_2013

28.8 kB
823 rows
14 columns

CREATE TABLE n_02_01_district_wise_crimes_committed_against_sc_2013 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "rape" BIGINT,
  "kidnapping_and_abduction" BIGINT,
  "dacoity" BIGINT,
  "robbery" BIGINT,
  "arson" BIGINT,
  "hurt" BIGINT,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "prevention_of_atrocities_poa_act" BIGINT  -- Prevention Of Atrocities (POA) Act,
  "other_crimes_against_scs" BIGINT
);

N 02–01 District Wise Crimes Committed Against Sc 2014

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_02_01_district_wise_crimes_committed_against_sc_2014

86.01 kB
837 rows
67 columns

CREATE TABLE n_02_01_district_wise_crimes_committed_against_sc_2014 (
  "index" BIGINT,
  "states_uts" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "protection_of_civil_rights_act_1955" BIGINT  -- Protection Of Civil Rights Act, 1955,
  "poa_murder" BIGINT,
  "poa_attempt_to_commit_murder" BIGINT,
  "poa_rape" BIGINT,
  "poa_attempt_to_commit_rape" BIGINT,
  "poa_assault_on_women_with_intent_to_outrage_her_modesty" BIGINT,
  "poa_sexual_harassment" BIGINT,
  "poa_assault_on_women_with_intent_to_disrobe" BIGINT,
  "poa_voyeurism" BIGINT,
  "poa_stalking" BIGINT,
  "poa_other_sexual_harassment" BIGINT,
  "poa_insult_to_the_modesty_of_women" BIGINT,
  "poa_kidnapping_abduction_grandtotal" BIGINT  -- POA Kidnapping \u0026 Abduction GrandTotal,
  "poa_kidnaping_abduction_total" BIGINT  -- POA Kidnaping \u0026 Abduction Total,
  "poa_kidnaping_abduction_in_order_to_murder" BIGINT  -- POA Kidnaping \u0026 Abduction In Order To Murder,
  "poa_kidnapping_for_ransom" BIGINT,
  "poa_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- POA Kidnapping \u0026 Abduction Of Women To Compel Her For Marriage,
  "poa_other_kidnapping" BIGINT,
  "poa_dacoity" BIGINT,
  "poa_dacoity_with_murder" BIGINT,
  "poa_other_dacoity" BIGINT,
  "poa_robbery" BIGINT,
  "poa_arson" BIGINT,
  "poa_grievous_hurt" BIGINT,
  "poa_hurt" BIGINT,
  "poa_acid_attack" BIGINT,
  "poa_attempt_to_acid_attack" BIGINT,
  "poa_riots" BIGINT,
  "poa_other_ipc_crimes" BIGINT,
  "poa_sc_st_prevention_of_atrocities_act_only" BIGINT  -- POA SC / ST (Prevention Of Atrocities) Act Only,
  "total_of_sc_st_prevention_of_atrocities_act_1989" BIGINT  -- Total Of SC/ST (Prevention Of Atrocities) Act ,1989,
  "ipc_murder" BIGINT,
  "ipc_attempt_to_commit_murder" BIGINT,
  "ipc_rape" BIGINT,
  "ipc_attempt_to_commit_rape" BIGINT,
  "ipc_assault_on_women_with_intent_to_outrage_her_modesty" BIGINT,
  "ipc_sexual_harassment" BIGINT,
  "ipc_assault_on_women_with_intent_to_disrobe" BIGINT,
  "ipc_voyeurism" BIGINT,
  "ipc_stalking" BIGINT,
  "ipc_other_sexual_harassment" BIGINT,
  "ipc_insult_to_the_modesty_of_women" BIGINT,
  "ipc_kidnapping_abduction" BIGINT  -- IPC Kidnapping \u0026 Abduction,
  "ipc_kidnaping_abduction" BIGINT  -- IPC Kidnaping \u0026 Abduction,
  "ipc_kidnaping_abduction_in_order_to_murder" BIGINT  -- IPC Kidnaping \u0026 Abduction In Order To Murder,
  "ipc_kidnapping_for_ransom" BIGINT,
  "ipc_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- IPC Kidnapping \u0026 Abduction Of Women To Compel Her For Marriage,
  "ipc_other_kidnapping" BIGINT,
  "ipc_dacoity" BIGINT,
  "ipc_dacoity_with_murder" BIGINT,
  "ipc_other_dacoity" BIGINT,
  "ipc_robbery" BIGINT,
  "ipc_arson" BIGINT,
  "ipc_grievous_hurt" BIGINT,
  "ipc_hurt" BIGINT,
  "ipc_acid_attack" BIGINT,
  "ipc_attempt_to_acid_attack" BIGINT,
  "ipc_riots" BIGINT,
  "ipc_other_ipc_crimes" BIGINT,
  "total_ipc_crimes_against_scs" BIGINT,
  "manual_scavengers_and_construction_of_dry_latrines_p_act_1993" BIGINT  -- Manual Scavengers And Construction Of Dry Latrines (P) Act, 1993,
  "other_sll_crime_against_scs" BIGINT,
  "total_crimes_against_scs" BIGINT
);

N 02 District Wise Crimes Committed Against St 2001–2012

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_02_district_wise_crimes_committed_against_st_2001_2012

103.02 kB
9,018 rows
14 columns

CREATE TABLE n_02_district_wise_crimes_committed_against_st_2001_2012 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "rape" BIGINT,
  "kidnapping_abduction" BIGINT,
  "dacoity" BIGINT,
  "robbery" BIGINT,
  "arson" BIGINT,
  "hurt" BIGINT,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "prevention_of_atrocities_poa_act" BIGINT  -- Prevention Of Atrocities (POA) Act,
  "other_crimes_against_sts" BIGINT
);

N 02 District Wise Crimes Committed Against St 2013

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_02_district_wise_crimes_committed_against_st_2013

26.1 kB
823 rows
14 columns

CREATE TABLE n_02_district_wise_crimes_committed_against_st_2013 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "rape" BIGINT,
  "kidnapping_abduction" BIGINT,
  "dacoity" BIGINT,
  "robbery" BIGINT,
  "arson" BIGINT,
  "hurt" BIGINT,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "prevention_of_atrocities_poa_act" BIGINT  -- Prevention Of Atrocities (POA) Act,
  "other_crimes_against_sts" BIGINT
);

N 02 District Wise Crimes Committed Against St 2014

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_02_district_wise_crimes_committed_against_st_2014

78.11 kB
837 rows
67 columns

CREATE TABLE n_02_district_wise_crimes_committed_against_st_2014 (
  "index" BIGINT,
  "states_uts" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "protection_of_civil_rights_act_1955" BIGINT  -- Protection Of Civil Rights Act, 1955,
  "poa_murder" BIGINT,
  "poa_attempt_to_commit_murder" BIGINT,
  "poa_rape" BIGINT,
  "poa_attempt_to_commit_rape" BIGINT,
  "poa_assault_on_women_with_intent_to_outrage_her_modesty" BIGINT,
  "poa_sexual_harassment" BIGINT,
  "poa_assault_on_women_with_intent_to_disrobe" BIGINT,
  "poa_voyeurism" BIGINT,
  "poa_stalking" BIGINT,
  "poa_other_sexual_harassment" BIGINT,
  "poa_insult_to_the_modesty_of_women" BIGINT,
  "poa_kidnapping_abduction_grandtotal" BIGINT  -- POA Kidnapping \u0026 Abduction GrandTotal,
  "poa_kidnaping_abduction_total" BIGINT  -- POA Kidnaping \u0026 Abduction Total,
  "poa_kidnaping_abduction_in_order_to_murder" BIGINT  -- POA Kidnaping \u0026 Abduction In Order To Murder,
  "poa_kidnapping_for_ransom" BIGINT,
  "poa_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- POA Kidnapping \u0026 Abduction Of Women To Compel Her For Marriage,
  "poa_other_kidnapping" BIGINT,
  "poa_dacoity" BIGINT,
  "poa_dacoity_with_murder" BIGINT,
  "poa_other_dacoity" BIGINT,
  "poa_robbery" BIGINT,
  "poa_arson" BIGINT,
  "poa_grievous_hurt" BIGINT,
  "poa_hurt" BIGINT,
  "poa_acid_attack" BIGINT,
  "poa_attempt_to_acid_attack" BIGINT,
  "poa_riots" BIGINT,
  "poa_other_ipc_crimes" BIGINT,
  "poa_sc_st_prevention_of_atrocities_act_only" BIGINT  -- POA SC / ST (Prevention Of Atrocities) Act Only,
  "total_of_sc_st_prevention_of_atrocities_act_1989" BIGINT  -- Total Of SC/ST (Prevention Of Atrocities) Act ,1989,
  "ipc_murder" BIGINT,
  "ipc_attempt_to_commit_murder" BIGINT,
  "ipc_rape" BIGINT,
  "ipc_attempt_to_commit_rape" BIGINT,
  "ipc_assault_on_women_with_intent_to_outrage_her_modesty" BIGINT,
  "ipc_sexual_harassment" BIGINT,
  "ipc_assault_on_women_with_intent_to_disrobe" BIGINT,
  "ipc_voyeurism" BIGINT,
  "ipc_stalking" BIGINT,
  "ipc_other_sexual_harassment" BIGINT,
  "ipc_insult_to_the_modesty_of_women" BIGINT,
  "ipc_kidnapping_abduction" BIGINT  -- IPC Kidnapping \u0026 Abduction,
  "ipc_kidnaping_abduction" BIGINT  -- IPC Kidnaping \u0026 Abduction,
  "ipc_kidnaping_abduction_in_order_to_murder" BIGINT  -- IPC Kidnaping \u0026 Abduction In Order To Murder,
  "ipc_kidnapping_for_ransom" BIGINT,
  "ipc_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- IPC Kidnapping \u0026 Abduction Of Women To Compel Her For Marriage,
  "ipc_other_kidnapping" BIGINT,
  "ipc_dacoity" BIGINT,
  "ipc_dacoity_with_murder" BIGINT,
  "ipc_other_dacoity" BIGINT,
  "ipc_robbery" BIGINT,
  "ipc_arson" BIGINT,
  "ipc_grievous_hurt" BIGINT,
  "ipc_hurt" BIGINT,
  "ipc_acid_attack" BIGINT,
  "ipc_attempt_to_acid_attack" BIGINT,
  "ipc_riots" BIGINT,
  "ipc_other_ipc_crimes" BIGINT,
  "total_ipc_crimes_against_sts" BIGINT,
  "manual_scavengers_and_construction_of_dry_latrines_p_act_1993" BIGINT  -- Manual Scavengers And Construction Of Dry Latrines (P) Act, 1993,
  "other_sll_crime_against_sts" BIGINT,
  "total_crimes_against_sts" BIGINT
);

N 03 District Wise Crimes Committed Against Children 2001–2012

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_03_district_wise_crimes_committed_against_children_2001_2012

135.41 kB
9,015 rows
16 columns

CREATE TABLE n_03_district_wise_crimes_committed_against_children_2001_2012 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" DOUBLE,
  "rape" DOUBLE,
  "kidnapping_and_abduction" DOUBLE,
  "foeticide" DOUBLE,
  "abetment_of_suicide" DOUBLE,
  "exposure_and_abandonment" DOUBLE,
  "procuration_of_minor_girls" DOUBLE,
  "buying_of_girls_for_prostitution" DOUBLE,
  "selling_of_girls_for_prostitution" DOUBLE,
  "prohibition_of_child_marriage_act" DOUBLE,
  "other_crimes" DOUBLE,
  "total" BIGINT
);

N 03 District Wise Crimes Committed Against Children 2013

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_03_district_wise_crimes_committed_against_children_2013

34.48 kB
823 rows
17 columns

CREATE TABLE n_03_district_wise_crimes_committed_against_children_2013 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "infanticid" BIGINT,
  "other_murder" BIGINT,
  "rape" BIGINT,
  "kidnapping_and_abduction" BIGINT,
  "foeticide" BIGINT,
  "abetment_of_suicide" BIGINT,
  "exposure_and_abandonment" BIGINT,
  "procuration_of_minor_girls" BIGINT,
  "buying_of_girls_for_prostitution" BIGINT,
  "selling_of_girls_for_prostitution" BIGINT,
  "prohibition_of_child_marriage_act" BIGINT,
  "other_crimes" BIGINT,
  "total" BIGINT
);

N 03 Persons Arrested And Their Disposal By Police And 6ed108b0

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_03_persons_arrested_and_their_disposal_by_police_and_6ed108b0

149.66 kB
2,028 rows
58 columns

CREATE TABLE n_03_persons_arrested_and_their_disposal_by_police_and_6ed108b0 (
  "index" BIGINT,
  "states_uts" VARCHAR,
  "crime_head" VARCHAR,
  "year" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_male" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_female" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_total" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_male" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_female" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_total" BIGINT,
  "persons_arrested_during_the_year_male" BIGINT,
  "persons_arrested_during_the_year_female" BIGINT,
  "persons_arrested_during_the_year_total" BIGINT,
  "persons_released_or_freed_before_trial_for_want_of_evi_e1bc6961" BIGINT  -- Persons Released Or Freed Before Trial For Want Of Evidence Male,
  "persons_released_or_freed_before_trial_for_want_of_evidence_fem" BIGINT,
  "persons_released_or_freed_before_trial_for_want_of_evidence_tot" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_male" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_female" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_total" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_male" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_female" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_total" BIGINT,
  "persons_charge_sheeted_male" BIGINT,
  "persons_charge_sheeted_female" BIGINT,
  "persons_charge_sheeted_total" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_male" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_female" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_total" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_male" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_female" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_total" BIGINT,
  "total_number_of_persons_under_trial_male" BIGINT,
  "total_number_of_persons_under_trial_female" BIGINT,
  "total_number_of_persons_under_trial_total" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_male" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_female" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_total" BIGINT,
  "persons_against_whom_cases_were_withdrawn_male" BIGINT,
  "persons_against_whom_cases_were_withdrawn_female" BIGINT,
  "persons_against_whom_cases_were_withdrawn_total" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_male" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_female" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_total" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_male" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_female" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_total" BIGINT,
  "persons_whose_cases_trials_were_completed_during_the_year_male" BIGINT,
  "persons_whose_cases_trials_were_completed_during_the_y_ed32adbc" BIGINT  -- Persons Whose Cases Trials Were Completed During The Year Female,
  "persons_whose_cases_trials_were_completed_during_the_year_total" BIGINT,
  "persons_convicted_male" BIGINT,
  "persons_convicted_female" BIGINT,
  "persons_convicted_total" BIGINT,
  "persons_acquitted_male" BIGINT,
  "persons_acquitted_female" BIGINT,
  "persons_acquitted_total" BIGINT,
  "persons_discharged_by_court_male" BIGINT,
  "persons_discharged_by_court_female" BIGINT,
  "persons_discharged_by_court_total" BIGINT
);

N 03 Persons Arrested And Their Disposal By Police And 7e201ad0

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_03_persons_arrested_and_their_disposal_by_police_and_7e201ad0

29.87 kB
494 rows
15 columns

CREATE TABLE n_03_persons_arrested_and_their_disposal_by_police_and_7e201ad0 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The Beginning Of The Year,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT  -- Persons Released Or Freed By Police Or Magistrate Before Trial For Want Of Evidence Or Any Other Reason,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The End Of The Year,
  "persons_in_whose_cases_charge_sheets_were_laid_during_the_year" BIGINT,
  "persons_under_trial_at_the_beginning_of_the_year" BIGINT,
  "total_number_of_persons_under_trial_during_the_year" BIGINT,
  "persons_against_whom_cases_were_compounded_or_withdrawn" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_tria_340bbb57" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Trial At The End Of The Year,
  "persons_in_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

N 03 Persons Arrested And Their Disposal By Police And Fea05944

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_03_persons_arrested_and_their_disposal_by_police_and_fea05944

29.68 kB
494 rows
15 columns

CREATE TABLE n_03_persons_arrested_and_their_disposal_by_police_and_fea05944 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The Beginning Of The Year,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT  -- Persons Released Or Freed By Police Or Magistrate Before Trial For Want Of Evidence Or Any Other Reason,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The End Of The Year,
  "persons_in_whose_cases_charge_sheets_were_laid_during_the_year" BIGINT,
  "persons_under_trial_at_the_beginning_of_the_year" BIGINT,
  "total_number_of_persons_under_trial_during_the_year" BIGINT,
  "persons_against_whom_cases_were_compounded_or_withdrawn" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_tria_340bbb57" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Trial At The End Of The Year,
  "persons_in_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

N 04–01 Person Arrested And Their Disposal By Police A 1a9d3577

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_04_01_person_arrested_and_their_disposal_by_police_a_1a9d3577

203.84 kB
2,730 rows
58 columns

CREATE TABLE n_04_01_person_arrested_and_their_disposal_by_police_a_1a9d3577 (
  "index" BIGINT,
  "states_uts" VARCHAR,
  "crime_head" VARCHAR,
  "year" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_male" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_female" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_total" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_male" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_female" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_total" BIGINT,
  "persons_arrested_during_the_year_male" BIGINT,
  "persons_arrested_during_the_year_female" BIGINT,
  "persons_arrested_during_the_year_total" BIGINT,
  "persons_released_or_freed_before_trial_for_want_of_evi_e1bc6961" BIGINT  -- Persons Released Or Freed Before Trial For Want Of Evidence Male,
  "persons_released_or_freed_before_trial_for_want_of_evidence_fem" BIGINT,
  "persons_released_or_freed_before_trial_for_want_of_evidence_tot" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_male" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_female" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_total" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_male" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_female" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_total" BIGINT,
  "persons_charge_sheeted_male" BIGINT,
  "persons_charge_sheeted_female" BIGINT,
  "persons_charge_sheeted_total" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_male" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_female" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_total" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_male" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_female" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_total" BIGINT,
  "total_number_of_persons_under_trial_male" BIGINT,
  "total_number_of_persons_under_trial_female" BIGINT,
  "total_number_of_persons_under_trial_total" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_male" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_female" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_total" BIGINT,
  "persons_against_whom_cases_were_withdrawn_male" BIGINT,
  "persons_against_whom_cases_were_withdrawn_female" BIGINT,
  "persons_against_whom_cases_were_withdrawn_total" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_male" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_female" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_total" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_male" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_female" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_total" BIGINT,
  "persons_whose_cases_trials_were_completed_during_the_year_male" BIGINT,
  "persons_whose_cases_trials_were_completed_during_the_y_ed32adbc" BIGINT  -- Persons Whose Cases Trials Were Completed During The Year Female,
  "persons_whose_cases_trials_were_completed_during_the_year_total" BIGINT,
  "persons_convicted_male" BIGINT,
  "persons_convicted_female" BIGINT,
  "persons_convicted_total" BIGINT,
  "persons_acquitted_male" BIGINT,
  "persons_acquitted_female" BIGINT,
  "persons_acquitted_total" BIGINT,
  "persons_discharged_by_court_male" BIGINT,
  "persons_discharged_by_court_female" BIGINT,
  "persons_discharged_by_court_total" BIGINT
);

N 04–01 Person Arrested And Their Disposal By Police A 6f8e2765

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_04_01_person_arrested_and_their_disposal_by_police_a_6f8e2765

28.09 kB
418 rows
15 columns

CREATE TABLE n_04_01_person_arrested_and_their_disposal_by_police_a_6f8e2765 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The Beginning Of The Year,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT  -- Persons Released Or Freed By Police Or Magistrate Before Trial For Want Of Evidence Or Any Other Reason,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The End Of The Year,
  "persons_in_whose_cases_charge_sheets_were_laid_during_the_year" BIGINT,
  "persons_under_trial_at_the_beginning_of_the_year" BIGINT,
  "total_number_of_persons_under_trial_during_the_year" BIGINT,
  "persons_against_whom_cases_were_compounded_or_withdrawn" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_tria_340bbb57" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Trial At The End Of The Year,
  "persons_in_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

N 04–01 Person Arrested And Their Disposal By Police A 9dfccd11

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_04_01_person_arrested_and_their_disposal_by_police_a_9dfccd11

50.64 kB
1,026 rows
15 columns

CREATE TABLE n_04_01_person_arrested_and_their_disposal_by_police_a_9dfccd11 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The Beginning Of The Year,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT  -- Persons Released Or Freed By Police Or Magistrate Before Trial For Want Of Evidence Or Any Other Reason,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The End Of The Year,
  "persons_in_whose_cases_charge_sheets_were_laid_during_the_year" BIGINT,
  "persons_under_trial_at_the_beginning_of_the_year" BIGINT,
  "total_number_of_persons_under_trial_during_the_year" BIGINT,
  "persons_against_whom_cases_were_compounded_or_withdrawn" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_tria_340bbb57" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Trial At The End Of The Year,
  "persons_in_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

N 04–02 Person Arrested And Their Disposal By Police A 79e07b9f

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_04_02_person_arrested_and_their_disposal_by_police_a_79e07b9f

70.79 kB
1,140 rows
15 columns

CREATE TABLE n_04_02_person_arrested_and_their_disposal_by_police_a_79e07b9f (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The Beginning Of The Year,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT  -- Persons Released Or Freed By Police Or Magistrate Before Trial For Want Of Evidence Or Any Other Reason,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The End Of The Year,
  "persons_in_whose_cases_charge_sheets_were_laid_during_the_year" BIGINT,
  "persons_under_trial_at_the_beginning_of_the_year" BIGINT,
  "total_number_of_persons_under_trial_during_the_year" BIGINT,
  "persons_against_whom_cases_were_compounded_or_withdrawn" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_tria_340bbb57" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Trial At The End Of The Year,
  "persons_in_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

N 04–02 Person Arrested And Their Disposal By Police A 85125627

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_04_02_person_arrested_and_their_disposal_by_police_a_85125627

372.25 kB
3,432 rows
58 columns

CREATE TABLE n_04_02_person_arrested_and_their_disposal_by_police_a_85125627 (
  "index" BIGINT,
  "states_uts" VARCHAR,
  "crime_head" VARCHAR,
  "year" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_male" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_female" BIGINT,
  "persons_in_custody_during_inv_stage_at_beginning_of_year_total" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_male" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_female" BIGINT,
  "persons_on_bail_during_inv_stage_at_beginning_of_year_total" BIGINT,
  "persons_arrested_during_the_year_male" BIGINT,
  "persons_arrested_during_the_year_female" BIGINT,
  "persons_arrested_during_the_year_total" BIGINT,
  "persons_released_or_freed_before_trial_for_want_of_evi_e1bc6961" BIGINT  -- Persons Released Or Freed Before Trial For Want Of Evidence Male,
  "persons_released_or_freed_before_trial_for_want_of_evidence_fem" BIGINT,
  "persons_released_or_freed_before_trial_for_want_of_evidence_tot" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_male" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_female" BIGINT,
  "persons_in_custody_during_inv_stage_at_year_end_total" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_male" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_female" BIGINT,
  "persons_on_bail_during_inv_stage_at_year_end_total" BIGINT,
  "persons_charge_sheeted_male" BIGINT,
  "persons_charge_sheeted_female" BIGINT,
  "persons_charge_sheeted_total" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_male" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_female" BIGINT,
  "persons_in_custody_during_trial_stage_at_begin_of_year_total" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_male" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_female" BIGINT,
  "persons_on_bail_during_trial_stage_at_begin_of_year_total" BIGINT,
  "total_number_of_persons_under_trial_male" BIGINT,
  "total_number_of_persons_under_trial_female" BIGINT,
  "total_number_of_persons_under_trial_total" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_male" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_female" BIGINT,
  "persons_against_whom_cases_were_compounded_by_courts_total" BIGINT,
  "persons_against_whom_cases_were_withdrawn_male" BIGINT,
  "persons_against_whom_cases_were_withdrawn_female" BIGINT,
  "persons_against_whom_cases_were_withdrawn_total" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_male" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_female" BIGINT,
  "persons_in_custody_during_trial_stage_at_year_end_total" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_male" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_female" BIGINT,
  "persons_on_bail_during_trial_stage_at_year_end_total" BIGINT,
  "persons_whose_cases_trials_were_completed_during_the_year_male" BIGINT,
  "persons_whose_cases_trials_were_completed_during_the_y_ed32adbc" BIGINT  -- Persons Whose Cases Trials Were Completed During The Year Female,
  "persons_whose_cases_trials_were_completed_during_the_year_total" BIGINT,
  "persons_convicted_male" BIGINT,
  "persons_convicted_female" BIGINT,
  "persons_convicted_total" BIGINT,
  "persons_acquitted_male" BIGINT,
  "persons_acquitted_female" BIGINT,
  "persons_acquitted_total" BIGINT,
  "persons_discharged_by_court_male" BIGINT,
  "persons_discharged_by_court_female" BIGINT,
  "persons_discharged_by_court_total" BIGINT
);

N 04–02 Person Arrested And Their Disposal By Police A D4bb9e32

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_04_02_person_arrested_and_their_disposal_by_police_a_d4bb9e32

70.49 kB
1,140 rows
15 columns

CREATE TABLE n_04_02_person_arrested_and_their_disposal_by_police_a_d4bb9e32 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The Beginning Of The Year,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT  -- Persons Released Or Freed By Police Or Magistrate Before Trial For Want Of Evidence Or Any Other Reason,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Investigation At The End Of The Year,
  "persons_in_whose_cases_charge_sheets_were_laid_during_the_year" BIGINT,
  "persons_under_trial_at_the_beginning_of_the_year" BIGINT,
  "total_number_of_persons_under_trial_during_the_year" BIGINT,
  "persons_against_whom_cases_were_compounded_or_withdrawn" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_tria_340bbb57" BIGINT  -- Persons In Custody Or On Bail During The Stage Of Trial At The End Of The Year,
  "persons_in_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

N 07–01 Persons Arrested By Sex And Age Group Ipc 2012

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_07_01_persons_arrested_by_sex_and_age_group_ipc_2012

54.4 kB
1,140 rows
16 columns

CREATE TABLE n_07_01_persons_arrested_by_sex_and_age_group_ipc_2012 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "male_below_18_years" BIGINT,
  "female_below_18_years" BIGINT,
  "male_between_18_30_years" BIGINT,
  "female_between_18_30_years" BIGINT,
  "male_between_30_45_years" BIGINT,
  "female_between_30_45_years" BIGINT,
  "male_between_45_60_years" BIGINT,
  "female_between_45_60_years" BIGINT,
  "male_above_60_years" BIGINT,
  "female_above_60_years" BIGINT,
  "male_total" BIGINT,
  "female_total" BIGINT,
  "grand_total" BIGINT
);

N 07–01 Persons Arrested By Sex And Age Group Ipc 2013

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_07_01_persons_arrested_by_sex_and_age_group_ipc_2013

54.4 kB
1,140 rows
16 columns

CREATE TABLE n_07_01_persons_arrested_by_sex_and_age_group_ipc_2013 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "male_below_18_years" BIGINT,
  "female_below_18_years" BIGINT,
  "male_between_18_30_years" BIGINT,
  "female_between_18_30_years" BIGINT,
  "male_between_30_45_years" BIGINT,
  "female_between_30_45_years" BIGINT,
  "male_between_45_60_years" BIGINT,
  "female_between_45_60_years" BIGINT,
  "male_above_60_years" BIGINT,
  "female_above_60_years" BIGINT,
  "male_total" BIGINT,
  "female_total" BIGINT,
  "grand_total" BIGINT
);

N 07–01 Persons Arrested By Sex And Age Group Ipc 2014

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_07_01_persons_arrested_by_sex_and_age_group_ipc_2014

123.54 kB
3,432 rows
19 columns

CREATE TABLE n_07_01_persons_arrested_by_sex_and_age_group_ipc_2014 (
  "index" BIGINT,
  "states_uts" VARCHAR,
  "crime_head" VARCHAR,
  "year" BIGINT,
  "n_18_and_above_and_below_30_years_male" BIGINT  -- 18 And Above And Below 30 Years Male,
  "n_18_and_above_and_below_30_years_female" BIGINT  -- 18 And Above And Below 30 Years Female,
  "n_18_and_above_and_below_30_years_total" BIGINT  -- 18 And Above And Below 30 Years Total,
  "n_30_and_above_and_below_45_years_male" BIGINT  -- 30 And Above And Below 45 Years Male,
  "n_30_and_above_and_below_45_years_female" BIGINT  -- 30 And Above And Below 45 Years Female,
  "n_30_and_above_and_below_45_years_total" BIGINT  -- 30 And Above And Below 45 Years Total,
  "n_45_and_above_and_below_60_years_male" BIGINT  -- 45 And Above And Below 60 Years Male,
  "n_45_and_above_and_below_60_years_female" BIGINT  -- 45 And Above And Below 60 Years Female,
  "n_45_and_above_and_below_60_years_total" BIGINT  -- 45 And Above And Below 60 Years Total,
  "n_60_years_and_above_male" BIGINT  -- 60 Years And Above Male,
  "n_60_years_and_above_female" BIGINT  -- 60 Years And Above Female,
  "n_60_years_and_above_total" BIGINT  -- 60 Years And Above Total,
  "total_male" BIGINT,
  "total_female" BIGINT,
  "total_persons_arrested_by_age_and_sex" BIGINT
);

N 07–02 Persons Arrested By Sex And Age Group Sll 2012

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_07_02_persons_arrested_by_sex_and_age_group_sll_2012

39.1 kB
1,026 rows
16 columns

CREATE TABLE n_07_02_persons_arrested_by_sex_and_age_group_sll_2012 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "male_below_18_years" BIGINT,
  "female_below_18_years" BIGINT,
  "male_between_18_30_years" BIGINT,
  "female_between_18_30_years" BIGINT,
  "male_between_30_45_years" BIGINT,
  "female_between_30_45_years" BIGINT,
  "male_between_45_60_years" BIGINT,
  "female_between_45_60_years" BIGINT,
  "male_above_60_years" BIGINT,
  "female_above_60_years" BIGINT,
  "male_total" BIGINT,
  "female_total" BIGINT,
  "grand_total" BIGINT
);

N 07–02 Persons Arrested By Sex And Age Group Sll 2013

@kaggle.thedevastator_crime_trends_in_india_from_2001_to_2020.n_07_02_persons_arrested_by_sex_and_age_group_sll_2013

38.89 kB
1,026 rows
16 columns

CREATE TABLE n_07_02_persons_arrested_by_sex_and_age_group_sll_2013 (
  "index" BIGINT,
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "male_below_18_years" BIGINT,
  "female_below_18_years" BIGINT,
  "male_between_18_30_years" BIGINT,
  "female_between_18_30_years" BIGINT,
  "male_between_30_45_years" BIGINT,
  "female_between_30_45_years" BIGINT,
  "male_between_45_60_years" BIGINT,
  "female_between_45_60_years" BIGINT,
  "male_above_60_years" BIGINT,
  "female_above_60_years" BIGINT,
  "male_total" BIGINT,
  "female_total" BIGINT,
  "grand_total" BIGINT
);