Animal Welfare Enforcement Non-compliance
Food Standards Agency
@ukgov.animal_welfare_enforcement_non_compliance
Food Standards Agency
@ukgov.animal_welfare_enforcement_non_compliance
CREATE TABLE animal_welfare_enforcement_non_compliance_july_2024_to_72b48008 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarm_transport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movement_restraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bo_mgt_resp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_january_2022_7e42b821 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarm_transport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movement_restraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bo_mgt_resp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_july_2022_to_ce5bb37f (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarm_transport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movement_restraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bo_mgt_resp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_april_2021_t_d3a31ce7 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarmtransport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movementrestraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bomgtresp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_april_2024_t_aa1cf226 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarm_transport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movement_restraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bo_mgt_resp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_april_2019_t_906e0942 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category" VARCHAR,
"onfarm" VARCHAR,
"transport" VARCHAR,
"generalrequirements" VARCHAR,
"lairageconditionsandhandlingofanimals" VARCHAR,
"slaughterprocess" VARCHAR,
"religiousslaughter" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_april_2017_t_f6904c73 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category" VARCHAR,
"onfarm" VARCHAR,
"transport" VARCHAR,
"generalrequirements" VARCHAR,
"lairageconditionsandhandlingofanimals" VARCHAR,
"slaughterprocess" VARCHAR,
"religiousslaughter" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_october_2021_806161fa (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarm_transport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movement_restraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bo_mgt_resp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_april_2010_t_d65c063c (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category" VARCHAR,
"onfarmtransport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movementrestraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bomgtresp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_october_2022_cf9a96e7 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarm_transport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movement_restraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bo_mgt_resp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_july_2021_to_cfcf5ce0 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarm_transport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movement_restraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bo_mgt_resp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_april_2018_t_b09bf2c7 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category" VARCHAR,
"onfarm" VARCHAR,
"transport" VARCHAR,
"generalrequirements" VARCHAR,
"lairageconditionsandhandlingofanimals" VARCHAR,
"slaughterprocess" VARCHAR,
"religiousslaughter" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_january_2020_a8fb1a6a (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category" VARCHAR,
"onfarmtransport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movementrestraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bomgtresp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_april_2022_t_5bb3ea0a (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" BIGINT,
"onfarm_transport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movement_restraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bo_mgt_resp" VARCHAR,
"action" VARCHAR
);
CREATE TABLE animal_welfare_enforcement_non_compliance_april_2020_t_f728a9a6 (
"dateofincident" TIMESTAMP,
"species" VARCHAR,
"category1" VARCHAR,
"numberaffected" DOUBLE,
"onfarmtransport" VARCHAR,
"unloading" VARCHAR,
"lairage" VARCHAR,
"movementrestraint" VARCHAR,
"stunning" VARCHAR,
"bleeding" VARCHAR,
"bomgtresp" VARCHAR,
"action" VARCHAR
);
Anyone who has the link will be able to view this.