Road Transport Notes (ED6) 2024

One of the FES outputs is an agreed set of data tables containing the GB FES values for road transport. This dataset is a file supporting those data tables. The file is the 2024 version of the dataset.

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=7fe93ddc-7a88-478b-8f60-4531c15bd538&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "7fe93ddc-7a88-478b-8f60-4531c15bd538" LIMIT 5`

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

var data = {
  resource_id: '7fe93ddc-7a88-478b-8f60-4531c15bd538', // 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=7fe93ddc-7a88-478b-8f60-4531c15bd538&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Column

Title
Type	string
Description
Comment
Example
Unit

Description

Title
Type	string
Description
Comment
Example
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Road Transport Notes (ED6) 2024

CKAN Data API

Data Explorer

Data Explorer

Table Information

Column

Category

Description