STOR DA Auction Results

STOR DA Auction Results for 30/06/2024

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=844a1a65-0a3c-4704-b327-d1685d0c397b&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "844a1a65-0a3c-4704-b327-d1685d0c397b" LIMIT 5`

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

var data = {
  resource_id: '844a1a65-0a3c-4704-b327-d1685d0c397b', // 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=844a1a65-0a3c-4704-b327-d1685d0c397b&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

PowerBI

Data Explorer

Table Information

Service Name

Title	Service Name
Type	string
Description	The service name is Short Term Operating Reserve
Comment	All submissions are Short Term Operating Reserve only
Example	Short Term Operating Reserve
Unit

Tender Round ID

Title	Tender Round ID
Type	string
Description	Unique Identifier generated for a given tender round
Comment	The format is "TRN-XXXX" (XXXX is an autogenerated number)
Example	TRN-0658
Unit

Buy Curve ID

Title	Buy Curve ID
Type	string
Description	Unique Identifier generated for a given Buy Curve
Comment	The format is "BCN-XXXXXXXX" (XXXXXXXX is an autogenerated number)
Example	BCN-00000095
Unit

Tender Submission ID

Title	Tender Submission ID
Type	string
Description	Unique Identifier generated for a given tender submission
Comment	The format is "TS-XXXXXX" (XXXXXX is an autogenerated number)
Example	TS-001085
Unit

Service Delivery From

Title	Service Delivery From
Type	datetime
Description	Start date and time from which the service is delivered
Comment	The Format is DD/MM/YYYY HH:MM
Example	13/02/2021 05:00
Unit

Service Delivery To

Title	Service Delivery To
Type	datetime
Description	End date and time of the date range in which the service is delivered
Comment	The Format is DD/MM/YYYY HH:MM
Example	14/02/2021 05:00
Unit

Unit ID

Title	Unit ID
Type	string
Description	NGT Unit Id
Comment
Example	PETEM-1
Unit

Company Name

Title	Company Name
Type	string
Description	Name of the STOR Service Provider
Comment	Company who has framework agreement with NG and delivers the STOR Service
Example	Centrica PB Ltd
Unit

BM/NBM

Title	BM/NBM
Type	string
Description	Identifies if a given unit is BM unit or Non BM Unit
Comment
Example	NBM
Unit

Fuel Type

Title	Fuel Type
Type	string
Description	The Fuel Type for a given BM or NBM unit
Comment
Example	Pump Storage
Unit

Tendered MW

Title	Tendered MW
Type	number
Description	Capacity in MW offered by the Service Provider for the availability windows during tender submission
Comment
Example	6
Unit	MW

Minimum Acceptable MW

Title	Minimum Acceptable MW
Type	number
Description
Comment
Example
Unit

Contracted MW

Title	Contracted MW
Type	number
Description	Capacity in MW of the Supplier for the availabilty windows accepted by us.
Comment
Example	7
Unit	MW

Tendered Availability Price

Title	Tendered Availability Price
Type	number
Description	Tendered Availability Price
Comment
Example
Unit	£/MW/Hr

Market Clearing Price

Title	Market Clearing Price
Type	number
Description	Availability price offered to Service Provider for a given tender submission
Comment	The price is limited to two decimals
Example	2.54
Unit	£/MW/Hr

Status

Title	Status
Type	string
Description	The status of the given tender submission
Comment
Example	Accepted
Unit

For any queries or feedback please contact [email protected]

You are now signed in

STOR DA Auction Results

CKAN Data API

PowerBI

Data Explorer

Data Explorer

Data Explorer

Table Information

Service Name

Tender Round ID

Buy Curve ID

Tender Submission ID

Service Delivery From

Service Delivery To

Unit ID

Company Name

BM/NBM

Fuel Type

Tendered MW

Minimum Acceptable MW

Contracted MW

Tendered Availability Price

Market Clearing Price

Status