Social Housing Asset Value
Leeds City Council
@ukgov.social_housing_asset_value1
Leeds City Council
@ukgov.social_housing_asset_value1
CREATE TABLE n_2014_15 (
"postcode_sector" VARCHAR,
"valuationsubband" VARCHAR,
"valuationbandrange" VARCHAR,
"totalnumberdwellings" BIGINT,
"euv_total" BIGINT,
"average_of_2014_euv" DOUBLE,
"marketvaluetotal" BIGINT,
"marketvalueaverage" DOUBLE,
"occupieddwellingpercent" VARCHAR,
"vacantdwellingspercent" VARCHAR
);
CREATE TABLE n_2015_16 (
"postcode_sector" VARCHAR,
"valuationbandrange" VARCHAR,
"valuationsubband" VARCHAR,
"totalnumberdwellings" BIGINT,
"n__euv_total" BIGINT,
"average_of_2015_euv" DOUBLE,
"marketvaluetotal" BIGINT,
"marketvalueaverage" DOUBLE,
"occupied_dwellings_percent" VARCHAR,
"vacant_dwellings_percent" VARCHAR
);
CREATE TABLE n_2016_17 (
"postalsector" VARCHAR,
"valuationbandrange" VARCHAR,
"valuationsubbands" VARCHAR,
"totalnumberdwellings" BIGINT,
"marketvaluetotal" DOUBLE,
"marketvalueaverage" DOUBLE,
"cccupieddwellingspercentage" DOUBLE,
"vacantdwellingspercentage" DOUBLE
);
CREATE TABLE n_2017_18 (
"postcode_sector" VARCHAR,
"valuationbandrange" VARCHAR,
"valuationsubband" VARCHAR,
"totalnumberofdwellings" BIGINT,
"market_value_total" DOUBLE,
"market_value_average" DOUBLE,
"occupied_dwellings_percent" DOUBLE,
"vacant_dwellings_percent" DOUBLE
);
Anyone who has the link will be able to view this.