This section of the data dictionary describes the eight report files and one dictionary file that are contained in a zip file created for each year in which data is currently available.
These tab delimited files may be downloaded here or from the Download section of the menu bar.
The ai_names.txt file is a dictionary file for the eight report files. It can be used to
lookup active ingredients names using the active ingredient code field. There is one record for each
active ingredient name for each code in the Active Ingredient Reporting Database.
Record Layout:
1. Active Ingredient Code
2. Active Ingredient Name
The file ai_sales_all_yyyy (where yyyy = year of report),
contains the active ingredient data for the Commercial Permittee Annual Sales Report for
Restricted Use Pesticides and General Use Agricultural Pesticides in New York State.
Record Layout:
1. Active Ingredient Code
2. Quantity (Pounds)
The file ai_sales_enduse_yyyy (where yyyy = year of report)
contains the active ingredient data for the Restricted Pesticides Annual Report for
Commercial Permittees (Including Importers, Manufacturers and Compounders) for Sales, including
Purchase Permit Sales to Commercial Applicators for End Use in New York State.
Record Layout:
1. Active Ingredient Code
2. Quantity (Pounds)
The file ai_sales_resale_yyyy (where yyyy = year of report)
contains the active ingredient data for the Restricted Pesticides Annual Report for
Commercial Permittees (Including Importers, Manufacturers and Compounders) for Sales to Commercial Permit Holders for
Resale in New York State.
Record Layout:
1. Active Ingredient Code
2. Quantity (Pounds)
The file ai_sales_cnty_yyyy (where yyyy = year of report)
contains the active ingredient data for the Commercial Permittee Annual Sales Report for Restricted
Use Pesticides and General Use Agricultural Pesticides in New York State Summarized by County.
Record Layout:
1. County
2. Active Ingredient Code
3. Quantity (Pounds)
The file i_sales_zip_yyyy (where yyyy = year of report)
contains the active ingredient data for the Commercial Permittee Annual Sales Report for Restricted
Use Pesticides and General Use Agricultural Pesticides in New York State Summarized by Zip.
Record Layout:
1. Zip Code
2. Active Ingredient Code
3. Quantity (Pounds)
The file ai_use_all_yyyy (where yyyy = year of report)
contains the active ingredient data for the Commercial Applicator Pesticide Use Annual
Report for New York State.
Record Layout:
1. Active Ingredient Code
2. Quantity (Pounds)
The file ai_use_cnty_yyyy (where yyyy = year of report)
contains the active ingredient data for the Commercial Applicator Pesticide Use Annual
Report for New York State.
Record Layout:
1. county
2. Active Ingredient Code
3. Quantity (Pounds)
The file ai_use_zip_yyyy (where yyyy = year of report)
contains the active ingredient data for the Commercial Applicator Pesticide Use Annual
Report for New York State.
Record Layout:
1. Zip Code
2. Active Ingredient Code
3. Quantity (Pounds)