Dataset: Empty Homes

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.66 KB
9 rows
16 columns


CREATE TABLE table_1 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2004" VARCHAR,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT
);

Table 2

@ukgov.empty_homes1.table_2

11.66 KB
9 rows
16 columns


CREATE TABLE table_2 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2004" VARCHAR,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT
);

Table 3

@ukgov.empty_homes1.table_3

11.13 KB
9 rows
16 columns


CREATE TABLE table_3 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" VARCHAR,
  "n_2009" VARCHAR,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" VARCHAR,
  "n_2017" VARCHAR
);

Table 4

@ukgov.empty_homes1.table_4

72.73 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,
  "n_2011_all_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2012_all_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2013_all_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2014_all_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2010_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2011_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2012_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2013_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2014_all_long_term_vacant_dwellings_from_council_tax_base" DOUBLE,
  "n_2010_local_authority_vacant_dwellings_from_hssa_at_1_april" DOUBLE,
  "n_2011_local_authority_vacant_dwellings_from_hssa_at_1_april" DOUBLE,
  "n_2012_local_authority_vacant_dwellings_from_lahs_at_1_april" DOUBLE,
  "n_2013_local_authority_vacant_dwellings_from_lahs_at_1_april" DOUBLE,
  "n_2014_local_authority_vacant_dwellings_from_lahs_at_1_april" DOUBLE,
  "n_2010_private_registered_provider_vacan_general_needs_7034b334" DOUBLE,
  "n_2011_private_registered_provider_vacant_general_need_e7819cf1" DOUBLE,
  "n_2012_private_registered_provider_vacant_general_need_89cd305c" DOUBLE,
  "n_2013_private_registered_provider_vacant_general_need_6f51b5a3" DOUBLE,
  "n_2014_private_registered_provider_vacant_general_need_bfbe4668" DOUBLE,
  "n_2010_private_registered_provider_long_term_vacant_ge_b1455702" DOUBLE,
  "n_2011_private_registered_provider_long_term_vacant_ge_4dd33bb4" DOUBLE,
  "n_2012_private_registered_provider_long_term_vacant_ge_f0347198" DOUBLE,
  "n_2013_private_registered_provider_long_term_vacant_ge_331ce6c1" DOUBLE,
  "n_2014_private_registered_provider_long_term_vacant_ge_160d415c" DOUBLE,
  "n_2010_other_public_sector_vacant_dwellings_from_hssa__dd1206bf" DOUBLE,
  "n_2011_other_public_sector_vacant_dwellings_from_hssa__3ca333d8" DOUBLE,
  "n_2012_other_public_sector_vacant_dwellings_from_lahs__5008af0d" DOUBLE,
  "n_2013_other_public_sector_vacant_dwellings_from_lahs__267a7691" DOUBLE,
  "n_2014_other_public_sector_vacant_dwellings_from_lahs__9bd9ffd9" DOUBLE
);

Table 5

@ukgov.empty_homes1.table_5

11.4 KB
9 rows
16 columns


CREATE TABLE table_5 (
  "ons_code" VARCHAR,
  "area" VARCHAR,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT
);

Table 6

@ukgov.empty_homes1.table_6

11.92 KB
9 rows
16 columns


CREATE TABLE table_6 (
  "ons_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT
);

Table 7

@ukgov.empty_homes1.table_7

11.8 KB
9 rows
16 columns


CREATE TABLE table_7 (
  "ons_code" VARCHAR,
  "area_name" VARCHAR,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT
);

Table 8

@ukgov.empty_homes1.table_8

19.67 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,
  "y_northing" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);