Historic GB Generation Mix

Historic GB generation mix from the 1st of Jan 2009 through to today. Data points are either MW or %.

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.nationalgrideso.com/api/3/action/datastore_search`
Query (via SQL)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=f93d1835-75bc-43e5-84ad-12472b180a98&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "f93d1835-75bc-43e5-84ad-12472b180a98" LIMIT 5`

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

var data = {
  resource_id: 'f93d1835-75bc-43e5-84ad-12472b180a98', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.nationalgrideso.com/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.nationalgrideso.com/api/3/action/datastore_search?resource_id=f93d1835-75bc-43e5-84ad-12472b180a98&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

PowerBI

Data Explorer

Table Information

DATETIME

Title	Date & Time
Type	timestamptz
Description	Date and time of the historic generation mix and carbon intensity
Comment
Example	2009-09-03T05:30:00+00:00
Unit	ISO 8601

GAS

Title	GAS
Type	number
Description	Amount of generation delivered by this fuel type
Comment
Example	10
Unit

COAL

Title	Coal
Type	number
Description	Amount of generation delivered by this fuel type
Comment
Example	10
Unit

NUCLEAR

Title	Nuclear
Type	number
Description	Amount of generation delivered by this fuel type
Comment
Example	42.2
Unit

WIND

Title	Wind
Type	number
Description	Amount of generation delivered by this fuel type
Comment
Example	2
Unit

HYDRO

Title	Hydro
Type	number
Description	Amount of generation delivered by this fuel type
Comment
Example	1
Unit

IMPORTS

Title	Imports
Type	number
Description	Interconnector Imports
Comment
Example	0
Unit

BIOMASS

Title	Biomass
Type	number
Description	Amount of generation delivered by this fuel type
Comment
Example	4.2
Unit

OTHER

Title	Other
Type	number
Description	Amount of generation delivered by other fuel types
Comment
Example	3.1
Unit

SOLAR

Title	Solar
Type	number
Description
Comment	Amount of generation delivered by this fuel type
Example	15.3
Unit

STORAGE

Title	Storage
Type	number
Description	Amount of generation delivered by this fuel type
Comment
Example	43.2
Unit

GENERATION

Title	Generation
Type	number
Description	Sum of gas, coal, nuclear, wind, hydro and imports.
Comment
Example	8.2
Unit

CARBON_INTENSITY

Title	CARBON INTENSITY
Type	number
Description	The carbon intensity of electricity is a measure of how much Carbon dioxide emissions are produced per kilowatt hour of electricity consumed.
Comment
Example
Unit

LOW_CARBON

Title	Low Carbon
Type	number
Description	Low carbon generation e.g. wind, solar, hydro, nuclear, biomass
Comment
Example
Unit

ZERO_CARBON

Title	Zero Carbon
Type	number
Description	Zero carbon generation e.g. wind, solar, hydro, nuclear
Comment
Example
Unit

RENEWABLE

Title	RENEWABLE
Type	number
Description	Renewable generation e.g Wind, Hydro, Solar
Comment
Example
Unit

FOSSIL

Title	FOSSIL
Type	number
Description	Fossil generation e.g. coal, natural gas
Comment
Example
Unit

GAS_perc

Title	Gas percentage
Type	number
Description	Fuel Type as a percentage for gas generation.
Comment
Example
Unit	%

COAL_perc

Title	Coal percentage
Type	number
Description	Fuel Type as a percentage for coal generation.
Comment
Example
Unit	%

NUCLEAR_perc

Title	Nuclear percentage
Type	number
Description	Fuel Type as a percentage for nuclear generation.
Comment
Example
Unit	%

WIND_perc

Title	Wind percentage
Type	number
Description	Fuel Type as a percentage for wind generation.
Comment
Example
Unit	%

HYDRO_perc

Title	Hydro percentage
Type	number
Description	Fuel Type as a percentage for hydro generation.
Comment
Example
Unit	%

IMPORTS_perc

Title	Imports percentage
Type	number
Description	Fuel Type as a percentage for interconnector imports
Comment
Example
Unit	%

BIOMASS_perc

Title	Biomass percentage
Type	number
Description	Fuel Type as a percentage for biomass generation.
Comment
Example
Unit	%

OTHER_perc

Title	Other percentage
Type	number
Description	Fuel Type as a percentage for other generation.
Comment
Example
Unit	%

SOLAR_perc

Title	Solar percentage
Type	number
Description	Fuel Type as a percentage for solar generation.
Comment
Example
Unit	%

STORAGE_perc

Title	Storage percentage
Type	number
Description	Fuel Type as a percentage for storage
Comment
Example
Unit	%

GENERATION_perc

Title	Generation percentage
Type	number
Description	Fuel Type as a percentage for Sum of gas, coal, nuclear, wind, hydro and imports
Comment
Example
Unit	%

LOW_CARBON_perc

Title	Low Carbon percentage
Type	number
Description	Fuel Type as a percentage for low carbon generation e.g. wind, solar, hydro, nuclear, biomass
Comment
Example
Unit	%

ZERO_CARBON_perc

Title	Zero Carbon percentage
Type	number
Description	Fuel Type as a percentage for zero carbon generation e.g. wind, solar, hydro, nuclear
Comment
Example
Unit	%

RENEWABLE_perc

Title	Renewable percentage
Type	number
Description	Fuel Type as a percentage for Renewable generation e.g Wind, Hydro, Solar
Comment
Example
Unit	%

FOSSIL_perc

Title	Fossil percentage
Type	number
Description	Fuel Type as a percentage for Fossil generation e.g. coal, natural gas
Comment
Example
Unit	%

For any queries or feedback please contact [email protected]

You are now signed in

Historic GB Generation Mix

CKAN Data API

PowerBI

Data Explorer

Data Explorer

Data Explorer

Table Information

DATETIME

GAS

COAL

NUCLEAR

WIND

HYDRO

IMPORTS

BIOMASS

OTHER

SOLAR

STORAGE

GENERATION

CARBON_INTENSITY

LOW_CARBON

ZERO_CARBON

RENEWABLE

FOSSIL

GAS_perc

COAL_perc

NUCLEAR_perc

WIND_perc

HYDRO_perc

IMPORTS_perc

BIOMASS_perc

OTHER_perc

SOLAR_perc

STORAGE_perc

GENERATION_perc

LOW_CARBON_perc

ZERO_CARBON_perc

RENEWABLE_perc

FOSSIL_perc