The results below are likely only meaningful to subject matter experts because the source dataset employs abbreviations, jargon and/or otherwise non-obvious labels. You may get in touch to help improve the source data, or you may browse Analyst-2 to find more accessible datasets.

Exposure to pesticides data for residents and bystanders, and for environmental risk assessment

(exposure-to-pesticides-data-for-residents-and-bystanders-and-for-environmental-risk-assessment)   []

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’

Size: 3844.6 KBSource: data.europa.euLast updated: 2022-01-08 00:41

Analyst-2 explores entire data repositories and data lakes, autonomously analyzing each dataset using the Inspirient Automated Analytics Engine.

If you would like Analyst-2 to surface insights in your company's data repository or data lake, please get in touch!

Creative Commons License

These analysis results by Inspirient GmbH are licensed under a Creative Commons Attribution 4.0 International License in conjunction with the licence of the source dataset.