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

77.48 kB
56,938 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

41.37 kB
56,337 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

41.75 kB
55,179 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

41.37 kB
56,395 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

41.78 kB
55,595 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

41.89 kB
56,163 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

42.03 kB
55,703 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

41.86 kB
56,284 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

41.84 kB
55,822 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

41.19 kB
56,602 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

41.62 kB
53,756 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

365.96 kB
53,847 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

41.68 kB
54,210 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

41.52 kB
53,682 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

41.76 kB
54,883 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

42.51 kB
54,702 rows
5 columns

CREATE TABLE n_31_10_2019 (
  "hmis_year_param_19_week_param_26_current_tenants" VARCHAR  -- HMIS Year Param : '19' , Week Param : '26' - Current Tenants,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

31/12/2014

@ukgov.tenanted_housing_stock.n_31_12_2014

41.37 kB
56,251 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

41.84 kB
56,067 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

41.64 kB
54,440 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

41.73 kB
53,798 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.62 kB
52 rows
3 columns

CREATE TABLE property_type_guidance (
  "criteria" VARCHAR,
  "n_1_2bb" VARCHAR  -- 1/2BB,
  "n_2_bed_bungalow" VARCHAR  -- 2 Bed Bungalow
);