Name: Caste Based Hate Crimes In India
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

79.73 kB
9,841 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  -- Prevention Of Atrocities (POA) Act,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "other_crimes_against_scs" BIGINT
);

Crime By District Rt

@kaggle.khalidative_crimeanalysis.crime_by_district_rt

68.17 kB
9,385 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  -- Prevention Of Atrocities (POA) Act,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "other_crimes_against_scs" BIGINT
);

Crime By State

@kaggle.khalidative_crimeanalysis.crime_by_state

17.39 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  -- Prevention Of Atrocities (POA) Act,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "other_crimes_against_scs" BIGINT
);

Crime By State Rt

@kaggle.khalidative_crimeanalysis.crime_by_state_rt

16.28 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  -- Prevention Of Atrocities (POA) Act,
  "protection_of_civil_rights_pcr_act" BIGINT  -- Protection Of Civil Rights (PCR) Act,
  "other_crimes_against_scs" BIGINT
);