Indian Prison Statistics

state_name State Name	is_state Is State	year Year	gender Gender	caste Caste	convicts Convicts	under_trial Under Trial	detenues Detenues	others Others
Andhra Pradesh	1	2001	Male	SC	1236	1836		5
Andhra Pradesh	1	2001	Male	ST	418	1205		1
Andhra Pradesh	1	2001	Male	OBC	1526	3359	4	8
Andhra Pradesh	1	2001	Male	Others	939	1960		8
Andhra Pradesh	1	2002	Male	SC	1177	1573	2
Andhra Pradesh	1	2002	Male	ST	384	962
Andhra Pradesh	1	2002	Male	OBC	1833	2951
Andhra Pradesh	1	2002	Male	Others	1327	2506
Andhra Pradesh	1	2003	Male	SC	1153	1622
Andhra Pradesh	1	2003	Male	ST	381	990


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