Baselight

Crime Case Files 🔫⚔️

India, like any other country, deals with various types of crimes

@kaggle.bhanupratapbiswas_crime_case_files

Loading...
Loading...

About this Dataset

Crime Case Files 🔫⚔️

India, like any other country, deals with various types of crimes, including but not limited to theft, assault, robbery, cybercrime, and more. Crime rates and types of crimes can vary significantly across different regions and cities in India.

If you are looking for information on recent crime cases in India, I recommend checking with reliable news sources or the official website of the Indian government's law enforcement agencies for the most up-to-date information.

Keep in mind that it's essential to respect the privacy and sensitivity of ongoing investigations and victims involved in crime cases. Always rely on verified sources for accurate and responsible information.

Tables

N 33 Ch Not Murder Victim Age Sex

@kaggle.bhanupratapbiswas_crime_case_files.n_33_ch_not_murder_victim_age_sex
  • 17.47 KB
  • 936 rows
  • 10 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_03_persons_arrested_and_their_disposal_by_police_and_6ed108b0
  • 134.83 KB
  • 2028 rows
  • 57 columns
Loading...

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

N 42 District Wise Crimes Committed Against Women 2001–2012

@kaggle.bhanupratapbiswas_crime_case_files.n_42_district_wise_crimes_committed_against_women_2001_2012
  • 92.26 KB
  • 9017 rows
  • 10 columns
Loading...

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

N 16 Casualties Under Police Firing And Lathi Charge

@kaggle.bhanupratapbiswas_crime_case_files.n_16_casualties_under_police_firing_and_lathi_charge
  • 14.74 KB
  • 1749 rows
  • 8 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_04_01_person_arrested_and_their_disposal_by_police_a_1a9d3577
  • 183.72 KB
  • 2730 rows
  • 57 columns
Loading...

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

N 03 District Wise Crimes Committed Against Children 2013

@kaggle.bhanupratapbiswas_crime_case_files.n_03_district_wise_crimes_committed_against_children_2013
  • 28.83 KB
  • 823 rows
  • 16 columns
Loading...

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

N 01 District Wise Crimes Committed Ipc 2001–2012

@kaggle.bhanupratapbiswas_crime_case_files.n_01_district_wise_crimes_committed_ipc_2001_2012
  • 425.26 KB
  • 9017 rows
  • 33 columns
Loading...

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

N 18–04 Juveniles Arrested Recidivism

@kaggle.bhanupratapbiswas_crime_case_files.n_18_04_juveniles_arrested_recidivism
  • 9.35 KB
  • 350 rows
  • 6 columns
Loading...

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

N 02 District Wise Crimes Committed Against St 2013

@kaggle.bhanupratapbiswas_crime_case_files.n_02_district_wise_crimes_committed_against_st_2013
  • 20.64 KB
  • 823 rows
  • 13 columns
Loading...

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

N 08–02 Juvenile Apprehended State Sll

@kaggle.bhanupratapbiswas_crime_case_files.n_08_02_juvenile_apprehended_state_sll
  • 32.94 KB
  • 9450 rows
  • 12 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_04_02_person_arrested_and_their_disposal_by_police_a_79e07b9f
  • 62.51 KB
  • 1140 rows
  • 14 columns
Loading...

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

N 17 Case Reported And Value Of Property Taken Away By A93c57ca

@kaggle.bhanupratapbiswas_crime_case_files.n_17_case_reported_and_value_of_property_taken_away_by_a93c57ca
  • 117.67 KB
  • 4344 rows
  • 11 columns
Loading...

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

N 23 Anti Corruprion Cases

@kaggle.bhanupratapbiswas_crime_case_files.n_23_anti_corruprion_cases
  • 52.44 KB
  • 346 rows
  • 29 columns
Loading...

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

N 25 Complaints Against Police

@kaggle.bhanupratapbiswas_crime_case_files.n_25_complaints_against_police
  • 36.4 KB
  • 350 rows
  • 22 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_03_persons_arrested_and_their_disposal_by_police_and_7e201ad0
  • 26.06 KB
  • 494 rows
  • 14 columns
Loading...

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

N 17 Crime By Place Of Occurrence 2001–2012

@kaggle.bhanupratapbiswas_crime_case_files.n_17_crime_by_place_of_occurrence_2001_2012
  • 63.82 KB
  • 456 rows
  • 34 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_07_02_persons_arrested_by_sex_and_age_group_sll_2012
  • 32.14 KB
  • 1026 rows
  • 15 columns
Loading...

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

N 13 Police Killed Or Injured On Duty

@kaggle.bhanupratapbiswas_crime_case_files.n_13_police_killed_or_injured_on_duty
  • 36.58 KB
  • 2450 rows
  • 18 columns
Loading...

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

N 27 Nature Of Complaints Received By Police

@kaggle.bhanupratapbiswas_crime_case_files.n_27_nature_of_complaints_received_by_police
  • 24.76 KB
  • 349 rows
  • 10 columns
Loading...

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

N 36 Police Housing

@kaggle.bhanupratapbiswas_crime_case_files.n_36_police_housing
  • 13.17 KB
  • 696 rows
  • 7 columns
Loading...

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

N 40–01 Custodial Death Person Remanded

@kaggle.bhanupratapbiswas_crime_case_files.n_40_01_custodial_death_person_remanded
  • 11.69 KB
  • 211 rows
  • 11 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_07_01_persons_arrested_by_sex_and_age_group_ipc_2014
  • 101.55 KB
  • 3432 rows
  • 18 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_04_01_person_arrested_and_their_disposal_by_police_a_6f8e2765
  • 24.7 KB
  • 418 rows
  • 14 columns
Loading...

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

N 37 Home Guards And Auxilliary Force

@kaggle.bhanupratapbiswas_crime_case_files.n_37_home_guards_and_auxilliary_force
  • 14.01 KB
  • 333 rows
  • 8 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_02_01_district_wise_crimes_committed_against_sc_2001_2012
  • 72.73 KB
  • 9018 rows
  • 13 columns
Loading...

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

N 39 Specific Purpose Of Kidnapping And Abduction

@kaggle.bhanupratapbiswas_crime_case_files.n_39_specific_purpose_of_kidnapping_and_abduction
  • 71.75 KB
  • 3569 rows
  • 20 columns
Loading...

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

N 11 Property Stolen And Recovered Nature Of Property

@kaggle.bhanupratapbiswas_crime_case_files.n_11_property_stolen_and_recovered_nature_of_property
  • 77.74 KB
  • 4550 rows
  • 8 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_07_01_persons_arrested_by_sex_and_age_group_ipc_2013
  • 46.49 KB
  • 1140 rows
  • 15 columns
Loading...

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

N 19 Motive Or Cause Of Murder And Culpable Homicide N 1970921c

@kaggle.bhanupratapbiswas_crime_case_files.n_19_motive_or_cause_of_murder_and_culpable_homicide_n_1970921c
  • 39.57 KB
  • 350 rows
  • 30 columns
Loading...

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

N 34 Use Of Fire Arms In Murder Cases

@kaggle.bhanupratapbiswas_crime_case_files.n_34_use_of_fire_arms_in_murder_cases
  • 7.91 KB
  • 284 rows
  • 5 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_04_02_person_arrested_and_their_disposal_by_police_a_d4bb9e32
  • 62.21 KB
  • 1140 rows
  • 14 columns
Loading...

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

N 43 Arrests Under Crime Against Women

@kaggle.bhanupratapbiswas_crime_case_files.n_43_arrests_under_crime_against_women
  • 105.36 KB
  • 2765 rows
  • 16 columns
Loading...

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

N 40–05 Custodial Death Others

@kaggle.bhanupratapbiswas_crime_case_files.n_40_05_custodial_death_others
  • 9.64 KB
  • 233 rows
  • 10 columns
Loading...

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

N 17 Case Reported And Value Of Property Taken Away By 2c1593e4

@kaggle.bhanupratapbiswas_crime_case_files.n_17_case_reported_and_value_of_property_taken_away_by_2c1593e4
  • 22.12 KB
  • 385 rows
  • 11 columns
Loading...

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

N 42 District Wise Crimes Committed Against Women 2014

@kaggle.bhanupratapbiswas_crime_case_files.n_42_district_wise_crimes_committed_against_women_2014
  • 102.63 KB
  • 837 rows
  • 62 columns
Loading...

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

N 18–02 Juveniles Arrested Economic Setup

@kaggle.bhanupratapbiswas_crime_case_files.n_18_02_juveniles_arrested_economic_setup
  • 16.03 KB
  • 350 rows
  • 10 columns
Loading...

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

N 17 Crime By Place Of Occurrence 2013

@kaggle.bhanupratapbiswas_crime_case_files.n_17_crime_by_place_of_occurrence_2013
  • 30.2 KB
  • 38 rows
  • 34 columns
Loading...

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

N 18–03 Juveniles Arrested Family Background

@kaggle.bhanupratapbiswas_crime_case_files.n_18_03_juveniles_arrested_family_background
  • 11.31 KB
  • 350 rows
  • 7 columns
Loading...

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

N 01 District Wise Crimes Committed Ipc 2014

@kaggle.bhanupratapbiswas_crime_case_files.n_01_district_wise_crimes_committed_ipc_2014
  • 172.81 KB
  • 838 rows
  • 91 columns
Loading...

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

N 12 Police Strength Actual And Sanctioned

@kaggle.bhanupratapbiswas_crime_case_files.n_12_police_strength_actual_and_sanctioned
  • 99.1 KB
  • 4188 rows
  • 16 columns
Loading...

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

N 28 Trial Of Violent Crimes By Courts

@kaggle.bhanupratapbiswas_crime_case_files.n_28_trial_of_violent_crimes_by_courts
  • 34.61 KB
  • 4473 rows
  • 7 columns
Loading...

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

N 32 Murder Victim Age Sex

@kaggle.bhanupratapbiswas_crime_case_files.n_32_murder_victim_age_sex
  • 25.5 KB
  • 1018 rows
  • 11 columns
Loading...

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

N 31 Serious Fraud

@kaggle.bhanupratapbiswas_crime_case_files.n_31_serious_fraud
  • 9.95 KB
  • 448 rows
  • 9 columns
Loading...

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

N 03 District Wise Crimes Committed Against Children 2001–2012

@kaggle.bhanupratapbiswas_crime_case_files.n_03_district_wise_crimes_committed_against_children_2001_2012
  • 80.92 KB
  • 9015 rows
  • 15 columns
Loading...

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

N 14 Age Profile Of Police Personnel Killed On Duty

@kaggle.bhanupratapbiswas_crime_case_files.n_14_age_profile_of_police_personnel_killed_on_duty
  • 9.26 KB
  • 350 rows
  • 8 columns
Loading...

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

N 40–04 Custodial Death During Hospitalization Or Treatment

@kaggle.bhanupratapbiswas_crime_case_files.n_40_04_custodial_death_during_hospitalization_or_treatment
  • 5.38 KB
  • 213 rows
  • 5 columns
Loading...

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

N 01 District Wise Crimes Committed Ipc 2013

@kaggle.bhanupratapbiswas_crime_case_files.n_01_district_wise_crimes_committed_ipc_2013
  • 84.63 KB
  • 823 rows
  • 33 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_07_02_persons_arrested_by_sex_and_age_group_sll_2013
  • 31.93 KB
  • 1026 rows
  • 15 columns
Loading...

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

N 35 Human Rights Violation By Police

@kaggle.bhanupratapbiswas_crime_case_files.n_35_human_rights_violation_by_police
  • 10.23 KB
  • 2267 rows
  • 7 columns
Loading...

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

N 02–01 District Wise Crimes Committed Against Sc 2014

@kaggle.bhanupratapbiswas_crime_case_files.n_02_01_district_wise_crimes_committed_against_sc_2014
  • 79.07 KB
  • 837 rows
  • 66 columns
Loading...

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

N 40–03 Custodial Death During Production

@kaggle.bhanupratapbiswas_crime_case_files.n_40_03_custodial_death_during_production
  • 11.8 KB
  • 204 rows
  • 11 columns
Loading...

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

N 20 Victims Of Rape

@kaggle.bhanupratapbiswas_crime_case_files.n_20_victims_of_rape
  • 24.48 KB
  • 1050 rows
  • 11 columns
Loading...

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

N 42 District Wise Crimes Committed Against Women 2013

@kaggle.bhanupratapbiswas_crime_case_files.n_42_district_wise_crimes_committed_against_women_2013
  • 25.94 KB
  • 823 rows
  • 10 columns
Loading...

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

N 22 Persons Arrested Under Recidivism

@kaggle.bhanupratapbiswas_crime_case_files.n_22_persons_arrested_under_recidivism
  • 15.51 KB
  • 350 rows
  • 7 columns
Loading...

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

N 08–01 Juvenile Apprehended State Ipc

@kaggle.bhanupratapbiswas_crime_case_files.n_08_01_juvenile_apprehended_state_ipc
  • 69.99 KB
  • 10500 rows
  • 12 columns
Loading...

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

N 09 Juveniles Arrested And Their Disposal

@kaggle.bhanupratapbiswas_crime_case_files.n_09_juveniles_arrested_and_their_disposal
  • 17.73 KB
  • 349 rows
  • 10 columns
Loading...

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

N 42 Cases Under Crime Against Women

@kaggle.bhanupratapbiswas_crime_case_files.n_42_cases_under_crime_against_women
  • 128.27 KB
  • 2765 rows
  • 22 columns
Loading...

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

N 30 Auto Theft

@kaggle.bhanupratapbiswas_crime_case_files.n_30_auto_theft
  • 19.99 KB
  • 1865 rows
  • 7 columns
Loading...

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

N 24 Anti Corruption Arrests

@kaggle.bhanupratapbiswas_crime_case_files.n_24_anti_corruption_arrests
  • 41.42 KB
  • 347 rows
  • 24 columns
Loading...

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

N 29 Period Of Trials By Courts

@kaggle.bhanupratapbiswas_crime_case_files.n_29_period_of_trials_by_courts
  • 54.56 KB
  • 1786 rows
  • 11 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_07_01_persons_arrested_by_sex_and_age_group_ipc_2012
  • 46.49 KB
  • 1140 rows
  • 15 columns
Loading...

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

N 38 Unidentified Dead Bodies Recovered And Inquest Conducted

@kaggle.bhanupratapbiswas_crime_case_files.n_38_unidentified_dead_bodies_recovered_and_inquest_conducted
  • 5.05 KB
  • 314 rows
  • 3 columns
Loading...

CREATE TABLE n_38_unidentified_dead_bodies_recovered_and_inquest_conducted (
  "area_name" VARCHAR,
  "year" BIGINT,
  "unidentified_dead_bodies_recovered_inquest_conducted" BIGINT
);

N 18–01 Juveniles Arrested Education

@kaggle.bhanupratapbiswas_crime_case_files.n_18_01_juveniles_arrested_education
  • 13.28 KB
  • 350 rows
  • 8 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_04_01_person_arrested_and_their_disposal_by_police_a_9dfccd11
  • 43.42 KB
  • 1026 rows
  • 14 columns
Loading...

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

N 10 Property Stolen And Recovered

@kaggle.bhanupratapbiswas_crime_case_files.n_10_property_stolen_and_recovered
  • 56.82 KB
  • 2449 rows
  • 8 columns
Loading...

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

N 02–01 District Wise Crimes Committed Against Sc 2013

@kaggle.bhanupratapbiswas_crime_case_files.n_02_01_district_wise_crimes_committed_against_sc_2013
  • 23.28 KB
  • 823 rows
  • 13 columns
Loading...

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

N 41 Escapes From Police Custody

@kaggle.bhanupratapbiswas_crime_case_files.n_41_escapes_from_police_custody
  • 27.94 KB
  • 311 rows
  • 21 columns
Loading...

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

N 02 District Wise Crimes Committed Against St 2014

@kaggle.bhanupratapbiswas_crime_case_files.n_02_district_wise_crimes_committed_against_st_2014
  • 71.36 KB
  • 837 rows
  • 66 columns
Loading...

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

N 15 Police Natural Death And Suicide

@kaggle.bhanupratapbiswas_crime_case_files.n_15_police_natural_death_and_suicide
  • 12.57 KB
  • 700 rows
  • 9 columns
Loading...

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

N 21 Offenders Known To The Victim

@kaggle.bhanupratapbiswas_crime_case_files.n_21_offenders_known_to_the_victim
  • 12.93 KB
  • 350 rows
  • 7 columns
Loading...

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

N 17 Crime By Place Of Occurrence 2014

@kaggle.bhanupratapbiswas_crime_case_files.n_17_crime_by_place_of_occurrence_2014
  • 85.38 KB
  • 39 rows
  • 82 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_04_02_person_arrested_and_their_disposal_by_police_a_85125627
  • 344.43 KB
  • 3432 rows
  • 57 columns
Loading...

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

N 40–02 Custodial Death Person Not Remanded

@kaggle.bhanupratapbiswas_crime_case_files.n_40_02_custodial_death_person_not_remanded
  • 11.91 KB
  • 228 rows
  • 11 columns
Loading...

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

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

@kaggle.bhanupratapbiswas_crime_case_files.n_07_02_persons_arrested_by_sex_and_age_group_sll_2014
  • 56.3 KB
  • 2730 rows
  • 18 columns
Loading...

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

N 03 Persons Arrested And Their Disposal By Police And Fea05944

@kaggle.bhanupratapbiswas_crime_case_files.n_03_persons_arrested_and_their_disposal_by_police_and_fea05944
  • 25.88 KB
  • 494 rows
  • 14 columns
Loading...

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

N 02 District Wise Crimes Committed Against St 2001–2012

@kaggle.bhanupratapbiswas_crime_case_files.n_02_district_wise_crimes_committed_against_st_2001_2012
  • 49.26 KB
  • 9018 rows
  • 13 columns
Loading...

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

Share link

Anyone who has the link will be able to view this.