Phase 2 FFR Auction ResultsByUnit Masterdata 2020-2021
Phase 2 FFR Auction ResultsByUnit Masterdata 2020-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=52faffc9-e804-44d8-b222-dd0821d79e7d&limit=5
|
| Query example (via SQL statement) |
https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "52faffc9-e804-44d8-b222-dd0821d79e7d" LIMIT 5
|
A simple ajax (JSONP) request to the data API using jQuery.
var data = {
resource_id: '52faffc9-e804-44d8-b222-dd0821d79e7d', // 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=52faffc9-e804-44d8-b222-dd0821d79e7d&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
Data Explorer
Table Information
Company
| Title | Company name |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | Company Name Ltd |
| Unit | string |
Unit Name
| Title | Unit delivering service |
|---|---|
| Type | string |
| Description | Unit that will be delivering service |
| Comment | |
| Example | UKBB-1 |
| Unit | string |
EFA Date
| Title | EFA Date |
|---|---|
| Type | string |
| Description | EFA Date |
| Comment | |
| Example | 06/12/2019 23:00:00 |
| Unit | datetime |
Delivery Start
| Title | Delivery Start datetime |
|---|---|
| Type | datetime |
| Description | Delivery Start datetime |
| Comment | |
| Example | 07/12/2019 03:00:00 |
| Unit | datetime |
Delivery End
| Title | Delivery End datetime |
|---|---|
| Type | datetime |
| Description | Delivery Start datetime |
| Comment | |
| Example | 07/12/2019 03:00:00 |
| Unit | number |
EFA
| Title | EFA |
|---|---|
| Type | string |
| Description | EFA |
| Comment | |
| Example | 1 |
| Unit | number |
Service
| Title | Service procured |
|---|---|
| Type | string |
| Description | DLH Dynamic Low High LFS Low Frequency Static |
| Comment | |
| Example | DLH |
| Unit | string |
Cleared Volume
| Title | Volume cleared |
|---|---|
| Type | number |
| Description | Volume Cleared |
| Comment | |
| Example | 10 |
| Unit | MW |
Clearing Price
| Title | Clearing Price |
|---|---|
| Type | number |
| Description | Clearing price |
| Comment | |
| Example | 10 |
| Unit | £/MW/h |
Cancelled
| Title | |
|---|---|
| Type | |
| Description | |
| Comment | |
| Example | |
| Unit |