Product/Label Database Query Instructions

Back to Product/Label Database Queries & Lists

IMPORTANT: The product/label database is refreshed nightly, Monday through Friday.

Newly registered (licensed) products are included in the database even though the labels have not yet been "indexed". Only the product name, registration date, and company information will be available until the product label is indexed.

THE QUERIES

These searches of the product/label database are designed to extract products that meet a number of different or singular criteria. The different criteria are as follows:

Any of the criteria below may be used together to form a complex query. Be judicious as the selection of too many criteria, for example ten sites, will slow the program down considerably.

  • Chemical Ingredient(s) - Follow the chemical code (lookup) to find the code or codes you are interested in. Your may search the lookup by DPR's chemical code, a name or portion of a name, or by the CAS number or a portion or a CAS number. Other links to pesticide chemical databases are found at the bottom of the lookup screen. With this query you may select one or up to three different chemicals and use "and/or" logic to narrow your search. Any product containing those ingredients in relation to the percentages and logic selected will be found.

  • Product Name(s) - you may search the database by all or part of a product name or search for several at once if you separate them with a comma.

  • Firm Number(s) / Name(s) - Search the product database by a firm number or a name or in combination if separated by a comma. (i.e. 239, dowelanco)

  • Registration Number(s) - Enter all or part of a number(s). If more than one, separate with a comma. (i.e. 239-50 or 239-50043-AA)

  • Site Code(s) - Follow the site code (lookup) to find the code or codes your are interested in. For example, if you are interested in what is registered for use on figs, follow the link, enter fig, and select the code you want to enter in the query. Several sites may be searched together. Once again, separate multiple selections with commas.

  • Formulation Type(s), Pesticide Type(s), Signal Word(s) - These selections are self explanatory but must be used in conjunction with one or more of the above variables. Multiple selections may be made in each box by pressing the "control"(Ctrl) key when you click with your mouse on the selections.

  • Retrieve Active Products Only - You will get only actively registered products by checking the box next to this criteria. If this box is not checked, all products meeting the prescribed criteria will be found.

  • Have all products selected for detail report - check this box if you want all products reported on in more detail. See the paragraph below.

THE REPORTS

The initial query yields a list of products with check boxes next to them. The user may have pre-selected to check all the boxes, but in any case must check at least one in order to get more specific information on any or all of the products. The list also details the registration status of the products on the list.

The reports themselves are self explanatory. The data table format is a little different in that it provides a flat ascii text file that can be saved by the user for later use in a spreadsheet or database structure. It is recommended that the data table format not be used if a significant number of products are selected.

This document will be updated as new queries and databases are added to the external Web site.