Caste Based Hate Crimes In India

Dataset for Crimes Against Scheduled Castes in India.

@kaggle.khalidative_crimeanalysis

Table List

4 tables(177.31 KB)

Crime By District

@kaggle.khalidative_crimeanalysis.crime_by_district

77.86 KB
9841 rows
13 columns

state_ut STATE/UT	district DISTRICT	year Year	murder Murder	assault_on_women Assault On Women	kidnapping_and_abduction Kidnapping And Abduction	dacoity Dacoity	robbery Robbery	arson Arson	hurt Hurt	prevention_of_atrocities_poa_act Prevention Of Atrocities (POA) Act	protection_of_civil_rights_pcr_act Protection Of Civil Rights (PCR) Act	other_crimes_against_scs Other Crimes Against SCs
ANDHRA PRADESH	ADILABAD	2001		1	4				3		15	32
ANDHRA PRADESH	ANANTAPUR	2001		4					49	21		53
ANDHRA PRADESH	CHITTOOR	2001	3	3					38	36		34
ANDHRA PRADESH	CUDDAPAH	2001		3					20	52		25
ANDHRA PRADESH	EAST GODAVARI	2001	1	3					3	12	63	7
ANDHRA PRADESH	GUNTAKAL RLY.	2001
ANDHRA PRADESH	GUNTUR	2001	4	5	1			3	53	16	6	53
ANDHRA PRADESH	HYDERABAD CITY	2001		2	1					40	1	35
ANDHRA PRADESH	KARIMNAGAR	2001	8	1	3	3	1		52	72	6	10
ANDHRA PRADESH	KHAMMAM	2001	2	6					12	51		90


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