EU Pollinator Hub

, ,
• •
Dataset Report
Unique identifier: PSTCD102.0.0
Title: Pesticides Sales Belgium
Long title: Sales of pesticides in Belgium
Status: Quality Validated
Current Version: v. 1.0
Published: 2024-12-11
Reviewed by:
Citation proposal:
Noa Simon Delso, Michael Rubinigg 2024 Report of dataset Pesticides Sales Belgium, v. 1.0 [PSTCD102.0.0]. EU Pollinator Hub. [2025-06-01] app.pollinatorhub.eu
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
Under evaluation

Document history

Release

Version v. 1.0 released on 2024-12-11.

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 2024-12-11 13:12:09 Initial release. n/a

Abbreviations

No abbreviations.

Executive summary

Data overview:

n/a

Data value:

n/a

Data description:

n/a

interactions.single.section-about.data-overview-application:

n/a

Unresolved issues:

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

Raw data file BE_PPP AS Sales 2011-2022.csv uploaded by the data provider was re-processed (cleaned, parsed) with Notepad++ (v8.7.1). The cleaned file was unpivoted using UnpivotToCsv.py.

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
interactions.single.uid PSTCD102.0.0
Title Pesticides Sales Belgium
Long title Sales of pesticides in Belgium
Target IRI https://app.pollinatorhub.eu/dataset-discovery/PSTCD102.0.0
interactions.single.section-details.licence n/a
DOI n/a
Created 2024-04-30
Published 2024-12-11
Contact simon@bee-life.eu
Keywords Belgium, pesticides, pesticides sales
Data collection years 2011-2022
Regions, the data was collected in Belgique/België
Abstract

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 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 https://orcid.org/0000-0002-7061-920X https://www.linkedin.com/in/rubinigg/
Description

Tables

Pesticide Sales Belgium

Table 7. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier PSTCD102.PSTCD526.0
Name Pesticide Sales Belgium
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/PSTCD102.PSTCD526.0
Table Type File
Licence n/a
Description

Pesticide sales data from Belgium per active ingredient.

Pesticide sales data from Belgium per active ingredient.

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).
Column Name Column Description Datatype Descriptor Unit
Major Groups

Major group of plant protection products according to Regulation (EU) 2017/269.

 String rec-1185-2009:majorGroup [0.0.MJRGR522]

n/a
Categories of products

Category of plant protection products according to Regulation (EU) 2017/269.

 String rec-1185-2009:categoriesOfProducts [0.0.CTGRF523]

n/a
Code

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.

 String rec-1185-2009:code [0.0.CDABC524]

n/a
Chemical Class

Chemical class 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.

 String rec-1185-2009:chemicalClass [0.0.PPPCH525]

n/a
SUBSTANCES COMMON NAMES

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.

 String rec-1185-2009:substancesCommonName [0.0.SBSTN526]

n/a
CAS

CAS registry number(s) of the plant protection products for which figures have to be provided accoring to Regulation (EU) 2017/269 for statistical purposes in the EU.

 String pms:casRegistryNumber [0.0.CSRGS389]

n/a
CIPAC

CIPAC registry code(s) of the plant protection products for which figures have to be provided accoring to Regulation (EU) 2017/269 for statistical purposes in the EU.

 String unsd:cipacCodeNumber [0.0.CPCCD391]

n/a
variable

Calendar year for which the results are provided.

 Integer number dwc:year [0.0.YEARA340]

year
value

Amount of plant protection products of a specific chemical class sold in a given [calendar year](calendar year) in Belgium in kg.

).

 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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/a

Changes made to data

  1. Multiple occurrences of quotation marks used to enclose column headers (24 occurrences) were removed.
  2. Thousand separators (1694 occurrences) used in some, but not all numbers were removed using regular expressions.
  3. Character sequence {-} representing missing values (4145 occurrences) were replaced by {NULL}.
  4. Blank characters (51 occurrences) were replaced by {NULL}.
  5. Missing values (1264 occurrences) were replaced by {NULL}.
  6. All columns were enclosed with quotation marks.

Unresolved issues

n/a

References

There are no sources in the current document.

Annex 1: Table column reports

Table: Pesticide Sales Belgium

Column: Major Groups

Table 11. 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).
Parameter Content
Column name Major Groups
Description

Major group of plant protection products according to Regulation (EU) 2017/269.
Data type String
Descriptor rec-1185-2009: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.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MJRGR522
Unit

n/a
Table 12. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.

Column: Categories of products

Table 14. 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).
Parameter Content
Column name Categories of products
Description

Category of plant protection products according to Regulation (EU) 2017/269.
Data type String
Descriptor rec-1185-2009: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.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CTGRF523
Unit

n/a
Table 15. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.

Column: Code

Table 17. 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).
Parameter Content
Column name Code
Description

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.
Data type String
Descriptor rec-1185-2009: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.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CDABC524
Unit

n/a
Table 18. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.

Column: Chemical Class

Table 20. 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).
Parameter Content
Column name Chemical Class
Description

Chemical class 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.
Data type String
Descriptor rec-1185-2009: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.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PPPCH525
Unit

n/a
Table 21. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.

Column: SUBSTANCES COMMON NAMES

Table 23. 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).
Parameter Content
Column name SUBSTANCES COMMON NAMES
Description

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.
Data type String
Descriptor rec-1185-2009: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.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.SBSTN526
Unit

n/a
Table 24. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.

Column: CAS

Table 26. 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).
Parameter Content
Column name CAS
Description

CAS registry number(s) of the plant protection products for which figures have to be provided accoring to Regulation (EU) 2017/269 for statistical purposes in the EU.
Data type String
Descriptor pms: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.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CSRGS389
Unit

n/a
Table 27. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.

Column: CIPAC

Table 29. 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).
Parameter Content
Column name CIPAC
Description

CIPAC registry code(s) of the plant protection products for which figures have to be provided accoring to Regulation (EU) 2017/269 for statistical purposes in the EU.
Data type String
Descriptor unsd: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.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CPCCD391
Unit

n/a
Table 30. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.

Column: variable

Table 32. 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).
Parameter Content
Column 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:

The four-digit year in which the dwc:Event occurred, according to the Common Era Calendar.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/year
Unit

year
Table 33. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.

Column: value

Table 35. 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).
Parameter Content
Column name value
Description

Amount of plant protection products of a specific chemical class sold in a given [calendar year](calendar year) in Belgium in kg.

).
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

kg
Table 36. 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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).
Column 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.