Searching the Pesticide Data Index Database
Guide to searching DPR’s pesticide data index
DPR’s library of pesticide data includes more than 76,000 volumes of data containing more than 210,000 studies. The index is updated weekly, on Sunday.
Information on studies submitted to DPR prior to 1994 may not include the DPR received date, applicant (i.e., data owner), or a tracking ID number.
To simplify retrieval of information, pesticide studies submitted to DPR have been indexed into a database using several different criteria. The more specific you can be in your search, the better the results. Searches that lack specificity may yield thousands of study titles and be of limited use to the requestor.
Chemical Ingredient Information - DPR "chemcode" numbers are assigned to each active ingredient found in a pesticide product and included in DPR’s Pesticide Product Database. If you know the chemcode for the product or study you are interested in, enter that number into the "Search by Chemical Code(s)" box. If you don’t know the chemcode of a pesticide active ingredient, use the "Lookup Chem Code" tool at the top of the search page.
If you are searching for multiple chemicals and check the "All studies must match all chemicals listed" box, you will get ONLY those studies that include those multiple chemicals. For example, if you enter 105 (carbaryl) and 198 (diazinon), and check the box, you will only get studies that test BOTH carbaryl and diazinon. If you enter the two chemicals, and do NOT check the box, you will get all studies that test EITHER carbaryl or diazinon, or both.
Test Types - Each study is also indexed according to its "Test Type(s). " California’s test types are similar to the U.S.Environmental Protection Agency’s Data Requirement Guidelines. You may want to click on the "List Test Types" button and the "Sort by Test Type Categories" checkbox and print the list for future reference. If you do not click the "Sort by Test Type Categories" button, you will get the list in numerical order (not as useful). You may search on either a "category" of test types or on individual test type numbers.
Title Word(s) - When you search, you may use any, all, or any combination of criteria: chemical code, test type, title word(s), and firm number. The title word search can be useful if you are interested in a specific pest or organism (like "quail") on which a study might have been performed. Search hint: searching on a word like "rabbit" will yield studies with both "rabbit" and "rabbits," but searching on "rabbits" will not yield study titles containing the word "rabbit."
Firm Number - This search is helpful if you know the firm number of a company that submitted studies for a particular active ingredient.
TIP FOR THE MULTIPLE CRITERIA SEARCH: You should always use at least two data elements when conducting this search, like chemcode and test type.
Study ID Number - When data are indexed, DPR assigns each individual study a unique "Study ID Number" (much like the U.S. EPA’s MRID number). This number is reported back to the data submitter with the first correspondence from the Pesticide Registration Branch (in the form of a "Data Detail Report"). If you know the study ID number, you may search for that specific study report. If you want to search for more than one study at time, you must separate the study ID numbers with a comma.
U.S. EPA Registration Number - If you want to know what studies were submitted to support a specific PRODUCT and you know the U.S. EPA registration number, you may search on those criteria. If you know the product name or other information about the product, you can find the U.S. EPA registration number elsewhere on the DPR website (go to "Product specific inquiries").
When searching by registration number, do not enter leading zeros on any of your search criteria. A search on a two-part number will also yield data that was submitted with a distributor registration. There are limitations on this search as the EPA registration number fields were not part of the initial database.
Tracking ID Number - It is advisable to know the tracking ID number before carrying out this search. The search will yield a listing of all the studies that were submitted to the Registration Branch and processed under that number. Tracking ID numbers are listed in weekly Notices of Decision, Materials Entering Evaluation, and included in the automatic email notifications of registration submission status. There are limitations on this search as the tracking ID field was not part of the initial database. Studies you retrieve using this criteria should also have a "date received" associated with the tracking ID.
Document Number - The "document" is a volume of data that may be comprised of a several studies; or, several volumes may comprise a single study. The document number is an aggregate of two numbers that identify the chemical and the volume number. This aggregate number is used for physical storage of the data in the Registration Resource Center. The first part of the number is the "DPN" field and may range in length from three to five numerals. The second part is the volume number and must be four numerals in length. Leading zeros are required for the volume. An example would be: 1840001. It is advised that you know the document number before you conduct this search.
Organization / Sponsor Report Number - These numbers are often assigned by submitting registrants, data owners, or laboratories that conduct the studies. These numbers may be alpha, numeric, or a combination of both. The search is conducted simultaneously against both fields. Many registrants have a methodology to the issuance of these identifiers.
MRID Number - The Master Record Identification number (MRID) number is assigned by U.S. EPA to individual studies and indexed in the DPR Data Index if submitted by the registrant along with the data. Only 7,000 MRID’s have been submitted. This is not considered to be good search criterion.
HOW TO REQUEST COPIES OF DATA: You can request, PDF (79 kb) copies of data from the Registration Branch Library. Because some studies contain proprietary business information under federal law, such requests are governed under special provisions of the Public Records Act.
For content questions, contact:
1001 I Street, P.O. Box 4015
Sacramento, CA 95812
Phone: (916) 445-4382