, ,
• •

Dataset Report

Unique identifier:	CRTVS53.0.0
Title:	Corteva S18-00591
Long title:	Data on colony development in control groups of a field trial S18-00591
Status:	Quality Validated
Current Version:	v. 1.0
Published:	2023-12-20
Reviewed by:
Citation proposal:	EU Pollinator Hub 2023 Report of dataset Corteva S18-00591, v. 1.0 [CRTVS53.0.0]. EU Pollinator Hub. [2026-02-24] app.pollinatorhub.eu

Compliance with FAIR* principles
Findable	Accessible	Interoperable	Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles

Data Quality

Under evaluation

Table of content

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

Document history

Release

Version v. 1.0 released on 2023-12-20.

Revision

Table 1. List of revisions made to the document. Identifier of revision (No); date of revision (Date); description of revision (Description); reason for revision (Reason).

No	Date	Description	Reason
1	2023-12-20 00:12:00	Initial release.	n/a

Abbreviations

No abbreviations.

Executive summary

Data overview:

n/a

Data value:

n/a

Data description:

n/a

Data application:

n/a

Unresolved issues:

n/a

Introduction

n/a

Material and methods

Data acquisition

n/a

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	Corteva_S18-00591_hive_weight_PREP_MR_240108.csv	CSV - Comma seperated values	Yes	No	2024-01-08 12:01:03	6,360	33.81 KiB
2	Corteva_S18-00591_hive_development_PREP_MR_240108.csv	CSV - Comma seperated values	Yes	No	2024-01-08 12:01:15	1,800	12.79 KiB
3	Corteva_S18-00591_varroa_PREP_MR_240108.csv	CSV - Comma seperated values	Yes	No	2024-01-08 12:01:28	35	253.00 B
4	Corteva_S18-00591_virus_PREP_MR_240108.csv	CSV - Comma seperated values	Yes	No	2024-01-08 12:01:10	336	3.02 KiB
5	Corteva_S18-00591_apiary_PREP_MR_240108.csv	CSV - Comma seperated values	Yes	No	2024-01-08 12:01:02	6	108.00 B

Data preparation

n/a

Data validation

n/a

Data analysis

n/a

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	Colony weight	The table contains data on hive weights of test colonies from the control group of a field trial near Pforzheim,…
2	Colony development	The table contains data on colony assessments (number of adult bees, number of brood cells, number of cells with food)…
3	Varroa	The table contains the results on Varroa infestation of test colonies from the control group of a field trial near…
4	Virus	The table contains results from an analyses on the presence of a range of honey bee viruses, which wer emade…
5	Apiary	The table contains information on the position of the test site. Note that geographical coordinates are blurred.

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

Parameter	Content
interactions.single.uid	CRTVS53.0.0
Title	Corteva S18-00591
Long title	Data on colony development in control groups of a field trial S18-00591
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/CRTVS53.0.0
interactions.single.section-details.licence	CC BY-SA 4.0
DOI	n/a
Created	2023-10-10
Published	2023-12-20
Contact	n/a
Keywords	Germany, Varroa destructor, Virus, colony development, hive scale
Data collection years	2018-2019
Regions, the data was collected in	Pforzheim, Stadtkreis
Abstract	The data contains results on the assessment of colony development in control groups of a field trial near Pforzheim, Germany from May 2018 to April 2019. Hive weights were recorded daily between 10:00 pm and 2:00 am at the next day from 2018-05-26 to 2018-10-30 and on 2019-04-19. Colony assessments (number of adult bees, number of brood cells, number of cells with food) were made at irregular intervals of 6 to 16 days from 2018-05-23 to 2018-10-31 and again after overwintering on 2019-04-09. Varroa infestation was measured once, in October 2018. Analyses on the presence of honey bee viruses were made on samples collected in June 2018 in 2 colonies.

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

Parameter	Content
Name	EU Pollinator Hub
Url
Acronym	EUPH
IRI	https://app.pollinatorhub.eu/data-providers/euph
Address
Country	Belgium
Contact	https://www.linkedin.com/company/beelife-european-beekeeping-coordination/ pollinatorhub.eu
Description	The EU Pollinator Hub (EUPH) is a data hub related to pollinators, which is provided by the European Food Safety Authority (EFSA).

Tables

Colony weight

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

Parameter	Content
Unique identifier	CRTVS53.CLNYW184.0
Name	Colony weight
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/CRTVS53.CLNYW184.0
Table Type	File
Licence	CC BY-SA 4.0
Description	The table contains data on hive weights of test colonies from the control group of a field trial near Pforzheim, Germany. Hive weights were recorded daily between 10:00 pm and 2:00 am at the next day from 2018-05-26 to 2018-10-30 and on 2019-04-19.

The table contains data on hive weights of test colonies from the control group of a field trial near Pforzheim, Germany. Hive weights were recorded daily between 10:00 pm and 2:00 am at the next day from 2018-05-26 to 2018-10-30 and on 2019-04-19.

Metadata

n/a

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

Column Name	Column Description	Datatype	Descriptor	Unit
id	Identifier of the record.	String	pms:recordID [0.0.RCRDD344]	n/a
date	Date of hive weight recording.	Date	iso-8601:calendarDate [0.0.DATEA317]	n/a
time	Time of hive weight recording.	Time	Time [0.0.TIMEA318]	n/a
apiary_id	Identifier if the apiary.	String	pms:apiaryID [0.0.PRYID342]	n/a
hive_id	Identifier of the hive.	String	pms:beehiveID [0.0.HVEID216]	n/a
hive_weight	Hive weight in kg recorded each day between 10:00 pm and 2:00 am at the next day.	Decimal number	pms:hiveWeight [0.0.HVWGH33]	kg
timing_code	Internal code referring to the scheduling of events in the study design.	String	Text [0.0.TEXTA315]	n/a
comment	Comments related to the record.	String	dwc:fieldNotes [0.0.FLDNT691]	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 - 3	398.0	1	199	398	597	795	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	795 ( 100.0% )
date	10 - 10	2,018.0	2018-05-26	2,018	2,018	2,018	2019-04-09	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	159 ( 20.0% )
time	0 - 0	n/a		n/a	n/a	n/a		795	795 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.1% )
apiary_id	1 - 1	n/a	1	n/a	n/a	n/a	1	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.1% )
hive_id	2 - 2	n/a	Ca	n/a	n/a	n/a	Ce	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 0.6% )
hive_weight	4 - 4	38.53	21.4	30.175	35.15	48	54.3	795	1 ( 0.1% )	0 ( 0.0% )	0 ( 0.0% )	242 ( 30.4% )
timing_code	4 - 6	n/a	0DBF	n/a	n/a	n/a	314DAF	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	159 ( 20.0% )
comment	0 - 56	n/a		n/a	n/a	n/a	feeding of t…	795	774 ( 97.4% )	0 ( 0.0% )	0 ( 0.0% )	3 ( 0.4% )

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
date	100.00%	20.00%	2018-05-26	2018-05-26
time	0.00%	0.13%	null	null
apiary_id	100.00%	0.13%	1	1
hive_id	100.00%	0.63%	Ca	Ca
hive_weight	99.87%	30.44%	51.8	26.4
timing_code	100.00%	20.00%	4DBF	4DBF
comment	2.64%	0.38%	null	Hive dead

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Colony development

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

Parameter	Content
Unique identifier	CRTVS53.CLNYD185.0
Name	Colony development
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/CRTVS53.CLNYD185.0
Table Type	File
Licence	CC BY-SA 4.0
Description	The table contains data on colony assessments (number of adult bees, number of brood cells, number of cells with food) of test colonies from the control group of a field trial near Pforzheim, Germany. Recordings were made at an interval of 6 to 16 days from 2018-05-23 to 2018-10-31 and again after overwintering on 2019-04-09.

The table contains data on colony assessments (number of adult bees, number of brood cells, number of cells with food) of test colonies from the control group of a field trial near Pforzheim, Germany. Recordings were made at an interval of 6 to 16 days from 2018-05-23 to 2018-10-31 and again after overwintering on 2019-04-09.

Metadata

n/a

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

Column Name	Column Description	Datatype	Descriptor	Unit
id	Identifier of the record.	String	Text [0.0.TEXTA315]	n/a
date	Date of the colony assessment.	Date	iso-8601:calendarDate [0.0.DATEA317]	n/a
apiary_id	Identifier if the apiary.	String	Text [0.0.TEXTA315]	n/a
hive_id	Identifier of the hive.	String	Text [0.0.TEXTA315]	n/a
timing_code	Internal code referring to the scheduling of events in the study design.	String	Text [0.0.TEXTA315]	n/a
endpoint	Variable measured during the assessment of a colony: No. of bees, number of adult bees; No. of cells with brood, number of brood cells; No. of cells with food, number of cells with food.	String	Text [0.0.TEXTA315]	n/a
endpoint_data	Value measured for the variable specified in column endpoint.	Integer number	Integer [0.0.NTGER313]	no.
comment	Comments related to the record.	String	Text [0.0.TEXTA315]	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 - 3	113.0	1	56.5	113	169.5	225	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	225 ( 100.0% )
date	10 - 10	n/a	2018-05-23	n/a	n/a	n/a	2019-04-09	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	15 ( 6.7% )
apiary_id	1 - 1	n/a	1	n/a	n/a	n/a	1	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.4% )
hive_id	2 - 2	n/a	Ca	n/a	n/a	n/a	Ce	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 2.2% )
timing_code	4 - 7	n/a	113 DAF	n/a	n/a	n/a	98 DAF	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	15 ( 6.7% )
endpoint	11 - 23	n/a	No. of bees	n/a	n/a	n/a	No. of cells…	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	3 ( 1.3% )
endpoint_data	4 - 5	23,086.7	3,000	9,800	14,285	30,758.75	88,600	225	3 ( 1.3% )	0 ( 0.0% )	0 ( 0.0% )	178 ( 79.1% )
comment	0 - 9	n/a	Hive dead	n/a	n/a	n/a	Hive dead	225	222 ( 98.7% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.9% )

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
date	100.00%	6.67%	2018-05-23	2018-05-23
apiary_id	100.00%	0.44%	1	1
hive_id	100.00%	2.22%	Ca	Ca
timing_code	100.00%	6.67%	7DBF	7DBF
endpoint	100.00%	1.33%	No. of bees	No. of bees
endpoint_data	98.67%	79.11%	12935	8775
comment	1.33%	0.89%	n/a	Hive dead

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Varroa

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

Parameter	Content
Unique identifier	CRTVS53.VRROA186.0
Name	Varroa
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/CRTVS53.VRROA186.0
Table Type	File
Licence	CC BY-SA 4.0
Description	The table contains the results on Varroa infestation of test colonies from the control group of a field trial near Pforzheim, Germany, measured in October 2018.

The table contains the results on Varroa infestation of test colonies from the control group of a field trial near Pforzheim, Germany, measured in October 2018.

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	Identifier of the record.	Integer number	Integer [0.0.NTGER313]	n/a
date_start	Date on which the measurement of natural mite fall was started.	Date	iso-8601:calendarDate [0.0.DATEA317]	n/a
date_end	Date on which the measurement of natural mite fall was stopped.	Date	iso-8601:calendarDate [0.0.DATEA317]	n/a
apiary_id	Identifier if the apiary.	Boolean	Boolean [0.0.BLEAN316]	n/a
hive_id	Identifier of the hive.	String	Text [0.0.TEXTA315]	n/a
mite_count	Number of mites measured on a sticky board in the period ranging from the date in column date_start to date_end.	Integer number	Integer [0.0.NTGER313]	no.
infestation	Varroa infestation of the colony, measured as natural mite fall and expressed in number of Varroa mites per day.	Decimal number	DecimalNumber [0.0.DCMLN314]	mites d-1

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 - 1	3.0	1	1.5	3	4.5	5	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 100.0% )
date_start	10 - 10	n/a	2018-10-15	n/a	n/a	n/a	2018-10-15	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 20.0% )
date_end	10 - 10	n/a	2018-10-22	n/a	n/a	n/a	2018-10-22	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 20.0% )
apiary_id	1 - 1	n/a	1	n/a	n/a	n/a	1	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 20.0% )
hive_id	2 - 2	n/a	Ca	n/a	n/a	n/a	Ce	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 100.0% )
mite_count	2 - 2	17.8	10	10	13	28	36	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	4 ( 80.0% )
infestation	3 - 3	2.54	1.4	1.4	1.9	4	5.1	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	4 ( 80.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
date_start	100.00%	20.00%	2018-10-15	2018-10-15
date_end	100.00%	20.00%	2018-10-22	2018-10-22
apiary_id	100.00%	20.00%	1	1
hive_id	100.00%	100.00%	Ca	Ca
mite_count	100.00%	80.00%	10	13
infestation	100.00%	80.00%	1.4	1.9

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Virus

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

Parameter	Content
Unique identifier	CRTVS53.VIRUS187.0
Name	Virus
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/CRTVS53.VIRUS187.0
Table Type	File
Licence	CC BY-SA 4.0
Description	The table contains results from an analyses on the presence of a range of honey bee viruses, which wer emade on samples collected in June 2018 in 2 colonies.

The table contains results from an analyses on the presence of a range of honey bee viruses, which wer emade on samples collected in June 2018 in 2 colonies.

Metadata

n/a

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

Column Name	Column Description	Datatype	Descriptor	Unit
id	Identifier of the record.	String	Text [0.0.TEXTA315]	n/a
date_sampling	Date of sampling.	Date	iso-8601:calendarDate [0.0.DATEA317]	n/a
apiary_id	Identifier if the apiary.	String	Text [0.0.TEXTA315]	n/a
hive_id	Identifier of the hive.	String	Text [0.0.TEXTA315]	n/a
timing_code	Internal code referring to the scheduling of events in the study design.	String	Text [0.0.TEXTA315]	n/a
sample_description	Description of the matrix which was analysed: Dead bees from dead bee trap/bottom; Alive bees from bee hive.	String	Text [0.0.TEXTA315]	n/a
virus	Virus analyses in the matrix specified in column dample_description: DWV, Deformed Wing Virus; SBV, Sackbrood Virus; ABPV, Acute Bee Paralysis Virus; CBPV, Chronic Bee Paralysis Virus; KBV, Kashmere Bee Virus; BQCV, Black-Queen-Cell Virus; IAPV, Israeli Acute Paralysis Virus.	String	Text [0.0.TEXTA315]	n/a
result	Result of the analysis: positive, virus specidied in column virus was present in the sample described in column dample_matrix; negative, virus specidied in column virus was absent from the sample described in column dample_matrix.	String	Text [0.0.TEXTA315]	n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 20. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).

Column Name	Range	Mean	Minimum	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
id	1 - 2	21.5	1	10.75	21.5	32.25	42	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	42 ( 100.0% )
date_sampling	10 - 10	n/a	2018-06-22	n/a	n/a	n/a	2018-06-23	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.8% )
apiary_id	1 - 1	n/a	1	n/a	n/a	n/a	1	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 2.4% )
hive_id	2 - 2	n/a	Ca	n/a	n/a	n/a	Cb	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.8% )
timing_code	5 - 5	n/a	23DAF	n/a	n/a	n/a	24DAF	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.8% )
sample_description	24 - 35	n/a	Alive bees f…	n/a	n/a	n/a	Dead bees fr…	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.8% )
virus	3 - 4	n/a	ABPV	n/a	n/a	n/a	SBV	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	7 ( 16.7% )
result	8 - 8	n/a	negative	n/a	n/a	n/a	positive	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.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
id	100.00%	100.00%	1	1
date_sampling	100.00%	4.76%	2018-06-23	2018-06-22
apiary_id	100.00%	2.38%	1	1
hive_id	100.00%	4.76%	Ca	Ca
timing_code	100.00%	4.76%	24DAF	23DAF
sample_description	100.00%	4.76%	Dead bees from dead bee trap/bottom	Alive bees from bee hive
virus	100.00%	16.67%	DWV	DWV
result	100.00%	4.76%	negative	positive

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Apiary

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

Parameter	Content
Unique identifier	CRTVS53.PIARY188.0
Name	Apiary
Target IRI	https://app.pollinatorhub.eu/dataset-discovery/parts/CRTVS53.PIARY188.0
Table Type	File
Licence	CC BY-SA 4.0
Description	The table contains information on the position of the test site. Note that geographical coordinates are blurred.

The table contains information on the position of the test site. Note that geographical coordinates are blurred.

Metadata

n/a

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

Column Name	Column Description	Datatype	Descriptor	Unit
id	Identifier of the record.	Boolean	Boolean [0.0.BLEAN316]	n/a
elevation	Height above sea level of the test site in m.	Decimal number	DecimalNumber [0.0.DCMLN314]	m
latitude_blurred	Geographical position of the test site. Latitude, measured in degrees. Note that the poosition has been blurred.	Decimal number	DecimalNumber [0.0.DCMLN314]	°
longitude_blurred	Geographical position of the test site. Longitude, measured in degrees. Note that the poosition has been blurred.	Decimal number	DecimalNumber [0.0.DCMLN314]	°
LAU	Code of the local administrative unit (LAU) in which the test site was located.	Integer number	Integer [0.0.NTGER313]	n/a
NUTS	NUTS Code of the region in which the test site was located.	String	Text [0.0.TEXTA315]	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 - 1	n/a	1	n/a	n/a	n/a	1	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )
elevation	3 - 3	349.0	349	n/a	n/a	n/a	349	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )
latitude_blurred	12 - 12	48.9095938800	48.909593880	n/a	n/a	n/a	48.909593880	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )
longitude_blurred	11 - 11	8.7665216700	8.766521670	n/a	n/a	n/a	8.766521670	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )
LAU	7 - 7	8,231,000.0	8,231,000	n/a	n/a	n/a	8,231,000	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )
NUTS	5 - 5	n/a	DE129	n/a	n/a	n/a	DE129	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )

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
elevation	100.00%	100.00%	349	349
latitude_blurred	100.00%	100.00%	48.909593880	48.909593880
longitude_blurred	100.00%	100.00%	8.766521670	8.766521670
LAU	100.00%	100.00%	8231000	8231000
NUTS	100.00%	100.00%	DE129	DE129

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

References

There are no sources in the current document.

Annex 1: Table column reports

Table: Colony weight

Column: id

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

Parameter	Content
Column name	id
Description	Identifier of the record.
Data type	String
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 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	Range	Mean	Minimum	Q₁	Median	Q₃	Maximum	Total	Missing	Zero	Blank	Distinct
id	1 - 3	398.0	1	199	398	597	795	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	795 ( 100.0% )

Table 28. 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: date

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

Parameter	Content
Column name	date
Description	Date of hive weight recording.
Data type	Date
Descriptor	iso-8601:calendarDate [UID:0.0.DATEA317]
Descriptor description	particular calendar day [...] represented by its calendar year [...], its calendar month [...] and its calendar day of month [...]
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DATEA317
Unit	n/a

Table 30. Structural analysis of the table. Column name (Name); concise description 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
date	10 - 10	2,018.0	2018-05-26	2,018	2,018	2,018	2019-04-09	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	159 ( 20.0% )

Table 31. 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
date	100.00%	20.00%	2018-05-26	2018-05-26

Outliers

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

No data available.

Completeness

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

Uniqueness

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

Column: time

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

Parameter	Content
Column name	time
Description	Time of hive weight recording.
Data type	Time
Descriptor	Time [UID:0.0.TIMEA318]
Descriptor description	The physical quantity time, attributed to an instant or a time interval on a specified time scale.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TIMEA318
Unit	n/a

Table 33. Structural analysis of the table. Column name (Name); concise description 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
time	0 - 0	n/a		n/a	n/a	n/a		795	795 ( 100.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.1% )

Table 34. 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
time	0.00%	0.13%	null	null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: apiary_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).

Parameter	Content
Column name	apiary_id
Description	Identifier if the apiary.
Data type	String
Descriptor	pms:apiaryID [UID:0.0.PRYID342]
Descriptor description	An apiary ID is a unique sequence of characters associated with an apiary, which is specific to a dataset or to a beekeeper.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PRYID342
Unit	n/a

Table 36. Structural analysis of the table. Column name (Name); concise description 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
apiary_id	1 - 1	n/a	1	n/a	n/a	n/a	1	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.1% )

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
apiary_id	100.00%	0.13%	1	1

Data Distribution Top 20

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

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: hive_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	hive_id
Description	Identifier of the hive.
Data type	String
Descriptor	pms:beehiveID [UID:0.0.HVEID216]
Descriptor description	A beehive ID is a unique sequence of characters associated with a beehive, which is specific to a dataset, to an apiary or to a beekeeper.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HVEID216
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
hive_id	2 - 2	n/a	Ca	n/a	n/a	n/a	Ce	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 0.6% )

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
hive_id	100.00%	0.63%	Ca	Ca

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: hive_weight

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	hive_weight
Description	Hive weight in kg recorded each day between 10:00 pm and 2:00 am at the next day.
Data type	Decimal number
Descriptor	pms:hiveWeight [UID:0.0.HVWGH33]
Descriptor description	A hive weight is a measurement of the mass of a beehive.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HVWGH33
Unit	kg

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
hive_weight	4 - 4	38.53	21.4	30.175	35.15	48	54.3	795	1 ( 0.1% )	0 ( 0.0% )	0 ( 0.0% )	242 ( 30.4% )

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
hive_weight	99.87%	30.44%	51.8	26.4

Continuous Data Distribution

Figure 17. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: timing_code

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	timing_code
Description	Internal code referring to the scheduling of events in the study design.
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 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
timing_code	4 - 6	n/a	0DBF	n/a	n/a	n/a	314DAF	795	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	159 ( 20.0% )

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
timing_code	100.00%	20.00%	4DBF	4DBF

Completeness

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

Uniqueness

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

Column: comment

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	comment
Description	Comments related to the record.
Data type	String
Descriptor	dwc:fieldNotes [UID:0.0.FLDNT691]
Descriptor description	A text of notes taken in the field.
Descriptor target IRI	http://rs.tdwg.org/dwc/terms/fieldNotes
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
comment	0 - 56	n/a		n/a	n/a	n/a	feeding of t…	795	774 ( 97.4% )	0 ( 0.0% )	0 ( 0.0% )	3 ( 0.4% )

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
comment	2.64%	0.38%	null	Hive dead

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: Colony development

Column: id

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	id
Description	Identifier of the record.
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
id	1 - 3	113.0	1	56.5	113	169.5	225	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	225 ( 100.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
id	100.00%	100.00%	1	1

Continuous Data Distribution

Figure 26. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: date

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	date
Description	Date of the colony assessment.
Data type	Date
Descriptor	iso-8601:calendarDate [UID:0.0.DATEA317]
Descriptor description	particular calendar day [...] represented by its calendar year [...], its calendar month [...] and its calendar day of month [...]
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DATEA317
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
date	10 - 10	n/a	2018-05-23	n/a	n/a	n/a	2019-04-09	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	15 ( 6.7% )

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
date	100.00%	6.67%	2018-05-23	2018-05-23

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: apiary_id

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	apiary_id
Description	Identifier if the apiary.
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
apiary_id	1 - 1	n/a	1	n/a	n/a	n/a	1	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 0.4% )

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
apiary_id	100.00%	0.44%	1	1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: hive_id

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	hive_id
Description	Identifier of the hive.
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 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
hive_id	2 - 2	n/a	Ca	n/a	n/a	n/a	Ce	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 2.2% )

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
hive_id	100.00%	2.22%	Ca	Ca

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: timing_code

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	timing_code
Description	Internal code referring to the scheduling of events in the study design.
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 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
timing_code	4 - 7	n/a	113 DAF	n/a	n/a	n/a	98 DAF	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	15 ( 6.7% )

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
timing_code	100.00%	6.67%	7DBF	7DBF

Data Distribution Top 20

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

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

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	endpoint
Description	Variable measured during the assessment of a colony: No. of bees, number of adult bees; No. of cells with brood, number of brood cells; No. of cells with food, number of cells with food.
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 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
endpoint	11 - 23	n/a	No. of bees	n/a	n/a	n/a	No. of cells…	225	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	3 ( 1.3% )

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
endpoint	100.00%	1.33%	No. of bees	No. of bees

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

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	endpoint_data
Description	Value measured for the variable specified in column endpoint.
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	no.

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
endpoint_data	4 - 5	23,086.7	3,000	9,800	14,285	30,758.75	88,600	225	3 ( 1.3% )	0 ( 0.0% )	0 ( 0.0% )	178 ( 79.1% )

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
endpoint_data	98.67%	79.11%	12935	8775

Continuous Data Distribution

Figure 45. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: comment

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	comment
Description	Comments related to the record.
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 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
comment	0 - 9	n/a	Hive dead	n/a	n/a	n/a	Hive dead	225	222 ( 98.7% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 0.9% )

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
comment	1.33%	0.89%	n/a	Hive dead

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: Varroa

Column: id

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	id
Description	Identifier of the record.
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 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
id	1 - 1	3.0	1	1.5	3	4.5	5	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 100.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
id	100.00%	100.00%	1	1

Continuous Data Distribution

Figure 52. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: date_start

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	date_start
Description	Date on which the measurement of natural mite fall was started.
Data type	Date
Descriptor	iso-8601:calendarDate [UID:0.0.DATEA317]
Descriptor description	particular calendar day [...] represented by its calendar year [...], its calendar month [...] and its calendar day of month [...]
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DATEA317
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
date_start	10 - 10	n/a	2018-10-15	n/a	n/a	n/a	2018-10-15	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 20.0% )

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
date_start	100.00%	20.00%	2018-10-15	2018-10-15

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: date_end

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	date_end
Description	Date on which the measurement of natural mite fall was stopped.
Data type	Date
Descriptor	iso-8601:calendarDate [UID:0.0.DATEA317]
Descriptor description	particular calendar day [...] represented by its calendar year [...], its calendar month [...] and its calendar day of month [...]
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DATEA317
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
date_end	10 - 10	n/a	2018-10-22	n/a	n/a	n/a	2018-10-22	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 20.0% )

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
date_end	100.00%	20.00%	2018-10-22	2018-10-22

Data Distribution Top 20

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

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: apiary_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	apiary_id
Description	Identifier if the apiary.
Data type	Boolean
Descriptor	Boolean [UID:0.0.BLEAN316]
Descriptor description	A basic type representing boolean. Supports a simple true or false value.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.BLEAN316
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
apiary_id	1 - 1	n/a	1	n/a	n/a	n/a	1	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 20.0% )

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
apiary_id	100.00%	20.00%	1	1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: hive_id

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	hive_id
Description	Identifier of the hive.
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 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
hive_id	2 - 2	n/a	Ca	n/a	n/a	n/a	Ce	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	5 ( 100.0% )

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
hive_id	100.00%	100.00%	Ca	Ca

Completeness

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

Uniqueness

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

Column: mite_count

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	mite_count
Description	Number of mites measured on a sticky board in the period ranging from the date in column date_start to date_end.
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	no.

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
mite_count	2 - 2	17.8	10	10	13	28	36	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	4 ( 80.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
mite_count	100.00%	80.00%	10	13

Continuous Data Distribution

Figure 67. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: infestation

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	infestation
Description	Varroa infestation of the colony, measured as natural mite fall and expressed in number of Varroa mites per day.
Data type	Decimal number
Descriptor	DecimalNumber [UID:0.0.DCMLN314]
Descriptor description	Any of the rational or irrational numbers.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit	mites d-1

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
infestation	3 - 3	2.54	1.4	1.4	1.9	4	5.1	5	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	4 ( 80.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
infestation	100.00%	80.00%	1.4	1.9

Continuous Data Distribution

Figure 71. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Virus

Column: id

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	id
Description	Identifier of the record.
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
id	1 - 2	21.5	1	10.75	21.5	32.25	42	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	42 ( 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
id	100.00%	100.00%	1	1

Continuous Data Distribution

Figure 75. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: date_sampling

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	date_sampling
Description	Date of sampling.
Data type	Date
Descriptor	iso-8601:calendarDate [UID:0.0.DATEA317]
Descriptor description	particular calendar day [...] represented by its calendar year [...], its calendar month [...] and its calendar day of month [...]
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DATEA317
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
date_sampling	10 - 10	n/a	2018-06-22	n/a	n/a	n/a	2018-06-23	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.8% )

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
date_sampling	100.00%	4.76%	2018-06-23	2018-06-22

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: apiary_id

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	apiary_id
Description	Identifier if the apiary.
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
apiary_id	1 - 1	n/a	1	n/a	n/a	n/a	1	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 2.4% )

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
apiary_id	100.00%	2.38%	1	1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: hive_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	hive_id
Description	Identifier of the hive.
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 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
hive_id	2 - 2	n/a	Ca	n/a	n/a	n/a	Cb	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.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
hive_id	100.00%	4.76%	Ca	Ca

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: timing_code

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	timing_code
Description	Internal code referring to the scheduling of events in the study design.
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 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
timing_code	5 - 5	n/a	23DAF	n/a	n/a	n/a	24DAF	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.8% )

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
timing_code	100.00%	4.76%	24DAF	23DAF

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: sample_description

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	sample_description
Description	Description of the matrix which was analysed: Dead bees from dead bee trap/bottom; Alive bees from bee hive.
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 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
sample_description	24 - 35	n/a	Alive bees f…	n/a	n/a	n/a	Dead bees fr…	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.8% )

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
sample_description	100.00%	4.76%	Dead bees from dead bee trap/bottom	Alive bees from bee hive

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: virus

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	virus
Description	Virus analyses in the matrix specified in column dample_description: DWV, Deformed Wing Virus; SBV, Sackbrood Virus; ABPV, Acute Bee Paralysis Virus; CBPV, Chronic Bee Paralysis Virus; KBV, Kashmere Bee Virus; BQCV, Black-Queen-Cell Virus; IAPV, Israeli Acute Paralysis Virus.
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 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
virus	3 - 4	n/a	ABPV	n/a	n/a	n/a	SBV	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	7 ( 16.7% )

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
virus	100.00%	16.67%	DWV	DWV

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

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	result
Description	Result of the analysis: positive, virus specidied in column virus was present in the sample described in column dample_matrix; negative, virus specidied in column virus was absent from the sample described in column dample_matrix.
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 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
result	8 - 8	n/a	negative	n/a	n/a	n/a	positive	42	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	2 ( 4.8% )

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
result	100.00%	4.76%	negative	positive

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: Apiary

Column: 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	id
Description	Identifier of the record.
Data type	Boolean
Descriptor	Boolean [UID:0.0.BLEAN316]
Descriptor description	A basic type representing boolean. Supports a simple true or false value.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.BLEAN316
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
id	1 - 1	n/a	1	n/a	n/a	n/a	1	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 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
id	100.00%	100.00%	1	1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: elevation

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	elevation
Description	Height above sea level of the test site in m.
Data type	Decimal number
Descriptor	DecimalNumber [UID:0.0.DCMLN314]
Descriptor description	Any of the rational or irrational numbers.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit	m

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
elevation	3 - 3	349.0	349	n/a	n/a	n/a	349	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )

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
elevation	100.00%	100.00%	349	349

Data Distribution Top 20

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

Continuous Data Distribution

Figure 103. Distribution of values in the column.

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

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	latitude_blurred
Description	Geographical position of the test site. Latitude, measured in degrees. Note that the poosition has been blurred.
Data type	Decimal number
Descriptor	DecimalNumber [UID:0.0.DCMLN314]
Descriptor description	Any of the rational or irrational numbers.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit	°

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
latitude_blurred	12 - 12	48.9095938800	48.909593880	n/a	n/a	n/a	48.909593880	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 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
latitude_blurred	100.00%	100.00%	48.909593880	48.909593880

Data Distribution Top 20

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

Continuous Data Distribution

Figure 107. Distribution of values in the column.

Completeness

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

Uniqueness

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

Column: longitude_blurred

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	longitude_blurred
Description	Geographical position of the test site. Longitude, measured in degrees. Note that the poosition has been blurred.
Data type	Decimal number
Descriptor	DecimalNumber [UID:0.0.DCMLN314]
Descriptor description	Any of the rational or irrational numbers.
Descriptor target IRI	https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit	°

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
longitude_blurred	11 - 11	8.7665216700	8.766521670	n/a	n/a	n/a	8.766521670	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )

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
longitude_blurred	100.00%	100.00%	8.766521670	8.766521670

Data Distribution Top 20

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

Continuous Data Distribution

Figure 111. Distribution of values in the column.

Completeness

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

Uniqueness

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

Column: LAU

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	LAU
Description	Code of the local administrative unit (LAU) in which the test site was located.
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 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
LAU	7 - 7	8,231,000.0	8,231,000	n/a	n/a	n/a	8,231,000	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.0% )

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
LAU	100.00%	100.00%	8231000	8231000

Data Distribution Top 20

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

Continuous Data Distribution

Figure 115. Distribution of values in the column.

Completeness

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

Uniqueness

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

Column: NUTS

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	NUTS
Description	NUTS Code of the region in which the test site was located.
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
NUTS	5 - 5	n/a	DE129	n/a	n/a	n/a	DE129	1	0 ( 0.0% )	0 ( 0.0% )	0 ( 0.0% )	1 ( 100.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
NUTS	100.00%	100.00%	DE129	DE129

Data Distribution Top 20

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

Completeness

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

Uniqueness

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