December 2019 - Historic Frequency Data

Historic frequency data for Great Britain at a 1-second resolution.

dtm - The date in a YYYY-MM-DD format, followed by the time in a HH:MM:SS format, given in Coordinated Universal Time (UTC).

f - The system frequency as measured at that second in time.

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=f0933bdd-1b0e-4dd3-aa7f-5498df1ba5b9&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "f0933bdd-1b0e-4dd3-aa7f-5498df1ba5b9" LIMIT 5`

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

var data = {
  resource_id: 'f0933bdd-1b0e-4dd3-aa7f-5498df1ba5b9', // 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=f0933bdd-1b0e-4dd3-aa7f-5498df1ba5b9&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Table Information

dtm

Title	Date and time
Type	datetime
Description	The date in a YYYY-MM-DD format, followed by the time in a HH:MM:SS format, followed by the timezone in a +HHHH format.
Comment
Example	2019-12-01 00:00:02 +0000
Unit

f

Title	System Frequency (Hz)
Type	number
Description	The system frequency as measured at that second in time.
Comment	If generation and demand were in balance the system would be running at 50 Hz. If the frequency is below 50 Hz, demand is greater than generation and if the frequency is over 50 Hz the converse is true.
Example	50.004
Unit	Hz

You are now signed in

December 2019 - Historic Frequency Data

CKAN Data API

Table Information

dtm

f