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

86.4 MB
1,916,395 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  -- Depth (m),
  "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
);