EU Pollinator Hub

, ,
• •
Dataset Report
Unique identifier: RGLTN80.0.0
Title: Regulation (EU) 2017/269
Long title: The Harmonised classification of substances according to Regulation (EU) 2017/269 amending Regulation (EC) No 1185/2009.
Status: Quality Validated
Current Version: v. 1.0
Published: 2023-12-14
Reviewed by:
Citation proposal:
EU Pollinator Hub 2023 Report of dataset Regulation (EU) 2017/269, v. 1.0 [RGLTN80.0.0]. EU Pollinator Hub. [2025-07-06] 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 2023-12-14.

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 2023-12-14 00:12:00 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 euph_000046_eu-regulation-2017-269_table_harmonised_cas.csv CSV - Comma seperated values Yes No 2023-12-13 18:12:40 908 11.57 KiB
2 euph_000046_eu-regulation-2017-269_table_harmonised_cibac.csv CSV - Comma seperated values Yes No 2023-12-13 17:12:46 990 9.30 KiB
3 euph_000046_eu-regulation-2017-269_table_harmonised_classification.csv CSV - Comma seperated values Yes No 2023-12-15 15:12:18 4,176 44.07 KiB

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 Harmonised classification - CAS The tabe contains the CAS codes corrisponding to a given code of the harmonised classification of substances.
2 Harmonised classification - CIPAC The tabe contains the CIPA codes corrisponding to a given code of the harmonised classification of substances.
3 Harmonised classification The table contains a summary of the table in annex III of Commission Regulation (EU) 2017/269 of 16 February 2017…
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid RGLTN80.0.0
Title Regulation (EU) 2017/269
Long title The Harmonised classification of substances according to Regulation (EU) 2017/269 amending Regulation (EC) No 1185/2009.
Target IRI https://app.pollinatorhub.eu/dataset-discovery/RGLTN80.0.0
interactions.single.section-details.licence CC BY 4.0
DOI n/a
Created 2023-12-13
Published 2023-12-14
Contact n/a
Keywords EU, pesticide
Data collection years n/a
Regions, the data was collected in n/a
Abstract

The dataset contains the harmonised classification of substances contained in annex III of Commission Regulation (EU) 2017/269 of 16 February 2017 amending Regulation (EC) No 1185/2009 of the European Parliament and of the Council concerning statistics on pesticides, as regards the list of active substances.
Table 5. Standardised metadata of the data provider EU Pollinator Hub. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name EU Pollinator Hub
Url
Acronym EUPH
IRI https://app.pollinatorhub.eu/data-providers/euph
Address
Country Belgium
Contact https://www.linkedin.com/company/beelife-european-beekeeping-coordination/ pollinatorhub.eu
Description

The EU Pollinator Hub (EUPH) is a data hub related to pollinators, which is provided by the European Food Safety Authority (EFSA).

Tables

Harmonised classification - CAS

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier RGLTN80.HRMNS149.0
Name Harmonised classification - CAS
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/RGLTN80.HRMNS149.0
Table Type File
Licence CC BY 4.0
Description

The tabe contains the CAS codes corrisponding to a given code of the harmonised classification of substances.

The tabe contains the CAS codes corrisponding to a given code of the harmonised classification of substances.

Metadata

n/a
Table 7. 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
code

Code of the Harmonised Classification of Substances

 String Text [0.0.TEXTA315]

n/a
cas

Chemical Abstracts Service registry numbers.

 String Text [0.0.TEXTA315]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 8. 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
code 9 - 11 n/a F01_01_01 n/a n/a n/a ZR99_99_12 454 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 424 ( 93.4% )
cas 7 - 12 n/a 10004-44-1 n/a n/a n/a 999-81-5 454 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 450 ( 99.1% )

Quality measures

Table 9. 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%
93.39%
I01_01_15 F01_01_01
cas
100.00%
99.12%
52315-07-8 8011-63-0

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Harmonised classification - CIPAC

Table 10. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier RGLTN80.HRMNS150.0
Name Harmonised classification - CIPAC
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/RGLTN80.HRMNS150.0
Table Type File
Licence CC BY 4.0
Description

The tabe contains the CIPA codes corrisponding to a given code of the harmonised classification of substances.

The tabe contains the CIPA codes corrisponding to a given code of the harmonised classification of substances.

Metadata

n/a
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).
Column Name Column Description Datatype Descriptor Unit
code

Code of the harmonised classification of substances

 String Text [0.0.TEXTA315]

n/a
cibac

Code of the Collaborative International Pesticides Analytical Council.

 Decimal number DecimalNumber [0.0.DCMLN314]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
code 6 - 11 n/a F01_01_01 n/a n/a n/a ZR99_99_24 495 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 472 ( 95.4% )
cibac 1 - 7 619.7703 1 451 660 845 982 495 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 493 ( 99.6% )

Quality measures

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
code
100.00%
95.35%
F06_01_14 F01_01_01
cibac
100.00%
99.60%
946 44.604

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Harmonised classification

Table 14. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier RGLTN80.HRMNS151.0
Name Harmonised classification
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/RGLTN80.HRMNS151.0
Table Type File
Licence CC BY 4.0
Description

The table contains a summary of the table in annex III of Commission Regulation (EU) 2017/269 of 16 February 2017 amending Regulation (EC) No 1185/2009 of the European Parliament and of the Council concerning statistics on pesticides, as regards the list of active substances.

The table contains a summary of the table in annex III of Commission Regulation (EU) 2017/269 of 16 February 2017 amending Regulation (EC) No 1185/2009 of the European Parliament and of the Council concerning statistics on pesticides, as regards the list of active substances.

Metadata

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 Column Description Datatype Descriptor Unit
id

Identifier of the record.

 String Text [0.0.TEXTA315]

n/a
code

Code of the harmonised classification of substances

 String Text [0.0.TEXTA315]

n/a
description

Name of of the item.

 String Text [0.0.TEXTA315]

n/a
aggregate

Aggregate level of the reported item (majorgroups: highest aggregation level, major groups in the harmonised classification of substances; category: second aggregation level, categories of products; class: third aggregation level, chemical classes; substance: fourth aggregation level, active substances in plant protection products).

 String Text [0.0.TEXTA315]

n/a
euph_code

Unique identifier of a class on the EU Pollinator Hub.

 Integer number Integer [0.0.NTGER313]

n/a
parent

Superior aggregate level of the reported item.

 String Text [0.0.TEXTA315]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 16. 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
id 1 - 3 348.5 1 174.25 348.5 522.75 696 696 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 696 ( 100.0% )
code 3 - 11 n/a F01 n/a n/a n/a ZR99_99_99 696 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 696 ( 100.0% )
description 4 - 81 n/a (2E, 13Z)-OC… n/a n/a n/a ZUCCHINI YEL… 696 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 673 ( 96.7% )
aggregate 5 - 10 n/a category n/a n/a n/a substance 696 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.6% )
euph_code 4 - 4 3,092.8 3,009 3,049.25 3,090.5 3,131.75 3,358 696 532 ( 76.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 165 ( 23.7% )
parent 1 - 3 367.3 1 183.25 350 565 743 696 6 ( 0.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 162 ( 23.3% )

Quality measures

Table 17. 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
id
100.00%
100.00%
1 1
code
100.00%
100.00%
PES_F PES_F
description
100.00%
96.70%
OTHER INORGANIC FUNGICIDES Fungicides and Bactericides
aggregate
100.00%
0.57%
substance majorgroup
euph_code
23.56%
23.71%
3009 3009
parent
99.14%
23.28%
568 10

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Table references

  1. EU 2017 Commission Regulation (EU) 2017/269 of 16 February 2017 amending Regulation (EC) No 1185/2009 of the European Parliament and of the Council concerning statistics on pesticides, as regards the list of active substances (Text with EEA relevance. ). [2023-2-8] eur-lex.europa.eu

References

  1. Anonymous L_2017040EN.01000401.xml. [2023-12-13] eur-lex.europa.eu

Annex 1: Table column reports

Table: Harmonised classification - CAS

Column: code

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).
Parameter Content
Column name code
Description

Code of the Harmonised Classification of Substances
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 19. 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 9 - 11 n/a F01_01_01 n/a n/a n/a ZR99_99_12 454 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 424 ( 93.4% )
Table 20. 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%
93.39%
I01_01_15 F01_01_01

Completeness

Figure 1. Visualization of completeness of the data in the column.

Uniqueness

Figure 2. Visualization of uniqueness of the data in the column.

Column: cas

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).
Parameter Content
Column name cas
Description

Chemical Abstracts Service registry numbers.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 22. 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 7 - 12 n/a 10004-44-1 n/a n/a n/a 999-81-5 454 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 450 ( 99.1% )
Table 23. 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
100.00%
99.12%
52315-07-8 8011-63-0

Completeness

Figure 3. Visualization of completeness of the data in the column.

Uniqueness

Figure 4. Visualization of uniqueness of the data in the column.

Table: Harmonised classification - CIPAC

Column: code

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).
Parameter Content
Column name code
Description

Code of the harmonised classification of substances
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 25. 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 6 - 11 n/a F01_01_01 n/a n/a n/a ZR99_99_24 495 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 472 ( 95.4% )
Table 26. 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%
95.35%
F06_01_14 F01_01_01

Completeness

Figure 5. Visualization of completeness of the data in the column.

Uniqueness

Figure 6. Visualization of uniqueness of the data in the column.

Column: cibac

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).
Parameter Content
Column name cibac
Description

Code of the Collaborative International Pesticides Analytical Council.
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

n/a
Table 28. 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
cibac 1 - 7 619.7703 1 451 660 845 982 495 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 493 ( 99.6% )
Table 29. 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
cibac
100.00%
99.60%
946 44.604

Continuous Data Distribution

Figure 7. Distribution of values in the column.

Outliers

Figure 8. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 9. Visualization of completeness of the data in the column.

Uniqueness

Figure 10. Visualization of uniqueness of the data in the column.

Table: Harmonised classification

Column: id

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).
Parameter Content
Column name id
Description

Identifier of the record.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 31. 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
id 1 - 3 348.5 1 174.25 348.5 522.75 696 696 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 696 ( 100.0% )
Table 32. 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
id
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 11. Distribution of values in the column.

Outliers

Figure 12. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 13. Visualization of completeness of the data in the column.

Uniqueness

Figure 14. Visualization of uniqueness of the data in the column.

Column: code

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).
Parameter Content
Column name code
Description

Code of the harmonised classification of substances
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 34. 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 696 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 696 ( 100.0% )
Table 35. 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%
100.00%
PES_F PES_F

Completeness

Figure 15. Visualization of completeness of the data in the column.

Uniqueness

Figure 16. Visualization of uniqueness of the data in the column.

Column: description

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).
Parameter Content
Column name description
Description

Name of of the item.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 37. 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
description 4 - 81 n/a (2E, 13Z)-OC… n/a n/a n/a ZUCCHINI YEL… 696 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 673 ( 96.7% )
Table 38. 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
description
100.00%
96.70%
OTHER INORGANIC FUNGICIDES Fungicides and Bactericides

Completeness

Figure 17. Visualization of completeness of the data in the column.

Uniqueness

Figure 18. Visualization of uniqueness of the data in the column.

Column: aggregate

Table 39. 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 aggregate
Description

Aggregate level of the reported item (majorgroups: highest aggregation level, major groups in the harmonised classification of substances; category: second aggregation level, categories of products; class: third aggregation level, chemical classes; substance: fourth aggregation level, active substances in plant protection products).
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 40. 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
aggregate 5 - 10 n/a category n/a n/a n/a substance 696 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.6% )
Table 41. 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
aggregate
100.00%
0.57%
substance majorgroup

Data Distribution Top 20

Figure 19. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 20. Visualization of completeness of the data in the column.

Uniqueness

Figure 21. Visualization of uniqueness of the data in the column.

Column: euph_code

Table 42. 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 euph_code
Description

Unique identifier of a class on the EU Pollinator Hub.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 43. 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
euph_code 4 - 4 3,092.8 3,009 3,049.25 3,090.5 3,131.75 3,358 696 532 ( 76.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 165 ( 23.7% )
Table 44. 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
euph_code
23.56%
23.71%
3009 3009

Continuous Data Distribution

Figure 22. Distribution of values in the column.

Outliers

Figure 23. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 24. Visualization of completeness of the data in the column.

Uniqueness

Figure 25. Visualization of uniqueness of the data in the column.

Column: parent

Table 45. 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 parent
Description

Superior aggregate level of the reported item.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 46. 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
parent 1 - 3 367.3 1 183.25 350 565 743 696 6 ( 0.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 162 ( 23.3% )
Table 47. 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
parent
99.14%
23.28%
568 10

Continuous Data Distribution

Figure 26. Distribution of values in the column.

Outliers

Figure 27. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 28. Visualization of completeness of the data in the column.

Uniqueness

Figure 29. Visualization of uniqueness of the data in the column.