Allergy Alerts
Food Standards Agency
@ukgov.allergy_alerts
Food Standards Agency
@ukgov.allergy_alerts
CREATE TABLE allergy_alerts (
"rownumber" BIGINT,
"descriptionofincident" VARCHAR,
"actiontaken" VARCHAR,
"risktoconsumers" VARCHAR,
"linktonotice" VARCHAR,
"issueddate" TIMESTAMP
);
CREATE TABLE allergy_alerts_april_2019_to_june_2019_quarter_1 (
"descriptionofincident" VARCHAR,
"actiontaken" VARCHAR,
"risktoconsumers" VARCHAR,
"linktonotice" VARCHAR,
"issueddate" TIMESTAMP
);
CREATE TABLE allergy_alerts_january_2019_to_march_2019_quarter_4 (
"descriptionofincident" VARCHAR,
"actiontaken" VARCHAR,
"risktoconsumers" VARCHAR,
"linktonotice" VARCHAR,
"issueddate" TIMESTAMP
);
CREATE TABLE allergy_alerts_october_2019_to_december_2019_quarter_3 (
"descriptionofincident" VARCHAR,
"actiontaken" VARCHAR,
"risktoconsumers" VARCHAR,
"linktonotice" VARCHAR,
"issueddate" TIMESTAMP
);
CREATE TABLE allergy_alerts_october_2018_to_december_2018_quarter_3 (
"descriptionofincident" VARCHAR,
"actiontaken" VARCHAR,
"risktoconsumers" VARCHAR,
"linktonotice" VARCHAR,
"issueddate" TIMESTAMP
);
CREATE TABLE allergy_alerts_july_2019_to_september_2019_quarter_2 (
"descriptionofincident" VARCHAR,
"actiontaken" VARCHAR,
"risktoconsumers" VARCHAR,
"linktonotice" VARCHAR,
"issueddate" TIMESTAMP
);
Anyone who has the link will be able to view this.