Border Notifications

datebnraised DateBNRaised	country Country	commodity Commodity	netweight NetWeight	productcategory ProductCategory	productname ProductName	controlledbylegislationyorn ControlledByLegislationYOrN	typeofconsignment TypeOfConsignment	hazardcategory HazardCategory	typeoffailure TypeOfFailure	reasonforfailure ReasonForFailure
Thu Jan 02 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Turkey	2008999960Ā	3379.2 kg	Fruits & vegetables	Soft Figs	Yes	FNAO	Mycotoxins	Mycotoxins	Physical
Wed Jan 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	India	910	7000 kg	Herbs & spices	Coriander Seed and Fenugreek (Methi)	Yes	FNAO	Chemical contamination	Chemical contamination	Physical
Wed Jan 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	India	0709999020Ā	798 kg	Fruits & vegetables	Okra	Yes		Pesticide residues	Pesticide residues	Physical
Sun Jan 05 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Germany	160232	4500 kg	Poultry meat & poultry meat products	Chicken Kebab	Yes	POAO	Documentary Checks	Documentary check	Documentary
Mon Jan 06 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Italy	2101981	438.38 kg	Meat & meat products	Pork cheek, Guanciale	Yes	POAO	Documentary Checks	Documentary check	Documentary
Sat Jan 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Germany	160250Ā	5680 kg	Meat & meat products	Beef Kebab	Yes	POAO	Documentary Checks	Documentary check	Documentary
Mon Jan 06 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	Soft drink	3356 kg	Non-alcoholic beverages	Creme Soda	No	FNAO	Food additives & flavourings	Food additives & Flavourings	Physical
Mon Jan 06 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	Soft drink	158.4 kg	Non-alcoholic beverages	Orange Flavoured Drink	No	FNAO	Food additives & flavourings	Food additives & Flavourings	Physical
Mon Jan 06 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	Soft drink	240 kg	Non-alcoholic beverages	Pine Nut Soft Drink	No	FNAO	Food additives & flavourings	Food additives & Flavourings	Physical
Mon Jan 06 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	Soft drink	480 kg	Non-alcoholic beverages	Orange Squash	No	FNAO	Food additives & flavourings	Food additives & Flavourings	Physical


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