, ,
• •

Dataset Report

Unique identifier:	PHCVA277.0.0
Title:	EUPH-CV
Long title:	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 EUPH-CV, v. 1.0 [PHCVA277.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. It contains terms that 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 use of the EUPH improves automated data interpretation and interoperability and, hence, compliance with FAIR principles.

Data description:

The dataset contains 9 files, which are required to analyse the ontoplogy metrics. File terms.csv (1 415 740 bytes) contains the basic information on the classes. File terms_to_terms.csv (285 616 bytes) maps the relationships between classes. File term_analogy.csv (255 bytes) maps the synonymy relationships between classes. The file definitions.csv (3 903 258 bytes) contains the definitions of the terms. File translations.csv (6 324 967 bytes) contains the translations of the classes to human languages. The file language.csv (1 441 bytes) contains the name of the human languages. The file domains.csv contains the domains in which a translation is used. The file translations_to_domains.csv (40 516 bytes) maps the relationship between translations and domains. The file translations_to_locations.csv (71 bytes) maps the relationship between translations and locations.

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

he 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	definitions.csv	CSV - Comma seperated values	Yes	No	2025-12-21 21:12:54	148,932	3.76 MiB
2	domains.csv	CSV - Comma seperated values	Yes	No	2025-12-21 21:12:17	133	2.73 KiB
3	language.csv	CSV - Comma seperated values	Yes	No	2025-12-21 21:12:37	172	1.41 KiB
4	term_analogy.csv	CSV - Comma seperated values	Yes	No	2025-12-21 21:12:00	32	255.00 B
5	terms.csv	CSV - Comma seperated values	Yes	No	2025-12-21 21:12:40	140,148	1.38 MiB
6	terms_to_terms.csv	CSV - Comma seperated values	Yes	No	2025-12-21 21:12:59	39,832	278.92 KiB
7	translations.csv	CSV - Comma seperated values	Yes	No	2025-12-21 21:12:37	743,350	6.03 MiB
8	translations_to_domains.csv	CSV - Comma seperated values	Yes	No	2025-12-21 21:12:57	6,806	39.57 KiB

Data preparation

Data was exported from the database in CSV format and subsequently imported into the EU Pollinator Hub.

Data validation

None

Data analysis

None

Data description

Dataset

Table 3. Summary of tables belonging to the dataset. Table row identifier (No); name of the table (Table); description of the table (Description).

No	Table	Description
1	definitions	Contains the definitions of the classes.
2	domains	Contains the domains to which a translation can be linked.
3	language	List of languages of the translation of classes of the subset of the EUPH-CV used to construct the Pollinator Ontology.
4	term_analogy	Maps the synonymy between classes.
5	terms	Basic properties of the classes the Controlled Vocabulary.
6	terms_to_terms	Relationship between classes of the Controlled Vocabulary.
7	translations	Translations to human languages of the classes of the Controlled Vocabulary.
8	translations_to_domains	Maps translations to domains

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

Parameter	Content
interactions.single.uid	PHCVA277.0.0
Title	EUPH-CV
Long title	The EU Pollinator Hub Controlled Vocabulary (EUPH-CV)
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/PHCVA277.0.0
interactions.single.section-details.licence	CC BY 4.0
DOI	https://doi.org/10.5281/zenodo.18005994
Created	2025-12-21
Published	2025-12-19
Contact	m.rubinigg@visualife.at
Keywords	EU Pollinator Hub, EUPH-CV, Pollinator, beekeeping, controlled vocabulary, honey bee
Data collection years	n/a
Regions, the data was collected in	n/a
Abstract	The EU Pollinator Hub Controlled Vocabulary (EUPH-CV), is an controlled vocabulary 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 controlled vocabulary 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

definitions

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

Parameter	Content
Unique identifier	PHCVA277.DFNTN671.0
Name	definitions
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PHCVA277.DFNTN671.0
Table Type	File
Licence	CC BY 4.0
Description	Contains the definitions of the classes.

Contains the definitions of the classes.

Metadata

term_id links to terms.id
user_id links to the user identifier of the creator of the 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	Identifier of the record in which basic properties of a definition are stored.	Integer number	pms:recordID [0.0.RCRDD344]	n/a
term_id	EUPH code of the class to which the definition belongs.	Integer number	pms:euphCode [0.0.PHCDE392]	n/a
number	Sequential number of the definition that has been created for a given class.	Integer number	Integer [0.0.NTGER313]	n/a
description	Definition of teh class in English language.	String	Text [0.0.TEXTA315]	n/a
slug	Slug of the definition (currently not in use).	String	Text [0.0.TEXTA315]	n/a
uid	UID of the definition (currently not in use).	String	Text [0.0.TEXTA315]	n/a
annotation	Annotation of the editor of the definition (currently not in use).	String	Text [0.0.TEXTA315]	n/a
release_no	Release number of the definition (currently not in use).	String	Integer [0.0.NTGER313]	n/a
revision_no	Revision number of the definition (currently not in use).	String	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.	Date and Time	pms:deletedAt [0.0.DLTDT32]	n/a
status	Status of the definition 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 definition starts.	Date and Time	iso-8601:calendarDateAndTime [0.0.DTNDT319]	n/a
valid_to	Date and time at which the validity of the class definition ends.	Date and Time	iso-8601:calendarDateAndTime [0.0.DTNDT319]	n/a
user_id	Identifier of the editor of the definition.	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 definition.	Integer number	Integer [0.0.NTGER313]	n/a
down_votes	The number of votes against this translation in the creation process of the definition.	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,178.3	1	2,068.75	4,206.5	6,275.25	8,343	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,274 ( 100.0% )
term_id	1 - 4	4,120.5	1	2,054.75	4,119.5	6,188.25	8,257	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,239 ( 99.6% )
number	1 - 1	1.0	1	1	1	1	8	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8 ( 0.1% )
description	4 - 2,219	n/a	Hemp	n/a	n/a	n/a	[Pyrethrins]…	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,262 ( 99.9% )
slug	0 - 0	n/a		n/a	n/a	n/a		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
uid	0 - 0	n/a		n/a	n/a	n/a		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
annotation	0 - 0	n/a		n/a	n/a	n/a		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
release_no	0 - 0	n/a		n/a	n/a	n/a		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
revision_no	0 - 0	n/a		n/a	n/a	n/a		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
created_at	19 - 19	2,023.0	2023-01-23 1…	2,023	2,023	2,023	2025-10-30 2…	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,157 ( 14.0% )
updated_at	19 - 19	2,024.0	2023-09-01 1…	2,023	2,023	2,025	2025-12-18 2…	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,506 ( 30.3% )
deleted_at	0 - 19	2,024.0	2023-09-18 0…	2,023	2,023	2,023	2025-04-15 0…	8,274	8,250 ( 99.7% )	0 ( 0.0% )	0 ( 0.0% )	25 ( 0.3% )
status	5 - 8	n/a	draft	n/a	n/a	n/a	approved	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )
valid_from	19 - 19	2,023.0	2023-01-23 1…	2,023	2,023	2,023	2025-12-03 1…	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,909 ( 23.1% )
valid_to	0 - 19	2,024.0	2023-09-02 1…	2,023	2,023	2,023	2025-12-03 1…	8,274	8,240 ( 99.6% )	0 ( 0.0% )	0 ( 0.0% )	33 ( 0.4% )
user_id	1 - 2	3.0	1	3	3	3	74	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9 ( 0.1% )
up_votes	1 - 1	0.0	0	0	0	0	9	8,274	0 ( 0.0% )	8,262 ( 99.9% )	0 ( 0.0% )	7 ( 0.1% )
down_votes	1 - 1	0.0	0	0	0	0	4	8,274	0 ( 0.0% )	8,265 ( 99.9% )	0 ( 0.0% )	4 ( 0.0% )

Quality measures

Table 9. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).

Column Name	Completeness	Uniqueness	Most Common Value	Least Common Value
id	100.00%	100.00%	1	1
term_id	100.00%	99.58%	3318	1
number	100.00%	0.10%	1	5
description	100.00%	99.85%	test	[The taxonomic species](https://app.pollinatorhub.eu/vocabulary/classes/7378) [Robinia pseudoacacia (L.)](https://app.pollinatorhub.eu/vocabulary/classes/1), which [is part of](https://app.pollinatorhub.eu/vocabulary/classes/7938) [the family Fabaceae](https://app.pollinatorhub.eu/vocabulary/classes/7915).
slug	0.00%	0.01%	null	null
uid	0.00%	0.01%	null	null
annotation	0.00%	0.01%	null	null
release_no	0.00%	0.01%	null	null
revision_no	0.00%	0.01%	null	null
created_at	100.00%	13.98%	2023-12-27 14:42:13	2023-02-08 12:54:09
updated_at	100.00%	30.29%	2023-12-27 14:42:13	2025-03-14 14:22:53
deleted_at	0.29%	0.30%	null	2023-11-01 14:12:13
status	100.00%	0.02%	approved	draft
valid_from	100.00%	23.07%	2023-12-27 14:42:13	2025-03-14 14:22:53
valid_to	0.41%	0.40%	null	2025-04-06 08:54:28
user_id	100.00%	0.11%	3	11
up_votes	100.00%	0.08%	0	4
down_votes	100.00%	0.05%	0	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

domains

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

Parameter	Content
Unique identifier	PHCVA277.DMNSA672.0
Name	domains
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PHCVA277.DMNSA672.0
Table Type	File
Licence	CC BY 4.0
Description	Contains the domains to which a translation can be linked.

Contains the domains to which a translation can be linked.

Metadata

parent_id links to domains.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.	Integer number	pms:recordID [0.0.RCRDD344]	n/a
name	Name of the domain.	String	Text [0.0.TEXTA315]	n/a
description	Description of the domain.	String	Text [0.0.TEXTA315]	n/a
abbreviation	Abbreviation of the domain name.	String	Text [0.0.TEXTA315]	n/a
parent_id	Record identifier of the parent domain.	Integer number	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

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 - 2	11.2	1	5	10	19	24	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	19 ( 100.0% )
name	3 - 19	n/a	Law	n/a	n/a	n/a	Veterinary M…	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	19 ( 100.0% )
description	6 - 191	n/a	unused	n/a	n/a	n/a	Terms relate…	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	14 ( 73.7% )
abbreviation	3 - 7	n/a	agr	n/a	n/a	n/a	vet-med	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	19 ( 100.0% )
parent_id	1 - 2	6.4	3	3	5	9.5	13	19	9 ( 47.4% )	0 ( 0.0% )	0 ( 0.0% )	7 ( 36.8% )
created_at	19 - 19	2,024.0	2024-09-05 1…	2,024	2,024	2,024	2024-11-03 1…	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	6 ( 31.6% )
updated_at	19 - 19	2,024.0	2024-09-05 1…	2,024	2,024	2,024	2024-11-03 1…	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8 ( 42.1% )

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
name	100.00%	100.00%	Apiculture	Apiculture
description	100.00%	73.68%	unused	Terms related to the management of <i>Apis mellifera</i> or <i>Apis cerana</i>.
abbreviation	100.00%	100.00%	apic	apic
parent_id	52.63%	36.84%	null	13
created_at	100.00%	31.58%	2024-09-05 12:43:29	2024-09-05 12:45:33
updated_at	100.00%	42.11%	2024-09-05 12:43:29	2024-09-05 14:48:24

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 14. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).

Parameter	Content
Unique identifier	PHCVA277.LNGGE673.0
Name	language
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PHCVA277.LNGGE673.0
Table Type	File
Licence	CC BY 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 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	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 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 - 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 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
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

term_analogy

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

Parameter	Content
Unique identifier	PHCVA277.TRMNL674.0
Name	term_analogy
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PHCVA277.TRMNL674.0
Table Type	File
Licence	CC BY 4.0
Description	Maps the synonymy between classes.

Maps the synonymy between classes.

Metadata

term_id links to terms.id
analogy_id links to terms.id

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
term_id	EUPH code of the class.	Integer number	pms:euphCode [0.0.PHCDE392]	n/a
analogy_id	EUPH code of the class of which the class is a synonym.	Integer number	pms:euphCode [0.0.PHCDE392]	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
term_id	3 - 4	2,571.1	986	1,577.75	2,056.5	3,453	7,254	16	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	16 ( 100.0% )
analogy_id	1 - 4	4,321.4	6	615.25	3,613.5	7,940.75	8,202	16	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	15 ( 93.8% )

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
term_id	100.00%	100.00%	3351	3351
analogy_id	100.00%	93.75%	23	6

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

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

Parameter	Content
Unique identifier	PHCVA277.TERMS675.0
Name	terms
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PHCVA277.TERMS675.0
Table Type	File
Licence	CC BY 4.0
Description	Basic properties of the classes the Controlled Vocabulary.

Basic properties of the classes the Controlled Vocabulary.

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 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	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.	Date and Time	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.	Date and Time	iso-8601:calendarDateAndTime [0.0.DTNDT319]	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.	Integer number	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 24. 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,129.3	1	2,061.25	4,135.5	6,196.75	8,257	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,244 ( 100.0% )
description	0 - 255	n/a		n/a	n/a	n/a	Cycloxydim i…	8,244	1 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,223 ( 99.7% )
uri	0 - 62	n/a		n/a	n/a	n/a	http://www.g…	8,244	7,393 ( 89.7% )	0 ( 0.0% )	0 ( 0.0% )	846 ( 10.3% )
uid	0 - 0	n/a		n/a	n/a	n/a		8,244	8,244 ( 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…	8,244	8,012 ( 97.2% )	0 ( 0.0% )	0 ( 0.0% )	225 ( 2.7% )
release_no	1 - 1	n/a	1	n/a	n/a	n/a	1	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
revision_no	0 - 0	n/a		n/a	n/a	n/a		8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
created_at	19 - 19	2,023.0	2023-01-23 1…	2,023	2,023	2,023	2025-10-30 2…	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,095 ( 13.3% )
updated_at	19 - 19	2,025.0	2023-09-01 1…	2,025	2,025	2,025	2025-12-18 2…	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,858 ( 34.7% )
deleted_at	0 - 19	2,024.0	2023-09-10 1…	2,023	2,024	2,024	2025-01-14 1…	8,244	8,232 ( 99.9% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 0.2% )
status	5 - 8	n/a	draft	n/a	n/a	n/a	approved	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	3 ( 0.0% )
valid_from	19 - 19	2,023.0	2023-01-23 1…	2,023	2,023	2,023	2025-10-30 2…	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,465 ( 17.8% )
valid_to	0 - 19	2,024.0	2023-09-10 1…	2,023	2,024	2,024	2025-01-14 1…	8,244	8,232 ( 99.9% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 0.2% )
user_id	1 - 2	3.0	1	3	3	3	74	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	6 ( 0.1% )
dataset_id	1 - 2	31.9	1	9	37	37	80	8,244	2,887 ( 35.0% )	0 ( 0.0% )	0 ( 0.0% )	8 ( 0.1% )
synonym_id	2 - 4	962.6	23	428	434	1,298	2,965	8,244	8,237 ( 99.9% )	0 ( 0.0% )	0 ( 0.0% )	8 ( 0.1% )
definition_counter	1 - 1	1.0	0	1	1	1	8	8,244	0 ( 0.0% )	5 ( 0.1% )	0 ( 0.0% )	6 ( 0.1% )

Quality measures

Table 25. 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.99%	99.75%	honey production	Robinia pseudoacacia
uri	10.32%	10.26%	null	https://www.gbif.org/species/5352251
uid	0.00%	0.01%	null	null
annotation	2.81%	2.73%	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.01%	1	1
revision_no	100.00%	0.01%	0	0
created_at	100.00%	13.28%	2023-12-27 14:30:50	2023-02-08 12:59:55
updated_at	100.00%	34.67%	2025-02-11 13:47:55	2025-03-14 14:22:59
deleted_at	0.15%	0.16%	null	2023-09-10 11:01:57
status	100.00%	0.04%	defined	approved
valid_from	100.00%	17.77%	2023-12-27 14:30:50	2023-09-02 17:59:34
valid_to	0.15%	0.16%	null	2023-09-10 11:01:57
user_id	100.00%	0.07%	3	74
dataset_id	64.98%	0.10%	37	32
synonym_id	0.08%	0.10%	null	428
definition_counter	100.00%	0.07%	1	8

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 26. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).

Parameter	Content
Unique identifier	PHCVA277.TRMST676.0
Name	terms_to_terms
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PHCVA277.TRMST676.0
Table Type	File
Licence	CC BY 4.0
Description	Relationship between classes of the Controlled Vocabulary.

Relationship between classes of the Controlled Vocabulary.

Metadata

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

Table 27. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).

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 28. 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	6,051.0	1	3,194.75	6,053.5	8,884.25	12,024	9,958	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,958 ( 100.0% )
term_id	1 - 4	4,005.4	1	1,723.75	3,813.5	6,286.25	8,257	9,958	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,239 ( 82.7% )
parent_id	1 - 4	3,567.6	1	1,088	3,950	3,977	8,257	9,958	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,687 ( 16.9% )
relationship_id	3 - 4	8,029.2	670	8,141	8,141	8,141	8,252	9,958	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	53 ( 0.5% )

Quality measures

Table 29. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).

Column Name	Completeness	Uniqueness	Most Common Value	Least Common Value
id	100.00%	100.00%	1	1
term_id	100.00%	82.74%	508	4
parent_id	100.00%	16.94%	3950	8046
relationship_id	100.00%	0.53%	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 30. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).

Parameter	Content
Unique identifier	PHCVA277.TRNSL677.0
Name	translations
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PHCVA277.TRNSL677.0
Table Type	File
Licence	CC BY 4.0
Description	Translations to human languages of the classes of the Controlled Vocabulary.

Translations to human languages of the classes of the Controlled Vocabulary.

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 31. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).

Column Name	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		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).	String	Integer [0.0.NTGER313]	n/a
revision_no	Revision number of the translation (currently not in use).	String	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.	Date and Time	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 32. 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	14,942.4	1	7,519.75	14,953.5	22,397.25	29,830	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	29,734 ( 100.0% )
expression	0 - 255	n/a		n/a	n/a	n/a	Cycloxydim i…	29,734	1 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	24,269 ( 81.6% )
term_id	1 - 4	3,683.0	1	3,112	3,583	3,903	8,257	29,734	10 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,233 ( 27.7% )
slug	0 - 0	n/a		n/a	n/a	n/a		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
uid	0 - 0	n/a		n/a	n/a	n/a		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
annotation	0 - 0	n/a		n/a	n/a	n/a		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
release_no	0 - 0	n/a		n/a	n/a	n/a		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )
revision_no	0 - 0	n/a		n/a	n/a	n/a		29,734	29,734 ( 100.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-12-17 1…	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,872 ( 33.2% )
updated_at	19 - 19	2,024.0	2023-09-01 1…	2,023	2,023	2,025	2025-12-18 2…	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,555 ( 32.1% )
deleted_at	0 - 19	2,024.0	2023-09-19 0…	2,023	2,023	2,023	2025-12-18 1…	29,734	29,599 ( 99.5% )	0 ( 0.0% )	0 ( 0.0% )	136 ( 0.5% )
valid_from	19 - 19	2,024.0	2023-01-23 1…	2,023	2,023	2,025	2025-12-18 2…	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,460 ( 31.8% )
valid_to	0 - 19	2,024.0	2023-09-02 1…	2,023	2,023	2,023	2025-12-18 1…	29,734	29,597 ( 99.5% )	0 ( 0.0% )	0 ( 0.0% )	136 ( 0.5% )
language_id	1 - 3	66.8	1	38	40	109	183	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	88 ( 0.3% )
location_id	0 - 1	n/a	1	n/a	n/a	n/a	1	29,734	29,733 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )
inflections	0 - 86	n/a		n/a	n/a	n/a	cellule roya…	29,734	29,548 ( 99.4% )	0 ( 0.0% )	0 ( 0.0% )	186 ( 0.6% )
description	0 - 78	n/a		n/a	n/a	n/a	La covata ap…	29,734	29,733 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )
grammtype	0 - 18	n/a		n/a	n/a	n/a	compound adj…	29,734	2,288 ( 7.7% )	0 ( 0.0% )	0 ( 0.0% )	12 ( 0.0% )
grammgender	0 - 9	n/a		n/a	n/a	n/a	masculine	29,734	25,262 ( 85.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 0.0% )
grammnumber	0 - 8	n/a		n/a	n/a	n/a	singular	29,734	18,623 ( 62.6% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 0.0% )
status	5 - 8	n/a	draft	n/a	n/a	n/a	approved	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )
user_id	1 - 2	3.5	1	3	3	3	74	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	18 ( 0.1% )
synonym_id	1 - 5	19,325.4	5	8,460.5	24,886	27,156	29,829	29,734	28,093 ( 94.5% )	0 ( 0.0% )	0 ( 0.0% )	1,388 ( 4.7% )
up_votes	1 - 1	0.0	0	0	0	0	2	29,734	0 ( 0.0% )	29,723 ( 100.0% )	0 ( 0.0% )	3 ( 0.0% )
down_votes	0 - 1	n/a		n/a	n/a	n/a	1	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Quality measures

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
id	100.00%	100.00%	1	1
expression	100.00%	81.62%	2,4-D	Akazie
term_id	99.97%	27.69%	3458	1154
slug	0.00%	0.00%	null	null
uid	0.00%	0.00%	null	null
annotation	0.00%	0.00%	null	null
release_no	0.00%	0.00%	null	null
revision_no	0.00%	0.00%	null	null
created_at	100.00%	33.20%	2023-12-15 14:22:57	2023-02-08 11:59:08
updated_at	100.00%	32.13%	2023-12-15 14:22:57	2025-04-18 11:04:37
deleted_at	0.45%	0.46%	null	2023-09-19 08:35:40
valid_from	100.00%	31.82%	2023-12-15 14:22:57	2025-04-18 11:04:37
valid_to	0.46%	0.46%	null	2023-09-02 17:56:37
language_id	100.00%	0.30%	38	93
location_id	0.00%	0.01%	null	1
inflections	0.63%	0.63%	null	Honigbiene {sg} \| Honigbienen {pl}
description	0.00%	0.01%	null	La covata appare irregolarmente distribuita in celle aperte e celle opercolate
grammtype	92.31%	0.04%	phrase	adverb
grammgender	15.04%	0.02%	null	common
grammnumber	37.37%	0.02%	null	paucal
status	100.00%	0.01%	approved	draft
user_id	100.00%	0.06%	3	45
synonym_id	5.52%	4.67%	null	45
up_votes	100.00%	0.01%	0	2
down_votes	100.00%	0.01%	0	1

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_to_domains

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

Parameter	Content
Unique identifier	PHCVA277.TRNSL678.0
Name	translations_to_domains
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/PHCVA277.TRNSL678.0
Table Type	File
Licence	CC BY 4.0
Description	Maps translations to domains

Maps translations to domains

Metadata

translation_id links to translations.id
domain_id links to domains.id

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	Column Description	Datatype	Descriptor	Unit
translation_id	Record ID of the translation	Integer number	Integer [0.0.NTGER313]	n/a
domain_id	Record ID of the domain	Integer number	Integer [0.0.NTGER313]	n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 36. 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
translation_id	1 - 5	4,112.2	1	987	1,838	2,940	29,569	3,403	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	3,394 ( 99.7% )
domain_id	1 - 2	3.4	1	1	4	4	24	3,403	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	12 ( 0.4% )

Quality measures

Table 37. 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
translation_id	100.00%	99.74%	27698	1
domain_id	100.00%	0.35%	4	2

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

Column: id

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

Parameter	Content
Column name	id
Description	Identifier of the record in which basic properties of a definition 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 39. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).

Column Name	Range	Mean	Minimum	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
id	1 - 4	4,178.3	1	2,068.75	4,206.5	6,275.25	8,343	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,274 ( 100.0% )

Table 40. 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: term_id

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

Parameter	Content
Column name	term_id
Description	EUPH code of the class to which the definition 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 42. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).

Column Name	Range	Mean	Minimum	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
term_id	1 - 4	4,120.5	1	2,054.75	4,119.5	6,188.25	8,257	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,239 ( 99.6% )

Table 43. 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%	99.58%	3318	1

Continuous Data Distribution

Figure 5. Distribution of values in the column.

Outliers

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

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

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

Parameter	Content
Column name	number
Description	Sequential number of the definition that has been created for a given 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 45. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).

Column Name	Range	Mean	Minimum	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
number	1 - 1	1.0	1	1	1	1	8	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8 ( 0.1% )

Table 46. 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
number	100.00%	0.10%	1	5

Data Distribution Top 20

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

Continuous Data Distribution

Figure 10. Distribution of values in the column.

Outliers

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

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

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

Parameter	Content
Column name	description
Description	Definition of teh class in English 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 48. 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	4 - 2,219	n/a	Hemp	n/a	n/a	n/a	[Pyrethrins]…	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,262 ( 99.9% )

Table 49. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).

Column Name	Completeness	Uniqueness	Most Common Value	Least Common Value
description	100.00%	99.85%	test	[The taxonomic species](https://app.pollinatorhub.eu/vocabulary/classes/7378) [Robinia pseudoacacia (L.)](https://app.pollinatorhub.eu/vocabulary/classes/1), which [is part of](https://app.pollinatorhub.eu/vocabulary/classes/7938) [the family Fabaceae](https://app.pollinatorhub.eu/vocabulary/classes/7915).

Completeness

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

Uniqueness

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

Column: slug

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

Parameter	Content
Column name	slug
Description	Slug of the definition (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 51. 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		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 52. 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 16. Distribution of 20 most common values, from highest to lowest.

Completeness

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

Uniqueness

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

Column: uid

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

Parameter	Content
Column name	uid
Description	UID of the definition (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 54. 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		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 55. 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 19. Distribution of 20 most common values, from highest to lowest.

Completeness

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

Uniqueness

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

Column: annotation

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

Parameter	Content
Column name	annotation
Description	Annotation of the editor of the definition (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 57. 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		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 58. 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 22. Distribution of 20 most common values, from highest to lowest.

Completeness

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

Uniqueness

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

Column: release_no

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

Parameter	Content
Column name	release_no
Description	Release number of the definition (currently not in use).
Data type	String
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 60. 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	0 - 0	n/a		n/a	n/a	n/a		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

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

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: revision_no

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

Parameter	Content
Column name	revision_no
Description	Revision number of the definition (currently not in use).
Data type	String
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 63. 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		8,274	8,274 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

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

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: created_at

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

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 66. 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,023.0	2023-01-23 1…	2,023	2,023	2,023	2025-10-30 2…	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,157 ( 14.0% )

Table 67. 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%	13.98%	2023-12-27 14:42:13	2023-02-08 12:54:09

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: updated_at

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

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 69. 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,023	2,025	2025-12-18 2…	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,506 ( 30.3% )

Table 70. 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%	30.29%	2023-12-27 14:42:13	2025-03-14 14:22:53

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: deleted_at

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

Parameter	Content
Column name	deleted_at
Description	Date and time at which the record has been deleted.
Data type	Date and Time
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 72. 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 - 19	2,024.0	2023-09-18 0…	2,023	2,023	2,023	2025-04-15 0…	8,274	8,250 ( 99.7% )	0 ( 0.0% )	0 ( 0.0% )	25 ( 0.3% )

Table 73. 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.29%	0.30%	null	2023-11-01 14:12:13

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: status

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

Parameter	Content
Column name	status
Description	Status of the definition 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 75. 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	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Table 76. 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 42. Distribution of 20 most common values, from highest to lowest.

Completeness

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

Uniqueness

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

Column: valid_from

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

Parameter	Content
Column name	valid_from
Description	Date and time at which the validity of the class definition 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 78. 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,023.0	2023-01-23 1…	2,023	2,023	2,023	2025-12-03 1…	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,909 ( 23.1% )

Table 79. 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%	23.07%	2023-12-27 14:42:13	2025-03-14 14:22:53

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: valid_to

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

Parameter	Content
Column name	valid_to
Description	Date and time at which the validity of the class definition 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 81. 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,024.0	2023-09-02 1…	2,023	2,023	2,023	2025-12-03 1…	8,274	8,240 ( 99.6% )	0 ( 0.0% )	0 ( 0.0% )	33 ( 0.4% )

Table 82. 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.41%	0.40%	null	2025-04-06 08:54:28

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: user_id

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

Parameter	Content
Column name	user_id
Description	Identifier of the editor of the definition.
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 84. 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.0	1	3	3	3	74	8,274	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9 ( 0.1% )

Table 85. 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.11%	3	11

Data Distribution Top 20

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

Continuous Data Distribution

Figure 54. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: up_votes

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

Parameter	Content
Column name	up_votes
Description	The number of votes in favour of this translation in the creation process of the definition.
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 87. 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	9	8,274	0 ( 0.0% )	8,262 ( 99.9% )	0 ( 0.0% )	7 ( 0.1% )

Table 88. 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.08%	0	4

Data Distribution Top 20

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

Continuous Data Distribution

Figure 59. Distribution of values in the column.

Completeness

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

Uniqueness

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

Column: down_votes

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

Parameter	Content
Column name	down_votes
Description	The number of votes against this translation in the creation process of the definition.
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 90. 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	1 - 1	0.0	0	0	0	0	4	8,274	0 ( 0.0% )	8,265 ( 99.9% )	0 ( 0.0% )	4 ( 0.0% )

Table 91. 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.05%	0	4

Data Distribution Top 20

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

Continuous Data Distribution

Figure 63. Distribution of values in the column.

Completeness

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

Uniqueness

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

Table: domains

Column: id

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

Parameter	Content
Column name	id
Description	Identifier of the record.
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 93. 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 - 2	11.2	1	5	10	19	24	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	19 ( 100.0% )

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

Outliers

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

Completeness

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

Uniqueness

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

Column: name

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

Parameter	Content
Column name	name
Description	Name of the domain.
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 96. 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 - 19	n/a	Law	n/a	n/a	n/a	Veterinary M…	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	19 ( 100.0% )

Table 97. 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%	Apiculture	Apiculture

Completeness

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

Uniqueness

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

Column: description

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

Parameter	Content
Column name	description
Description	Description of the domain.
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 99. 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	6 - 191	n/a	unused	n/a	n/a	n/a	Terms relate…	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	14 ( 73.7% )

Table 100. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).

Column Name	Completeness	Uniqueness	Most Common Value	Least Common Value
description	100.00%	73.68%	unused	Terms related to the management of <i>Apis mellifera</i> or <i>Apis cerana</i>.

Completeness

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

Uniqueness

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

Column: abbreviation

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

Parameter	Content
Column name	abbreviation
Description	Abbreviation of the domain name.
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 102. 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
abbreviation	3 - 7	n/a	agr	n/a	n/a	n/a	vet-med	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	19 ( 100.0% )

Table 103. 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
abbreviation	100.00%	100.00%	apic	apic

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

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

Parameter	Content
Column name	parent_id
Description	Record identifier of the parent domain.
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 105. 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 - 2	6.4	3	3	5	9.5	13	19	9 ( 47.4% )	0 ( 0.0% )	0 ( 0.0% )	7 ( 36.8% )

Table 106. 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	52.63%	36.84%	null	13

Continuous Data Distribution

Figure 76. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: created_at

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

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 108. 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	2024-09-05 1…	2,024	2,024	2,024	2024-11-03 1…	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	6 ( 31.6% )

Table 109. 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%	31.58%	2024-09-05 12:43:29	2024-09-05 12:45:33

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: updated_at

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

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 111. 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	2024-09-05 1…	2,024	2,024	2,024	2024-11-03 1…	19	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8 ( 42.1% )

Table 112. 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%	42.11%	2024-09-05 12:43:29	2024-09-05 14:48:24

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Table: language

Column: id

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

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 114. 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 115. 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 86. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: name

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

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 117. 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 118. 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 90. Visualization of completeness of the data in the column.

Uniqueness

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

Table: term_analogy

Column: term_id

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

Parameter	Content
Column name	term_id
Description	EUPH code of the 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 120. 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	3 - 4	2,571.1	986	1,577.75	2,056.5	3,453	7,254	16	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	16 ( 100.0% )

Table 121. 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%	100.00%	3351	3351

Continuous Data Distribution

Figure 92. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: analogy_id

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

Parameter	Content
Column name	analogy_id
Description	EUPH code of the class of which the class is a synonym.
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 123. 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
analogy_id	1 - 4	4,321.4	6	615.25	3,613.5	7,940.75	8,202	16	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	15 ( 93.8% )

Table 124. 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
analogy_id	100.00%	93.75%	23	6

Continuous Data Distribution

Figure 96. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: terms

Column: id

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

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 126. 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,129.3	1	2,061.25	4,135.5	6,196.75	8,257	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,244 ( 100.0% )

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

Outliers

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

Completeness

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

Uniqueness

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

Column: description

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

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 129. 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 - 255	n/a		n/a	n/a	n/a	Cycloxydim i…	8,244	1 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,223 ( 99.7% )

Table 130. 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.99%	99.75%	honey production	Robinia pseudoacacia

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

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

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 132. 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 - 62	n/a		n/a	n/a	n/a	http://www.g…	8,244	7,393 ( 89.7% )	0 ( 0.0% )	0 ( 0.0% )	846 ( 10.3% )

Table 133. 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	10.32%	10.26%	null	https://www.gbif.org/species/5352251

Completeness

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

Uniqueness

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

Column: uid

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

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 135. 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		8,244	8,244 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 136. 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 108. Distribution of 20 most common values, from highest to lowest.

Completeness

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

Uniqueness

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

Column: annotation

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

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 138. 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…	8,244	8,012 ( 97.2% )	0 ( 0.0% )	0 ( 0.0% )	225 ( 2.7% )

Table 139. 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	2.81%	2.73%	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 111. Visualization of completeness of the data in the column.

Uniqueness

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

Column: release_no

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

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 141. 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	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 142. 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 113. Distribution of 20 most common values, from highest to lowest.

Completeness

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

Uniqueness

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

Column: revision_no

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

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 144. 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		8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 145. 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 116. Distribution of 20 most common values, from highest to lowest.

Completeness

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

Uniqueness

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

Column: created_at

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

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 147. 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,023.0	2023-01-23 1…	2,023	2,023	2,023	2025-10-30 2…	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,095 ( 13.3% )

Table 148. 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%	13.28%	2023-12-27 14:30:50	2023-02-08 12:59:55

Outliers

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

No data available.

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

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

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 150. 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…	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2,858 ( 34.7% )

Table 151. 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%	34.67%	2025-02-11 13:47:55	2025-03-14 14:22:59

Outliers

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

No data available.

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

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

Parameter	Content
Column name	deleted_at
Description	Date and time at which the record has been deleted.
Data type	Date and Time
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 153. 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 - 19	2,024.0	2023-09-10 1…	2,023	2,024	2,024	2025-01-14 1…	8,244	8,232 ( 99.9% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 0.2% )

Table 154. 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.15%	0.16%	null	2023-09-10 11:01:57

Data Distribution Top 20

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

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: status

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

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 156. 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	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	3 ( 0.0% )

Table 157. 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	approved

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: valid_from

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

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 159. 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,023.0	2023-01-23 1…	2,023	2,023	2,023	2025-10-30 2…	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,465 ( 17.8% )

Table 160. 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%	17.77%	2023-12-27 14:30:50	2023-09-02 17:59:34

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: valid_to

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

Parameter	Content
Column name	valid_to
Description	Date and time at which the validity of the class class 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 162. 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,024.0	2023-09-10 1…	2,023	2,024	2,024	2025-01-14 1…	8,244	8,232 ( 99.9% )	0 ( 0.0% )	0 ( 0.0% )	13 ( 0.2% )

Table 163. 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.15%	0.16%	null	2023-09-10 11:01:57

Data Distribution Top 20

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

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: user_id

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

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 165. 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.0	1	3	3	3	74	8,244	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	6 ( 0.1% )

Table 166. 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.07%	3	74

Data Distribution Top 20

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

Continuous Data Distribution

Figure 140. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: dataset_id

Table 167. 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	Integer number
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 168. 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	1 - 2	31.9	1	9	37	37	80	8,244	2,887 ( 35.0% )	0 ( 0.0% )	0 ( 0.0% )	8 ( 0.1% )

Table 169. 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	64.98%	0.10%	37	32

Data Distribution Top 20

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

Continuous Data Distribution

Figure 145. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: synonym_id

Table 170. 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 171. 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	2 - 4	962.6	23	428	434	1,298	2,965	8,244	8,237 ( 99.9% )	0 ( 0.0% )	0 ( 0.0% )	8 ( 0.1% )

Table 172. 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.08%	0.10%	null	428

Data Distribution Top 20

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

Continuous Data Distribution

Figure 150. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: definition_counter

Table 173. 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 174. 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	0	1	1	1	8	8,244	0 ( 0.0% )	5 ( 0.1% )	0 ( 0.0% )	6 ( 0.1% )

Table 175. 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.07%	1	8

Data Distribution Top 20

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

Continuous Data Distribution

Figure 155. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: terms_to_terms

Column: id

Table 176. 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 177. 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	6,051.0	1	3,194.75	6,053.5	8,884.25	12,024	9,958	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,958 ( 100.0% )

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

Outliers

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

Completeness

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

Uniqueness

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

Column: term_id

Table 179. 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 180. 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,005.4	1	1,723.75	3,813.5	6,286.25	8,257	9,958	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,239 ( 82.7% )

Table 181. 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%	82.74%	508	4

Continuous Data Distribution

Figure 163. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: parent_id

Table 182. 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 183. 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	3,567.6	1	1,088	3,950	3,977	8,257	9,958	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1,687 ( 16.9% )

Table 184. 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%	16.94%	3950	8046

Continuous Data Distribution

Figure 167. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: relationship_id

Table 185. 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 186. 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	8,029.2	670	8,141	8,141	8,141	8,252	9,958	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	53 ( 0.5% )

Table 187. 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%	0.53%	8141	1461

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Table: translations

Column: id

Table 188. 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 189. 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	14,942.4	1	7,519.75	14,953.5	22,397.25	29,830	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	29,734 ( 100.0% )

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

Outliers

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

Completeness

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

Uniqueness

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

Column: expression

Table 191. 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 192. 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 - 255	n/a		n/a	n/a	n/a	Cycloxydim i…	29,734	1 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	24,269 ( 81.6% )

Table 193. 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	100.00%	81.62%	2,4-D	Akazie

Completeness

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

Uniqueness

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

Column: term_id

Table 194. 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 195. 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,683.0	1	3,112	3,583	3,903	8,257	29,734	10 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	8,233 ( 27.7% )

Table 196. 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	99.97%	27.69%	3458	1154

Continuous Data Distribution

Figure 182. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: slug

Table 197. 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 198. 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		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 199. 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.00%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: uid

Table 200. 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
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 201. 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		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 202. 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.00%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: annotation

Table 203. 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 204. 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		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 205. 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.00%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: release_no

Table 206. 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	String
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 207. 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	0 - 0	n/a		n/a	n/a	n/a		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 208. 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	0.00%	0.00%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: revision_no

Table 209. 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	String
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 210. 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		29,734	29,734 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.0% )

Table 211. 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	0.00%	0.00%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: created_at

Table 212. 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 213. 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-12-17 1…	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,872 ( 33.2% )

Table 214. 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%	33.20%	2023-12-15 14:22:57	2023-02-08 11:59:08

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: updated_at

Table 215. 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 216. 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,023	2,025	2025-12-18 2…	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,555 ( 32.1% )

Table 217. 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%	32.13%	2023-12-15 14:22:57	2025-04-18 11:04:37

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: deleted_at

Table 218. 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	Date and Time
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 219. 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 - 19	2,024.0	2023-09-19 0…	2,023	2,023	2,023	2025-12-18 1…	29,734	29,599 ( 99.5% )	0 ( 0.0% )	0 ( 0.0% )	136 ( 0.5% )

Table 220. 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.45%	0.46%	null	2023-09-19 08:35:40

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: valid_from

Table 221. 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 222. 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-12-18 2…	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	9,460 ( 31.8% )

Table 223. 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%	31.82%	2023-12-15 14:22:57	2025-04-18 11:04:37

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: valid_to

Table 224. 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 225. 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,024.0	2023-09-02 1…	2,023	2,023	2,023	2025-12-18 1…	29,734	29,597 ( 99.5% )	0 ( 0.0% )	0 ( 0.0% )	136 ( 0.5% )

Table 226. 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.46%	0.46%	null	2023-09-02 17:56:37

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: language_id

Table 227. 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 228. 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	66.8	1	38	40	109	183	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	88 ( 0.3% )

Table 229. 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.30%	38	93

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: location_id

Table 230. 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 231. 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	29,734	29,733 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Table 232. 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.00%	0.01%	null	1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: inflections

Table 233. 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 234. 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…	29,734	29,548 ( 99.4% )	0 ( 0.0% )	0 ( 0.0% )	186 ( 0.6% )

Table 235. 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	0.63%	0.63%	null	Honigbiene {sg} \| Honigbienen {pl}

Completeness

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

Uniqueness

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

Column: description

Table 236. 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 237. 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…	29,734	29,733 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

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

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: grammtype

Table 239. 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 240. 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…	29,734	2,288 ( 7.7% )	0 ( 0.0% )	0 ( 0.0% )	12 ( 0.0% )

Table 241. 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	92.31%	0.04%	phrase	adverb

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: grammgender

Table 242. 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 243. 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	29,734	25,262 ( 85.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 0.0% )

Table 244. 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	15.04%	0.02%	null	common

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: grammnumber

Table 245. 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 246. 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	29,734	18,623 ( 62.6% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 0.0% )

Table 247. 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	37.37%	0.02%	null	paucal

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: status

Table 248. 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 249. 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	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Table 250. 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.01%	approved	draft

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: user_id

Table 251. 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 252. 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.5	1	3	3	3	74	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	18 ( 0.1% )

Table 253. 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.06%	3	45

Data Distribution Top 20

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

Continuous Data Distribution

Figure 246. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: synonym_id

Table 254. 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 255. 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,325.4	5	8,460.5	24,886	27,156	29,829	29,734	28,093 ( 94.5% )	0 ( 0.0% )	0 ( 0.0% )	1,388 ( 4.7% )

Table 256. 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	5.52%	4.67%	null	45

Continuous Data Distribution

Figure 250. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: up_votes

Table 257. 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 258. 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	29,734	0 ( 0.0% )	29,723 ( 100.0% )	0 ( 0.0% )	3 ( 0.0% )

Table 259. 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.01%	0	2

Data Distribution Top 20

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

Continuous Data Distribution

Figure 255. Distribution of values in the column.

Completeness

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

Uniqueness

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

Column: down_votes

Table 260. 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 261. 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 - 1	n/a		n/a	n/a	n/a	1	29,734	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.0% )

Table 262. 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	1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: translations_to_domains

Column: translation_id

Table 263. 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	translation_id
Description	Record ID 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 264. 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
translation_id	1 - 5	4,112.2	1	987	1,838	2,940	29,569	3,403	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	3,394 ( 99.7% )

Table 265. 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
translation_id	100.00%	99.74%	27698	1

Continuous Data Distribution

Figure 261. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: domain_id

Table 266. 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	domain_id
Description	Record ID of the domain
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 267. 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
domain_id	1 - 2	3.4	1	1	4	4	24	3,403	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	12 ( 0.4% )

Table 268. 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
domain_id	100.00%	0.35%	4	2

Data Distribution Top 20

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

Continuous Data Distribution

Figure 266. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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