About this Dataset

Drinking Water - Results Of Lead Sampling Of Drinking Water In California Schools

The Division of Drinking Water (DDW), in collaboration with the California Department of Education, has taken the initiative to begin testing for lead in drinking water at all public K-12 schools. In early 2017, DDW and Local Primacy Agencies issued amendments to the domestic water supply permits of approximately 1,200 community water systems so that schools that are served by a public water system could request assistance from their public water system to conduct water sampling for lead and receive technical assistance if an elevated lead sample is found. To further safeguard water quality in California’s K-12 public schools, California Assembly Bill 746 published on October 12, 2017, effective January 1, 2018, requires community water system to test lead levels, by July 1, 2019, in drinking water at all California public, K-12 school sites that were constructed before January 1, 2010. The program webpage contains information on both the permit amendments and AB 746.
Organization: State of California
Last updated: 2021-07-23T12:32:25.050962
Tags: child-health, drinking-water, lead-contamination, public-schools, water

Tables

Drinking Water - Monthly Summary Of Results Of Lead Sampling Of Drinking Water In California Schools

@usgov.ca_gov_drinking_water_results_of_lead_sampling_of_drin_cd762e96.drinking_water_monthly_summary_of_results_of_lead_samp_cbde23c8

1.47 MB
43,978 rows
21 columns

CREATE TABLE drinking_water_monthly_summary_of_results_of_lead_samp_cbde23c8 (
  "pws_id" VARCHAR,
  "pscode" VARCHAR,
  "district" VARCHAR,
  "school_name" VARCHAR,
  "school_address" VARCHAR,
  "school_site_name" VARCHAR,
  "samp_date" BIGINT,
  "xmod" VARCHAR,
  "result" DOUBLE,
  "rpt_unit" VARCHAR,
  "water_system_name" VARCHAR,
  "water_system_county" VARCHAR,
  "school_county" VARCHAR,
  "sample_date" TIMESTAMP,
  "samp_loaded" BIGINT,
  "sample_loaddate" TIMESTAMP,
  "samp_time" BIGINT,
  "action_level_exceedance" VARCHAR,
  "ale_follow_up_action" VARCHAR,
  "ale_follow_up_status" VARCHAR,
  "school_type" VARCHAR
);