Indian Prison Statistics

state_name State Name	year Year	category Category	type Type	gender Gender	age_18_30 Age 18–30	age_30_50 Age 30–50	age_50_above Age 50 Above
A & N Islands	2001	Foreigners	Convicts	Female
A & N Islands	2001	Foreigners	Convicts	Male	12	139	2
A & N Islands	2001	Foreigners	Detenus	Female
A & N Islands	2001	Foreigners	Detenus	Male
A & N Islands	2001	Foreigners	Others	Female
A & N Islands	2001	Foreigners	Others	Male
A & N Islands	2001	Foreigners	Under Trials	Female
A & N Islands	2001	Foreigners	Under Trials	Male	61	47	5
A & N Islands	2001	Indians	Convicts	Female		3
A & N Islands	2001	Indians	Convicts	Male	18	38	5


CREATE TABLE age_group (
  "state_name" VARCHAR,
  "is_state" BIGINT,
  "year" BIGINT,
  "category" VARCHAR,
  "type" VARCHAR,
  "gender" VARCHAR,
  "age_16_18" DOUBLE,
  "age_18_30" BIGINT,
  "age_30_50" BIGINT,
  "age_50_above" BIGINT
);