Download Additional Envirofacts Datasets

Safer Choice and Design for the Environment

To learn more about these programs, visit the Safer Choice homepage and the Design for the Environment webpage .

Get the data

This section is for users who want to download Safer Choice data directly. If you want to search for Safer Choice products, use the Safer Choice Product Search .

Download the full dataset from Envirofacts using the Envirofacts RESTful API. Available formats:

• Safer Choice dataset (CSV)
• Safer Choice dataset (JSON)
• Safer Choice dataset (Excel)
• Safer Choice dataset (XML)

The dataset is also available in Spanish:

• Safer Choice dataset (CSV, Spanish)
• Safer Choice dataset (JSON, Spanish)
• Safer Choice dataset (Excel, Spanish)
• Safer Choice dataset (XML, Spanish)

View the data model

Use the Safer Choice data model and the Envirofacts RESTful API documentation to understand the structure of the data and build custom queries. Safer Choice data is stored in a single table, described below.

Table and column definitions

Table name: T_SAFERCHOICE_AND_DESIGN_FOR_THE_ENVIRONMENT

• PRODUCT NAME — A Safer Choice-labeled product made by a partner company.
  • Type: VARCHAR2 | Length: 500
• COMPANY NAME — A company that has signed a partnership agreement with the Safer Choice program.
  • Type: VARCHAR2 | Length: 250
• SECTOR — A category of products, including audience (e.g., Consumer or Institutional/Industrial) and product use (e.g., all-purpose cleaners, laundry detergents).
  • Type: VARCHAR2 | Length: 500
• CATEGORY — Industrial/Institutional Product or Consumer Product.
  • Type: VARCHAR2 | Length: 250
• CITY — City name of the partner location.
  • Type: VARCHAR2 | Length: 150
• STATE — State abbreviation for the partner location.
  • Type: VARCHAR2 | Length: 20
• PARTNER SINCE — Date the company signed a partnership agreement.
  • Type: VARCHAR2 | Length: 15
• FRAGRANCE-FREE — Indicates the product meets the Safer Choice criteria for fragrance-free products .
  • Type: VARCHAR2 | Length: 5
• OUTDOOR USE — Indicates products marketed for outdoor use must meet Safer Choice criteria for chemicals in direct release products. Review the Safer Choice product-class criteria.
  • Type: VARCHAR2 | Length: 5
• PRODUCT URL — URL for the product listing on the certified product webpage.
  • Type: VARCHAR2 | Length: 250
• COMPANY IN GOOD STANDING — Indicates whether the partner is up to date on the annual partnership review.
  • Type: VARCHAR2 | Length: 250
• PROGRAM — Program the product is certified under.
  • Type: VARCHAR2 | Length: 250
• GTIN — Global Trade Item Number.
  • Type: NUMBER | Length: 250
• MPN — Manufacturer Part Number.
  • Type: VARCHAR2 | Length: 250
• UPC — Universal Product Code.
  • Type: VARCHAR2 | Length: 250

Safe Drinking Water Information System (SDWIS)

SDWIS provides information about public water systems and how they comply with EPA drinking water standards. It includes data on violations, enforcement actions, and regulated contaminants. To learn more, visit the Drinking Water Regulations webpage .

Access SDWIS data

• SDWIS data model
• Envirofacts Web Services 
• SDWIS data element search

Other SDWIS data tables

• SDW_COUNTY_SERVED
• SDW_VIOL_ENFORCEMENT

Example API requests

• Public water systems in Accomack County (example) 
• Enforcement actions in McLean County, Illinois (Excel example) 
• Violations for water system IL3141937 (JSON example) 

Enforcement and Compliance History Online (ECHO)

About the program

ECHO provides data about facility inspections, violations, enforcement actions, and penalties under key environmental laws such as the Clean Air Act, Clean Water Act, Resource Conservation and Recovery Act, and the Safe Drinking Water Act. It includes data for about 800,000 regulated facilities across the United States.

Access ECHO web services on the ECHO web services page.