EU Pollinator Hub

, ,
• •
Dataset Report
Unique identifier: CRRNC5.0.0
Title: Currencies
Long title: EUPH reference dataset containing currencies
Status: Quality Validated
Current Version: v. 1.0
Published: 2023-01-27
Reviewed by:
Citation proposal:
EU Pollinator Hub 2023 Report of dataset Currencies, v. 1.0 [CRRNC5.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-01-27.

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

Abbreviations

EUPH
EU Pollinator Hub
ISO
International Organization for Standardization
SIX
Swiss Infrastructure and Exchange
n.a.
not available

Executive summary

Data overview:

The dataset contains ISO 4217:2015 Codes for the representation of currencies published by the Organization for Standardization (ISO) for internal use on the EU Pollinator Hub.

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 iso4217-2015.csv contains 443 records of 283 distinct current and historic currencies, funds and precious metal codes, defined by column from ISO 4217:2015 Codes for the representation of currencies, which has been published in August 2015 and subsequently reviewed and confirmed in 2021.

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 Organization for Standardization (ISO) is an important source for internationally recognized standards, for some of which ISO grants free-of-charge use. ISO 4217 is an internationally recognised and adopted, free-of-charge standard for currencies. This standard establishes internationally recognized codes for the representation of currencies that enable clarity and reduce errors. The dataset contains ISO 4217 currency codes published by and the Organization for Standardization (ISO) for internal use on the EU Pollinator Hub.

Material and methods

Data acquisition

Raw data integrated into this dataset consisting of 3 file was downloaded on 17.11.2022 from the website of the maintenance agency for ISO 4217:2015 ‘Codes for the representation of currencies’ (published on 2015-08, reviewed and confirmed in 2021), the SIX Financial Information AG [1].

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_000005_currencies_table_iso4217.csv CSV - Comma seperated values Yes No 2023-09-01 10:09:24 4,873 n/a

Data preparation

Data from the web page 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 ISO 4217:2015 This table contains codes and names for the representation of current and historic currencies, funds and precious metal codes.
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid CRRNC5.0.0
Title Currencies
Long title EUPH reference dataset containing currencies
Target IRI https://app.pollinatorhub.eu/dataset-discovery/CRRNC5.0.0
interactions.single.section-details.licence EU Pollinator Hub
DOI n/a
Created 2023-11-27
Published 2023-01-27
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 current and historic currencies, funds and precious metal codes contained in the ISO 4217 standard.
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

ISO 4217:2015

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

This table contains codes and names for the representation of current and historic currencies, funds and precious metal codes.

This table contains codes and names for the representation of current and historic currencies, funds and precious metal codes.

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
Id
Integer number Id [CRRNC5.ISOAB3.IDABC76]

n/a
Alpha3Code
String iso-3166:alpha-3CountryCode [0.0.LPHCN5]

n/a
Entity
String Entity name [CRRNC5.ISOAB3.NTTYN78]

n/a
Currency
String Currency [CRRNC5.ISOAB3.CRRNC79]

n/a
AlphabeticCode
String Alphabetic Code [CRRNC5.ISOAB3.LPHBT80]

n/a
NumericCode
String Numeric Code [CRRNC5.ISOAB3.NMRCC81]

n/a
MinorUnit
String Minor Unit [CRRNC5.ISOAB3.MNRNT82]

n/a
Definitions
String Definitions [CRRNC5.ISOAB3.DFNTN83]

n/a
WithdrawFrom
String Withdraw time [CRRNC5.ISOAB3.WTHDR84]

n/a
WithdrawTo
String Withdraw time [CRRNC5.ISOAB3.WTHDR84]

n/a
DatePublished
Date Date Published [CRRNC5.ISOAB3.DTPBL85]

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
Id 1 - 3 222.0 1 111 222 333 443 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 443 ( 100.0% )
Alpha3Code 3 - 4 n/a ABW n/a n/a n/a NULL 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 259 ( 58.5% )
Entity 4 - 58 n/a CHAD n/a n/a n/a SISTEMA UNIT… 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 276 ( 62.3% )
Currency 3 - 65 n/a Lek n/a n/a n/a The codes as… 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 283 ( 63.9% )
AlphabeticCode 3 - 4 n/a ADP n/a n/a n/a NULL 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 305 ( 68.8% )
NumericCode 3 - 4 n/a 004 n/a n/a n/a NULL 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 256 ( 57.8% )
MinorUnit 1 - 4 n/a n/a n/a n/a NULL 443 0 ( 0.0% ) 31 ( 7.0% ) 0 ( 0.0% ) 5 ( 1.1% )
Definitions 4 - 451 n/a NULL n/a n/a n/a The CLF is a… 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 10 ( 2.3% )
WithdrawFrom 4 - 7 n/a 1978 n/a n/a n/a 2018-08 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 93 ( 21.0% )
WithdrawTo 4 - 7 n/a 1981 n/a n/a n/a 1990-09 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.9% )
DatePublished 10 - 10 2,021.0 2018-08-20 2,018 2,022 2,022 2022-09-23 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.5% )

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
Id
100.00%
100.00%
1 1
Alpha3Code
100.00%
58.47%
NULL DZA
Entity
100.00%
62.30%
BRAZIL ALGERIA
Currency
100.00%
63.88%
Euro Lek
AlphabeticCode
100.00%
68.85%
EUR AFN
NumericCode
100.00%
57.79%
978 971
MinorUnit
100.00%
1.13%
2 4
Definitions
100.00%
2.26%
NULL For indexation purposes and denomination of certain financial instruments (e.g. treasury bills). The Mvdol is set daily by the Central Bank of Bolivia based on the official USD/BOB rate.
WithdrawFrom
100.00%
20.99%
NULL 2003-01
WithdrawTo
100.00%
0.90%
NULL 1990-09
DatePublished
100.00%
0.45%
2022-09-23 2018-08-20

Changes made to preparatory file

The following data was included in the of preparatory file Currencies_PREP_MR_221117.xlsx:

Changes made to data

Unresolved issues

n/a

References

There are no sources in the current document.

Querries

 

UPDATE iso4217 AS a LEFT JOIN euph_000002_countries.iso3166_1 AS b ON (CAST(UPPER(a.Entity) AS CHAR CHARACTER SET utf8) COLLATE utf8_bin) = (CAST(UPPER(b.ShortNameLcEn) AS CHAR CHARACTER SET utf8) COLLATE utf8_bin) SET a.Alpha3Code = b.Alpha3Code WHERE !ISNULL(b.ShortNameLcEn);

 

UPDATE iso4217 AS a LEFT JOIN euph_000002_countries.iso3166_1 AS b ON (CAST(UPPER(a.Entity) AS CHAR CHARACTER SET utf8) COLLATE utf8_bin) = (CAST(UPPER(b.ShortName) AS CHAR CHARACTER SET utf8) COLLATE utf8_bin) SET a.Alpha3Code = b.Alpha3Code WHERE !ISNULL(b.ShortName);

 

UPDATE iso4217 AS a LEFT JOIN euph_000002_countries.iso3166_1 AS b ON a.Alpha3Code = b.Alpha3Code SET a.Entity = b.ShortName WHERE !ISNULL(a.Alpha3code);

Annex 1: Table column reports

Table: ISO 4217:2015

Column: Id

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 Id
Description
Data type Integer number
Descriptor Id [UID:CRRNC5.ISOAB3.IDABC76]
Descriptor description

Identifier of the record.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.IDABC76
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
Id 1 - 3 222.0 1 111 222 333 443 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 443 ( 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
Id
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: Alpha3Code

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 Alpha3Code
Description
Data type String
Descriptor iso-3166:alpha-3CountryCode [UID:0.0.LPHCN5]
Descriptor description

A three-letter code that represents a country name, which is usually more closely related to the country name.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN5
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
Alpha3Code 3 - 4 n/a ABW n/a n/a n/a NULL 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 259 ( 58.5% )
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
Alpha3Code
100.00%
58.47%
NULL DZA

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

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 Entity
Description
Data type String
Descriptor Entity name [UID:CRRNC5.ISOAB3.NTTYN78]
Descriptor description

Name of the entity the currency, fund, or precious metal code refers to.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.NTTYN78
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
Entity 4 - 58 n/a CHAD n/a n/a n/a SISTEMA UNIT… 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 276 ( 62.3% )
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
Entity
100.00%
62.30%
BRAZIL ALGERIA

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

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 Currency
Description
Data type String
Descriptor Currency [UID:CRRNC5.ISOAB3.CRRNC79]
Descriptor description

Name of the currency, fund or precious metal.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.CRRNC79
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
Currency 3 - 65 n/a Lek n/a n/a n/a The codes as… 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 283 ( 63.9% )
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
Currency
100.00%
63.88%
Euro Lek

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

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 AlphabeticCode
Description
Data type String
Descriptor Alphabetic Code [UID:CRRNC5.ISOAB3.LPHBT80]
Descriptor description

Three-letter alphabetic code of the currency, fund, or precious metal.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.LPHBT80
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
AlphabeticCode 3 - 4 n/a ADP n/a n/a n/a NULL 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 305 ( 68.8% )
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
AlphabeticCode
100.00%
68.85%
EUR AFN

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

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 NumericCode
Description
Data type String
Descriptor Numeric Code [UID:CRRNC5.ISOAB3.NMRCC81]
Descriptor description

Numeric code of the currency, fund, or precious metal.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.NMRCC81
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
NumericCode 3 - 4 n/a 004 n/a n/a n/a NULL 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 256 ( 57.8% )
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
NumericCode
100.00%
57.79%
978 971

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

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 MinorUnit
Description
Data type String
Descriptor Minor Unit [UID:CRRNC5.ISOAB3.MNRNT82]
Descriptor description

Unit of recorded value (i.e. as recorded by banks) which is a division of the respective unit of the currency, fund, or precious metal.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.MNRNT82
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
MinorUnit 1 - 4 n/a n/a n/a n/a NULL 443 0 ( 0.0% ) 31 ( 7.0% ) 0 ( 0.0% ) 5 ( 1.1% )
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
MinorUnit
100.00%
1.13%
2 4

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

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 Definitions
Description
Data type String
Descriptor Definitions [UID:CRRNC5.ISOAB3.DFNTN83]
Descriptor description

Definitions of fund types.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.DFNTN83
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
Definitions 4 - 451 n/a NULL n/a n/a n/a The CLF is a… 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 10 ( 2.3% )
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
Definitions
100.00%
2.26%
NULL For indexation purposes and denomination of certain financial instruments (e.g. treasury bills). The Mvdol is set daily by the Central Bank of Bolivia based on the official USD/BOB rate.

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: WithdrawFrom

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 WithdrawFrom
Description
Data type String
Descriptor Withdraw time [UID:CRRNC5.ISOAB3.WTHDR84]
Descriptor description

Date (YYYY or YYYY-MM) at which withdrawal of currency, fund or precious metal has been started.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.WTHDR84
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
WithdrawFrom 4 - 7 n/a 1978 n/a n/a n/a 2018-08 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 93 ( 21.0% )
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
WithdrawFrom
100.00%
20.99%
NULL 2003-01

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

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 WithdrawTo
Description
Data type String
Descriptor Withdraw time [UID:CRRNC5.ISOAB3.WTHDR84]
Descriptor description

Date (YYYY or YYYY-MM) at which withdrawal of currency, fund or precious metal has been started.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.WTHDR84
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
WithdrawTo 4 - 7 n/a 1981 n/a n/a n/a 1990-09 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.9% )
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
WithdrawTo
100.00%
0.90%
NULL 1990-09

Data Distribution Top 20

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

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

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 DatePublished
Description
Data type Date
Descriptor Date Published [UID:CRRNC5.ISOAB3.DTPBL85]
Descriptor description

Publishing date of the document from which data was obtained.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/CRRNC5.ISOAB3.DTPBL85
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
DatePublished 10 - 10 2,021.0 2018-08-20 2,018 2,022 2,022 2022-09-23 443 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.5% )
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
DatePublished
100.00%
0.45%
2022-09-23 2018-08-20

Data Distribution Top 20

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

Outliers

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

Completeness

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

Uniqueness

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