About this Dataset

Tariffs To Trade With The UK From 1 January 2021

This dataset shows the UK import tariffs which apply from 1 January 2021.

It lists preferential measures where the UK has entered into a new trade agreement or arrangement with a third country or territory. For other countries and territories, it shows the UK's Most Favoured Nation (MFN) tariffs. The dataset does not include other import duties (such as VAT) and details of quota volumes.
Publisher name: Department for Business and Trade
Last updated: 2025-07-02T04:06:36Z

Tables

V4.0.1042 - Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1042_commodities

1.12 MB
25,428 rows
10 columns

CREATE TABLE v4_0_1042_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_suffix" BIGINT  -- Commodity, Suffix,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "commodity_validity_start" TIMESTAMP  -- Commodity, Validity Start,
  "commodity_validity_end" VARCHAR  -- Commodity, Validity End,
  "parent_sid" VARCHAR  -- Parent, Sid,
  "parent_code" VARCHAR  -- Parent, Code,
  "parent_suffix" VARCHAR  -- Parent, Suffix
);

V4.0.1042 - Measures As Defined

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1042_measures_as_defined

2.34 MB
82,857 rows
24 columns

CREATE TABLE v4_0_1042_measures_as_defined (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1042 - Measures On Declarable Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1042_measures_on_declarable_commodities

9.88 MB
1,096,231 rows
24 columns

CREATE TABLE v4_0_1042_measures_on_declarable_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1043 - Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1043_commodities

1.12 MB
25,428 rows
10 columns

CREATE TABLE v4_0_1043_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_suffix" BIGINT  -- Commodity, Suffix,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "commodity_validity_start" TIMESTAMP  -- Commodity, Validity Start,
  "commodity_validity_end" VARCHAR  -- Commodity, Validity End,
  "parent_sid" VARCHAR  -- Parent, Sid,
  "parent_code" VARCHAR  -- Parent, Code,
  "parent_suffix" VARCHAR  -- Parent, Suffix
);

V4.0.1043 - Measures As Defined

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1043_measures_as_defined

2.34 MB
82,712 rows
24 columns

CREATE TABLE v4_0_1043_measures_as_defined (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1043 - Measures On Declarable Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1043_measures_on_declarable_commodities

9.87 MB
1,095,922 rows
24 columns

CREATE TABLE v4_0_1043_measures_on_declarable_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1044 - Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1044_commodities

1.13 MB
25,517 rows
10 columns

CREATE TABLE v4_0_1044_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_suffix" BIGINT  -- Commodity, Suffix,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "commodity_validity_start" TIMESTAMP  -- Commodity, Validity Start,
  "commodity_validity_end" VARCHAR  -- Commodity, Validity End,
  "parent_sid" VARCHAR  -- Parent, Sid,
  "parent_code" VARCHAR  -- Parent, Code,
  "parent_suffix" VARCHAR  -- Parent, Suffix
);

V4.0.1044 - Measures As Defined

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1044_measures_as_defined

2.34 MB
82,660 rows
24 columns

CREATE TABLE v4_0_1044_measures_as_defined (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1044 - Measures On Declarable Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1044_measures_on_declarable_commodities

9.91 MB
1,100,483 rows
24 columns

CREATE TABLE v4_0_1044_measures_on_declarable_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1045 - Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1045_commodities

1.13 MB
25,517 rows
10 columns

CREATE TABLE v4_0_1045_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_suffix" BIGINT  -- Commodity, Suffix,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "commodity_validity_start" TIMESTAMP  -- Commodity, Validity Start,
  "commodity_validity_end" VARCHAR  -- Commodity, Validity End,
  "parent_sid" VARCHAR  -- Parent, Sid,
  "parent_code" VARCHAR  -- Parent, Code,
  "parent_suffix" VARCHAR  -- Parent, Suffix
);

V4.0.1045 - Measures As Defined

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1045_measures_as_defined

2.34 MB
82,651 rows
24 columns

CREATE TABLE v4_0_1045_measures_as_defined (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1045 - Measures On Declarable Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1045_measures_on_declarable_commodities

9.91 MB
1,100,483 rows
24 columns

CREATE TABLE v4_0_1045_measures_on_declarable_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1046 - Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1046_commodities

1.13 MB
25,517 rows
10 columns

CREATE TABLE v4_0_1046_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_suffix" BIGINT  -- Commodity, Suffix,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "commodity_validity_start" TIMESTAMP  -- Commodity, Validity Start,
  "commodity_validity_end" VARCHAR  -- Commodity, Validity End,
  "parent_sid" VARCHAR  -- Parent, Sid,
  "parent_code" VARCHAR  -- Parent, Code,
  "parent_suffix" VARCHAR  -- Parent, Suffix
);

V4.0.1046 - Measures As Defined

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1046_measures_as_defined

2.34 MB
82,662 rows
24 columns

CREATE TABLE v4_0_1046_measures_as_defined (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1046 - Measures On Declarable Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1046_measures_on_declarable_commodities

9.91 MB
1,100,629 rows
24 columns

CREATE TABLE v4_0_1046_measures_on_declarable_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1047 - Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1047_commodities

1.14 MB
25,594 rows
10 columns

CREATE TABLE v4_0_1047_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_suffix" BIGINT  -- Commodity, Suffix,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "commodity_validity_start" TIMESTAMP  -- Commodity, Validity Start,
  "commodity_validity_end" VARCHAR  -- Commodity, Validity End,
  "parent_sid" VARCHAR  -- Parent, Sid,
  "parent_code" VARCHAR  -- Parent, Code,
  "parent_suffix" VARCHAR  -- Parent, Suffix
);

V4.0.1047 - Measures As Defined

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1047_measures_as_defined

2.34 MB
82,929 rows
24 columns

CREATE TABLE v4_0_1047_measures_as_defined (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);

V4.0.1047 - Measures On Declarable Commodities

@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211.v4_0_1047_measures_on_declarable_commodities

9.98 MB
1,106,689 rows
24 columns

CREATE TABLE v4_0_1047_measures_on_declarable_commodities (
  "id" BIGINT,
  "commodity_sid" BIGINT  -- Commodity, Sid,
  "commodity_code" BIGINT  -- Commodity, Code,
  "commodity_indent" BIGINT  -- Commodity, Indent,
  "commodity_description" VARCHAR  -- Commodity, Description,
  "measure_sid" BIGINT  -- Measure, Sid,
  "measure_type_id" BIGINT  -- Measure, Type, Id,
  "measure_type_description" VARCHAR  -- Measure, Type, Description,
  "measure_additional_code_code" VARCHAR  -- Measure, Additional Code, Code,
  "measure_additional_code_description" VARCHAR  -- Measure, Additional Code, Description,
  "measure_duty_expression" VARCHAR  -- Measure, Duty Expression,
  "measure_effective_start_date" TIMESTAMP  -- Measure, Effective Start Date,
  "measure_effective_end_date" VARCHAR  -- Measure, Effective End Date,
  "measure_reduction_indicator" VARCHAR  -- Measure, Reduction Indicator,
  "measure_footnotes" VARCHAR  -- Measure, Footnotes,
  "measure_conditions" VARCHAR  -- Measure, Conditions,
  "measure_geographical_area_sid" BIGINT  -- Measure, Geographical Area, Sid,
  "measure_geographical_area_id" VARCHAR  -- Measure, Geographical Area, Id,
  "measure_geographical_area_description" VARCHAR  -- Measure, Geographical Area, Description,
  "measure_excluded_geographical_areas_ids" VARCHAR  -- Measure, Excluded Geographical Areas, Ids,
  "measure_excluded_geographical_areas_descriptions" VARCHAR  -- Measure, Excluded Geographical Areas, Descriptions,
  "measure_quota_order_number" VARCHAR  -- Measure, Quota, Order Number,
  "measure_regulation_id" VARCHAR  -- Measure, Regulation, Id,
  "measure_regulation_url" VARCHAR  -- Measure, Regulation, Url
);