Other Species Conditions Data
Food Standards Agency
@ukgov.other_species_conditions_data
Food Standards Agency
@ukgov.other_species_conditions_data
Conditions data in species other than cattle, poultry, pigs and sheep & goats, collected by Food Standards Agency staff at approved meat establishments as a percentage of throughput. The data is aggregated to country level and is shown by month.
Publisher name: Food Standards Agency
Last updated: 2025-01-28T04:03:25Z
CREATE TABLE other_species_conditions_data (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_apr19_jun19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_apr_20_jun_20 (
"n__species" VARCHAR -- ???Species,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_jan19_mar19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_jan_20_mar_20 (
"n__species" VARCHAR -- ???Species,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_jul19_sep19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_jul_20_sep_20 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_oct18_dec18 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_oct_19_dec_19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE other_species_conditions_data_oct_20_dec_20 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);Anyone who has the link will be able to view this.