Phase 2 FFR Auction BlockOrders Masterdata 2021-2022
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 example (first 5 results) |
---|
https://api.neso.energy/api/3/action/datastore_search?resource_id=89467af0-a577-4bba-9955-f8c380a78923&limit=5
|
Query example (via SQL statement) |
https://api.neso.energy/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.neso.energy/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.neso.energy/api/3/action/datastore_search?resource_id=89467af0-a577-4bba-9955-f8c380a78923&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
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 |