Border Notifications

datebnraised DateBNRaised	country Country	commodity Commodity	productcategory ProductCategory	productname ProductName	controlledbylegislationyorn ControlledByLegislationYOrN	typeofconsignment TypeOfConsignment	hazardcategory HazardCategory	typeoffailure TypeOfFailure	reasonforfailure ReasonForFailure
Sat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	USA	NA	Prepared dishes & snacks	Hot Mama (Pickle)	No	FNAO	Food additives & flavourings	Physical	Tartazine detected above MPL
Sun Apr 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Argentina	12024200	Nuts, nut products & seeds	Groundnuts HC	Yes	FNAO	mycotoxins	Physical	Aflatoxin B1 and Total Aflatoxin detected above MPL
Wed Apr 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Ukraine	160232	Poultry meat & poultry meat products	Steam Cooked chicken breast fillet uncalibrated	Yes	POAO	Pathogenic micro-organisms	Physical	Salmonella detected
Thu Apr 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	India	0709609920	Fruits & vegetables	Chillies	Yes	FNAO	Pesticide residues	Physical	Acephate, Methamidophos and Omethoate detected above MRL
Thu Apr 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	India	NA	Non-alcoholic beverages	Davant Orange	No	FNAO	Food additives & flavourings	Physical	Benzoic acid and Sunset yellow detected above MPL
Thu Apr 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Vietnam	0810902010	Fruits & vegetables	Dragon Fruit	Yes	FNAO	Identity checks	Identity	NA
Thu Apr 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	China	NA	Other food product/mixed	Enoki Mushrooms	No	FNAO	Pathogenic micro-organisms	Physical	Listeria monocytogenes detected
Sat Apr 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Ghana	12024200	Nuts, nut products & seeds	Groundnuts	Yes	FNAO	Identity checks	Identity	NA
Mon Apr 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	12024100	Nuts, nut products & seeds	Groundnuts	Yes	FNAO	Mycotoxins	Physical	Aflatoxin B1 and Total Aflatoxins detected above MRL
Mon Apr 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	China	04090000	Honey & royal jelly	Honey	Yes	POAO	Adulteration/fraud	Physical	Authenticity issue


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