Border Notifications

datebnraised DateBNRaised	country Country	commodity Commodity	productcategory ProductCategory	productname ProductName	controlledbylegislationyorn ControlledByLegislationYOrN	typeofconsignment TypeOfConsignment	hazardcategory HazardCategory	typeoffailure TypeOfFailure	reasonforfailure ReasonForFailure
Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Kenya	0708200020	Fruits & vegetables	Green beans	Yes	FNAO	Pesticide residues	Physical	Acephate detected above MRL
Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Brazil	12024200	Fruits & vegetables	Groundnuts	Yes	FNAO	Mycotoxins	Physical	Aflatoxin B1 detected above MPL
Fri Feb 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	USA	12024200	Feed materials	Groundnuts	Yes	Feed	Mycotoxins	Physical	Aflatoxin B1 detected above MPL
Tue Feb 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Turkey	08042090	Fruits & vegetables	Dried Figs	Yes	FNAO	mycotoxins	Physical	Aflatoxin B1 and Total Aflatoxin detected above MPL
Tue Feb 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Kenya	0708200020	Fruits & vegetables	Fine Green Beans	Yes	FNAO	Pesticide residues	Physical	Acephate detected above MRL
Tue Feb 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Kenya	0708200020	Fruits & vegetables	Green Beans	Yes	FNAO	Pesticide residues	Physical	Flutriafol detected above MRL
Fri Feb 09 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Nigeria	1207700010	Fruits & vegetables	Egusi Seeds	Yes	FNAO	Documentary checks	Documentary	NA
Fri Feb 09 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Sri Lanka	0302	Fish & fish products	Chilled Fish	Yes	POAO	Documentary checks	Documentary	NA
Sat Feb 10 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Nigeria		non-alcoholic beverages	Fanta Orange	No	FNAO	Food additives & flavourings	Physical	Sunset Yellow detected above permitted MPL
Sat Feb 10 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Kenya	0708200020	Fruits & vegetables	Fine Green Beans	Yes	FNAO	Pesticide residues	Physical	Acephate detected above MRL


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