Border Notifications

datebnraised DateBNRaised	country Country	commodity Commodity	productcategory ProductCategory	productname ProductName	controlledbylegislationyorn ControlledByLegislationYOrN	typeofconsignment TypeOfConsignment	hazardcategory HazardCategory	typeoffailure TypeOfFailure	reasonforfailure ReasonForFailure
Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Uganda	0709609920	Fruits & vegetables	Hot Peppers	Yes	FNAO	Pesticide residues	Physical	Clothianidin detected above MRL
Thu May 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Vietnam	03057900	Fish & fish products	Pangasius	Yes	POAO	Documentary checks	Documentary	NA
Thu May 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Nigeria	16041390	Fish & fish products	Sardines in Vegetable Oil	Yes	POAO	Documentary checks	Documentary	NA
Thu May 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	India	0709999010	Fruits & vegetables	Drumsticks (Moringa)	Yes	FNAO	Pesticide residues	Physical	Carbendazim detected above MRL
Thu May 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	India	0909	Herbs & Spices	Fennel Seeds	Yes	FNAO	Pesticide residues	Physical	Chlorpyrifos detected above MRL
Fri May 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	China	21069098	Fish & fish products	Omega 3 Fish Oil 1200mg	Yes	Composite	Not determined/other	NA	NA
Fri May 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	China	21069098	Fish & fish products	Omega 3 Fish Oil 1500mg	Yes	Composite	Not determined/other	NA	NA
Fri May 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	China	21069098	Fish & fish products	Omega 3 Fish Oil 1500mg	Yes	Composite	Not determined/other	NA	NA
Fri May 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	China	21069098	Fish & fish products	Omega 3 Fish Oil 1200mg Plus D3	Yes	Composite	Not determined/other	NA	NA
Sun May 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Uganda	0709609920	Fruits & vegetables	Hot Peppers	Yes	FNAO	Pesticide residues	Physical	Clothianidin detected above MRL


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