Baselight
Sign In

Empty Homes

Cambridgeshire Insight

@ukgov.empty_homes1

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
);