In 2014, EFSA has commissioned a study to review and evaluate all published data related to the exposure to pesticides for residents and bystanders and for environmental risk assessment. The aim was to conduct a literature review and to produce a database containing all published data (predominately peer-reviewed publications supplemented by grey-literature) for the last 25-years, which will support the non-dietary exposure assessment to pesticides for bystanders and residents, as well as daily air concentration (vapours and aerosols) of pesticides, drift values from spray, seed and granular applications, and dislodgeable foliar residues. The data has been collated via a systematic and extensive literature review defined and managed according to a pre-defined 'review protocol'. The data was also exported in a format that meets the requirements of the EFSA Data Collection Framework (DCF). Based on quality and relevance criteria, articles and related studies have been selected. For dislodgeable foliar residues the assessment includes 27 articles (containing 49 discrete studies); for air concentrations, 26 articles (containing 84 discrete studies); for resident and bystander exposure, 5 articles (containing 8 discrete studies); and for drift values 55 articles (containing 275 discrete studies). For dislodgeable foliar residues the data retained covered 17 crops (including grass, glasshouse crops, lucerne, and citrus) and 29 pesticides; for air concentrations the data retained covered 21 crops (including fruit, glasshouse crops, ornamentals, grass, vegetables and cereals) and 39 pesticides. For drift values, the data covers a range of crops and landscapes from cereals, grass and turf, orchards, vineyards and regenerated forestry. The vast majority of the data retrieved applies to field studies for liquid spray drift, measured either as ground deposits or collected at various heights and were conducted using fluorescent tracers rather than pesticides. No data was found for microbials (biopesticides). For resident and bystander exposure, many articles were rejected due to the applied inclusion/exclusion criteria.

Data summary

• File 'Pesticide20usage20datasets20and20data20dictionary.xlsx'

  • Table ‘DATA EXCTRACTION’ consists of 15,415 data rows along 103 dimensions: ‘ID’, ‘ID_OP’, ‘ID_STUDY’, ‘ID_THEME’, ‘STUDY_DESIGN_OVERVIEW’, ‘SAMPLE_POINTS’, ‘REPLICATIONS’, ‘SAMPLING_DESIGN’, ‘SAMPSTRATEGY’, ‘SAMPLING_TECHNIQUE’ and 93 other dimensions
  • Table ‘STUDY APPRAISAL’ consists of 924 data rows along 32 dimensions: ‘ID_OP’, ‘ID_THEME’, ‘ID’, ‘KEY_EQUIPMENT’, ‘LABORATORY’, ‘LITERATURE’, ‘METEOROLOGICAL_CONDITIONS_1’, ‘METEOROLOGICAL_CONDITIONS_2’, ‘METHODOLOGY’, ‘NORMAL_CONDITIONS’ and 22 other dimensions
  • Table ‘OPINION’ consists of 92 data rows along 14 dimensions: ‘ID’, ‘DATA_ID’, ‘ID_OP’, ‘OP_TYPE’, ‘AUTHOR’, ‘TITLE’, ‘PUBLICATION_DATE’, ‘JOURNAL_TITLE’, ‘DOI’, ‘INTERNATION_UNIQUE_NUMBER’ and four other dimensions
  • Table ‘Data dictionary [A1:H104]’ consists of 103 data rows along eight dimensions: ‘tableName’, ‘name’, ‘Proposal’, ‘dataType’, ‘isNullable’, ‘isRecordUniqueIdentifier’, ‘catalogueCode’ and ‘Last update’
  • Table ‘Data dictionary [A106:H139]’ consists of 33 data rows along eight dimensions: ‘tableName’, ‘name’, ‘Column C’, ‘dataType’, ‘isNullable’, ‘isRecordUniqueIdentifier’, ‘catalogue code’ and ‘lastUpdate’
  • Table ‘Data dictionary [A141:H155]’ consists of 14 data rows along eight dimensions: ‘tableName’, ‘name’, ‘Column C’, ‘dataType’, ‘isNullable’, ‘isRecordUniqueIdentifier’, ‘catalogue code’ and ‘lastUpdate’