Other Datasets

EPA's mission is to protect the health of people and the environment. To further that mission, EPA labels products so that consumers can easily choose ones that are safer for people and the environment. Using EPA's science expertise, the Safer Choice program applies stringent criteria for health and environmental safety in labeling the safest products. When consumers see the Safer Choice label on a product, they can be confident that the product is among the safest when compared with traditional products.

Design for the Environment

Included in these files are products certified by the Design for the Environment (Dfe) program or Safer Choice program. Disinfectants and sanitizers may qualify for the Design for the Environment (DfE) logo. When you see a product with the DfE logo, it means that every ingredient in that product has met rigorous standards for protecting the environment, your health, and the health of your family and pets. EPA developed this program to further empower consumers to make environmentally and health-conscious buying decisions.

Get the Data

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

• https://data.epa.gov/efservice/t_saferchoice and design for the environment_esp/CSV- (Comma Separated Value format)
• https://data.epa.gov/efservice/t_saferchoice and design for the environment_esp/JSON> - (JavaScript Object Notation format)
• https://data.epa.gov/efservice/t_safer_choice_and_design_for_the_environment_esp/EXCEL - (Microsoft Excel format)
• https://data.epa.gov/efservice/t_saferchoice and design for the environment_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_AND_DESIGN_FOR_THE_ENVIRONMENT 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 this product meets the Safer Choice Criteria for Fragrance-Free products.
• OUTDOOR USE  - Where marketed for outdoor use, Safer Choice-certified products must contain ingredients that meet the Safer Choice Criteria for Chemicals in Direct Release Products. 
• PRODUCT URL  - A unique URL leading to the product's listing on the certified product webpage.
• 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.
• PROGRAM - The program the product is certified under.
• GTIN - The Global Trade Item Number of the product. 
• MPN - Manufacturer Part Number.  It is a unique number that is issued by manufacturers to identify individual products. 

• UPC - The Universal Product Code of the product.

  For additional information, please see the Safer Choice Model page

Additional Resources

• Safer Choice Homepage
• About the Program
• Safer Choice Labeled Products

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://www.epa.gov/dwreginfo/drinking-water-regulations#List.

SDWIS information is available within the tables documented at: https://enviro.epa.gov/envirofacts/metadata/model/sdwis. 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 Data Element Search page.

SDWIS Other Data tables (metadata):

• SDW_COUNTY_SERVED
• SDW_VIOL_ENFORCEMENT

• 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://data.epa.gov/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://data.epa.gov/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://data.epa.gov/efservice/SDW_VIOL_ENFORCEMENT/PWSID/IL3141937/JSON