NESO Response-Reserve Sell Orders FY2023-FY2024 (Archive)
This is the archive file which contains, for each sell order ID, the quantity that market participants were willing to provide for each auction product and period depending on the price. It also includes the sell order type (parent, child, or substitutable child) among other parameters. Additionally, the file includes information on the cleared quantity, cleared price and rejection codes for each Order ID
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=3780a81e-bee4-43e2-9ebe-ef85d2ba18de&limit=5
|
| Query example (via SQL statement) |
https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "3780a81e-bee4-43e2-9ebe-ef85d2ba18de" LIMIT 5
|
A simple ajax (JSONP) request to the data API using jQuery.
var data = {
resource_id: '3780a81e-bee4-43e2-9ebe-ef85d2ba18de', // 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=3780a81e-bee4-43e2-9ebe-ef85d2ba18de&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
Data Explorer
Table Information
auctionID
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
registeredAuctionParticipant
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |
auctionUnit
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |
basketID
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
serviceType
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |
deliveryStart
| Title | |
|---|---|
| Type | datetime |
| Description | |
| Comment | |
| Example | |
| Unit |
deliveryEnd
| Title | |
|---|---|
| Type | datetime |
| Description | |
| Comment | |
| Example | |
| Unit |
orderID
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
orderType
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |
auctionProduct
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |
productID
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
quantity
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
priceLimit
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
loopedBasketID
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
orderEntryTime
| Title | |
|---|---|
| Type | datetime |
| Description | |
| Comment | |
| Example | |
| Unit |
acceptanceRatio
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
status
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |
executedQuantity
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
clearingPrice
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
reasonRejected
| Title | |
|---|---|
| Type | any |
| Description | |
| Comment | |
| Example | |
| Unit |
flexibleGroupID
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |
minimumConsecutiveWindows
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |
source_file
| Title | |
|---|---|
| Type | string |
| Description | |
| Comment | |
| Example | |
| Unit |