About this Dataset

Southeast Alaska Periodic Dolly Varden Tissue Mercury Analyses (EC E)

An ASCII CSV file of all mercury contamination results obtained from sampled fish specimens covering one sampling year, as provided by the contracted laboratory.
Organization: Department of the Interior
Last updated: 2025-09-14T17:49:56.152569
Tags: contaminants, dolly-varden, ecological-framework-biological-integrity-focal-species-or-communities-fishes, ecological-framework-water-water-quality-toxics, mercury, salvelinus-malma

Tables

EC E 2018

@usgov.doi_gov_southeast_alaska_periodic_dolly_varden_tissue__3e6607cd.ec_e_2018

29.45 kB
86 rows
32 columns

CREATE TABLE ec_e_2018 (
  "siteprimarykey" VARCHAR,
  "fieldlatitude" DOUBLE,
  "fieldlongitude" DOUBLE,
  "fieldsitename" VARCHAR,
  "collectiondate" TIMESTAMP,
  "collectorname" VARCHAR,
  "incoming_idcode" VARCHAR,
  "cerp_idcode" VARCHAR,
  "speciescode" VARCHAR,
  "scientificname" VARCHAR,
  "commonname" VARCHAR,
  "sampletypereceived" VARCHAR,
  "fieldforklength_mm" BIGINT,
  "fieldwetweight_wbody_g" DOUBLE,
  "catalognotes" VARCHAR,
  "labstandardlength_mm" BIGINT,
  "labforklength_mm" BIGINT,
  "labtotallength_mm" BIGINT,
  "labwetweight_wbody_g" DOUBLE,
  "flagcatalogsample" VARCHAR,
  "flagcatreason" VARCHAR,
  "flagcatpersonnel" VARCHAR,
  "tissueid" VARCHAR,
  "moisturecontentpercent" DOUBLE,
  "thg_conc_ppm_dw" DOUBLE,
  "thg_conc_ppm_ww" DOUBLE,
  "thg_analysisdate" TIMESTAMP,
  "thg_instrument" VARCHAR,
  "thg_analytical_method" VARCHAR,
  "thg_mdl_nghg" DOUBLE,
  "thg_loq_nghg" DOUBLE,
  "thg_analyticallab" VARCHAR
);