Name: Indian Prison Statistics
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

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

36.79 kB
7,152 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

28.54 kB
3,568 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

6.02 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

23.19 kB
2,676 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

33.77 kB
5,346 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

11 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.29 kB
4,023 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.53 kB
1,788 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

122.55 kB
9,391 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

151.96 kB
9,390 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

97.73 kB
4,023 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

82.65 kB
1,397 rows
14 columns

CREATE TABLE prison_details_2015 (
  "category" VARCHAR,
  "state_ut_name" VARCHAR  -- State / UT Name,
  "jail_type_sl_no" BIGINT  -- Jail Type Sl.No.,
  "jail_type" VARCHAR,
  "number_of_jails" BIGINT,
  "jail_sl_no" BIGINT  -- Jail Sl.No.,
  "jail_name" VARCHAR,
  "contact_no" VARCHAR  -- Contact No.,
  "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.81 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

8.11 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

29.4 kB
4,460 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

39.09 kB
8,940 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.78 kB
1,336 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.83 kB
4,122 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.64 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
);