Baselight
Sign In

Drinking Water - Open Environmental Data Project - March 23, 2023 Workshop

State of California

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e

Loading...
Loading...

About this Dataset

Drinking Water - Open Environmental Data Project - March 23, 2023 Workshop

The following datasets related to regulated drinking water system facilities in California have been developed and are available for the purpose of the March 23, 2023, OEDP workshop. The main purpose of the workshop is to engage community members and researchers in understanding datasets maintained and shared by the California State Water Resources Control Board Drinking Water Program and explore possibilities for their use and enhancement. Input from this workshop could be used to inform recommendations OEDP makes to partnering organizations about how to collect, share, and structure their open datasets. Conversations could also support community organizations in using water datasets to inform programming, policy advocacy, or organizing.
Organization: State of California
Last updated: 2025-07-23T16:15:11.161302
Tags: drinking-water, drinking-water-quality-results, drinking-water-violations, open-data

Tables

Drinking Water Laboratory Analysis Results 2011

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2011
  • 37.18 MB
  • 1,581,406 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2011 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2012

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2012
  • 36.55 MB
  • 1,552,678 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2012 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2013

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2013
  • 37.28 MB
  • 1,556,423 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2013 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2014

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2014
  • 40 MB
  • 1,660,117 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2014 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2015

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2015
  • 37.18 MB
  • 1,539,236 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2015 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2016

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2016
  • 37.26 MB
  • 1,558,368 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2016 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" BIGINT,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2017

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2017
  • 41.18 MB
  • 1,695,793 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2017 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2018

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2018
  • 42.88 MB
  • 1,767,873 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2018 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2019

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2019
  • 42.13 MB
  • 1,725,921 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2019 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2020

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2020
  • 43.62 MB
  • 1,790,815 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2020 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2021

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2021
  • 45.44 MB
  • 1,766,849 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2021 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2022

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2022
  • 44.66 MB
  • 1,726,896 rows
  • 32 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2022 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "less_than" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "water_system_is" BIGINT  -- Water System IS#,
  "water_system_facility_is" BIGINT  -- Water System Facility IS#,
  "facility_water_type" VARCHAR
);

Drinking Water Laboratory Analysis Results 2023

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2023
  • 84.67 MB
  • 1,983,248 rows
  • 37 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2023 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "facility_water_type" VARCHAR,
  "water_system_primary_key" BIGINT,
  "water_system_facility_primary_key" BIGINT,
  "facility_id" VARCHAR  -- Facility ID#,
  "sample_pointid" VARCHAR  -- Sample PointID#,
  "sample_type" VARCHAR,
  "less_than_reporting_level" VARCHAR,
  "lab_sample_id" VARCHAR,
  "record_id" BIGINT  -- Record ID#
);

Drinking Water Laboratory Analysis Results 2024

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2024
  • 88.29 MB
  • 2,068,496 rows
  • 37 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2024 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "facility_water_type" VARCHAR,
  "water_system_primary_key" BIGINT,
  "water_system_facility_primary_key" BIGINT,
  "facility_id" VARCHAR  -- Facility ID#,
  "sample_pointid" VARCHAR  -- Sample PointID#,
  "sample_type" VARCHAR,
  "less_than_reporting_level" VARCHAR,
  "lab_sample_id" VARCHAR,
  "record_id" BIGINT  -- Record ID#
);

Drinking Water Laboratory Analysis Results 2025

@usgov.ca_gov_drinking_water_open_environmental_project_march_483d755e.drinking_water_laboratory_analysis_results_2025
  • 2.5 MB
  • 68,042 rows
  • 37 columns
Loading... 
CREATE TABLE drinking_water_laboratory_analysis_results_2025 (
  "regulating_agency" VARCHAR,
  "water_system_number" VARCHAR,
  "water_system_name" VARCHAR,
  "system_status" VARCHAR,
  "water_system_classification" VARCHAR,
  "principal_county_served" VARCHAR,
  "population_served" BIGINT,
  "service_connections" DOUBLE,
  "ps_code" VARCHAR,
  "sampling_point_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "sample_date" TIMESTAMP,
  "year" BIGINT,
  "sample_time" VARCHAR,
  "analysis_date" TIMESTAMP,
  "elap_cert" BIGINT  -- ELAP Cert#,
  "lab_name" VARCHAR,
  "analyte_code" VARCHAR,
  "analyte_name" VARCHAR,
  "reporting_level" DOUBLE,
  "result" DOUBLE,
  "counting_error" DOUBLE,
  "dlr" DOUBLE,
  "mcl" DOUBLE,
  "units_of_measure" VARCHAR,
  "method" VARCHAR,
  "indate" TIMESTAMP,
  "facility_water_type" VARCHAR,
  "water_system_primary_key" BIGINT,
  "water_system_facility_primary_key" BIGINT,
  "facility_id" VARCHAR  -- Facility ID#,
  "sample_pointid" VARCHAR  -- Sample PointID#,
  "sample_type" VARCHAR,
  "less_than_reporting_level" VARCHAR,
  "lab_sample_id" VARCHAR,
  "record_id" BIGINT  -- Record ID#
);

Share link

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