Dataset: How Old Is Our Housing?

About this Dataset

How Old Is Our Housing?

This dataset provides information for Cambridgeshire, West Suffolk and Peterborough, showing the age of homes as provided by the Valuation Office Agency, based on council tax records.
The first file of data is specifically focussed on identifying homes with solid walls, as part of the Warm Homes project, so the data has been grouped to highlight the small areas (known as Lower Super Output Areas) where homes fall into three specific age bands:
Built before 1929
Built between 1930 to 1939
Built between 1945 and 2015

Some build dates are unknown, there are also counted in the data.

Homes built before 1929 all tend to have solid walls, as cavity walls had not been invented. Homes built between 1930 and 1939 may or may not have solid walls, in the period when cavity walls were becoming more popular but not yet "the norm". Few homes were built 1939 to 1945. On the whole, homes built since 1945 tend to have cavity walls.

So this data set helps us identify where we can find homes which are most likely to have solid walls, and therefore where a solid wall insulation project might want ot focus its attention.

The second data file is more detailed and adds further information on the date homes were built, grouped into ten-year bands, and adds the number of homes in each LSO which falls into council tax bands A to H as well.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:44:16Z

Tables

Where Can We Find Homes With Solid Walls?

@ukgov.how_old_is_our_housing1.where_can_we_find_homes_with_solid_walls

23.72 KB
587 rows
8 columns


CREATE TABLE where_can_we_find_homes_with_solid_walls (
  "n_2011_lsoa" VARCHAR,
  "n_2011_lsoa_name" VARCHAR,
  "local_2011_lsoa_name" VARCHAR,
  "total_homes_built_before_1929" BIGINT,
  "total_homes_built_1930_to_1939" BIGINT,
  "total_homes_built_1945_to_2015" BIGINT,
  "total_homes_unknown_built_date" VARCHAR,
  "total_homes" BIGINT
);

Homes By Age Built And Council Tax Band

@ukgov.how_old_is_our_housing1.homes_by_age_built_and_council_tax_band

57.38 KB
4705 rows
18 columns


CREATE TABLE homes_by_age_built_and_council_tax_band (
  "n_2011_lsoa" VARCHAR,
  "n_2011_lsoa_name" VARCHAR,
  "local_2011_lsoa_name" VARCHAR,
  "council_tax_band" VARCHAR,
  "built_before_1900" DOUBLE,
  "built_1900_to_1918" DOUBLE,
  "built_1919_to_1929" DOUBLE,
  "built_1930_to_1939" DOUBLE,
  "built_1945_to_1954" DOUBLE,
  "built_1955_to_1964" DOUBLE,
  "built_1965_to_1972" DOUBLE,
  "built_1973_to_1982" DOUBLE,
  "built_1983_to_1992" DOUBLE,
  "built_1993_to_1999" DOUBLE,
  "built_2000_to_2009" DOUBLE,
  "built_2010_to_2015" DOUBLE,
  "built_date_unknown" DOUBLE,
  "total" DOUBLE
);