Safe Drinking Water Act (SDWA) Systems Search Service

Output Format Flag. Enter one of the following keywords:

• JSON = Data model formatted as Javascript Object Notation (default).
• JSONP = Data model formatted as Javascript Object Notation with Padding.
• XML = Data model formatted as Extensible Markup Language.

Facility Name Filter. Enter one or more case-insensitive facility names to filter results. Provide multiple values as a comma-delimited list. See p_fntype for additional modifiers.

Facility City Filter. Enter a single case-insensitive city name to filter results.

Facility County Filter. Provide a single county name in combination with a state value provided via p_st.

FIPS Code Filter. Enter a single 5-character Federal Information Processing Standards (FIPS) state + county value to restrict results. E.g. to limit results to Kenosha County, Wisconsin, use 55059.

Facility State and State-Equivalent Filter. Provide one or more USPS postal abbreviations for states and state-equivalents to filter results. Provide multiple values as a comma-delimited list.

5-Digit ZIP Code Filter. Provide one or more 5-digit postal zip codes to filter results. May contain multiple comma-separated values.

EPA Region Filter. Provide a single value of 01 thru 10 to restrict results to a single EPA region.

Tribe name

Active Permits/Facilities Flag. Provide Y or N to filter results to facilities with active permits.

Quarters in Noncompliance Limiter. Enter a coded value to limit results to facilities with given quarter of noncompliance.

• Z = Zero quarters in noncompliance.
• GEXX = Replacing XX with a numeric value, that number of quarterd or more in noncompliance.
• GTXX = Replacing XX with a numeric value, more than that number of quarters in noncompliance.

Indian Country Flag. Enter a "Y" or "N" to restrict searches to facilities inside or outside Indian Country.

Nine-digit permit IDs. May contain up to 2000 comma-separated values.

Owner/Operator code filter. Enter one of the following codes to filter results:

• F = Federal Government
• S = State Government
• L = Local Government
• M = Public/Private
• N = Native American
• P = Private

Type of public water system:

• CWS=Community water system
• NCWS=Non-community water system
• NTCWS=Non-transient non-community water system
• TNCWS=Transient non-community water system

Source Water Type:

• SW = Surface water
• GW= Ground water
• GU = Ground water under direct influence of (UDI) surface water
• SWP = Purchased Surface water
• GWP = Purchased Ground water
• GUP = Purchased Ground water UDI surface water

Estimated average daily population served by a system:

• LE500 = 500 or less
• IN501_3K = 501-3,300
• IN3K_10K = 3,301-10,000
• IN10K_100K = 10,001-100,000
• IN100K_1M = 100,001-1,000,000
• GT1M = More than 1,000,000 May contain multiple comma-separated values.

Current violations:

• M = Monitoring and Reporting Violations
• H = Health-based Violations
• O = Other Violations
• P = Public Notice Violations
• S = Serious Violator
• N = No Violations May contain multiple comma-separated values.

Monitoring and Reporting Violations (failure to conduct regular monitoring of drinking water quality or submit monitoring results in a timely fashion).

Violations of health-based drinking water standards (maximum contaminant levels, maximum residual disinfectant levels, or treatment technique rules).

Other violations, such as failing to issue annual consumer confidence reports or maintain required records.

Public Notice Violations (failure to immediately alert consumers of serious problem with drinking water).

Serious Violator (unresolved serious, multiple, and/or continuing violations). A value of Y will return only SDWIS systems that are Serious Violators, while a value of N will only return SDWIS Systems that are not Serious Violators.

Quick Search. Allows entry for city, state, and/or zip code.

Single Facility Search Filter. Provide a facility name or program system identifier to limit results. For the all data search, the FRS registry identifier is also searched.

For CWA, pollutant names for surface water discharges. for Drinking Water, SDWIS Violation contaminant codes for unaddressed violations that have occurred in the last 3 years. May contain multiple comma-separated values.

Used in conjuction with parameters p_pswpol and p_pswparam, indicates whether search should only include pollutants with violations.

Lead Action Level Exceedance. A "Y" value will select water systems with at least 1 Lead Action Level Exceedance.

Copper Action Level Exceedance. A "Y" value will select water systems with at least 1 Copper Action Level Exceedance.

Rule code 350 violation. A "Y" value will select water systems with at least one rule code 350 violation.

Lead Violations. A "Y" value will select water systems with at least 1 Lead Violation.

Copper Violation. A "Y" value will select water systems with at least 1 Copper Violation.

Lead or Copper rule violations. A "Y" value will select water systems with at least 1 Lead or Copper Rule Violation.

Formal Enforcement Actions [within / not within] specified date range indicator. The date range is determined by parameters p_fead1 and p_fead2 or by parameter p_feay.

• W = within date range
• N = not within date range

Years (1 to 5) Range. This value is used to create a date range for Formal Enforcement Actions (FEA). Used along with p_fea (which indicates whether to look within or outside of the date range) to find FEAs within (or not within) the number of years specified.

Agency associated with Formal Enforcement Actions:

• E = EPA
• S = State
• A = All

Informal Enforcement Actions [within / not within] specified date range. The date range is determined by parameters p_iead1 and p_iead2 or by parameter p_ieay.

• W = within date range
• N = not within date range

Years (1 to 5) Range. This value is used to create a date range for Informal Enforcement Actions (IEA). Used along with p_iea (which indicates whether to look within or outside of the date range) to find IEAs within (or not within) the number of years specified.

Agency associated with Informal Enforcement Actions. If left blank, both agencies are included.

• E = EPA
• S = State

Significant Quarters in Noncompliance Limiter. Enter one of the following codes to limit results to facilities having given quarters of noncompliance.

• Z = Zero quarters in noncompliance.
• GE1 = One or more quarters in noncompliance.
• GT1 = More than one quarters in noncompliance.
• GE2 = Two or more quarters in noncompliance.
• GT2 = More than two quarters in noncompliance.
• GE4 = Four or more quarters in noncompliance.
• GT4 = More than four quarters in noncompliance.
• GE8 = Eight or more quarters in noncompliance.
• GT8 = More than eight quarters in noncompliance.
• GE12 = Twelve or more quarters in noncompliance.
• GT12 = Twelve or more quarters in noncompliance.
• 12 = Exactly twelve quarters in noncompliance. Note the seemingly incongruous of GT12 is deliberate.

Formal Enforcement Action Date Range Start. Enter a date in MM/DD/YYYY format to set the start of the range for filtering by recent Formal Enforcement Action (FEA) taken against the facility within the last five years.

Formal Enforcement Action Date Range End. Enter a date in MM/DD/YYYY format to set the end of the date range for filtering by recent Formal Enforcement Action (FEA) taken against the facility within the last five years.

Formal Enforcement Action (FEA) Code Filter. Enter one or more three-letter FEA codes to restrict results to facilities with these attributes. Use p_fead1 and p_fead2 parameters to further restrict this filter by entering a date range. Provide multiple codes as a comma-delimited list.

Sanitary Surveys (in past 5 years) flag. Values of visit_reason_code are either "SNSV" or "SNSP" in the past 5 years indicate a Sanitary Survey.

Enter "Y" to select facilities with Sanitary Surveys within the past 5 years.

Enter "N" to select facilities without Sanitary Surveys in the past 5 years.

Enter a number to search for greater for facilities with a quantity than or equal to that value.

Significant Deficiency Count (in past 5 years) flag.

Enter "Y" to select facilities with Sanitary Surveys within the past 5 years.

Enter "N" to select facilities without Sanitary Surveys in the past 5 years.

Enter a number to search for facilities with a quantity greater than or equal to that value.

Last Facility Inspection [within / not within] Specified Date Range Indicator. The date range is determined by parameters p_idt1 and p_idt2 or by parameter p_ysly.

• W = within date range
• N = not within date range

Number of years (1 to 5) since last facility inspection. A value of 1 means that it has been inspected within the year.

Facility Last Inspection Code Filter. If left blank, both agencies are included. Enter a value to limit results:

• E = EPA
• S = State

Beginning of date range of most recent facility inspection.

End of date range of most recent facility inspection.

Query Limiter. Enter a value to limit the number of records returned for each query. Value cannot exceed 70,000.

Response Set Limiter. Enter a value to limit the number of records per page. Value cannot exceed 1,000.

JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response.

Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.