Dataset: Indian Prison Statistics

About this Dataset

Indian Prison Statistics

Context

This dataset contains the complete detail about the Prison and various characteristics of inmates. This will help to understand better about prison system in India.

Content

Details of Jail wise population of prison inmates
Details about the list of jails in India at the end of year 2015.
Jail category wise population of inmates.
Capacity of jails by inmate population.
Age group, nationality and gender wise population of inmates.
Religion and gender wise population of inmates.
Caste and gender wise population of inmates.
Education standards of inmates.
Domicile of inmates.
Incidence of recidivism.
Rehabilitation of prisoners.
Distribution of sentence periods of convicts in various jails by sex and age-groups.
Details of under trial prisoners by the type of IPC (Indian Penal Code) offences.
Details of convicts by the type of IPC (Indian Penal Code) offences.
Details of SLL (special & local law) Crime headwise distribution of inmates who convicted
Details of SLL (special & local law) Crime head wise distribution of inmates under trial
Details of educational facilities provided to prisoners.
Details of Jail breaks, group clashes and firing in jail (Tranquility).
Details of wages per day to convicts.
Details of Prison inmates trained under different vocational training.
Details of capital punishment (death sentence) and life imprisonment.
Details of prison inmates escaped.
Details of prison inmates released.
Details of Strength of officials
Details of Total Budget and Actual Expenditure during the year 2015-16.
Details of Budget
Details of Expenditure
Details of Expenditure on inmates
Details of Inmates suffering from mental ilness
Details of Period of detention of undertrials
Details of Number of women prisoners with children
Details of Details of inmates parole during the year
Details of Value of goods produced by inmates
Details of Number of vehicles available
Details of Training of Jail Officers
Details of Movements outside jail premises
Details of Details of electronic equipment used in prison

Inspiration

There are many questions about Indian prison with this dataset. Some of the interesting questions are

Percentage of jails over crowded. Is there any change in percentage over time?
How many percentage of inmates re-arrested?
Which state/u.t pay more wages to the inmates?
Which state/u.t has more capital punishment/life imprisonment inmates?
Inmates gender ratio per state

Acknowledgements

National Crime Records Bureau (NCRB), Govt of India has shared this dataset under Govt. Open Data License - India.
NCRB has also shared prison data on their website.

Tables

Age Group

@kaggle.rajanand_prison_in_india.age_group

35.93 KB
7152 rows
10 columns


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
);

Caste

@kaggle.rajanand_prison_in_india.caste

27.87 KB
3568 rows
9 columns


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

Death Sentence

@kaggle.rajanand_prison_in_india.death_sentence

5.88 KB
446 rows
5 columns


CREATE TABLE death_sentence (
  "state_name" VARCHAR,
  "year" BIGINT,
  "no_capital_punishment" BIGINT,
  "no_life_imprisonment" BIGINT,
  "no_executed" BIGINT
);

Domicile

@kaggle.rajanand_prison_in_india.domicile

22.64 KB
2676 rows
9 columns


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

Education

@kaggle.rajanand_prison_in_india.education

32.97 KB
5346 rows
9 columns


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

Education Facilities

@kaggle.rajanand_prison_in_india.education_facilities

10.74 KB
445 rows
6 columns


CREATE TABLE education_facilities (
  "state_name" VARCHAR,
  "year" BIGINT,
  "elementary_education" BIGINT,
  "adult_education" BIGINT,
  "higher_education" BIGINT,
  "computer_course" BIGINT
);

Inmates Death

@kaggle.rajanand_prison_in_india.inmates_death

11.02 KB
4023 rows
6 columns


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

Inmates Escapee

@kaggle.rajanand_prison_in_india.inmates_escapee

8.33 KB
1788 rows
6 columns


CREATE TABLE inmates_escapee (
  "state_name" VARCHAR,
  "year" BIGINT,
  "detail" VARCHAR,
  "male" BIGINT,
  "female" BIGINT,
  "total" BIGINT
);

Ipc Crime Inmates Convicted

@kaggle.rajanand_prison_in_india.ipc_crime_inmates_convicted

119.68 KB
9391 rows
18 columns


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
);

Ipc Crime Inmates Under Trial

@kaggle.rajanand_prison_in_india.ipc_crime_inmates_under_trial

148.39 KB
9390 rows
18 columns


CREATE TABLE ipc_crime_inmates_under_trial (
  "state_ut" VARCHAR,
  "year" BIGINT,
  "crime_head" VARCHAR,
  "male_16_18_years" BIGINT,
  "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
);

Jail Wise Population Of Prison Inmates

@kaggle.rajanand_prison_in_india.jail_wise_population_of_prison_inmates

95.44 KB
4023 rows
18 columns


CREATE TABLE jail_wise_population_of_prison_inmates (
  "state_ut_name" VARCHAR,
  "year" BIGINT,
  "jail_type" VARCHAR,
  "male_convicts" BIGINT,
  "female_convicts" BIGINT,
  "total_convicts" BIGINT,
  "male_under_trial" BIGINT,
  "female_under_trial" BIGINT,
  "total_under_trial" BIGINT,
  "male_detenues" BIGINT,
  "female_detenues" BIGINT,
  "total_detenues" BIGINT,
  "male_others" BIGINT,
  "female_others" BIGINT,
  "total_others" BIGINT,
  "total_male" BIGINT,
  "total_female" BIGINT,
  "grand_total" BIGINT
);

Prison Details 2015

@kaggle.rajanand_prison_in_india.prison_details_2015

80.71 KB
1397 rows
14 columns


CREATE TABLE prison_details_2015 (
  "category" VARCHAR,
  "state_ut_name" VARCHAR,
  "jail_type_sl_no" BIGINT,
  "jail_type" VARCHAR,
  "number_of_jails" BIGINT,
  "jail_sl_no" BIGINT,
  "jail_name" VARCHAR,
  "contact_no" VARCHAR,
  "vc_for_remand_purpose" VARCHAR,
  "vc_for_trial_purpose" VARCHAR,
  "vc_for_other_purpose" VARCHAR,
  "location1" VARCHAR,
  "location2" VARCHAR,
  "email_id" VARCHAR
);

Recidivism

@kaggle.rajanand_prison_in_india.recidivism

7.62 KB
447 rows
4 columns


CREATE TABLE recidivism (
  "state_name" VARCHAR,
  "year" BIGINT,
  "convicts_admitted" BIGINT,
  "habitual_offenders" BIGINT
);

Rehabilitation

@kaggle.rajanand_prison_in_india.rehabilitation

7.92 KB
445 rows
5 columns


CREATE TABLE rehabilitation (
  "state_name" VARCHAR,
  "year" BIGINT,
  "financial_assistance_provided" BIGINT,
  "rehabilitated" BIGINT,
  "legal_aid_provided" BIGINT
);

Religion

@kaggle.rajanand_prison_in_india.religion

28.71 KB
4460 rows
8 columns


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

Sentence Period

@kaggle.rajanand_prison_in_india.sentence_period

38.17 KB
8940 rows
9 columns


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
);

Tranquillity

@kaggle.rajanand_prison_in_india.tranquillity

8.57 KB
1336 rows
8 columns


CREATE TABLE tranquillity (
  "state_name" VARCHAR,
  "year" BIGINT,
  "type" VARCHAR,
  "incidence" BIGINT,
  "inmate_injured" BIGINT,
  "jail_personnel_injured" BIGINT,
  "inmate_killed" BIGINT,
  "jail_personnel_killed" BIGINT
);

Vocational Training

@kaggle.rajanand_prison_in_india.vocational_training

32.06 KB
4122 rows
4 columns


CREATE TABLE vocational_training (
  "state_name" VARCHAR,
  "year" BIGINT,
  "vocational_trainings_program" VARCHAR,
  "inmates_trained" DOUBLE
);

Wages

@kaggle.rajanand_prison_in_india.wages

6.48 KB
445 rows
5 columns


CREATE TABLE wages (
  "state_name" VARCHAR,
  "year" BIGINT,
  "wages_skilled_convicts" DOUBLE,
  "wages_semi_skilled_convicts" DOUBLE,
  "wages_unskilled_convicts" DOUBLE
);