Baselight

Crime In India

State-wise data from 2001 is classified according to 40+factors. (75+ csv files)

@kaggle.rajanand_crime_in_india

N 10 Property Stolen And Recovered
@kaggle.rajanand_crime_in_india.n_10_property_stolen_and_recovered

  • 56.82 KB
  • 2449 rows
  • 8 columns
area_name

Area Name

year

Year

group_name

Group Name

sub_group_name

Sub Group Name

cases_property_recovered

Cases Property Recovered

cases_property_stolen

Cases Property Stolen

value_of_property_recovered

Value Of Property Recovered

value_of_property_stolen

Value Of Property Stolen

Andaman & Nicobar Islands2001Burglary - Property3. Burglary27647558581321961
Andhra Pradesh2001Burglary - Property3. Burglary3321713451483437147019348
Arunachal Pradesh2001Burglary - Property3. Burglary662488251154931904
Assam2001Burglary - Property3. Burglary5392423372285021466955
Bihar2001Burglary - Property3. Burglary3673231232713517023937
Chandigarh2001Burglary - Property3. Burglary119364180482310217378
Chhattisgarh2001Burglary - Property3. Burglary11694144651826130457033
Dadra & Nagar Haveli2001Burglary - Property3. Burglary10342471401333389
Daman & Diu2001Burglary - Property3. Burglary7434793002084845
Delhi2001Burglary - Property3. Burglary642302939632177150033824

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

Share link

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