Baselight

Indices Of Deprivation

Cambridgeshire Insight

@ukgov.indices_of_deprivation2

Loading...
Loading...

About this Dataset

Indices Of Deprivation

The Department of Communities and Local Government (DCLG) has released the English Indices of Deprivation 2019 which updates the English Indices of Deprivation 2015 (ID2015), which updates the 2010 indices of the same name. The indices are combined together to form the composite Index of Multiple Deprivation (IMD).

The IMD measures relative deprivation across small areas of England called Lower Super Output Areas (LSOAs). Datasets come from 2015, 2010 and 2007. Whilst historical datasets can be compared, there are caveats:

• LSOA definitions have changed between the 2015 and 2010 releases. As such, some locations will not be comparable at all.

• The variables used to define each indices of deprivation have been updated with each publication. As such, changes in apparent deprivation may reflect these changes in methodology rather than actual changes in local circumstance.

Compared to 2010, four out of the five Cambridgeshire districts now rank as more deprived nationally; Cambridge City ranks as less deprived.

Cambridgeshire now (in IMD 2015) has 16 LSOAs in the 20% most deprived nationally – this is compared to 9 in 2010. Two are in Cambridge City, two are in Huntingdonshire and 12 are in Fenland. Four Fenland LSOAs are in the 10% most deprived nationally.

As with 2007 and 2010, Fenland has the highest levels of deprivation in Cambridgeshire, followed by Cambridge City, East Cambridgeshire, Huntingdonshire then South Cambridgeshire.

Linked below are:

• IMD2015 data for Cambridgeshire and Peterborough

• Map of IMD2015 national rankings for Cambridgeshire and Peterborough

• IMD2010 and 2007 data for Cambridgeshire.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:13Z

Tables

Indices Of Deprivation 2010 Quintiles For Cambridgeshire

@ukgov.indices_of_deprivation2.indices_of_deprivation_2010_quintiles_for_cambridgeshire
  • 31.49 kB
  • 365 rows
  • 22 columns
Loading...
CREATE TABLE indices_of_deprivation_2010_quintiles_for_cambridgeshire (
  "codes" VARCHAR,
  "names" VARCHAR,
  "index_of_multiple_deprivation_imd_2007" VARCHAR  -- Index Of Multiple Deprivation (IMD) 2007,
  "index_of_multiple_deprivation_imd_2010" VARCHAR  -- Index Of Multiple Deprivation (IMD) 2010,
  "n__income_deprivation_2007" VARCHAR  -- Income Deprivation 2007,
  "income_deprivation_2010" VARCHAR,
  "employment_deprivation_2007" VARCHAR,
  "employment_deprivation_2010" VARCHAR,
  "health_deprivation_and_disability_2007" VARCHAR,
  "health_deprivation_and_disability_2010" VARCHAR,
  "education_skills_and_training_deprivation_2007" VARCHAR,
  "education_skills_and_training_deprivation_2010" VARCHAR,
  "barriers_to_housing_and_services_deprivation_2007" VARCHAR,
  "barriers_to_housing_and_services_deprivation_2010" VARCHAR,
  "crime_and_disorder_deprivation_2007" VARCHAR,
  "crime_and_disorder_deprivation_2010" VARCHAR,
  "living_environment_deprivation_2007" VARCHAR,
  "living_environment_deprivation_2010" VARCHAR,
  "income_deprivation_affecting_children_index_idaci_2007" VARCHAR  -- Income Deprivation Affecting Children Index (IDACI) 2007,
  "income_deprivation_affecting_children_index_idaci_2010" VARCHAR  -- Income Deprivation Affecting Children Index (IDACI) 2010,
  "income_deprivation_affecting_older_people_index_idaopi_2007" VARCHAR  -- Income Deprivation Affecting Older People Index (IDAOPI) 2007,
  "income_deprivation_affecting_older_people_index_idaopi_2010" VARCHAR  -- Income Deprivation Affecting Older People Index (IDAOPI) 2010
);

Indices Of Deprivation 2010 Ranks For Cambridgeshire

@ukgov.indices_of_deprivation2.indices_of_deprivation_2010_ranks_for_cambridgeshire
  • 64.87 kB
  • 365 rows
  • 22 columns
Loading...
CREATE TABLE indices_of_deprivation_2010_ranks_for_cambridgeshire (
  "codes" VARCHAR,
  "names" VARCHAR,
  "index_of_multiple_deprivation_imd_2007" BIGINT  -- Index Of Multiple Deprivation (IMD) 2007,
  "index_of_multiple_deprivation_imd_2010" BIGINT  -- Index Of Multiple Deprivation (IMD) 2010,
  "n__income_deprivation_2007" BIGINT  -- Income Deprivation 2007,
  "income_deprivation_2010" BIGINT,
  "employment_deprivation_2007" BIGINT,
  "employment_deprivation_2010" BIGINT,
  "health_deprivation_and_disability_2007" BIGINT,
  "health_deprivation_and_disability_2010" BIGINT,
  "education_skills_and_training_deprivation_2007" BIGINT,
  "education_skills_and_training_deprivation_2010" BIGINT,
  "barriers_to_housing_and_services_deprivation_2007" BIGINT,
  "barriers_to_housing_and_services_deprivation_2010" BIGINT,
  "crime_and_disorder_deprivation_2007" BIGINT,
  "crime_and_disorder_deprivation_2010" BIGINT,
  "living_environment_deprivation_2007" BIGINT,
  "living_environment_deprivation_2010" BIGINT,
  "income_deprivation_affecting_children_index_idaci_2007" BIGINT  -- Income Deprivation Affecting Children Index (IDACI) 2007,
  "income_deprivation_affecting_children_index_idaci_2010" BIGINT  -- Income Deprivation Affecting Children Index (IDACI) 2010,
  "income_deprivation_affecting_older_people_index_idaopi_2007" BIGINT  -- Income Deprivation Affecting Older People Index (IDAOPI) 2007,
  "income_deprivation_affecting_older_people_index_idaopi_2010" BIGINT  -- Income Deprivation Affecting Older People Index (IDAOPI) 2010
);

Indices Of Deprivation 2010 Scores For Cambridgeshire

@ukgov.indices_of_deprivation2.indices_of_deprivation_2010_scores_for_cambridgeshire
  • 52.02 kB
  • 365 rows
  • 22 columns
Loading...
CREATE TABLE indices_of_deprivation_2010_scores_for_cambridgeshire (
  "codes" VARCHAR,
  "names" VARCHAR,
  "index_of_multiple_deprivation_imd_2007" DOUBLE  -- Index Of Multiple Deprivation (IMD) 2007,
  "index_of_multiple_deprivation_imd_2010" DOUBLE  -- Index Of Multiple Deprivation (IMD) 2010,
  "n__income_deprivation_2007" DOUBLE  -- Income Deprivation 2007,
  "income_deprivation_2010" DOUBLE,
  "employment_deprivation_2007" DOUBLE,
  "employment_deprivation_2010" DOUBLE,
  "health_deprivation_and_disability_2007" DOUBLE,
  "health_deprivation_and_disability_2010" DOUBLE,
  "education_skills_and_training_deprivation_2007" DOUBLE,
  "education_skills_and_training_deprivation_2010" DOUBLE,
  "barriers_to_housing_and_services_deprivation_2007" DOUBLE,
  "barriers_to_housing_and_services_deprivation_2010" DOUBLE,
  "crime_and_disorder_deprivation_2007" DOUBLE,
  "crime_and_disorder_deprivation_2010" DOUBLE,
  "living_environment_deprivation_2007" DOUBLE,
  "living_environment_deprivation_2010" DOUBLE,
  "income_deprivation_affecting_children_index_idaci_2007" DOUBLE  -- Income Deprivation Affecting Children Index (IDACI) 2007,
  "income_deprivation_affecting_children_index_idaci_2010" DOUBLE  -- Income Deprivation Affecting Children Index (IDACI) 2010,
  "income_deprivation_affecting_older_people_index_idaopi_2007" DOUBLE  -- Income Deprivation Affecting Older People Index (IDAOPI) 2007,
  "income_deprivation_affecting_older_people_index_idaopi_2010" DOUBLE  -- Income Deprivation Affecting Older People Index (IDAOPI) 2010
);

Indices Of Deprivation 2015 Deciles For Cambridgeshire And Peterborough

@ukgov.indices_of_deprivation2.indices_of_deprivation_2015_deciles_for_cambridgeshire_6d712a0e
  • 40.7 kB
  • 487 rows
  • 25 columns
Loading...
CREATE TABLE indices_of_deprivation_2015_deciles_for_cambridgeshire_6d712a0e (
  "rg_lsoa_name_2011" VARCHAR  -- RG LSOA Name (2011),
  "notes_where_lsoa_includes_more_than_1_ward" VARCHAR  -- Notes (where LSOA Includes More Than 1 Ward),
  "lsoa_code_2011" VARCHAR  -- LSOA Code (2011),
  "lsoa_name_2011" VARCHAR  -- LSOA Name (2011),
  "local_authority_district_name_2013" VARCHAR  -- Local Authority District Name (2013),
  "nat_index_of_multiple_deprivation_imd" BIGINT  -- Nat Index Of Multiple Deprivation (IMD),
  "nat_income_deprivation_rate" BIGINT  -- Nat Income Deprivation (rate),
  "nat_employment_rate" BIGINT  -- Nat Employment (rate),
  "nat_education_skills_and_training" BIGINT  -- Nat Education, Skills And Training,
  "nat_health_deprivation_and_disability" BIGINT,
  "nat_crime" BIGINT,
  "nat_barriers_to_housing_and_services" BIGINT,
  "nat_living_environment" BIGINT,
  "nat_income_deprivation_affecting_children_index_idaci_rate" BIGINT  -- Nat Income Deprivation Affecting Children Index (IDACI) (rate),
  "nat_income_deprivation_affecting_older_people_idaopi_rate" BIGINT  -- Nat Income Deprivation Affecting Older People (IDAOPI) (rate),
  "local_index_of_multiple_deprivation_imd" BIGINT  -- Local Index Of Multiple Deprivation (IMD),
  "local_income_deprivation_rate" BIGINT  -- Local Income Deprivation (rate),
  "local_employment_rate" BIGINT  -- Local Employment (rate),
  "local_education_skills_and_training" BIGINT  -- Local Education, Skills And Training,
  "local_health_deprivation_and_disability" BIGINT,
  "local_crime" BIGINT,
  "local_barriers_to_housing_and_services" BIGINT,
  "local_living_environment" BIGINT,
  "local_income_deprivation_affecting_children_index_idaci_rate" BIGINT  -- Local Income Deprivation Affecting Children Index (IDACI) (rate),
  "local_income_deprivation_affecting_older_people_idaopi_rate" BIGINT  -- Local Income Deprivation Affecting Older People (IDAOPI) (rate)
);

Indices Of Deprivation 2015 Ranks For Cambridgeshire And Peterborough

@ukgov.indices_of_deprivation2.indices_of_deprivation_2015_ranks_for_cambridgeshire_a_ee327e4f
  • 82 kB
  • 487 rows
  • 25 columns
Loading...
CREATE TABLE indices_of_deprivation_2015_ranks_for_cambridgeshire_a_ee327e4f (
  "rg_lsoa_name_2011" VARCHAR  -- RG LSOA Name (2011),
  "notes_where_lsoa_includes_more_than_1_ward" VARCHAR  -- Notes (where LSOA Includes More Than 1 Ward),
  "lsoa_code_2011" VARCHAR  -- LSOA Code (2011),
  "lsoa_name_2011" VARCHAR  -- LSOA Name (2011),
  "local_authority_district_name_2013" VARCHAR  -- Local Authority District Name (2013),
  "nat_index_of_multiple_deprivation_imd" BIGINT  -- Nat Index Of Multiple Deprivation (IMD),
  "nat_income_deprivation_rate" BIGINT  -- Nat Income Deprivation (rate),
  "nat_employment_rate" BIGINT  -- Nat Employment (rate),
  "nat_education_skills_and_training" BIGINT  -- Nat Education, Skills And Training,
  "nat_health_deprivation_and_disability" BIGINT,
  "nat_crime" BIGINT,
  "nat_barriers_to_housing_and_services" BIGINT,
  "nat_living_environment" BIGINT,
  "nat_income_deprivation_affecting_children_index_idaci_rate" BIGINT  -- Nat Income Deprivation Affecting Children Index (IDACI) (rate),
  "nat_income_deprivation_affecting_older_people_idaopi_rate" BIGINT  -- Nat Income Deprivation Affecting Older People (IDAOPI) (rate),
  "local_index_of_multiple_deprivation_imd" BIGINT  -- Local Index Of Multiple Deprivation (IMD),
  "local_income_deprivation_rate" BIGINT  -- Local Income Deprivation (rate),
  "local_employment_rate" BIGINT  -- Local Employment (rate),
  "local_education_skills_and_training" BIGINT  -- Local Education, Skills And Training,
  "local_health_deprivation_and_disability" BIGINT,
  "local_crime" BIGINT,
  "local_barriers_to_housing_and_services" BIGINT,
  "local_living_environment" BIGINT,
  "local_income_deprivation_affecting_children_index_idaci_rate" BIGINT  -- Local Income Deprivation Affecting Children Index (IDACI) (rate),
  "local_income_deprivation_affecting_older_people_idaopi_rate" BIGINT  -- Local Income Deprivation Affecting Older People (IDAOPI) (rate)
);

Indices Of Deprivation 2015 Scores For Cambridgeshire And Peterborough

@ukgov.indices_of_deprivation2.indices_of_deprivation_2015_scores_for_cambridgeshire__836f6a88
  • 51.34 kB
  • 487 rows
  • 15 columns
Loading...
CREATE TABLE indices_of_deprivation_2015_scores_for_cambridgeshire__836f6a88 (
  "rg_lsoa_name_2011" VARCHAR  -- RG LSOA Name (2011),
  "notes_where_lsoa_includes_more_than_1_ward" VARCHAR  -- Notes (where LSOA Includes More Than 1 Ward),
  "lsoa_code_2011" VARCHAR  -- LSOA Code (2011),
  "lsoa_name_2011" VARCHAR  -- LSOA Name (2011),
  "local_authority_district_name_2013" VARCHAR  -- Local Authority District Name (2013),
  "index_of_multiple_deprivation_imd" DOUBLE  -- Index Of Multiple Deprivation (IMD),
  "income_deprivation_rate" DOUBLE  -- Income Deprivation (rate),
  "employment_rate" DOUBLE  -- Employment (rate),
  "education_skills_and_training" DOUBLE  -- Education, Skills And Training,
  "health_deprivation_and_disability" DOUBLE,
  "crime" DOUBLE,
  "barriers_to_housing_and_services" DOUBLE,
  "living_environment" DOUBLE,
  "income_deprivation_affecting_children_index_idaci_rate" DOUBLE  -- Income Deprivation Affecting Children Index (IDACI) (rate),
  "income_deprivation_affecting_older_people_idaopi_rate" DOUBLE  -- Income Deprivation Affecting Older People (IDAOPI) (rate)
);

Share link

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