EU Pollinator Hub

, ,
• •
Dataset Report
Unique identifier: UNITS7.0.0
Title: Units
Long title: EUPH Reference dataset containing units
Status: Quality Validated
Current Version: v. 1.0
Published: 2023-02-04
Reviewed by:
Citation proposal:
EU Pollinator Hub 2023 Report of dataset Units, v. 1.0 [UNITS7.0.0]. EU Pollinator Hub. [2026-02-24] 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-02-04.

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-02-04 00:02:00 Initial release. n/a

Abbreviations

BIPM
Bureau International des Poids et Mesures
EFSA
European Food Safety Authority
EUPH
EU Pollinator Hub
FAO
Food and Agriculture Organization of the United Nations
ISO
International Organization for Standardization
UNSD
United Nations Statistics Division
n.a.
not available

Executive summary

Data overview:

The reference dataset for units contains a collection of units used by other datasets. Data sources in their original state were merged into one single table. If available, identifiers and descriptions of the original datasets are maintained to guaranty their integrity and to enable linkage across datasets.

Data value:

The dataset provides a unique identifier for all units to be integrated on the platform. It is required by the EU Pollinator Hub (EUPH) for administrative purposes and fulfils an important role in data standardisation across datasets.

Data description:

The dataset contains 1 table. Units and their descriptions were obtained from 3 sources: from the United Nations Statistics Division (UNSD), from the Bureau International des Poids et Mesures (BIPM), from the Statistics Division of the Food and Agriculture Organization of the United Nations (FAOSTAT) and from the Organization for Standardization (ISO).

Data application:

This data will be used for the standardisation of data integrated on the EUPH by data providers.

Unresolved issues:

n/a

Introduction

Standardisation is an important goal of the EU Pollinator Hub (EUPH). Existing standards are prioritised to achieve this goal. Variables are described by numerical facts which we call data. Data is commonly expressed in a unit, which is one of many attributes that may be used to classify data. On the EUPH a unit is treated as metadata. One important goal of the EUPH is to allow users to link data from different sources. It is therefore necessary to provide a standardised description of the data, including units. The general policy of the EUPH is not to modify raw data once it has been prepared for integration. Since the EUPH aims to allow analysis and visualisation of data on the spot, converting the data to a common unit may represent a major challenge, both in terms of usability during the process of data integration and time required for data processing. It has therefor been decided that data will be standardised during the integration process. When data is integrated on the platform, data providers define the unit in which the data to be integrated is expressed from a list of preconfigured set of units (base units and derived units as well as decimal multiples and sub-multiples of the units). If the preconfigured set of units does not meet the requirements of the data provider, the provider has to transform the data to an accepted unit before integration. There is a potentially unlimited number of derived units. Depending on the future management of the EUPH, the user might therefore also request the integration of a unit into the EUPH. The present dataset contains a preconfigured set of units used by international standardising organisations (SI, ISO, United Nations) and the information required for the conversion of units into base units. This allows linkage and visualisation in a variety of units on the EUPH.

Material and methods

Data acquisition

Raw data integrated into this dataset comes from 4 different sources on the EUPH:

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_000007_units_table_units.csv CSV - Comma seperated values Yes No 2023-09-01 10:09:26 5,808 n/a

Data preparation

Data was copied into a Microsoft® Excel® worksheet (Microsoft Corporation, Version 2210 Build 16.0.15726.20188). Prepared data was then converted to CSV and imported for profiling into a SQL database (MariaDB foundation, Server-Version 10.4.24) running in a XAMPP environment (BitRock, version 3.3.0). Data was exported from the MySQL database to CSV format using utf-8 coding. Data profiling was performed according to SOP-005 Data profiling using phpMyAdmin (version 5.2.0).

Data validation

None

Data analysis

None

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 Units Data in this table was obtained from various sources. It contains standardised information on units, including standardised units, decimal multiples…
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid UNITS7.0.0
Title Units
Long title EUPH Reference dataset containing units
Target IRI https://app.pollinatorhub.eu/dataset-discovery/UNITS7.0.0
interactions.single.section-details.licence EU Pollinator Hub
DOI n/a
Created 2022-11-26
Published 2023-02-04
Contact n/a
Keywords n/a
Data collection years n/a
Regions, the data was collected in n/a
Abstract

This dataset contains standardised information on units.
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

Units

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier UNITS7.UNITS4.0
Name Units
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/UNITS7.UNITS4.0
Table Type File
Licence EU Pollinator Hub
Description

Data in this table was obtained from various sources. It contains standardised information on units, including standardised units, decimal multiples and submultiples, information on how to convert units to base units (function and conversion factor), as well as the name of the quantities, which these units describe, to be used for data standardisation on the EU Pollinator Hub (EUPH).

Data in this table was obtained from various sources. It contains standardised information on units, including standardised units, decimal multiples and submultiples, information on how to convert units to base units (function and conversion factor), as well as the name of the quantities, which these units describe, to be used for data standardisation on the EU Pollinator Hub (EUPH).

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
UnitId
Integer number pms:unitID [0.0.NITID86]

n/a
UnitName
String dwc:measurementUnit [0.0.NTNME87]

n/a
UnitStandardised
String Text [0.0.TEXTA315]

n/a
QuantityDescription
String Text [0.0.TEXTA315]

n/a
UnitDescription
String Text [0.0.TEXTA315]

n/a
BaseUnit
String Text [0.0.TEXTA315]

n/a
ConFunct
String Text [0.0.TEXTA315]

n/a
Multiplier
String Text [0.0.TEXTA315]

n/a
FaostatUnit
String faostat:Unit [0.0.UNITA94]

n/a
UnsdUnit
String unsd:unsdUnitID [0.0.NSDNT849]

n/a
SiUnit
String bipm:siUnit [0.0.SNITA850]

n/a
CurrencyUnit
String iso-4217:aphabeticCurrencyCode [0.0.PHBTC851]

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
UnitId 1 - 3 242.5 1 121.25 242.5 363.75 484 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 484 ( 100.0% )
UnitName 0 - 23 n/a n/a n/a n/a units/100 km… 484 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% ) 468 ( 96.7% )
UnitStandardised 1 - 54 n/a % n/a n/a n/a (102 km2 lan… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 467 ( 96.5% )
QuantityDescription 4 - 36 n/a NULL n/a n/a n/a activity ref… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 78 ( 16.1% )
UnitDescription 3 - 65 n/a Lek n/a n/a n/a The codes as… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 440 ( 90.9% )
BaseUnit 1 - 19 n/a % n/a n/a n/a g N2O/kg dry… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 413 ( 85.3% )
ConFunct 4 - 4 n/a NULL n/a n/a n/a NULL 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Multiplier 4 - 13 n/a NULL n/a n/a n/a 2.777778 E-0… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 30 ( 6.2% )
FaostatUnit 1 - 30 n/a % n/a n/a n/a per 100 squa… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 59 ( 12.2% )
UnsdUnit 1 - 4 n/a 1 n/a n/a n/a NULL 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 2.7% )
SiUnit 3 - 31 n/a bel n/a n/a n/a watt per squ… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 78 ( 16.1% )
CurrencyUnit 3 - 4 n/a ADP n/a n/a n/a NULL 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 304 ( 62.8% )

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
UnitId
100.00%
100.00%
1 1
UnitName
100.00%
96.69%
kt null
UnitStandardised
100.00%
96.49%
10<sup>3</sup> t NULL
QuantityDescription
100.00%
16.12%
monetary value power
UnitDescription
100.00%
90.91%
thousand tonnes percent
BaseUnit
100.00%
85.33%
kg %
ConFunct
100.00%
0.21%
NULL NULL
Multiplier
100.00%
6.20%
1 E+00 2.388915 E-07
FaostatUnit
100.00%
12.19%
NULL %
UnsdUnit
100.00%
2.69%
NULL 1
SiUnit
100.00%
16.12%
NULL metre
CurrencyUnit
100.00%
62.81%
NULL EUR

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

References

There are no sources in the current document.

Annex 1: Table column reports

Table: Units

Column: UnitId

Table 10. 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 UnitId
Description
Data type Integer number
Descriptor pms:unitID [UID:0.0.NITID86]
Descriptor description

Identifier of a measurement unit. May be a global unique identifier or an identifier specific to a collection or institution.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NITID86
Unit

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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
UnitId 1 - 3 242.5 1 121.25 242.5 363.75 484 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 484 ( 100.0% )
Table 12. 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
UnitId
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 1. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: UnitName

Table 13. 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 UnitName
Description
Data type String
Descriptor dwc:measurementUnit [UID:0.0.NTNME87]
Descriptor description

a label that is part of a scalar measurement datum and denotes a unit of measure.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTNME87
Unit

n/a
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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
UnitName 0 - 23 n/a n/a n/a n/a units/100 km… 484 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% ) 468 ( 96.7% )
Table 15. 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
UnitName
100.00%
96.69%
kt null

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: UnitStandardised

Table 16. 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 UnitStandardised
Description
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 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
UnitStandardised 1 - 54 n/a % n/a n/a n/a (102 km2 lan… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 467 ( 96.5% )
Table 18. 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
UnitStandardised
100.00%
96.49%
10<sup>3</sup> t NULL

Completeness

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

Uniqueness

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

Column: QuantityDescription

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).
Parameter Content
Column name QuantityDescription
Description
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 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
QuantityDescription 4 - 36 n/a NULL n/a n/a n/a activity ref… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 78 ( 16.1% )
Table 21. 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
QuantityDescription
100.00%
16.12%
monetary value power

Completeness

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

Uniqueness

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

Column: UnitDescription

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).
Parameter Content
Column name UnitDescription
Description
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 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
UnitDescription 3 - 65 n/a Lek n/a n/a n/a The codes as… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 440 ( 90.9% )
Table 24. 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
UnitDescription
100.00%
90.91%
thousand tonnes percent

Completeness

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

Uniqueness

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

Column: BaseUnit

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).
Parameter Content
Column name BaseUnit
Description
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 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
BaseUnit 1 - 19 n/a % n/a n/a n/a g N2O/kg dry… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 413 ( 85.3% )
Table 27. 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
BaseUnit
100.00%
85.33%
kg %

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: ConFunct

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).
Parameter Content
Column name ConFunct
Description
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 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ConFunct 4 - 4 n/a NULL n/a n/a n/a NULL 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 30. 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
ConFunct
100.00%
0.21%
NULL NULL

Data Distribution Top 20

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

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: Multiplier

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).
Parameter Content
Column name Multiplier
Description
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 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Multiplier 4 - 13 n/a NULL n/a n/a n/a 2.777778 E-0… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 30 ( 6.2% )
Table 33. 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
Multiplier
100.00%
6.20%
1 E+00 2.388915 E-07

Completeness

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

Uniqueness

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

Column: FaostatUnit

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).
Parameter Content
Column name FaostatUnit
Description
Data type String
Descriptor faostat:Unit [UID:0.0.UNITA94]
Descriptor description

Unit in which FAOSTAT provides data, summarised in the "Units" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.UNITA94
Unit

n/a
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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
FaostatUnit 1 - 30 n/a % n/a n/a n/a per 100 squa… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 59 ( 12.2% )
Table 36. 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
FaostatUnit
100.00%
12.19%
NULL %

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: UnsdUnit

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).
Parameter Content
Column name UnsdUnit
Description
Data type String
Descriptor unsd:unsdUnitID [UID:0.0.NSDNT849]
Descriptor description

Special units maintained by the United Nations Statistics Division (UNSD)).
Descriptor target IRI https://app.pollinatorhub.eu/dashboard/descriptors/849
Unit

n/a
Table 38. 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
UnsdUnit 1 - 4 n/a 1 n/a n/a n/a NULL 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 2.7% )
Table 39. 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
UnsdUnit
100.00%
2.69%
NULL 1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: SiUnit

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).
Parameter Content
Column name SiUnit
Description
Data type String
Descriptor bipm:siUnit [UID:0.0.SNITA850]
Descriptor description

The International System of Units (Système International d'Unités). maintained by the Bureau International des Poids et Mesures (BIPM) is a recommended practical system of units of measurement, with the international abbreviation SI.
Descriptor target IRI https://app.pollinatorhub.eu/dashboard/descriptors/850
Unit

n/a
Table 41. 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
SiUnit 3 - 31 n/a bel n/a n/a n/a watt per squ… 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 78 ( 16.1% )
Table 42. 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
SiUnit
100.00%
16.12%
NULL metre

Completeness

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

Uniqueness

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

Column: CurrencyUnit

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).
Parameter Content
Column name CurrencyUnit
Description
Data type String
Descriptor iso-4217:aphabeticCurrencyCode [UID:0.0.PHBTC851]
Descriptor description

A three-letter code from ISO 4217 that represents a currency.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PHBTC851
Unit

n/a
Table 44. 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
CurrencyUnit 3 - 4 n/a ADP n/a n/a n/a NULL 484 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 304 ( 62.8% )
Table 45. 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
CurrencyUnit
100.00%
62.81%
NULL EUR

Completeness

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

Uniqueness

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