Baselight
Sign In

English Indices Of Deprivation 2015 & 2011 Census

Compare crime, education, health, wealth and other factors in the UK

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015

Loading...
Loading...

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

F 16–24

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.f_16_24
  • 145.17 kB
  • 7,211 rows
  • 9 columns
Loading... 
CREATE TABLE f_16_24 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR  -- DC6206EW - NS-SeC By Ethnic Group By Sex By Age,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

F 25–49

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.f_25_49
  • 168.48 kB
  • 7,211 rows
  • 9 columns
Loading... 
CREATE TABLE f_25_49 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR  -- DC6206EW - NS-SeC By Ethnic Group By Sex By Age,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

F 50–64

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.f_50_64
  • 156.48 kB
  • 7,211 rows
  • 9 columns
Loading... 
CREATE TABLE f_50_64 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR  -- DC6206EW - NS-SeC By Ethnic Group By Sex By Age,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

F 65 Plus

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.f_65_plus
  • 157.16 kB
  • 7,211 rows
  • 9 columns
Loading... 
CREATE TABLE f_65_plus (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR  -- DC6206EW - NS-SeC By Ethnic Group By Sex By Age,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

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.21 MB
  • 32,844 rows
  • 20 columns
Loading... 
CREATE TABLE file_2_id_2015_domains_of_deprivation (
  "lsoa_code_2011" VARCHAR  -- LSOA Code (2011),
  "lsoa_name_2011" VARCHAR  -- LSOA Name (2011),
  "local_authority_district_code_2013" VARCHAR  -- Local Authority District Code (2013),
  "local_authority_district_name_2013" VARCHAR  -- Local Authority District Name (2013),
  "index_of_multiple_deprivation_imd_rank_where_1_is_most_da66b844" BIGINT  -- Index Of Multiple Deprivation (IMD) Rank (where 1 Is Most Deprived),
  "index_of_multiple_deprivation_imd_decile_where_1_is_mo_a064151a" BIGINT  -- Index Of Multiple Deprivation (IMD) Decile (where 1 Is Most Deprived 10% Of LSOAs),
  "income_rank_where_1_is_most_deprived" BIGINT  -- Income Rank (where 1 Is Most Deprived),
  "income_decile_where_1_is_most_deprived_10_of_lsoas" BIGINT  -- Income Decile (where 1 Is Most Deprived 10% Of LSOAs),
  "employment_rank_where_1_is_most_deprived" BIGINT  -- Employment Rank (where 1 Is Most Deprived),
  "employment_decile_where_1_is_most_deprived_10_of_lsoas" BIGINT  -- Employment Decile (where 1 Is Most Deprived 10% Of LSOAs),
  "education_skills_and_training_rank_where_1_is_most_deprived" BIGINT  -- Education, Skills And Training Rank (where 1 Is Most Deprived),
  "education_skills_and_training_decile_where_1_is_most_d_86cf4e60" BIGINT  -- Education, Skills And Training Decile (where 1 Is Most Deprived 10% Of LSOAs),
  "health_deprivation_and_disability_rank_where_1_is_most_bf7cb99f" BIGINT  -- Health Deprivation And Disability Rank (where 1 Is Most Deprived),
  "health_deprivation_and_disability_decile_where_1_is_mo_ed00bbc8" BIGINT  -- Health Deprivation And Disability Decile (where 1 Is Most Deprived 10% Of LSOAs),
  "crime_rank_where_1_is_most_deprived" BIGINT  -- Crime Rank (where 1 Is Most Deprived),
  "crime_decile_where_1_is_most_deprived_10_of_lsoas" BIGINT  -- Crime Decile (where 1 Is Most Deprived 10% Of LSOAs),
  "barriers_to_housing_and_services_rank_where_1_is_most_deprived" BIGINT  -- Barriers To Housing And Services Rank (where 1 Is Most Deprived),
  "barriers_to_housing_and_services_decile_where_1_is_mos_af1ca2c0" BIGINT  -- Barriers To Housing And Services Decile (where 1 Is Most Deprived 10% Of LSOAs),
  "living_environment_rank_where_1_is_most_deprived" BIGINT  -- Living Environment Rank (where 1 Is Most Deprived),
  "living_environment_decile_where_1_is_most_deprived_10_of_lsoas" BIGINT  -- Living Environment Decile (where 1 Is Most Deprived 10% Of LSOAs)
);

M 16–24

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.m_16_24
  • 148.3 kB
  • 7,211 rows
  • 9 columns
Loading... 
CREATE TABLE m_16_24 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR  -- DC6206EW - NS-SeC By Ethnic Group By Sex By Age,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

M 25–49

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.m_25_49
  • 169.7 kB
  • 7,211 rows
  • 9 columns
Loading... 
CREATE TABLE m_25_49 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR  -- DC6206EW - NS-SeC By Ethnic Group By Sex By Age,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

M 50–64

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.m_50_64
  • 156.3 kB
  • 7,211 rows
  • 9 columns
Loading... 
CREATE TABLE m_50_64 (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR  -- DC6206EW - NS-SeC By Ethnic Group By Sex By Age,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

M 65 Plus

@kaggle.nm8883_uk_census_data_with_uk_deprivation_index_2015.m_65_plus
  • 155.98 kB
  • 7,211 rows
  • 9 columns
Loading... 
CREATE TABLE m_65_plus (
  "dc6206ew_ns_sec_by_ethnic_group_by_sex_by_age" VARCHAR  -- DC6206EW - NS-SeC By Ethnic Group By Sex By Age,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

Share link

Anyone who has the link will be able to view this.