Animal Welfare Non-Compliances In Approved Slaughterhouses
Food Standards Agency
@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses
Food Standards Agency
@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses
Animal Welfare non-compliance data collected and categorised by the Food Standards Agency in approved slaughterhouses. Level 3: Potential risk of compromising animal welfare but where there is no immediate risk to animals. Level 4: A serious and imminent risk to animal welfare or where avoidable pain, distress or suffering has been caused.
Publisher name: Food Standards Agency
Last updated: 2022-07-01T04:03:03Z
CREATE TABLE animal_welfare_non_compliances_in_approved_slaughterhouses (
"species" VARCHAR,
"slaughtermethod" VARCHAR,
"noncompliance" VARCHAR,
"q2_1" BIGINT,
"q2_1_1" BIGINT,
"q2_2" BIGINT,
"q2_2_1" BIGINT,
"q2_3" BIGINT,
"q2_4" BIGINT,
"q2_5" BIGINT,
"q2_6" BIGINT,
"q2_7" BIGINT,
"q2_8" BIGINT,
"q2_9" BIGINT,
"q2_10" BIGINT,
"q2_11" BIGINT,
"q2_12" BIGINT,
"q2_13" BIGINT,
"q2_14" BIGINT,
"q2_15" BIGINT,
"q2_16" BIGINT,
"q2_17" BIGINT,
"q2_18" BIGINT,
"q2_19" BIGINT,
"q2_20" BIGINT,
"q2_21" BIGINT,
"q2_22" BIGINT
);CREATE TABLE non_compliance_data_apr_jun_2019 (
"species" VARCHAR,
"slaughtermethod" VARCHAR,
"noncompliance" VARCHAR,
"q2_1" BIGINT,
"q2_1_1" BIGINT,
"q2_2" BIGINT,
"q2_2_1" BIGINT,
"q2_3" BIGINT,
"q2_4" BIGINT,
"q2_5" BIGINT,
"q2_6" BIGINT,
"q2_7" BIGINT,
"q2_8" BIGINT,
"q2_9" BIGINT,
"q2_10" BIGINT,
"q2_11" BIGINT,
"q2_12" BIGINT,
"q2_13" BIGINT,
"q2_14" BIGINT,
"q2_15" BIGINT,
"q2_16" BIGINT,
"q2_17" BIGINT,
"q2_18" BIGINT,
"q2_19" BIGINT,
"q2_20" BIGINT,
"q2_21" BIGINT,
"q2_22" BIGINT,
"q2_23" BIGINT
);CREATE TABLE non_compliance_data_apr_jun_2020 (
"species" VARCHAR,
"noncompliance" VARCHAR,
"q2_24" BIGINT,
"q2_25" BIGINT,
"q2_26" BIGINT,
"q2_27" BIGINT,
"q2_28" BIGINT,
"q2_29" BIGINT
);CREATE TABLE non_compliance_data_jan_mar_2019 (
"species" VARCHAR,
"slaughtermethod" VARCHAR,
"noncompliance" VARCHAR,
"q2_1" BIGINT,
"q2_1_1" BIGINT,
"q2_2" BIGINT,
"q2_2_1" BIGINT,
"q2_3" BIGINT,
"q2_4" BIGINT,
"q2_5" BIGINT,
"q2_6" BIGINT,
"q2_7" BIGINT,
"q2_8" BIGINT,
"q2_9" BIGINT,
"q2_10" BIGINT,
"q2_11" BIGINT,
"q2_12" BIGINT,
"q2_13" BIGINT,
"q2_14" BIGINT,
"q2_15" BIGINT,
"q2_16" BIGINT,
"q2_17" BIGINT,
"q2_18" BIGINT,
"q2_19" BIGINT,
"q2_20" BIGINT,
"q2_21" BIGINT,
"q2_22" BIGINT,
"q2_23" BIGINT
);CREATE TABLE non_compliance_data_jan_mar_2020 (
"species" VARCHAR,
"slaughtermethod" VARCHAR,
"noncompliance" VARCHAR,
"q2_1" BIGINT,
"q2_1_1" BIGINT,
"q2_2" BIGINT,
"q2_2_1" BIGINT,
"q2_3" BIGINT,
"q2_4" BIGINT,
"q2_5" BIGINT,
"q2_6" BIGINT,
"q2_7" BIGINT,
"q2_8" BIGINT,
"q2_9" BIGINT,
"q2_10" BIGINT,
"q2_11" BIGINT,
"q2_12" BIGINT,
"q2_13" BIGINT,
"q2_14" BIGINT,
"q2_15" BIGINT,
"q2_16" BIGINT,
"q2_17" BIGINT,
"q2_18" BIGINT,
"q2_19" BIGINT,
"q2_20" BIGINT,
"q2_21" BIGINT,
"q2_22" BIGINT,
"q2_23" BIGINT,
"q2_24" BIGINT,
"q2_25" BIGINT,
"q2_26" BIGINT,
"q2_27" BIGINT,
"q2_28" BIGINT,
"q2_29" BIGINT
);CREATE TABLE non_compliance_data_jul_sep_2019 (
"species" VARCHAR,
"slaughtermethod" VARCHAR,
"noncompliance" VARCHAR,
"q2_1" BIGINT,
"q2_1_1" BIGINT,
"q2_2" BIGINT,
"q2_2_1" BIGINT,
"q2_3" BIGINT,
"q2_4" BIGINT,
"q2_5" BIGINT,
"q2_6" BIGINT,
"q2_7" BIGINT,
"q2_8" BIGINT,
"q2_9" BIGINT,
"q2_10" BIGINT,
"q2_11" BIGINT,
"q2_12" BIGINT,
"q2_13" BIGINT,
"q2_14" BIGINT,
"q2_15" BIGINT,
"q2_16" BIGINT,
"q2_17" BIGINT,
"q2_18" BIGINT,
"q2_19" BIGINT,
"q2_20" BIGINT,
"q2_21" BIGINT,
"q2_22" BIGINT
);CREATE TABLE non_compliance_data_oct_dec_2018 (
"species" VARCHAR,
"slaughtermethod" VARCHAR,
"noncompliance" VARCHAR,
"q2_1" BIGINT,
"q2_1_1" BIGINT,
"q2_2" BIGINT,
"q2_2_1" BIGINT,
"q2_3" BIGINT,
"q2_4" BIGINT,
"q2_5" BIGINT,
"q2_6" BIGINT,
"q2_7" BIGINT,
"q2_8" BIGINT,
"q2_9" BIGINT,
"q2_10" BIGINT,
"q2_11" BIGINT,
"q2_12" BIGINT,
"q2_13" BIGINT,
"q2_14" BIGINT,
"q2_15" BIGINT,
"q2_16" BIGINT,
"q2_17" BIGINT,
"q2_18" BIGINT,
"q2_19" BIGINT,
"q2_20" BIGINT,
"q2_21" BIGINT,
"q2_22" BIGINT
);CREATE TABLE non_compliance_data_oct_dec_2019 (
"species" VARCHAR,
"slaughtermethod" VARCHAR,
"noncompliance" VARCHAR,
"q2_1" BIGINT,
"q2_1_1" BIGINT,
"q2_2" BIGINT,
"q2_2_1" BIGINT,
"q2_3" BIGINT,
"q2_4" BIGINT,
"q2_5" BIGINT,
"q2_6" BIGINT,
"q2_7" BIGINT,
"q2_8" BIGINT,
"q2_9" BIGINT,
"q2_10" BIGINT,
"q2_11" BIGINT,
"q2_12" BIGINT,
"q2_13" BIGINT,
"q2_14" BIGINT,
"q2_15" BIGINT,
"q2_16" BIGINT,
"q2_17" BIGINT,
"q2_18" BIGINT,
"q2_19" BIGINT,
"q2_20" BIGINT,
"q2_21" BIGINT,
"q2_22" BIGINT,
"q2_23" BIGINT
);Anyone who has the link will be able to view this.