SmartMeter Energy Consumption Data in London Households
Energy consumption readings for a sample of 5,567 London Households that took part in the UK Power Networks led Low Carbon London project between November 2011 and February 2014.
Readings were taken at half hourly intervals. Households have been allocated to a CACI Acorn group (2010). The customers in the trial were recruited as a balanced sample representative of the Greater London population.
The dataset contains energy consumption, in kWh (per half hour), unique household identifier, date and time, and CACI Acorn group. The CSV file is around 10GB when unzipped and contains around 167million rows.
Within the data set are two groups of customers. The first is a sub-group, of approximately 1100 customers, who were subjected to Dynamic Time of Use (dToU) energy prices throughout the 2013 calendar year period. The tariff prices were given a day ahead via the Smart Meter IHD (In Home Display) or text message to mobile phone. Customers were issued High (67.20p/kWh), Low (3.99p/kWh) or normal (11.76p/kWh) price signals and the times of day these applied. The dates/times and the price signal schedule is availaible as part of this dataset. All non-Time of Use customers were on a flat rate tariff of 14.228pence/kWh.
The signals given were designed to be representative of the types of signal that may be used in the future to manage both high renewable generation (supply following) operation and also test the potential to use high price signals to reduce stress on local distribution grids during periods of stress.
The remaining sample of approximately 4500 customers energy consumption readings were not subject to the dToU tariff.
More information can be found on the Low Carbon London webpage
Some analysis of this data can be seen here.
Data and Resources
zip low-carbon-london-data (765.1 MB)
Very large dataset (CSV). 167million rows of data. Unzipped 11.3GB.
zip low-carbon-london-data-168-files (765.2 MB)
Same data as in other Zip file but split into 168 separate CSV files, each containing 1 million rows. Each file can fully load in Excel. Column headers are repeated in each file.
spreadsheet Tariffs (239.6 KB)
Time of Use Tariffs for 2013
csv UKPN-LCL-smartmeter-sample (987.0 KB)
Sample of data representing one household
|Author||UK Power Networks (email@example.com)|
|Maintainer||Opinion Research and General Statistics (GLA) (firstname.lastname@example.org)|