The U.S. Food and Drug Administration (FDA) operates an ongoing program of monitoring for pesticide residues in foods. The results of the program are published annually. Tables, figures, and appendices in each report are based upon summarizations of analytical data resulting from collection and analysis of food samples in field laboratories. Data files are made available here for the user who wishes to scrutinize further any aspect of analytical data and results.
Unlike the dBase III+ databases that were made public in 1992-1997, the 1998 and 1999 information is presented as a series of tab-delimited text files. This change in approach requires the user to create databases from the files, rather than merely using a pre-established database. The advantage of offering files in this format is that the user may create databases in any software available; most database or spreadsheet software should work with these files if adequate disk space and RAM are available.
Data in these files are the same as those provided in previous years, i.e., six files of summary data, in varying levels of summarization, as well as one file of analytical data related to each sample, and another file that describes the capabilities of the analytical methods in terms of the residues detectable. An additional file decompresses to four lookup tables, each of which provides further information about particular data entries.
Directions for downloading and executing (decompressing) the individual files follows the background information about the pesticide program and the details of file structure and content.
BACKGROUND: FDA'S PESTICIDE PROGRAMS
Regulatory Responsibility for Pesticides
The FDA shares responsibility with two other federal agencies for the regulation of pesticides. The Environmental Protection Agency (EPA) registers (i.e., approves) the use of pesticides based on evidence that their use will not cause an unreasonable risk to health or the environment. EPA is also responsible for establishing tolerances if use of a pesticide may lead to residues in food. (A tolerance is the maximum amount of a residue that is permitted in or on a food.) With the exception of meat, poultry, and certain egg products, for which the Food Safety and Inspection Service (FSIS) of the U.S. Department of Agriculture (USDA) is responsible, FDA is charged with enforcing tolerances in imported foods and in domestically produced foods shipped in interstate commerce. FDA also acquires incidence/level data on particular commodity/pesticide combinations and carries out its market basket survey, the Total Diet Study. USDA's Agricultural Marketing Service (AMS), through contracts with participating states, conducts a residue testing program directed primarily at raw agricultural products. FSIS and AMS pesticide residue data are reported independently by those agencies.
FDA Pesticide Monitoring Program
The FDA pesticide monitoring program is comprised of three components: 1) regulatory monitoring; 2) incidence/level monitoring; and 3) the Total Diet Study. THE DATABASE PRESENTED HERE COVERS ONLY THE REGULATORY MONITORING COMPONENT. However, a brief description of the other two components is provided, and further information on them is available in the FDA annual reports, available from FDA's website.
Regulatory Monitoring
The regulatory monitoring component is directed toward enforcing tolerances in imported foods and in domestically produced foods shipped in interstate commerce. Under regulatory monitoring, FDA samples individual lots of domestically produced and imported foods and analyzes them for pesticide residues. Domestic shipments are collected as close as possible to the point of production in the distribution system; import samples are collected at the point of entry into U.S. commerce. Emphasis is on the raw agricultural product, which is analyzed as the unwashed, whole (unpeeled), raw commodity. Processed foods also are included.
Domestic and import food samples collected for analysis are classified as either "surveillance" or "compliance", this classification was dropped in 1999. Most samples collected by FDA are the surveillance type; that is, there is no prior knowledge or evidence that a specific food shipment contains illegal pesticide residues. Compliance samples are collected as follow-up to the finding of an illegal residue or when there is other evidence of a pesticide problem. Compliance samples include follow-up samples from the same shipment as a violative surveillance sample, follow-up samples from additional product from the same grower or shipper, and audit samples from shipments presented for entry into the United States with a certificate of analysis (i.e., shipments subject to detention without physical examination).
To analyze the large numbers of samples whose pesticide treatment history is usually unknown, analytical methods capable of simultaneously determining a number of pesticides are used. These multiresidue methods (MRMs) can determine about half of the approximately 400 pesticides with EPA tolerances, as well as many others that have no tolerances. The most commonly used MRMs can also detect many metabolites, impurities, and alteration products of pesticides with and without tolerances.
Single residue methods (SRMs) or selective MRMs may be used to determine pesticides not covered by an MRM. An SRM usually determines one pesticide; a selective MRM measures a relatively small number of chemically related pesticides. These types of methods are usually more resource-intensive per residue, and they may require at least as much time to perform as an MRM. They are much less cost efficient than MRMs.
The lower limit of residue measurement in FDA's determination of a specific pesticide is usually well below tolerance levels, which generally range from 0.1 to 50 parts per million (ppm). Residues present at 0.01 ppm and above are usually measurable; however, for individual pesticides, this limit may range from 0.005 to 1 ppm. In this database, the term "trace" is used to indicate residues detected, but at levels below the limit of quantitation.
Incidence/Level Monitoring
A complementary approach to regulatory monitoring, incidence/level monitoring has been used to increase FDA's knowledge about particular pesticide/commodity combinations by analyzing certain foods to determine the presence and levels of selected pesticides. In 1995, a survey of triazines was started and in 1997 the survey was completed.
Statistically based monitoring surveys, focusing on domestic and imported foods were initiated in 1992 and the results have been published. These statistically based surveys were initiated to determine whether FDA data acquired under regulatory monitoring are statistically representative of the overall residue situation for a particular pesticide, commodity, or place of origin. In FDA's surveillance sampling for pesticide residues, sampling bias may be incurred by weighting sampling toward such factors as commodity or place of origin with a past history of violations or large volume of production or import shipments. In addition, the total number of samples of a given commodity analyzed for a particular pesticide each year may not be sufficient to draw specific conclusions about the residue situation for the whole volume of that commodity in commerce. Therefore, the objective of these statistically based surveys is to determine whether violation rates, frequency of occurrence of residues, and residue levels obtained from such a sampling regimen differ from those obtained through FDA's traditional surveillance approach.
Total Diet Study
The Total Diet Study is designed to estimate dietary intakes of pesticide residues by various age/sex groups from infants to senior citizens. FDA personnel purchase foods from supermarkets or grocery stores four times per year, once from each of four geographical regions of the country. Each collection contains 261 food items (234 items prior to 1992) that have been selected on the basis of information obtained through nationwide dietary surveys. The 261 foods are representative of over 3500 different foods in the national surveys; for example, apple pie represents all fruit pies and fruit pastries. Each of the four collections is a composite of like foods purchased in three cities in that region. The foods are prepared table-ready and then analyzed for pesticide residues (as well as radionuclides, industrial chemicals, toxic elements, trace and macro elements, vitamin B6, and folic acid). The levels of pesticides found are used in conjunction with food consumption data to estimate the dietary intakes of the pesticide residues.
DATA FILES STRUCTURE AND CONTENT
The following notes apply to all Summary Files.
Structure of each Summary File follows:
PRODYYYY.TXT: Summary File by Country/Sample
Flag/Food Product Combination (where YYYY is the year)
Summary file by country/sample flag/food product combination (without regard to pesticide).
Field Name |
Full Name |
Width |
Description |
YEAR |
year |
4 |
"YYYY" in all records |
COUNTRY |
country of origin |
20 |
country name (see list of country names for more details) |
FLAG |
sample flag |
4 |
"SURV" for surveillance samples or "COMP" for compliance samples, dropped in 1999 |
PRODCODE |
product code |
5 |
Product code (see downloadable file for list of product codes and full product names) |
PRODNAME |
product name |
60 |
product name (translation of product code; see downloadable file for list of product codes and full product names) |
SAMPANAL |
samples analyzed |
4 |
number of samples analyzed |
SAMPRES |
samples with residues |
4 |
number of samples with one or more residues |
PCTRES |
percent with residues |
3 |
percent of samples with one or more residues |
SAMPADV |
samples adverse |
4 |
number of samples with one or more adverse residues |
PCTSMADV |
percent adverse |
3 |
percent of samples with one or more adverse residues |
CHEMCOVR |
chemicals covered |
4 |
number of different pesticides covered in one or more samples for the country/sample flag/product combination; value will be "0" in cases where the analytical coverage could not be determined from the information reported by the analyzing laboratories |
CHEMFND |
chemicals found |
4 |
number of different pesticides found in one or more samples for the country/sample flag/product combination |
CHEMYYYY.TXT: Summary File by Country/Sample
Flag/Pesticide Combination (where YYYY is the year)
Summary file by country/sample flag/pesticide combination (without regard to product).
Field Name |
Full Name |
Width |
Description |
YEAR |
year |
4 |
"YYYY" in all records |
COUNTRY |
country of origin |
20 |
country name (see list of country names for more details) |
FLAG |
sample flag |
4 |
"SURV" for surveillance samples or "COMP" for compliance samples, dropped in 1999 |
CHEMICAL |
chemical (residue) |
40 |
pesticide name (see list of pesticide names for more details) |
TOTSMPCOVR |
total samples covered |
5 |
number of samples covered for this pesticide by the analytical methodology used |
TOTPCTCOVR |
total percent covered |
3 |
percent of samples covered for this pesticide (calculated based on TOTAL samples analyzed for the country/sample flag combination) |
TOTRESFND |
total samples with residues |
5 |
number of samples with residue found |
TOTPCTFND |
total percent with residues |
3 |
percent of samples with residue found (calculated based on number of samples covered) |
TOTRESADV |
total samples adverse |
5 |
number of samples with adverse residue |
TOTPCTADV |
total percent adverse |
3 |
percent of samples with adverse residue (calculated based on number of samples covered) |
USYYYY.TXT, IMFRYYYY.TXT,
IMVEYYYY.TXT, IMOTYYYY.TXT:
Summary Files by Country/Sample Flag/Food
Product/Pesticide Combination (where YYYY is the year)
Detailed data by country/sample flag/food product/pesticide combination.
Field Name |
Full Name |
Width |
Description |
YEAR |
year |
4 |
"YYYY" in all records |
COUNTRY |
country |
20 |
country name (see list of country names for more details) |
FLAG |
sample flag |
4 |
"SURV" for surveillance samples or "COMP" for compliance samples, dropped in 1999 |
PRODCODE |
product code |
5 |
product code (see downloadable file for list of product codes and full product names) |
PRODNAME |
product name |
40 |
product name (translation of product code; to conserve space in the detailed file, records contain only 40 characters of the product names; see downloadable file for list of product codes and full 60-character product names) |
CHEMICAL |
chemical (residue) |
40 |
pesticide name (see list of pesticide names for more details) |
SAMPCOVR |
samples covered |
4 |
number of samples covered by the analytical methodology used |
PCTCOVR |
percent covered |
3 |
percent of samples covered for this pesticide (calculated based on TOTAL samples analyzed for the country/sample flag/food product combination) |
RESFND |
residues found |
4 |
number of samples with residue found (includes trace residues) |
PCTFND |
percent found |
3 |
percent of samples with residue found (calculated based on number of samples covered) |
RESADV |
residues adverse |
4 |
number of samples with adverse residue |
PCTADV |
percent advers |
3 |
percent of samples with adverse residue (calculated based on number of samples covered) |
RESTRCE |
residues at trace level |
4 |
number of trace residues found |
MEAN |
mean |
10 |
mean residue concentration; format 999.999999; although mean is calculated to six places to right of decimal for informational purposes, this is not indicative of the accuracy of the analytical methodology* |
MINIMUM |
minimum |
8 |
minimum residue concentration; format 999.9999 with trailing zeros to right of decimal removed or can contain "T" to represent trace value* |
MEDIAN |
median |
8 |
median residue concentration; format 999.9999 with trailing zeros to right of decimal removed or can contain "T" to represent trace value* |
NINETITH |
ninetieth percentile |
8 |
90th percentile residue concentration; format 999.9999 with trailing zeros to right of decimal removed or can contain "T" to represent trace value* |
MAXIMUM |
maximum |
8 |
maximum residue concentration; format 999.9999 with trailing zeros to right of decimal removed or can contain "T" to represent trace value* |
* The data elements pertaining to residue concentration (MEAN, MINIMUM, MEDIAN, NINETITH, and MAXIMUM) are based on the number of samples covered and are expressed in parts per million. Trace findings and samples in which no residue was detected were treated as zero in calculation of the MEAN. In the MINIMUM, MEDIAN, NINETITH, and MAXIMUM data elements, "T" represents a trace finding and "0" represents "none detected." The vast majority of these records indicate that no residues were found (i.e., RESFND=0) for that country/sample flag/food product/pesticide combination.
The following notes apply to the Analytical Data File.
Structure of the Analytical Data File follows:
SMPLYYYY.TXT: Analytical Data File (where YYYY is the year)
Analytical data for each individual sample, as entered by FDA field chemists.
Note that each record is uniquely identified by its combination of year/analyzing district/sample number/PAC/LID/entry number, and the file is provided in sequence by this record key.
Field Name |
Full Name |
Width |
Description |
Year |
year |
4 |
"YYYY" |
AnalDist |
analyzing district |
3 |
abbreviation for FDA analyzing district; see list of Districts |
SmplNo |
sample number |
8 |
identifier for a particular sample |
PAC |
PAC |
6 |
program assignment code; indicates the program or assignment under which the sample was analyzed; see list of PACs |
LID |
LID |
1 |
laboratory identifier assigned by analyzing laboratory; no standardized definitions |
EntryNo |
entry number |
2 |
computer-generated sequential numbering of records entered for the analyzing district/sample number/PAC/LID combination |
ColDist |
collecting district |
3 |
abbreviation for FDA collecting district; see list of Districts |
ColDate |
collection date |
8 |
sample collection date; format YYYYMMDD |
SmplFlag |
sample flag |
4 |
"SURV" for surveillance sample or "COMP" for compliance sample, dropped in 1999 |
SmplType |
sample type |
1 |
|
Orig |
origin |
3 |
"DOM" for domestic or "IMP" for import |
State |
state |
2 |
postal abbreviation for state where responsible firm resides (District of Columbia-DC, Puerto Rico-RQ, and American Samoa-AQ); will be blank for import samples |
Country |
country |
20 |
name of country of origin (see list of country names for more details); will be blank for domestic samples |
ProdCode |
product code |
5 |
product code (see downloadable file for list of product codes and full product names)) |
ProdName |
product name |
60 |
product name (translation of product code; see downloadable file for list of product codes and full product names) |
LabClass |
lab class |
1 |
code for classification of sample by analyzing laboratory; see list of Lab Classes |
LabDate |
lab out date |
8 |
date of final review of sample analysis and exit from laboratory; format YYYYMMDD |
Smpl |
sample description |
25 |
free form narrative describing the product analyzed; if sample was collected in follow-up to a previous adverse sample, position 17 will be "#" followed by the sample number of the initial adverse sample (called "episode sample number") |
SubSmpl |
subsample |
2 |
code that identifies an individual subsample within the sample; may be blank (to represent sample composite) or can contain a numeric value or standardized code (B=bottoms, E=edible portion, T=tops, W=whole product). |
AnalType |
analysis type |
1 |
code for type of
analysis: |
ResCode |
residue code |
3 |
code for the chemical that was found; code may instead represent a chemical analyzed for but not found if analyzing laboratory wanted to highlight the result |
ResName |
residue name |
60 |
translation of residue code (see list of pesticide names for more details) |
AdvFlag |
adverse flag |
1 |
code to denote the adverse nature of the residue found: A=At or above
action level |
Trace |
trace |
1 |
"T" if trace residue was found, otherwise will be blank |
Amount |
residue amount |
6 |
residue concentration; format 999999 with implied decimal after third position; will be blank in records with analysis type=I |
Unit |
residue unit |
1 |
unit of concentration for residue amount field; "M" for parts per million or "B" for parts per billion |
ExtCode |
extraction code |
3 |
code for extraction method used; see list for definitions |
DetCode |
determination code |
2 |
code for determination method used; see list for definitions |
Remarks |
remarks |
35 |
narrative remarks concerning analytical method or results of analysis; may be blank |
The following notes apply to the File of Pesticides Covered by the Analytical Methods.
Structure of the File of Pesticides Covered by the Analytical Methods follows:
METHYYYY.TXT: File of Pesticides Covered by the Analytical
Methods (where YYYY is the year)
List of pesticides covered by analytical methods used by FDA.
Field Name |
Full Name |
Width |
Description |
ExtCode |
extraction code |
3 |
extraction method code; see list for definitions) |
DetCode |
determination code |
2 |
determination method codesee list for definitions |
ResCode |
residue code |
3 |
code for the chemical covered |
ResName |
residue name |
60 |
translation of residue code (see list of pesticide names for more details) |
The following notes apply to the Other Lookup Tables.
All data files for 1998 and 1999 are compressed (zipped) into self-extracting executable files. Execution of each downloaded file produces a tab-delimited text (.txt) data file. Structures and contents of each data file are described above. Each data file can be imported by most database or spreadsheet software. At least 50 MB of free disk storage space is needed to hold the decompressed 1998 data.
The following tables describe codes found in the records of the analytical data file:
Code |
Definition |
Code |
Definition |
ATL |
Atlanta |
NOL |
New Orleans |
BLT |
Baltimore |
NSV |
Nashville |
BUF |
Buffalo |
NRL |
New York Regional Laboratory |
CHI |
Chicago |
NWE |
New England District Office |
CIN |
Cincinnati |
NWJ |
New Jersey District Office |
DAL |
Dallas |
NYK |
New York |
DEN |
Denver |
PHI |
Philadelphia |
DET |
Detroit |
SAN |
San Francisco |
FLA |
Florida |
SEA |
Seattle |
KAN |
Kansas City |
SJN |
San Juan |
LOS |
Los Angeles |
SRL |
Southeast Regional Laboratory in Atlanta |
MIN |
Minneapolis |
WEA |
Winchester Engineering and Analytical Center in Winchester, Massachusetts |
Program/Assignment Code (PAC) Definitions
The following are code definitions for the general monitoring programs and special field assignments.
Code |
Definition |
04F800 |
Pesticide and Industrial Chemicals short term assignments |
04R834 |
Pesticide and Industrial Chemicals partnership activities |
04R842 |
Pesticide and Industrial Chemicals short term assignments |
04S800 |
Pesticide and Industrial Chemicals in State Grown Foods (FDA/State Cooperation (Virginia and California)) |
04004A |
Pesticides and Industrial Chemicals in Domestic Foods (general program) |
04016A |
Pesticides and Industrial Chemicals in Imported Foods (general program)
|
04842A |
Pesticides and Industrial Chemicals in Domestic Fish and Fishery Products (special program initiated in FY 1997) |
Code |
Definition |
A |
Additional--Sample collected from a previously sampled lot; for import samples, the additional sample must have the same sample number as the original sample; for domestic samples, the additional sample may have another sample number but it must be flagged as additional and the original sample number should be in the sample description field |
C |
Certification/audit--Sample collected to verify analytical results provided by a certificate of analysis that purport to show that a product is in compliance. (This sample type will usually be used with import samples.) |
F |
Food Standards--A sample collected as a direct result of an assignment in connection with food standards. |
I |
Domestic import--Sample of a product that was imported and released into commerce in the United States. (Treated as "import" origin sample in the database.) |
M |
Mail entry--A sample of an imported product that enters the United States through the United States mail. |
N |
Non-regulatory--Sample collected and analyzed by FDA for other federal, state or local agencies of products over which the FDA has no jurisdiction. |
O |
Official--A representative portion of a lot, collected for possible regulatory action with the records and evidence to prove that the product is subject to the laws and regulations enforced by FDA. |
P |
Post seizure--A representative sample collected under court order from the goods under seizure. |
V |
Investigational--Sample collected for general information. |
X |
Regulatory--Sample collected or analyzed by non-FDA personnel. |
Laboratory Classification Definitions
Code |
Definition |
1 |
The sample either: 1) contains no residues, as indicated by the methods used; or 2) contains only residues that comply with established tolerances. |
2 |
The sample contains a residue for which no tolerance has been established in the sampled food, but the residue level is below the level of regulatory significance. |
3 |
The sample: 1) contains a residue which exceeds a tolerance; and/or 2) contains a residue for which there is no tolerance for the food product involved and the residue level appears to be of regulatory significance. [Note: This classification is based on the laboratory's conclusion that the sample appears to contain actionable residue(s). Upon further review, FDA compliance officers may determine that the sample does not support FDA regulatory action (e.g., shipment not entered into interstate commerce).] |
4 |
No classification required. (The sample is not of the type to require a classification because the type of examination or the reason for analysis makes classification meaningless.) |
To comment or request further information, contact Mark Wirtz, mwirtz@cfsan.fda.gov