Indices Of Deprivation
Lincolnshire County Council
@ukgov.indices_of_deprivation1
Lincolnshire County Council
@ukgov.indices_of_deprivation1
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
);
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
);
Anyone who has the link will be able to view this.