About this Dataset

Surface Water - Aquatic Organism Tissue Sample Results

This data set provides results of tissue from organisms found in surface waters, from the California Environmental Data Exchange Network (CEDEN). The data are of tissue from individual organisms and of composite samples where tissue samples from multiple organisms are combined and then analyzed. Both the individual samples and the composite sample results may be given so for individual samples, there will be a row for the individual sample and a row for the composite where the number per composite is one.

The data set contains two provisionally assigned values (“DataQuality” and “DataQualityIndicator”) to help users interpret the data quality metadata provided with the associated result.

Due to file size limitations, the data has been split into individual resources by year. The entire dataset can also be downloaded in bulk using the zip files on this page (in csv format or parquet format), and developers can also use the API associated with each year's dataset to access the data.

Users who want to manually download more specific subsets of the data can also use the CEDEN Query Tool, which provides access to the same data presented here, but allows for interactive data filtering.
Organization: State of California
Last updated: 2025-08-23T12:57:47.933807
Tags: assessment, benthic, bioaccumulation, bioassessment, bivalves, ceden, containment, fish, organisms, pollutant, sediment, surface-water, taxonomy, tissue, water-quality

Tables

CEDEN Tissue Data Prior To 2000

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.ceden_tissue_data_prior_to_2000

27.57 MB
611,668 rows
124 columns


CREATE TABLE ceden_tissue_data_prior_to_2000 (
  "programname" VARCHAR,
  "parentprojectname" VARCHAR,
  "projectcode" VARCHAR,
  "projectname" VARCHAR,
  "compositeid" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometryshape" VARCHAR,
  "earliestdatesampled" TIMESTAMP,
  "compositetype" VARCHAR,
  "commonname" VARCHAR,
  "finalid" VARCHAR,
  "tissueprep" VARCHAR,
  "tissuename" VARCHAR,
  "numberfishpercomp" DOUBLE,
  "sampletypecode" VARCHAR,
  "compositereplicate" DOUBLE,
  "resultreplicate" DOUBLE,
  "matrix" VARCHAR,
  "method" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resqualcode" VARCHAR,
  "mdl" VARCHAR,
  "rl" VARCHAR,
  "qacode" VARCHAR,
  "batchverification" VARCHAR,
  "compliancecode" VARCHAR,
  "dilutionfactor" DOUBLE,
  "labsampleid" VARCHAR,
  "resultcomments" VARCHAR,
  "preppreservationname" VARCHAR,
  "preppreservationdate" TIMESTAMP,
  "digestextractmethod" VARCHAR,
  "digestextractdate" TIMESTAMP,
  "analysisdate" TIMESTAMP,
  "compositecomments" VARCHAR,
  "labbatch" VARCHAR,
  "labbatchcomments" VARCHAR,
  "analyzingagency" VARCHAR,
  "submittingagency" VARCHAR,
  "labsubmissioncode" VARCHAR,
  "organismgroup" VARCHAR,
  "weightavg_g" VARCHAR,
  "tlmax_mm" VARCHAR,
  "tlavglength_mm" VARCHAR,
  "compsizecheck" VARCHAR,
  "sexsummary" VARCHAR,
  "latestdatesampled" TIMESTAMP,
  "sampledaterange_days" DOUBLE,
  "sampledate" TIMESTAMP,
  "collectiontime" VARCHAR,
  "tissueresultrowid" VARCHAR,
  "compositeparentprojectname" VARCHAR,
  "compositeprojectcode" VARCHAR,
  "compositeprojectname" VARCHAR,
  "compositecompositeid" VARCHAR,
  "compositestationname" VARCHAR,
  "compositestationcode" VARCHAR,
  "compositelatitude" DOUBLE,
  "compositelongitude" DOUBLE,
  "compositegeometryshape" VARCHAR,
  "compositesampledate" TIMESTAMP,
  "compositeprogramname" VARCHAR,
  "compositecompositetype" VARCHAR,
  "compositecommonname" VARCHAR,
  "compositefinalid" VARCHAR,
  "compositetissueprep" VARCHAR,
  "compositetissuename" VARCHAR,
  "compositesampletypecode" VARCHAR,
  "samplingagency" VARCHAR,
  "groupsample" VARCHAR,
  "protocolcode" VARCHAR,
  "locationcode" VARCHAR,
  "hydromodloc" VARCHAR,
  "hydromod" VARCHAR,
  "collectionreplicate" DOUBLE,
  "collectionmethodname" VARCHAR,
  "collectiondevicename" VARCHAR,
  "organismid" VARCHAR,
  "totalcount" DOUBLE,
  "tagnumber" VARCHAR,
  "forklength" VARCHAR,
  "totallength" VARCHAR,
  "lengthsource" VARCHAR,
  "organismweight" VARCHAR,
  "unitlengthfish" VARCHAR,
  "unitweightfish" VARCHAR,
  "weightsource" VARCHAR,
  "sizedescr" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "anomaly" VARCHAR,
  "processedorganismsexpandedcomments" VARCHAR,
  "tissueid" VARCHAR,
  "tissueweight" DOUBLE,
  "unittissueweight" VARCHAR
);

Data Dictionary - 2000 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2000_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2000_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2001 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2001_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2001_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2002 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2002_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2002_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2003 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2003_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2003_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2004 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2004_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2004_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2005 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2005_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2005_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2006 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2006_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2006_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2007 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2007_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2007_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2008 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2008_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2008_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2009 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2009_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2009_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2010 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2010_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2010_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2011 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2011_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2011_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2012 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2012_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2012_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2013 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2013_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2013_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2014 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2014_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2014_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2015 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2015_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2015_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2016 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2016_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2016_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2017 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2017_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2017_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2018 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2018_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2018_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2019 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2019_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2019_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2020 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2020_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2020_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2021 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2021_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2021_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2022 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2022_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2022_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2023 CEDEN Tissue Data

@usgov.ca_gov_surface_water_aquatic_organism_tissue_sample_results.data_dictionary_2023_ceden_tissue_data

19.75 kB
124 rows
4 columns


CREATE TABLE data_dictionary_2023_ceden_tissue_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);