Dynamic Containment - 4 Day forecast

Dynamic Containment High and Low requirements for the next four days.

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=1b85a3f3-80f0-49cf-9b0e-49648fa0cae6&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "1b85a3f3-80f0-49cf-9b0e-49648fa0cae6" LIMIT 5`

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

var data = {
  resource_id: '1b85a3f3-80f0-49cf-9b0e-49648fa0cae6', // 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=1b85a3f3-80f0-49cf-9b0e-49648fa0cae6&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date
Type	date
Description	The date for which the forecast is for.
Comment
Example	2022-04-26
Unit	ISO 8601

Service_Type

Title	Service Type
Type	string
Description	The service for which the forecast is for.
Comment	This field will contain DC-L for Dynamic Containment Low and DC-H for Dynamic Containment High.
Example	DC-L
Unit	N/A

EFA_1

Title	EFA 1
Type	integer
Description	The requirement for EFA block 1
Comment
Example	100
Unit	MW

EFA_2

Title	EFA 2
Type	integer
Description	The requirement for EFA block 2
Comment
Example	100
Unit	MW

EFA_3

Title	EFA 3
Type	integer
Description	The requirement for EFA block 3
Comment
Example	100
Unit	MW

EFA_4

Title	EFA 4
Type	integer
Description	The requirement for EFA block 4
Comment
Example	100
Unit	MW

EFA_5

Title	EFA 5
Type	integer
Description	The requirement for EFA block 5
Comment
Example	100
Unit	MW

EFA_6

Title	EFA 6
Type	integer
Description	The requirement for EFA block 6
Comment
Example	100
Unit	MW

For any queries or feedback please contact [email protected]

You are now signed in

Dynamic Containment - 4 Day forecast

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

Service_Type

EFA_1

EFA_2

EFA_3

EFA_4

EFA_5

EFA_6