This index page is arranged in sections: Permanent and Transitory items.
- Permanent Items
- Pesticide Statistics, Trends, Miscellaneous
- Access: Visual Tutorials
[Finding Pending Registrations Applications]
Look for the 
and 
flags to find recent updates or additions.
Pesticides Regulatory Authorities
Australia.
Canada. (Product search page.)
United Kingdom. {Also has simplest place to find European Union links.}
United States of America.
U.S. Federal and State Pesticide Product Registrations. NPIRS at Purdue University offers free-of-charge searches. Links tab leads to useful sites for more information.
Compendium of Pesticide Common Names
The definitive source for names, structures, use types, and more. Courtesy of Alan Wood.
U.S. Pesticide Product Labels
Greenbook. Industry sponsored searchable site. Also has news about the industry.
US-EPA. Environmental Protection Agrncy's searchable site.
Pesticide Registration/Regulatory Affairs
Consultants
Information, supplied by the principals, about
individuals and companies conducting registration and regulatory affairs
consulting services on a contract basis.
Pesticide Formulation Devlopment Labs &
Consultants
Information about individuals and facilities
offering their services for development and/or evaluation of pesticide
product formulations (added: Focus Formulation and Consulting).
Pesticide Process Chemistry/Engineering.
Consultants
Need help with pesticide AI production, or related?
Here are consultants I've found. Know of others(?), send them my way for a
free listing.
Pesticide Chemical Usage and Crop Statistics
Links to federal and state sites containing reports about
amounts of pesticides used in the United States, and about other crop
statistics.
Pesticide Contract Formulators/Packagers On The
WWW
Companies I've found with Internet sites.
Resistance Action Committees
RACs do more than track
developing resistance to insecticides, herbicides, and fungicides. One of
their services is classification of pesticidal actives by chemical type and
mode of action. {In the event you're worried: RACs are sponsored and
promoted by major pesticide registrants.}
Herbicides: Regs/Co-(AI, Site, Pest)
Using PPIS files of 23 January 2012.
Herbicides. Means (1) Any registration assigned at least one of EPA-OPP's Product Type Codes 34, 39, 40. (2) Company Number has at least 2 Herbicide
product registrations (deletes 96 of 3940 products and 96 of 287 Company Numbers).
Regs/Co-AI. Excel file h_regai.xls has: Registrant, How many Regs for the named Individual AI, Number of Herbicide Regs for
the CoNr, Percentage of the CoNr Regs for the named AI. (1486 rows)
Individual AI. Single AIs as Regs/Registrants, as example extracts: 24d_2ehe.xls (2,4-D, 2-Ethylhexyl ester).
prodiam.xls (Prodiamine).
Regs/Co-Pest. Zip file h_pest.zip extracts to the Delimited text file h_pest.txt. Has Registrant, Number of Products for the
named Pest. (Text file has 57582 rows).
Individual Pests. Extraction examples. pennsmwd.xls (Pennsylvania Smartweed). barn_pre.xls
(Barnyardgrass Preemergence).
Regs/Co-Site. Zip file h_site.zip extracts to the Delimited text filer h_site.txt. As for Pests, same information.
(Text file has 154169 rows).
Individual Sites. Extraction examples. barley.xls (Barley). golfcors.xls (Golf Course).
Reminder. EPA-OPP is the ONLY source for registered (now or previously) products. NPIRS gets their version of PPIS directly from EPA-OPP. I and all others use the web-posted PPIS files...(January 30)
New (Sub)Registration Approvals: 23 January 2012
Using PPIS files of 23 January.
Original Registrations. Excel file appr1202.xls has: AIs and Pcts, Registrant, Product Name, EPA Reg. No.
Transferred Registrations. None added in the PPIS file set.
SubRegistrations. Excel file sub_1202.xls has: AIs and Pct, To Whom, From Whom, Product Name, EPA Reg. No...(January 25)
HERBICIDE TERRESTRIAL. Regs/Weed The Industry. Jan. 2012 vs. Jan 2008
Using PPIS files of Jan. 2012 and of Jan. 2008.
Excel file ht_1208.xls has (for EPA-OPP Product Type HT = Code 39): Regs/Weed as of Jan. 2012; Change (+/-) in Regs. 2012 - 2008;
Percentage of All HT Regs/Weed as of Jan. 2012; Percentage change Jan. 2012 vs. Jan. 2008. (Note: More Weeds than those here. Others have too few Regs to be
important in this context).
Note: although some large changes (mostly negative) in Regs/Weed, the change is over 4 years, and I suspect is because of changes in a few AIs (e.g.,
2,4-D's and/or Dicamba's)...(January 23)
New TGAI-MUP Registrations: 2000 - 2011
Using PPIS files of 09 January 2012.
Excel file tgmp0011.xls has for each year: number of TGAI and MUP registrations in the year. Also graph of Regs/Year...(January 19)
New Registrations: 1 Year Summaries
Using PPIS files of 09 January 2012. New, original (NOT Transferred) registrations since 01 December 2010.
Each Active. Excel file 1year_01.xls has: Each AI, Registrant, EPA Reg. No.
All AIs. Excel file 1year_02.xls has: Registrant, All AIs and Pct, EPA Reg. No...(January 19)
Combinations New To Registrants: 09 January 2012
Using PPIS files of 09 January 2012 and 05 December 2011.
Excel file comb1201.xls has: Registrant, Combination, EPA Reg. No...(January 16)
Actives New To Registrants: 09 January 2012
Using PPIS files of 09 January 2012 and 05 December 2011.
Excel file ais_1201.xls has: AI new to the registrant (not in 05 Dec. PPIS), Registrant, Product Name, EPA Reg. No...(January 16)
New SubRegistrations: All Product Types
Excel file asub1209.xls has summary information for all product types...(January 13)
Selected New SubRegistrations: 09 January 2012
Using PPIS files of 09 January.
Selection. Deleting such as Disinfectans and Sanitizers, leaving Herbicides, Insecticides, Fungicides.
Excel file sub_1209.xls has: AIs and Pct, SubTo, SubFrom, Sub Product Name, EPA Reg. No...(January 12)
Herbicides: Labels/Registrants: Jan. 2012 vs. Jan. 2010
Using PPIS files of January 2012 and of January 2010.
Herbicide means a product Typed by EPA-OPP as at least one of: HERBICIDE, HERBICIDE AQUATIC, HERBICIDE TERRESTRIAL.
Excel file h12vs10.xls has: Difference (+/-) in Herbicide registrations for each of the 251 current herbicide registrants
...(January 11)
New Registration Approvals: 09 January 2012
Using PPIS files of 09 January.
Original Registrations. Excel file appr1201.xls has: AIs and Pcts, Registrant, Product Name, EPA Reg. No.
Transferred Registrations. Excel file xfer1201.xls has information as for above...(January 11)
Product Use Types: Regs-AIs/Registrant
Using PPIS files of 5 December.
Excel file type_cnt.xls has: Count of Registrations and Count of (unique) Active Ingredients for each Registrant for each of EPA-OPP's 68
Product Use Types, plus for TGAI and MUP products.
Note: EPA-OPP assigns 1 - 6 Use Types to products. Note: Some Registrants have more than 1 Registration for an AI as TGAI or MUP.
Excel file is sorted: Use Type (ascending), Count of Regs (descending), Registrant Name (ascending)...(December 26)
DuPont: Reg/Active
Excel file dupont_1.xls has Regs/each Active for DuPont (CoNr 352)...(December 22)
12 Dec. New Registrations Approvals: Access Ready-to-Run
Note: For you, if interested, to use Access to find New Approvals in PPIS of 12 Dec. which are NOT in PPIS of 05 Dec.
Note: Only Original Approvals, NO Transfers.
Note: 05 Dec Active Regs Table is a permanent part of this database. Just because of how to post for you. In practice 05 Dec file would be only a
temporary Attachment/Link, saving clutter in the 12 Dec. database file.
Note: In a week or 2, depending on EPA-OPP's web postings, I'll have my usual Excel file postings, using a more recent PPIS file set.
Ready-to-Run Access Finder. Zip file dec11_12.zip extracts to the Access 2002 database file dec11_12.mdb. Just Open this file, go to
Queries and double-click the only Query. Access will do a Make Table. Contains Registrant CoNr, Co Name, Product Name, RegNr, EPA Reg No, Approval date.
Note: Access 2007 (and 2010?): Open the mdb file then "Save As" in 2007 format, SAVING TO A TRUSTED LOCATION! (convenience but doing what Microsoft wants)
...(December 16)
Registration Approvals: 6 Month Summary
PPIS files of 5 December 2011. Registration approvals since 1 May 2011.
Excel file summ6mon.xls has: CoNr/Co Name, AI Name/AI Pct, Product Name, Form Type (1 = TGAI, 2 = MUP, Other number = End-Use,
blank = unknown), RegNr, Approval Date...(December 14)
Access (All Versions): Visual Tutorials
Finding Pending Registration Applications. Let NPIRS-PDMS Do The Initial Drudge Work
The Idea. NPIRS-PDMS has a clicky-clicky method to find EPA Reg. No. for Pending Registration Applications. Rather than clicking to Run many Access Queries
(I suspect this can be frightening to those not conversant with Access) to find, let the NPIRS database do that initial work.
The Trade-Off. In return for having NPIRS do the drudge work you (your company) will pay NPIRS for you (your company) to find out "What is in the Registration
Applications?". Cost effectiveness? You (your company) must decide. Since I know of no one offering the finding service you're stuck.
NPIRS-PDMS: Date Range Searching Application Submissions. NPIRS-PDMS is not, can't possibly be, "up to the minute" for Submissions. Today's submission (for anything)
might appear in PDMS with a Received-by-EPA date 2 weeks or 2 months ago. Safety Factor. Searches ought, in my experience, cover old ground (dates already searched).
You'll have to decide on a comfort factor: What is my Company willing to miss. My Safety Factor is 4 months prior to the date of the NPIRS-PDMS current post. Example:
Retrive Pending EPA Reg. No. in the 1 August 2011 NPIRS-PDMS posting, searching for Submissions from 1 April to 1 August. Wait until 1 September posting, or nearest,
then search for 1 May to 1 September submissions with a Pending EPA Reg. No.
Compare EPA Reg. No. from the 2 Date Range searches to find NEW in the 1 September posting.
Step 1. NPIRS-PDMS. Finding EPA Reg. No. For Pending Registrations
NPIRS-PDMS search page:
1. Option #14: Submission Dates. Choose your beginning and final dates. Then after NPIRS returns "Found this many".
2. Option P (Pending Registrations will be highlighted). NPIRS has returned How Many of the Submittal Documents contain a Pending EPA Reg. No.
Clicking on Option P brings up a list: Number of Citations and the Pending EPA Reg. No. {Note: The number of Pending citations will be MUCH FEWER than all the citations.}
Save The Pending EPA Reg. No. List. Your browser (right mouse click): Save Page As/Save As. Choose to save to your hard drive as HTM/HTML format.
Next section,WHY save as HTML/HTM? NPIRS format of the list will only be easy to use in HTM/HTML format (until of course NPIRS changes the format!).
{NOTE: If your search returns more than 5000 citations the Option P WILL NOT be available due to an NPIRS retriction. Narrow your range of Submission Dates.}
Word and Access. Finding Newest Pending EPA Reg. No.
Why Save NPIRS-PDMS List As HTM/HTML? Simple, good reason:
i. The NPIRS-PDMS list saved in Text (*.txt format) and Opened in Word. snag_01.pdf. Ugly, inscrutable? Mostly.
ii. The NPIRS-PDMS list saved in HTM/HTML (*.htm) format), and Opened in Word. snag_02.pdf. Isn't that neater?
iii. Why The HTM/HTML File Format. Only, I expect, for those interested in details. Your browser. View Page Source, or as I do, your HTML editor.
snag_03.pdf. Yah-de-yah. See the line above Date Search. Last is "pre" between angle brackets. An Instruction to your browser: "Show the following
Exactly as written". Way down at the bottom is "/pre", telling your browser to move on. ANYWAY, you need not be concerned with
details of this Interlude, other than to know: SAVE AS HTM/HTML. {snag... is shorthand for screen capture using the SNAGIT program.}
Formatting NPIRS-PDMS Pending HTM/HTML File With Word (trivial!!)
Open the HTM/HTML file. I've clicked on Word's paragraph symbol, just because.
Delete Before The List Begins. Just the usual highlighting/blocking to select What-to-Delete.
Deleted. Need A Push. Line 1 beginning spaces are gone. Hit the Space Bar to realign.
Realigned.
Block End-of-File. Then do a Delete. Left is only the list of Citations and Pending EPA Reg No.
Save As Text (*.txt). Access importing (and Excel should you wish) uses, in my examples, a Text file (lowest common denominator
understood by all computer programs).
Access Database. RTU Example and Infinitely Reusable
Zip files: pend2002.zip, extracts to the Access 2002 database pendtemp.mdb. pend2007.zip extracts to the Access
2007 database pend2007.accdb.
Later Access versions. Open pend2002 or pend2007 with your version. After looking/trying out Save As your Access version.
Importing a New Pending Set. You will Append your new set to the Pending_New Dump table. If you're not familiar with Importing/Appending ask me How-To.
For my ready-to-use example I've done the Importing. Database has an Import Specification (Spec) for the Fixed-width text file. Hardly needed as there are only
2 fields in the NPIRS-PDMS file.
Ready-to-Use Example. When NPIRS updated PDMS on 1 August 2011 I asked for Pending EPA Reg. No. with submissions from 1 April 2011 to 1 August 2011. When NPIRS
updated PDMS on 15 August 2011 I asked for Pending EPA Reg. No. with submissions from 1 April 2011 to 15 August 2011. I kept the 1 April start date only for simplicity.
Choose your range. Note that if the All Citations returned are more than 5000 NPIRS will not let you ask for Pending.
In the Example and Infinitely Reusable Database. Below are screen shots. In brief: (i) Table of Known Pending EPA Reg. No. (here these are from my 1 August
dump). (ii) Table of New Dump EPA Reg. No. Here they're from my 15 August search. (iii) 3 Queries, ready-to-use. 1st finds Newest Pending EPA Reg. No. 2nd and 3rd are
to clean up the database so its ready for your next New Dump.
Finding New Pending EPA Reg. No.
pend_008.pdf is the database screen showing Tables.
pend_009.pdf shows the entries in the Known EPA Reg. No. table. I.e., these which have been found in a previous search. Used for
eliminating old, previously found, EPA Reg. No.
pend_010.pdf shows the entries in the New Dump EPA Reg. No. table. Notice that Known and New look the same. 2 fields: Citation Count and
EPA Reg. No. Nothing tricky.
pend_011.pdf shows the 3 Queries you'll be using.
pend_012.pdf shows what happens when you Run the 1st Query. Access has found Newest Pending EPA Reg. No. Since there is an existing Table
(see again the Tables screen shot) Access asks "Delete the existing one before Making a new one?" Fine, yes. Old one is of no longer of any interest.
pend_013.pdf. Access found newest Pendings and made you a Table. Alas for this example the number of New Pendings is pitifully
small. On average searches separated by one month will return more.
What Is In Pendings?. Go back into NPIRS-PDMS. Do a Registration Number search, using the Newest Pending EPA Reg. No., and let NPIRS give you a nicely formatted
report.
pend_014.pdf. When you do another search using an updated New Dump set you don't want to see Known EPA Reg. No. (well you might for
your own reason but that is up to you). This Query appends the Newest EPA Reg. No. to the Table of Known EPA Reg. No. Known is now updated, and presumable up-to-date.
pend_015.pdf. The next time you want to find (Management is screaming/begging for) Newest Pending submission you DON'T want the New
Dump table cluttered with old Citation Counts and EPA Reg. No. This, 3rd, Query deletes all the entries in the New Dump table. It now sits (empty) there waiting for YOU to give
it a new data set.
Who Can Find Newest Pending Submissions? the pend2002/pend2007 database is even simpler than most others. It can be treated as a Black Box: Import/Get entries for
New Dump, then click on Queries, in order (qry01, qry02, qry_03). Look at Newest then go ask NPIRS-PDMS "What is in these?" Any moderately competent Secretary or
Technician or Intern or... can do it with no problem. Happy Hunting!!!
Reusing the Access Database. When you're ready to use the database to FIND NEW PENDING on your own... Run (double-click) qry03. This Query deletes entries in the Pending_New Dump table, so it is ready to receive a new set of entries.
For further information, or to discuss a specific project, contact Bruce
McKay:
e-mail your request to bmckay@ix.netcom.com (that's
bmckay@ix.netcom.com).
All original materials are copyright © 1996 - 2011 by Bruce M. McKay, and all rights are reserved.
The URL for this page is http://www.bmckay.com