#FF0000

Newest Pesticide Product Registations SubRegistrations Transfers - Details about registered products,registrants, and active ingredients.

Using EPA PPIS files. New, Transferred, Subregistered pesticide product registrations, and much more. Complete AIs, as Sole or Combination.

About my site postings

My primary objectives are: (1) Summary information for new EPA federal, Sect. 3, registrations, and (2) summary information for new transfers of registrations.

Secondarily I will post about features of registered products and registrants.

My postings use EPA's PPIS (Pesticide Product Information System) 18 text data files (updated weekly, usually), imported into an Access database. Search results are converted to Excel format files for posting here.

Date in report file name. Date formatted as YYYYMMDD. Date is that of EPA's PPIS files I used to prepare the report.

Should you want more information about registered products or applications for product registration, consider subscibing to NPIRS or Knowtify. Or, learn to use EPA's text files and a database. FYI: I do not receive any compensation for these suggestions.

Alert. As of 14 October 2020 I will be posting for only these EPA assigned Product Types: Herbicide, Fungicide, Insecticide, Invertebraticide, Rodenticide.
Here is a list of EPA's 73 Product Types with my assignment for each Type. D = Delete/Don't use. Others ought be obvious. Disagree? Send me an emal.

End of my Postings New 2025_11_14

I am no longer updating this site.
Bruce McKay

New Pesticide Registration Approvals, Including Transfers and ME-TOO
- ME-TOO registrations are those flagged as such in EPA's Comprehensive APPRIL file about every Registration ever
- Link to APPRIL Home .
- _______________________________________________________________
- 2025_10_08 New 2025_10_08
- No additions to PPIS this week.
- 2025_09_24
- 2025_09_17
- 2025_09_10
- 2025_08_27
- 2025_08_20
- 2025_08_13
- 2025_08_06
Labels for New Pesticide Registration Approvals
- Links in the HTML file are to EPA's PPLS (Pesticide Product Label System).
- You will get a (PDF) Label or the site will tell you a label has not been posted.
- Or, Search by multiple criteria here
- _________________________________________________________
- 2025_10_08 New 2025_10_08
- 2025_09_24
- 2025_09_17
- 2025_09_10
- 2025_08_27
- 2025_08_20
- 2025_08_13
- 2025_08_06
Miscellaneous
- On occasion I will do Counts using Aggregate Company Name, rather than Company Number.
- Label Sites. Unless noted otherwise I use my . Site SubCategory names
- My Database. For postings below I use Microsoft's Access 2007.
- Field vs. Column. Relational databases use the name Field. I'll use the more common name, Column.
- Caution. EPA's PPIS files are never complete for all product information, nor are completely accurate for all product charactertics. Caveat lector!
TGAI MUP Registrations New 2025_09_15
- PPIS has 2626 TGAI (Technical Grade Active Ingredient) and MUP (Manufacturing Use Product) registrations.
- Incomplete information for 25 products.
- File TGAI MUP Products has 2626 rows with...
- Registrant, AI, Pct AI, product name, EPA Reg Nr.
- File TGAI MUP AI Count RegNrs has 815 rows with...
- AI, Count of RegNrs, Count of Registrants.
- File TGAI MUP Co Count RegNrs has 435 rows with...
- AI, Count of RegNrs, Count of unique AIs.
Using PPIS Site Qualifier New 2025_09_13
- 26388 of the 30654 PPIS Site Vocabulary entries have a Site Qualifier suffix.
- Site Qualifier is the parenthetical suffix following the Site's base name. These add information about the Site.
- In addition to site Name, Qualifiers are digits 6 and 7 of the 9 digit Site Code.
- Examples
- File PPIS Site Qualifier Examples has 3 rows...
- Site Code, Site Name, Site Code digits 67, my Short List Site Qualifier name.
- Qualifier Lists
- File PPIS Site Qualifier Full List has 1415 rows with...
- PPIS (parenthetical) Qualifier for Sites other than Ornamentals.
- File PPIS Site Qualifier Ornamentals List has 673 rows with...
- PPIS (parenthetical) Qualifier.
- File PPIS Site Qualifier Short List has 79 rows with...
- My shorthand name for Qualifiers, Site Code digits 67, Count of RegNrs for Sites.
Using PPIS Pest Qualifier New 2025_09_13
- 3523 of the 8798 PPIS Pest Vocabulary entries have a Pest Qualfier suffix.
- I have created separate files for each Pest Type (first letter of the Pest code).
- File PPIS Fungus Qualifier has 611 rows with Qualifier.
- File PPIS Plant Qualifier has 113 rows with Qualifier. Includes Pant Regulators.
- File PPIS Insect Qualifier has 32 rows with Qualifier.
- File PPIS Vertebrate Qualifier has 16 rows with Qualifier.
- File PPIS Disinfectant Qualifier has 63 rows with Qualifier.
Sites 1to4 Labels versus All Other New 2025_09_11
- My question. Do Registrants with a few products label differently from other Registrants.
- Of course individual Registrants might have Site preferences.
- My approach is to compare Percentages.
- The file below has Percentage of labels for Registrants as a Group, with Label Counts.
- Registrants with 1 or 2 or 3 or 4 labels versus all other Registrants.
- Label Site Code and Name, Percent of labels for each set of Registrants for each Site.
- Differences of course. Overall, however, I conclude industry consensus is fairly consistent.
Atticus Group Labels same ingredient as New 2025_09_05
- Atticus Group (Atticus and Avalaire) labels for whatever reason often add a parenthetical statement.
- ...same ingredient as...
- File Atticus same as has examples.
- Any error in copying the parenthetical statement is accidental.
Herbicide Site Categories and AIs New 2025_09_02
- The last time I will do 4 or 5 "...only" Site Category Groups.
- Now how many RegNrs for each Site Category Group.
- File Herbicide One Site Category CountRegNrs has 440 rows with...
- Label Site, Count of RegNrs for each "...only" Group.
- Next, a look at Active Ingredients
- Herbicide Common AIs Crop or Not Crop
- Most labels are multi Site Categories. E.g., Crop and Ornamental, Crop and Other.
- How are Active Ingredients used?
- "Crop and" means label must have Crop sites and may have other sites (only 24 RegNr are Crop only).
- "NotCrop" means label DOES NOT have a Crop site.
- File Herbicide CommonAI Crop NotCrop CntRegs has 721 rows with...
- Active Ingredient, Count of RegNrs for "Crop and" labels and "NotCrop" labels.
- Crop and labels >0 and Not Crop = 0: 2249
- Not Crop labels >0 and Crop and = 0: 1080
Label Weeds Active Ingredients New 2025_08_30
- In file(s) below "...only" means no label site other than for the Site Category Group.
- Crop Other only means both Crop and Other sites.
- File Weed Crops Others Count RegNrs has 1559 rows with...
- Weed Code and Name, Count of RegNrs for: Crop only, Other only, Crop Other only, Total of RegNrs for Weed,
- Number of unique Active Ingredients on the Weed label; Rank number for the weed.
- File Weed Emerged Top 10 List is cheat sheet for your use, just in case.
- File Weeds AI Top 10 YorN has 231 rows with...
- Active Ingredient, labels for all Top and/or Top 6-10 Emerged Weeds>.
- The 231 AIs are from all 721 Herbicide AIs. There 80 where Top 5 and Top 6-10 are Y.
- Factoids. 3329 RegNr for Emerged Weed Herbicide products. 305246 rows for Herbicide RegNr and RegNr Label Weed name.
Crop Label Weeds New 2025_08_25
- Is it possible to find Weed(s) specific to Crops using PPIS files?
- My answer is no, allowing for a few exceptions.
- This post is for Weed RegNr data. Later I will look at AIs and Label Sites.
- Reminders. LT means Lawn and Turf. "...only" means no Sites other than in the named Category Group.
- Oth/Other means Not Crop, Not LT, Not Ornamentals, Not Forestry.
- File Crop Emerged Weeds CountRegNr has 1407 rows with...
- Emerged label Weed, Count of RegNrs for Crop only, Crop LT only, Crop Oth only, Oth only.
- File Crop PreEmergent Weeds CountRegNr has 626 rows with...
- Emerged label Weed, Count of RegNrs for Crop only, Crop LT only, Crop Oth only, Oth only.
EndUse Products Where Used Data New 2025_08_19
- If needed see "EndUse Products Where Used Introduction" post below.
- EndUse Producs
- File EndUse Products 11136 has 11136 rows with...
- Information for all EndUse products registered as of 06 August 2025.
- Site Category Groups
- File EndUse Products SiteCategoryGroup has 11136 rows with...
- Product, in which Site Category Group(s)does the label list one or more Sites, Registrant.
- Crop only products = 1714; LT/LawnTurf only products = 573; Orn/Ornamental only products = 129; Forest only products = 3; Oth/Other only products = 2495.
- Products in a single Group comprise 44 percent of the total.
- Individual Active Ingredients
- File EndUse Each AI Group isY has 16842 rows with...
- Each AI in products, Site Category Group(s), Pct AI, AIs in product, Pct AI for the product..
- Using Individual AI Information
- An example for using multiple files. Choose an AI of interest, find details. Here 2 AIs.
- File EndUse Products Quinclorac Sulfentrazone has 106 rows with...
- Product AIs, Site Category Group is Y, AIs in product, Registrant of label sites.
EndUse Products Where Used Introduction New 2025_08_12
- One method to condense EndUse product label sites is using 5 Site Category Groups.
- Site Category is the first two digits of EPA's 9-digit Site Code.
- File Site Categories and Groups has 73 rows with...
- Epa's Category Code, Category name, Alt Group name, Category Group name.
- FYI. I will be using Alt Group Name in future posts to save screen space.
- Examples using RegNr Group assignments.
- File Site Groups Example has 97 rows with...
- RegNrs for 2 Registrants, product has sites in Group (is Y).
- File Syngenta AIs RegNr LT Group only has 24 rows with...
- Syngenta AIs for RegNr with Sites in the LT (LawnTurf) Group only .
New Registrations 2024- 2025 New 2025_08_09
- File Registrations 2024-2025 has 248 rows with...
- Registrant, Product Active Ingredient, EPA RegNr, if a Transfer, EPA Approval date.
- CT = 11 means Transfer from another Registrant.
- Easy to pick out postpatent company such as Atticus and Sharda.
- Empty cell means nothing in EPA's PPIS file, yet.
TGAI MUP Products New 2025_08_07
- TGAI/Technical, Technical Grade Active Ingredient; MUP/Formulation Intermediate/Manufacturing Use Product; EndUse.
- EPA has a Code for these. Unfortunely there are 3074 RegNrs for which there is no Code. Caution. I do my best using APPRIL and product name.
- This file TGAI MUP Syngenta Products as an example, has 116 rows with...
- Syngenta's product name, EPA's Formulation Code, EPA's Code Nsme. Missing assignments. Last row is an incorrect Code (EndUse).
- File TGAI MUP Products has 2587 rows with...
- Registrant and Product information.
- File TGAI MUP Common AIs has 811 rows with...
- Active Ingredient, Number of RegNrs, Number of Registrants.
- File TGAI MUP Co Count AIs has 428 rows with...
- Registrants, Counts for TGAI MUP products.
___________________________________________________________________

PPIS Basic Informatiom. My version

Many of my Access database Queries, and yours?, depend on Company Number/Name and/or label stle EPA Reg. Nr. Company info is in the Address file.
However, CoNr and Name are not in any other data file. Label style EPA Reg Nr is nowhere in PPIS.
I have revised my Basic Information Access database table to take care of these deficiencies.
This one row file Basic Info is an example. Extract from the 11 digit RegNr the CoNr and Product Number, then...
Combine CoNr and Product Number as label style EPA Reg Nr.

PPIS. Importing Fixed Width/Fixed Length Files

This tedious section just-in-case you are considering using PPIS.
Fixed Width/Fixed Length (FW/FL) files are another variation of plain text (.txt).
Open with any program that understands .txt format.
FW/FL files are for use by a Database, or Spreadsheet program (yes, Excel). They look odd because...
No column names in the first row, and data in each row is scrunched without column separation.
I use Access 2007 database. Other databases or newer Access versions will look different, but there is ONE key idea.
Up to you to define columns and assign names.
I have an Access reusable Template database. Does Importing, and other stuff, with one or two clicks (1-5 seconds to do it).
Starting import, what the file looks like. Example is PPIS product.txt (Basic Registration Information).
Here is the Access preview. Scrunched rows.
Access wants to know "Where do Columns begin and end?" PPIS give you the information.
On the PPIS page follow the PPIS and Information and Report Samples link.
Click on the PPIS introduction-file formats-data dictionary link. Multipage pdf file explanations.
Here is the (partial) explanation page for product.txt. Scroll down.
Ignore the Dec column. Regardless of EPA's data type, I import everthing as Text. Can be changed later.
You need to use only that 1 starts the first column and where every column ends.
Access asks "where are the columns?"
Using PPIS instructions I put in line breaks. Only a few are shown here.
I told Access at start of the import "Append/stuff the file contents into my empty All Products table."
Here is the ready-to-use table
Any questions? Contact me. Have fun with PPIS.

EPA's Pesticide Product Information System Files

PPIS files are split between Data and Vocabulary.
Vocabulary (Lookup Dictionary) files are used to find the name associated with an EPA Code.
FYI: I've chosen selections from very long files. Sites on Labels, e.g., is 1,000,000+ rows.
Data Files:
Basic Registration Information
Percentage AIs.
Alternate Brand Name.
Pests on Product Label.
Sites on Product Label.
Product Transfers.
Product Use Type.
Distributor Product.
Registrant Information.
Registrant's Agent.
Vocabulary Files:
Cancel/Transfer Reason.
AIs/Chemicals.
Pest Name.
Product Formulation Type.
EPA Product Manager.
Product Use Type.
Site Name.

Explanations

Back to Miscellaneous

Aggregate Company Name.

In the following file each Aggregate Name shares at least one of:
Company Name or Division; HQ address; Registration Personnel.
Aggregate Company Name.
Have I errored by omission or commission? Let me know (my email link bottome of this page).

Back to Miscellaneous

Label Sites. Deconstructing EPA's Site Codes

EPA's 9 digit Site Codes can be taken apart and Names assigned to each piece. Pieces are: Digits 1-2, 1-5, 6-7. Digits 8-9 have no inherent meaning.
Below are Site Code Pieces and the Name for item within the piece.
SiteCategory (73). SubCategories (3376). What/Where (79). Note: SubCategory names are closest to names used on product labels.

22968 Sites_ EPA Complete Name

Complete Site Names.

Site SubCategory Name.

Crop, Ornamental, Forestry, SubCategory Sites also have Category Name.
SubCategory is the first five digits of EPA's nine digit complete Site Code..
SubCategory Name and Code.

Product Type. Introduction

ProductType

PestType

Comment, Suggestion, Criticism? Send me an email: Bruce McKay
Just in case. My email address is: brucemckay578@gmail.com

In case you're interested in such stuff: I construct my site using CoffeeCup HTML Editor. Host for my site is Bluehost.

End of my Postings New 2025_11_14

I am no longer updating this site.

Bruce McKay

New Pesticide Registration Approvals, Including Transfers and ME-TOO

Labels for New Pesticide Registration Approvals

Miscellaneous

Referencing Registrants

TGAI MUP Registrations New 2025_09_15

Using PPIS Site Qualifier New 2025_09_13

Using PPIS Pest Qualifier New 2025_09_13

Sites 1to4 Labels versus All Other New 2025_09_11

Atticus Group Labels same ingredient as New 2025_09_05

Herbicide Site Categories and AIs New 2025_09_02

Label Weeds Active Ingredients New 2025_08_30

Crop Label Weeds New 2025_08_25

EndUse Products Where Used Data New 2025_08_19

EndUse Products Where Used Introduction New 2025_08_12

New Registrations 2024- 2025 New 2025_08_09

TGAI MUP Products New 2025_08_07