Summary Of Incident Notifications Received By The Food Standards Agency
Food Standards Agency
@ukgov.summary_of_incident_notifications_received_by_the_food_b3676605
Food Standards Agency
@ukgov.summary_of_incident_notifications_received_by_the_food_b3676605
The information has been extracted from the Incidents Database and provides a summary of incident notifications received and managed by the Food Standards Agency (FSA). The information is being published as open data on the FSA’s website.
Publisher name: Food Standards Agency
Last updated: 2022-07-01T04:03:53Z
CREATE TABLE incident_notifications_received_april_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_august_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_december_2018 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_december_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_february_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_january_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_january_2020 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_july_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_june_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_march_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_may_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_november_2018 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_november_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_october_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE incident_notifications_received_september_2019 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);CREATE TABLE summary_of_incident_notifications_received_by_the_food_b3676605 (
"uniquereferencenumber_urn" VARCHAR -- UniqueReferenceNumber(URN),
"incidentdate" TIMESTAMP,
"incidentcategory" VARCHAR,
"producttype" VARCHAR,
"productorigincountry" VARCHAR,
"notifiertype" VARCHAR
);Anyone who has the link will be able to view this.