Dataset: English Indices Of Deprivation 2015 & 2011 Census

About this Dataset

English Indices Of Deprivation 2015 & 2011 Census

Background

This analysis was conducted as part of a university module to compare age with socio-economic group in the UK and investigates unemployment levels with deprivation in England.

Content

The dataset includes the English Indices of Deprivation 2015 and the 2011 UK census data.

The English indices of deprivation measures relative deprivation in small areas in England called lower-layer super output areas. The index of multiple deprivation is the most widely used of these indices. More information can be found on the government website here. The Index of Multiple Deprivation ranks every small area in England from 1 (most deprived area) to 32,844 (least deprived area) and ranks them according to the following measures:

Income Deprivation
Employment Deprivation
Education, Skills and Training Deprivation
Health Deprivation and Disability
Crime
Barriers to Housing and Services
Living Environment Deprivation
By including the 2011 UK census data and a lookup table (for combining the datasets) it is possible to see how age and gender corresponds to areas of deprivation.

Acknowledgements

All data has been made freely available by the UK Government and can be accessed here. It is strongly recommended that the guidance notes for this dataset are read before performing any analysis.

Tables

File 2 Id 2015 Domains Of Deprivation

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.file_2_id_2015_domains_of_deprivation

2.1 MB
32844 rows
20 columns


CREATE TABLE file_2_id_2015_domains_of_deprivation (
  "lsoa_code_2011" VARCHAR,
  "lsoa_name_2011" VARCHAR,
  "local_authority_district_code_2013" VARCHAR,
  "local_authority_district_name_2013" VARCHAR,
  "index_of_multiple_deprivation_imd_rank_where_1_is_most_da66b844" BIGINT,
  "index_of_multiple_deprivation_imd_decile_where_1_is_mo_a064151a" BIGINT,
  "income_rank_where_1_is_most_deprived" BIGINT,
  "income_decile_where_1_is_most_deprived_10_of_lsoas" BIGINT,
  "employment_rank_where_1_is_most_deprived" BIGINT,
  "employment_decile_where_1_is_most_deprived_10_of_lsoas" BIGINT,
  "education_skills_and_training_rank_where_1_is_most_deprived" BIGINT,
  "education_skills_and_training_decile_where_1_is_most_d_86cf4e60" BIGINT,
  "health_deprivation_and_disability_rank_where_1_is_most_bf7cb99f" BIGINT,
  "health_deprivation_and_disability_decile_where_1_is_mo_ed00bbc8" BIGINT,
  "crime_rank_where_1_is_most_deprived" BIGINT,
  "crime_decile_where_1_is_most_deprived_10_of_lsoas" BIGINT,
  "barriers_to_housing_and_services_rank_where_1_is_most_deprived" BIGINT,
  "barriers_to_housing_and_services_decile_where_1_is_mos_af1ca2c0" BIGINT,
  "living_environment_rank_where_1_is_most_deprived" BIGINT,
  "living_environment_decile_where_1_is_most_deprived_10_of_lsoas" BIGINT
);

F 16–24

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.f_16_24

141.77 KB
7211 rows
9 columns


CREATE TABLE f_16_24 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

F 25–49

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.f_25_49

164.53 KB
7211 rows
9 columns


CREATE TABLE f_25_49 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

F 50–64

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.f_50_64

152.81 KB
7211 rows
9 columns


CREATE TABLE f_50_64 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

F 65 Plus

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.f_65_plus

153.48 KB
7211 rows
9 columns


CREATE TABLE f_65_plus (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

M 16–24

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.m_16_24

144.83 KB
7211 rows
9 columns


CREATE TABLE m_16_24 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

M 25–49

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.m_25_49

165.72 KB
7211 rows
9 columns


CREATE TABLE m_25_49 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

M 50–64

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.m_50_64

152.64 KB
7211 rows
9 columns


CREATE TABLE m_50_64 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

M 65 Plus

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.m_65_plus

152.32 KB
7211 rows
9 columns


CREATE TABLE m_65_plus (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);