About this Dataset

Social Housing Asset Value Manchester

This data set is provided as specified in para. 38 of Local Government Transparency Code February 2015 This data provides information relating to the market value of social housing assets within the Housing Revenue Account.
Publisher name: Manchester City Council
Last updated: 2024-07-31T04:00:10Z

Tables

Social Housing Asset Value 2019

@ukgov.social_housing_asset_value_manchester.social_housing_asset_value_2019

14.3 kB
110 rows
11 columns

CREATE TABLE social_housing_asset_value_2019 (
  "postcodesector" VARCHAR,
  "valuationband" VARCHAR,
  "interveningband" VARCHAR,
  "total_dwellings" BIGINT,
  "merged_band" BIGINT,
  "value_existing_use_social_housing" BIGINT  -- Value (Existing Use Social Housing),
  "average_value_existing_use_social_housing" DOUBLE  -- Average Value (Existing Use Social Housing),
  "market_value_total" BIGINT,
  "average_market_value" DOUBLE,
  "occupied_percent" DOUBLE,
  "vacant_percent" DOUBLE
);

Social Housing Asset Value 2021

@ukgov.social_housing_asset_value_manchester.social_housing_asset_value_2021

11.76 kB
41 rows
12 columns

CREATE TABLE social_housing_asset_value_2021 (
  "postcodesector" VARCHAR,
  "valuationband" VARCHAR,
  "interveningband" VARCHAR,
  "totaldwellings" BIGINT,
  "mergedband" BIGINT,
  "valueeuv" DOUBLE,
  "averagevaleuv" DOUBLE,
  "marketvalue" BIGINT,
  "averagemarketval" DOUBLE,
  "sum_of_voidcount" DOUBLE,
  "occupiedpercent" DOUBLE,
  "vacantpercent" DOUBLE
);

Social Housing Asset Value 2024

@ukgov.social_housing_asset_value_manchester.social_housing_asset_value_2024

12.35 kB
67 rows
11 columns

CREATE TABLE social_housing_asset_value_2024 (
  "post_code" VARCHAR,
  "valuation_band" VARCHAR,
  "intervening_band" VARCHAR,
  "totaldwellings" BIGINT,
  "merged_band" BIGINT,
  "value_euv_sh" BIGINT  -- Value (EUV-SH),
  "average_euv_sh" DOUBLE  -- Average (EUV-SH),
  "market_value" BIGINT,
  "average_market_value" DOUBLE,
  "occupied_percent" DOUBLE,
  "vacanct_percent" DOUBLE
);

Social Housing Asset Value Manchester

@ukgov.social_housing_asset_value_manchester.social_housing_asset_value_manchester

10.58 kB
59 rows
11 columns

CREATE TABLE social_housing_asset_value_manchester (
  "postcode" VARCHAR,
  "valuationband" VARCHAR,
  "interveningband" VARCHAR,
  "mergedband" BIGINT,
  "totaldwellings" BIGINT,
  "euvsh_total" BIGINT,
  "euvsh_average" BIGINT,
  "marketval_total" BIGINT,
  "marketval_avg" BIGINT,
  "occupiedpercent" VARCHAR,
  "vacantpercent" VARCHAR
);