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
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_children_of_convict_women_prisoners" BIGINT,
"no_of_under_trial_women_prisoners_with_children" BIGINT,
"no_of_children_of_under_trial_women_prisoners" BIGINT,
"no_of_detenues_women_prisoners_with_children" BIGINT,
"no_of_children_of_detenues_women_prisoners" BIGINT,
"no_of_other_women_prisoners_with_children" BIGINT,
"no_of_children_of_other_women_prisoners" BIGINT,
"total_no_of_women_prisoners_with_children" BIGINT,
"total_no_of_children_of_women_prisoners" BIGINT
);
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,
"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
);
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_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 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 total_budget_and_actual_expenditure_during_the_year_2015_2016 (
"index" BIGINT,
"s_no_col_no_1" BIGINT,
"state_ut_col_no_2" VARCHAR,
"total_annual_budget_plan_col_no_3" DOUBLE,
"total_annual_budget_non_plan_col_no_4" DOUBLE,
"total_annual_budget_total_col_no_5" DOUBLE,
"actual_expenditure_plan_col_no_6" DOUBLE,
"actual_expenditure_non_plan_col_no_7" DOUBLE,
"actual_expenditure_expenditure_on_account_of_funds_mad_cd57b885" DOUBLE,
"actual_expenditure_total_col_no_9_col_6_7_8" DOUBLE
);
CREATE TABLE tranquillity (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"type" VARCHAR,
"incidence" BIGINT,
"inmate_injured" BIGINT,
"jail_personnel_injured" BIGINT,
"inmate_killed" BIGINT,
"jail_personnel_killed" BIGINT
);
CREATE TABLE value_of_goods_produced_by_inmates (
"index" BIGINT,
"state_ut" VARCHAR,
"year" BIGINT,
"vocation_activity" VARCHAR,
"gross_value_of_sale_proceeds_earning_in_rs" DOUBLE
);
CREATE TABLE vocational_training (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"vocational_trainings_program" VARCHAR,
"inmates_trained" DOUBLE
);
CREATE TABLE wages (
"index" BIGINT,
"state_name" VARCHAR,
"year" BIGINT,
"wages_skilled_convicts" DOUBLE,
"wages_semi_skilled_convicts" DOUBLE,
"wages_unskilled_convicts" DOUBLE
);
Anyone who has the link will be able to view this.