ODFM Instructed Volume for 05-07-2020

Note: A new version of this file was uploaded on Monday 07/07/2020. Please use the new version named "ODFM Instructed Volume for 05-07-2020 V2" This is the ODFM instructed volume for Sunday. The BMRS Demand forecast has already been adjusted for this.

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=f0a52698-5f80-4fb7-ad64-ede99015195f&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "f0a52698-5f80-4fb7-ad64-ede99015195f" LIMIT 5`

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

var data = {
  resource_id: 'f0a52698-5f80-4fb7-ad64-ede99015195f', // 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=f0a52698-5f80-4fb7-ad64-ede99015195f&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Settlement Period

Title	Settlement Period
Type	integer
Description	A period of 30 minutes beginning on the hour or the half-hour.
Comment
Example	4
Unit

ODFM Instructed MW

Title	ODFM Instructed MW
Type	integer
Description	ODFM instructed in MW.
Comment
Example	776
Unit	MW

Time

Title	Time
Type	time
Description	Time of when instruction took place.
Comment
Example	23:00
Unit

Date

Title	Date
Type	date
Description	Date of ODFM
Comment
Example	05/07/2020
Unit

For any queries or feedback please contact [email protected]

You are now signed in

ODFM Instructed Volume for 05-07-2020

CKAN Data API

Data Explorer

Data Explorer

Table Information

Settlement Period

ODFM Instructed MW

Time

Date