Sheep & Goat Conditions
Food Standards Agency
@ukgov.sheep_goat_conditions
Food Standards Agency
@ukgov.sheep_goat_conditions
CREATE TABLE sheep_goat_conditions (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);
CREATE TABLE sheep_goat_conditions_apr19_jun19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);
CREATE TABLE sheep_goat_conditions_apr_20_jun_20 (
"n__species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);
CREATE TABLE sheep_goat_conditions_jan19_mar19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);
CREATE TABLE sheep_goat_conditions_jan_20_mar_20 (
"n__species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);
CREATE TABLE sheep_goat_conditions_jul19_sep19 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);
CREATE TABLE sheep_goat_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 sheep_goat_conditions_oct18_dec18 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);
CREATE TABLE sheep_goat_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 sheep_goat_conditions_oct_20_dec_20 (
"species" VARCHAR,
"inspectiontype" VARCHAR,
"condition" VARCHAR,
"yearmonth" TIMESTAMP,
"country" VARCHAR,
"numberofconditions" BIGINT,
"throughput" BIGINT,
"numberofthroughputplants" BIGINT,
"percentageofthroughput" DOUBLE
);
CREATE TABLE sheep_goats_conditions_jul18_sep18 (
"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.