Phase 2 FFR Auction BlockOrders Masterdata 2021-2022

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=89467af0-a577-4bba-9955-f8c380a78923&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "89467af0-a577-4bba-9955-f8c380a78923" LIMIT 5`

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

var data = {
  resource_id: '89467af0-a577-4bba-9955-f8c380a78923', // 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=89467af0-a577-4bba-9955-f8c380a78923&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

MarketName

Title	Market Name
Type	string
Description	The market for which the bid is in relation to. The two choices are DLH (Dynamic Low High) and LFS (Low Frequency Static)
Comment
Example	DLH
Unit

BiddingLevelName

Title	Bidding Level Name
Type	string
Description	The market for which the bid is in relation to. The two choices are DLH (Dynamic Low High) and LFS (Low Frequency Static)
Comment
Example	DLH
Unit

MemberName

Title	Member Name
Type	string
Description	The member of the trial who submitted the bid
Comment
Example	Example company
Unit

OrderID

Title	Order ID
Type	integer
Description	The ID for the submitted bid in the auction
Comment
Example	100000000013081
Unit

Portfolio

Title	Portfolio
Type	string
Description	The portfolio associated with the FFR provider
Comment
Example	FFR_1
Unit

OrderEntryTime

Title	Order Entry Time
Type	datetime
Description	The time at which the bid was submitted
Comment
Example	12/3/2020 13:23
Unit

OrderEntryUser

Title	Order Entry User
Type	string
Description	The user who submitted the entry
Comment
Example	ESO-123-D
Unit

SettlementCurrency

Title	Settlement Currency
Type	string
Description	The currency in which the bid was submitted
Comment
Example	GBP
Unit

ClearingPrice

Title	Clearing Price
Type	number
Description	The market clearing price is dependent on the price of the highest-priced sell order executed in the auction. When the highest-price sell order is a single-period block order, the market clearing price is the price of this order
Comment
Example	12.34
Unit	£/MW

Price

Title	Price
Type	number
Description	The price for the provision of the service
Comment
Example	7.9
Unit	£/MW

MAR

Title	MAR
Type	integer
Description	Automatically infilled, please leave blank
Comment
Example	1
Unit

Status

Title	Status
Type	boolean
Description	Was the bid executed or rejected
Comment
Example	Executed
Unit

BlockCode

Title	Block Code
Type	string
Description	Either C01 for a non-curtailable block (may be a parent in a linked family or may be a standalone block) or C02 for a fully curtailable child block
Comment
Example	C01
Unit

BlockCodePRM

Title	Block Code PRM
Type	string
Description	Blank for a C01 block, for a C02 block infill the Order ID of the parent
Comment
Example	NA
Unit

Paradoxically

Title	Paradoxically
Type	boolean
Description	Is this bid paradoxical in relation to other bids?
Comment
Example	No
Unit

OrderPeriodID

Title	Order Period ID
Type	integer
Description	ID for the order period
Comment
Example	100000000017734
Unit

TradeID

Title	Trade ID
Type	integer
Description	Identical to previous column
Comment
Example	100000000017734
Unit

EFA

Title	EFA
Type	integer
Description	The week is split into 42 blocks, with 6 four-hour blocks each day
Comment
Example	18
Unit

DeliveryStart

Title	Delivery Start
Type	datetime
Description	The time from which delivery of FFR will commence
Comment
Example	12/3/2020 13:23
Unit

DeliveryEnd

Title	Delivery End
Type	datetime
Description	The time from which delivery of FFR will end
Comment
Example	12/3/2020 13:23
Unit

ExecutedVolume

Title	Executed Volume
Type	integer
Description	The volume of the order which is executed
Comment
Example	-9
Unit	MW

Volume

Title	Volume
Type	integer
Description	The total volume of the bid
Comment
Example	-9
Unit	MW

Invalid

Title	Invalid bid - contract rejected
Type	boolean
Description	Whether or not the bid is invalid
Comment
Example	FALSE
Unit

Bid Validity

Title	Bid validity
Type	string
Description	Whether or not the bid is invalid
Comment
Example	FALSE
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Phase 2 FFR Auction BlockOrders Masterdata 2021-2022

CKAN Data API

Data Explorer

Data Explorer

Table Information

MarketName

BiddingLevelName

MemberName

OrderID

Portfolio

OrderEntryTime

OrderEntryUser

SettlementCurrency

ClearingPrice

Price

MAR

Status

BlockCode

BlockCodePRM

Paradoxically

OrderPeriodID

TradeID

EFA

DeliveryStart

DeliveryEnd

ExecutedVolume

Volume

Invalid

Bid Validity