Summary Of Food/Feed Safety Incident Root Cause Analysis (RCA) Information
Food Standards Agency
@ukgov.summary_of_food_feed_safety_incident_root_cause_analys_8858254c
Food Standards Agency
@ukgov.summary_of_food_feed_safety_incident_root_cause_analys_8858254c
CREATE TABLE root_cause_analysis_data_received_in_august_2021 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" VARCHAR,
"unnamed_66" VARCHAR,
"unnamed_67" VARCHAR,
"unnamed_68" VARCHAR,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"unnamed_71" VARCHAR,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" VARCHAR,
"unnamed_75" VARCHAR,
"unnamed_76" VARCHAR,
"unnamed_77" VARCHAR,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" VARCHAR,
"unnamed_81" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" VARCHAR,
"unnamed_84" VARCHAR,
"unnamed_85" VARCHAR,
"unnamed_86" VARCHAR,
"unnamed_87" VARCHAR,
"unnamed_88" VARCHAR,
"unnamed_89" VARCHAR,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"unnamed_92" VARCHAR,
"unnamed_93" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_december_2021 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_february_2022 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_january_2022 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_july_2021 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" VARCHAR,
"unnamed_66" VARCHAR,
"unnamed_67" VARCHAR,
"unnamed_68" VARCHAR,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"unnamed_71" VARCHAR,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" VARCHAR,
"unnamed_75" VARCHAR,
"unnamed_76" VARCHAR,
"unnamed_77" VARCHAR,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" VARCHAR,
"unnamed_81" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" VARCHAR,
"unnamed_84" VARCHAR,
"unnamed_85" VARCHAR,
"unnamed_86" VARCHAR,
"unnamed_87" VARCHAR,
"unnamed_88" VARCHAR,
"unnamed_89" VARCHAR,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"unnamed_92" VARCHAR,
"unnamed_93" VARCHAR,
"unnamed_94" VARCHAR,
"unnamed_95" VARCHAR,
"unnamed_96" VARCHAR,
"unnamed_97" VARCHAR,
"unnamed_98" VARCHAR,
"unnamed_99" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_june_2021 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_march_2022 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_may_2021 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_november_2021 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR,
"unnamed_13" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_october_2021 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR
);
CREATE TABLE root_cause_analysis_data_received_in_september_2021 (
"incident_reference_number" VARCHAR,
"date_rca_received" TIMESTAMP,
"incident_type" VARCHAR,
"hazard_type" VARCHAR,
"product_type" VARCHAR,
"why_1" VARCHAR,
"why_2" VARCHAR,
"why_3" VARCHAR,
"why_4" VARCHAR,
"why_5" VARCHAR,
"root_cause" VARCHAR,
"corrective_actions" VARCHAR,
"alpha_test_fsa_rca_categorisation" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR
);
Anyone who has the link will be able to view this.