EU Pollinator Hub

, ,

Dataset Report
Unique identifier: BSCLD32.0.0
Title: Boscalid time-to-death ecotox
Long title: Time-to-death approach to reveal chronic and cumulative toxicity of a fungicide for honeybees not revealed with the standard ten-day test
Status: Quality Validated
Current Version: v. 1.0
Published: 2024-01-24
Reviewed by:
Citation proposal:
EU Pollinator Hub, San Martin 2024 Report of dataset Boscalid time-to-death ecotox, v. 1.0 [BSCLD32.0.0]. EU Pollinator Hub. [2026-02-24] app.pollinatorhub.eu
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
Under evaluation

Document history

Release

Version v. 1.0 released on 2024-01-24.

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 2024-01-24 00:01: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 Mortality.csv CSV - Comma seperated values Yes No 2024-01-25 12:01:08 12,240 47.01 KiB

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 Mortality This table contains the mortality data over time for the different treatments (different pesticides) along with behavioral observations (number of…
2 Evaporation The difference of syrup weight has been measured between two consecutive days in cages without bees or with dead bees…
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid BSCLD32.0.0
Title Boscalid time-to-death ecotox
Long title Time-to-death approach to reveal chronic and cumulative toxicity of a fungicide for honeybees not revealed with the standard ten-day test
Target IRI https://app.pollinatorhub.eu/dataset-discovery/BSCLD32.0.0
interactions.single.section-details.licence CC BY 4.0
DOI n/a
Created 2023-09-20
Published 2024-01-24
Contact g.sanmartin@cra.wallonie.be simon@bee-life.eu
Keywords boscalid, ecotoxicological test, ecotoxicology, pesticides, toxicity
Data collection years n/a
Regions, the data was collected in n/a
Abstract

Raw data from a study about chronic toxicity of boscalid on honey bees available on figshare : https://figshare.com/s/865e87feaad34c095bbd and published in Scientific Reports : https://doi.org/10.1038/s41598-018-24746-9

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

Table 6. Standardised metadata of the data provider San Martin. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name San Martin
Url
Acronym GSM
IRI https://app.pollinatorhub.eu/data-providers/gilles-san-martin-2
Contact g.sanmartin@cra.wallonie.be Walloon Agricultural Research Centre (CRA-W) rue de Liroux 2 5030 Gembloux Belgium https://twitter.com/GillesSanMartin
Description

Tables

Mortality

Table 7. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BSCLD32.MRTLT68.0
Name Mortality
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BSCLD32.MRTLT68.0
Table Type File
Licence CC BY 4.0
Description

This table contains the mortality data over time for the different treatments (different pesticides) along with behavioral observations (number of bees with abnormal behavior) and the weight of the sugar syrup used as food and exposure to pesticides before and after consumption (to estimate the real consumption by the bees and estimate the dose from the concentration data).

The data from the last day (D33) have been removed because there was no data about syrup consumption on this last day

This table contains the mortality data over time for the different treatments (different pesticides) along with behavioral observations (number of bees with abnormal behavior) and the weight of the sugar syrup used as food and exposure to pesticides before and after consumption (to estimate the real consumption by the bees and estimate the dose from the concentration data).

The data from the last day (D33) have been removed because there was no data about syrup consumption on this last day

Metadata

n/a
Table 8. Structural analysis of the table. Column name (Name); concise description 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
Treat

Treatments: CANTUS (commercial name of the fungicide containing boscalid), 2CNA (not used in this test), TS (toxic standard), CONTROL (control treatment).

String treatment [BSCLD32.0.TRTMN397]

n/a

Rep

Identifier of the replicate.

Integer number replicate [BSCLD32.0.RPLCT398]

n/a

Conc

Concentration of the active ingredient in the syrup (sugar solution), expressed in mg active ingredient/l syrup.

Decimal number pms:massConcentration [0.0.CNCNT399]

mg L-1

Eff

Number of bees at the beginning of the test (Day=0). This was usually 10, except for some cases in which bees had died between the time of collection and the time of cageing and no replacement of the same age was available.

Integer number Integer [0.0.NTGER313]

no.

Day

Experimental day, starting at day 0.

Integer number Integer [0.0.NTGER313]

day

Alive

Number of bees being alive at day = Day.

Integer number Integer [0.0.NTGER313]

no.

Dead

Number of bees being dead at day = Day.

Integer number Integer [0.0.NTGER313]

no.

Abnormal

Number of bees showing abnormal behaviour at day = Day.

String Text [0.0.TEXTA315]

no.

Weightt0

Measurement of the weight in g of the new syrup syringe provided on day d.

Decimal number weight_t0 [BSCLD32.0.WGHTT401]

g

Weightt1

Measurement of the weight in g of the old syrup syringe provided on day d+1.

Decimal number weight_t1 [BSCLD32.0.WGHTT402]

g

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 9. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Treat 2 - 7 n/a TS n/a n/a n/a CONTROL 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.3% )
Rep 1 - 1 2.0 1 1 2 3 3 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.2% )
Conc 1 - 5 2,936.9303 0 0.6225 181.5 3,937.5 18,000 1,224 0 ( 0.0% ) 102 ( 8.3% ) 0 ( 0.0% ) 12 ( 1.0% )
Eff 1 - 2 10.0 9 10 10 10 10 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.2% )
Day 1 - 2 16.5 0 8 16.5 25 33 1,224 0 ( 0.0% ) 36 ( 2.9% ) 0 ( 0.0% ) 34 ( 2.8% )
Alive 1 - 2 6.2 0 1 8 10 10 1,224 0 ( 0.0% ) 291 ( 23.8% ) 0 ( 0.0% ) 11 ( 0.9% )
Dead 1 - 2 3.8 0 0 2 9 10 1,224 0 ( 0.0% ) 478 ( 39.1% ) 0 ( 0.0% ) 11 ( 0.9% )
Abnormal 1 - 2 n/a n/a n/a n/a NA 1,224 0 ( 0.0% ) 522 ( 42.6% ) 0 ( 0.0% ) 12 ( 1.0% )
Weightt0 2 - 7 n/a NA n/a n/a n/a 474.646 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 885 ( 72.3% )
Weightt1 1 - 7 n/a 4 n/a n/a n/a 444.584 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 913 ( 74.6% )

Quality measures

Table 10. 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
Treat
100.00%
0.33%
2CNA CONTROL
Rep
100.00%
0.25%
1 1
Conc
100.00%
0.98%
0 0
Eff
100.00%
0.16%
10 9
Day
100.00%
2.78%
0 0
Alive
100.00%
0.90%
10 1
Dead
100.00%
0.90%
0 9
Abnormal
100.00%
0.98%
0 9
Weightt0
100.00%
72.30%
NA 43.902
Weightt1
100.00%
74.59%
NA 41.326

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Evaporation

Table 11. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BSCLD32.VPRTN69.0
Name Evaporation
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BSCLD32.VPRTN69.0
Table Type File
Licence CC BY 4.0
Description

The difference of syrup weight has been measured between two consecutive days in cages without bees or with dead bees in order to evaluate the levels of evaporation. These measurements have not been done on each day for all cages. We used cages were all bees were dead to perform these measurements. For some days we did not changed the syringe on day d+1 but we kept the same one and remeasured it again on d+2, d+3 etc because the aim was not to feed the bees (no living bees were present in theses cages) but just to evaluate evaporation.

The difference of syrup weight has been measured between two consecutive days in cages without bees or with dead bees in order to evaluate the levels of evaporation. These measurements have not been done on each day for all cages. We used cages were all bees were dead to perform these measurements. For some days we did not changed the syringe on day d+1 but we kept the same one and remeasured it again on d+2, d+3 etc because the aim was not to feed the bees (no living bees were present in theses cages) but just to evaluate evaporation.

Metadata

n/a
Table 12. Structural analysis of the table. Column name (Name); concise description 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

Metadata of individual tables can be found in Annex 1.

Descriptive measures

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

Quality measures

Table 14. 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

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

Column: Treat

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).
Parameter Content
Column name Treat
Description

Treatments: CANTUS (commercial name of the fungicide containing boscalid), 2CNA (not used in this test), TS (toxic standard), CONTROL (control treatment).

Data type String
Descriptor treatment [UID:BSCLD32.0.TRTMN397]
Descriptor description

Type of treatment applied in the test.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/BSCLD32.0.TRTMN397
Unit

n/a

Table 16. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Treat 2 - 7 n/a TS n/a n/a n/a CONTROL 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.3% )
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
Treat
100.00%
0.33%
2CNA CONTROL

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Rep

Table 18. Structural analysis of the table. Column name (Name); concise description 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 Rep
Description

Identifier of the replicate.

Data type Integer number
Descriptor replicate [UID:BSCLD32.0.RPLCT398]
Descriptor description

Identifier of the replicate.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/BSCLD32.0.RPLCT398
Unit

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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Rep 1 - 1 2.0 1 1 2 3 3 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.2% )
Table 20. 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
Rep
100.00%
0.25%
1 1

Data Distribution Top 20

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

Continuous Data Distribution

Figure 5. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Conc

Table 21. Structural analysis of the table. Column name (Name); concise description 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 Conc
Description

Concentration of the active ingredient in the syrup (sugar solution), expressed in mg active ingredient/l syrup.

Data type Decimal number
Descriptor pms:massConcentration [UID:0.0.CNCNT399]
Descriptor description

The physical quantity mass concentration, also defined as the a mass of solute (e.g. 1 gram) per volume (e.g. 1000 cubic centimetre or 1 Liter) of solution, typical symbol ρ, γ, expressed in the derived unit kilogram per cubic metre.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CNCNT399
Unit

mg L-1

Table 22. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Conc 1 - 5 2,936.9303 0 0.6225 181.5 3,937.5 18,000 1,224 0 ( 0.0% ) 102 ( 8.3% ) 0 ( 0.0% ) 12 ( 1.0% )
Table 23. 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
Conc
100.00%
0.98%
0 0

Data Distribution Top 20

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

Continuous Data Distribution

Figure 10. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Eff

Table 24. Structural analysis of the table. Column name (Name); concise description 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 Eff
Description

Number of bees at the beginning of the test (Day=0). This was usually 10, except for some cases in which bees had died between the time of collection and the time of cageing and no replacement of the same age was available.

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 25. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Eff 1 - 2 10.0 9 10 10 10 10 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.2% )
Table 26. 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
Eff
100.00%
0.16%
10 9

Data Distribution Top 20

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

Continuous Data Distribution

Figure 15. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Day

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).
Parameter Content
Column name Day
Description

Experimental day, starting at day 0.

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

day

Table 28. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Day 1 - 2 16.5 0 8 16.5 25 33 1,224 0 ( 0.0% ) 36 ( 2.9% ) 0 ( 0.0% ) 34 ( 2.8% )
Table 29. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Day
100.00%
2.78%
0 0

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Alive

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).
Parameter Content
Column name Alive
Description

Number of bees being alive at day = Day.

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 31. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Alive 1 - 2 6.2 0 1 8 10 10 1,224 0 ( 0.0% ) 291 ( 23.8% ) 0 ( 0.0% ) 11 ( 0.9% )
Table 32. 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
Alive
100.00%
0.90%
10 1

Data Distribution Top 20

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

Continuous Data Distribution

Figure 25. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Dead

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).
Parameter Content
Column name Dead
Description

Number of bees being dead at day = Day.

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 34. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Dead 1 - 2 3.8 0 0 2 9 10 1,224 0 ( 0.0% ) 478 ( 39.1% ) 0 ( 0.0% ) 11 ( 0.9% )
Table 35. 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
Dead
100.00%
0.90%
0 9

Data Distribution Top 20

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

Continuous Data Distribution

Figure 30. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Abnormal

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).
Parameter Content
Column name Abnormal
Description

Number of bees showing abnormal behaviour at day = Day.

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

no.

Table 37. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Abnormal 1 - 2 n/a n/a n/a n/a NA 1,224 0 ( 0.0% ) 522 ( 42.6% ) 0 ( 0.0% ) 12 ( 1.0% )
Table 38. 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
Abnormal
100.00%
0.98%
0 9

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Weightt0

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).
Parameter Content
Column name Weightt0
Description

Measurement of the weight in g of the new syrup syringe provided on day d.

Data type Decimal number
Descriptor weight_t0 [UID:BSCLD32.0.WGHTT401]
Descriptor description

Measurement of the weight in g of the new syrup syringe provided on day d.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/BSCLD32.0.WGHTT401
Unit

g

Table 40. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Weightt0 2 - 7 n/a NA n/a n/a n/a 474.646 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 885 ( 72.3% )
Table 41. 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
Weightt0
100.00%
72.30%
NA 43.902

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

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).
Parameter Content
Column name Weightt1
Description

Measurement of the weight in g of the old syrup syringe provided on day d+1.

Data type Decimal number
Descriptor weight_t1 [UID:BSCLD32.0.WGHTT402]
Descriptor description

Measurement of the weight in g of the old syrup syringe provided on day d+1.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/BSCLD32.0.WGHTT402
Unit

g

Table 43. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Weightt1 1 - 7 n/a 4 n/a n/a n/a 444.584 1,224 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 913 ( 74.6% )
Table 44. 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
Weightt1
100.00%
74.59%
NA 41.326

Completeness

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

Uniqueness

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

Table: Evaporation