Dataset: Water Quality

About this Dataset

Water Quality

This dataset contains water quality samples collected from Puget Sound, lakes, and streams in the region.
Sample ID: Unique identifier for each sample taken.
Grab ID: Identifier for the specific grab instance associated with the sample.
Profile ID: Identifier for the profile associated with the sample.
Sample Number: Sequential number assigned to each sample.
Collect DateTime: Date and time when the sample was collected.
Depth (m): Depth at which the sample was collected, measured in meters.
Site Type: Type of site where the sample was collected (e.g., river, lake, well).
Area: Geographic area or region where the sample was collected.
Locator: Locator information indicating the precise location of the sample.
Site: Specific site or location where the sample was collected.
Parameter: The parameter measured or analyzed in the sample (e.g., pH, dissolved oxygen).
Value: Value of the parameter measured in the sample.
Units: Units of measurement for the parameter value.
QualityId: Identifier indicating the quality of the data.
Lab Qualifier: Qualifier assigned by the laboratory indicating any special conditions or characteristics of the sample.
MDL (Method Detection Limit): Method detection limit for the parameter.
RDL (Reporting Detection Limit): Reporting detection limit for the parameter.
Text Value: Textual representation of the parameter value.
Sample Info: Additional information related to the sample.
Steward Note: Notes or comments provided by the data steward.
Replicates: Number of replicates taken for the sample.
Replicate Of: Identifier indicating the sample of which this is a replicate.
Method: Method used for analysis or measurement.
Date Analyzed: Date when the sample was analyzed.
Data Source: Source of the data.

Tables

Water Quality 1

@kaggle.sukhmandeepsinghbrar_water_quality.water_quality_1

48.15 MB
1259444 rows
25 columns


CREATE TABLE water_quality_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" DOUBLE,
  "method" VARCHAR,
  "date_analyzed" TIMESTAMP,
  "data_source" VARCHAR
);