Baselight
Sign In

Phytoplankton Results For England And Wales

Food Standards Agency

@ukgov.phytoplankton_results_for_england_and_wales

Loading...
Loading...

About this Dataset

Phytoplankton Results For England And Wales

Official control monitoring data for toxin producing algae found in water samples within classified harvesting areas in England and Wales.
Publisher name: Food Standards Agency
Last updated: 2024-10-23T04:00:08Z

Tables

Phytoplankton Results April 2001 To May 2003

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_april_2001_to_may_2003
  • 26.39 kB
  • 1,749 rows
  • 9 columns
Loading... 
CREATE TABLE phytoplankton_results_april_2001_to_may_2003 (
  "sampleid" DOUBLE,
  "sitenumber" VARCHAR,
  "sitelocation" VARCHAR,
  "sampledate" TIMESTAMP,
  "psp" VARCHAR,
  "potentialdirecttoxicity" VARCHAR,
  "dsp" VARCHAR,
  "asp" VARCHAR,
  "samplemethod" VARCHAR
);

Phytoplankton Results August 2005 To August 2012

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_august_2005_to_august_2012
  • 218.13 kB
  • 7,498 rows
  • 21 columns
Loading... 
CREATE TABLE phytoplankton_results_august_2005_to_august_2012 (
  "samplenumber" VARCHAR,
  "productionarea" VARCHAR,
  "bedid" VARCHAR,
  "localauthority" VARCHAR,
  "gridreference" VARCHAR,
  "samplingpoint" VARCHAR,
  "samplecollectionmethod" VARCHAR,
  "datesamplecollected" TIMESTAMP,
  "datesamplearrivedatlowestoft" TIMESTAMP,
  "dateofanalysis" TIMESTAMP,
  "psp_alexandrium_spp" VARCHAR,
  "psp_gymnodinium_catenatum" VARCHAR,
  "dsp_dinophysis_spp" VARCHAR,
  "dsp_prorocentrum_lima" VARCHAR,
  "asp_pseudo_nitzschia_spp" VARCHAR,
  "nsprisk_karenia_cf_mikimotoi" VARCHAR,
  "yessotoxin_lingulodinium_polyedrum" VARCHAR,
  "yessotoxin_protoceratium_reticulatum" VARCHAR,
  "venerupin_prorocentrum_minimum" VARCHAR,
  "azp_protoperidinium_crassipes" VARCHAR,
  "samplenumber2" VARCHAR
);

Phytoplankton Results January 2017 To December 2017

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_january_2017_to_december_2017
  • 36.2 kB
  • 912 rows
  • 18 columns
Loading... 
CREATE TABLE phytoplankton_results_january_2017_to_december_2017 (
  "samplenumber" VARCHAR,
  "productionarea" VARCHAR,
  "bedid" VARCHAR,
  "localauthority" VARCHAR,
  "gridreference" VARCHAR,
  "samplingpoint" VARCHAR,
  "samplecollectionmethod" VARCHAR,
  "datesamplecollected" TIMESTAMP,
  "datesamplearrivedatlowestoft" TIMESTAMP,
  "dateofanalysisandresultsreported" TIMESTAMP,
  "psp_alexandrium_spp_cellsl_1" VARCHAR,
  "dsp_dinophysiaceaecellsl_1" VARCHAR,
  "dsp_prorocentrumlimacellsl_1" VARCHAR,
  "asp_pseudo_nitzschia_spp_cellsl_1" VARCHAR,
  "yessotoxinlingulodiniumpolyedrumcellsl_1" VARCHAR,
  "yessotoxinprotoceratiumreticulatumcellsl_1" VARCHAR,
  "venerupinprorocentrumcordatumcellsl_1" VARCHAR,
  "actionrequired" VARCHAR
);

Phytoplankton Results January 2018 To December 2018

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_january_2018_to_december_2018
  • 35.88 kB
  • 875 rows
  • 18 columns
Loading... 
CREATE TABLE phytoplankton_results_january_2018_to_december_2018 (
  "samplenumber" VARCHAR,
  "productionarea" VARCHAR,
  "bedid" VARCHAR,
  "localauthority" VARCHAR,
  "gridreference" VARCHAR,
  "samplingpoint" VARCHAR,
  "samplecollectionmethod" VARCHAR,
  "datesamplecollected" TIMESTAMP,
  "datesamplearrivedatlowestoft" TIMESTAMP,
  "dateofanalysisandresultsreported" TIMESTAMP,
  "psp_alexandrium_spp_cellsl_1" VARCHAR,
  "dsp_dinophysiaceaecellsl_1" VARCHAR,
  "dsp_prorocentrumlimacellsl_1" VARCHAR,
  "asp_pseudo_nitzschia_spp_cellsl_1" VARCHAR,
  "yessotoxinlingulodiniumpolyedrumcellsl_1" VARCHAR,
  "yessotoxinprotoceratiumreticulatumcellsl_1" VARCHAR,
  "venerupinprorocentrumcordatumcellsl_1" VARCHAR,
  "actionrequired" VARCHAR
);

Phytoplankton Results January 2019 To December 2019

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_january_2019_to_december_2019
  • 36.48 kB
  • 907 rows
  • 18 columns
Loading... 
CREATE TABLE phytoplankton_results_january_2019_to_december_2019 (
  "samplenumber" VARCHAR,
  "productionarea" VARCHAR,
  "bedid" VARCHAR,
  "localauthority" VARCHAR,
  "gridreference" VARCHAR,
  "samplingpoint" VARCHAR,
  "samplecollectionmethod" VARCHAR,
  "datesamplecollected" TIMESTAMP,
  "datesamplearrivedatlowestoft" TIMESTAMP,
  "dateofanalysisandresultsreported" TIMESTAMP,
  "psp_alexandrium_spp_cellsl_1" VARCHAR,
  "dsp_dinophysiaceaecellsl_1" VARCHAR,
  "dsp_prorocentrumlimacellsl_1" VARCHAR,
  "asp_pseudo_nitzschia_spp_cellsl_1" VARCHAR,
  "yessotoxinlingulodiniumpolyedrumcellsl_1" VARCHAR,
  "yessotoxinprotoceratiumreticulatumcellsl_1" VARCHAR,
  "venerupinprorocentrumcordatumcellsl_1" VARCHAR,
  "actionrequired" VARCHAR
);

Phytoplankton Results January 2020 To December 2020

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_january_2020_to_december_2020
  • 30.45 kB
  • 906 rows
  • 14 columns
Loading... 
CREATE TABLE phytoplankton_results_january_2020_to_december_2020 (
  "samplenumber" VARCHAR,
  "productionarea" VARCHAR,
  "bedid" VARCHAR,
  "localauthority" VARCHAR,
  "gridreference" VARCHAR,
  "samplingpoint" VARCHAR,
  "datesamplecollected" TIMESTAMP,
  "psp_alexandrium_spp_cellsl_1" VARCHAR,
  "dsp_dinophysiaceaecellsl_1" VARCHAR,
  "dsp_prorocentrumlimacellsl_1" VARCHAR,
  "asp_pseudo_nitzschia_spp_cellsl_1" VARCHAR,
  "yessotoxinlingulodiniumpolyedrumcellsl_1" VARCHAR,
  "yessotoxinprotoceratiumreticulatumcellsl_1" VARCHAR,
  "venerupinprorocentrumcordatumcellsl_1" VARCHAR
);

Phytoplankton Results January 2021 To December 2021

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_january_2021_to_december_2021
  • 31.7 kB
  • 947 rows
  • 16 columns
Loading... 
CREATE TABLE phytoplankton_results_january_2021_to_december_2021 (
  "samplenumber" VARCHAR,
  "productionarea" VARCHAR,
  "bedid" VARCHAR,
  "localauthority" VARCHAR,
  "gridreference" VARCHAR,
  "samplingpoint" VARCHAR,
  "datesamplecollected" TIMESTAMP,
  "psp_alexandrium_spp_cellsl_1" VARCHAR,
  "dsp_dinophysiaceaecellsl_1" VARCHAR,
  "dsp_prorocentrumlimacellsl_1" VARCHAR,
  "asp_pseudo_nitzschia_spp_cellsl_1" VARCHAR,
  "yessotoxinlingulodiniumpolyedrumcellsl_1" VARCHAR,
  "yessotoxinprotoceratiumreticulatumcellsl_1" VARCHAR,
  "venerupinprorocentrumcordatumcellsl_1" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

Phytoplankton Results January 2022 To December 2022

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_january_2022_to_december_2022
  • 30.16 kB
  • 912 rows
  • 14 columns
Loading... 
CREATE TABLE phytoplankton_results_january_2022_to_december_2022 (
  "samplenumber" VARCHAR,
  "productionarea" VARCHAR,
  "bedid" VARCHAR,
  "localauthority" VARCHAR,
  "gridreference" VARCHAR,
  "samplingpoint" VARCHAR,
  "datesamplecollected" TIMESTAMP,
  "psp_alexandrium_spp_cellsl_1" VARCHAR,
  "dsp_dinophysiaceaecellsl_1" VARCHAR,
  "dsp_prorocentrumlimacellsl_1" VARCHAR,
  "asp_pseudo_nitzschia_spp_cellsl_1" VARCHAR,
  "yessotoxinlingulodiniumpolyedrumcellsl_1" VARCHAR,
  "yessotoxinprotoceratiumreticulatumcellsl_1" VARCHAR,
  "venerupinprorocentrumcordatumcellsl_1" VARCHAR
);

Phytoplankton Results June 2003 To July 2005

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_june_2003_to_july_2005
  • 24.92 kB
  • 936 rows
  • 13 columns
Loading... 
CREATE TABLE phytoplankton_results_june_2003_to_july_2005 (
  "sampleid" VARCHAR,
  "sitenumber" BIGINT,
  "sitelocation" VARCHAR,
  "sampledate" TIMESTAMP,
  "alexandrium_sp_psp" VARCHAR,
  "karenia_mikimotoi_potentiallytoxictofish" DOUBLE,
  "protoperidinium_crassipes" DOUBLE,
  "psp_lingulodinium_polyedrum" DOUBLE,
  "gyrodinium_aureolum_potentiallytoxictofish" DOUBLE,
  "dinophysis_sp_p_lima_dsp" VARCHAR,
  "pseudonitzschia_asp" VARCHAR,
  "samplemethod" VARCHAR,
  "comments" VARCHAR
);

Phytoplankton Results September 2012 To December 2016

@ukgov.phytoplankton_results_for_england_and_wales.phytoplankton_results_september_2012_to_december_2016
  • 132.62 kB
  • 4,299 rows
  • 19 columns
Loading... 
CREATE TABLE phytoplankton_results_september_2012_to_december_2016 (
  "samplenumber" VARCHAR,
  "productionarea" VARCHAR,
  "bedid" VARCHAR,
  "localauthority" VARCHAR,
  "gridreference" VARCHAR,
  "samplingpoint" VARCHAR,
  "samplecollectionmethod" VARCHAR,
  "datesamplecollected" TIMESTAMP,
  "datesamplearriveatlowestoft" TIMESTAMP,
  "dateofanalysisandresultsreported" VARCHAR,
  "psp_alexandrium_spp" VARCHAR,
  "dsp_dinophysiaceae" VARCHAR,
  "dsp_prorocentrum_lima" VARCHAR,
  "asp_pseudo_nitzschia_spp" VARCHAR,
  "yessotoxin_lingulodinium_polyedrum" VARCHAR,
  "yessotoxin_protoceratium_reticulatum" VARCHAR,
  "venerupin_prorocentrum_cordatum" VARCHAR,
  "actionrequired" VARCHAR,
  "samplenumber2" VARCHAR
);

Share link

Anyone who has the link will be able to view this.