Other Service-Enabled Data
- Home
- Multisystem Search
- Topic Searches
- System Data Searches
- About the Data
- Data Downloads
- Widgets
- Services
- Mobile
- Other Datasets
System Data Searches
Other Sites of Interest
Envirofacts contains a variety of environmental information from EPA System databases, as well as other EPA data sources. All of these data are important and critical in decision-making, however some of the data sources may not be easily accessible, and for this reason, these data are grouped on this page for easy access through the Envirofacts RESTful API. Below you will find a listing of program data available for download or incorporation into a mashup.
Enforcement & Compliance History Online (ECHO)
|
About the ProgramECHO 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.
- http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/CSV - (Comma Separated Value format)
- http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/JSON - (JavaScript Object Notation format)
- http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/EXCEL - (Microsoft Excel format)
- http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/XML - (Extensible Markup Language format)
Below are a few additional links to the Envirofacts RESTful API, using a few of the features to query compliance data.
- http://iaspub.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.
- http://iaspub.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.
- http://iaspub.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.
In addition to the above Envirofacts RESTful API access to the data, the complete ECHO dataset can be downloaded. The links for these complete downloads can be found below, along with the month and year of the file. The download file is formatted
as a compressed .ZIP file. The file within the .ZIP file is a Comma Separated Value file, that can be viewed within a text editor or Microsoft Excel.
The metadata describing the data and the column headers, can be found at: ECHO Exporter Version 1.0 Summary (.xls file, 75 KB)
- ECHO Exporter Version 1.0 Downloads
- January 2013 Refresh New! (.zip file, 44 MB)
- December 2012 Refresh(.zip file, 44 MB)
- November 2012 Refresh(.zip file, 44 MB)
- October 2012 Refresh(.zip file, 44 MB)
- September 2012 Refresh(.zip file, 43 MB)
- August 2012 Refresh(.zip file, 43 MB)
- July 2012 Refresh(.zip file, 44 MB)
- June 2012 Refresh (.zip file, 45 MB)
Design for the Environment (DfE)
|
About the ProgramEPA'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 Design for the Environment program applies stringent criteria for health and environmental safety in labeling the safest products. When consumers see the Design for the Environment (DfE) label on a product, they can be confident that the product is among the safest when compared with traditional products. |
Get the Data
Learn about the API - DfE 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 DfE data within the Envirofacts database. DfE only consists of one table, so the links below will retrieve all of the data within the Envirofacts database for the T_DESIGN_FOR_ENVIRONMENT table.- http://iaspub.epa.gov/enviro/efservice/t_design_for_environment/CSV - (Comma Separated Value format)
- http://iaspub.epa.gov/enviro/efservice/t_design_for_environment/JSON - (JavaScript Object Notation format)
- http://iaspub.epa.gov/enviro/efservice/t_design_for_environment/EXCEL - (Microsoft Excel format)
- http://iaspub.epa.gov/enviro/efservice/t_design_for_environment/XML - (Extensible Markup Language format)
- http://iaspub.epa.gov/enviro/efservice/t_design_for_environment_esp/CSV - (Comma Separated Value format)
- http://iaspub.epa.gov/enviro/efservice/t_design_for_environment_esp/JSON - (JavaScript Object Notation format)
- http://iaspub.epa.gov/enviro/efservice/t_design_for_environment_esp/EXCEL - (Microsoft Excel format)
- http://iaspub.epa.gov/enviro/efservice/t_design_for_environment_esp/XML - (Extensible Markup Language format)
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. DfE only consists of one table, as defined below:
Table Name: T_DESIGN_FOR_ENVIRONMENT
Columns:
- PRODUCT - A DfE-labeled product that is made by a partner company.
- PARTNER - A company who has signed a partnership agreement with the DfE 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.
- SECTOR ID - A number representing the unique identifier for the product's sector.
- 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.
- PRODUCT ID - A number representing the unique identifier for a product.
Sample Data - When running the Envirofacts RESTful API you will retrieve data in various formats. An example of how the data appears is below.
| SECTOR_ID | CATEGORY | SECTOR | PARTNER | CITY | STATE | PARTNERSINCE | PRODUCT_ID | PRODUCT |
| 7 | Industrial/Institutional Product | All-Purpose Cleaners | Barnes Distribution | Cleveland | OH | Apr 2009 | 1085 | *Biodyne - Unscented |
| 7 | Industrial/Institutional Product | All-Purpose Cleaners | BCD Supply | Crest Hill | IL | Jun 2011 | 3132 | *Green Clean Enviro-Degreaser |
| 7 | Industrial/Institutional Product | All-Purpose Cleaners | Beaver Research Company | Portage | MI | Jan 2009 | 906 | *FOAM BLANC |