Road Transport Notes (ED6) 2023

The Future Energy Scenarios (FES) represent a range of different, credible ways to decarbonise our energy system as we strive towards the 2050 target. 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 2023 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=30012023-6c0b-4da5-bd77-4f2b244a950d&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "30012023-6c0b-4da5-bd77-4f2b244a950d" LIMIT 5`

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

var data = {
  resource_id: '30012023-6c0b-4da5-bd77-4f2b244a950d', // 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=30012023-6c0b-4da5-bd77-4f2b244a950d&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Column

Title	Column
Type	string
Description	Column the note applies to from ED5
Comment
Example	Data Item
Unit	N/A

Title	Category
Type	string
Description	Terminology used in ED5
Comment
Example	# Cars - All
Unit	N/A

Description

Title	Description
Type	string
Description	Description of the category
Comment
Example	all cars (as defined by DfT/DVLA in https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/917624/vehicle-licensing-statistics-notes-definitions.pdf). History from Vehicle licensing data tables - VEH0101. Includes vehicles licenced as taxis from DfT taxi statistics taxi0102 and Scottish Transport Statistics table 1.4.
Unit	N/A

For any queries or feedback please contact [email protected]

You are now signed in

Road Transport Notes (ED6) 2023

CKAN Data API

Data Explorer

Data Explorer

Table Information

Column

Category

Description