|
BEELIFE EUROPEAN BEEKEEPING COORDINATION Avenue Louise 209/7, 1050 Brussels, Belgium info@pollinatorhub.eu • www.pollinatorhub.eu • +32 (0) 486 973 920 |
Dataset Report
| UID: | PSTCD102.0.0 |
| Name: | Pesticides Sales Belgium |
| Status: | Sales of pesticides in Belgium |
| Title: | Approved |
| Version: | v. 1.1 |
| Date: | 2024-12-11 |
| Author: | |
| Citation proposal: |
2024.
Report of dataset Pesticides Sales Belgium,
v. 1.1
[PSTCD102.0.0].
https://app.pollinatorhub.eu/dataset-discovery/reports/63
|
|
Data Quality
Under evaluation
|
|||||||||||||||
This document is intended for use by collaborators of the EU Pollinator Hub and may be passed on with the express permission of the leader of the consortium and for the purpose determined by the leader of the consortium.
Document History
Release
Version v. 1.1 released on 2025-02-05.
Revision
Table 1. List of revisions made to the document. Identifier of revision (No); date of revision (Date); description of revision (Description); reason for revision (Reason).
| No | Date | Description | Reason |
|---|---|---|---|
| 1 | 2025-02-05 05:02:19 | Initial release. | N.A. |
Abbreviations
No Abbreviations.
Executive Summary
Data overview:
n/a
Data value:
n/a
Data description:
n/a
Data application:
n/a
Introduction
n/a
Material and Methods
Data Acquisition
n/a
Table 2. List of raw data and metadata files included in the dataset. Identifier of table row (No); name of the file (File); the type of the file (Type); file contains data (D); file
contains metadata (M); date of upload of the file to the EU Pollinator Hub (Arrival); number of data points contained within the file (if applicable); uploaded file size.
| No | File | Type | D | M | Arrival | Data points | File size |
|---|---|---|---|---|---|---|---|
| 1 | BE_PPP AS Sales 2011-2022_PREP_MR_241205.csv | CSV - Comma seperated values | Yes | No | 2024-12-10 14:12:28 | 95,580 | 1.50 MiB |
Data Preparation
n/a
Data Validation
n/a
Data Analysis
n/a
Data Description
Dataset
Table 3. Summary of tables belonging to the dataset. Table row identifier (No); name of the table (Table); description of the table (Description).
| No | Table | Description |
|---|---|---|
| 1 | Pesticide Sales Belgium | Pesticide sales data from Belgium per active ingredient. |
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | PSTCD102.0.0 |
| Name | Pesticides Sales Belgium |
| Title | Sales of pesticides in Belgium |
| IRI | https://app.pollinatorhub.eu/dataset-discovery/PSTCD102.0.0 |
| Licence | n/a |
| DOI | n/a |
| Creation date | 2024-04-30 |
| Publishing date | 2024-12-11 |
| Contact information | simon@bee-life.eu |
| Keywords | Belgium, pesticides, pesticides sales |
| Data collection years | 2011-2022 |
| Regions, the data was collected in | Belgique/België |
| Description | Data from pesticide sales in Belgium between 2011 and 2022. Provided by SPF Health and Safety, Belgium. |
Table 5. Standardised metadata of the data provider Noa Simon Delso. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Noa Simon Delso |
| URL | |
| Acronym | Noa |
| IRI | https://app.pollinatorhub.eu/data-providers/noa-simon-delso-2 |
| Contact information | simon@bee-life.eu |
| Description | Noa Simón Delso became Scientific Director and Project Manager at BeeLife at the beginning of 2021. She holds a PhD in Agricultural Science and Bioengineering from the Université Catholique de Louvain (Belgium), an MSc in Economy, Management and Consumer Studies from Wageningen University (the Netherlands) and she is a DVM from the University of León (Spain). In her scientific career, Noa has specialised in environmental toxicology, particularly on bees, environmental policy and honey bee health, fields in which she has published several papers in peer-reviewed international journals in the field of environmental research, health and toxicology. In 2019 she started diversifying her activities, evolving towards the implementation of data science to pollinators health. In parallel, she has provided technical assistance to Belgian and European beekeepers and decision makers. Since 2009, she has advised in scientific-technical dossiers to the European organisation BeeLife, following the evolution and implementation of European legislation on the subject of pesticide authorisation, agricultural and environmental policy. During this time, she developed great expertise in the regulatory framework and policies related to pollinator health and conservation. More on: https://www.researchgate.net/profile/Noa-Simon-Delso |
Table 6. Standardised metadata of the data provider Michael Rubinigg. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Michael Rubinigg |
| URL | |
| Acronym | Visualife |
| IRI | https://app.pollinatorhub.eu/data-providers/michael-rubinigg |
| Contact information | https://orcid.org/0000-0002-7061-920X https://www.linkedin.com/in/rubinigg/ |
| Description |
Tables
Pesticide Sales Belgium
Table 7. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | PSTCD102.PSTCD526.0 |
| Name | Pesticide Sales Belgium |
| IRI | https://app.pollinatorhub.eu/dataset-discovery/parts/PSTCD102.PSTCD526.0 |
| Type | File |
| Licence | n/a |
| Description |
n/a
Metadata
n/a
Table 8. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data
type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
| Name | Description | Data type | Descriptor | Unit |
|---|---|---|---|---|
| Major Groups | Major group of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj). | String | majorGroup [0.0.MJRGR522] | n/a |
| Categories of products | Category of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj). | String | categoriesOfProducts [0.0.CTGRF523] | n/a |
| Code | Code of the group of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. | String | code [0.0.CDABC524] | n/a |
| Chemical Class | Chemical class of the group of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. | String | chemicalClass [0.0.PPPCH525] | n/a |
| SUBSTANCES COMMON NAMES | Common name of the group of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. | String | substancesCommonName [0.0.SBSTN526] | n/a |
| CAS | CAS registry number(s) of the [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided accoring to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. | String | casRegistryNumber [0.0.CSRGS389] | n/a |
| CIPAC | CIPAC registry code(s) of the [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided accoring to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. | String | cipacCodeNumber [0.0.CPCCD391] | n/a |
| variable | Calendar year for which the results are provided. | Integer number | year [0.0.YEARA340] | year |
| value | Amount of [plant protection products](https://app.pollinatorhub.eu/vocabulary/classes/2974) of a specific [chemical class](https://app.pollinatorhub.eu/vocabulary/classes/3321) sold in a given [calendar year](calendar year) in [Belgium](https://app.pollinatorhub.eu/vocabulary/classes/173) in [kg](https://app.pollinatorhub.eu/vocabulary/classes/586). ). | Decimal number | DecimalNumber [0.0.DCMLN314] | kg |
Metadata of individual tables can be found in Annex 1.
Descriptive Measures
Table 9. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Major Groups | 0 - 46 | n/a | Fungicides a… | n/a | n/a | n/a | Total | 10,620 | 104 ( 1.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 8 ( 0.1% ) |
| Categories of products | 0 - 69 | n/a | Acaricides | n/a | n/a | n/a | Vegetal oils | 10,620 | 182 ( 1.7% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 37 ( 0.3% ) |
| Code | 3 - 11 | n/a | F01 | n/a | n/a | n/a | ZR99_99_99 | 10,620 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 815 ( 7.7% ) |
| Chemical Class | 0 - 114 | n/a | ALIPHATIC NI… | n/a | n/a | n/a | inorganic fu… | 10,620 | 91 ( 0.9% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 170 ( 1.6% ) |
| SUBSTANCES COMMON NAMES | 0 - 185 | n/a | (E)-11-TETRA… | n/a | n/a | n/a | ZUCCHINI YEL… | 10,620 | 2,209 ( 20.8% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 646 ( 6.1% ) |
| CAS | 0 - 46 | n/a | 10004-44-1 | n/a | n/a | n/a | 999-81-5 | 10,620 | 4,432 ( 41.7% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 470 ( 4.4% ) |
| CIPAC | 0 - 68 | n/a | 1 | n/a | n/a | n/a | 991 | 10,620 | 3,613 ( 34.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 526 ( 5.0% ) |
| variable | 4 - 4 | 2,016.5 | 2,011 | 2,013.25 | 2,016.5 | 2,019.75 | 2,022 | 10,620 | 816 ( 7.7% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 13 ( 0.1% ) |
| value | 0 - 10 | n/a | 0.0 | n/a | n/a | n/a | D | 10,620 | 4,957 ( 46.7% ) | 832 ( 7.8% ) | 0 ( 0.0% ) | 4,023 ( 37.9% ) |
Quality Measures
Table 10. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Major Groups |
99.02%
|
0.08%
|
Fungicides and Bactericides | Total |
| Categories of products |
98.29%
|
0.35%
|
Other insecticides | Total |
| Code |
100.00%
|
7.67%
|
F06_01_22 | PES_T |
| Chemical Class |
99.14%
|
1.60%
|
MICROBIOLOGICAL FUNGICIDES | TOTAL |
| SUBSTANCES COMMON NAMES |
79.20%
|
6.08%
|
n/a | DIETHOFENCARB |
| CAS |
58.27%
|
4.43%
|
n/a | 87130-20-9 |
| CIPAC |
65.98%
|
4.95%
|
n/a | 513 |
| variable |
92.32%
|
0.12%
|
2011 | 2011 |
| value |
53.32%
|
37.88%
|
n/a | 2408170.12 |
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aReferences
There are no sources in the current document.
Annexes
Annex 1: Table column reports
Pesticide Sales Belgium
Major Groups
Table 11. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Major Groups |
| Description | Major group of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj). |
| Data type | String |
| Descriptor | reu-2022-2379:majorGroup [UID:0.0.MJRGR522] |
| Descriptor description |
The highest level at which plant protection products are summarised by Regulation (EU) 2017/269 for statistical purposes in the EU. |
| IRI | |
| Unit | n/a |
Table 12. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Major Groups | 0 - 46 | n/a | Fungicides a… | n/a | n/a | n/a | Total | 10,620 | 104 ( 1.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 8 ( 0.1% ) |
Table 13. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Major Groups |
99.02%
|
0.08%
|
Fungicides and Bactericides | Total |
Data Distribution Top 20
Figure 1. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 2. Visualization of completeness of the data in the column.
Uniqueness
Figure 3. Visualization of uniqueness of the data in the column.
Categories of products
Table 14. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Categories of products |
| Description | Category of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj). |
| Data type | String |
| Descriptor | reu-2022-2379:categoriesOfProducts [UID:0.0.CTGRF523] |
| Descriptor description |
The second highest level at which plant protection products are summarised by Regulation (EU) 2017/269 for statistical purposes in the EU. |
| IRI | |
| Unit | n/a |
Table 15. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Categories of products | 0 - 69 | n/a | Acaricides | n/a | n/a | n/a | Vegetal oils | 10,620 | 182 ( 1.7% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 37 ( 0.3% ) |
Table 16. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Categories of products |
98.29%
|
0.35%
|
Other insecticides | Total |
Data Distribution Top 20
Figure 4. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 5. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 6. Visualization of completeness of the data in the column.
Uniqueness
Figure 7. Visualization of uniqueness of the data in the column.
Code
Table 17. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Code |
| Description | Code of the group of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. |
| Data type | String |
| Descriptor | reu-2022-2379:code [UID:0.0.CDABC524] |
| Descriptor description |
The code of the group of plant protection products for which figures have to be provided according to Regulation (EU) 2017/269 for statistical purposes in the EU. |
| IRI | |
| Unit | n/a |
Table 18. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Code | 3 - 11 | n/a | F01 | n/a | n/a | n/a | ZR99_99_99 | 10,620 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 815 ( 7.7% ) |
Table 19. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Code |
100.00%
|
7.67%
|
F06_01_22 | PES_T |
Completeness
Figure 8. Visualization of completeness of the data in the column.
Uniqueness
Figure 9. Visualization of uniqueness of the data in the column.
Chemical Class
Table 20. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Chemical Class |
| Description | Chemical class of the group of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. |
| Data type | String |
| Descriptor | reu-2022-2379:chemicalClass [UID:0.0.PPPCH525] |
| Descriptor description |
The chemical class of plant protection products for which figures have to be provided according to Regulation (EU) 2017/269 for statistical purposes in the EU. |
| IRI | |
| Unit | n/a |
Table 21. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chemical Class | 0 - 114 | n/a | ALIPHATIC NI… | n/a | n/a | n/a | inorganic fu… | 10,620 | 91 ( 0.9% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 170 ( 1.6% ) |
Table 22. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Chemical Class |
99.14%
|
1.60%
|
MICROBIOLOGICAL FUNGICIDES | TOTAL |
Completeness
Figure 10. Visualization of completeness of the data in the column.
Uniqueness
Figure 11. Visualization of uniqueness of the data in the column.
SUBSTANCES COMMON NAMES
Table 23. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | SUBSTANCES COMMON NAMES |
| Description | Common name of the group of [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided according to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. |
| Data type | String |
| Descriptor | reu-2022-2379:substancesCommonName [UID:0.0.SBSTN526] |
| Descriptor description |
The common name of the group of plant protection products for which figures have to be provided according to Regulation (EU) 2017/269 for statistical purposes in the EU. |
| IRI | |
| Unit | n/a |
Table 24. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SUBSTANCES COMMON NAMES | 0 - 185 | n/a | (E)-11-TETRA… | n/a | n/a | n/a | ZUCCHINI YEL… | 10,620 | 2,209 ( 20.8% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 646 ( 6.1% ) |
Table 25. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| SUBSTANCES COMMON NAMES |
79.20%
|
6.08%
|
n/a | DIETHOFENCARB |
Completeness
Figure 12. Visualization of completeness of the data in the column.
Uniqueness
Figure 13. Visualization of uniqueness of the data in the column.
CAS
Table 26. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | CAS |
| Description | CAS registry number(s) of the [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided accoring to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. |
| Data type | String |
| Descriptor | beexml:casRegistryNumber [UID:0.0.CSRGS389] |
| Descriptor description |
A CAS Registry Number® is a unique and unambiguous identifier for a specific substance that allows clear communication and, with the help of CAS scientists, links together all available data and research about that substance. Governmental agencies rely on CAS Registry Numbers for substance identification in regulatory applications because they are unique, easy validated, and internationally recognized. |
| IRI | |
| Unit | n/a |
Table 27. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CAS | 0 - 46 | n/a | 10004-44-1 | n/a | n/a | n/a | 999-81-5 | 10,620 | 4,432 ( 41.7% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 470 ( 4.4% ) |
Table 28. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| CAS |
58.27%
|
4.43%
|
n/a | 87130-20-9 |
Completeness
Figure 14. Visualization of completeness of the data in the column.
Uniqueness
Figure 15. Visualization of uniqueness of the data in the column.
CIPAC
Table 29. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | CIPAC |
| Description | CIPAC registry code(s) of the [plant protection products](https://app.pollinatorhub.eu/dictionary/classes/2974) for which figures have to be provided accoring to [Regulation (EU) 2017/269](https://eur-lex.europa.eu/eli/reg/2017/269/oj) for statistical purposes in the EU. |
| Data type | String |
| Descriptor | beexml:cipacCodeNumber [UID:0.0.CPCCD391] |
| Descriptor description |
The CIPAC (Collaborative International Pesticides Analytical Council) code number system is a simple approach for an unambiguous coding of active ingredients and variants used in the area/field of pesticides. |
| IRI | |
| Unit | n/a |
Table 30. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CIPAC | 0 - 68 | n/a | 1 | n/a | n/a | n/a | 991 | 10,620 | 3,613 ( 34.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 526 ( 5.0% ) |
Table 31. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| CIPAC |
65.98%
|
4.95%
|
n/a | 513 |
Completeness
Figure 16. Visualization of completeness of the data in the column.
Uniqueness
Figure 17. Visualization of uniqueness of the data in the column.
variable
Table 32. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | variable |
| Description | Calendar year for which the results are provided. |
| Data type | Integer number |
| Descriptor | dwc:year [UID:0.0.YEARA340] |
| Descriptor description |
A term from the Darwin Core standard:
|
| IRI | http://rs.tdwg.org/dwc/terms/year |
| Unit | year |
Table 33. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| variable | 4 - 4 | 2,016.5 | 2,011 | 2,013.25 | 2,016.5 | 2,019.75 | 2,022 | 10,620 | 816 ( 7.7% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 13 ( 0.1% ) |
Table 34. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| variable |
92.32%
|
0.12%
|
2011 | 2011 |
Data Distribution Top 20
Figure 18. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 19. Distribution of values in the column.
Outliers
Figure 20. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 21. Visualization of completeness of the data in the column.
Uniqueness
Figure 22. Visualization of uniqueness of the data in the column.
value
Table 35. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | value |
| Description | Amount of [plant protection products](https://app.pollinatorhub.eu/vocabulary/classes/2974) of a specific [chemical class](https://app.pollinatorhub.eu/vocabulary/classes/3321) sold in a given [calendar year](calendar year) in [Belgium](https://app.pollinatorhub.eu/vocabulary/classes/173) in [kg](https://app.pollinatorhub.eu/vocabulary/classes/586). ). |
| Data type | Decimal number |
| Descriptor | DecimalNumber [UID:0.0.DCMLN314] |
| Descriptor description |
A decimal numeral (also often just decimal or, less correctly, decimal number), refers generally to the notation of a number in the decimal numeral system. Decimals may sometimes be identified by a decimal separator (usually "." or "," as in 25.9703 or 3,1415).[3] Decimal may also refer specifically to the digits after the decimal separator, such as in "3.14 is the approximation of π to two decimals". Zero-digits after a decimal separator serve the purpose of signifying the precision of a value. |
| IRI | |
| Unit | kg |
Table 36. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest
value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column
(Max);
number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and
of
distinct values including NULL, Zero and blank (Distinct).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| value | 0 - 10 | n/a | 0.0 | n/a | n/a | n/a | D | 10,620 | 4,957 ( 46.7% ) | 832 ( 7.8% ) | 0 ( 0.0% ) | 4,023 ( 37.9% ) |
Table 37. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most
Common
Value); least common value in the column (Least Common Value).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| value |
53.32%
|
37.88%
|
n/a | 2408170.12 |
Completeness
Figure 23. Visualization of completeness of the data in the column.
Uniqueness
Figure 24. Visualization of uniqueness of the data in the column.