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
);

Share link

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