Indian Prison Statistics

state_name State Name	year Year	details Details	male Male	female Female	total Total
Andhra Pradesh	2001	Natural Deaths	71		71
Andhra Pradesh	2001	Un-natural Deaths	10		10
Andhra Pradesh	2001	Un-natural Deaths - Suicides	6		6
Andhra Pradesh	2001	Un-natural Deaths - Execution
Andhra Pradesh	2001	Un-natural Deaths - Murder by inmates	1		1
Andhra Pradesh	2001	Un-natural Deaths - Death due to assault by outside elements during transit or	3		3
Andhra Pradesh	2001	Un-natural Deaths - Deaths due to firing
Andhra Pradesh	2001	Un-natural Deaths - Deaths due to negligence by Jail Personnel
Andhra Pradesh	2001	Un-natural Deaths - Others
Andhra Pradesh	2002	Natural Deaths	86	2	88


CREATE TABLE inmates_death (
  "state_name" VARCHAR,
  "year" BIGINT,
  "details" VARCHAR,
  "male" BIGINT,
  "female" BIGINT,
  "total" BIGINT
);