Northern Ireland Phytoplankton Results
Food Standards Agency
@ukgov.northern_ireland_phytoplankton_results
Food Standards Agency
@ukgov.northern_ireland_phytoplankton_results
CREATE TABLE northern_ireland_phytoplankton_results_2021 (
"lough" VARCHAR,
"representativemonitoringpoints" VARCHAR,
"shellfishspecies" VARCHAR,
"dateofsampling" TIMESTAMP,
"dspalgae" VARCHAR,
"aspalgae" VARCHAR,
"pspalgae" VARCHAR,
"status" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE northern_ireland_phytoplankton_results_2022 (
"lough" VARCHAR,
"representativemonitoringpoints" VARCHAR,
"shellfishspecies" VARCHAR,
"dateofsampling" TIMESTAMP,
"dspalgae" VARCHAR,
"aspalgae" VARCHAR,
"pspalgae" VARCHAR,
"other_producers_of_yessotoxins_hepatotoxins_and_icthyt_a0de3515" VARCHAR,
"status" VARCHAR,
"comments" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR
);
CREATE TABLE northern_ireland_phytoplankton_results_2023 (
"lough" VARCHAR,
"representativemonitoringpoints" VARCHAR,
"shellfishspecies" VARCHAR,
"dateofsampling" TIMESTAMP,
"dspalgae" VARCHAR,
"aspalgae" VARCHAR,
"pspalgae" VARCHAR,
"other_producers_of_yessotoxins_hepatotoxins_and_icthyt_a0de3515" VARCHAR,
"status" VARCHAR,
"comments" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR
);
CREATE TABLE northern_ireland_phytoplankton_results_2024 (
"lough" VARCHAR,
"representativemonitoringpoints" VARCHAR,
"shellfishspecies" VARCHAR,
"dateofsampling" TIMESTAMP,
"dspalgae" VARCHAR,
"aspalgae" VARCHAR,
"pspalgae" VARCHAR,
"other_producers_of_yessotoxins_hepatotoxins_and_icthyt_a0de3515" VARCHAR,
"status" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.