Dataset: Caste Based Hate Crimes In India

About this Dataset

Caste Based Hate Crimes In India

About the data

Data is picked from the National Crime Records Bureau of India.
Representing the state wise and district wise crimes against scheduled castes during the years 2001 to 2012. data for the year 2013 is available for the district wise data.
Crimes that are recorded here as fields are the Indian Penal Code crimes.

Each record represents the number of each type of crime that occurred where the victim was registered as a person of a scheduled cast. Crimes are recorded regardless of the caste of the offender.

Tables

Crime By District

@kaggle.khalidative_crimeanalysis.crime_by_district

77.86 KB
9841 rows
13 columns


CREATE TABLE crime_by_district (
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "assault_on_women" 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
);

Crime By District Rt

@kaggle.khalidative_crimeanalysis.crime_by_district_rt

66.57 KB
9385 rows
13 columns


CREATE TABLE crime_by_district_rt (
  "state_ut" VARCHAR,
  "district" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "assault_on_women" 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
);

Crime By State

@kaggle.khalidative_crimeanalysis.crime_by_state

16.98 KB
456 rows
12 columns


CREATE TABLE crime_by_state (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "assault_on_women" 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
);

Crime By State Rt

@kaggle.khalidative_crimeanalysis.crime_by_state_rt

15.9 KB
420 rows
12 columns


CREATE TABLE crime_by_state_rt (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "murder" BIGINT,
  "assault_on_women" 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
);