Baselight

Indices Of Deprivation

Lincolnshire County Council

@ukgov.indices_of_deprivation1

Loading...
Loading...

About this Dataset

Indices Of Deprivation

The Indices of Deprivation are published nationally by the Ministry of Housing, Communities and Local Government (MHCLG). These are the official indicators of deprivation. As such, wherever they show deprivation in local areas they provide strong and credible evidence to support funding bids and target resources. Deprivation is measured by the Indices of Deprivation on an Index of Multiple Deprivation (IMD), and also in specific domains and sub-domains of deprivation (for example Income, Employment, Education and Skills, etc). Two further datasets are included within this data, for Income Deprivation affecting Children (IDACI) and Older People (IDAOPI). So as well as overall deprivation shown in the IMD, the themed deprivation domains (and sub-domains) can also be used to identify and evidence different elements of deprivation. For example, among the various deprivation issues affecting local communities in Lincolnshire, deprivation in rural access to housing and services can often stand out in the data. There are useful supporting resources to help people understand and use the Indices of Deprivation, please see the source weblink and the additional links provided. These links also provide Deprivation data summaries for Districts, NHS CCGs, Lincolnshire, and the Greater Lincolnshire LEP. Source: Ministry of Housing, Communities and Local Government (MHCLG). The Indices of Deprivation are updated at four-yearly intervals (so until the next update, the data stays current and valid for use).
Publisher name: Lincolnshire County Council
Last updated: 2024-06-13T04:21:21Z

Tables

Indices Of Deprivation

@ukgov.indices_of_deprivation1.indices_of_deprivation
  • 154.88 KB
  • 420 rows
  • 67 columns
Loading...

CREATE TABLE indices_of_deprivation (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" BOOLEAN,
  "geoareadescription" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "year" BIGINT,
  "localauthoritydistrictcode" VARCHAR,
  "localauthoritydistrictname" VARCHAR,
  "imd_score" DOUBLE,
  "imd_rank_1mostdeprived" BIGINT,
  "imd_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "income_score_rate" DOUBLE,
  "income_rank_1mostdeprived" BIGINT,
  "income_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "employment_score_rate" DOUBLE,
  "employment_rank_1mostdeprived" BIGINT,
  "employment_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "educationskillsandtraining_score" DOUBLE,
  "educationskillsandtraining_rank_1mostdeprived" BIGINT,
  "educationskillsandtraining_decile_1mostdeprivedtenperc_8cded4ab" BIGINT,
  "healthdeprivanddisability_score" DOUBLE,
  "healthdeprivanddisability_rank_1mostdeprived" BIGINT,
  "healthdeprivanddisability_decile_1mostdeprivedtenperce_df45f549" BIGINT,
  "crime_score" DOUBLE,
  "crime_rank_1mostdeprived" BIGINT,
  "crime_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "barrierstohousingandservices_score" DOUBLE,
  "barrierstohousingandservices_rank_1mostdeprived" BIGINT,
  "barrierstohousingandservices_decile_1mostdeprivedtenpe_38732319" BIGINT,
  "livingenvironmentscore" DOUBLE,
  "livingenvironment_rank_1mostdeprived" BIGINT,
  "livingenvironment_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "incomedeprivchildrenindex_idaci_score_rate" DOUBLE,
  "incomedeprivchildrenindex_idaci_rank_1mostdeprived" BIGINT,
  "incomedeprivchildrenindex_idaci_decile_1mostdeprivedte_374ec791" BIGINT,
  "incomedeprivolderpeople_idaopi_score_rate" DOUBLE,
  "incomedeprivolderpeople_idaopi_rank_1_mostdeprived" BIGINT,
  "incomedeprivolderpeople_idaopi_decile_1mostdeprivedten_cad4edba" BIGINT,
  "childrenandyp_subdomain_score" DOUBLE,
  "childrenandyp_subdomain_rank_1mostdeprived" BIGINT,
  "childrenandyp_subdomain_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "adultskills_subdomain_score" DOUBLE,
  "adultskills_subdomain_rank_1mostdeprived" BIGINT,
  "adultskills_subdomain_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "geographicalbarriers_subdomain_score" DOUBLE,
  "geographicalbarriers_subdomain_rank_1mostdeprived" BIGINT,
  "geographicalbarriers_subdomain_decile_1mostdeprivedten_637c1285" BIGINT,
  "widerbarriers_subdomain_score" DOUBLE,
  "widerbarriers_subdomain_rank_1mostdeprived" BIGINT,
  "widerbarriers_subdomain_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "indoors_subdomain_score" DOUBLE,
  "indoors_subdomain_rank_1mostdeprived" BIGINT,
  "indoors_subdomain_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "outdoors_subdomain_score" DOUBLE,
  "outdoors_subdomain_rank_1mostdeprived" BIGINT,
  "outdoors_subdomain_decile_1mostdeprivedtenpercentoflsoas" BIGINT,
  "totalpopulation_exclprisoners" BIGINT,
  "dependentchildrenage0_15_exclprisoners" BIGINT,
  "populationage16_59_exclprisoners" BIGINT,
  "olderpopulationage60andover_exclprisoners" BIGINT,
  "workingagepopn18_59or64_exclprisoners_employmentdeprivdomain" BIGINT
);

Table 1

@ukgov.indices_of_deprivation1.table_1
  • 13.42 KB
  • 67 rows
  • 12 columns
Loading...

CREATE TABLE table_1 (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);

Share link

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