dataset catalogue

HELP AND INFORMATION

Measures within the table:

  • Value – the statistical value in pounds sterling (£) of the trade
  • Net mass – the weight of the trade items in kilograms (kg)
  • Supplementary Unit – the quantity of trade items e.g. pairs of shoes, litres of whisky etc.
 
Note: Net mass and supplementary unit requirements differ for different commodities.
 
For further explanation of the measures click here

Country Information

To see all countries and geographical areas included on the tables click here.

Dimensions:

  • Commodity - HS2 to CN8, or SITC 1-5 hierarchy
  • EU indicator - World, EU, Non-EU and Continent groupings
  • Year / Month (or Quarter for RTS)
  • Flow - Import, Export, Arrival, Dispatch Port - UK place of clearance (for Non-EU trade only)

Table Building Tutorials

Available in the ‘Help’ tab in the interactive table area, or by clicking on the image below.
 
​​​​​

Build Your Own Tables

Introduction

​The ‘Dataset Catalogue’ links in the left-hand navigation bar provide direct access to our interactive data tables, where the following datasets can be accessed:

Data by Commodity Code (Overseas Trade Statistics)
  • UK import and export data from 1996 to current period, by month
  • HS2, HS4, HS6 and CN8 commodity code levels
  • EU estimates for non-response and Below Threshold Trade at HS2
  • UK port data (place of clearance) for Non-EU trade

Data by SITC (Standard International Trade Classification
  • SITC correlation of the Overseas Trade Statistics (OTS) from 1996 to current period, by month
  • SITC 1-5 digit
  • EU estimates for non-response and Below Threshold Trade at SITC2
  • UK port data (place of clearance) for Non-EU trade

RTS Data (Regional Trade Statistics)
  • RTS data from 1996 to current quarter
  • OTS imports and exports allocated to a standard UK region

Further information regarding OTS and RTS data can be found in the ‘Statistics’ drop-down menu. Further information regarding SITC can be found in the ‘Codes & Guides’ menu under ‘Goods Classification System’.

Changes in Methodology
Changes in Methodology applied to OTS and RTS data are not back cast in the Interactive Tables:

These are:

Switch from General Trade to Special Trade

  • OTS - May 2016
  • RTS - Quarter 2 2016

New RTS Methodology - Quarter 3 2016

How to use the interactive tables

Once you have made a selection from the ‘Dataset Catalogue’ you will enter the interactive data area. You will be presented with a default table grid displaying the latest releases (last 3 months for Data by Commodity Code and SITC, more for RTS). You will be able customise the table view by selecting the measures and dimensions (see our Help and Information box) you want by choosing from dropdown filter boxes.

Once you have made your selection, simply click ok to build your table or cancel to discard the selection and return to the previous view.

Using this method you can ‘drill down’ from high-level aggregate data to increasing levels of detail e.g. from Non-EU to Continent groupings, to country.

Grouping and aggregation

The interactive data tables are designed to ‘total’ the data values included in the selection. This means that when you make selections from the measure/dimension filters, you will at first be presented with the data in an aggregate format. To reach the true data values for your selection, you should use the + icon to expand the measure/dimension view to reach the greatest level of detail selected. This can be reversed by collapsing rows or columns by using the – icon.

This is important to remember when filtering, as the table first presented may be misleading until you expand out the detail.

Saving and exporting data tables

A drop down option is available at the top of the interactive data table page to enable you to export the data view from the table in Excel, PDF or CSV format.

In addition, you can save the table that you have built for up to 3 months by clicking on the ‘Save Table View’ button and selecting to copy the URL. You can then paste the contents of the pop up box (a web link) into another application (e.g. a Word document, an email, save as a web favourite or even share on a social networking site). The system will store the details of the saved table view so that when you click on the saved web link you will see the table view you selected to save.

Please note – if you save your tables via this method, the web links (URLs) are only kept on our web server for 3 months due to capacity constraints. If you wish to keep your tables for longer, you can do so by registering (free of charge) to save tables using our combined Alert Service/Data Tables registration form.

We recommend you save the table as a web link first (using the ‘Save Table View’ process above) before registering (or subsequently logging in), to avoid losing the table you have created whilst completing these stages.

Detailed help in building tables is available by clicking on the ‘Help’ tab in the interactive data area (see ‘Table Building Tutorials’ in the ‘Help and Information’ box).

Changing from general trade to special trade: effect on port statistics

Due to the switch to special trade reporting from May 2016, 'Port' data (as compiled from the 'Place of Clearance' data on customs declarations) will appear to be missing when searching for data on goods being removed from customs warehousing. This is because the requirement for approved operators to submit supplementary customs declarations for goods imported into customs warehousing is waived and, with it, the 'Port' data element. There is no requirement to declare 'Port' data for goods being removed from customs warehousing. However, there is likely to be some 'Port' data available (i.e. from businesses submitting full customs declarations for entry into customs warehousing or those who continue to submit customs supplementary declarations voluntarily). As a result, 'Port' data in these circumstances will be incomplete.

Risk of losing saved data reports when changing email address

When you create an account, your email address is set up automatically as your user account/login name, and any reports you save will be associated with this user name.

If, in the future, you obtain a new email address and change it on this site using the ‘edit profile’ function, you will no longer be able to retrieve your reports because they will have been stored for your old email address, which the system would then interpret as belonging to a different customer.

Therefore we recommend that, before changing your email address in the future, you should first log in using your registered email address and retrieve each of your reports, and then use the ‘save table view’ to save the URL of each report and paste them into a Word document.

Once you’ve saved all the links to the reports you need in this way, you can then change your email address, click on the saved links and re-save each of them to your new “my reports account”.

​​