Indian Prison Statistics

state_name State Name	year Year	gender Gender	domicile Domicile	convicts Convicts	under_trial Under Trial
A & N Islands	2001	Female	Belongs to other Country
A & N Islands	2001	Female	Belongs to other State
A & N Islands	2001	Female	Belongs to State	3	1
A & N Islands	2001	Male	Belongs to other Country	153	113
A & N Islands	2001	Male	Belongs to other State
A & N Islands	2001	Male	Belongs to State	61	52
A & N Islands	2002	Female	Belongs to other Country
A & N Islands	2002	Female	Belongs to other State
A & N Islands	2002	Female	Belongs to State	4	4
A & N Islands	2002	Male	Belongs to other Country	68	121


CREATE TABLE domicile (
  "state_name" VARCHAR,
  "is_state" BIGINT,
  "year" BIGINT,
  "gender" VARCHAR,
  "domicile" VARCHAR,
  "convicts" BIGINT,
  "under_trial" BIGINT,
  "detenues" BIGINT,
  "others" BIGINT
);