The zip files below contain 69 individual Microsoft Access files (one file per contaminant).  The number of records and the size of the files range considerably from contaminant to contaminant, generally reflecting the frequency of required sampling. The files below incorporate a corrected data set for nitrate monitoring data that was posted in November 2010 to correct an inconsistency in a state data set that was identified.

 

Part 1: Chemicals 1,1,1-Trichloroethane thru 2,4-D.zip(1 pg, 69 MB)

Part 2: Chemicals Cyanide thru Combined Radium 226_228.zip(1 pg, 75 MB)

Part 3: Chemicals Dalapon thru Monochlorobenzene.zip(1 pg, 81 MB)

Part 4: Chemicals Nitrate as N updated.zip(1 pg, 22 MB)

Part 5: Chemicals Nitrite as N thru Styrene.zip(1 pg, 33 MB)

Part 6: Chemicals Tetrachloroethylene thru Xylenes.zip(1 pg, 70 MB)

 

 

 

The following two tables are data dictionaries for the chemical data sets; they contain the list of data elements, column names, and a brief description of the data for each data element. Table 1 describes inventory data and Table 2 describes chemical specific information.

 

Table 1: Six-Year Review-ICR Dataset Data Element List - Inventory Data

Data Element	Column Name	Description
State Code	STATE	2- digit state code
Public Water System Identification Number (PWSID)	PWSID	The code used to identify each PWS. The code begins with the standard 2-character postal state abbreviation or region code; the remaining 7 numbers are unique to each PWS in the state.
System Name	PWSNAME	Name of the PWS.
Federal Public Water System Type Code	PWSTYPE	A code to identify whether a system is: • Community Water System (C); • Non-transient Non-community Water System (NTNC); or • Transient Non-community Water System (NC; nitrate/nitrite only).
Population-served	POPULATION	Highest average daily number of people served by a PWS, when in operation.
Source Water Type	SRCWATER	Type of water at the source. Source water type can be: • Ground water (GW); or • Surface water (SW); or • Ground water under the direct influence of surface water (GU)

Table 2: Six-Year Review-ICR Dataset Data Element List - Chemical-Specific Information

Data Element	Column Name	Description
State ID	ID	State-specific unique identification code
Sampling Point Identification Code	SAMPLEPOINTID	A sampling point identifier established by the state, unique within each applicable facility, for each applicable sampling location (e.g., entry point to the distribution system). This information enables occurrence assessments that address intra-system variability.
Sample Identification Number	SAMPLEID	Identifier assigned by state or the laboratory that uniquely identifies a sample.
Sample Collection Date	DATE	Date the sample was collected, including month, day, and year.
Contaminant	CHEMID	4-digit SDWIS contaminant identification number for which the sample is being analyzed.
Sample Analytical Result - Sign	DETECT	The sign indicates whether the sample analytical result was: • (0) "less than" means the contaminant was not detected or was detected at a level "less than" the MRL. • (1) "equal to" means the contaminant was detected at a level "equal to" the value reported in "Sample Analytical Result - Value."
Sample Analytical Result - Value	VALUE	Actual numeric (decimal) value of the analysis for the chemical result, or the MRL if the analytical result is less than the contaminant's MRL.
Sample Analytical Result - Unit of Measure	UNITS	Unit of measurement for the analytical results reported (usually expressed in either µg/L or mg/L for chemicals; or pCi/L for radionuclides).