About this Dataset

English Indices Of Deprivation 2010

The English Indices of Deprivation 2010 provide a relative measure of deprivation at small area level across England. Areas are ranked from least deprived to most deprived on seven different dimensions of deprivation and an overall composite measure of multiple deprivation. Most of the data underlying the 2010 Indices are for the year 2008. The domains used in the Indices of Deprivation 2010 are: income deprivation; employment deprivation; health deprivation and disability; education deprivation; crime deprivation; barriers to housing and services deprivation; and living environment deprivation. Each of these domains has its own scores and ranks, allowing users to focus on specific aspects of deprivation. In addition, two supplementary indices measure income deprivation amongst children - the Income Deprivation Affecting Children Index (IDACI) - and older people - the Income Deprivation Affecting Older People Index (IDAOPI).
Publisher name: Ministry of Housing, Communities and Local Government
Last updated: 2024-09-15T07:50:56Z

Tables

English Indices Of Deprivation 2010

@ukgov.index_of_multiple_deprivation.english_indices_of_deprivation_2010

4.45 MB
32,482 rows
39 columns

CREATE TABLE english_indices_of_deprivation_2010 (
  "lsoa_code" VARCHAR,
  "pre_2009_la_code" VARCHAR,
  "pre_2009_la_name" VARCHAR,
  "post_2009_la_code" VARCHAR,
  "post_2009_la_name" VARCHAR,
  "gor_code" VARCHAR,
  "gor_name" VARCHAR,
  "imd_score" DOUBLE,
  "rank_of_imd_score_where_1_is_most_deprived" BIGINT  -- RANK OF IMD SCORE (where 1 Is Most Deprived),
  "income_score" DOUBLE,
  "rank_of_income_score_where_1_is_most_deprived" BIGINT  -- RANK OF INCOME SCORE (where 1 Is Most Deprived),
  "employment_score" DOUBLE,
  "rank_of_employment_score_where_1_is_most_deprived" BIGINT  -- RANK OF EMPLOYMENT SCORE (where 1 Is Most Deprived),
  "health_deprivation_and_disability_score" DOUBLE,
  "rank_of_health_deprivation_and_disability_score_where__b53e4e75" BIGINT  -- RANK OF HEALTH DEPRIVATION AND DISABILITY SCORE (where 1 Is Most Deprived),
  "education_skills_and_training_score" DOUBLE,
  "rank_of_education_skills_and_training_score_where_1_is_ee5b18b3" BIGINT  -- RANK OF EDUCATION SKILLS AND TRAINING SCORE (where 1 Is Most Deprived),
  "barriers_to_housing_and_services_score" DOUBLE,
  "rank_of_barriers_to_housing_and_services_score_where_1_0b1a3a02" BIGINT  -- RANK OF BARRIERS TO HOUSING AND SERVICES SCORE (where 1 Is Most Deprived),
  "crime_and_disorder_score" DOUBLE,
  "rank_of_crime_score_where_1_is_most_deprived" BIGINT  -- RANK OF CRIME SCORE (where 1 Is Most Deprived),
  "living_environment_score" DOUBLE,
  "rank_of_living_environment_score_where_1_is_most_deprived" BIGINT  -- RANK OF LIVING ENVIRONMENT SCORE (where 1 Is Most Deprived),
  "indoors_sub_domain_score" DOUBLE,
  "indoors_sub_domain_rank_where_1_is_most_deprived" BIGINT  -- Indoors Sub-domain Rank (where 1 Is Most Deprived),
  "outdoors_sub_domain_score" DOUBLE,
  "outdoors_sub_domain_rank_where_1_is_most_deprived" BIGINT  -- Outdoors Sub-domain Rank (where 1 Is Most Deprived),
  "geographical_barriers_sub_domain_score" DOUBLE,
  "geographical_barriers_sub_domain_rank_where_1_is_most_deprived" BIGINT  -- Geographical Barriers Sub-domain Rank (where 1 Is Most Deprived),
  "wider_barriers_sub_domain_score" DOUBLE,
  "wider_barriers_sub_domain_rank_where_1_is_most_deprived" BIGINT  -- Wider Barriers Sub-domain Rank (where 1 Is Most Deprived),
  "children_young_people_sub_domain_score" DOUBLE,
  "children_young_people_sub_domain_rank_where_1_is_most_deprived" BIGINT  -- Children/Young People Sub-domain Rank (where 1 Is Most Deprived),
  "skills_sub_domain_score" DOUBLE,
  "skills_sub_domain_rank_where_1_is_most_deprived" BIGINT  -- Skills Sub-domain Rank (where 1 Is Most Deprived),
  "idaci_score" DOUBLE,
  "rank_of_idaci_where_1_is_most_deprived" BIGINT  -- Rank Of IDACI (where 1 Is Most Deprived),
  "idaopi_score" DOUBLE,
  "rank_of_idaopi_where_1_is_most_deprived" BIGINT  -- Rank Of IDAOPI (where 1 Is Most Deprived)
);