Prison Inmates In India
Demographics, Age, Education, Caste, Wages, Rehabilitation, Technical Info
@kaggle.thedevastator_prison_inmates_in_india_demographics_crimes_and
Demographics, Age, Education, Caste, Wages, Rehabilitation, Technical Info
@kaggle.thedevastator_prison_inmates_in_india_demographics_crimes_and
By Rajanand Ilangovan [source]
This dataset provides a detailed view of prison inmates in India, including their age, caste, and educational background. It includes information on inmates from all states/union territories for the year 2019 such as the number of male and female inmates aged 16-18 years, 18-30 year old inmates and those above 50 years old. The data also covers total number of penalized prisoners sentenced to death sentence, life imprisonment or executed by the state authorities. Additionally, it provides information regarding the crimehead (type) committed by an inmate along with its grand total across different age groups. This dataset not only sheds light on India’s criminal justice system but also highlights prevelance of crimes in different states and union territories as well as providing insight into crime trends across Indian states over time
For more datasets, click here.
- 🚨 Your notebook can be here! 🚨!
This dataset provides a comprehensive look at the demographics, crimes and sentences of Indian prison inmates in 2019. The data is broken down by state/union territory, year, crime head, age groups and gender.
This dataset can be used to understand the demographic composition of the prison population in India as well as the types of crimes committed. It can also be used to gain insight into any changes or trends related to sentencing patterns in India over time. Furthermore, this data can provide valuable insight into potential correlations between different demographic factors (such as gender and caste) and specific types of crimes or length of sentences handed out.
To use this dataset effectively there are a few important things to keep in mind:
•State/UT - This column refers to individual states or union territories in India where prisons are located •Year – This column indicates which year(s) the data relates to •Both genders - Female columns refer only to female prisoners while male columns refers only to male prisoners •Age Groups – 16-18 years old = 21-30 years old = 31-50 years old = 50+ years old •Crime Head – A broad definition for each type of crime that inmates have been convicted for •No Capital Punishment – The total number sentenced with capital punishment No Life Imprisonment – The total number sentenced with life imprisonment No Executed– The total number executed from death sentence Grand Total–The overall totals for each categoryBy using this information it is possible to answer questions regarding topics such as sentencing trends, types of crimes committed by different age groups or genders and state-by-state variation amongst other potential queries
- Using the age and gender information to develop targeted outreach strategies for prisons in order to reduce recidivism rates.
- Creating an AI-based predictive model to predict crime trends by analyzing crime head data from a particular region/state and correlating it with population demographics, economic activity, etc.
- Analyzing the caste of inmates across different states in India in order to understand patterns of discrimination within the criminal justice system
If you use this dataset in your research, please credit the original authors.
Data Source
License: Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
- You are free to:
- Share - copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt - remix, transform, and build upon the material for any purpose, even commercially.
- You must:
- Give appropriate credit - Provide a link to the license, and indicate if changes were made.
- ShareAlike - You must distribute your contributions under the same license as the original.
File: SLL_Crime_headwise_distribution_of_inmates_who_convicted.csv
| Column name | Description |
|---|---|
| STATE/UT | Name of the state or union territory where the jail is located. (String) |
| YEAR | Year when the inmate population data was collected. (Integer) |
| CRIME HEAD | Type of offence/crime committed by the inmate. (String) |
| Male 16-18 years | Number of male inmates aged between 16-18. (Integer) |
| Female 16-18 years | Number of female inmates aged between 16-18. (Integer) |
| Total 16-18 years | Total number of inmates aged between 16-18. (Integer) |
| Male 18-30 years | Number of male inmates aged between 18-30. (Integer) |
| Female 18-30 years | Number of female inmates aged between 18-30. (Integer) |
| Total 18-30 years | Total number of inmates aged between 18-30. (Integer) |
| Male 30-50 years | Number of male inmates aged between 30-50. (Integer) |
| Female 30-50 years | Number of female inmates aged between 30-50. (Integer) |
| Total 30-50 years | Total number of inmates aged between 30-50. (Integer) |
| Male Above 50 years | Number of male inmates aged above 50. (Integer) |
| Female Above 50 years | Number of female inmates aged above 50. (Integer) |
| Total Above 50 years | Total number of inmates aged above 50. (Integer) |
| Total Male | Total number of male inmates across all age categories for a particular year/state/UT. (Integer) |
| Total Female | Total number of female inmates across all age categories for a particular year/state/UT. (Integer) |
| Grand Total | Sum of all age groups tallying up. (Integer) |
File: Death_sentence.csv
| Column name | Description |
|---|---|
| state_name | Name of the state or union territory where the jail is located. (String) |
| year | Year when the inmate population data was collected. (Integer) |
| no_capital_punishment | Number of capital punishment sentences handed out in each state/union territory. (Integer) |
| no_life_imprisonment | Number of life imprisonment sentences handed out in each state/union territory. (Integer) |
| no_executed | Number of executions carried out across India through the year. (Integer) |
If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Rajanand Ilangovan.
CREATE TABLE age_group (
"index" BIGINT,
"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
);CREATE TABLE caste (
"index" BIGINT,
"state_name" VARCHAR,
"is_state" BIGINT,
"year" BIGINT,
"gender" VARCHAR,
"caste" VARCHAR,
"convicts" BIGINT,
"under_trial" BIGINT,
"detenues" BIGINT,
"others" BIGINT
);CREATE TABLE death_sentence (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"no_capital_punishment" BIGINT,
"no_life_imprisonment" BIGINT,
"no_executed" BIGINT
);CREATE TABLE details_of_inmates_parole_during_the_year (
"index" BIGINT,
"state_ut" VARCHAR,
"year" BIGINT,
"details" VARCHAR,
"male" BIGINT,
"female" BIGINT,
"total" BIGINT
);CREATE TABLE domicile (
"index" BIGINT,
"state_name" VARCHAR,
"is_state" BIGINT,
"year" BIGINT,
"gender" VARCHAR,
"domicile" VARCHAR,
"convicts" BIGINT,
"under_trial" BIGINT,
"detenues" BIGINT,
"others" BIGINT
);CREATE TABLE education (
"index" BIGINT,
"state_name" VARCHAR,
"is_state" BIGINT,
"year" BIGINT,
"gender" VARCHAR,
"education" VARCHAR,
"convicts" BIGINT,
"under_trial" BIGINT,
"detenues" BIGINT,
"others" BIGINT
);CREATE TABLE education_facilities (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"elementary_education" BIGINT,
"adult_education" BIGINT,
"higher_education" BIGINT,
"computer_course" BIGINT
);CREATE TABLE inmates_death (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"details" VARCHAR,
"male" BIGINT,
"female" BIGINT,
"total" BIGINT
);CREATE TABLE inmates_escapee (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"detail" VARCHAR,
"male" BIGINT,
"female" BIGINT,
"total" BIGINT
);CREATE TABLE inmates_released (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"details" VARCHAR,
"male" BIGINT,
"female" BIGINT,
"total" BIGINT
);CREATE TABLE inmates_suffering_from_mental_ilness (
"index" BIGINT,
"state_ut" VARCHAR,
"year" BIGINT,
"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
);CREATE TABLE ipc_crime_inmates_convicted (
"index" BIGINT,
"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
);CREATE TABLE ipc_crime_inmates_under_trial (
"index" BIGINT,
"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
);CREATE TABLE jail_wise_population_of_prison_inmates (
"index" BIGINT,
"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
);CREATE TABLE number_of_women_prisoners_with_children (
"index" BIGINT,
"state_ut" VARCHAR,
"year" BIGINT,
"no_of_convict_women_prisoners_with_children" BIGINT -- No. Of Convict Women Prisoners With Children,
"no_of_children_of_convict_women_prisoners" BIGINT -- No. Of Children Of Convict Women Prisoners,
"no_of_under_trial_women_prisoners_with_children" BIGINT -- No. Of Under Trial Women Prisoners With Children,
"no_of_children_of_under_trial_women_prisoners" BIGINT -- No. Of Children Of Under Trial Women Prisoners,
"no_of_detenues_women_prisoners_with_children" BIGINT -- No. Of Detenues Women Prisoners With Children,
"no_of_children_of_detenues_women_prisoners" BIGINT -- No. Of Children Of Detenues Women Prisoners,
"no_of_other_women_prisoners_with_children" BIGINT -- No. Of Other Women Prisoners With Children,
"no_of_children_of_other_women_prisoners" BIGINT -- No. Of Children Of Other Women Prisoners,
"total_no_of_women_prisoners_with_children" BIGINT -- Total No. Of Women Prisoners With Children,
"total_no_of_children_of_women_prisoners" BIGINT -- Total No. Of Children Of Women Prisoners
);CREATE TABLE period_of_detention_of_undertrials (
"index" BIGINT,
"state_ut" VARCHAR,
"year" BIGINT,
"period_of_detention" VARCHAR,
"male" BIGINT,
"female" BIGINT,
"total" BIGINT
);CREATE TABLE population_and_capacity_of_jails (
"index" BIGINT,
"state_ut" VARCHAR,
"year" BIGINT,
"type_of_jail" VARCHAR,
"number_of_central_jails" BIGINT,
"total_capacity_of_male_inmates" BIGINT,
"total_capacity_of_female_inmates" BIGINT,
"total_capacity_of_inmates" BIGINT,
"male_inmate_population" BIGINT,
"female_inmate_population" BIGINT,
"total_inmate_population" BIGINT
);CREATE TABLE prison_details_2015 (
"index" BIGINT,
"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
);CREATE TABLE recidivism (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"convicts_admitted" BIGINT,
"habitual_offenders" BIGINT
);CREATE TABLE rehabilitation (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"financial_assistance_provided" BIGINT,
"rehabilitated" BIGINT,
"legal_aid_provided" BIGINT
);CREATE TABLE religion (
"index" BIGINT,
"state_name" BIGINT,
"is_state" BIGINT,
"year" VARCHAR,
"gender" VARCHAR,
"convicts" BIGINT,
"under_trial" BIGINT,
"detenues" BIGINT,
"others" BIGINT
);CREATE TABLE sentence_period (
"index" BIGINT,
"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
);CREATE TABLE sll_crime_head_wise_distribution_of_inmates_under_trial (
"index" BIGINT,
"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
);CREATE TABLE sll_crime_headwise_distribution_of_inmates_who_convicted (
"index" BIGINT,
"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" DOUBLE,
"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
);CREATE TABLE total_budget_and_actual_expenditure_during_the_year_2015_2016 (
"index" BIGINT,
"s_no_col_no_1" BIGINT -- S.No. (Col. No. 1),
"state_ut_col_no_2" VARCHAR -- State/UT (Col. No. 2),
"total_annual_budget_plan_col_no_3" DOUBLE -- Total Annual Budget - Plan (Col. No. 3),
"total_annual_budget_non_plan_col_no_4" DOUBLE -- Total Annual Budget - Non-Plan (Col. No. 4),
"total_annual_budget_total_col_no_5" DOUBLE -- Total Annual Budget - Total (Col. No. 5),
"actual_expenditure_plan_col_no_6" DOUBLE -- Actual Expenditure - Plan (Col. No. 6),
"actual_expenditure_non_plan_col_no_7" DOUBLE -- Actual Expenditure - Non-Plan (Col. No. 7),
"actual_expenditure_expenditure_on_account_of_funds_mad_cd57b885" DOUBLE -- Actual Expenditure - Expenditure On Account Of Funds Made Available By Other Agencies (Col. No. 8),
"actual_expenditure_total_col_no_9_col_6_7_8" DOUBLE -- Actual Expenditure - Total (Col. No. 9) \u003d (Col.6+7+8)
);Anyone who has the link will be able to view this.