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.
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)
PPLS: Amended Labels: 24 August 2017
Using PPIS files of 21 August and PPLS file of 24 August.
The file below contains a product summary for products having an Amended label added to PPLS.
Excel file MEND1712.xlsx is for products having an AMENDED label posted in PPLS. File has product information and a link to PPLS for all labels of the product (using the EPA Reg. Nr.)...(August 25)
EPA. New (Sub)Registration(s) Approvals: 21 August 2017
Added to PPIS files of 28 August.
Newest Registration(s) Approvals. Excel file APPR1712.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 XFER1712.xlsx.
Newest SubRegistrations. Excel file SUBS1712.xlsx...(August 22)
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 email@example.com (that's firstname.lastname@example.org).
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