Formal Complaints About The Food Standards Agency
Food Standards Agency
@ukgov.formal_complaints_about_the_food_standards_agency
Food Standards Agency
@ukgov.formal_complaints_about_the_food_standards_agency
CREATE TABLE formal_complaints_about_the_food_standards_agency (
"complainantcategory" VARCHAR,
"stage" BIGINT,
"complaintdetails" VARCHAR,
"datecomplaintreceived" TIMESTAMP,
"dateacknowledged" TIMESTAMP,
"originalduedateforresponse" TIMESTAMP,
"datefinalresponsesent" TIMESTAMP,
"formalnotificationofinvestigationbythephso" VARCHAR,
"formalnotificationofoutcomebythephso" VARCHAR,
"outcome" VARCHAR,
"workingdaystakentorespond" VARCHAR,
"improvementsmadeasaresultofcomplaint" VARCHAR
);
CREATE TABLE formal_complaints_about_the_food_standards_agency_2019 (
"complainantcategory" VARCHAR,
"stage" BIGINT,
"complaintdetails" VARCHAR,
"datecomplaintreceived" TIMESTAMP,
"dateacknowledged" TIMESTAMP,
"originalduedateforresponse" TIMESTAMP,
"datefinalresponsesent" TIMESTAMP,
"formalnotificationofinvestigationbythephso" TIMESTAMP,
"formalnotificationofoutcomebythephso" VARCHAR,
"outcome" VARCHAR,
"workingdaystakentorespond" DOUBLE,
"improvementsmadeasaresultofcomplaint" VARCHAR
);
CREATE TABLE formal_complaints_about_the_food_standards_agency_2020 (
"complainantcategory" VARCHAR,
"stage" BIGINT,
"complaintdetails" VARCHAR,
"datecomplaintreceived" TIMESTAMP,
"dateacknowledged" TIMESTAMP,
"originalduedateforresponse" TIMESTAMP,
"datefinalresponsesent" TIMESTAMP,
"formalnotificationofinvestigationbythephso" VARCHAR,
"formalnotificationofoutcomebythephso" VARCHAR,
"outcome" VARCHAR,
"workingdaystakentorespond" DOUBLE,
"improvementsmadeasaresultofcomplaint" VARCHAR
);
CREATE TABLE formal_complaints_about_the_food_standards_agency_2021 (
"complainantcategory" VARCHAR,
"stage" BIGINT,
"complaintdetails" VARCHAR,
"datecomplaintreceived" TIMESTAMP,
"dateacknowledged" TIMESTAMP,
"originalduedateforresponse" TIMESTAMP,
"datefinalresponsesent" TIMESTAMP,
"formalnotificationofinvestigationbythephso" VARCHAR,
"formalnotificationofoutcomebythephso" VARCHAR,
"outcome" VARCHAR,
"workingdaystakentorespond" BIGINT,
"improvementsmadeasaresultofcomplaint" VARCHAR
);
CREATE TABLE formal_complaints_about_the_food_standards_agency_2022 (
"complainantcategory" VARCHAR,
"stage" BIGINT,
"complaintdetails" VARCHAR,
"datecomplaintreceived" TIMESTAMP,
"dateacknowledged" TIMESTAMP,
"originalduedateforresponse" TIMESTAMP,
"datefinalresponsesent" TIMESTAMP,
"formalnotificationofinvestigationbythephso" VARCHAR,
"formalnotificationofoutcomebythephso" VARCHAR,
"outcome" VARCHAR,
"workingdaystakentorespond" DOUBLE,
"improvementsmadeasaresultofcomplaint" VARCHAR
);
CREATE TABLE formal_complaints_about_the_food_standards_agency_2023 (
"complainantcategory" VARCHAR,
"stage" DOUBLE,
"complaintdetails" VARCHAR,
"datecomplaintreceived" TIMESTAMP,
"dateacknowledged" TIMESTAMP,
"originalduedateforresponse" TIMESTAMP,
"datefinalresponsesent" TIMESTAMP,
"formalnotificationofinvestigationbythephso" VARCHAR,
"formalnotificationofoutcomebythephso" VARCHAR,
"outcome" VARCHAR,
"workingdaystakentorespond" DOUBLE,
"improvementsmadeasaresultofcomplaint" VARCHAR
);
Anyone who has the link will be able to view this.