Indian Prison Statistics
Details of Inmates are classified according to 35+ factors. (35+ csv files)
@kaggle.rajanand_prison_in_india
Table List
- 19 tables(729.15 KB)
- Age Group
- Caste
- Death Sentence
- Domicile
- Education
- Education Facilities
- Inmates Death
- Inmates Escapee
- Ipc Crime Inmates Convicted
- Ipc Crime Inmates Under Trial
- Jail Wise Population Of Prison Inmates
- Prison Details 2015
- Recidivism
- Rehabilitation
- Religion
- Sentence Period
- Tranquillity
- Vocational Training
- Wages
Ipc Crime Inmates Convicted
@kaggle.rajanand_prison_in_india.ipc_crime_inmates_convicted
- 119.68 KB
- 9391 rows
- 18 columns
state_utSTATE/UT | yearYEAR | crime_headCRIME HEAD | male_16_18_yearsMale 16-18 Years | female_16_18_yearsFemale 16-18 Years | total_16_18_yearsTotal 16-18 Years | male_18_30_yearsMale 18-30 Years | female_18_30_yearsFemale 18-30 Years | total_18_30_yearsTotal 18-30 Years | male_30_50_yearsMale 30-50 Years | female_30_50_yearsFemale 30-50 Years | total_30_50_yearsTotal 30-50 Years | male_above_50_yearsMale Above 50 Years | female_above_50_yearsFemale Above 50 Years | total_above_50_yearsTotal Above 50 Years | total_maleTotal Male | total_femaleTotal Female | grand_totalGrand Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Andhra Pradesh | 2001 | Murder | 1 | 1 | 688 | 21 | 709 | 1221 | 29 | 1250 | 249 | 10 | 259 | 2159 | 60 | 2219 | |
| Andhra Pradesh | 2001 | Attempt To Commit Murder | 38 | 38 | 71 | 71 | 12 | 12 | 121 | 121 | |||||||
| Andhra Pradesh | 2001 | C.H. Not Amounting To Murder | 78 | 1 | 79 | 121 | 3 | 124 | 23 | 23 | 222 | 4 | 226 | ||||
| Andhra Pradesh | 2001 | Rape | 97 | 97 | 64 | 64 | 5 | 5 | 166 | 166 | |||||||
| Andhra Pradesh | 2001 | Kidnapping And Abduction | 9 | 9 | 5 | 2 | 7 | 1 | 1 | 14 | 3 | 17 | |||||
| Andhra Pradesh | 2001 | Dacoity | 1 | 1 | 85 | 85 | 90 | 90 | 14 | 14 | 190 | 190 | |||||
| Andhra Pradesh | 2001 | Prep. And Assembly For Dacoity | 11 | 11 | 5 | 5 | 16 | 16 | |||||||||
| Andhra Pradesh | 2001 | Robbery | 40 | 40 | 22 | 22 | 3 | 3 | 65 | 65 | |||||||
| Andhra Pradesh | 2001 | Burglary | 1 | 1 | 25 | 25 | 9 | 9 | 3 | 3 | 38 | 38 | |||||
| Andhra Pradesh | 2001 | Thefts | 1 | 1 | 185 | 185 | 80 | 80 | 18 | 18 | 284 | 284 |
CREATE TABLE ipc_crime_inmates_convicted (
"state_ut" VARCHAR,
"year" BIGINT,
"crime_head" VARCHAR,
"male_16_18_years" DOUBLE,
"female_16_18_years" BIGINT,
"total_16_18_years" BIGINT,
"male_18_30_years" BIGINT,
"female_18_30_years" BIGINT,
"total_18_30_years" BIGINT,
"male_30_50_years" BIGINT,
"female_30_50_years" BIGINT,
"total_30_50_years" BIGINT,
"male_above_50_years" BIGINT,
"female_above_50_years" BIGINT,
"total_above_50_years" BIGINT,
"total_male" BIGINT,
"total_female" BIGINT,
"grand_total" BIGINT
);