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

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

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 Total,
  "kidnapping_abduction" BIGINT  -- Kidnapping & Abduction,
  "kidnapping_abduction_in_order_to_murder" BIGINT  -- Kidnapping & Abduction In Order To Murder,
  "kidnapping_for_ransom" BIGINT,
  "kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- Kidnapping & 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 & 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 & 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 & 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
);

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  -- Prevention Of Atrocities (POA) Act,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "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  -- Protection Of Civil Rights (PCR) Act,
  "prevention_of_atrocities_poa_act" BIGINT  -- Prevention Of Atrocities (POA) Act,
  "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  -- 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 & Abduction GrandTotal,
  "poa_kidnaping_abduction_total" BIGINT  -- POA Kidnaping & Abduction Total,
  "poa_kidnaping_abduction_in_order_to_murder" BIGINT  -- POA Kidnaping & Abduction In Order To Murder,
  "poa_kidnapping_for_ransom" BIGINT,
  "poa_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- POA Kidnapping & 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 & Abduction,
  "ipc_kidnaping_abduction" BIGINT  -- IPC Kidnaping & Abduction,
  "ipc_kidnaping_abduction_in_order_to_murder" BIGINT  -- IPC Kidnaping & Abduction In Order To Murder,
  "ipc_kidnapping_for_ransom" BIGINT,
  "ipc_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- IPC Kidnapping & 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
);

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  -- Protection Of Civil Rights (PCR) Act,
  "prevention_of_atrocities_poa_act" BIGINT  -- Prevention Of Atrocities (POA) Act,
  "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  -- Protection Of Civil Rights (PCR) Act,
  "prevention_of_atrocities_poa_act" BIGINT  -- Prevention Of Atrocities (POA) Act,
  "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  -- 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 & Abduction GrandTotal,
  "poa_kidnaping_abduction_total" BIGINT  -- POA Kidnaping & Abduction Total,
  "poa_kidnaping_abduction_in_order_to_murder" BIGINT  -- POA Kidnaping & Abduction In Order To Murder,
  "poa_kidnapping_for_ransom" BIGINT,
  "poa_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- POA Kidnapping & 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 & Abduction,
  "ipc_kidnaping_abduction" BIGINT  -- IPC Kidnaping & Abduction,
  "ipc_kidnaping_abduction_in_order_to_murder" BIGINT  -- IPC Kidnaping & Abduction In Order To Murder,
  "ipc_kidnapping_for_ransom" BIGINT,
  "ipc_kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT  -- IPC Kidnapping & 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
);

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE n_08_01_juvenile_apprehended_state_ipc (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "crime" VARCHAR,
  "boys_7_12_years" BIGINT,
  "girls_7_12_years" BIGINT,
  "boys_12_16_years" BIGINT,
  "girls_12_16_years" BIGINT,
  "boys_16_18_years" BIGINT,
  "girls_16_18_years" BIGINT,
  "total_for_boys_all_age_groups" BIGINT,
  "total_for_girls_all_age_groups" BIGINT,
  "grand_total" BIGINT
);

CREATE TABLE n_08_02_juvenile_apprehended_state_sll (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "crime" VARCHAR,
  "boys_7_12_years" BIGINT,
  "girls_7_12_years" BIGINT,
  "boys_12_16_years" BIGINT,
  "girls_12_16_years" BIGINT,
  "boys_16_18_years" BIGINT,
  "girls_16_18_years" BIGINT,
  "total_for_boys_all_age_groups" BIGINT,
  "total_for_girls_all_age_groups" BIGINT,
  "grand_total" BIGINT
);

CREATE TABLE n_09_juveniles_arrested_and_their_disposal (
  "area_name" VARCHAR,
  "year" BIGINT,
  "juveniles_acquitted_or_otherwise_disposed_of" BIGINT,
  "juveniles_arrested" BIGINT,
  "juveniles_dealt_with_fine" BIGINT,
  "juveniles_released_on_probation_and_placed_under_the_c_3c4d70f1" BIGINT  -- Juveniles Released On Probation And Placed Under The Care Of Fit Institutions,
  "juveniles_released_on_probation_and_placed_under_the_c_ee64b8c3" BIGINT  -- Juveniles Released On Probation And Placed Under The Care Of Parent Guardian,
  "juveniles_sent_home_after_advice_or_admonition" BIGINT,
  "juveniles_sent_to_special_home" BIGINT,
  "juveniles_whose_cases_pending_disposal" BIGINT
);

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

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

CREATE TABLE n_12_police_strength_actual_and_sanctioned (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "rank_all_ranks_total" BIGINT,
  "rank_asi_equivalent" BIGINT,
  "rank_aspdyspassttcommandant" BIGINT,
  "rank_below_hc_and_above_constables" BIGINT,
  "rank_constables" BIGINT,
  "rank_dgaddl_dg" BIGINT,
  "rank_dig" BIGINT,
  "rank_head_constables" BIGINT,
  "rank_igsplig" BIGINT,
  "rank_inspectors_equivalent" BIGINT,
  "rank_si_equivalent" BIGINT,
  "rank_sspspaddlspcommandant" BIGINT
);

CREATE TABLE n_13_police_killed_or_injured_on_duty (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "police_injured_by_criminals" BIGINT,
  "police_injured_by_riotous_mobs" BIGINT,
  "police_injured_in_accidents" BIGINT,
  "police_injured_in_dacoity_operationsother_raids" BIGINT,
  "police_injured_in_terroristsextremists_operations" BIGINT,
  "police_injured_on_border_duties" BIGINT,
  "police_injured_total_policemen" BIGINT,
  "police_killed_by_criminals" BIGINT,
  "police_killed_by_riotous_mobs" BIGINT,
  "police_killed_in_accidents" BIGINT,
  "police_killed_in_dacoity_operationsother_raids" BIGINT,
  "police_killed_in_terroristsextremists_operations" BIGINT,
  "police_killed_on_border_duties" BIGINT,
  "police_killed_total_policemen" BIGINT
);

CREATE TABLE n_14_age_profile_of_police_personnel_killed_on_duty (
  "area_name" VARCHAR,
  "year" BIGINT,
  "age_18_25_yrs" BIGINT,
  "age_25_35_yrs" BIGINT,
  "age_35_45_yrs" BIGINT,
  "age_45_55_yrs" BIGINT,
  "age_above_55_yrs" BIGINT,
  "age_total" BIGINT
);

CREATE TABLE n_15_police_natural_death_and_suicide (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "age_18_25_yrs" BIGINT,
  "age_25_35_yrs" BIGINT,
  "age_35_45_yrs" BIGINT,
  "age_45_55_yrs" BIGINT,
  "age_above_55_yrs" BIGINT,
  "age_total" BIGINT
);

CREATE TABLE n_16_casualties_under_police_firing_and_lathi_charge (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "civilians_injured" BIGINT,
  "civilians_killed" BIGINT,
  "no_of_firings" BIGINT,
  "policemen_injured" BIGINT,
  "policemen_killed" BIGINT
);

CREATE TABLE n_17_case_reported_and_value_of_property_taken_away_by_2c1593e4 (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "place_of_occurrence" VARCHAR,
  "dacoity_section_395_398_ipc_number_of_cases_registered" BIGINT  -- Dacoity (Section 395-398 IPC) - Number Of Cases Registered,
  "dacoity_section_395_398_ipc_value_of_property_stolen_in_rupees" BIGINT  -- Dacoity (Section 395-398 IPC) - Value Of Property Stolen (in Rupees),
  "robbery_section_392_394_397_398_ipc_number_of_cases_registered" BIGINT  -- Robbery(Section 392-394, 397, 398 IPC) - Number Of Cases Registered,
  "robbery_section_392_394_397_398_ipc_value_of_property__c9c55ffc" BIGINT  -- Robbery(Section 392-394, 397, 398 IPC) - Value Of Property Stolen (in Rupees),
  "burglary_section_449_452_454_455_457_460_ipc_number_of_3c6dddb5" BIGINT  -- Burglary(Section 449-452, 454, 455, 457-460 IPC) - Number Of Cases Registered,
  "burglary_section_449_452_454_455_457_460_ipc_value_of__5a2d9c23" BIGINT  -- Burglary(Section 449-452, 454, 455, 457-460 IPC) - Value Of Property Stolen (in Rupees),
  "theft_section_379_382_ipc_number_of_cases_registered" BIGINT  -- Theft (Section 379-382 IPC) - Number Of Cases Registered,
  "theft_section_379_382_ipc_value_of_property_stolen_in_rupees" BIGINT  -- Theft (Section 379-382 IPC) - Value Of Property Stolen (in Rupees)
);

CREATE TABLE n_17_case_reported_and_value_of_property_taken_away_by_a93c57ca (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "place_of_occurrence" VARCHAR,
  "dacoity_section_395_398_ipc_number_of_cases_registered" BIGINT  -- Dacoity (Section 395-398 IPC) - Number Of Cases Registered,
  "dacoity_section_395_398_ipc_value_of_property_stolen_in_rupees" BIGINT  -- Dacoity (Section 395-398 IPC) - Value Of Property Stolen (in Rupees),
  "robbery_section_392_394_397_398_ipc_number_of_cases_registered" BIGINT  -- Robbery(Section 392-394, 397, 398 IPC) - Number Of Cases Registered,
  "robbery_section_392_394_397_398_ipc_value_of_property__c9c55ffc" BIGINT  -- Robbery(Section 392-394, 397, 398 IPC) - Value Of Property Stolen (in Rupees),
  "burglary_section_449_452_454_455_457_460_ipc_number_of_3c6dddb5" BIGINT  -- Burglary(Section 449-452, 454, 455, 457-460 IPC) - Number Of Cases Registered,
  "burglary_section_449_452_454_455_457_460_ipc_value_of__5a2d9c23" BIGINT  -- Burglary(Section 449-452, 454, 455, 457-460 IPC) - Value Of Property Stolen (in Rupees),
  "theft_section_379_382_ipc_number_of_cases_registered" BIGINT  -- Theft (Section 379-382 IPC) - Number Of Cases Registered,
  "theft_section_379_382_ipc_value_of_property_stolen_in_rupees" BIGINT  -- Theft (Section 379-382 IPC) - Value Of Property Stolen (in Rupees)
);

CREATE TABLE n_17_crime_by_place_of_occurrence_2001_2012 (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "residential_premises_dacoity" BIGINT  -- RESIDENTIAL PREMISES - Dacoity,
  "residential_premises_robbery" BIGINT  -- RESIDENTIAL PREMISES - Robbery,
  "residential_premises_burglary" BIGINT  -- RESIDENTIAL PREMISES - Burglary,
  "residential_premises_theft" BIGINT  -- RESIDENTIAL PREMISES - Theft,
  "highways_dacoity" BIGINT  -- HIGHWAYS - Dacoity,
  "highways_robbery" BIGINT  -- HIGHWAYS - Robbery,
  "highways_burglary" BIGINT  -- HIGHWAYS - Burglary,
  "highways_theft" BIGINT  -- HIGHWAYS - Theft,
  "river_and_sea_dacoity" BIGINT  -- RIVER And SEA - Dacoity,
  "river_and_sea_robbery" BIGINT  -- RIVER And SEA - Robbery,
  "river_and_sea_burglary" BIGINT  -- RIVER And SEA - Burglary,
  "river_and_sea_theft" BIGINT  -- RIVER And SEA - Theft,
  "railways_dacoity" BIGINT  -- RAILWAYS - Dacoity,
  "railways_robbery" BIGINT  -- RAILWAYS - Robbery,
  "railways_burglary" BIGINT  -- RAILWAYS - Burglary,
  "railways_theft" BIGINT  -- RAILWAYS - Theft,
  "banks_dacoity" BIGINT  -- BANKS - Dacoity,
  "banks_robbery" BIGINT  -- BANKS - Robbery,
  "banks_burglary" BIGINT  -- BANKS - Burglary,
  "banks_theft" BIGINT  -- BANKS - Theft,
  "commercial_establishments_dacoity" BIGINT  -- COMMERCIAL ESTABLISHMENTS - Dacoity,
  "commercial_establishments_robbery" BIGINT  -- COMMERCIAL ESTABLISHMENTS - Robbery,
  "commercial_establishments_burglary" BIGINT  -- COMMERCIAL ESTABLISHMENTS - Burglary,
  "commercial_establishments_theft" BIGINT  -- COMMERCIAL ESTABLISHMENTS - Theft,
  "other_places_dacoity" BIGINT  -- OTHER PLACES - Dacoity,
  "other_places_robbery" BIGINT  -- OTHER PLACES - Robbery,
  "other_places_burglary" BIGINT  -- OTHER PLACES - Burglary,
  "other_places_theft" BIGINT  -- OTHER PLACES - Theft,
  "total_dacoity" BIGINT  -- TOTAL - Dacoity,
  "total_robbery" BIGINT  -- TOTAL - Robbery,
  "total_burglary" BIGINT  -- TOTAL - Burglary,
  "total_theft" BIGINT  -- TOTAL - Theft
);

CREATE TABLE n_17_crime_by_place_of_occurrence_2013 (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "residential_premises_dacoity" BIGINT  -- RESIDENTIAL PREMISES - Dacoity,
  "residential_premises_robbery" BIGINT  -- RESIDENTIAL PREMISES - Robbery,
  "residential_premises_burglary" BIGINT  -- RESIDENTIAL PREMISES - Burglary,
  "residential_premises_theft" BIGINT  -- RESIDENTIAL PREMISES - Theft,
  "highways_dacoity" BIGINT  -- HIGHWAYS - Dacoity,
  "highways_robbery" BIGINT  -- HIGHWAYS - Robbery,
  "highways_burglary" BIGINT  -- HIGHWAYS - Burglary,
  "highways_theft" BIGINT  -- HIGHWAYS - Theft,
  "river_and_sea_dacoity" BIGINT  -- RIVER And SEA - Dacoity,
  "river_and_sea_robbery" BIGINT  -- RIVER And SEA - Robbery,
  "river_and_sea_burglary" BIGINT  -- RIVER And SEA - Burglary,
  "river_and_sea_theft" BIGINT  -- RIVER And SEA - Theft,
  "railways_dacoity" BIGINT  -- RAILWAYS - Dacoity,
  "railways_robbery" BIGINT  -- RAILWAYS - Robbery,
  "railways_burglary" BIGINT  -- RAILWAYS - Burglary,
  "railways_theft" BIGINT  -- RAILWAYS - Theft,
  "banks_dacoity" BIGINT  -- BANKS - Dacoity,
  "banks_robbery" BIGINT  -- BANKS - Robbery,
  "banks_burglary" BIGINT  -- BANKS - Burglary,
  "banks_theft" BIGINT  -- BANKS - Theft,
  "commercial_establishments_dacoity" BIGINT  -- COMMERCIAL ESTABLISHMENTS - Dacoity,
  "commercial_establishments_robbery" BIGINT  -- COMMERCIAL ESTABLISHMENTS - Robbery,
  "commercial_establishments_burglary" BIGINT  -- COMMERCIAL ESTABLISHMENTS - Burglary,
  "commercial_establishments_theft" BIGINT  -- COMMERCIAL ESTABLISHMENTS - Theft,
  "other_places_dacoity" BIGINT  -- OTHER PLACES - Dacoity,
  "other_places_robbery" BIGINT  -- OTHER PLACES - Robbery,
  "other_places_burglary" BIGINT  -- OTHER PLACES - Burglary,
  "other_places_theft" BIGINT  -- OTHER PLACES - Theft,
  "total_dacoity" BIGINT  -- TOTAL - Dacoity,
  "total_robbery" BIGINT  -- TOTAL - Robbery,
  "total_burglary" BIGINT  -- TOTAL - Burglary,
  "total_theft" BIGINT  -- TOTAL - Theft
);

CREATE TABLE n_17_crime_by_place_of_occurrence_2014 (
  "states_uts" VARCHAR,
  "year" BIGINT,
  "residence_dacoity_cases_reported" BIGINT,
  "residence_dacoity_value_of_property_stolen" BIGINT,
  "residence_robbery_cases_reported" BIGINT,
  "residence_robbery_value_of_property_stolen" BIGINT,
  "residence_burglary_cases_reported" BIGINT,
  "residence_burglary_value_of_property_stolen" BIGINT,
  "residence_theft_cases_reported" BIGINT,
  "residence_theft_value_of_property_stolen" BIGINT,
  "highways_dacoity_cases_reported" BIGINT,
  "highways_dacoity_value_of_property_stolen" BIGINT,
  "highways_robbery_cases_reported" BIGINT,
  "highways_robbery_value_of_property_stolen" BIGINT,
  "highways_burglary_cases_reported" BIGINT,
  "highways_burglary_value_of_property_stolen" BIGINT,
  "highways_theft_cases_reported" BIGINT,
  "highways_theft_value_of_property_stolen" BIGINT,
  "riverorsea_dacoity_cases_reported" BIGINT,
  "riverorsea_dacoity_value_of_property_stolen" BIGINT,
  "riverorsea_robbery_cases_reported" BIGINT,
  "riverorsea_robbery_value_of_property_stolen" BIGINT,
  "riverorsea_burglary_cases_reported" BIGINT,
  "riverorsea_burglary_value_of_property_stolen" BIGINT,
  "riverorsea_theft_cases_reported" BIGINT,
  "riverorsea_theft_value_of_property_stolen" BIGINT,
  "railways_dacoity_cases_reported" BIGINT,
  "railways_dacoity_value_of_property_stolen" BIGINT,
  "railways_robbery_cases_reported" BIGINT,
  "railways_robbery_value_of_property_stolen" BIGINT,
  "railways_burglary_cases_reported" BIGINT,
  "railways_burglary_value_of_property_stolen" BIGINT,
  "railways_theft_cases_reported" BIGINT,
  "railways_theft_value_of_property_stolen" BIGINT,
  "religious_places_dacoity_cases_reported" BIGINT,
  "religious_places_dacoity_value_of_property_stolen" BIGINT,
  "religious_places_robbery_cases_reported" BIGINT,
  "religious_places_robbery_value_of_property_stolen" BIGINT,
  "religious_places_burglary_cases_reported" BIGINT,
  "religious_places_burglary_value_of_property_stolen" DOUBLE,
  "religious_places_theft_cases_reported" BIGINT,
  "religious_places_theft_value_of_property_stolen" BIGINT,
  "atm_dacoity_cases_reported" BIGINT,
  "atm_dacoity_value_of_property_stolen" BIGINT,
  "atm_robbery_cases_reported" BIGINT,
  "atm_robbery_value_of_property_stolen" BIGINT,
  "atm_burglary_cases_reported" BIGINT,
  "atm_burglary_value_of_property_stolen" BIGINT,
  "atm_theft_cases_reported" BIGINT,
  "atm_theft_value_of_property_stolen" BIGINT,
  "bank_dacoity_cases_reported" BIGINT,
  "bank_dacoity_value_of_property_stolen" BIGINT,
  "bank_robbery_cases_reported" BIGINT,
  "bank_robbery_value_of_property_stolen" BIGINT,
  "bank_burglary_cases_reported" BIGINT,
  "bank_burglary_value_of_property_stolen" BIGINT,
  "bank_theft_cases_reported" BIGINT,
  "bank_theft_value_of_property_stolen" BIGINT,
  "commest_dacoity_cases_reported" BIGINT,
  "commest_dacoity_value_of_property_stolen" BIGINT,
  "commest_robbery_cases_reported" BIGINT,
  "commest_robbery_value_of_property_stolen" BIGINT,
  "commest_burglary_cases_reported" BIGINT,
  "commest_burglary_value_of_property_stolen" BIGINT,
  "commest_theft_cases_reported" BIGINT,
  "commest_theft_value_of_property_stolen" BIGINT,
  "otherplaces_dacoity_cases_reported" BIGINT,
  "otherplaces_dacoity_value_of_property_stolen" BIGINT,
  "otherplaces_robbery_cases_reported" BIGINT,
  "otherplaces_robbery_value_of_property_stolen" BIGINT,
  "otherplaces_burglary_cases_reported" BIGINT,
  "otherplaces_burglary_value_of_property_stolen" BIGINT,
  "otherplaces_theft_cases_reported" BIGINT,
  "otherplaces_theft_value_of_property_stolen" BIGINT,
  "total_dacoity_cases_reported" BIGINT,
  "total_dacoity_value_of_property_stolen" BIGINT,
  "total_robbery_cases_reported" BIGINT,
  "total_robbery_value_of_property_stolen" BIGINT,
  "total_burglary_cases_reported" BIGINT,
  "total_burglary_value_of_property_stolen" DOUBLE,
  "total_theft_cases_reported" BIGINT,
  "total_theft_value_of_property_stolen" BIGINT
);