Cattle Conditions
Food Standards Agency
@ukgov.cattle_conditions
Food Standards Agency
@ukgov.cattle_conditions
Cattle condition data collected by Food Standards Agency staff at approved meat establishments as a percentage of cattle throughput. The data is aggregated to country level and is shown by month.
Publisher name: Food Standards Agency
Last updated: 2022-07-01T04:02:41Z
CREATE TABLE cattle_conditions (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_apr_19_jun_19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_apr_20_jun_20 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_jan_19_mar_19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_jan_20_mar_20 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_jul_19_sep_19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_jul_20_sep_20 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_oct_18_dec_18 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_oct_19_dec_19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);CREATE TABLE cattle_conditions_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.