Border Notifications
Food Standards Agency
@ukgov.border_notifications_fsa
Food Standards Agency
@ukgov.border_notifications_fsa
The Border Notifications (BN) dashboard is primarily an IT tool designed to exchange information between the Food Standards Agency (FSA) and Port Health Authorities (PHAs) in England and Wales on health risks related to imported food and feed. The BN system underpins the exchange of information to PHAs on food and feed related risks. This tool enables PHAs to take coordinated, coherent, and simultaneous actions to ensure the highest possible level of consumer protection. A BN is triggered by a PHA on the BN dashboard module when the existence of a serious, direct, or indirect, risk to public health linked to imported food or feed is detected.
Publisher name: Food Standards Agency
Last updated: 2025-04-10T04:00:12Z
CREATE TABLE border_notifications_april_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_april_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_august_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_august_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"netweight" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_december_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_february_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_february_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_february_2025 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"netweight" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_january_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_january_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_january_2025 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"netweight" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_july_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_july_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"netweight" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_june_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_june_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_march_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_march_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_may_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_may_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_november_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_november_2024 (
"datebnraised" VARCHAR,
"country" VARCHAR,
"commodity" VARCHAR,
"netweight" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_october_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_october_2024 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"netweight" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);CREATE TABLE border_notifications_september_2023 (
"datebnraised" TIMESTAMP,
"country" VARCHAR,
"commodity" VARCHAR,
"productcategory" VARCHAR,
"productname" VARCHAR,
"controlledbylegislationyorn" VARCHAR,
"typeofconsignment" VARCHAR,
"hazardcategory" VARCHAR,
"typeoffailure" VARCHAR,
"reasonforfailure" VARCHAR
);Anyone who has the link will be able to view this.