Crime Case Files 🔫⚔️

CREATE TABLE n_01_district_wise_crimes_committed_ipc_2001_2012 (
  "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_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
);

CREATE TABLE n_01_district_wise_crimes_committed_ipc_2013 (
  "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_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
);

CREATE TABLE n_01_district_wise_crimes_committed_ipc_2014 (
  "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_abduction" BIGINT,
  "kidnapping_abduction_in_order_to_murder" BIGINT,
  "kidnapping_for_ransom" BIGINT,
  "kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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
);

CREATE TABLE n_02_01_district_wise_crimes_committed_against_sc_2001_2012 (
  "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,
  "protection_of_civil_rights_pcr_act" BIGINT,
  "other_crimes_against_scs" BIGINT
);

CREATE TABLE n_02_01_district_wise_crimes_committed_against_sc_2013 (
  "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,
  "prevention_of_atrocities_poa_act" BIGINT,
  "other_crimes_against_scs" BIGINT
);

CREATE TABLE n_02_01_district_wise_crimes_committed_against_sc_2014 (
  "states_uts" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "protection_of_civil_rights_act_1955" BIGINT,
  "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_kidnaping_abduction_total" BIGINT,
  "poa_kidnaping_abduction_in_order_to_murder" BIGINT,
  "poa_kidnapping_for_ransom" BIGINT,
  "poa_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT,
  "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,
  "total_of_sc_st_prevention_of_atrocities_act_1989" BIGINT,
  "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_kidnaping_abduction" BIGINT,
  "ipc_kidnaping_abduction_in_order_to_murder" BIGINT,
  "ipc_kidnapping_for_ransom" BIGINT,
  "ipc_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT,
  "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,
  "other_sll_crime_against_scs" BIGINT,
  "total_crimes_against_scs" BIGINT
);

CREATE TABLE n_02_district_wise_crimes_committed_against_st_2001_2012 (
  "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,
  "prevention_of_atrocities_poa_act" BIGINT,
  "other_crimes_against_sts" BIGINT
);

CREATE TABLE n_02_district_wise_crimes_committed_against_st_2013 (
  "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,
  "prevention_of_atrocities_poa_act" BIGINT,
  "other_crimes_against_sts" BIGINT
);

CREATE TABLE n_02_district_wise_crimes_committed_against_st_2014 (
  "states_uts" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "protection_of_civil_rights_act_1955" BIGINT,
  "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_kidnaping_abduction_total" BIGINT,
  "poa_kidnaping_abduction_in_order_to_murder" BIGINT,
  "poa_kidnapping_for_ransom" BIGINT,
  "poa_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT,
  "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,
  "total_of_sc_st_prevention_of_atrocities_act_1989" BIGINT,
  "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_kidnaping_abduction" BIGINT,
  "ipc_kidnaping_abduction_in_order_to_murder" BIGINT,
  "ipc_kidnapping_for_ransom" BIGINT,
  "ipc_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT,
  "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,
  "other_sll_crime_against_sts" BIGINT,
  "total_crimes_against_sts" BIGINT
);

CREATE TABLE n_03_district_wise_crimes_committed_against_children_2001_2012 (
  "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
);

CREATE TABLE n_03_district_wise_crimes_committed_against_children_2013 (
  "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
);

CREATE TABLE n_03_persons_arrested_and_their_disposal_by_police_and_6ed108b0 (
  "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_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_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
);

CREATE TABLE n_03_persons_arrested_and_their_disposal_by_police_and_7e201ad0 (
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT,
  "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_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

CREATE TABLE n_03_persons_arrested_and_their_disposal_by_police_and_fea05944 (
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT,
  "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_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

CREATE TABLE n_04_01_person_arrested_and_their_disposal_by_police_a_1a9d3577 (
  "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_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_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
);

CREATE TABLE n_04_01_person_arrested_and_their_disposal_by_police_a_6f8e2765 (
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT,
  "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_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

CREATE TABLE n_04_01_person_arrested_and_their_disposal_by_police_a_9dfccd11 (
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT,
  "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_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

CREATE TABLE n_04_02_person_arrested_and_their_disposal_by_police_a_79e07b9f (
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT,
  "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_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

CREATE TABLE n_04_02_person_arrested_and_their_disposal_by_police_a_85125627 (
  "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_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_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
);

CREATE TABLE n_04_02_person_arrested_and_their_disposal_by_police_a_d4bb9e32 (
  "state_ut" VARCHAR,
  "crime_head" VARCHAR,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_68051b9b" BIGINT,
  "persons_arrested_during_the_year" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT,
  "persons_in_custody_or_on_bail_during_the_stage_of_inve_05a9d1c5" BIGINT,
  "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_whose_cases_trials_were_completed_during_the_year" BIGINT,
  "persons_convicted" BIGINT,
  "persons_acquitted" BIGINT
);

CREATE TABLE n_07_01_persons_arrested_by_sex_and_age_group_ipc_2012 (
  "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
);

CREATE TABLE n_07_01_persons_arrested_by_sex_and_age_group_ipc_2013 (
  "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
);

CREATE TABLE n_07_01_persons_arrested_by_sex_and_age_group_ipc_2014 (
  "states_uts" VARCHAR,
  "crime_head" VARCHAR,
  "year" BIGINT,
  "n_18_and_above_and_below_30_years_male" BIGINT,
  "n_18_and_above_and_below_30_years_female" BIGINT,
  "n_18_and_above_and_below_30_years_total" BIGINT,
  "n_30_and_above_and_below_45_years_male" BIGINT,
  "n_30_and_above_and_below_45_years_female" BIGINT,
  "n_30_and_above_and_below_45_years_total" BIGINT,
  "n_45_and_above_and_below_60_years_male" BIGINT,
  "n_45_and_above_and_below_60_years_female" BIGINT,
  "n_45_and_above_and_below_60_years_total" BIGINT,
  "n_60_years_and_above_male" BIGINT,
  "n_60_years_and_above_female" BIGINT,
  "n_60_years_and_above_total" BIGINT,
  "total_male" BIGINT,
  "total_female" BIGINT,
  "total_persons_arrested_by_age_and_sex" BIGINT
);

CREATE TABLE n_07_02_persons_arrested_by_sex_and_age_group_sll_2012 (
  "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
);

CREATE TABLE n_07_02_persons_arrested_by_sex_and_age_group_sll_2013 (
  "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
);