We like data, and we like to share ...
This data is useful, so in the spirit of openness and transparency – and with support from the Esmée Fairbairn Foundation – we're pleased to make some of it available here. This is our Open Data Collaboration Initiative, and we hope it will lead to:
- Better evidence to underpin climate change and fuel poverty policy.
- Stronger innovation and enterprise in developing sustainable energy solutions.
- A new basis for collaboration.
- Empowerment of communities and local organisations to use data to develop appropriate responses to local circumstances.
Click on the links to take you to the different datasets:
1) Display Energy Certificate data
2) Lower Super Output Area data
3) Fuel poverty data (including 'hard-to-treat' data)
4) Energy Company Obligation data
5) Energy consumption data (domestic)
6) Heating and housing census data (at smallest output area level)
7) GB household emissions dataset
8) GB postcodes off the mains gas grid
9) Energy Performance Certificate data (at parliamentary constituency level)
Please email suggestions of other sources of data to add to this collection to firstname.lastname@example.org.
In 2011, CSE obtained the full Display Energy Certificate Register dataset for all UK public buildings from the Department of Communities and Local Government (CLG), under the Environmental Information Regulations. Read about how we did it here.
Subsequently, the same dataset has been made available in a more convenient format by the Ministry of Housing, Communities & Local Government and can be viewed here: https://epc.opendatacommunities.org/
The Community Energy Saving Programme (CESP) was designed to target the lowest income households living in homes that need significant investment in energy saving measures and low carbon technologies.
CSE mined the CESP data stores to develop and publish a database of useful information to assist with this targeting. The dataset is available to download here (NB: this file is zipped).
CSE has recently published a free tool called HEAT that enables you to model opportunities in the English Housing Stock and also predict fuel poverty. Read more about this here.
As part of our commitment to open-data we published projections for fuel poverty in 2012. The file also contains breakdowns for 2009, 2010, 2011 and 2012. It can be downloaded here.
Our latest 'Nowcast' of fuel poverty, 2013 shows the breakdown of predicted fuel poverty in England in 2013 by EPC band, according to both the old definition of fuel poverty and the new Hills definition. Click here to download the tables (Excel).
CSE's rural fuel poverty website www.ruralfuelpoverty.org.uk is no longer being updated (that link takes you to an archived version on the Way Back Machine) but still contains useful information and data. It focuses on rural fuel poverty particularly in relation to 'hard-to-treat' homes and includes downloadable maps and data. The full dataset used to produce the website can be downloaded here (NB this file is zipped). A useful key and glossery can be downloaded here.
We're often asked for data which can help with targeting measures to households and stats about progress to date. These are available but can be hard to find, so below we've given you some links to the published datasets and an official tool.
The list of low income and rural areas eligible for CSCO can be found on the government website here (NB this is a .xlsx file).
Ofgem provides an online tool which identifies CSCO-eligible areas at postcode, LSOA, and local authority level. It also shows Adjoining Areas, which are not given in the above spreadsheet. The tool can be found here.
The government publishes monthly and quarterly statistics on ECO and the Green Deal, which can be found here.
There is also some data on off-gas areas available. For this, see Section 8 below.
CSE has developed an analytical model known as 'Dimpsa' (Distributional Impacts Model for Policy Scenario Analysis) which is now used under license by the Department of Energy and Climate Change for the Government’s own assessments of the distributional impacts of policies.
You can read more about Dimpsa here.
Underlying Dimpsa is a comprehensive dataset developed of UK household energy consumption. This dataset is derived from the socio-demographically representative sample of UK households surveyed in the Office of National Statistics Living Costs and Food Survey. Data from six of these surveys (2004/5 to 2009) has been combined, generating a sample size of over 36,000 cases.
We've published some key statistics on average household energy consumption derived from the Dimpsa dataset. The information provided includes estimates of average annual household electricity and gas consumption for all households in Great Britain, and broken down by income bands and consumption bands (representing ‘quintiles’ and ‘deciles’ of the dataset).
Ian Preston, CSE's Senior Analyst, said: "You could, for example, gather information about different energy tariffs, and then use these profiles of consumption by income to estimate how much different households pay for their energy."
The number of households in each consumption and income quintile and decile is also provided. This information is fundamental in understanding the distribution of energy consumption patterns across households in Great Britain.
The spreadsheet of summary data is available to download here.
A guidance document providing key information about the data, including the method behind developing the dataset and examples of how the data can be used is available here. We highly recommend you read this document before using the data provided in the spreadsheet.
If you use this data please reference it as ‘CSE Dimpsa data’. We are very interested to find out what people are doing with this data, and we also welcome questions about it. Please send any comments or queries to email@example.com.
For more energy consumption statistics please see our work on identifying consumer archetypes for Ofgem.
The Office for National Statistics publishes summary census data over a range of geographical levels after a national census has been performed. As the 2011 census data has become available, CSE has downloaded and compiled selected datasets at the lowest available geographical area. Output levels typically contain 70 to 150 households and so cover a relatively small geographical area, dependent upon rurality.
CSE has downloaded and joined key data sets from the Office for National Statistics census 2011 website. There are many potentially interesting topics that could be investigated from the data available, and CSE has chosen data that could be relevant to characterising housing and their energy usage.
- The main central heating type of households
- Number of bedrooms
- Household type (detached, flat etc)
- Household composition
We believe that this data could be useful for targeting schemes such as the ECO, as areas likely to be off gas and containing more vulnerable customers, or areas containing ‘large’ households could be identified. Here’s an example of how we used the data to create a map of the percentage of gas centrally-heated households across the South West:
Data is available by Government Office Region (click below for .xls files):
Or for the whole of England & Wales (NB Excel 2007 as 181,000 rows).
No processing has been performed on this data, and so for any questions and information about the data users should refer to the Office for National Statistics website. Users should be particularly aware of the statistical disclosure control for 2011 census information.
This household-level dataset covers the annual CO2 emissions from domestic energy consumption and personal travel by car, public transport and non-domestic flights for all households in Great Britain and is derived from threenationally representative surveys:
- Expenditure and Food Survey (EFS, 2004-07): used to derive estimates of household emissions from the consumption of energy in the home (electricity, gas and all non-metered fuels);
- National Travel Survey (NTS, 2002-2006): used to derive estimates of household emissions from all personal (defined as leisure and commuting) travel by private road vehicle and public transport;
- Civil Aviation Authority Air Passenger Survey (CAA APS, 1999 to 2008): used to derive estimates of household emissions from international air travel.
The dataset was initially developed as part of a Joseph Rowntree Foundation-funded research project, ‘Distribution of Carbon Emissions in the UK: Implications for Domestic Energy Policy’, where is was used to explore the distribution of emissions across households in Great Britain by a range of socio-demographic variables.
As far as we are aware, this is the first integrated analysis of emissions from both the consumption of energy in the home and personal travel based entirely and directly on nationally representative survey data, and the results are summarised in section 4 of the main project report and in more detail in a supplementary project paper.
However, a great deal more analysis of this dataset could still be done - e.g. the distribution of emissions from the different sources across different socio-demographic groups - and we hope that providing the data others could take up the challenge.
The dataset is designed to be analysed using SPSS (though it's also available in Excel) and the instructions provided reflect this. We also assume users have a good level of understanding of the Expenditure and Food Survey, which provides the core structure for the emissions distribution dataset. For more information about the EFS please refer to ONS documentation.
To request the data, please email firstname.lastname@example.org stating your name, your organisation (if applicable), the format you require (SPSS or Excel) and the reason you are interested in this data (this helps us understand its utility and how it could be improved).
We strongly recommend that users read the accompanying ‘How-to’ guide.
CSE has published a complete list of Great Britain postcodes that are not connected to the mains gas grid, up-to-date for 2017. We've also added the census area and the co-ordinates of the centre of each postcode on the list.
The households in these areas do not have access to mains gas for heating or cooking, and are likely to be reliant upon more expensive forms of heating such as oil or bottled gas.
Download the list here (xlsx doc, 19MB)
NB There are over 381,385 postcodes in this dataset. Please be aware that conversion to other file formats such as .xls may result in loss of data, because not all spreadsheets support a sufficient number of rows. After conversion, please check the number of records before you use the data (the final postcode - ZE3 9JZ - should be in row number 381,386).
This work uses data contained in the National Energy Efficiency Data-framework (NEED) administered by the Department for Energy and Climate Change (DECC). The data shows the numbers of dwellings in each EPC band by Lower Super Output Area (LSOA) – an area that represents around 650 houses on average – and is now available on the government website.
We have used this data to calculate the numbers of dwellings in other types of areas including at Middle Layer Super Output Area (MLSOA) and parliamentary constituency areas in England and Wales. As a result, data showing the number and proportions of dwellings in each energy efficiency (EPC) band by LSOA, MLSOA and parliamentary constituency can be downloaded here.
In addition, we have also produced a series of maps of the parliamentary constituencies. These show where the highest proportions of the most efficient and least efficient dwellings are located.
This formed part of research for Citizens Advice that looked at level of energy efficiency of housing in different areas of the country.