We've made some changes to EPA.gov. If the information you are looking for is not here, you may be able to find it on the EPA Web Archive or the January 19, 2017 Web Snapshot.

Pesticide Product Label System (PPLS) Application Program Interface (API)

On this page:

Pesticide Product Label System Application Program Interface

Pesticide Product Label System (PPLS) provides a single point of access to U.S. EPA environmental data contained in the U.S. EPA databases. Interested parties from state and local governments, EPA, or federal agencies, or individuals can search for information about a pesticide product that may help or affect human, health and environment via Application Program Interface (API). 

Top of Page

Data Service API

PPLS has developed a RESTful data service API to all of internal data holding. This functionality provides a user of PPLS with the ability to query any data through the use of a URL by EPA Registration Number. The default output is in JSON (JavaScript Object Notation). The database is being updated every 12 hours (noon and midnight EDT).

Top of Page

Constructing a Search

To retrieve pesticide product information, users create a URL with a specific set of parameter. This is done by creating a string using the following format:

To search by EPA Registration Number:

https://ofmpub.epa.gov/apex/pesticides/ppls/[Company Number-Product Number]

  • COMPANY_NUMBER = six (6) digit company number part of registration number.
  • PRODUCT_NUMBER = five (5) digit product number part of registration number.

Example: https://ofmpub.epa.gov/apex/pesticides/ppls/66551-1

To Search by Product Name:

https://ofmpub.epa.gov/apex/pesticides/pplstxt/[Product_Name]

  • PRODUCT_NAME = Name of product, must be spelled correctly and it’s not case sensitive.

Example: https://ofmpub.epa.gov/apex/pesticides/pplstxt/RAID CWR BAIT STATIONS

To Search by Distributor Product Number:

https://ofmpub.epa.gov/pesticides/ppldist/[Company_Number-Product_Number-Distributor_Number]

  • COMPANY_NUMBER = six (6) digit company number part of registration number.
  • PRODUCT_NUMBER = five (5) digit product number part of registration number.
  • DISTRIBUTOR_NUMBER = five (5) digit distributor number part of registration number.

Example: https://ofmpub.epa.gov/apex/pesticides/pplsdist/67702-6-11204

Top of Page

Working with the Output

The result set is JSON that can be ported into an application or used as part of a Web mash-up. This is an example of what the output looks like with a return of pesticide product information from the PPLS database:

Element Name Description Data Type
EPAREGNO EPA Registration Number VARCHAR(2)
PRODUCTNAME Product Name VARCHAR(2)
PRODUCT_STATUS Current Status: Pending, Active, or Cancelled VARCHAR(2)
PRODUCT_STATUS_DATE Product Status Date (Month Day, Year) Date
COMPANYINFO (NODE)
NAME Company Name VARCHAR(2)
CONTACT_PERSON Company Contact Person VARCHAR(2)
DIVISION_NAME Company Division Name VARCHAR(2)
PHONE Company Phone Number VARCHAR(2)
FAX Company Fax Number VARCHAR(2)
EMAIL Company Email Address VARCHAR(2)
STREET Company Street Address VARCHAR(2)
PO_BOX Company P.O. Box VARCHAR(2)
CITY Company City Name VARCHAR(2)
STATE Company State VARCHAR(2)
ZIP_CODE Company Zip Code VARCHAR(2)
COMPANYAGENTINFO (NODE)
NAME Agent Name VARCHAR(2)
CONTACT_PERSON Agent Contact Person VARCHAR(2)
PHONE Agent Phone Number VARCHAR(2)
FAX Agent Fax Number VARCHAR(2)
EMAIL Agent Email Address VARCHAR(2)
STREET Agent Street Address VARCHAR(2)
PO_BOX Agent P.O. Box VARCHAR(2)
CITY Agent City Name VARCHAR(2)
STATE Agent State VARCHAR(2)
ZIP_CODE Agent Zip Code VARCHAR(2)
SIGNAL_WORD Signal word: Danger, Warning, Caution, or No Signal Word VARCHAR(2)
RUP_YN Restricted Use (Yes/No) VARCHAR(2)
FORMULATIONS (NODE)
FORMULATION Physical Form VARCHAR(2)
ACTIVE_INGREDIENTS (NODE)
PC_CODE EPA assigned pesticde chemical code VARCHAR(2)
ACTIVE_ING Active Ingredient VARCHAR(2)
CAS_NUMBER EPA assigned CAS Number VARCHAR(2)
ACTIVE_ING_PERCENT Active Ingredient percentage appearing in the pesticide product formulation VARCHAR(2)
INACTIVE_BRAND_NAMES (NODE)
INACTIVE_BRAND_NAME List inactive brand name associated with this product VARCHAR(2)
PDFFILES (NODE)
PDFFILE List of PDF files for each product VARCHAR(2)
PDFFILE_ACCEPTED_DATE Accepted Date (Month Day, Year) Date
ALTBRANDNAMES (NODE)
ALTBRANDNAME Product Alternative brand Name VARCHAR(2)
SITES (NODE)
SITE List site associated with a pesticide product VARCHAR(2)
PESTS
PEST List pest associate with a pesticide product VARCHAR(2)
TYPES(NODE)    
TYPE List of Pesticide Type VARCHAR(2)
EPADISTNO EPA Distributor Product Number VARCHAR(2)
SEC3RINUM Section 3 Registration Number of the Distributor product VARCHAR(2)
DISTRIBUTOR _STATUS Current Status: Pending, Active, or Cancelled VARCHAR(2)
DISTRIBUTOR_STATUS_DATE Status Date (Month Day, Year) DATE

Top of Page

For Assistance or Questions

If you have any questions or need further assistance, please contact Dina Castellon (castellon.dina@epa.gov)

Top of Page