October 2023 – 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. 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.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=530d18c9-01bc-4620-9911-0d03c7152081&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "530d18c9-01bc-4620-9911-0d03c7152081" LIMIT 5`

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

var data = {
  resource_id: '530d18c9-01bc-4620-9911-0d03c7152081', // 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=530d18c9-01bc-4620-9911-0d03c7152081&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

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
Comment
Example	2021-11-01 00:00:01
Unit

f

Title	System Frequency (Hz)
Type	number
Description	The system frequency as measured at that second in time.
Comment
Example	50.00
Unit	Hz

For any queries or feedback please contact [email protected]

You are now signed in

October 2023 – Historic Frequency Data

CKAN Data API

Data Explorer

Data Explorer

Table Information

dtm

f