Phase 2: FFR Auction Results by Unit 26.11.2021
Phase 2 FFR Auction Results by Unit 26.11.2021
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=87ee8fc4-11ae-4575-b734-99548aab2d98&limit=5
|
Query example (via SQL statement) |
https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "87ee8fc4-11ae-4575-b734-99548aab2d98" LIMIT 5
|
A simple ajax (JSONP) request to the data API using jQuery.
var data = { resource_id: '87ee8fc4-11ae-4575-b734-99548aab2d98', // 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=87ee8fc4-11ae-4575-b734-99548aab2d98&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
Data Explorer
Table Information
Company
Title | Company |
---|---|
Type | string |
Description | The member of the trial who submitted the bid |
Comment | |
Example | Example Company |
Unit |
Unit Name
Title | Unit Name |
---|---|
Type | string |
Description | The unit which would provide the FFR being bidded for. |
Comment | |
Example | FFR-01 |
Unit |
EFA Date
Title | Electricity Forward Agreement Date |
---|---|
Type | date |
Description | Equivalent date to the delivery end date in this instance. |
Comment | |
Example | 13/03/2020 |
Unit |
Delivery Start
Title | Delivery Start |
---|---|
Type | datetime |
Description | The time from which delivery of FFR will commence |
Comment | |
Example | 13/03/2020 23:00:00 |
Unit |
Delivery End
Title | Delivery End |
---|---|
Type | datetime |
Description | The time from which delivery of FFR will end |
Comment | |
Example | 13/03/2020 22:00:00 |
Unit |
EFA
Title | Electricity Forward Agreement |
---|---|
Type | integer |
Description | The week is split into 42 blocks, with 6 four-hour blocks each day |
Comment | |
Example | 1 |
Unit |
Service
Title | Service |
---|---|
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 | LFS |
Unit |
Cleared Volume
Title | Cleared Volume |
---|---|
Type | integer |
Description | The volume of response that was accepted as per the cleared price. |
Comment | |
Example | 5 |
Unit | MW |
Clearing Price
Title | Clearing Price |
---|---|
Type | number |
Description | The cleared price per MW per hour. |
Comment | |
Example | 9.8 |
Unit | £/MW/h |
Cancelled
Title | Cancelled |
---|---|
Type | string |
Description | Whether or not the bid has been cancelled |
Comment | |
Example | |
Unit |