Crime Case Files 🔫⚔️

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

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_42_district_wise_crimes_committed_against_women_2001_2012 (
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "rape" BIGINT,
  "kidnapping_and_abduction" 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" 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_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_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_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_18_04_juveniles_arrested_recidivism (
  "area_name" VARCHAR,
  "year" BIGINT,
  "sub_group_name" VARCHAR,
  "recidivism_new_delinquent" BIGINT,
  "recidivism_old_delinquent" BIGINT,
  "recidivism_total" 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_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_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_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_value_of_property_stolen_in_rupees" BIGINT,
  "robbery_section_392_394_397_398_ipc_number_of_cases_registered" BIGINT,
  "robbery_section_392_394_397_398_ipc_value_of_property__c9c55ffc" BIGINT,
  "burglary_section_449_452_454_455_457_460_ipc_number_of_3c6dddb5" BIGINT,
  "burglary_section_449_452_454_455_457_460_ipc_value_of__5a2d9c23" BIGINT,
  "theft_section_379_382_ipc_number_of_cases_registered" BIGINT,
  "theft_section_379_382_ipc_value_of_property_stolen_in_rupees" BIGINT
);

CREATE TABLE n_23_anti_corruprion_cases (
  "area_name" VARCHAR,
  "year" BIGINT,
  "ac01_no_of_cases_pending_investigation_from_previous_year" DOUBLE,
  "ac02_no_of_cases_registered_during_the_year" DOUBLE,
  "ac03_total_no_of_cases_for_investigation_during_the_year" DOUBLE,
  "ac04_no_of_cases_investigated_during_the_year" DOUBLE,
  "ac05_no_of_cases_not_investigatedor_in_which_investiga_d6413c7a" DOUBLE,
  "ac06_no_of_cases_transferred_to_local_police_during_the_year" DOUBLE,
  "ac07_no_of_cases_declared_false_mistake_of_fact_or_of__2d1a2451" DOUBLE,
  "ac08_no_of_cases_in_which_charge_sheets_were_laid_duri_6294269c" DOUBLE,
  "ac09_no_of_cases_pending_departmental_sanction_for_pro_d670f501" DOUBLE,
  "ac10_no_of_cases_sent_up_for_trial_and_also_reported_f_41635e49" DOUBLE,
  "ac11_no_of_cases_reported_for_regular_departmental_act_50b4a53c" DOUBLE,
  "ac12_no_of_cases_reported_for_suitable_action_during_the_year" DOUBLE,
  "ac13_no_of_cases_in_which_charge_sheets_were_not_laid__193a1bbf" DOUBLE,
  "ac14_no_of_cases_pending_investigation_at_the_end_of_the_year" DOUBLE,
  "ac15_no_of_cases_resulted_in_recoveries_or_seizures_du_0c5c6e2e" DOUBLE,
  "ac16_value_of_property_recoveredseized_during_the_year_in_rs" DOUBLE,
  "ac17_percentage_of_cases_charge_sheeted_to_total_cases_f7949f22" DOUBLE,
  "ac18_no_of_cases_pending_trial_from_the_previous_year" DOUBLE,
  "ac19_no_of_cases_sent_up_for_trial_during_the_year" DOUBLE,
  "ac20_total_no_of_cases_for_trial_during_the_year" DOUBLE,
  "ac21_no_of_cases_withdrawn_or_other_wise_disposed_off__8ff51e05" DOUBLE,
  "ac22_no_of_cases_in_which_trials_were_completed_during_the_year" DOUBLE,
  "ac23_no_of_cases_convicted_during_the_year" DOUBLE,
  "ac24_no_of_cases_acquitted_or_discharged_during_the_year" DOUBLE,
  "ac25_no_of_cases_pending_trial_at_the_end_of_the_year" DOUBLE,
  "ac26_percentage_of_cases_convicted_to_cases_in_which_t_f8f82422" DOUBLE,
  "ac27_total_amount_of_fine_imposed_during_the_year_in_rs" DOUBLE
);

CREATE TABLE n_25_complaints_against_police (
  "area_name" VARCHAR,
  "year" BIGINT,
  "sub_group" VARCHAR,
  "cpa_cases_registered" BIGINT,
  "cpa_cases_reported_for_dept_action" BIGINT,
  "cpa_complaints_cases_declared_false_unsubstantiated" BIGINT,
  "cpa_complaints_received_alleged" BIGINT,
  "cpa_no_of_departmental_enquiries" BIGINT,
  "cpa_no_of_magisterial_enquiries" BIGINT,
  "cpa_cases_sent_for_trials_charge_sheeted" BIGINT,
  "cpa_no_of_judicial_enquiries" BIGINT,
  "cpb_police_personnel_acquitted" BIGINT,
  "cpb_police_personnel_convicted" BIGINT,
  "cpb_police_personnel_sent_up_for_trial" BIGINT,
  "cpb_police_personnel_trial_completed" BIGINT,
  "cpb_police_personnel_cases_withdrawn_or_otherwise_disposed_of" BIGINT,
  "cpc_police_personnel_cases_trial_completed" BIGINT,
  "cpc_police_personnel_cases_withdrawn_or_otherwise_disposed_of" BIGINT,
  "cpc_police_personnel_disciplinary_action_initiated" BIGINT,
  "cpc_police_personnel_dismissal_removal_from_service" BIGINT,
  "cpc_police_personnel_major_punishment_awarded" BIGINT,
  "cpc_police_personnel_minor_punishment_awarded" BIGINT
);

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_17_crime_by_place_of_occurrence_2001_2012 (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "residential_premises_dacoity" BIGINT,
  "residential_premises_robbery" BIGINT,
  "residential_premises_burglary" BIGINT,
  "residential_premises_theft" BIGINT,
  "highways_dacoity" BIGINT,
  "highways_robbery" BIGINT,
  "highways_burglary" BIGINT,
  "highways_theft" BIGINT,
  "river_and_sea_dacoity" BIGINT,
  "river_and_sea_robbery" BIGINT,
  "river_and_sea_burglary" BIGINT,
  "river_and_sea_theft" BIGINT,
  "railways_dacoity" BIGINT,
  "railways_robbery" BIGINT,
  "railways_burglary" BIGINT,
  "railways_theft" BIGINT,
  "banks_dacoity" BIGINT,
  "banks_robbery" BIGINT,
  "banks_burglary" BIGINT,
  "banks_theft" BIGINT,
  "commercial_establishments_dacoity" BIGINT,
  "commercial_establishments_robbery" BIGINT,
  "commercial_establishments_burglary" BIGINT,
  "commercial_establishments_theft" BIGINT,
  "other_places_dacoity" BIGINT,
  "other_places_robbery" BIGINT,
  "other_places_burglary" BIGINT,
  "other_places_theft" BIGINT,
  "total_dacoity" BIGINT,
  "total_robbery" BIGINT,
  "total_burglary" BIGINT,
  "total_theft" 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_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_27_nature_of_complaints_received_by_police (
  "area_name" VARCHAR,
  "year" BIGINT,
  "pc1_oral_complaints" DOUBLE,
  "pc2_written_complaints" BIGINT,
  "pc3_distress_call_over_phoneno_100_etc" DOUBLE,
  "pc4_complaints_initiated_sue_motto_by_police" DOUBLE,
  "pc5_total_complaints_sum_of_1_4_above" BIGINT,
  "pc6_total_complaints_as_recorded_in_gd" DOUBLE,
  "pc7_ipc_cases_registered" BIGINT,
  "pc8_sll_cases_registered" BIGINT
);

CREATE TABLE n_36_police_housing (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "ph_houses_provided_by_department" DOUBLE,
  "ph_houses_provided_on_leaserentgpra" DOUBLE,
  "ph_sanctioned_strength" BIGINT
);

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

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_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_37_home_guards_and_auxilliary_force (
  "area_name" VARCHAR,
  "year" BIGINT,
  "hg_lower_subordinates_actual_strength" DOUBLE,
  "hg_lower_subordinates_sanctioned_strength" DOUBLE,
  "hg_officers_actual_strength" DOUBLE,
  "hg_officers_sanctioned_strength" DOUBLE,
  "hg_upper_subordinates_actual_strength" DOUBLE,
  "hg_upper_subordinates_sanctioned_strength" DOUBLE
);

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_39_specific_purpose_of_kidnapping_and_abduction (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "k_a_cases_reported" DOUBLE,
  "k_a_female_10_15_years" DOUBLE,
  "k_a_female_15_18_years" DOUBLE,
  "k_a_female_18_30_years" DOUBLE,
  "k_a_female_30_50_years" DOUBLE,
  "k_a_female_above_50_years" DOUBLE,
  "k_a_female_total" DOUBLE,
  "k_a_female_upto_10_years" DOUBLE,
  "k_a_grand_total" DOUBLE,
  "k_a_male_10_15_years" DOUBLE,
  "k_a_male_15_18_years" DOUBLE,
  "k_a_male_18_30_years" DOUBLE,
  "k_a_male_30_50_years" DOUBLE,
  "k_a_male_above_50_years" DOUBLE,
  "k_a_male_total" DOUBLE,
  "k_a_male_upto_10_years" DOUBLE
);

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_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_19_motive_or_cause_of_murder_and_culpable_homicide_n_1970921c (
  "area_name" VARCHAR,
  "year" BIGINT,
  "chnamurder_cause_by_terroristextremist" BIGINT,
  "chnamurder_cause_casteism" BIGINT,
  "chnamurder_cause_class_conflict" BIGINT,
  "chnamurder_cause_communalism" BIGINT,
  "chnamurder_cause_dowry" BIGINT,
  "chnamurder_cause_for_political_reason" BIGINT,
  "chnamurder_cause_gain" BIGINT,
  "chnamurder_cause_love_affairssexual_relations" BIGINT,
  "chnamurder_cause_lunacy" BIGINT,
  "chnamurder_cause_other_causes_or_motives" BIGINT,
  "chnamurder_cause_personal_vendetta_or_enmity" BIGINT,
  "chnamurder_cause_property_dispute" BIGINT,
  "chnamurder_cause_total" BIGINT,
  "chnamurder_cause_witchcraft" BIGINT,
  "murder_cause_by_terroristextremist" BIGINT,
  "murder_cause_casteism" BIGINT,
  "murder_cause_class_conflict" BIGINT,
  "murder_cause_communalism" BIGINT,
  "murder_cause_dowry" BIGINT,
  "murder_cause_for_political_reason" BIGINT,
  "murder_cause_gain" BIGINT,
  "murder_cause_love_affairssexual_relations" BIGINT,
  "murder_cause_lunacy" BIGINT,
  "murder_cause_other_causes_or_motives" BIGINT,
  "murder_cause_personal_vendetta_or_enmity" BIGINT,
  "murder_cause_property_dispute" BIGINT,
  "murder_cause_total" BIGINT,
  "murder_cause_witchcraft" BIGINT
);

CREATE TABLE n_34_use_of_fire_arms_in_murder_cases (
  "area_name" VARCHAR,
  "year" BIGINT,
  "victims_of_murder_by_fire_arms" BIGINT,
  "victims_of_murder_by_licensed_arms" DOUBLE,
  "victims_of_murder_by_un_licensedimprovisedcrudecountry_538b039e" DOUBLE
);

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_43_arrests_under_crime_against_women (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "persons_acquitted" BIGINT,
  "persons_against_whom_cases_compounded_or_withdrawn" BIGINT,
  "persons_arrested" BIGINT,
  "persons_chargesheeted" BIGINT,
  "persons_convicted" BIGINT,
  "persons_in_custody_or_on_bail_during_investigation_at__30a0e7fb" BIGINT,
  "persons_in_custody_or_on_bail_during_investigation_at_year_end" BIGINT,
  "persons_in_custody_or_on_bail_during_trial_at_year_end" BIGINT,
  "persons_released_or_freed_by_police_or_magistrate_befo_efa0e070" BIGINT,
  "persons_trial_completed" BIGINT,
  "persons_under_trial_at_year_beginning" BIGINT,
  "total_persons_under_trial" BIGINT
);

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

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_value_of_property_stolen_in_rupees" BIGINT,
  "robbery_section_392_394_397_398_ipc_number_of_cases_registered" BIGINT,
  "robbery_section_392_394_397_398_ipc_value_of_property__c9c55ffc" BIGINT,
  "burglary_section_449_452_454_455_457_460_ipc_number_of_3c6dddb5" BIGINT,
  "burglary_section_449_452_454_455_457_460_ipc_value_of__5a2d9c23" BIGINT,
  "theft_section_379_382_ipc_number_of_cases_registered" BIGINT,
  "theft_section_379_382_ipc_value_of_property_stolen_in_rupees" BIGINT
);

CREATE TABLE n_42_district_wise_crimes_committed_against_women_2014 (
  "states_uts" VARCHAR,
  "district" VARCHAR,
  "year" 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,
  "kidnaping_abduction" BIGINT,
  "kidnaping_abduction_in_order_to_murder" BIGINT,
  "kidnapping_for_ransom" BIGINT,
  "kidnapping_abduction_of_women_to_compel_her_for_marriage" BIGINT,
  "kidnaping_abduction_others" BIGINT,
  "dowry_deaths" BIGINT,
  "assault_on_women_with_intent_to_outrage_her_modesty_total" BIGINT,
  "sexual_harassment" BIGINT,
  "assault_on_women_with_intent_to_disrobe" BIGINT,
  "voyeurism" BIGINT,
  "stalking" BIGINT,
  "others" BIGINT,
  "insult_to_the_modesty_of_women_total" BIGINT,
  "at_office_premises" BIGINT,
  "in_places_related_to_work" BIGINT,
  "in_public_transport_system" BIGINT,
  "in_other_places" BIGINT,
  "cruelty_by_husband_or_his_relatives" BIGINT,
  "importation_of_girls_from_foreign_country" BIGINT,
  "murder" BIGINT,
  "attempt_to_commit_murder" BIGINT,
  "culpable_homicide_not_amounting_to_murder" BIGINT,
  "attempt_to_commit_culpable_homicide" BIGINT,
  "grievous_hurt" BIGINT,
  "hurt" BIGINT,
  "acid_attack" BIGINT,
  "attempt_to_acid_attack" BIGINT,
  "deaths_caused_with_intent_to_cause_miscarriage" BIGINT,
  "causing_miscarriage_without_consent_of_women" BIGINT,
  "dacoity_total" BIGINT,
  "dacoity_with_murder" BIGINT,
  "other_dacoity" BIGINT,
  "robbery" BIGINT,
  "arson" BIGINT,
  "humantrafficking" BIGINT,
  "abetment_of_suicides_of_women" BIGINT,
  "unnatural_offences" BIGINT,
  "other_ipc_crimes" BIGINT,
  "dowry_prohibition_act_1961" BIGINT,
  "indecent_representation_of_women_p_act_1986" BIGINT,
  "commission_of_sati_prevention_act_1987" BIGINT,
  "protection_of_women_from_domestic_violence_act_2005" BIGINT,
  "immoral_traffic_prevention_act" BIGINT,
  "itp_under_section_5" BIGINT,
  "itp_under_section_6" BIGINT,
  "itp_under_section_7" BIGINT,
  "itp_under_section_8" BIGINT,
  "itp_under_other_sections" BIGINT,
  "other_sll_crimes_against_women" BIGINT,
  "total_crimes_against_women" BIGINT
);

CREATE TABLE n_18_02_juveniles_arrested_economic_setup (
  "area_name" VARCHAR,
  "year" BIGINT,
  "sub_group_name" VARCHAR,
  "economic_set_up_annual_income_250001_to_50000" BIGINT,
  "economic_set_up_annual_income_upto_rs_25000" BIGINT,
  "economic_set_up_middle_income_from_100001_to_200000" BIGINT,
  "economic_set_up_middle_income_from_50001_to_100000" BIGINT,
  "economic_set_up_total" BIGINT,
  "economic_set_up_upper_income_above_rs_300000" BIGINT,
  "economic_set_up_upper_middle_income_from_200001_to_300000" BIGINT
);

CREATE TABLE n_17_crime_by_place_of_occurrence_2013 (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "residential_premises_dacoity" BIGINT,
  "residential_premises_robbery" BIGINT,
  "residential_premises_burglary" BIGINT,
  "residential_premises_theft" BIGINT,
  "highways_dacoity" BIGINT,
  "highways_robbery" BIGINT,
  "highways_burglary" BIGINT,
  "highways_theft" BIGINT,
  "river_and_sea_dacoity" BIGINT,
  "river_and_sea_robbery" BIGINT,
  "river_and_sea_burglary" BIGINT,
  "river_and_sea_theft" BIGINT,
  "railways_dacoity" BIGINT,
  "railways_robbery" BIGINT,
  "railways_burglary" BIGINT,
  "railways_theft" BIGINT,
  "banks_dacoity" BIGINT,
  "banks_robbery" BIGINT,
  "banks_burglary" BIGINT,
  "banks_theft" BIGINT,
  "commercial_establishments_dacoity" BIGINT,
  "commercial_establishments_robbery" BIGINT,
  "commercial_establishments_burglary" BIGINT,
  "commercial_establishments_theft" BIGINT,
  "other_places_dacoity" BIGINT,
  "other_places_robbery" BIGINT,
  "other_places_burglary" BIGINT,
  "other_places_theft" BIGINT,
  "total_dacoity" BIGINT,
  "total_robbery" BIGINT,
  "total_burglary" BIGINT,
  "total_theft" BIGINT
);

CREATE TABLE n_18_03_juveniles_arrested_family_background (
  "area_name" VARCHAR,
  "year" BIGINT,
  "sub_group_name" VARCHAR,
  "family_back_ground_homeless" BIGINT,
  "family_back_ground_living_with_guardian" BIGINT,
  "family_back_ground_living_with_parents" BIGINT,
  "family_back_ground_total" 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_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_28_trial_of_violent_crimes_by_courts (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "trial_of_violent_crimes_by_courts_by_confession" DOUBLE,
  "trial_of_violent_crimes_by_courts_by_trial" DOUBLE,
  "trial_of_violent_crimes_by_courts_total" DOUBLE
);

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

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

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_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_40_04_custodial_death_during_hospitalization_or_treatment (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cd_hospitalisation_treatment" 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_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_35_human_rights_violation_by_police (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cases_registered_under_human_rights_violations" DOUBLE,
  "policemen_chargesheeted" DOUBLE,
  "policemen_convicted" DOUBLE
);

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_40_03_custodial_death_during_production (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cd_deaths_reported" BIGINT,
  "cd_no_of_autopsy_conducted" DOUBLE,
  "cd_no_of_cases_registered_in_connection_with_deaths" DOUBLE,
  "cd_no_of_judicial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_magisterial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_policemen_charge_sheeted" DOUBLE,
  "cd_no_of_policemen_convicted" DOUBLE
);

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

CREATE TABLE n_42_district_wise_crimes_committed_against_women_2013 (
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "rape" BIGINT,
  "kidnapping_and_abduction" 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" BIGINT
);

CREATE TABLE n_22_persons_arrested_under_recidivism (
  "area_name" VARCHAR,
  "year" BIGINT,
  "offenders_arrested" BIGINT,
  "offenders_arrested_for_the_first_time" BIGINT,
  "offenders_conviction_in_the_past_once" BIGINT,
  "offenders_conviction_in_the_past_three_times_or_more" BIGINT,
  "offenders_conviction_in_the_past_twice" 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_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_c_ee64b8c3" BIGINT,
  "juveniles_sent_home_after_advice_or_admonition" BIGINT,
  "juveniles_sent_to_special_home" BIGINT,
  "juveniles_whose_cases_pending_disposal" BIGINT
);

CREATE TABLE n_42_cases_under_crime_against_women (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cases_acquitted_or_discharged" BIGINT,
  "cases_charge_sheets_were_not_laid_but_final_report_submitted" BIGINT,
  "cases_chargesheeted" BIGINT,
  "cases_compounded_or_withdrawn" BIGINT,
  "cases_convicted" BIGINT,
  "cases_declared_false_on_account_of_mistake_of_fact_or_of_law" BIGINT,
  "cases_investigated_chargesheets_fr_submitted" BIGINT,
  "cases_not_investigated_or_in_which_investigation_was_refused" BIGINT,
  "cases_pending_investigation_at_year_end" BIGINT,
  "cases_pending_investigation_from_previous_year" BIGINT,
  "cases_pending_trial_at_year_end" BIGINT,
  "cases_pending_trial_from_the_previous_year" BIGINT,
  "cases_reported" BIGINT,
  "cases_sent_for_trial" BIGINT,
  "cases_trials_completed" BIGINT,
  "cases_withdrawn_by_the_govt" BIGINT,
  "cases_withdrawn_by_the_govt_during_investigation" BIGINT,
  "total_cases_for_trial" BIGINT
);

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

CREATE TABLE n_24_anti_corruption_arrests (
  "area_name" VARCHAR,
  "year" BIGINT,
  "aca01_no_of_persons_in_custody_or_on_bail_during_the_s_e3f4ea76" DOUBLE,
  "aca02_no_of_persons_arrested_during_the_year" DOUBLE,
  "aca04_no_of_persons_in_custody_or_on_bail_during_the_s_0417847e" DOUBLE,
  "aca05_no_of_persons_in_whose_cases_charge_sheets_were__db35cf2b" DOUBLE,
  "aca06_no_of_persons_under_trial_at_the_beginning_of_the_year" DOUBLE,
  "aca07_total_no_of_persons_under_trial_during_the_year" DOUBLE,
  "aca08_no_of_persons_whose_cases_were_withdrawn_or_othe_d3d4a652" DOUBLE,
  "aca09_no_of_persons_in_custody_or_on_bail_during_the_s_eabfd263" DOUBLE,
  "aca10_no_of_persons_in_whose_cases_trials_were_complet_0ff20b61" DOUBLE,
  "aca11_no_of_persons_convicted_during_the_year" DOUBLE,
  "aca12_no_of_persons_acquitted_during_the_year" DOUBLE,
  "aca13_percentage_of_persons_convicted_to_total_persons_a4175b8f" DOUBLE,
  "aca14_no_of_persons_involved_in_the_cases_reported_for_67c17bba" DOUBLE,
  "aca15_no_of_persons_involved_in_the_cases_reported_for_421d16ab" DOUBLE,
  "aca16_no_of_persons_punished_departmentally_during_the_year" DOUBLE,
  "aca161_no_of_persons_dismissed_from_service_during_the_year" DOUBLE,
  "aca162_no_of_persons_removed_from_service_during_the_year" DOUBLE,
  "aca163_no_of_persons_awarded_other_major_punishments_d_5ce60039" DOUBLE,
  "aca164_no_of_persons_awarded_minor_punishments_during_the_year" DOUBLE,
  "aca171_no_of_group_a_officers_out_of_above" DOUBLE,
  "aca172_no_of_group_b_officers_out_of_above" DOUBLE,
  "aca19_no_of_private_persons_involved_during_the_year" DOUBLE
);

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

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_38_unidentified_dead_bodies_recovered_and_inquest_conducted (
  "area_name" VARCHAR,
  "year" BIGINT,
  "unidentified_dead_bodies_recovered_inquest_conducted" BIGINT
);

CREATE TABLE n_18_01_juveniles_arrested_education (
  "area_name" VARCHAR,
  "year" BIGINT,
  "sub_group_name" VARCHAR,
  "education_above_primary_but_below_matric_or_higher_secondary" BIGINT,
  "education_illiterate" BIGINT,
  "education_matric_or_higher_secondary_above" BIGINT,
  "education_total" BIGINT,
  "education_upto_primary" 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_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_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_41_escapes_from_police_custody (
  "area_name" VARCHAR,
  "year" BIGINT,
  "epc_cases_cases_acquitted" DOUBLE,
  "epc_cases_cases_convicted" DOUBLE,
  "epc_cases_cases_pending_for_trial" DOUBLE,
  "epc_cases_registered" DOUBLE,
  "epc_cases_trial_completed" DOUBLE,
  "epc_escapees_re_arrested_from_lockup" DOUBLE,
  "epc_escapees_re_arrested_from_others" DOUBLE,
  "epc_fr_submitted" DOUBLE,
  "epc_persons_awarded_more_than_3_years_imprisonment" DOUBLE,
  "epc_persons_awarded_upto_3_years_imprisonment" DOUBLE,
  "epc_persons_cases_acquitted" DOUBLE,
  "epc_persons_cases_convicted" DOUBLE,
  "epc_persons_cases_pending_for_trial" DOUBLE,
  "epc_persons_chargesheeted_for_escape" DOUBLE,
  "epc_persons_escaped" DOUBLE,
  "epc_persons_escaped_from_lockup" DOUBLE,
  "epc_persons_escaped_outside_the_lockup" DOUBLE,
  "epc_persons_escaped_total" DOUBLE,
  "epc_persons_trial_completed" DOUBLE
);

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_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_21_offenders_known_to_the_victim (
  "area_name" VARCHAR,
  "year" BIGINT,
  "no_of_cases_in_which_offenders_were_known_to_the_victims" BIGINT,
  "no_of_cases_in_which_offenders_were_neighbours" BIGINT,
  "no_of_cases_in_which_offenders_were_other_known_persons" BIGINT,
  "no_of_cases_in_which_offenders_were_parentsclose_family_members" BIGINT,
  "no_of_cases_in_which_offenders_were_relatives" BIGINT
);

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

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_40_02_custodial_death_person_not_remanded (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "cd_deaths_reported" BIGINT,
  "cd_no_of_autopsy_conducted" DOUBLE,
  "cd_no_of_cases_registered_in_connection_with_deaths" DOUBLE,
  "cd_no_of_judicial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_magisterial_enquiry_orderedconducted" DOUBLE,
  "cd_no_of_policemen_charge_sheeted" DOUBLE,
  "cd_no_of_policemen_convicted" DOUBLE
);

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,
  "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_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_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
);