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

#FF0000

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.

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 .
_______________________________________________________________
2024_12_16 New 2024_12_16
2024_11_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
_________________________________________________________
2024_12_16 New 2024_12_16
2024_11_06

California's Pesticide Products Updated 2024_10_31

CDPR Product/Label site for downloadable products files is here.
CDPR site for online product searches is here.
CDPR site with links to many pesticide information sites is here.
CDPR All Products Registrations
FYI. I DO NOT include in my reports: Disinfectants and related; SubRegistrations; Adjuvants.
All CDPR registrations as of this date New 2024_10_31
Newest registrations will be added occasionally.
Count for Registrants of All CDPR registrations as of this date ? New 2024_10_31

Miscellaneous

Referencing Registrants

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

Herbicde Active Ingredients New 2024_10_27

FYI. EPA does seem to incorrectly assign Product Types for some products.
I have deleted some of the obvious errors. You will find others to ignore.
File Herbicide AIs has each AI, then count of registrations for each AI.
Counts are for sole AI products and each of 2-7 AI combinations.
Hint. There are no Herbicide products with 6 AIs. Curiosity?

Agents for Registrants. Two Views New 2024_10_25

FYI. Because of how Registrants and Agents are named in PPIS files not everything is in exact order.
File Registrant-Agent lists Registrant then Agent.
File Agent-Registrant lists Agent then Registrant.

APPRIL. Crop Label Sites New 2024_10_22

EPA's APPRIL data file, unlike PPIS, puts Label Sites into one cell.
While I selectd (from PPIS) products labelled for crops, products will have non-crop sites on the labels.
Rather than indiviual labels I have summarized, counting labels for similar sites. Shortens the longer list.
File APPRIL Crop Sites

PPIS. 14458 Active Registrations New 2024_10_22

All products in PPIS with an active registration as of this PPIS posting date.
36 products have incomplete information in PPIS, and in APPRIL.
File Products_14458 has my usual information plus ApprovalDate.
file Count AI has count of registrations for product AIs.
File Count Co has count of registrations for each registrant. Counts are by CoNe

PPIS. Excel Pivot Table? New 2024_10_15

My knowledge of Excel is limited to "Access, export this results Table as an Excel Spreadsheet".
Access is a, nominally, Relational Database. Excel Pivot Table seems to also make use of Relationships.
Relationship simply means: Data Tables have at least one item in common. Drag-Drop to connect/relate items.
What/how you can do in Excel I leave to you. Web has examples.
This screenshot FMC 2024 is an Access example of constructing a Query. Scroll down to see all.
Company Number is the common item.
Query tells Access: Products for any company whose name begins FMC and registered products in 2024. Sort dates New to Old.
Run the Query to get this result.
Aside. More than one data table? For useless fun I once constructed a Query using all 18 PPIS files.

PPIS. Active Ingredient Percentage New 2024_10_15

In a section below I mistakenly showed an incorrent example for Formulation. Now a correction.
This screenshot Formula is EPA's desciption of the file Formula.txt (Product Formulation).
In Access I convert this to a percentage by dividing by 10000, putting the result in a new field.
The new field is assigned the Single (Precision) data type. Single numbers can be up to 7 digits and are typically used for decimal numbers..
The result is percentage: 1.25
Each percentage for multi AI products goes in a separate row.
One of my Access Queries (macros) creates a new table with Reg Nr, PC Code, and the Sum of individual percentages in a product.

PPIS. Importing Fixed Width/Fixed Length Files New 2024_10_08

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 New 2024_07_15

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.