Baselight
Sign In

Surface Water - Habitat Results

State of California

@usgov.ca_gov_surface_water_habitat_results

Loading...
Loading...

About this Dataset

Surface Water - Habitat Results

This data provides results from field analyses, from the California Environmental Data Exchange Network (CEDEN). 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-07-23T14:47:30.412228
Tags: ceden, physical-habitat, water

Tables

Data Dictionary - 2024 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2024_ceden_habitat_data
  • 10.55 kB
  • 49 rows
  • 4 columns
Loading... 
CREATE TABLE data_dictionary_2024_ceden_habitat_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2025 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_2025_ceden_habitat_data
  • 10.56 kB
  • 49 rows
  • 4 columns
Loading... 
CREATE TABLE data_dictionary_2025_ceden_habitat_data (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - CEDEN Habitat Data Prior To 2000

@usgov.ca_gov_surface_water_habitat_results.data_dictionary_ceden_habitat_data_prior_to_2000
  • 10.55 kB
  • 49 rows
  • 4 columns
Loading... 
CREATE TABLE data_dictionary_ceden_habitat_data_prior_to_2000 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

2000 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2000_ceden_habitat_data
  • 853.68 kB
  • 90,554 rows
  • 49 columns
Loading... 
CREATE TABLE n_2000_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2001 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2001_ceden_habitat_data
  • 1.66 MB
  • 186,187 rows
  • 49 columns
Loading... 
CREATE TABLE n_2001_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2002 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2002_ceden_habitat_data
  • 1.7 MB
  • 183,268 rows
  • 49 columns
Loading... 
CREATE TABLE n_2002_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2003 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2003_ceden_habitat_data
  • 870.38 kB
  • 92,237 rows
  • 49 columns
Loading... 
CREATE TABLE n_2003_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2004 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2004_ceden_habitat_data
  • 1.63 MB
  • 183,476 rows
  • 49 columns
Loading... 
CREATE TABLE n_2004_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2005 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2005_ceden_habitat_data
  • 2.17 MB
  • 234,463 rows
  • 49 columns
Loading... 
CREATE TABLE n_2005_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2006 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2006_ceden_habitat_data
  • 2 MB
  • 211,907 rows
  • 49 columns
Loading... 
CREATE TABLE n_2006_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2007 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2007_ceden_habitat_data
  • 3.29 MB
  • 349,217 rows
  • 49 columns
Loading... 
CREATE TABLE n_2007_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2008 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2008_ceden_habitat_data
  • 4.2 MB
  • 468,275 rows
  • 49 columns
Loading... 
CREATE TABLE n_2008_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2009 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2009_ceden_habitat_data
  • 4.93 MB
  • 583,312 rows
  • 49 columns
Loading... 
CREATE TABLE n_2009_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2010 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2010_ceden_habitat_data
  • 5.78 MB
  • 686,453 rows
  • 49 columns
Loading... 
CREATE TABLE n_2010_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2011 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2011_ceden_habitat_data
  • 5.94 MB
  • 691,733 rows
  • 49 columns
Loading... 
CREATE TABLE n_2011_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2012 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2012_ceden_habitat_data
  • 7.02 MB
  • 801,252 rows
  • 49 columns
Loading... 
CREATE TABLE n_2012_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2013 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2013_ceden_habitat_data
  • 6.84 MB
  • 727,556 rows
  • 49 columns
Loading... 
CREATE TABLE n_2013_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2014 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2014_ceden_habitat_data
  • 6.29 MB
  • 667,263 rows
  • 49 columns
Loading... 
CREATE TABLE n_2014_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2015 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2015_ceden_habitat_data
  • 6.09 MB
  • 637,263 rows
  • 49 columns
Loading... 
CREATE TABLE n_2015_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2016 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2016_ceden_habitat_data
  • 7.77 MB
  • 789,074 rows
  • 49 columns
Loading... 
CREATE TABLE n_2016_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2017 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2017_ceden_habitat_data
  • 9.4 MB
  • 961,429 rows
  • 49 columns
Loading... 
CREATE TABLE n_2017_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2018 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2018_ceden_habitat_data
  • 8.34 MB
  • 822,483 rows
  • 49 columns
Loading... 
CREATE TABLE n_2018_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2019 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2019_ceden_habitat_data
  • 9.15 MB
  • 860,397 rows
  • 49 columns
Loading... 
CREATE TABLE n_2019_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2020 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2020_ceden_habitat_data
  • 5.95 MB
  • 607,015 rows
  • 49 columns
Loading... 
CREATE TABLE n_2020_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" VARCHAR,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

2021 CEDEN Habitat Data

@usgov.ca_gov_surface_water_habitat_results.n_2021_ceden_habitat_data
  • 7.17 MB
  • 710,818 rows
  • 49 columns
Loading... 
CREATE TABLE n_2021_ceden_habitat_data (
  "program" VARCHAR,
  "parentproject" VARCHAR,
  "project" VARCHAR,
  "stationname" VARCHAR,
  "stationcode" VARCHAR,
  "sampledate" TIMESTAMP,
  "collectiontime" TIMESTAMP,
  "locationcode" VARCHAR,
  "sampletypecode" VARCHAR,
  "collectionreplicate" DOUBLE,
  "matrixname" VARCHAR,
  "methodname" VARCHAR,
  "analyte" VARCHAR,
  "unit" VARCHAR,
  "result" DOUBLE,
  "resultqualcode" VARCHAR,
  "variableresult" VARCHAR,
  "qacode" VARCHAR,
  "compliancecode" VARCHAR,
  "samplecomments" VARCHAR,
  "collectioncomments" VARCHAR,
  "resultscomments" VARCHAR,
  "eventcode" VARCHAR,
  "protocolcode" VARCHAR,
  "sampleagency" VARCHAR,
  "collectionmethodname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondevicedescription" VARCHAR,
  "occupationmethod" VARCHAR,
  "startingbank" VARCHAR,
  "distancefrombank" VARCHAR,
  "unitdistancefrombank" VARCHAR,
  "streamwidth" VARCHAR,
  "unitstreamwidth" VARCHAR,
  "stationwaterdepth" VARCHAR,
  "unitstationwaterdepth" VARCHAR,
  "locationdetailcomments" VARCHAR,
  "dw_analytename" VARCHAR,
  "programcode" BOOLEAN,
  "parentprojectcode" VARCHAR,
  "projectcode" VARCHAR,
  "matrixcode" VARCHAR,
  "analytecode" BIGINT,
  "fractionname" BIGINT,
  "fractioncode" VARCHAR,
  "dataquality" VARCHAR,
  "dataqualityindicator" VARCHAR,
  "datum" VARCHAR
);

Share link

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