Historic Demand Data 2009

Historic electricity demand, interconnector, wind and solar outturn data for 2009.

CKAN Data API

Access resource data via a web API with powerful query support.
Further information in the main CKAN Data API and DataStore documentation.

The Data API can be accessed via the following actions of the CKAN action API.

Query
`https://api.neso.energy/api/3/action/datastore_search`
Query (via SQL)
`https://api.neso.energy/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.neso.energy/api/3/action/datastore_search?resource_id=ed8a37cb-65ac-4581-8dbc-a3130780da3a&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "ed8a37cb-65ac-4581-8dbc-a3130780da3a" LIMIT 5`

A simple ajax (JSONP) request to the data API using jQuery.

var data = {
  resource_id: 'ed8a37cb-65ac-4581-8dbc-a3130780da3a', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.neso.energy/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function(data) {
    alert('Total results found: ' + data.result.total)
  }
});

A simple ajax (JSONP) request to the data API using jQuery.

import urllib2
  url = 'https://api.neso.energy/api/3/action/datastore_search?resource_id=ed8a37cb-65ac-4581-8dbc-a3130780da3a&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

SETTLEMENT_DATE

Title	Settlement Date
Type	date
Description	The period from 00:00 hours to 24:00 hours on each day.
Comment
Example	01/01/2009
Unit

SETTLEMENT_PERIOD

Title	Settlement Period
Type	integer
Description	The half hourly period for the historic outturn occurred. Settlement period 1 runs from 00:00-00:30.
Comment
Example	1
Unit

ND

Title	National Demand
Type	integer
Description	This is the Great Britain generation requirement and is equivalent to the Initial National Demand Outturn (INDO) and National Demand Forecast as published on BM Reports. National Demand is the sum of metered generation, but excludes generation required to meet station load, pump storage pumping and interconnector exports. National Demand is calculated as a sum of generation based on the operational generation metering from the Transmission Network Operators.
Comment
Example	28354
Unit	MW

TSD

Title	Transmission System Demand
Type	integer
Description	This is the Transmission System generation requirement and is equivalent to the Initial Transmission System Demand Outturn (ITSDO) and Transmission System Demand Forecast on BM Reports. Transmission System Demand is equal to the ND plus the additional generation required to meet station load, pump storage pumping and interconnector exports. Transmission System Demand is calculated using the operational metering from the Transmission Network Operators. Note that the Transmission System Demand includes an estimate of station load of 500MW in BST and 600MW in GMT.
Comment
Example	28968
Unit	MW

ENGLAND_WALES_DEMAND

Title	England and Wales Demand
Type	integer
Description	England and Wales Demand, as ND above but on an England and Wales basis.
Comment
Example	26130
Unit	MW

EMBEDDED_WIND_GENERATION

Title	Estimated Embedded Wind Generation
Type	integer
Description	This is an estimate of the GB wind generation from wind farms which do not have Transmission System metering installed. These wind farms are embedded in the distribution network and invisible to NESO. Their effect is to suppress the electricity demand during periods of high wind. The true output of these generators is not known so an estimate is provided based on NESO’s best model.
Comment
Example	1018
Unit	MW

EMBEDDED_WIND_CAPACITY

Title	Embedded Wind Capacity
Type	integer
Description	This is NESO’s best view of the installed embedded wind capacity in GB. This is based on publicly available information compiled from a variety of sources and is not the definitive view. It is consistent with the generation estimate provided above.
Comment
Example	6527
Unit	MW

EMBEDDED_SOLAR_GENERATION

Title	Estimated Embedded Solar Generation
Type	integer
Description	This is an estimate of the GB solar generation from PV panels. These are embedded in the distribution network and invisible to NESO. Their effect is to suppress the electricity demand during periods of high radiation. The true output of these generators is not known so an estimate is provided based on NESO’s best model.
Comment
Example	0
Unit	MW

EMBEDDED_SOLAR_CAPACITY

Title	Embedded Solar Capacity
Type	integer
Description	As embedded wind capacity above, but for solar generation.
Comment
Example	13080
Unit	MW

NON_BM_STOR

Title	Non-Balancing Mechanism Short-Term Operating Reserve
Type	integer
Description	For units that are not included in the ND generator definition. This can be in the form of generation or demand reduction.
Comment
Example	0
Unit	MW

PUMP_STORAGE_PUMPING

Title	Pump Storage Pumping
Type	integer
Description	The demand due to pumping at hydro pump storage units; the -ve signifies pumping load.
Comment
Example	14
Unit	MW

IFA_FLOW

Title	IFA Interconnector Flow
Type	integer
Description	The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB.
Comment
Example	2003
Unit	MW

IFA2_FLOW

Title	IFA2 Interconnector Flow
Type	integer
Description	The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB.
Comment
Example	0
Unit	MW

BRITNED_FLOW

Title	Britned Interconnector Flow
Type	integer
Description	The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB.
Comment
Example	0
Unit	MW

MOYLE_FLOW

Title	Moyle Interconnector Flow
Type	integer
Description	The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB.
Comment
Example	215
Unit	MW

EAST_WEST_FLOW

Title	East West Interconnector Flow
Type	integer
Description	The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB.
Comment
Example	203
Unit	MW

NEMO_FLOW

Title	Nemo Interconnector Flow
Type	integer
Description	The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB.
Comment
Example	0
Unit	MW

You are now signed in

Historic Demand Data 2009

CKAN Data API

Data Explorer

Data Explorer

Table Information

SETTLEMENT_DATE

SETTLEMENT_PERIOD

ND

TSD

ENGLAND_WALES_DEMAND

EMBEDDED_WIND_GENERATION

EMBEDDED_WIND_CAPACITY

EMBEDDED_SOLAR_GENERATION

EMBEDDED_SOLAR_CAPACITY

NON_BM_STOR

PUMP_STORAGE_PUMPING

IFA_FLOW

IFA2_FLOW

BRITNED_FLOW

MOYLE_FLOW

EAST_WEST_FLOW

NEMO_FLOW