Name: U.P. Crime Data - Year 2019
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

U.P. Crime Data - Year 2019

This dataset was created for a project at IIT Kanpur and requires preprocessing to visualize the dataset.

The content is crime news articles under the header with "Murder" ,"Kidnapping", and "Crime Against Women" reported by the Times of India site for the year 2019 in Uttar Pradesh. The data is annotated and categorized manually so as to define the reasons and the number of persons invovled.

This data can be used to improve your preprocessing and visuallization skills which corresponds directly to the business research usually done by the big companies to answer many problems. I would like you to see if there exists any relation between the reasons or the crimes committed based on the data.

Tables

Mr Data Compiled Data Set

@kaggle.deepankurk_up_crime_data_year_2019.mr_data_compiled_data_set

438.24 kB
466 rows
13 columns

CREATE TABLE mr_data_compiled_data_set (
  "city" VARCHAR,
  "title" VARCHAR,
  "text" VARCHAR,
  "murder_happened_with_reason_1_property_land_disputes_2_d9a1c275" VARCHAR  -- Murder Happened With Reason: 1:Property/Land Disputes, 2:Family Dispute 3:Petty Quarrels, 4:Money Disputes, 5:Personal Vendetta, 6:Love Affairs, 7:Casteism 8: Unknown/other,
  "number_of_child_victims" DOUBLE,
  "number_of_male_victims_adult" DOUBLE  -- Number Of Male Victims(adult),
  "number_of_female_victims_adult" DOUBLE  -- Number Of Female Victims(adult),
  "kidnnaping_number_of_child_victims" DOUBLE  -- Kidnnaping: Number Of Child Victims,
  "number_of_male_adult" DOUBLE  -- Number Of Male(adult),
  "number_of_female_adult" DOUBLE  -- Number Of Female(adult),
  "crime_against_women_combined_1_murder_with_rape_2_dowr_c2de901a" VARCHAR  -- Crime Against Women ( Combined ): 1. Murder With Rape 2. Dowry Deaths(Sec. 3048) 3. Suicide(sec 305/306) 4. Kidnapping(All) 5. Acid Attack(Sec. 326A IPC) 6. Cruelty By Husband/in-laws((Sec.498 A IPC) 7. Rape Only(Sec. 376 Or 511 IPC) 8. Assault On Women With Intent To Outrage Her Modesty (Sec. 354 IPC) 9. Cyber Crimes Against Women 10. Protection Of Children From Sexual Offences Act,
  "number_of_adult_victims" DOUBLE,
  "number_of_childs_invoved" DOUBLE
);