Integrated Compliance Information System (ICIS)

Concentrated Animal Feeding Operations (CAFOs) are agricultural operations where animals are kept and raised in confined situations. Manure and wastewater from CAFOs have the potential to contribute pollutants such as nitrogen and phosphorus, organic matter, sediment, pathogens, heavy metals, hormones, antibiotics, and ammonia to the environment. Animal waste can enter water bodies from spills or breaks of waste storage structures, due to accidents or excessive rain, and non-agricultural application of manure to crop land. The NPDES program regulates the discharge of pollutants from CAFOs to waters of the United States.

CAFO information is available within the ICIS tables documented at PCS-ICIS Model. Utilizing the Envirofacts REST API, the CAFO information can be queried and retrieved from the ICIS database. To simplify the process of retrieving CAFO information, a special data view has been created combining the data within all five tables. The data view is named V_ICIS_FACILITY_CAFO.

To retrieve CAFO information utilizing the data view, you can utilize the Envirofacts REST API at https://enviro.epa.gov/enviro/efservice/V_ICIS_FACILITY_CAFO/ To better understand the options available in the Envirofacts REST API, the documentation is available on the Envirofacts Services Page. All of the data elements and metadata supporting the data elements is available on the V_ICIS_FACILITY_CAFO metadata page. Additional ICIS Other Data tables will be posted at the ICIS Other Data metadata page.

Below are a few example Envirofacts REST API URLs that run against the CAFO data:
 

• Return the first 10,000 CAFO records within an EXCEL spreadsheet
  https://enviro.epa.gov/enviro/efservice/V_ICIS_FACILITY_CAFO/excel/
   
• Return the first 25 CAFO records within an XML document for the state of Arkansas
  https://enviro.epa.gov/enviro/efservice/V_ICIS_FACILITY_CAFO/state_code/AR/rows/0:24
   
• Return the second 50 CAFO records within a JSON document for the ZIP Code 72655
  https://enviro.epa.gov/enviro/efservice/V_ICIS_FACILITY_CAFO/zip/72655/rows/50:99/JSON

Enforcement & Compliance History Online (ECHO)

About the Program

ECHO focuses on facility compliance and EPA/state enforcement of environmental regulations. ECHO provides integrated compliance and enforcement information for approximately 800,000 regulated facilities nationwide. The site allows users to find inspection, violation, enforcement action, informal enforcement action, and penalty information about facilities for the past three years. Facilities regulated under the following environmental statutes are included: Clean Air Act (CAA) Stationary Source Program, Clean Water Act (CWA) National Pollutant Elimination Discharge System (NPDES), Resource Conservation and Recovery Act (RCRA), and Safe Drinking Water Act (SDWA). The information shown in ECHO accesses an integrated database called IDEA, which stands for Integrated Data for Enforcement Analysis. Some users prefer to use the raw IDEA data rather than using the ECHO web interface. The ECHO Exporter and IDEA data downloads provide a full set of information nationally, whereas ECHO has limitations on how much data can be shown at one time.

Get the Data

The ECHO dataset is updated monthly and can be downloaded or accessed directly from the database.

To access the data real-time, that's updated monthly, within the Envirofact's database, you can use the Envirofacts RESTful API. The data can be obtained in four different output types. Please use the links below to access the most current compliance data within the Envirofacts database. The compliance data from ECHO only consists of one table, so the links below will retrieve all of the columns available within the Envirofacts database for ECHO's compliance data. These links will retrieve the first 5 rows of data within the table.

• https://enviro.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/CSV - (Comma Separated Value format)
• https://enviro.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/JSON - (JavaScript Object Notation format)
• https://enviro.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/EXCEL - (Microsoft Excel format)
• https://enviro.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/XML - (Extensible Markup Language format)

The Envirofacts RESTful API can output 5000 rows of data from the table for each call to the API. For more information on how this process works, along with other functionality within the API, please visit the Envirofacts RESTful API.

Below are a few additional links to the Envirofacts RESTful API, using a few of the features to query compliance data.

• https://enviro.epa.gov/enviro/efservice/t_compliance_echo/zip/60085/EXCEL - This URL will return all of the compliance records for ZIP Code 60085 in an EXCEL file.
• https://enviro.epa.gov/enviro/efservice/t_compliance_echo/city/WASHINGTON/state/DC - This URL will return all of the compliance records for Washington, DC in XML.
• https://enviro.epa.gov/enviro/efservice/t_compliance_echo/city/WASHINGTON/state/DC/CURR_COMP_STATUS/serious violation(s)/JSON - This URL will return all of the compliance records whos current compliance records are listed as "serious violations(s)" in Washington, DC as a JSON output.

Using the features of the Envirofacts RESTful API and the Latest ECHO Explorer Version 2.0 Download, you can query the compliance and incorporate the results within your app.  

In addition to the above Envirofacts RESTful API access to the data, the complete ECHO dataset can be downloaded. Latest ECHO Explorer Version 2.0 Download

Safe Drinking Water Information System (SDWIS)

National Primary Drinking Water Regulations (NPDWRs), or primary standards, are legally enforceable standards that apply to public water systems. Primary standards protect public health by limiting the levels of certain contaminants in drinking water. EPA sets a Maximum Contamination Limit (MCL) for every regulated contaminant. When public water systems are found to contain contaminants in amounts exceeding the MCL, they are in violation and must take action to restore the quality of their water. For more information about EPA regulated drinking water contaminants visit https://water.epa.gov/drink/contaminants/#List.

SDWIS information is available within the tables documented at: SDWIS Model. Utilizing the Envirofacts REST API, the SDWIS information can be queried and retrieved from the SDWIS database. To simplify the process of retrieving SDWIS information, special data views have been created combining the data within all SDWIS tables. These data views, using the REST API service, are described below. To better understand the options available in the Envirofacts REST API, the documentation is available on the Envirofacts Services Page. For information on the tables and columns available thru the service calls below, please visit the SDWIS Other Data metadata page.

SDWIS Other Data tables (metadata):
 

• SDW_COUNTY_SERVED
• SDW_VIOL_ENFORCEMENT
• SDW_CONTAM_VIOL_ZIP
• SDW_CONTAM_VIOL_CITY

Example SDWIS REST API services:
 

• I would like to know, within a specific county, what are the different Public Water Systems (PWSs), the population served by each one, the regulating agency, and the contact name and phone number.
  Rest Web Service URL: https://enviro.epa.gov/enviro/efservice/SDW_COUNTY_SERVED/COUNTYSERVED/ACCOMACK
   
• I would like to know, within a specific county and state, the violations and enforcement actions for the different PWSs, as well as the definitions, health effects, and sources of contamination for any contaminants.
  Rest Web Service URL: https://enviro.epa.gov/enviro/efservice/SDW_VIOL_ENFORCEMENT/COUNTYSERVED/MCLEAN/STATE/IL/Excel
   
• I would like to know, for a specific PWS, the violations and enforcement actions, as well as the definitions, health effects, and sources of contamination for any contaminants.
  Rest Web Service URL: https://enviro.epa.gov/enviro/efservice/SDW_VIOL_ENFORCEMENT/PWSID/IL3141937/JSON
   
• I would like to know, for a specific zip code, the violations and enforcement actions, as well as the definitions, health effects, and sources of contamination for any contaminants.
  Rest Web Service URL: https://enviro.epa.gov/enviro/efservice/SDW_CONTAM_VIOL_ZIP/geolocation_zip/=/20460/rows/1:10/excel
   
• I would like to know, for a specific city and state, the violations and enforcement actions, as well as the definitions, health effects, and sources of contamination for any contaminants.
  Rest Web Service URL: https://enviro.epa.gov/enviro/efservice/SDW_CONTAM_VIOL_CITY/geolocation_city/CROFTON/STATE/MD/rows/1:10/excel

Safer Choice

About the Program

Products that qualify for the Safer Choice label contain ingredients that are safer for workers, families, pets, and the environment -- EPA scientists review every ingredient for potential health and environmental concerns. Safer Choice-labeled products must also meet performance, packaging, and ingredient disclosure requirements.

Get the Data

Learn about the API - Safer Choice data can be downloaded via the Envirofacts RESTful API. The data can be obtained in four different output types. Please use the links below to access the most current Safer Choice data within the Envirofacts database. Safer Choice only consists of one table, so the links below will retrieve all of the data within the Envirofacts database for the T_SAFERCHOICE table.
 

• https://enviro.epa.gov/enviro/efservice/t_saferchoice/CSV - (Comma Separated Value format)
• https://enviro.epa.gov/enviro/efservice/t_saferchoice/JSON - (JavaScript Object Notation format)
• https://enviro.epa.gov/enviro/efservice/t_saferchoice/EXCEL - (Microsoft Excel format)
• https://enviro.epa.gov/enviro/efservice/t_saferchoice/XML - (Extensible Markup Language format)

The Spanish version of this data is available in the T_SAFERCHOICE_ESP table.
 

• https://enviro.epa.gov/enviro/efservice/t_saferchoice_esp/CSV - (Comma Separated Value format)
• https://enviro.epa.gov/enviro/efservice/t_saferchoice_esp/JSON - (JavaScript Object Notation format)
• https://enviro.epa.gov/enviro/efservice/t_saferchoice_esp/EXCEL - (Microsoft Excel format)
• https://enviro.epa.gov/enviro/efservice/t_saferchoice_esp/XML - (Extensible Markup Language format)

The links above are available for you to download the full dataset, however you can use the information in the View the Model section below, or the Safer Choice Model page, along with the Envirofacts RESTful API documentation to create additional queries against the database.

View the Model - The data model is an important aspect of using the Envirofacts RESTful API. The model can be used to create Uniform Resource Locators (URL) that will query specific data elements for use in your applications. Safer Choice only consists of one table, as defined below:
Table Name: T_SAFERCHOICE
Columns:

• PRODUCT NAME - A Safer Choice-labeled product that is made by a partner company.
• COMPANY NAME - A company who has signed a partnership agreement with the Safer Choice program.
• SECTOR - A category of products, including the audience (e.g., Consumer or Institutional/Industrial) as well as the product use such as all-purpose cleaners, laundry detergents, etc.
• CATEGORY - Reported values of Industrial/Institutional Product or Consumer Product representing the audience.
• CITY - The city name of the partner's location.
• STATE - The state abbreviation for the partner's location.
• PARTNER SINCE - The date a company signed a partnership agreement with the Safer Choice program.
• FRAGRANCE-FREE - Safer Choice has verified that these products meet the Safer Choice Criteria for Fragrance-Free Products (https://19january2021snapshot.epa.gov/saferchoice/safer-choice-criteria-fragrance-free-products).
• OUTDOOR USE - Safer Choice encourages limiting direct releases to the environment.  Where marketed for outdoor use, Safer Choice-certified products must contain ingredients that meet the Safer Choice Criteria for Chemicals in Direct Release Products (https://19january2021snapshot.epa.gov/saferchoice/standard#tab-3).

For additional information, please see the Safer Choice Model page.

Sample Data - When running the Envirofacts RESTful API you will retrieve data in various formats. An example of how the data appears is below.

CATEGORY	SECTOR	COMPANY NAME	CITY	STATE	PARTNER SINCE	PRODUCT NAME	FRAGRANCE-FREE	OUTDOOR USE
Industrial/Institutional Product	All-Purpose Cleaners	Barnes Distribution	Cleveland	OH	Apr 2009	*Biodyne - Unscented
Industrial/Institutional Product	All-Purpose Cleaners	BCD Supply	Crest Hill	IL	Jun 2011	*Green Clean Enviro-Degreaser
Industrial/Institutional Product	All-Purpose Cleaners	Beaver Research Company	Portage	MI	Jan 2009	*FOAM BLANC

Additional Resources

• Safer Choice Home Page
• Learn About the Safer Choice Label
• Safer Choice on Facebook