Baselight

Border Notifications

Food Standards Agency

@ukgov.border_notifications_fsa

Loading...
Loading...

About this Dataset

Border Notifications

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

Tables

Border Notifications - April 2023

@ukgov.border_notifications_fsa.border_notifications_april_2023
  • 9.97 KB
  • 33 rows
  • 10 columns
Loading...

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

Border Notifications - January 2025

@ukgov.border_notifications_fsa.border_notifications_january_2025
  • 11.57 KB
  • 63 rows
  • 11 columns
Loading...

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

Border Notifications - February 2024

@ukgov.border_notifications_fsa.border_notifications_february_2024
  • 10.07 KB
  • 47 rows
  • 10 columns
Loading...

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

Border Notifications - November 2024

@ukgov.border_notifications_fsa.border_notifications_november_2024
  • 10.41 KB
  • 42 rows
  • 11 columns
Loading...

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

Border Notifications - May 2024

@ukgov.border_notifications_fsa.border_notifications_may_2024
  • 10.46 KB
  • 51 rows
  • 10 columns
Loading...

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

Border Notifications - September 2023

@ukgov.border_notifications_fsa.border_notifications_september_2023
  • 9.91 KB
  • 39 rows
  • 10 columns
Loading...

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

Border Notifications - March 2024

@ukgov.border_notifications_fsa.border_notifications_march_2024
  • 9.88 KB
  • 32 rows
  • 10 columns
Loading...

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

Border Notifications - May 2023

@ukgov.border_notifications_fsa.border_notifications_may_2023
  • 9.77 KB
  • 33 rows
  • 10 columns
Loading...

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

Border Notifications - December 2023

@ukgov.border_notifications_fsa.border_notifications_december_2023
  • 10.04 KB
  • 32 rows
  • 10 columns
Loading...

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

Border Notifications - February 2023

@ukgov.border_notifications_fsa.border_notifications_february_2023
  • 10.27 KB
  • 41 rows
  • 10 columns
Loading...

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

Border Notifications - October 2023

@ukgov.border_notifications_fsa.border_notifications_october_2023
  • 9.62 KB
  • 30 rows
  • 10 columns
Loading...

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

Border Notifications - June 2024

@ukgov.border_notifications_fsa.border_notifications_june_2024
  • 10.61 KB
  • 44 rows
  • 10 columns
Loading...

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

Border Notifications - January 2024

@ukgov.border_notifications_fsa.border_notifications_january_2024
  • 9.75 KB
  • 37 rows
  • 10 columns
Loading...

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

Border Notifications - April 2024

@ukgov.border_notifications_fsa.border_notifications_april_2024
  • 10.28 KB
  • 40 rows
  • 10 columns
Loading...

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

Border Notifications - August 2023

@ukgov.border_notifications_fsa.border_notifications_august_2023
  • 10.1 KB
  • 46 rows
  • 10 columns
Loading...

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

Border Notifications - July 2023

@ukgov.border_notifications_fsa.border_notifications_july_2023
  • 9.78 KB
  • 38 rows
  • 10 columns
Loading...

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

Border Notifications - November 2023

@ukgov.border_notifications_fsa.border_notifications_november_2023
  • 10.06 KB
  • 35 rows
  • 10 columns
Loading...

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

Border Notifications - March 2023

@ukgov.border_notifications_fsa.border_notifications_march_2023
  • 10.67 KB
  • 36 rows
  • 10 columns
Loading...

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

Border Notifications - August 2024

@ukgov.border_notifications_fsa.border_notifications_august_2024
  • 11 KB
  • 31 rows
  • 11 columns
Loading...

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

Border Notifications - February 2025

@ukgov.border_notifications_fsa.border_notifications_february_2025
  • 12.6 KB
  • 102 rows
  • 11 columns
Loading...

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

Border Notifications - June 2023

@ukgov.border_notifications_fsa.border_notifications_june_2023
  • 9.48 KB
  • 29 rows
  • 10 columns
Loading...

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

Border Notifications - October 2024

@ukgov.border_notifications_fsa.border_notifications_october_2024
  • 10.79 KB
  • 44 rows
  • 11 columns
Loading...

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

Border Notifications - July 2024

@ukgov.border_notifications_fsa.border_notifications_july_2024
  • 10.62 KB
  • 29 rows
  • 11 columns
Loading...

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

Border Notifications - January 2023

@ukgov.border_notifications_fsa.border_notifications_january_2023
  • 9.34 KB
  • 14 rows
  • 10 columns
Loading...

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

Share link

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