Other Species Conditions Data
Food Standards Agency
@ukgov.other_species_conditions_data
Food Standards Agency
@ukgov.other_species_conditions_data
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,
"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,
"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.