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
  • 16.93 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
  • 16.94 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.13 KB
  • 1623 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
  • 44.12 KB
  • 3102 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.4 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.27 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
  • 30.38 KB
  • 1895 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
  • 39.71 KB
  • 2581 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.49 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
  • 15.8 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
  • 32.29 KB
  • 2105 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
  • 16.79 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
  • 16.97 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.23 KB
  • 1624 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
  • 37.56 KB
  • 2146 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.11 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
  • 17.62 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
  • 32.63 KB
  • 1972 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
  • 35.86 KB
  • 2071 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.19 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.58 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
  • 29.37 KB
  • 1752 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
  • 42.83 KB
  • 2950 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.05 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
  • 16.64 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.