About this Dataset

Number Of Council Houses

A dataset providing the total number of council houses from 2006 to present date as at the 31st March each year.
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:30Z

Tables

Council Stock By Ward 01/04/2006 - 31/03/2019

@ukgov.number_of_council_houses.council_stock_by_ward_01_04_2006_31_03_2019

14.25 kB
34 rows
16 columns

CREATE TABLE council_stock_by_ward_01_04_2006_31_03_2019 (
  "ward" VARCHAR,
  "n_2006_07" VARCHAR  -- 2006/07,
  "n_2007_08" VARCHAR  -- 2007/08,
  "n_2008_09" VARCHAR  -- 2008/09,
  "n_2009_10" BIGINT  -- 2009/10,
  "n_2010_11" BIGINT  -- 2010/11,
  "n_2011_12" BIGINT  -- 2011/12,
  "n_2012_13" BIGINT  -- 2012/13,
  "n_2013_14" BIGINT  -- 2013/14,
  "n_2014_15" BIGINT  -- 2014/15,
  "n_2015_16" BIGINT  -- 2015/16,
  "n_2016_17" BIGINT  -- 2016/17,
  "n_2017_18" BIGINT  -- 2017/18,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "ward_1" VARCHAR,
  "n_2018_19" BIGINT  -- 2018/19
);

Council Stock By Ward 01/04/2006 - 31/03/2020

@ukgov.number_of_council_houses.council_stock_by_ward_01_04_2006_31_03_2020

15.11 kB
34 rows
17 columns

CREATE TABLE council_stock_by_ward_01_04_2006_31_03_2020 (
  "ward" VARCHAR,
  "n_2006_07" VARCHAR  -- 2006/07,
  "n_2007_08" VARCHAR  -- 2007/08,
  "n_2008_09" VARCHAR  -- 2008/09,
  "n_2009_10" BIGINT  -- 2009/10,
  "n_2010_11" BIGINT  -- 2010/11,
  "n_2011_12" BIGINT  -- 2011/12,
  "n_2012_13" BIGINT  -- 2012/13,
  "n_2013_14" BIGINT  -- 2013/14,
  "n_2014_15" BIGINT  -- 2014/15,
  "n_2015_16" BIGINT  -- 2015/16,
  "n_2016_17" BIGINT  -- 2016/17,
  "n_2017_18" BIGINT  -- 2017/18,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "ward_1" VARCHAR,
  "n_2018_19" BIGINT  -- 2018/19,
  "n_2019_20" BIGINT  -- 2019/20
);

Council Stock By Ward 01/04/2006 - 31/03/2021

@ukgov.number_of_council_houses.council_stock_by_ward_01_04_2006_31_03_2021

15.95 kB
34 rows
18 columns

CREATE TABLE council_stock_by_ward_01_04_2006_31_03_2021 (
  "ward" VARCHAR,
  "n_2006_07" VARCHAR  -- 2006/07,
  "n_2007_08" VARCHAR  -- 2007/08,
  "n_2008_09" VARCHAR  -- 2008/09,
  "n_2009_10" BIGINT  -- 2009/10,
  "n_2010_11" BIGINT  -- 2010/11,
  "n_2011_12" BIGINT  -- 2011/12,
  "n_2012_13" BIGINT  -- 2012/13,
  "n_2013_14" BIGINT  -- 2013/14,
  "n_2014_15" BIGINT  -- 2014/15,
  "n_2015_16" BIGINT  -- 2015/16,
  "n_2016_17" BIGINT  -- 2016/17,
  "n_2017_18" BIGINT  -- 2017/18,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "ward_1" VARCHAR,
  "n_2018_19" BIGINT  -- 2018/19,
  "n_2019_20" BIGINT  -- 2019/20,
  "n_2020_21" BIGINT  -- 2020/21
);

01/04/2006 - 31/03/2018

@ukgov.number_of_council_houses.n_01_04_2006_31_03_2018

11.71 kB
34 rows
13 columns

CREATE TABLE n_01_04_2006_31_03_2018 (
  "ward" VARCHAR,
  "n_2006_07" VARCHAR  -- 2006/07,
  "n_2007_08" VARCHAR  -- 2007/08,
  "n_2008_09" VARCHAR  -- 2008/09,
  "n_2009_10" BIGINT  -- 2009/10,
  "n_2010_11" BIGINT  -- 2010/11,
  "n_2011_12" BIGINT  -- 2011/12,
  "n_2012_13" BIGINT  -- 2012/13,
  "n_2013_14" BIGINT  -- 2013/14,
  "n_2014_15" BIGINT  -- 2014/15,
  "n_2015_16" BIGINT  -- 2015/16,
  "n_2016_17" BIGINT  -- 2016/17,
  "n_2017_18" BIGINT  -- 2017/18
);