Dataset: Contaminants Monitoring Programme For Wild Caught Fish, Crustaceans And Cephalopods

About this Dataset

Contaminants Monitoring Programme For Wild Caught Fish, Crustaceans And Cephalopods

One hundred and fifty two samples of wild caught fish, crustaceans and cephalopods were purchased from fish markets across England and Wales and analysed for a number of chemical contaminants.
Publisher name: Food Standards Agency
Last updated: 2025-05-24T04:00:34Z

Tables

Heavy Metals (mercury Lead, Cadmium, Total Arsenic And Inorganic Arsenic) Data

@ukgov.contaminants_monitoring_programme_for_wild_caught_fish_4a1147de.heavy_metals_mercury_lead_cadmium_total_arsenic_and_in_ecc7668a

33.1 KB
665 rows
32 columns


CREATE TABLE heavy_metals_mercury_lead_cadmium_total_arsenic_and_in_ecc7668a (
  "progid" VARCHAR,
  "proglegalref" VARCHAR,
  "sampstrategy" VARCHAR,
  "progtype" VARCHAR,
  "sampler" VARCHAR,
  "samppoint" VARCHAR,
  "sampid" VARCHAR,
  "sampcountry" VARCHAR,
  "sampy" BIGINT,
  "sampm" BIGINT,
  "sampd" BIGINT,
  "sampmatcode" VARCHAR,
  "origcountry" VARCHAR,
  "analysisy" BIGINT,
  "labid" VARCHAR,
  "labaccred" VARCHAR,
  "labcountry" VARCHAR,
  "paramcode" VARCHAR,
  "paramtext" VARCHAR,
  "anmethrefid" VARCHAR,
  "anmethtype" VARCHAR,
  "anmethcode" VARCHAR,
  "resid" VARCHAR,
  "accredproc" VARCHAR,
  "resunit" VARCHAR,
  "resloq" DOUBLE,
  "exprrestype" VARCHAR,
  "restype" VARCHAR,
  "evallimittype" VARCHAR,
  "evalcode" VARCHAR,
  "resval" DOUBLE,
  "resvaluncert" DOUBLE
);

Per- And Polyfluoroalkyl Substances (PFAS) Data

@ukgov.contaminants_monitoring_programme_for_wild_caught_fish_4a1147de.per_and_polyfluoroalkyl_substances_pfas_data

42.7 KB
1441 rows
33 columns


CREATE TABLE per_and_polyfluoroalkyl_substances_pfas_data (
  "progid" VARCHAR,
  "proglegalref" VARCHAR,
  "sampstrategy" VARCHAR,
  "progtype" VARCHAR,
  "sampler" VARCHAR,
  "samppoint" VARCHAR,
  "sampid" VARCHAR,
  "sampcountry" VARCHAR,
  "sampy" BIGINT,
  "sampm" BIGINT,
  "sampd" BIGINT,
  "sampmatcode" VARCHAR,
  "origcountry" VARCHAR,
  "analysisy" BIGINT,
  "labid" VARCHAR,
  "labaccred" VARCHAR,
  "labcountry" VARCHAR,
  "paramcode" VARCHAR,
  "paramtext" VARCHAR,
  "anmethrefid" VARCHAR,
  "anmethtype" VARCHAR,
  "anmethcode" VARCHAR,
  "resid" VARCHAR,
  "accredproc" VARCHAR,
  "resunit" VARCHAR,
  "resloq" DOUBLE,
  "exprrestype" VARCHAR,
  "restype" VARCHAR,
  "evallimittype" VARCHAR,
  "evalcode" VARCHAR,
  "resval" DOUBLE,
  "resvaluncert" DOUBLE,
  "evallowlimit" DOUBLE
);

Dioxins And Dioxin-like Polychlorinated Biphenyls Data

@ukgov.contaminants_monitoring_programme_for_wild_caught_fish_4a1147de.dioxins_and_dioxin_like_polychlorinated_biphenyls_data

51.67 KB
2184 rows
33 columns


CREATE TABLE dioxins_and_dioxin_like_polychlorinated_biphenyls_data (
  "progid" VARCHAR,
  "proglegalref" VARCHAR,
  "sampstrategy" VARCHAR,
  "progtype" VARCHAR,
  "sampler" VARCHAR,
  "samppoint" VARCHAR,
  "sampid" VARCHAR,
  "sampcountry" VARCHAR,
  "sampy" BIGINT,
  "sampm" BIGINT,
  "sampd" BIGINT,
  "sampmatcode" VARCHAR,
  "origcountry" VARCHAR,
  "analysisy" BIGINT,
  "labid" VARCHAR,
  "labaccred" VARCHAR,
  "labcountry" VARCHAR,
  "paramtype" VARCHAR,
  "paramcode" VARCHAR,
  "paramtext" VARCHAR,
  "anmethrefid" VARCHAR,
  "anmethtype" VARCHAR,
  "anmethcode" VARCHAR,
  "resid" VARCHAR,
  "accredproc" VARCHAR,
  "resunit" VARCHAR,
  "resval" DOUBLE,
  "exprrestype" VARCHAR,
  "restype" VARCHAR,
  "resvaluncert" DOUBLE,
  "evallimittype" VARCHAR,
  "evalcode" VARCHAR,
  "resloq" DOUBLE
);