Tariffs To Trade With The UK From 1 January 2021
Department for Business and Trade
@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211
Department for Business and Trade
@ukgov.tariffs_to_trade_with_the_uk_from_1_january_20211
CREATE TABLE v4_0_1042_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_suffix" BIGINT,
"commodity_description" VARCHAR,
"commodity_validity_start" TIMESTAMP,
"commodity_validity_end" VARCHAR,
"parent_sid" VARCHAR,
"parent_code" VARCHAR,
"parent_suffix" VARCHAR
);
CREATE TABLE v4_0_1042_measures_as_defined (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1042_measures_on_declarable_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1043_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_suffix" BIGINT,
"commodity_description" VARCHAR,
"commodity_validity_start" TIMESTAMP,
"commodity_validity_end" VARCHAR,
"parent_sid" VARCHAR,
"parent_code" VARCHAR,
"parent_suffix" VARCHAR
);
CREATE TABLE v4_0_1043_measures_as_defined (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1043_measures_on_declarable_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1044_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_suffix" BIGINT,
"commodity_description" VARCHAR,
"commodity_validity_start" TIMESTAMP,
"commodity_validity_end" VARCHAR,
"parent_sid" VARCHAR,
"parent_code" VARCHAR,
"parent_suffix" VARCHAR
);
CREATE TABLE v4_0_1044_measures_as_defined (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1044_measures_on_declarable_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1045_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_suffix" BIGINT,
"commodity_description" VARCHAR,
"commodity_validity_start" TIMESTAMP,
"commodity_validity_end" VARCHAR,
"parent_sid" VARCHAR,
"parent_code" VARCHAR,
"parent_suffix" VARCHAR
);
CREATE TABLE v4_0_1045_measures_as_defined (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1045_measures_on_declarable_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1046_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_suffix" BIGINT,
"commodity_description" VARCHAR,
"commodity_validity_start" TIMESTAMP,
"commodity_validity_end" VARCHAR,
"parent_sid" VARCHAR,
"parent_code" VARCHAR,
"parent_suffix" VARCHAR
);
CREATE TABLE v4_0_1046_measures_as_defined (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1046_measures_on_declarable_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1047_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_suffix" BIGINT,
"commodity_description" VARCHAR,
"commodity_validity_start" TIMESTAMP,
"commodity_validity_end" VARCHAR,
"parent_sid" VARCHAR,
"parent_code" VARCHAR,
"parent_suffix" VARCHAR
);
CREATE TABLE v4_0_1047_measures_as_defined (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
CREATE TABLE v4_0_1047_measures_on_declarable_commodities (
"id" BIGINT,
"commodity_sid" BIGINT,
"commodity_code" BIGINT,
"commodity_indent" BIGINT,
"commodity_description" VARCHAR,
"measure_sid" BIGINT,
"measure_type_id" BIGINT,
"measure_type_description" VARCHAR,
"measure_additional_code_code" VARCHAR,
"measure_additional_code_description" VARCHAR,
"measure_duty_expression" VARCHAR,
"measure_effective_start_date" TIMESTAMP,
"measure_effective_end_date" VARCHAR,
"measure_reduction_indicator" VARCHAR,
"measure_footnotes" VARCHAR,
"measure_conditions" VARCHAR,
"measure_geographical_area_sid" BIGINT,
"measure_geographical_area_id" VARCHAR,
"measure_geographical_area_description" VARCHAR,
"measure_excluded_geographical_areas_ids" VARCHAR,
"measure_excluded_geographical_areas_descriptions" VARCHAR,
"measure_quota_order_number" VARCHAR,
"measure_regulation_id" VARCHAR,
"measure_regulation_url" VARCHAR
);
Anyone who has the link will be able to view this.