You can contact me with your questions or suggestions by sending an e-mail message.
This index page is arranged in sections: Permanent and Transitory items.
Look for the and flags to find recent updates or additions.
Pesticide Foreign Establishments
The file below is my compilation of Foreign Pesticide Establishments.
FYI and caution. I can guarantee my list is neither complete nor up to date. Also, there are duplicate entries because back when EPA used a 2 letter code for Country but later switched to a 3 letter code.
Excel file NotUSEst.xlsx. Should you not be familiar with How-To. Get from Google a link to FOIA Online, then, after choosing EPA as the Agency, begin guessing at approriate search term(s).
Hint. For much you want to add to your search term EPA-HQ and even better are EPA-HQ-2016 or EPA-HQ-2017. Elsewise Years back to 2012 will show up...(October 19)
Pests on Labels. Registrations/Registrant/Pest Type
Excel file Pest_Co.xlsx has Count of Registrations for each Registrant, and Total Registrations..
I've abbreviated Pest Type to save space. DO = Disinfectant Organism; F = Fungus; I = Invertebrate; ILS = Invertebrate Life Stage; N = Nematode P = Plant; PRE = Plant Preemergence; Reg = Plant Regulator; V = Vertebrate.
Total is NOT the sum of Registrations in each row. I separated parts of Invertebrate and Plant labels, for I hope clarity. This would result in double counting Registrations. My Total is Count of Registrations for Unique Values of CoNr - RegNr for each Registrant.
For Access database users as an FYI or just in case. I used the usual Access operations Table Design and Make Table. Generating the file above I used these Access built-in operations/functions (i.e., click on): Unique Value, Count, Builder, Update...(October 18)
Pests on Labels. Example: Using Product Approval Date
A stretch just in case for anyone doing a dayabase and PPIS. Example of combining a Pestxxx file and a PPIS file.
Question: Who has most recently registered a Sulfentrazone product for a Plant/Weed pest.
This screen shot Sulfen.jpg shows my Query. I don't bother to show the result.
Should you have a question about this, or any other Query with Access, just ask...(October 16)
Pests on Labels
I used PPIS files of 02 October 2017 for this post.
Format. Each file below has the same format:
EPA Reg. No. - CoNr - Co Name - Pest Name - PctAI - All_AI - EPA's pest code
Be patient. I and P files can took a while to load to your screen.
Disinfectant Organism. Excel file Pest_D.xlsx.
Fungus. Excel file Pest_F.xlsx.
Invertebrate, other than with Life Stage Qualifier. Excel file Pest_I.xlsx.
Invertebrate with Life Stage Qualifier. Excel file Pest_ILS.xlsx.
Nematode. Excel file Pest_N.xlsx.
Plant, other than PREEMERGENCE or REGULATOR. Excel file Pest_P.xlsx.
Plant, PREEMERGENCE. Excel file Pest_PRE.xlsx.
Plant, REGULATOR. Excel file Pest_REG.xlsx.
Vertebrate. Excel file Pest_V.xlsx...(October 16)
Weed Pests. (Mostly) Dicamba Combinations
My last posting on this topic. Using in a teeny, tiny, way for obvious to you results from my postings below. Again, merely a suggestion about using EPA's PPIS files.
Individual AIs. Excel file Comb_01.xlsx has for each AI in a Combination: How many Combinations, Registrations, Registrants.
Dicamba Acid or Salt are used in 115 Combinations. Remainder of this posting is about Dicambas.
Dicamba Combinations. Excel file Comb_02.xlsx has all the Dicamba Combinations.
AIs. Excel file Comb_03.xlsx has the individual AIs found in Dicamba Combinations.
Weeds on Dicamba Labels. Excel file Comb_04.xlsx has: How many Dicamba combinations for each of my (see below) 603 selected Weeds.
You don't need to look. The answer is 583 of the 603. Might not mean anything but... of the 20 No Label Weeds 19 are PREEMERGENCE. However, there are PREEMERGENCE Weeds on Dicamba labels.
HENBIT. I choose HENBIT as a most labeled Weed by Dicambas. Excel file Comb_05.xlsx has: Registrant and Dicamba Combination for label naming HENBIT. Note: There are 154 entries here while I showed above 115 Dicamba combinations. Obvious answer is that more than one Registrant registers the same Combination.
Henbit. Dicamba Combinations. Label Sites. Although EPA's PPIS files do not allow a direct association of label Pests and Sites, results can be suggestive. Excel file Comb_06.xlsx has: How many Dicamba product Registrations for HENBIT pest label Sites. Surely obvious to those who know/care that 84% of the Sites are Non-Crop (of course not obvious to me until I saw the results)...(October 15)
Weed Pests. AI Combinations. 2
In this posting I show the data I'll use later asking about Who/What. Database and PPIS users might get a suggestion about something to do with PPIS. Excel users might be interested in skimming my files.
Combinations. Excel file WeedComb.xlsx has: my Combination ID, Combinations, Count of Registrations, Registrants, label Weeds.
Each AI. Excel file Weed_AI.xlsx has: my Combination ID, my ID for each AI in the Combination, AI common name.
Weeds. For this exercise I selected 603 Weeds, those with 50 or more labels. Excel file Weed603.xlsx has: my Weed ID, EPA's pest code, Weed name, Count of Registrations, Registrants, Combinations, AIs in Combinations.
AI Trends. Excel file Weed93AI.xlsx has: my AI ID, AI common name, Count of Combinations registered in one or more of years 2017, 2016, 2015.
Database users will note that I can connect (relate) data types via my IDs (and product RegNr which I don't show here)...(October 9)
Caution. EPA's PPIS files do not ALWAYS correctly identify Technical Grade AIs.
TGAIs. Excel file TGAI_1.xlsx has the Who and What...(October 5)
EPA. New (Sub)Registration(s) Approvals: 2 October 2017
Added to PPIS files of 2 October.
Newest Registration(s) Approvals. Excel file APPR1714.xlsx has: AIs and Pcts, Registrant, Product Name, EPA Reg. No., link to PPLS for the product label. Note: If the link leads to No Label Found you will have to query PPLS later for the label.
Newest Transferred Registrations. Excel file XFER1714.xlsx.
Newest SubRegistrations. Excel file SUBS1714.xlsx...(October 3)
Weed Pests. AI Combinations. 1
The two files below are an introuction to a much larger set of postings.
I've chosen 603 Weeds for this exercise. Here I show some results for one Weed: HENBIT (currently with most Labels).
Short Version. Only 862 rows. Excel file HENBIT_1.xlsx is how I and EPA for PPIS would show:
Who and What for Registrants with Henbit on a label. Well, possible to compact a bit more.
Long Version. Using other database tables to convert IDs to names. (Non database users won't care HOW/WHAT; database users know HOW/WHAT).
Excel file HENBIT_2.xlsx has names of things.
Next posting(s) I'll make used of Weed, Combo, and Pest IDs for deeper looks...(October 1)
EPA Chemical Dictionary. New Entries
New entries in the PPIS file of 15 September 2017. PPISDICT.xlsx..(September 16)
EPA. New (Sub)Registration(s) Approvals: 15 September 2017
Added to PPIS files of 15 September.
Newest Registration(s) Approvals. Excel file APPR1713.xlsx has: AIs and Pcts, Registrant, Product Name, EPA Reg. No., link to PPLS for the product label. Note: If the link leads to No Label Found you will have to query PPLS later for the label.
Newest Transferred Registrations. Excel file XFER1713.xlsx.
Newest SubRegistrations. Excel file SUBS1713.xlsx...(September 16)
PPIS: All Companies
EPA has updated its company-full.txt PPIS file. Entries are for 2005 (last revision to PPIS file formats) to September 2016. There are now 84031 entries with information about entities doing something with pesticides which requires an EPA Company Number.
In case you have not used previous versions and want to import the fixed-width file into a database or spreadsheet, below are field names I use, starting position on each line for each field, and the field width (number of reserved spaces).
Co_NR: Start = 1, width = 6. Co_Name: Start =7, width =60. Co_Name2: Start = 67, width = 60. Co_Street: Start = 127, width = 50. Co_City: Start = 177, width = 50. Co_State: Start = 27, width = 2. Co_Zip: Start = 229, width = 5. Co_Contact: Starrt = 234, width = 40. Co_Phone: Start = 274, width =10...(October 6)
Foreign Pesticide Production Establishments. Y2014
Excel file SSTS2014.xlsx is my extract from FOIA requesr EPA-HQ-2015-006206 for reporting year 2014...(May 2015)
Foreign Pesticide Production Establishments. Two Summaries
Files below are from my collection of EPA's SSTS (Section Seven Tracking System) reports for 2004, 2005, 2006, 2011, 2012, 2013.
Note: Both files contain some duplicates.
Note: EPA's Excel format files for 2011-2013 are posted on the web. Go to the FOIA search site. Search for: EPA-HQ-2014-005123.
Establishments. Excel file EstNotUS.xlsx.
Products. Excel file SSTSPROD.XLS.
Country Code-Name. If not familiar with country codes, converted to names at http://www.epa.gov/compliance/resources/publications/monitoring/fifra/fgnestablishments.html...(April 2013)
Playing A-V files. Read this first.
Tutorial sessions move from finding EPA Reg. No. for latest label image additions to PPLS up to creating a browser-ready file such as this one, which has Registrant, Product, Actives information and with links to PPLS to get Label Images.
Access database Templates.
Access 2007. Zip file PPIS7TMP.zip extracts to PPIS7TMP.accdb. As of June 2014 this is the entire Template database I am using each month with EPA-OPP's PPIS text files. Minimal explanations below. Feel free to ask me "How-To, Say-What?, etc.).
Access Template database has 31 Tables. 18 Tables are Designed to receive EPA's PPIS Fixed-Width text (*.txt) files. For each PPIS Table I have an Import Specification (use the Advanced tab and then the Spec tab after telling Access which text file to append to which data table). Other Tables are those I use and each is filled in the Template. Again, ASK if any interest.
Quick and Simple: One File Import. Download then Import PPIS product.txt file. Run (double-click) qry01, qry02, qry03. Voila! tblActiveRegs has the currently Active Registrations.
Source. CDPR's data tables and descriptions of table contents is found at CDPR Database stuff.
Note: My Template databases have ONLY 8 Tables for CDPR data. There are many more, such as label Pests and Sites.
Note: CDPR's text data files are very much like EPA's for PPIS: Fixed-Width file format, except CDPR uses the 3 letter extension "dat" rather than EPA's "txt" file name extension. Importing data files and using Queries is the same as with PPIS files.
Import Specifications. Excel file CDPR_imp.xls tells you into which Access Table to Append each of the 8 CDPR Fixed-width text files and which Import Specification to use.
Queries. Excel file CDPR_qry.xls tells you what each of the 8 Queries does. Do them in numerical order (else funny results or a dreaded ERROR message). I.e., qry01, qry02, qry03, etc.
For further information, or to discuss a specific project, contact Bruce
e-mail your request to firstname.lastname@example.org (that's email@example.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