Q.01

What is the USDA Pesticide Data Program?

The USDA Pesticide Data Program (PDP) is the national program that monitors pesticide residues in the US food supply. USDA's Agricultural Marketing Service (AMS) runs it, and AMS says it "produces the most comprehensive pesticide residue database in the U.S." (USDA AMS PDP overview).

What it does

  • Who runs it: the AMS Monitoring Programs Division handles the sampling, testing and reporting of pesticide residues on farm produce in the US food supply. It works with State agriculture departments and other Federal agencies (PDP overview).
  • Focus: it puts particular weight on the foods that infants and children eat most (PDP overview).
  • What the data are for, as AMS states it (PDP overview):
    • letting the US Environmental Protection Agency assess dietary exposure;
    • helping US farm products sell on world markets;
    • guiding decisions by the FDA and other government agencies.
  • Other users: the AMS factsheet page (published 02/29/2024) says academic institutions, food producers and processors, chemical manufacturers, environmental groups and food safety organisations also use PDP data. They use it to look at residue issues that may affect farming practices and domestic and international trade (AMS PDP factsheet page).
  • What AMS publishes: program plans, a database search tool, annual summary reports (the latest is the 2024 Annual Summary), standard operating procedures, analytical methods, special projects and testing history (PDP overview).

What the raw data look like The datasets hold the PDP results files for the annual surveys from 1992 to 2024. Each record is one test result. It gives the survey year, sample number, commodity code and type, testing laboratory, pesticide code, concentration, limit of detection (LOD) and confirmation method. For example, a 1992 record shows commodity "AP" (type "FR") tested by laboratory "CA1" for pesticide code 160, at a concentration of 0.013 [1]. The pesticide and commodity codes are explained in AMS's PDP Search App Data Dictionary, linked from the overview page.

Approach: I checked the PDP results files in the datasets and opened the USDA AMS PDP overview and factsheet pages. Those pages don't give the program's start date or its legal basis, so I've left both out.

Q.02

How do I download its pesticide residue data?

You can download PDP data from the AMS page "PDP Databases and Annual Summaries". It has one ZIP file for each calendar year from 1992 to 2024. If you only need some records, the online PDP Database Search app lets you query them without downloading anything (AMS PDP Databases page).

Option 1: Download the full data for a year

  1. Open the PDP Databases and Annual Summaries page and click the Data ZIP File for the year you want. The 2024 file, for example, is 2024PDPDatabase.zip. It is 10.1 MB and was posted on 12/23/2025. The list also gives each year's posting or revision date.

  2. Unzip it. AMS says each file extracts to 7 files (AMS download instructions, August 2025):

    • 2 delimited text (.txt) files holding the PDP data;
    • 1 MS-Access (.mdb) database;
    • 1 Excel (.xls) workbook;
    • 3 PDFs.

    A fourth PDF with the revision history is included if that year's data has been revised.

  3. Follow the 2-page "INSTRUCTIONS ####.pdf" inside the ZIP, where #### is the year. The Access template already has the tables set up, a macro that imports the data automatically, and the code reference tables filled in. If you don't have MS-Access 2000 or higher, you can load the text files into your own database system instead.

  4. To read the codes, use the file layouts and reference lists in the ZIP. AMS also publishes a PDP Search App Data Dictionary.

Option 2: Query online

Related material: the Annual Summary Reports list has the published summaries. For data questions, AMS lists amsmpo.data@usda.gov and 202-572-8177 as the PDP staff contacts (PDP overview).

Approach: The PDP records in the datasets are individual test results and don't explain how to download them, so the steps above come from the official USDA AMS pages and the AMS download instructions. I can also pull PDP results for a specific commodity, pesticide code or year if that's useful.

Q.03