About this Dataset

Empty Homes

This data on empty homes is presented in two sections: our original data is provided for the whole of England, collated from local authority returns to the Department of Communities and Local Government (DCLG) for 2010 to 2014. Re-formatting the data and releasing it locally helps us see and use the data locally to monitor this issue - especially useful in an area of high housing pressure.
Our second section of empty homes data, published in 2019, is presented under six side-headings, with one line of data for the whole of England followed by data for our eight Housing Board districts only, rather than districts across the whole country. The data comes from returns made to the Government and is simply re-presented to make it easier to use locally, and slightly more accessible.
The 2019 data comes from a variety of government returns which can be found on the MHCLG web pages; is provided for 2004 to 2017, and is broken down into

All vacants
All long-term vacants
Local authority owned vacants
Private registered provider vacants (aka housing associations)
Private registered provider long tem vacants (aka housing associations)
Other public sector vacants (discontinued in 2015, so no values in 2016 or 2017).

Notes are provided in the data dictionary for each dataset, setting out further detail.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:35:34Z

Tables

Table 1

@ukgov.empty_homes1.table_1

11.94 kB
9 rows
16 columns

CREATE TABLE table_1 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2004" VARCHAR  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017
);

Table 2

@ukgov.empty_homes1.table_2

11.94 kB
9 rows
16 columns

CREATE TABLE table_2 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2004" VARCHAR  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017
);

Table 3

@ukgov.empty_homes1.table_3

11.39 kB
9 rows
16 columns

CREATE TABLE table_3 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" VARCHAR  -- 2008,
  "n_2009" VARCHAR  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" VARCHAR  -- 2016,
  "n_2017" VARCHAR  -- 2017
);

Table 4

@ukgov.empty_homes1.table_4

74.48 kB
451 rows
32 columns

CREATE TABLE table_4 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2010_all_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2010 All Vacant Dwellings From Council Tax Base,
  "n_2011_all_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2011 All Vacant Dwellings From Council Tax Base,
  "n_2012_all_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2012 All Vacant Dwellings From Council Tax Base,
  "n_2013_all_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2013 All Vacant Dwellings From Council Tax Base,
  "n_2014_all_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2014 All Vacant Dwellings From Council Tax Base,
  "n_2010_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2010 All Long-term Vacant Dwellings From Council Tax Base,
  "n_2011_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2011 All Long-term Vacant Dwellings From Council Tax Base,
  "n_2012_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2012 All Long-term Vacant Dwellings From Council Tax Base,
  "n_2013_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2013 All Long-term Vacant Dwellings From Council Tax Base,
  "n_2014_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE  -- 2014 All Long-term Vacant Dwellings From Council Tax Base,
  "n_2010_local_authority_vacant_dwellings_from_hssa_at_1_april" DOUBLE  -- 2010 Local Authority Vacant Dwellings From HSSA At 1 April,
  "n_2011_local_authority_vacant_dwellings_from_hssa_at_1_april" DOUBLE  -- 2011 Local Authority Vacant Dwellings From HSSA At 1 April,
  "n_2012_local_authority_vacant_dwellings_from_lahs_at_1_april" DOUBLE  -- 2012 Local Authority Vacant Dwellings From LAHS At 1 April,
  "n_2013_local_authority_vacant_dwellings_from_lahs_at_1_april" DOUBLE  -- 2013 Local Authority Vacant Dwellings From LAHS At 1 April,
  "n_2014_local_authority_vacant_dwellings_from_lahs_at_1_april" DOUBLE  -- 2014 Local Authority Vacant Dwellings From LAHS At 1 April,
  "n_2010_private_registered_provider_vacan_general_needs_7034b334" DOUBLE  -- 2010 Private Registered Provider Vacan General Needs Dwellings From TSA At 31 March,
  "n_2011_private_registered_provider_vacant_general_need_e7819cf1" DOUBLE  -- 2011 Private Registered Provider Vacant General Needs Dwellings From TSA At 31 March,
  "n_2012_private_registered_provider_vacant_general_need_89cd305c" DOUBLE  -- 2012 Private Registered Provider Vacant General Needs Dwellings From HCA SDR At 31 March,
  "n_2013_private_registered_provider_vacant_general_need_6f51b5a3" DOUBLE  -- 2013 Private Registered Provider Vacant General Needs Dwellings From HCA SDR At 31 March,
  "n_2014_private_registered_provider_vacant_general_need_bfbe4668" DOUBLE  -- 2014 Private Registered Provider Vacant General Needs Dwellings From HCA SDR At 31 March,
  "n_2010_private_registered_provider_long_term_vacant_ge_b1455702" DOUBLE  -- 2010 Private Registered Provider Long Term Vacant General Needs Dwellings From TSA At 31 March,
  "n_2011_private_registered_provider_long_term_vacant_ge_4dd33bb4" DOUBLE  -- 2011 Private Registered Provider Long Term Vacant General Needs Dwellings From TSA At 31 March,
  "n_2012_private_registered_provider_long_term_vacant_ge_f0347198" DOUBLE  -- 2012 Private Registered Provider Long Term Vacant General Needs Dwellings From HCA SDR At 31 March,
  "n_2013_private_registered_provider_long_term_vacant_ge_331ce6c1" DOUBLE  -- 2013 Private Registered Provider Long Term Vacant General Needs Dwellings From HCA SDR At 31 March,
  "n_2014_private_registered_provider_long_term_vacant_ge_160d415c" DOUBLE  -- 2014 Private Registered Provider Long Term Vacant General Needs Dwellings From HCA SDR At 31 March,
  "n_2010_other_public_sector_vacant_dwellings_from_hssa__dd1206bf" DOUBLE  -- 2010 Other Public Sector Vacant Dwellings From HSSA At 1 April,
  "n_2011_other_public_sector_vacant_dwellings_from_hssa__3ca333d8" DOUBLE  -- 2011 Other Public Sector Vacant Dwellings From HSSA At 1 April,
  "n_2012_other_public_sector_vacant_dwellings_from_lahs__5008af0d" DOUBLE  -- 2012 Other Public Sector Vacant Dwellings From LAHS At 1 April,
  "n_2013_other_public_sector_vacant_dwellings_from_lahs__267a7691" DOUBLE  -- 2013 Other Public Sector Vacant Dwellings From LAHS At 1 April,
  "n_2014_other_public_sector_vacant_dwellings_from_lahs__9bd9ffd9" DOUBLE  -- 2014 Other Public Sector Vacant Dwellings From LAHS At 1 April
);

Table 5

@ukgov.empty_homes1.table_5

11.67 kB
9 rows
16 columns

CREATE TABLE table_5 (
  "ons_code" VARCHAR,
  "area" VARCHAR,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017
);

Table 6

@ukgov.empty_homes1.table_6

12.2 kB
9 rows
16 columns

CREATE TABLE table_6 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017
);

Table 7

@ukgov.empty_homes1.table_7

12.08 kB
9 rows
16 columns

CREATE TABLE table_7 (
  "ons_code" VARCHAR,
  "area_name" VARCHAR,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017
);

Table 8

@ukgov.empty_homes1.table_8

20.14 kB
574 rows
10 columns

CREATE TABLE table_8 (
  "address_1" VARCHAR,
  "postcode" VARCHAR,
  "discount_code" VARCHAR,
  "codes_means" VARCHAR,
  "empty_start_date" VARCHAR,
  "number_of_days_empty_at_6_sept_2019" BIGINT,
  "x_easting" BIGINT  -- X (easting),
  "y_northing" BIGINT  -- Y (northing),
  "latitude" DOUBLE,
  "longitude" DOUBLE
);