Crime Case Files 🔫⚔️
India, like any other country, deals with various types of crimes
@kaggle.bhanupratapbiswas_crime_case_files
India, like any other country, deals with various types of crimes
@kaggle.bhanupratapbiswas_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
);
Anyone who has the link will be able to view this.