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
The information summarises anonymised Root Cause Analysis (RCA) data received by the Food Standards Agency (FSA) for corresponding food/feed safety incidents during the 2021/22 Reporting Year. The information is being published as open data on the FSA’s website and will be used to obtain stakeholder feedback on content and format, during future phases of an Alpha development project. It is the first step in making sure we get information in a format that is useful for others to interpret, with an overall aim of being able to learn from incidents to reduce the risk of them recurring. If you require further information regarding this publication, please direct your query to ReceiptAndManagement@food.gov.uk.
Publisher name: Food Standards Agency
Last updated: 2024-10-18T04:00:13Z
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 -- ALPHA TEST: FSA RCA Categorisation,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" VARCHAR -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" VARCHAR -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" VARCHAR -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" VARCHAR -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" VARCHAR -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" VARCHAR -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" VARCHAR -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" VARCHAR -- Unnamed: 91,
"unnamed_92" VARCHAR -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93
);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 -- ALPHA TEST: FSA RCA Categorisation,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16
);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 -- ALPHA TEST: FSA RCA Categorisation
);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 -- ALPHA TEST: FSA RCA Categorisation
);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 -- ALPHA TEST: FSA RCA Categorisation,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" VARCHAR -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" VARCHAR -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" VARCHAR -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" VARCHAR -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" VARCHAR -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" VARCHAR -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" VARCHAR -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" VARCHAR -- Unnamed: 91,
"unnamed_92" VARCHAR -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"unnamed_94" VARCHAR -- Unnamed: 94,
"unnamed_95" VARCHAR -- Unnamed: 95,
"unnamed_96" VARCHAR -- Unnamed: 96,
"unnamed_97" VARCHAR -- Unnamed: 97,
"unnamed_98" VARCHAR -- Unnamed: 98,
"unnamed_99" VARCHAR -- Unnamed: 99
);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 -- ALPHA TEST: FSA RCA Categorisation,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16
);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 -- ALPHA TEST: FSA RCA Categorisation
);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 -- ALPHA TEST: FSA RCA Categorisation
);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 -- ALPHA TEST: FSA RCA Categorisation,
"unnamed_13" VARCHAR -- Unnamed: 13
);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 -- ALPHA TEST: FSA RCA Categorisation,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52
);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 -- ALPHA TEST: FSA RCA Categorisation,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14
);Anyone who has the link will be able to view this.