Indices Of Deprivation
Cambridgeshire Insight
@ukgov.indices_of_deprivation2
Cambridgeshire Insight
@ukgov.indices_of_deprivation2
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_2010" BIGINT,
"n__income_deprivation_2007" BIGINT,
"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_2010" BIGINT,
"income_deprivation_affecting_older_people_index_idaopi_2007" BIGINT,
"income_deprivation_affecting_older_people_index_idaopi_2010" BIGINT
);
CREATE TABLE indices_of_deprivation_2015_deciles_for_cambridgeshire_6d712a0e (
"rg_lsoa_name_2011" VARCHAR,
"notes_where_lsoa_includes_more_than_1_ward" VARCHAR,
"lsoa_code_2011" VARCHAR,
"lsoa_name_2011" VARCHAR,
"local_authority_district_name_2013" VARCHAR,
"nat_index_of_multiple_deprivation_imd" BIGINT,
"nat_income_deprivation_rate" BIGINT,
"nat_employment_rate" BIGINT,
"nat_education_skills_and_training" BIGINT,
"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_older_people_idaopi_rate" BIGINT,
"local_index_of_multiple_deprivation_imd" BIGINT,
"local_income_deprivation_rate" BIGINT,
"local_employment_rate" BIGINT,
"local_education_skills_and_training" BIGINT,
"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_older_people_idaopi_rate" BIGINT
);
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_2010" VARCHAR,
"n__income_deprivation_2007" VARCHAR,
"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_2010" VARCHAR,
"income_deprivation_affecting_older_people_index_idaopi_2007" VARCHAR,
"income_deprivation_affecting_older_people_index_idaopi_2010" VARCHAR
);
CREATE TABLE indices_of_deprivation_2015_ranks_for_cambridgeshire_a_ee327e4f (
"rg_lsoa_name_2011" VARCHAR,
"notes_where_lsoa_includes_more_than_1_ward" VARCHAR,
"lsoa_code_2011" VARCHAR,
"lsoa_name_2011" VARCHAR,
"local_authority_district_name_2013" VARCHAR,
"nat_index_of_multiple_deprivation_imd" BIGINT,
"nat_income_deprivation_rate" BIGINT,
"nat_employment_rate" BIGINT,
"nat_education_skills_and_training" BIGINT,
"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_older_people_idaopi_rate" BIGINT,
"local_index_of_multiple_deprivation_imd" BIGINT,
"local_income_deprivation_rate" BIGINT,
"local_employment_rate" BIGINT,
"local_education_skills_and_training" BIGINT,
"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_older_people_idaopi_rate" BIGINT
);
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_2010" DOUBLE,
"n__income_deprivation_2007" DOUBLE,
"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_2010" DOUBLE,
"income_deprivation_affecting_older_people_index_idaopi_2007" DOUBLE,
"income_deprivation_affecting_older_people_index_idaopi_2010" DOUBLE
);
CREATE TABLE indices_of_deprivation_2015_scores_for_cambridgeshire__836f6a88 (
"rg_lsoa_name_2011" VARCHAR,
"notes_where_lsoa_includes_more_than_1_ward" VARCHAR,
"lsoa_code_2011" VARCHAR,
"lsoa_name_2011" VARCHAR,
"local_authority_district_name_2013" VARCHAR,
"index_of_multiple_deprivation_imd" DOUBLE,
"income_deprivation_rate" DOUBLE,
"employment_rate" DOUBLE,
"education_skills_and_training" DOUBLE,
"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_older_people_idaopi_rate" DOUBLE
);
Anyone who has the link will be able to view this.