About this Dataset

Tenanted Housing Stock

This provides data on all council housing which are currently tenanted, i.e. not empty properties. It provides details on property type, area, ward, and by post code sector. Information ----------- * Please refer to the Property Type document for further guidance on what the property types descriptions mean.
Publisher name: Leeds City Council
Last updated: 2024-09-14T10:05:00Z

Tables

04/03/2014

@ukgov.tenanted_housing_stock.n_04_03_2014

75.66 KB
56938 rows
5 columns


CREATE TABLE n_04_03_2014 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "postcode" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

04/09/2015

@ukgov.tenanted_housing_stock.n_04_09_2015

40.4 KB
56337 rows
5 columns


CREATE TABLE n_04_09_2015 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

06/02/2019

@ukgov.tenanted_housing_stock.n_06_02_2019

40.77 KB
55179 rows
5 columns


CREATE TABLE n_06_02_2019 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

06/10/2014

@ukgov.tenanted_housing_stock.n_06_10_2014

40.4 KB
56395 rows
5 columns


CREATE TABLE n_06_10_2014 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

13/02/2018

@ukgov.tenanted_housing_stock.n_13_02_2018

40.8 KB
55595 rows
5 columns


CREATE TABLE n_13_02_2018 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

17/11/2016

@ukgov.tenanted_housing_stock.n_17_11_2016

40.91 KB
56163 rows
5 columns


CREATE TABLE n_17_11_2016 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

18/10/2017

@ukgov.tenanted_housing_stock.n_18_10_2017

41.04 KB
55703 rows
5 columns


CREATE TABLE n_18_10_2017 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

21/07/2016

@ukgov.tenanted_housing_stock.n_21_07_2016

40.88 KB
56284 rows
5 columns


CREATE TABLE n_21_07_2016 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

25/06/2017

@ukgov.tenanted_housing_stock.n_25_06_2017

40.85 KB
55822 rows
5 columns


CREATE TABLE n_25_06_2017 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

30/06/2014

@ukgov.tenanted_housing_stock.n_30_06_2014

40.23 KB
56602 rows
5 columns


CREATE TABLE n_30_06_2014 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "postcode" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

30/06/2020

@ukgov.tenanted_housing_stock.n_30_06_2020

40.64 KB
53756 rows
5 columns


CREATE TABLE n_30_06_2020 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

30/09/2020

@ukgov.tenanted_housing_stock.n_30_09_2020

357.39 KB
53847 rows
6 columns


CREATE TABLE n_30_09_2020 (
  "prop_sequence_no" BIGINT,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "part_post_code" VARCHAR,
  "property_type" VARCHAR,
  "ward_des" VARCHAR
);

31/03/2020

@ukgov.tenanted_housing_stock.n_31_03_2020

40.71 KB
54210 rows
5 columns


CREATE TABLE n_31_03_2020 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

31/03/2021

@ukgov.tenanted_housing_stock.n_31_03_2021

40.54 KB
53682 rows
5 columns


CREATE TABLE n_31_03_2021 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

31/07/2019

@ukgov.tenanted_housing_stock.n_31_07_2019

40.78 KB
54883 rows
5 columns


CREATE TABLE n_31_07_2019 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

31/10/2019

@ukgov.tenanted_housing_stock.n_31_10_2019

41.51 KB
54702 rows
5 columns


CREATE TABLE n_31_10_2019 (
  "hmis_year_param_19_week_param_26_current_tenants" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR
);

31/12/2014

@ukgov.tenanted_housing_stock.n_31_12_2014

40.4 KB
56251 rows
5 columns


CREATE TABLE n_31_12_2014 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

31/12/2016

@ukgov.tenanted_housing_stock.n_31_12_2016

40.86 KB
56067 rows
5 columns


CREATE TABLE n_31_12_2016 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

31/12/2019

@ukgov.tenanted_housing_stock.n_31_12_2019

40.66 KB
54440 rows
5 columns


CREATE TABLE n_31_12_2019 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

31/12/2020

@ukgov.tenanted_housing_stock.n_31_12_2020

40.75 KB
53798 rows
5 columns


CREATE TABLE n_31_12_2020 (
  "area1" VARCHAR,
  "area2" VARCHAR,
  "post_code_sector" VARCHAR,
  "warddesc" VARCHAR,
  "propertytype" VARCHAR
);

Property Type Guidance

@ukgov.tenanted_housing_stock.property_type_guidance

3.53 KB
52 rows
3 columns


CREATE TABLE property_type_guidance (
  "criteria" VARCHAR,
  "n_1_2bb" VARCHAR,
  "n_2_bed_bungalow" VARCHAR
);