Baselight
Sign In

Trade Control & Expert System – Food Of Non-Animal Origin

Food Standards Agency

@ukgov.trade_control_expert_system_food_of_non_animal_origin

Loading...
Loading...

About this Dataset

Trade Control & Expert System – Food Of Non-Animal Origin

High-risk food of non-animal origin imported into the United Kingdom via approved designated ports.
Publisher name: Food Standards Agency
Last updated: 2025-04-30T04:00:21Z

Tables

Food Non-Animal Origin - April 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_april_2021
  • 17.33 kB
  • 332 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_april_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - April 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_april_2022
  • 17.35 kB
  • 296 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_april_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - April 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_april_2023
  • 28.8 kB
  • 1,623 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_april_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - April 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_april_2024
  • 45.18 kB
  • 3,102 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_april_2024 (
  "countryoforigin" VARCHAR,
  "countryfromwhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - August 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_august_2021
  • 16.79 kB
  • 240 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_august_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - August 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_august_2022
  • 16.66 kB
  • 235 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_august_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - August 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_august_2023
  • 31.11 kB
  • 1,895 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_august_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - August 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_august_2024
  • 40.66 kB
  • 2,581 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_august_2024 (
  "countryoforigin" VARCHAR,
  "countryfromwhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - December 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_december_2021
  • 16.88 kB
  • 247 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_december_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - December 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_december_2022
  • 16.18 kB
  • 202 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_december_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - December 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_december_2023
  • 33.07 kB
  • 2,105 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_december_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - February 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_february_2021
  • 17.2 kB
  • 308 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_february_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - February 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_february_2022
  • 17.38 kB
  • 285 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_february_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - February 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_february_2023
  • 29.93 kB
  • 1,624 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_february_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - February 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_february_2024
  • 38.46 kB
  • 2,146 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_february_2024 (
  "countryoforigin" VARCHAR,
  "countryfromwhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - January 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_january_2021
  • 17.52 kB
  • 294 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_january_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - January 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_january_2022
  • 18.04 kB
  • 347 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_january_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - January 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_january_2023
  • 33.41 kB
  • 1,972 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_january_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - January 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_january_2024
  • 36.72 kB
  • 2,071 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_january_2024 (
  "countryoforigin" VARCHAR,
  "countrywhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - July 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_july_2021
  • 17.6 kB
  • 289 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_july_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - July 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_july_2022
  • 16.98 kB
  • 245 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_july_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - July 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_july_2023
  • 30.08 kB
  • 1,752 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_july_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - July 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_july_2024
  • 43.86 kB
  • 2,950 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_july_2024 (
  "countryoforigin" VARCHAR,
  "countryfromwhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - June 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_june_2021
  • 17.46 kB
  • 305 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_june_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" BOOLEAN,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - June 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_june_2022
  • 17.04 kB
  • 302 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_june_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - June 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_june_2023
  • 28.71 kB
  • 1,633 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_june_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - June 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_june_2024
  • 42.06 kB
  • 2,797 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_june_2024 (
  "countryoforigin" VARCHAR,
  "countryfromwhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - March 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_march_2021
  • 17.59 kB
  • 326 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_march_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - March 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_march_2022
  • 17.36 kB
  • 320 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_march_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - March 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_march_2023
  • 29.88 kB
  • 1,637 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_march_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - March 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_march_2024
  • 40.82 kB
  • 2,587 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_march_2024 (
  "countryoforigin" VARCHAR,
  "countryfromwhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - May 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_may_2021
  • 17.25 kB
  • 290 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_may_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - May 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_may_2022
  • 16.85 kB
  • 282 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_may_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - May 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_may_2023
  • 30.03 kB
  • 1,767 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_may_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - May 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_may_2024
  • 44.86 kB
  • 3,085 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_may_2024 (
  "countryoforigin" VARCHAR,
  "countryfromwhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - November 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_november_2021
  • 17.05 kB
  • 283 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_november_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" BOOLEAN,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - November 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_november_2022
  • 16.79 kB
  • 261 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_november_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - November 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_november_2023
  • 33.63 kB
  • 2,052 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_november_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - October 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_october_2021
  • 17.59 kB
  • 320 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_october_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - October 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_october_2022
  • 17.03 kB
  • 302 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_october_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - October 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_october_2023
  • 33.55 kB
  • 2,075 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_october_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - September 2021

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_september_2021
  • 16.98 kB
  • 259 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_september_2021 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" BOOLEAN,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - September 2022

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_september_2022
  • 16.47 kB
  • 225 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_september_2022 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" TIMESTAMP,
  "totalofnetweightkg" BIGINT
);

Food Non-Animal Origin - September 2023

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_september_2023
  • 29.42 kB
  • 1,689 rows
  • 16 columns
Loading... 
CREATE TABLE food_non_animal_origin_september_2023 (
  "countryoforigin" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Non-Animal Origin - September 2024

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_non_animal_origin_september_2024
  • 44.97 kB
  • 3,061 rows
  • 17 columns
Loading... 
CREATE TABLE food_non_animal_origin_september_2024 (
  "countryoforigin" VARCHAR,
  "countryfromwhereconsigned" VARCHAR,
  "dateofarrival" TIMESTAMP,
  "notificationstatus" VARCHAR,
  "commoditycode" BIGINT,
  "commoditydescription" VARCHAR,
  "documentcheckyesorno" VARCHAR,
  "documentcheckresult" VARCHAR,
  "identitycheckyesorno" VARCHAR,
  "identitycheckresult" VARCHAR,
  "physicalcheckyesorno" VARCHAR,
  "physicalcheckresult" VARCHAR,
  "laboratorytestsyesorno" VARCHAR,
  "laboratorytestresult" VARCHAR,
  "laboratorytesttype" VARCHAR,
  "laboratorytestdate" VARCHAR,
  "totalofnetweightkg" DOUBLE
);

Food Of Non-Animal Origin - April 2019

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_of_non_animal_origin_april_2019
  • 43.68 kB
  • 2,129 rows
  • 28 columns
Loading... 
CREATE TABLE food_of_non_animal_origin_april_2019 (
  "commoditygroups" VARCHAR,
  "declarationdate" TIMESTAMP,
  "yearofdeclaration" BIGINT,
  "quarterofdeclaration" VARCHAR,
  "monthofdeclaration" BIGINT,
  "dayofdeclaration" BIGINT,
  "decisioncontroldatemonth" TIMESTAMP,
  "countryoforigin" VARCHAR,
  "arrivalatdpe" TIMESTAMP,
  "forimport" VARCHAR,
  "commoditycode" BIGINT,
  "descriptionofcommodity" VARCHAR,
  "producttemperature" VARCHAR,
  "commodityintendedfor" VARCHAR,
  "documentarycheck" VARCHAR,
  "acceptablefortransfer" VARCHAR,
  "notacceptable" VARCHAR,
  "identitycheck" VARCHAR,
  "physicalcheck" VARCHAR,
  "laboratorytests" VARCHAR,
  "testedfor" VARCHAR,
  "results" VARCHAR,
  "acceptableforreleaseforfreecirculation" VARCHAR,
  "notacceptable2" VARCHAR,
  "reasonforrefusal" VARCHAR,
  "dpename" VARCHAR,
  "noofconsignments" BIGINT,
  "netweightkg" BIGINT
);

Food Of Non-Animal Origin - April 2020

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_of_non_animal_origin_april_2020
  • 46.87 kB
  • 1,802 rows
  • 28 columns
Loading... 
CREATE TABLE food_of_non_animal_origin_april_2020 (
  "commoditiesgroup" VARCHAR,
  "declaration" TIMESTAMP,
  "declarationyear" BIGINT,
  "declarationquarter" VARCHAR,
  "declarationmonth" BIGINT,
  "declarationday" BIGINT,
  "countryoforigin" VARCHAR,
  "arrivalatentrypoint" TIMESTAMP,
  "commodities" BIGINT,
  "commonnames" VARCHAR,
  "documentarycheck" VARCHAR,
  "documentarycheckresults" VARCHAR,
  "identitycheck" VARCHAR,
  "identitycheckresults" VARCHAR,
  "physicalcheck" VARCHAR,
  "physicalcheckresults" VARCHAR,
  "commoditylaboratorytest" VARCHAR,
  "commoditylaboratorytestresults" VARCHAR,
  "netweightkg" BIGINT,
  "grossweightkg" BIGINT,
  "notacceptable" VARCHAR,
  "notacceptablemeasureselection" VARCHAR,
  "reasonforrefusal" VARCHAR,
  "decision" TIMESTAMP,
  "year" BIGINT,
  "quarter" VARCHAR,
  "month" BIGINT,
  "day" DOUBLE
);

Food Of Non-Animal Origin - August 2019

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_of_non_animal_origin_august_2019
  • 42.34 kB
  • 1,993 rows
  • 28 columns
Loading... 
CREATE TABLE food_of_non_animal_origin_august_2019 (
  "commoditygroups" VARCHAR,
  "declarationdate" TIMESTAMP,
  "yearofdeclaration" BIGINT,
  "quarterofdeclaration" VARCHAR,
  "monthofdeclaration" BIGINT,
  "dayofdeclaration" BIGINT,
  "decisioncontroldatemonth" TIMESTAMP,
  "countryoforigin" VARCHAR,
  "arrivalatdpe" TIMESTAMP,
  "forimport" VARCHAR,
  "commoditycode" BIGINT,
  "descriptionofcommodity" VARCHAR,
  "producttemperature" VARCHAR,
  "commodityintendedfor" VARCHAR,
  "documentarycheck" VARCHAR,
  "acceptablefortransfer" VARCHAR,
  "notacceptable" VARCHAR,
  "identitycheck" VARCHAR,
  "physicalcheck" VARCHAR,
  "laboratorytests" VARCHAR,
  "testedfor" VARCHAR,
  "results" VARCHAR,
  "acceptableforreleaseforfreecirculation" VARCHAR,
  "notacceptable2" VARCHAR,
  "reasonforrefusal" VARCHAR,
  "dpename" VARCHAR,
  "noofconsignments" BIGINT,
  "netweightkg" BIGINT
);

Food Of Non-Animal Origin - August 2020

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_of_non_animal_origin_august_2020
  • 49.4 kB
  • 1,968 rows
  • 28 columns
Loading... 
CREATE TABLE food_of_non_animal_origin_august_2020 (
  "commoditiesgroup" VARCHAR,
  "declaration" TIMESTAMP,
  "declarationyear" BIGINT,
  "declarationquarter" VARCHAR,
  "declarationmonth" BIGINT,
  "declarationday" BIGINT,
  "countryoforigin" VARCHAR,
  "arrivalatentrypoint" TIMESTAMP,
  "commodities" BIGINT,
  "commonnames" VARCHAR,
  "documentarycheck" VARCHAR,
  "documentarycheckresults" VARCHAR,
  "identitycheck" VARCHAR,
  "identitycheckresults" VARCHAR,
  "physicalcheck" VARCHAR,
  "physicalcheckresults" VARCHAR,
  "commoditylaboratorytest" VARCHAR,
  "commoditylaboratorytestresults" VARCHAR,
  "netweightkg" BIGINT,
  "grossweightkg" BIGINT,
  "notacceptable" VARCHAR,
  "notacceptablemeasureselection" VARCHAR,
  "reasonforrefusal" VARCHAR,
  "decision" TIMESTAMP,
  "year" BIGINT,
  "quarter" VARCHAR,
  "month" BIGINT,
  "day" DOUBLE
);

Food Of Non-Animal Origin - December 2018

@ukgov.trade_control_expert_system_food_of_non_animal_origin.food_of_non_animal_origin_december_2018
  • 40.21 kB
  • 1,626 rows
  • 29 columns
Loading... 
CREATE TABLE food_of_non_animal_origin_december_2018 (
  "declarationdate" TIMESTAMP,
  "yearofdeclaration" BIGINT,
  "quarterofdeclaration" VARCHAR,
  "monthofdeclaration" VARCHAR,
  "dayofdeclaration" BIGINT,
  "decisioncontroldate_month" TIMESTAMP  -- DecisionControlDate(Month),
  "consignorcountrycode" VARCHAR,
  "dpename" VARCHAR,
  "consigneecountry" VARCHAR,
  "countryoforigin" VARCHAR,
  "importercountry" VARCHAR,
  "deliverycountry" VARCHAR,
  "commoditycode" BIGINT,
  "descriptionofcommodity" VARCHAR,
  "totalnumberofpackages" BIGINT,
  "totalnetweight_kg" BIGINT  -- TotalNetWeight(kg),
  "commodityintendedfor" VARCHAR,
  "documentarycheck" VARCHAR,
  "acceptablefortransfer" VARCHAR,
  "notacceptable1" VARCHAR,
  "identitycheck" VARCHAR,
  "physicalcheck" VARCHAR,
  "laboratorytests" VARCHAR,
  "testedfor" VARCHAR  -- TestedFor:,
  "results" VARCHAR  -- Results:,
  "acceptableforreleaseforfreecirculation" VARCHAR,
  "notacceptable2" VARCHAR,
  "reasonforrefusal" VARCHAR,
  "noofconsignments" BIGINT
);

Share link

Anyone who has the link will be able to view this.