#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.
New Pesticide Registration Approvals, Including Transfers and ME-TOO
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_03_26 New 2025_03_26
- 2025_03_20
- 2025_02_26
- 2025_02_19
- 2025_02_05
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
- Caution. EPA's PPIS files are never complete for all product information, nor are completely accurate for all product charactertics. Caveat lector!
1058 Registrants_Count Registrations New 2025_03_31
PPIS Basic Informatiom. My version New 2025_02_22
- 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
Back to Miscellaneous
- 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
- 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
EPA's complete name for Sites. Includes every parenthetical Site Qualfier term.
- Complete Site Names.
- 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
EPA assigns a Type, or multiple Types, to each registered product. Types are indicative of the pest being targeted.
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.
©Original Content and formatting, copyrighted by Bruce McKay. Please ask for permissioon before reposting.