, ,
• •

Dataset Report

Unique identifier:	UNSDA25.0.0
Title:	UNSD
Long title:	World Customs Organization/UN Comtrade Supplementary Quantity Units
Status:	Quality Validated
Current Version:	v. 1.0
Published:	2023-02-04
Reviewed by:
Citation proposal:	EU Pollinator Hub 2023 Report of dataset UNSD, v. 1.0 [UNSDA25.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

Table of content

Document history
1. Release
2. Revision
Abbreviations
Executive summary
Introduction
Material and methods
Data description
1. Dataset
2. Tables
  1. Un Comtrade Units
References
Annex 1: Table column reports

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

EUPH

EU Pollinator Hub

UNSD

United Nations Statistics Division

WCO

World Customs Organization

n.a.

not available

Executive summary

Data overview:

The dataset contains quantity units used in detailed UN Comtrade data, which is maintained by the United Nations Statistics Division (UNSD). These units of measurement are based on the standards of quantity recommended by the World Customs Organization (WCO).

Data value:

The dataset is required by the EUPH for administrative purposes and fulfils an important role in data standardisation across datasets.

Data description:

File wcoomd_units.csv contains 13 records of units used in detailed UN Comtrade data.

Data application:

This data will be used for the standardisation of data integrated on the EU Pollinator Hub (EUPH).

Unresolved issues:

n/a

Introduction

Standardisation is an important goal of the EU Pollinator Hub (EUPH). Existing standards are prioritised to achieve this goal. The dataset contains quantity units used in detailed UN Comtrade data, which is maintained by the United Nations Statistics Division (UNSD). These units of measurement are based on the standards of quantity recommended by the World Customs Organization (WCO). The dataset is intended for internal use on the EU Pollinator Hub.

Material and methods

Data acquisition

Raw data integrated into this dataset consists of 2 files:

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_000025_unsd_table_uncomtradeunits.csv	CSV - Comma seperated values	Yes	No	2025-02-14 12:02:07	39	483.00 B

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	Un Comtrade Units	This table contains quantity units used in detailed UN Comtrade data, based on the standards of quantity recommended by the…

Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).

Parameter	Content
interactions.single.uid	UNSDA25.0.0
Title	UNSD
Long title	World Customs Organization/UN Comtrade Supplementary Quantity Units
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/UNSDA25.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	The dataset contains quantity units used in detailed UN Comtrade data, which is maintained by the United Nations Statistics Division (UNSD), servingh under the United Nations Department of Economic and Social Affairs as the central mechanism within the Secretariat of the United Nations to supply the statistical needs and coordinating activities of the global statistical system. The units of measurement are based on the standards of quantity recommended by the World Customs Organization (WCO).

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

Un Comtrade Units

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).

Parameter	Content
Unique identifier	UNSDA25.NCMTR5.0
Name	Un Comtrade Units
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/UNSDA25.NCMTR5.0
Table Type	File
Licence	EU Pollinator Hub
Description	This table contains quantity units used in detailed UN Comtrade data, based on the standards of quantity recommended by the World Customs Organization (WCO).

This table contains quantity units used in detailed UN Comtrade data, based on the standards of quantity recommended by the World Customs Organization (WCO).

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	Datatype	Descriptor	Unit
UnsdId	Integer number	unsd:unsdUnitID [0.0.NSDNT849]	n/a
WCOAbbreviation	String	Text [0.0.TEXTA315]	n/a
Description	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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
UnsdId	1 - 2	7.0	1	3.5	7	10.5	13	13	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 100.0% )
WCOAbbreviation	0 - 12	n/a		n/a	n/a	n/a	U (jeu/pack)	13	1 ( 7.7% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 100.0% )
Description	11 - 48	n/a	No quantity	n/a	n/a	n/a	Electrical e…	13	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 100.0% )

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
UnsdId	100.00%	100.00%	1	1
WCOAbbreviation	92.31%	100.00%	null	null
Description	100.00%	100.00%	No quantity	No quantity

Changes made to preparatory file

None

Changes made to data

None

Unresolved issues

None

References

There are no sources in the current document.

Annex 1: Table column reports

Table: Un Comtrade Units

Column: UnsdId

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	UnsdId
Description
Data type	Integer number
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 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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
UnsdId	1 - 2	7.0	1	3.5	7	10.5	13	13	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 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
UnsdId	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: WCOAbbreviation

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	WCOAbbreviation
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 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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
WCOAbbreviation	0 - 12	n/a		n/a	n/a	n/a	U (jeu/pack)	13	1 ( 7.7% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 100.0% )

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
WCOAbbreviation	92.31%	100.00%	null	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: Description

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	Description
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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
Description	11 - 48	n/a	No quantity	n/a	n/a	n/a	Electrical e…	13	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 100.0% )

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
Description	100.00%	100.00%	No quantity	No quantity

Completeness

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

Uniqueness

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