Week Ahead Overnight Voltage Requirement 20-24

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=00881643-7a5e-4eed-b144-06423a88202b&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "00881643-7a5e-4eed-b144-06423a88202b" LIMIT 5`

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

var data = {
  resource_id: '00881643-7a5e-4eed-b144-06423a88202b', // 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=00881643-7a5e-4eed-b144-06423a88202b&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Start Date

Title	Start Date
Type	date
Description	Start date of the voltage plan
Comment
Example	2021-02-04
Unit

End Date

Title	End Date
Type	date
Description	End date of the voltage plan
Comment
Example	2021-02-05
Unit

Group

Title	Voltage Group
Type	string
Description	Voltage requirement group name
Comment
Example	VLONDON
Unit

Units

Title	No. of Unit
Type	integer
Description	No. of Units might be required to meet the voltage plan
Comment
Example	3
Unit

Notes

Title	Note
Type	string
Description	Notes
Comment
Example	optimisation likely
Unit

Last Updated

Title	Last Updated
Type	datetime
Description	Datetime of last update
Comment
Example	2021-02-02T00:00Z
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Week Ahead Overnight Voltage Requirement 20-24

CKAN Data API

Data Explorer

Data Explorer

Table Information

Start Date

End Date

Group

Units

Notes

Last Updated