Indian Prison Statistics

state_name State Name	is_state Is State	year Year	gender Gender	sentence_period Sentence Period	age_16_18_years Age 16–18 Years	age_18_30_years Age 18–30 Years	age_30_50_years Age 30–50 Years	age_50_above Age 50 Above
Andhra Pradesh	1	2001	Male	Capital Punishment
Andhra Pradesh	1	2001	Male	Life Imprisonment		631	1252	212
Andhra Pradesh	1	2001	Male	10-13 Plus years		74	80	10
Andhra Pradesh	1	2001	Male	7-9 Plus years		87	85	8
Andhra Pradesh	1	2001	Male	5-6 Plus years		113	108	27
Andhra Pradesh	1	2001	Male	2-4 Plus years	3	135	112	19
Andhra Pradesh	1	2001	Male	1 Less than 2 years		140	128	12
Andhra Pradesh	1	2001	Male	6 months less than 1 Yr.		179	159	41
Andhra Pradesh	1	2001	Male	3 - 6 months	2	165	84	42
Andhra Pradesh	1	2001	Male	Less than 3 months		115	79	17


CREATE TABLE sentence_period (
  "state_name" VARCHAR,
  "is_state" BIGINT,
  "year" BIGINT,
  "gender" VARCHAR,
  "sentence_period" VARCHAR,
  "age_16_18_years" BIGINT,
  "age_18_30_years" BIGINT,
  "age_30_50_years" BIGINT,
  "age_50_above" BIGINT
);