Other Datasets

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're just looking to search for Safer Choice products, visit the Safer Choice Product Search page.

You can download the full dataset from the Envirofacts database using the Envirofacts RESTful API. The data is available in the following formats: 

• CSV - Comma Separated Values.
• JSON - JavaScript Object Notation. 
• Excel - Microsoft Excel.
• XML - Extensible Markup Language.

The dataset is also available in Spanish: 

• CSV (Spanish). 
• JSON (Spanish). 
• Excel (Spanish). 
• XML (Spanish). 

View the Model 

Use the Safer Choice 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 Name: T_SAFERCHOICE_AND_DESIGN_FOR_THE_ENVIRONMENT Columns:

• PRODUCT NAME - A Safer Choice-labeled product that is made by a partner company.
  • Type: VARCHAR2 | Length: 500
• COMPANY NAME - A company who has signed a partnership agreement with the Safer Choice program.
  • Type: VARCHAR2 | Length: 250 
• 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.
  • Type: VARCHAR2 | Length: 500
• CATEGORY - Reported values of Industrial/Institutional Product or Consumer Product representing the audience.
  • Type: VARCHAR2 | Length: 250 
• CITY - The city name of the partner's location.
  • Type: VARCHAR2 | Length: 150
• STATE - The state abbreviation for the partner's location.
  • Type: VARCHAR2 | Length: 20
• PARTNER SINCE - The date a company signed a partnership agreement with the Safer Choice program.
  • Type: VARCHAR2 | Length: 15
• FRAGRANCE-FREE  - Safer Choice has verified that this product meets the Safer Choice Criteria for Fragrance-Free products.
  • Type: VARCHAR2 | Length: 5
• 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. Click here to review the Safer Choice Product-Class Criteria.
  • Type: VARCHAR2 | Length: 5
• PRODUCT URL  - A unique URL leading to the product's listing on the certified product webpage.
  • Type: VARCHAR2 | Length: 250 
• COMPANY IN GOOD STANDING  - An indication of whether the partner company that makes a product is up to date on its yearly partnership review with Safer Choice.
  • Type: VARCHAR2 | Length: 250 
• PROGRAM - The program the product is certified under.
  • Type: VARCHAR2 | Length: 250 
• GTIN - The Global Trade Item Number of the product. 
  • Type: NUMBER | Length: 250
• MPN - Manufacturer Part Number.  It is a unique number that is issued by manufacturers to identify individual products. 
  • Type: VARCHAR2 | Length: 250 

• UPC - The Universal Product Code of the product.

  • 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. 

To access SDWIS data:

• Explore the data model: SDWIS data model page.
• Learn how to use the API: Envirofacts Web Services page.
• View the table and column definitions: SDWIS Data Element Search page. 

Other SDWIS Data tables:

• SDW_COUNTY_SERVED
• SDW_VIOL_ENFORCEMENT

• Find public water systems in a specific county:
  • ACCOMACK County Example
     
• View enforcement actions by county and state: 
  • McLean County, IL Example.  
     
• View the violations for a specific water system(PWSID): 
  • Example: Violations for water system IL1341937.