← All datasets

# curated.water_system_lcr_sample
EPA SDWIS Lead and Copper Rule 90th-percentile results per system and monitoring period (14,909 rows; category: Environment; no geometry)
Notes: contaminant_code 'PB90' = lead, 'CU90' = copper, sample_measure in mg/L. Action levels: lead 0.015 mg/L (15 ppb), copper 1.3 mg/L. A result is the system's 90th-percentile tap sample for the period, not one home. Use the latest sampling_end_date per system for current status.

Fields (expression | type | filled/distinct in a sample | values or examples):
- pwsid | text | 5000/1862 | e.g.: TX0200355; TX0200009; TX0200037
- sample_id | text | 5000/3217 | e.g.: 4996; 4995; 4994
- sampling_start_date | date | 5000/70 | e.g.: 1996-01-01; 1995-01-01; 2023-01-01
- sampling_end_date | date | 5000/73 | e.g.: 1996-12-31; 2025-12-31; 2022-12-31
- contaminant_code | text | 5000/2 | values: PB90; CU90
- result_sign_code | text | 0/0 | e.g.: 
- sample_measure | double precision | 5000/765 | e.g.: 0; 0.01; 0.001
- unit_of_measure | text | 5000/1 | values: mg/L