Crime In India

area_name Area Name	year Year	group_name Group Name	sub_group_name Sub Group Name	auto_theft_coordinated_traced Auto Theft Coordinated/Traced	auto_theft_recovered Auto Theft Recovered	auto_theft_stolen Auto Theft Stolen
Andaman & Nicobar Islands	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters		4	4
Andhra Pradesh	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters	136	1311	2725
Arunachal Pradesh	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters		21	27
Assam	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters		94	205
Bihar	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters	44	205	946
Chandigarh	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters		107	281
Chhattisgarh	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters		338	790
Dadra & Nagar Haveli	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters		4	12
Delhi	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters	62	688	3185
Goa	2001	AT1-Motor Cycles/ Scooters	1. Motor Cycles/ Scooters	9	68	152


CREATE TABLE n_30_auto_theft (
  "area_name" VARCHAR,
  "year" BIGINT,
  "group_name" VARCHAR,
  "sub_group_name" VARCHAR,
  "auto_theft_coordinated_traced" DOUBLE,
  "auto_theft_recovered" DOUBLE,
  "auto_theft_stolen" BIGINT
);