, ,
• •

Dataset Report

Unique identifier:	PLLNT274.0.0
Title:	Pollinator Ontology Metrics
Long title:	The Pollinator Ontology in the EU Pollinator Hub Controlled Vocabulary (EUPH-CV)
Status:	Quality Validated with Peer Review
Current Version:	v. 1.0
Published:	2025-12-19
Reviewed by:
Citation proposal:	Rubinigg 2025 Report of dataset Pollinator Ontology Metrics, v. 1.0 [PLLNT274.0.0]. EU Pollinator Hub. [2025-12-22] 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
References
Annex 1: Table column reports

Document history

Release

Version v. 1.0 released on 2025-12-19.

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	2025-12-19 00:12:00	Initial release.	n/a

Abbreviations

No abbreviations.

Executive summary

Data overview:

The EU Pollinator Hub (EUPH) provides a controlled vocabulary (EUPH-CV) for datastandardisation. A subset of the EUPH-CV has been designed as an ontology, the Pollinator Ontology, in which terms are arranged in a hierarchical structure, enriched with definitions, formal relationships between terms, and other properties (e.g., relations to metadata standard elements, comments, images, and version information).

Data value:

The classes im the controlled vocabulary and the relationships between them serve as a backbone (1) for the definition of the metadata standard elements (EUPH-MS), (2) for the standardisation of data stored on the EUPH in the form of literals, resource identifiers or resource description frameworks (RDF), and (3) for the alignment of terminologies from different vocabularies. The Pollinator Ontology is a crucial technology in knowledge management, big data processing, and machine learning. The use of terms from ontologies to annotate research data greatly improves automated data interpretation and interoperability and, hence, compliance with FAIR principles.

Data description:

The dataset contains 4 files, which are required to analyse the ontoplogy metrics. File terms.csv (442 733 bytes) contains the basic information on the classes. File terms_to_terms.csv (117 650 bytes) contains the relationships between classes. File translations.csv (2 285 199 bytes) contains the translations of the classes to human languages. The file language.csv (1 441 bytes) contains the name of the human languages.

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

The data should be used to validate the method used in the manuscript "The EU Pollinator Hub Controlled Vocabulary: An Ontology for Pollinators" submitted for publication in December 2025.

Unresolved issues:

n/a

Introduction

The Pollinator Ontology of the EU Pollinator Hub Controlled Vocabulary (EUPH-CV) is an ontology for information and data about pollinators and their interaction with the abiotic and biotic environment, particularly humans. It contains a series of concepts, referred to as classes, their properties and the relationships between them. A first version of the ontology has been deployed as part of a web-based open-source software application, the EU Pollinator Hub, a tool that has been developed, among others, to promote (1) the standardisation and internationalisation of data related to pollinators, (2) the community-driven development of the ontology and (3) the integration of existing vocabularies in the future.

Material and methods

Data acquisition

Data was collected with the vocabulary management user interface of the EU Pollinator Hub, which has been developed to create and maintene the Controlled Vocabulary and which is regulated by a set of SOP (Standard Operating Procedures) and Work Instructions (WI).

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	terms.csv	CSV - Comma seperated values	Yes	No	2025-12-20 14:12:43	40,834	432.36 KiB
2	terms_to_terms.csv	CSV - Comma seperated values	Yes	No	2025-12-20 14:12:08	16,532	114.89 KiB
3	translations.csv	CSV - Comma seperated values	Yes	No	2025-12-20 14:12:28	275,450	2.18 MiB
4	language.csv	CSV - Comma seperated values	Yes	No	2025-12-20 14:12:59	172	1.41 KiB
5	ontology_analysis.ipynb	Miscellaneous	No	Yes	2025-12-19 21:12:52	n/a	416.61 KiB

Data preparation

A detailed description of the method will become available after the publication of the manuscript.

Data validation

None

Data analysis

Data analysis was performrd with Jupyter Lab notebook (Version 4.5.1).

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	terms	Basic properties of the classes of a subset of the EUPH-CV used to construct the Pollinator Ontology.
2	terms to terms	Relationship between classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.
3	translations	Translations to human languages of the classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.
4	language	List of languages of the translation of classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.

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

Parameter	Content
interactions.single.uid	PLLNT274.0.0
Title	Pollinator Ontology Metrics
Long title	The Pollinator Ontology in the EU Pollinator Hub Controlled Vocabulary (EUPH-CV)
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/PLLNT274.0.0
interactions.single.section-details.licence	CC BY-NC 4.0
DOI	https://doi.org/10.5281/zenodo.17992427
Created	2025-12-04
Published	2025-12-19
Contact	m.rubinigg@visualife.at
Keywords	Pollinator, controlled vocabulary, honey bee, ontology
Data collection years	n/a
Regions, the data was collected in	n/a
Abstract	The Pollinator Ontology, a subset of the EU Pollinator Hub Controlled Vocabulary (EUPH-CV), is an ontology for information and data about pollinators and their interaction with the abiotic and biotic environment, particularly humans. It contains a series of concepts, referred to as classes, their properties and the relationships between them. A first version of the ontology has been deployed as part of the EU Pollinator Hub, a tool that has been developed, among others, to promote (1) the standardisation and internationalisation of data related to pollinators, (2) the community-driven development of the ontology and (3) the integration of existing vocabularies in the future.

Table 5. Standardised metadata of the data provider Rubinigg. Reported parameter (Parameter); content of the parameter (Content).

Parameter	Content
Name	Rubinigg
Url
Acronym	VR
IRI	https://app.pollinatorhub.eu/data-providers/visualife-rubinigg
Contact	https://orcid.org/0000-0002-7061-920X https://www.linkedin.com/in/rubinigg/
Description

Tables

terms

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

Parameter	Content
Unique identifier	PLLNT274.TERMS667.0
Name	terms
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT274.TERMS667.0
Table Type	File
Licence	CC BY-NC 4.0
Description	Basic properties of the classes of a subset of the EUPH-CV used to construct the Pollinator Ontology.

Basic properties of the classes of a subset of the EUPH-CV used to construct the Pollinator Ontology.

Metadata

uri links to external IRI
user_id links to the user identifier of the creator of the class
dataset_id links to the EUPH identifier if the dataset to which the class has been linked
synonym_id links to terms.id in case the class is a synonym of another class

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	EUPH code of the class and ID of the record in which basic properties of a class are stored.	Integer number	pms:euphCode [0.0.PHCDE392]	n/a
description	Label of the class.	String	pms:euphLabel [0.0.PHLBL880]	n/a
uri	IRI of the class.	String	pms:euphIRI [0.0.PHIRI881]	n/a
uid	UID of the class (currently not in use).	String	Text [0.0.TEXTA315]	n/a
annotation	Annotation of the editor of the class.	String	dwc:recordRemark [0.0.RCRDR842]	n/a
release_no	Release number of the class.	Boolean	Integer [0.0.NTGER313]	n/a
revision_no	Revision number of the class.	Boolean	Integer [0.0.NTGER313]	n/a
created_at	Date and time at which the record has been created.	Date and Time	pms:createdAt [0.0.CRTDT30]	n/a
updated_at	Date and time at which the record has been updated.	Date and Time	pms:updatedAt [0.0.PDTDT31]	n/a
deleted_at	Date and time at which the record has been deleted.	String	pms:deletedAt [0.0.DLTDT32]	n/a
status	Status of the class in the meta data asset's life cycle.	String	Text [0.0.TEXTA315]	n/a
valid_from	Date and time at which the validity of the class class starts.	Date and Time	iso-8601:calendarDateAndTime [0.0.DTNDT319]	n/a
valid_to	Date and time at which the validity of the class class ends.	String	Text [0.0.TEXTA315]	n/a
user_id	Identifier of the editor of the class.	Integer number	pms:userID [0.0.SERID483]	n/a
dataset_id	Identifier of the dataset linked to the class.	String	dwc:datasetID [0.0.DTSTD335]	n/a
synonym_id	EUPH code of the class that is a synonym of this class.	Integer number	pms:euphCode [0.0.PHCDE392]	n/a
definition_counter	The number of the definition approved to describe this class.	Integer number	Integer [0.0.NTGER313]	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
id	1 - 4	4,425.8	1	1,136.75	3,424.5	7,643.25	8,257	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,402 ( 100.0% )
description	0 - 84	n/a		n/a	n/a	n/a	other herbic…	2,402	1 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,400 ( 99.9% )
uri	0 - 54	n/a		n/a	n/a	n/a	http://www.g…	2,402	1,560 ( 64.9% )	0 ( 0.0% )	0 ( 0.0% )	838 ( 34.9% )
uid	0 - 0	n/a		n/a	n/a	n/a		2,402	2,402 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
annotation	0 - 1,086	n/a		n/a	n/a	n/a	A term from…	2,402	2,170 ( 90.3% )	0 ( 0.0% )	0 ( 0.0% )	225 ( 9.4% )
release_no	1 - 1	n/a	1	n/a	n/a	n/a	1	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
revision_no	0 - 0	n/a		n/a	n/a	n/a		2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
created_at	19 - 19	2,024.0	2023-01-23 1…	2,023	2,023	2,025	2025-10-30 2…	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,063 ( 44.3% )
updated_at	19 - 19	2,025.0	2023-09-01 1…	2,025	2,025	2,025	2025-12-18 2…	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,309 ( 96.1% )
deleted_at	0 - 0	n/a		n/a	n/a	n/a		2,402	2,402 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
status	7 - 7	n/a	defined	n/a	n/a	n/a	defined	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
valid_from	19 - 19	2,024.0	2023-01-23 1…	2,023	2,023	2,025	2025-10-30 2…	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,411 ( 58.7% )
valid_to	0 - 0	n/a		n/a	n/a	n/a		2,402	2,402 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
user_id	1 - 2	3.1	1	3	3	3	74	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	6 ( 0.2% )
dataset_id	0 - 0	n/a		n/a	n/a	n/a		2,402	2,402 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
synonym_id	4 - 4	1,298.0	1,298	n/a	n/a	n/a	1,298	2,402	2,401 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.1% )
definition_counter	1 - 1	1.0	1	1	1	1	4	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	4 ( 0.2% )

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
description	99.96%	99.92%	honey production	Robinia pseudoacacia
uri	35.05%	34.89%	null	https://www.gbif.org/species/5352251
uid	0.00%	0.04%	null	null
annotation	9.66%	9.37%	null	A term from the [Darwin Core standard](https://dwc.tdwg.org/list/#dc_type): > The name of the country or major administrative unit in which the [dcterms:Location](https://app.pollinatorhub.eu/vocabulary/classes/7367) occurs.
release_no	100.00%	0.04%	1	1
revision_no	100.00%	0.04%	0	0
created_at	100.00%	44.25%	2023-01-23 18:17:06	2023-09-01 12:34:04
updated_at	100.00%	96.13%	2023-09-01 10:57:56	2025-03-14 14:22:59
deleted_at	0.00%	0.04%	null	null
status	100.00%	0.04%	defined	defined
valid_from	100.00%	58.74%	2023-01-23 18:17:06	2023-09-02 17:59:34
valid_to	0.00%	0.04%	null	null
user_id	100.00%	0.25%	3	74
dataset_id	0.00%	0.04%	null	null
synonym_id	0.04%	0.08%	null	1298
definition_counter	100.00%	0.17%	1	4

Changes made to preparatory file

No changes have been made to the preparatory file

Changes made to data

No changes have been made to the data in the table

Unresolved issues

No unresolved issues have been detected

terms to terms

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

Parameter	Content
Unique identifier	PLLNT274.TRMST668.0
Name	terms to terms
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT274.TRMST668.0
Table Type	File
Licence	CC BY-NC 4.0
Description	Relationship between classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.

Relationship between classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.

Metadata

term_id links to terms.id
parent_id links to terms.id
relationship_id links to terms.id

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
id	Identifier of the record in which basic properties of a relationship between classes are stored.	Integer number	pms:recordID [0.0.RCRDD344]	n/a
term_id	EUPH code of the subject class of the axiom.	Integer number	pms:euphCode [0.0.PHCDE392]	n/a
parent_id	EUPH code of the object class of the axiom.	Integer number	pms:euphCode [0.0.PHCDE392]	n/a
relationship_id	EUPH code of the predicate class of the axiom.	Integer number	pms:euphCode [0.0.PHCDE392]	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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
id	1 - 5	7,472.3	1	2,147.5	9,352	10,766	12,024	4,133	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	4,133 ( 100.0% )
term_id	1 - 4	4,012.4	1	829.5	3,158	7,574	8,257	4,133	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,627 ( 63.6% )
parent_id	1 - 4	4,064.6	1	699	3,270	7,515	8,257	4,133	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,389 ( 33.6% )
relationship_id	3 - 4	7,871.6	670	8,141	8,141	8,141	8,252	4,133	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	53 ( 1.3% )

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
id	100.00%	100.00%	1	1
term_id	100.00%	63.56%	508	4
parent_id	100.00%	33.61%	7639	8046
relationship_id	100.00%	1.28%	8141	1461

Changes made to preparatory file

No changes have been made to the preparatory file

Changes made to data

No changes have been made to the data in the table

Unresolved issues

No unresolved issues have been detected

translations

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

Parameter	Content
Unique identifier	PLLNT274.TRNSL669.0
Name	translations
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT274.TRNSL669.0
Table Type	File
Licence	CC BY-NC 4.0
Description	Translations to human languages of the classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.

Translations to human languages of the classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.

Metadata

term_id links to terms.id
language_id links to language.id
user_id links to the user identifier of the creator of the translation
synonym_id links to translations.id in case the translation is a synonym of another translation

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 in which basic properties of a translation are stored.	Integer number	pms:recordID [0.0.RCRDD344]	n/a
expression	A synonym of a class in human language.	String	Text [0.0.TEXTA315]	n/a
term_id	EUPH code of the class to which the synonym belongs.	Integer number	pms:euphCode [0.0.PHCDE392]	n/a
slug	Slug of the translation (currently not in use).	String	Text [0.0.TEXTA315]	n/a
uid	UID of the translation (currently not in use).	String	Text [0.0.TEXTA315]	n/a
annotation	Annotation of the editor of the translation (currently not in use).	String	Text [0.0.TEXTA315]	n/a
release_no	Release number of the translation (currently not in use).	Boolean	Integer [0.0.NTGER313]	n/a
revision_no	Revision number of the translation (currently not in use).	Boolean	Integer [0.0.NTGER313]	n/a
created_at	Date and time at which the record has been created.	Date and Time	pms:createdAt [0.0.CRTDT30]	n/a
updated_at	Date and time at which the record has been updated.	Date and Time	pms:updatedAt [0.0.PDTDT31]	n/a
deleted_at	Date and time at which the record has been deleted.	String	pms:deletedAt [0.0.DLTDT32]	n/a
valid_from	Date and time at which the validity of the class translation starts.	Date and Time	iso-8601:calendarDateAndTime [0.0.DTNDT319]	n/a
valid_to	Date and time at which the validity of the class translation ends.	Date and Time	iso-8601:calendarDateAndTime [0.0.DTNDT319]	n/a
language_id	Identifier of the language in which a translation is provided.	Integer number	Integer [0.0.NTGER313]	n/a
location_id	Identifier of the location for which a translation is provided (currently not in use).	Boolean	dwc:locationID [0.0.LCTND157]	n/a
inflections	Inflections of the translation (currently not in use).	String	Text [0.0.TEXTA315]	n/a
description	Description of the translation in the language in which it has been provided (currently not in use).	String	Text [0.0.TEXTA315]	n/a
grammtype	Grammatical type of the translation.	String	Text [0.0.TEXTA315]	n/a
grammgender	Grammatical gender of the translation.	String	Text [0.0.TEXTA315]	n/a
grammnumber	Grammatical number of the translation.	String	Text [0.0.TEXTA315]	n/a
status	Status of the translation in the meta data asset's life cycle.	String	Text [0.0.TEXTA315]	n/a
user_id	Identifier of the editor of the translation.	Integer number	pms:userID [0.0.SERID483]	n/a
synonym_id	Record ID of the translation that is a synonym of this translation in the same language.	Integer number	Integer [0.0.NTGER313]	n/a
up_votes	The number of votes in favour of this translation in the creation process of the translation.	Integer number	Integer [0.0.NTGER313]	n/a
down_votes	The number of votes against this translation in the creation process of the translation.	Boolean	Integer [0.0.NTGER313]	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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
id	1 - 5	17,792.4	1	7,050.75	21,772.5	26,563.25	29,830	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	11,018 ( 100.0% )
expression	0 - 180	n/a		n/a	n/a	n/a	Bundesgesetz…	11,018	1 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,445 ( 85.7% )
term_id	1 - 4	3,785.8	1	921	3,458	7,361	8,257	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,244 ( 20.4% )
slug	0 - 0	n/a		n/a	n/a	n/a		11,018	11,018 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
uid	0 - 0	n/a		n/a	n/a	n/a		11,018	11,018 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
annotation	0 - 0	n/a		n/a	n/a	n/a		11,018	11,018 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
release_no	1 - 1	n/a	1	n/a	n/a	n/a	1	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
revision_no	0 - 0	n/a		n/a	n/a	n/a		11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
created_at	19 - 19	2,024.0	2023-01-23 1…	2,023	2,024	2,025	2025-12-17 1…	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,405 ( 76.3% )
updated_at	19 - 19	2,024.0	2023-09-01 1…	2,023	2,025	2,025	2025-12-18 2…	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	7,883 ( 71.5% )
deleted_at	0 - 0	n/a		n/a	n/a	n/a		11,018	11,018 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
valid_from	19 - 19	2,024.0	2023-01-23 1…	2,023	2,025	2,025	2025-12-18 2…	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	7,883 ( 71.5% )
valid_to	0 - 19	2,025.0	2025-12-18 1…	n/a	n/a	n/a	2025-12-18 1…	11,018	11,017 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )
language_id	1 - 3	69.1	8	38	40	116	183	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	32 ( 0.3% )
location_id	0 - 1	n/a	1	n/a	n/a	n/a	1	11,018	11,017 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )
inflections	0 - 86	n/a		n/a	n/a	n/a	cellule roya…	11,018	10,840 ( 98.4% )	0 ( 0.0% )	0 ( 0.0% )	178 ( 1.6% )
description	0 - 78	n/a		n/a	n/a	n/a	La covata ap…	11,018	11,017 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )
grammtype	0 - 18	n/a		n/a	n/a	n/a	compound adj…	11,018	56 ( 0.5% )	0 ( 0.0% )	0 ( 0.0% )	11 ( 0.1% )
grammgender	0 - 9	n/a		n/a	n/a	n/a	masculine	11,018	6,710 ( 60.9% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 0.0% )
grammnumber	0 - 8	n/a		n/a	n/a	n/a	singular	11,018	3,956 ( 35.9% )	0 ( 0.0% )	0 ( 0.0% )	4 ( 0.0% )
status	5 - 8	n/a	draft	n/a	n/a	n/a	approved	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )
user_id	1 - 2	4.1	1	3	3	3	74	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	17 ( 0.2% )
synonym_id	1 - 5	19,425.8	5	10,448	24,903	27,151	29,829	11,018	9,445 ( 85.7% )	0 ( 0.0% )	0 ( 0.0% )	1,328 ( 12.1% )
up_votes	1 - 1	0.0	0	0	0	0	2	11,018	0 ( 0.0% )	11,009 ( 99.9% )	0 ( 0.0% )	3 ( 0.0% )
down_votes	0 - 0	n/a		n/a	n/a	n/a		11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

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
expression	99.99%	85.72%	HMF	Akazie
term_id	100.00%	20.37%	3458	76
slug	0.00%	0.01%	null	null
uid	0.00%	0.01%	null	null
annotation	0.00%	0.01%	null	null
release_no	100.00%	0.01%	1	1
revision_no	100.00%	0.01%	0	0
created_at	100.00%	76.28%	2023-12-15 14:22:57	2023-09-17 09:34:44
updated_at	100.00%	71.55%	2023-12-15 14:22:57	2025-04-18 11:04:37
deleted_at	0.00%	0.01%	null	null
valid_from	100.00%	71.55%	2023-12-15 14:22:57	2025-04-18 11:04:37
valid_to	0.01%	0.02%	null	2025-12-18 17:26:18
language_id	100.00%	0.29%	38	93
location_id	0.01%	0.02%	null	1
inflections	1.62%	1.62%	null	Honigbiene {sg} \| Honigbienen {pl}
description	0.01%	0.02%	null	La covata appare irregolarmente distribuita in celle aperte e celle opercolate
grammtype	99.49%	0.10%	noun	pronoun
grammgender	39.10%	0.05%	null	common
grammnumber	64.10%	0.04%	singular	trial
status	100.00%	0.02%	approved	draft
user_id	100.00%	0.15%	3	45
synonym_id	14.28%	12.05%	null	45
up_votes	100.00%	0.03%	0	2
down_votes	100.00%	0.01%	0	0

Changes made to preparatory file

No changes have been made to the preparatory file

Changes made to data

No changes have been made to the data in the table

Unresolved issues

No unresolved issues have been detected

language

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

Parameter	Content
Unique identifier	PLLNT274.LNGGE670.0
Name	language
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT274.LNGGE670.0
Table Type	File
Licence	CC BY-NC 4.0
Description	List of languages of the translation of classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.

List of languages of the translation of classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.

Metadata

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	Column Description	Datatype	Descriptor	Unit
id	ID of the record, identifying the language in which a translation is provided.	Integer number	pms:recordID [0.0.RCRDD344]	n/a
name	Name of the language in which a translation is provided.	String	iso-639:languageName [0.0.LNGGN123]	n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 20. 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
id	1 - 3	94.6	1	47.75	99	140.75	183	86	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	86 ( 100.0% )
name	3 - 14	n/a	Lao	n/a	n/a	n/a	Haitian Creo…	86	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	86 ( 100.0% )

Quality measures

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
id	100.00%	100.00%	1	1
name	100.00%	100.00%	Afar	Afar

Changes made to preparatory file

No changes have been made to the preparatory file

Changes made to data

No changes have been made to the data in the table

Unresolved issues

No unresolved issues have been detected

References

Noa SD., Santiago O., Gregor S., Michael R., Gilles SM. 2025 The EU Pollinator Hub: Operationalisation of the EU Bee Partnership Platform for Harmonised Data Collection and Sharing Among Stakeholders on Bees and Pollinators. EFSA Supporting Publications. Vol. 22, (1) p. 9219E. doi: 10.2903/sp.efsa.2025.EN-9219

Annex 1: Table column reports

Table: terms

Column: id

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	id
Description	EUPH code of the class and ID of the record in which basic properties of a class are stored.
Data type	Integer number
Descriptor	pms:euphCode [UID:0.0.PHCDE392]
Descriptor description	An EUPH code is an EUPH-CV entity. It is a property of an EUPH class that confers a unique identifier to the class. It is required for the standardisation within and across datasets.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PHCDE392
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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
id	1 - 4	4,425.8	1	1,136.75	3,424.5	7,643.25	8,257	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,402 ( 100.0% )

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

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	description
Description	Label of the class.
Data type	String
Descriptor	pms:euphLabel [UID:0.0.PHLBL880]
Descriptor description	An EUPH label is an EUPH-CV entity. It is a property of an EUPH class that confers a standardised name in human language to the class. It may be used for the labelling of metadata within a dataset.
Descriptor target IRI	https://app.pollinatorhub.eu/dashboard/descriptors/880
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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
description	0 - 84	n/a		n/a	n/a	n/a	other herbic…	2,402	1 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,400 ( 99.9% )

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
description	99.96%	99.92%	honey production	Robinia pseudoacacia

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

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	uri
Description	IRI of the class.
Data type	String
Descriptor	pms:euphIRI [UID:0.0.PHIRI881]
Descriptor description	An EUPH IRI is an EUPH-CV entity. It is a property of an EUPH class that confers an internationalised resource identifier to the class. It may be used for the labelling of metadata within a dataset.
Descriptor target IRI	https://app.pollinatorhub.eu/dashboard/descriptors/881
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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
uri	0 - 54	n/a		n/a	n/a	n/a	http://www.g…	2,402	1,560 ( 64.9% )	0 ( 0.0% )	0 ( 0.0% )	838 ( 34.9% )

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
uri	35.05%	34.89%	null	https://www.gbif.org/species/5352251

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

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	uid
Description	UID of the class (currently not in use).
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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
uid	0 - 0	n/a		n/a	n/a	n/a		2,402	2,402 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

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
uid	0.00%	0.04%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: annotation

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	annotation
Description	Annotation of the editor of the class.
Data type	String
Descriptor	dwc:recordRemark [UID:0.0.RCRDR842]
Descriptor description	A remark (annotation, comment) related to a specific record.
Descriptor target IRI	https://app.pollinatorhub.eu/dashboard/descriptors/842
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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
annotation	0 - 1,086	n/a		n/a	n/a	n/a	A term from…	2,402	2,170 ( 90.3% )	0 ( 0.0% )	0 ( 0.0% )	225 ( 9.4% )

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
annotation	9.66%	9.37%	null	A term from the [Darwin Core standard](https://dwc.tdwg.org/list/#dc_type): > The name of the country or major administrative unit in which the [dcterms:Location](https://app.pollinatorhub.eu/vocabulary/classes/7367) occurs.

Completeness

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

Uniqueness

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

Column: release_no

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	release_no
Description	Release number of the class.
Data type	Boolean
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 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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
release_no	1 - 1	n/a	1	n/a	n/a	n/a	1	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

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
release_no	100.00%	0.04%	1	1

Data Distribution Top 20

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

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

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	revision_no
Description	Revision number of the class.
Data type	Boolean
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 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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
revision_no	0 - 0	n/a		n/a	n/a	n/a		2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

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
revision_no	100.00%	0.04%	0	0

Data Distribution Top 20

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

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

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	created_at
Description	Date and time at which the record has been created.
Data type	Date and Time
Descriptor	pms:createdAt [UID:0.0.CRTDT30]
Descriptor description	The complete representation of the time at which an information content was created.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CRTDT30
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	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
created_at	19 - 19	2,024.0	2023-01-23 1…	2,023	2,023	2,025	2025-10-30 2…	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,063 ( 44.3% )

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
created_at	100.00%	44.25%	2023-01-23 18:17:06	2023-09-01 12:34:04

Outliers

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

No data available.

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

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).

Parameter	Content
Column name	updated_at
Description	Date and time at which the record has been updated.
Data type	Date and Time
Descriptor	pms:updatedAt [UID:0.0.PDTDT31]
Descriptor description	The complete representation of the time at which an information content was modified.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PDTDT31
Unit	n/a

Table 47. 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
updated_at	19 - 19	2,025.0	2023-09-01 1…	2,025	2,025	2,025	2025-12-18 2…	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,309 ( 96.1% )

Table 48. 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
updated_at	100.00%	96.13%	2023-09-01 10:57:56	2025-03-14 14:22:59

Outliers

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

No data available.

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

Table 49. 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	deleted_at
Description	Date and time at which the record has been deleted.
Data type	String
Descriptor	pms:deletedAt [UID:0.0.DLTDT32]
Descriptor description	The complete representation of the time at which an information content was deleted.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DLTDT32
Unit	n/a

Table 50. 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
deleted_at	0 - 0	n/a		n/a	n/a	n/a		2,402	2,402 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 51. 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
deleted_at	0.00%	0.04%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: status

Table 52. 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	status
Description	Status of the class in the meta data asset's life cycle.
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 53. 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
status	7 - 7	n/a	defined	n/a	n/a	n/a	defined	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 54. 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
status	100.00%	0.04%	defined	defined

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: valid_from

Table 55. 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	valid_from
Description	Date and time at which the validity of the class class starts.
Data type	Date and Time
Descriptor	iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description	date and time representation [...] that includes all the time scale components [...] associated with the expression [...]
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DTNDT319
Unit	n/a

Table 56. 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
valid_from	19 - 19	2,024.0	2023-01-23 1…	2,023	2,023	2,025	2025-10-30 2…	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,411 ( 58.7% )

Table 57. 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
valid_from	100.00%	58.74%	2023-01-23 18:17:06	2023-09-02 17:59:34

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: valid_to

Table 58. 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	valid_to
Description	Date and time at which the validity of the class class ends.
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 59. 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
valid_to	0 - 0	n/a		n/a	n/a	n/a		2,402	2,402 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 60. 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
valid_to	0.00%	0.04%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: user_id

Table 61. 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	user_id
Description	Identifier of the editor of the class.
Data type	Integer number
Descriptor	pms:userID [UID:0.0.SERID483]
Descriptor description	A user is a person who utilizes a computer or network service. A user often has a user account and is identified to the system by a username (or user name).
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.SERID483
Unit	n/a

Table 62. 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
user_id	1 - 2	3.1	1	3	3	3	74	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	6 ( 0.2% )

Table 63. 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
user_id	100.00%	0.25%	3	74

Data Distribution Top 20

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

Continuous Data Distribution

Figure 39. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: dataset_id

Table 64. 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	dataset_id
Description	Identifier of the dataset linked to the class.
Data type	String
Descriptor	dwc:datasetID [UID:0.0.DTSTD335]
Descriptor description	An identifier for the set of data. May be a global unique identifier or an identifier specific to a collection or institution.
Descriptor target IRI	http://rs.tdwg.org/dwc/terms/datasetID
Unit	n/a

Table 65. 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
dataset_id	0 - 0	n/a		n/a	n/a	n/a		2,402	2,402 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 66. 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
dataset_id	0.00%	0.04%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: synonym_id

Table 67. 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	synonym_id
Description	EUPH code of the class that is a synonym of this class.
Data type	Integer number
Descriptor	pms:euphCode [UID:0.0.PHCDE392]
Descriptor description	An EUPH code is an EUPH-CV entity. It is a property of an EUPH class that confers a unique identifier to the class. It is required for the standardisation within and across datasets.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PHCDE392
Unit	n/a

Table 68. 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
synonym_id	4 - 4	1,298.0	1,298	n/a	n/a	n/a	1,298	2,402	2,401 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.1% )

Table 69. 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
synonym_id	0.04%	0.08%	null	1298

Data Distribution Top 20

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

Continuous Data Distribution

Figure 47. Distribution of values in the column.

Completeness

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

Uniqueness

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

Column: definition_counter

Table 70. 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	definition_counter
Description	The number of the definition approved to describe this class.
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 71. 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
definition_counter	1 - 1	1.0	1	1	1	1	4	2,402	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	4 ( 0.2% )

Table 72. 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
definition_counter	100.00%	0.17%	1	4

Data Distribution Top 20

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

Continuous Data Distribution

Figure 51. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: terms to terms

Column: id

Table 73. 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 in which basic properties of a relationship between classes are stored.
Data type	Integer number
Descriptor	pms:recordID [UID:0.0.RCRDD344]
Descriptor description	Unique sequence of integers associated with a record within a certain table.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit	n/a

Table 74. 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
id	1 - 5	7,472.3	1	2,147.5	9,352	10,766	12,024	4,133	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	4,133 ( 100.0% )

Table 75. 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 55. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: term_id

Table 76. 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	term_id
Description	EUPH code of the subject class of the axiom.
Data type	Integer number
Descriptor	pms:euphCode [UID:0.0.PHCDE392]
Descriptor description	An EUPH code is an EUPH-CV entity. It is a property of an EUPH class that confers a unique identifier to the class. It is required for the standardisation within and across datasets.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PHCDE392
Unit	n/a

Table 77. 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
term_id	1 - 4	4,012.4	1	829.5	3,158	7,574	8,257	4,133	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,627 ( 63.6% )

Table 78. 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
term_id	100.00%	63.56%	508	4

Continuous Data Distribution

Figure 59. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: parent_id

Table 79. 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_id
Description	EUPH code of the object class of the axiom.
Data type	Integer number
Descriptor	pms:euphCode [UID:0.0.PHCDE392]
Descriptor description	An EUPH code is an EUPH-CV entity. It is a property of an EUPH class that confers a unique identifier to the class. It is required for the standardisation within and across datasets.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PHCDE392
Unit	n/a

Table 80. 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
parent_id	1 - 4	4,064.6	1	699	3,270	7,515	8,257	4,133	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,389 ( 33.6% )

Table 81. 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_id	100.00%	33.61%	7639	8046

Continuous Data Distribution

Figure 63. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: relationship_id

Table 82. 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	relationship_id
Description	EUPH code of the predicate class of the axiom.
Data type	Integer number
Descriptor	pms:euphCode [UID:0.0.PHCDE392]
Descriptor description	An EUPH code is an EUPH-CV entity. It is a property of an EUPH class that confers a unique identifier to the class. It is required for the standardisation within and across datasets.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PHCDE392
Unit	n/a

Table 83. 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
relationship_id	3 - 4	7,871.6	670	8,141	8,141	8,141	8,252	4,133	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	53 ( 1.3% )

Table 84. 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
relationship_id	100.00%	1.28%	8141	1461

Data Distribution Top 20

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

Data Distribution Bottom 20

Figure 68. Distribution of 20 least common values, from lowest to highest.

Outliers

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

Completeness

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

Uniqueness

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

Table: translations

Column: id

Table 85. 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 in which basic properties of a translation are stored.
Data type	Integer number
Descriptor	pms:recordID [UID:0.0.RCRDD344]
Descriptor description	Unique sequence of integers associated with a record within a certain table.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit	n/a

Table 86. 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
id	1 - 5	17,792.4	1	7,050.75	21,772.5	26,563.25	29,830	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	11,018 ( 100.0% )

Table 87. 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 72. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: expression

Table 88. 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	expression
Description	A synonym of a class in human language.
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 89. 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
expression	0 - 180	n/a		n/a	n/a	n/a	Bundesgesetz…	11,018	1 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,445 ( 85.7% )

Table 90. 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
expression	99.99%	85.72%	HMF	Akazie

Completeness

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

Uniqueness

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

Column: term_id

Table 91. 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	term_id
Description	EUPH code of the class to which the synonym belongs.
Data type	Integer number
Descriptor	pms:euphCode [UID:0.0.PHCDE392]
Descriptor description	An EUPH code is an EUPH-CV entity. It is a property of an EUPH class that confers a unique identifier to the class. It is required for the standardisation within and across datasets.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PHCDE392
Unit	n/a

Table 92. 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
term_id	1 - 4	3,785.8	1	921	3,458	7,361	8,257	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,244 ( 20.4% )

Table 93. 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
term_id	100.00%	20.37%	3458	76

Continuous Data Distribution

Figure 78. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: slug

Table 94. 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	slug
Description	Slug of the translation (currently not in use).
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 95. 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
slug	0 - 0	n/a		n/a	n/a	n/a		11,018	11,018 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 96. 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
slug	0.00%	0.01%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: uid

Table 97. 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	uid
Description	UID of the translation (currently not in use).
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 98. 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
uid	0 - 0	n/a		n/a	n/a	n/a		11,018	11,018 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 99. 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
uid	0.00%	0.01%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: annotation

Table 100. 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	annotation
Description	Annotation of the editor of the translation (currently not in use).
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 101. 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
annotation	0 - 0	n/a		n/a	n/a	n/a		11,018	11,018 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 102. 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
annotation	0.00%	0.01%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: release_no

Table 103. 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	release_no
Description	Release number of the translation (currently not in use).
Data type	Boolean
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 104. 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
release_no	1 - 1	n/a	1	n/a	n/a	n/a	1	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 105. 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
release_no	100.00%	0.01%	1	1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: revision_no

Table 106. 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	revision_no
Description	Revision number of the translation (currently not in use).
Data type	Boolean
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 107. 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
revision_no	0 - 0	n/a		n/a	n/a	n/a		11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 108. 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
revision_no	100.00%	0.01%	0	0

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: created_at

Table 109. 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	created_at
Description	Date and time at which the record has been created.
Data type	Date and Time
Descriptor	pms:createdAt [UID:0.0.CRTDT30]
Descriptor description	The complete representation of the time at which an information content was created.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CRTDT30
Unit	n/a

Table 110. 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
created_at	19 - 19	2,024.0	2023-01-23 1…	2,023	2,024	2,025	2025-12-17 1…	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,405 ( 76.3% )

Table 111. 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
created_at	100.00%	76.28%	2023-12-15 14:22:57	2023-09-17 09:34:44

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: updated_at

Table 112. 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	updated_at
Description	Date and time at which the record has been updated.
Data type	Date and Time
Descriptor	pms:updatedAt [UID:0.0.PDTDT31]
Descriptor description	The complete representation of the time at which an information content was modified.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PDTDT31
Unit	n/a

Table 113. 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
updated_at	19 - 19	2,024.0	2023-09-01 1…	2,023	2,025	2,025	2025-12-18 2…	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	7,883 ( 71.5% )

Table 114. 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
updated_at	100.00%	71.55%	2023-12-15 14:22:57	2025-04-18 11:04:37

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: deleted_at

Table 115. 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	deleted_at
Description	Date and time at which the record has been deleted.
Data type	String
Descriptor	pms:deletedAt [UID:0.0.DLTDT32]
Descriptor description	The complete representation of the time at which an information content was deleted.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DLTDT32
Unit	n/a

Table 116. 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
deleted_at	0 - 0	n/a		n/a	n/a	n/a		11,018	11,018 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 117. 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
deleted_at	0.00%	0.01%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: valid_from

Table 118. 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	valid_from
Description	Date and time at which the validity of the class translation starts.
Data type	Date and Time
Descriptor	iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description	date and time representation [...] that includes all the time scale components [...] associated with the expression [...]
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DTNDT319
Unit	n/a

Table 119. 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
valid_from	19 - 19	2,024.0	2023-01-23 1…	2,023	2,025	2,025	2025-12-18 2…	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	7,883 ( 71.5% )

Table 120. 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
valid_from	100.00%	71.55%	2023-12-15 14:22:57	2025-04-18 11:04:37

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: valid_to

Table 121. 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	valid_to
Description	Date and time at which the validity of the class translation ends.
Data type	Date and Time
Descriptor	iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description	date and time representation [...] that includes all the time scale components [...] associated with the expression [...]
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DTNDT319
Unit	n/a

Table 122. 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
valid_to	0 - 19	2,025.0	2025-12-18 1…	n/a	n/a	n/a	2025-12-18 1…	11,018	11,017 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Table 123. 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
valid_to	0.01%	0.02%	null	2025-12-18 17:26:18

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: language_id

Table 124. 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	language_id
Description	Identifier of the language in which a translation is provided.
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 125. 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
language_id	1 - 3	69.1	8	38	40	116	183	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	32 ( 0.3% )

Table 126. 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
language_id	100.00%	0.29%	38	93

Data Distribution Top 20

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

Data Distribution Bottom 20

Figure 113. Distribution of 20 least common values, from lowest to highest.

Outliers

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

Completeness

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

Uniqueness

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

Column: location_id

Table 127. 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	location_id
Description	Identifier of the location for which a translation is provided (currently not in use).
Data type	Boolean
Descriptor	dwc:locationID [UID:0.0.LCTND157]
Descriptor description	An identifier for the set of dcterms:Location information. May be a global unique identifier or an identifier specific to the data set.
Descriptor target IRI	http://rs.tdwg.org/dwc/terms/locationID
Unit	n/a

Table 128. 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
location_id	0 - 1	n/a	1	n/a	n/a	n/a	1	11,018	11,017 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Table 129. 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
location_id	0.01%	0.02%	null	1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: inflections

Table 130. 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	inflections
Description	Inflections of the translation (currently not in use).
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 131. 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
inflections	0 - 86	n/a		n/a	n/a	n/a	cellule roya…	11,018	10,840 ( 98.4% )	0 ( 0.0% )	0 ( 0.0% )	178 ( 1.6% )

Table 132. 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
inflections	1.62%	1.62%	null	Honigbiene {sg} \| Honigbienen {pl}

Completeness

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

Uniqueness

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

Column: description

Table 133. 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	Description of the translation in the language in which it has been provided (currently not in use).
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 134. 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	0 - 78	n/a		n/a	n/a	n/a	La covata ap…	11,018	11,017 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Table 135. 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	0.01%	0.02%	null	La covata appare irregolarmente distribuita in celle aperte e celle opercolate

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: grammtype

Table 136. 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	grammtype
Description	Grammatical type of the translation.
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 137. 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
grammtype	0 - 18	n/a		n/a	n/a	n/a	compound adj…	11,018	56 ( 0.5% )	0 ( 0.0% )	0 ( 0.0% )	11 ( 0.1% )

Table 138. 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
grammtype	99.49%	0.10%	noun	pronoun

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: grammgender

Table 139. 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	grammgender
Description	Grammatical gender of the translation.
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 140. 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
grammgender	0 - 9	n/a		n/a	n/a	n/a	masculine	11,018	6,710 ( 60.9% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 0.0% )

Table 141. 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
grammgender	39.10%	0.05%	null	common

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: grammnumber

Table 142. 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	grammnumber
Description	Grammatical number of the translation.
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 143. 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
grammnumber	0 - 8	n/a		n/a	n/a	n/a	singular	11,018	3,956 ( 35.9% )	0 ( 0.0% )	0 ( 0.0% )	4 ( 0.0% )

Table 144. 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
grammnumber	64.10%	0.04%	singular	trial

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: status

Table 145. 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	status
Description	Status of the translation in the meta data asset's life cycle.
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 146. 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
status	5 - 8	n/a	draft	n/a	n/a	n/a	approved	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Table 147. 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
status	100.00%	0.02%	approved	draft

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: user_id

Table 148. 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	user_id
Description	Identifier of the editor of the translation.
Data type	Integer number
Descriptor	pms:userID [UID:0.0.SERID483]
Descriptor description	A user is a person who utilizes a computer or network service. A user often has a user account and is identified to the system by a username (or user name).
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.SERID483
Unit	n/a

Table 149. 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
user_id	1 - 2	4.1	1	3	3	3	74	11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	17 ( 0.2% )

Table 150. 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
user_id	100.00%	0.15%	3	45

Data Distribution Top 20

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

Continuous Data Distribution

Figure 138. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: synonym_id

Table 151. 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	synonym_id
Description	Record ID of the translation that is a synonym of this translation in the same language.
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 152. 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
synonym_id	1 - 5	19,425.8	5	10,448	24,903	27,151	29,829	11,018	9,445 ( 85.7% )	0 ( 0.0% )	0 ( 0.0% )	1,328 ( 12.1% )

Table 153. 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
synonym_id	14.28%	12.05%	null	45

Continuous Data Distribution

Figure 142. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: up_votes

Table 154. 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	up_votes
Description	The number of votes in favour of this translation in the creation process of the translation.
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 155. 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
up_votes	1 - 1	0.0	0	0	0	0	2	11,018	0 ( 0.0% )	11,009 ( 99.9% )	0 ( 0.0% )	3 ( 0.0% )

Table 156. 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
up_votes	100.00%	0.03%	0	2

Data Distribution Top 20

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

Continuous Data Distribution

Figure 147. Distribution of values in the column.

Completeness

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

Uniqueness

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

Column: down_votes

Table 157. 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	down_votes
Description	The number of votes against this translation in the creation process of the translation.
Data type	Boolean
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 158. 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
down_votes	0 - 0	n/a		n/a	n/a	n/a		11,018	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 159. 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
down_votes	100.00%	0.01%	0	0

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: language

Column: id

Table 160. 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	ID of the record, identifying the language in which a translation is provided.
Data type	Integer number
Descriptor	pms:recordID [UID:0.0.RCRDD344]
Descriptor description	Unique sequence of integers associated with a record within a certain table.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit	n/a

Table 161. 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
id	1 - 3	94.6	1	47.75	99	140.75	183	86	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	86 ( 100.0% )

Table 162. 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 153. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: name

Table 163. 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	name
Description	Name of the language in which a translation is provided.
Data type	String
Descriptor	iso-639:languageName [UID:0.0.LNGGN123]
Descriptor description	A systematic means of communicating by the use of sounds, symbols, or gestures.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors0.0.LNGGN123
Unit	n/a

Table 164. 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
name	3 - 14	n/a	Lao	n/a	n/a	n/a	Haitian Creo…	86	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	86 ( 100.0% )

Table 165. 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
name	100.00%	100.00%	Afar	Afar

Completeness

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

Uniqueness

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