Dataset: Animal Welfare Non-Compliances In Approved Slaughterhouses

About this Dataset

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

Tables

Animal Welfare Non-Compliances In Approved Slaughterhouses

@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses.animal_welfare_non_compliances_in_approved_slaughterhouses

17.75 KB
12 rows
27 columns


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
);

Non-Compliance Data Apr-Jun 2020

@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses.non_compliance_data_apr_jun_2020

6.05 KB
8 rows
8 columns


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
);

Non-Compliance Data Oct-Dec 2019

@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses.non_compliance_data_oct_dec_2019

18.41 KB
16 rows
28 columns


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
);

Non-Compliance Data Jan-Mar 2019

@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses.non_compliance_data_jan_mar_2019

18.38 KB
13 rows
28 columns


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
);

Non-Compliance Data Apr-Jun 2019

@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses.non_compliance_data_apr_jun_2019

18.42 KB
16 rows
28 columns


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
);

Non-Compliance Data Jan-Mar 2020

@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses.non_compliance_data_jan_mar_2020

22.02 KB
16 rows
34 columns


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
);

Non-Compliance Data Jul-Sep 2019

@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses.non_compliance_data_jul_sep_2019

17.79 KB
16 rows
27 columns


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
);

Non-Compliance Data Oct-Dec 2018

@ukgov.animal_welfare_non_compliances_in_approved_slaughterhouses.non_compliance_data_oct_dec_2018

17.79 KB
13 rows
27 columns


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
);