Safe Drinking Water Sample Results Information Systems Pennsylvania 2010 - Current Environmental Protection
data.pa.gov | Last Updated 21 Feb 2022Pennsylvania collects and manages public drinking water system information in the Pennsylvania Drinking Water Information System (PADWIS). <br> The data includes water system inventory information, drinking water sample results for testing required by the regulations and violations of PA Safe Drinking Water Regulations, pertaining to monitoring/reporting requirements, MCL exceedances, and treatment techniques. Much of this data is searchable via the www.drinkingwater.state.pa.us website. This set contains drinking water sample results reported on behalf of Pennsylvania’s regulated public water supplies. The data is updated quarterly.
This dataset has the following 17 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Public Water System Name | water_system_name | text | Public Water System Name | AQUA PA MAIN SYSTEM PHILADELPHIA WATER DEPARTMENT PITTSBURGH WATER & SEWER AUTH LCA WLSA CENTRAL DIVISION NORTH PENN WATER AUTHORITY view top 100 |
| Public Water System ID | water_sytem_id | text | Public Water System ID | 1460073 1510001 5020038 3390073 1460034 view top 100 |
| Activity | activity | text | Current System Activity | ACTIVE INACTIVE view top 100 |
| Public Water System Type | water_system_type | text | Type of Public Water System | COMMUNITY NONTRANSIENT NONCOMM TRANSIENT NONCOMM BOTTLED WATER VENDED WATER view top 100 |
| Population Served | population | text | Population Served by the Water System | 25 100 50 150 200 view top 100 |
| Location ID | location_id | text | Sample Location ID | 101 100 102 103 104 view top 100 |
| Sample Type | sample_type | text | Type of Sample: Check Samples Are Collected to Confirm the Result of Some Type of Routine Sample (Entry Point or Distribution), Distribution Samples are collected from locations within the Distribution System, Entry Point Samples Are Collected After All Treatment and Required Disinfectant Contact Time, Filter Samples Are Collected After an Individual Filter, Maximum Residence Samples Are Collected From the Location in the Distribution System with Maximum Water Residence Time, Plant Samples Are Collected at a Point After Some Treatment but Prior to the Entry Point, Raw Samples Are Collected Prior to Any Treatment, Special Samples Are Not Necessarily Collected at a Required Location or as Required by a Regulation | ENTRY POINT DISTRIBUTION N RAW WATER SPECIAL view top 100 |
| Date Sample Collected | date_sample_collected | calendar_date | Date Sample Collected | 2020-04-07T00:00:00.000 2019-08-13T00:00:00.000 2019-08-14T00:00:00.000 2019-08-06T00:00:00.000 2020-04-14T00:00:00.000 view top 100 |
| Completed Analysis Date | analysis_date | calendar_date | Data Sample Analysis Was Completed | 2019-08-14T00:00:00.000 2019-07-02T00:00:00.000 2019-09-04T00:00:00.000 2020-08-12T00:00:00.000 2019-10-02T00:00:00.000 view top 100 |
| Sample Received Date | sample_received_date | calendar_date | Date Result was Received by the Department | 2018-07-06T00:00:00.000 2019-09-09T00:00:00.000 2019-06-10T00:00:00.000 2019-12-09T00:00:00.000 2019-08-09T00:00:00.000 view top 100 |
| Contaminant Group ID | group_id | text | Contaminant Group ID: DDBP – Disinfectants and Disinfection By Products, Filt – Surface Water Treatment Rule, IOC - Inorganic Contaminants, LCR – Lead/Copper Rule, LT2 – Surface Water Treatment Rule, NTRT – Nitrate/Nitrite, Othr – A Contaminant That Doesn’t Fall Specifically Into One of the other Groups, PERF – Perfluoroalkyl and Polyfluoroalkyl Substances, RAD – Radionuclide Rule, SEC – Secondary Inorganic Contaminants, SOC - Synthetic Organic Contaminants, TCR – Total Coliform Rule or Revised Total Coliform Rule, UIOC – Unregulated Inorganic Contaminants, USOC – Unregulated Synthetic Organic Contaminants, VOC - Volatile Organic Contaminants | DDBP OTHR TCR SOC VOC view top 100 |
| Contaminant Name | contaminant | text | Contaminant Name. 0999 is Free Chlorine and 100 is Turbidity | CHLORINE FREE CHLORINE TOTAL COLIFORM PRESENCE E. COLIFORM PRESENCE GIARDIA INACTIVATION view top 100 |
| Measure Result | measure_result | text | Analysis Result, Generally Units Are in MG/L, Exceptions: Coliform Bacteria - Presence (1)/Absence (0) or Count/100 mL, RAD Contaminants - pCi/L, Turbidity - NTU, Cryptosporidum – Oocysts/L, PERF - NG/L | 0 1 1.1 1.2 1.3 view top 100 |
| Analysis Method | analysis_method | text | Analysis Method | DPD-SM 4500 CL G 21ST GWR-ONPG-MUG (MMO-MUG) ???? PURGE & TRAP (MS VOCS 524.2) ICP, MASS SPEC. view top 100 |
| Analyzing Laboratory Name | lab_name | text | Name of Analyzing Laboratory | SUBURBAN WATER TESTING LABS ANALYTICAL LABORATORY SERVICES AQUA PENNSYLVANIA, INC M J REIDER ASSOC INC PROSSER LABORATORIES view top 100 |
| Laboratory Id | lab_id | text | Analyzing Laboratory ID | 06208 22293 46026 06003 45289 view top 100 |
| County Name | county_name | text | Name of County Where Water System is Located | Lancaster Bucks Montgomery Berks Monroe view top 100 |