Water Quality by US Government | Environmental and Climate Sciences

About this Dataset

Water Quality

Prior to downloading data, please download the README file. This dataset contains water quality samples collected from Puget Sound, lakes, and streams in the region which can be filtered by "Site Type" and "Area". To see where water quality samples are collected, see the WLRD Water Quality Collection Sites dataset.
Organization: King County, Washington
Last updated: 2020-11-10T16:58:46.266207
Tags: fresh-water, lakes, marine, puget-sound, streams, water, water-quality

Tables

Table 1

@usgov.king_county_washington_water_quality.table_1

82.4 MB
1916395 rows
25 columns


CREATE TABLE table_1 (
  "sample_id" BIGINT,
  "grab_id" DOUBLE,
  "profile_id" BIGINT,
  "sample_number" VARCHAR,
  "collect_datetime" VARCHAR,
  "depth_m" DOUBLE,
  "site_type" VARCHAR,
  "area" VARCHAR,
  "locator" VARCHAR,
  "site" VARCHAR,
  "parameter" VARCHAR,
  "value" DOUBLE,
  "units" VARCHAR,
  "qualityid" BIGINT,
  "lab_qualifier" VARCHAR,
  "mdl" DOUBLE,
  "rdl" DOUBLE,
  "text_value" VARCHAR,
  "sample_info" VARCHAR,
  "steward_note" VARCHAR,
  "replicates" DOUBLE,
  "replicate_of" VARCHAR,
  "method" VARCHAR,
  "date_analyzed" TIMESTAMP,
  "data_source" VARCHAR
);