EU Pollinator Hub

, ,

Dataset Report
Unique identifier: BGDCG179.0.0
Title: B-GOOD CO2 Gas Measurements
Long title: Dataset from the B-GOOD project, containing data from studies on carbon dioxide gas measurements in honey bee colonies.
Status: Quality Validated
Current Version: v. 1.0
Published: 2025-03-17
Reviewed by: Rubinigg Michael as Data scientist
Citation proposal:
B-GOOD Bee Health Data Portal 2025 Report of dataset B-GOOD CO2 Gas Measurements, v. 1.0 [BGDCG179.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
Requires major revision

This document is intended for use by collaborators of the EU Pollinator Hub and may be passed on with the express permission of the leader of the consortium and for the purpose determined by the leader of the consortium.

Document history

Release

Version v. 1.0 released on 2025-03-17. Reviewed by Rubinigg Michael.

Revision

Table 1. List of revisions made to the document. Identifier of revision (No); date of revision (Date); description of revision (Description); reason for revision (Reason).
No Date Description Reason
1 2025-03-17 00:03:00 Initial release. n/a

Abbreviations

ISO
International Organization for Standardization
TNTU
The Nottingham Trent University

Executive summary

Data overview:

The data was published by Bencsik MB, Chamberlain LC and Newton MN (TNTU) on the B-GOOD Bee Health Data Portal as part of the B-GOOD project (grant agreement 817622), funded under the EU Horizon 2020 Research and Innovation Programme. It contains data from carbon dioxide gas measurements in five beehives. The measurements were performed between 2022-07-08 and 2022-12-07 in most beehives, except for beehive 7 where measurements were performed between 2022-04-27 and 2022-09-25. In three beehives measurements came from two sensors, one placed near the queen excluder and one near the crown board. In beehive 7 only measurements from the sensor placed near the crown board was made available, even though in the description of the dataset the existence of a second sensor was mentioned. In beehive 1 only one sensor was used and it is not specified where the sensor was located.

Data value:

The objectives of the B-GOOD project were: (1) Facilitate decision making for beekeepers and other stakeholders by establishing ready-to-use tools for operationalising the HSI; (2) Test, standardise and validate methods for measuring and reporting selected indicators affecting bee health; (3) Explore the various socio-economic and ecological factors beyond bee health; (4) Foster an EU community to collect and share knowledge related to honey bees and their environment; (5) Engender a lasting learning and innovation system (LIS); (6) Minimise the impact of biotic and abiotic stressors.

Data description:

The dataset contains 8 files, each with aproximately 1.2 million records and a file size of approximately 70 MB. Each file is a merge of approximately 3380 single files from the same sensor on a given position in a given hive and each single file covers approximately one hour of measuremenmts.

Data application:

Currently, the data integrated from the B-GOOD Bee Health Data Portal contains major issues and does not comply with the FAIR Guiding Principles for scientific data management and stewardship applied on the EU Pollinator Hub. More descriptive information about the context, quality and condition, or characteristics of the data (e.g. protocols, measurement devices used, units of the captured data, or any other details about the study) must be provided. More metadata in the form of accurate and relevant attributes (*e.g. *metadata that describes the scope of the data has been described, any particularities or limitations about the data that other users should be aware of, specification of the date of generation/collection of the data, the lab conditions, who prepared the data, the parameter settings, the name and version of the software used, specification of whether it is raw or processed data, explanation of all variable names are explained if they are not self-explanatory) must be provided. It requires major revisions by the data provider.

Unresolved issues:

n/a

Introduction

The data was published by Bencsik MB, Chamberlain LC and Newton MN (TNTU) on the B-GOOD Bee Health Data Portal as part of the B-GOOD project (grant agreement 817622), funded under the EU Horizon 2020 Research and Innovation Programme. The dataset contains data from carbon dioxide gas measurements in five beehives. The measurements were performed between 2022-07-08 and 2022-12-07 in most beehives, except for beehive 7 where measurements were performed between 2022-04-27 and 2022-09-25. In three beehives measurements came from two sensors, one placed near the queen excluder and one near the crown board. In beehive 7 only measurements from the sensor placed near the crown board was made available, even though in the description of the dataset the existence of a second sensor was mentioned. In beehive 1 only one sensor was used and it is not specified where the sensor was located.

The objectives of the B-GOOD project were: (1) Facilitate decision making for beekeepers and other stakeholders by establishing ready-to-use tools for operationalising the HSI; (2) Test, standardise and validate methods for measuring and reporting selected indicators affecting bee health; (3) Explore the various socio-economic and ecological factors beyond bee health; (4) Foster an EU community to collect and share knowledge related to honey bees and their environment; (5) Engender a lasting learning and innovation system (LIS); (6) Minimise the impact of biotic and abiotic stressors.

Material and methods

Data acquisition

All raw data files were downloaded from the B-GOOD Bee Health Data Portal on 2024-07-04.

List of raw data obtained from the data provider.

  1. Archive Istec.zip accessed on 2024-07-04 14:29:30, provided by B-GOOD Bee Health Data Portal
  2. Archive Crown board.zip accessed on 2024-07-04 14:29:24, provided by B-GOOD Bee Health Data Portal
  3. Archive Queen excluder.zip accessed on 2024-07-04 14:29:23, provided by B-GOOD Bee Health Data Portal
  4. Archive Crown board.zip accessed on 2024-07-04 14:29:21, provided by B-GOOD Bee Health Data Portal
  5. Archive Queen excluder.zip accessed on 2024-07-04 14:29:20, provided by B-GOOD Bee Health Data Portal
  6. Archive Crown board.zip accessed on 2024-07-04 14:29:22, provided by B-GOOD Bee Health Data Portal
  7. Archive Crown board.zip accessed on 2024-07-04 14:29:25, provided by B-GOOD Bee Health Data Portal
  8. Archive Queen excluder.zip accessed on 2024-07-04 14:29:28, provided at B-GOOD Bee Health Data Portal

Metadata was obtained from the web pages of the single datasets (see above).

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 b-good co2 hive 1 istec_PREP_MR_241010.csv CSV - Comma seperated values Yes No 2024-10-10 13:10:25 5,950,145 70.20 MiB
2 b-good co2 hive 5 hpp queenexcluder_PRER_MR_241010.csv CSV - Comma seperated values Yes No 2024-10-10 14:10:45 5,902,395 69.84 MiB
3 b-good co2 hive 5 hpp crownboard_PREP_MR_241010.csv CSV - Comma seperated values Yes No 2024-10-10 13:10:07 5,902,690 69.41 MiB
4 b-good co2 hive 6 hpp crownboard_PREP_MR_241010.csv CSV - Comma seperated values Yes No 2024-10-10 14:10:36 5,902,065 69.10 MiB
5 b-good co2 hive 6 hpp queenexcluder_PREP_MR_241010.csv CSV - Comma seperated values Yes No 2024-10-10 14:10:12 5,902,390 69.58 MiB
6 b-good co2 hive 7 hpp crownboard_PREP_MR_241010.csv CSV - Comma seperated values Yes No 2024-10-10 14:10:45 5,902,130 69.18 MiB
7 b-good co2 hive 8 hpp crownboard_PREP_MR_241010.csv CSV - Comma seperated values Yes No 2024-10-10 15:10:06 5,901,870 69.06 MiB
8 b-good co2 hive 8 hpp queenexcluder_PREP_MR_241010.csv CSV - Comma seperated values Yes No 2024-10-10 15:10:57 5,901,490 69.56 MiB

Data preparation

All files in the zip-archives were extracted using File Explorer (Microsoft Corporation, version 22H2). Files from the same archive were merged using the python script MergeToCsv.py:

  • Archive Istec.zip obtained from dataset CO2_Gas_Measurements_Hive_1_ISTEC contained 3401 files in csv format with a total of 1.190.029 records, recorded from 2022-07-08 11:50:50 to 2022-12-07 12:48:16, which were merged to file CO2GasMeasurementsHive1ISTEC.csv using thePython script MergeCsv.py.
  • Archive Crown board.zip obtained from dataset CO2_Gas_Measurements_Hive_5_HPP contained 3378 fieles in csv format with a total of 1.180.538 records, recorded from 2022-07-08 15:26:02 to 2022-12-06 12:42:17, which were merged to file CO2GasMeasurementsHive5HPPcrown board.csv using thePython script MergeCsv.py.
  • Archive Queen excluder.zip obtained from dataset CO2_Gas_Measurements_Hive_5_HPP contained 3378 files in csv format with a total of 1.180.479 records, recorded from 2022-07-08 15:30:14 to 2022-12-06 12:47:57, which were merged to file CO2GasMeasurementsHive5HPPqueen excluder.csv using thePython script MergeCsv.py.
  • Archive Crown board.zip obtained from dataset CO2_Gas_Measurements_Hive_6_HPP contained 3377 files in csv format with a total of 1.180.413 records, recorded from 2022-07-08 15:20:47 to 2022-12-06 12:32:29, which were merged to file CO2_Gas_Measurements_Hive_6_HPP_crown board.csv using thePython script MergeCsv.py.
  • Archive Queen excluder.zip obtained from dataset CO2_Gas_Measurements_Hive_6_HPP contained 3377 files in csv format with a total of 1.180.478 records, recorded from 2022-07-08 15:20:45 to 2022-12-06 12:32:24, which were merged to file CO2_Gas_Measurements_Hive_6_HPP_queen excluder.csv using thePython script MergeCsv.py.
  • Archive Crown board.zip obtained from dataset CO2_Gas_Measurements_Hive_7_HPP contained 3377 files in csv format with a total of 1.180.426 records, recorded from 2022-04-27 10:07:44 to 2022-09-25 08:19:09, which were merged to file CO2_Gas_Measurements_Hive_7_HPP_crown board.csv using thePython script MergeCsv.py.
  • Archive Crown board.zip obtained from dataset CO2_Gas_Measurements_Hive_8_HPP contained 3377 files in csv format with a total of 1.180.374 records, recorded from 2022-07-08 16:11:56 to 2022-12-06 13:17:37, which were merged to file CO2_Gas_Measurements_Hive_8_HPP_crown board.csv using thePython script MergeCsv.py.
  • Archive Queen excluder.zip obtained from dataset CO2_Gas_Measurements_Hive_8_HPP contained 3377 files in csv format with a total of 1.180.298 records, recorded from 2022-07-08 16:14:07 to 2022-12-06 13:17:46, which were merged to file CO2_Gas_Measurements_Hive_8_HPP_crown board.csv using thePython script MergeCsv.py.

The merged files were imported into a SQL database (MariaDB foundation, server version 10.4.32) running in an XAMPP environment (BitRock, version 5.2.1) according to the following workflow:

  • UNIX timestamps in column time were transformed to ISO 8601 format and saved in column datetime using Query 1

Data was then exported to the respective preparatory files and uploaded to the EU Pollinator Hub according to SOP-017 (Dataset integration.

Data validation

No data validation was performed.

Data analysis

No data analysis was performed.

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 Hive 1 ISTEC Measurement of carbon dioxide with a sensors in beehive number 1 (ISTEC) from 2022-07-08 to 2022-12-07.
2 Hive 5 HPP queen excluder Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 5 (HPP) from 2022-07-08 to 2022-12-06.
3 Hive 5 HPP crown board Measurement of carbon dioxide with a sensors near the crown board of beehive number 5 (HPP) from 2022-07-08 to 2022-12-06.
4 Hive 6 HPP crown board Measurement of carbon dioxide with a sensors near the crown board of beehive number 6 (HPP) from 2022-07-08 to 2022-12-06.
5 Hive 6 HPP queen excluder Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 6 (HPP) from 2022-07-08 to 2022-12-06.
6 Hive 7 HPP crown board Measurement of carbon dioxide with a sensors near the crown board of beehive number 7 (HPP) from 2022-04-27 to 2022-09-25.
7 Hive 8 HPP crown board Measurement of carbon dioxide with a sensors near the crown board of beehive number 8 (HPP) from 2022-07-08 to 2022-12-06.
8 Hive 8 HPP queen excluder Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 8 (HPP) from 2022-07-08 to 2022-12-06.
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid BGDCG179.0.0
Title B-GOOD CO2 Gas Measurements
Long title Dataset from the B-GOOD project, containing data from studies on carbon dioxide gas measurements in honey bee colonies.
Target IRI https://app.pollinatorhub.eu/dataset-discovery/BGDCG179.0.0
interactions.single.section-details.licence CC BY-NC-ND 4.0
DOI n/a
Created 2024-10-09
Published 2025-03-17
Contact n/a
Keywords Apis mellifera, beehive, carbon dioxide, honey bee, sensor
Data collection years n/a
Regions, the data was collected in n/a
Abstract

The dataset contains data from carbon dioxide gas measurements in five beehives over a period of 5 months at a distance of 11 seconds in 2022. The data was published by Bencsik MB, Chamberlain LC and Newton MN (TNTU) on the B-GOOD Bee Health Data Portal as part of the B-GOOD project (grant agreement 817622), funded under the EU Horizon 2020 Research and Innovation Programme.

Table 5. Standardised metadata of the data provider B-GOOD Bee Health Data Portal. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name B-GOOD Bee Health Data Portal
Url
Acronym B-GOOD
IRI https://app.pollinatorhub.eu/data-providers/b-good-bee-health-data-portal
Address https://b-good-project.eu
Country Belgium
Contact b-good-project.eu
Description

Project funded by the EU Horizon 2020 Research and Innovation Programme under grant agreement No 817622. Project website: https://b-good-project.eu

Tables

Hive 1 ISTEC

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BGDCG179.HVSTC366.0
Name Hive 1 ISTEC
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BGDCG179.HVSTC366.0
Table Type File
Licence CC BY-NC-ND 4.0
Description

Measurement of carbon dioxide with a sensors in beehive number 1 (ISTEC) from 2022-07-08 to 2022-12-07.

Measurement of carbon dioxide with a sensors in beehive number 1 (ISTEC) from 2022-07-08 to 2022-12-07.

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
time

Time of measurement in unix time format.

Integer number pms:unixTime [0.0.NXTME469]

n/a

datetime

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Date and Time iso-8601:calendarDateAndTime [0.0.DTNDT319]

n/a

scdCO2

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

Decimal number DecimalNumber [0.0.DCMLN314]

n/a

scdT

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

°C

scdH

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

%

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 8. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,837,113.2 1,657,273,850 1,660,551,278.5 1,663,833,851 1,667,121,267.5 1,670,413,696 1,190,029 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,190,029 ( 100.0% )
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-07 1… 1,190,029 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,190,029 ( 100.0% )
scdCO2 4 - 8 3,484.686 0.00 1,943 3,179 4,795 23,041.00 1,190,029 1 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 11,896 ( 1.0% )
scdT 4 - 5 22.804 5.31 20.25 25.07 27.61 34.20 1,190,029 1 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2,884 ( 0.2% )
scdH 5 - 5 66.577 42.76 59.24 66.53 73.15 84.90 1,190,029 1 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,175 ( 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
time
100.00%
100.00%
1657273850 1657273850
datetime
100.00%
100.00%
2022-07-08 11:50:50 2022-07-08 11:50:50
scdCO2
100.00%
1.00%
1703.00 null
scdT
100.00%
0.24%
26.45 null
scdH
100.00%
0.35%
82.59 null

Changes made to preparatory file

  1. Column datetime was created to allow conversion of the Unix time to ISO 8601 time.

Changes made to data

  1. Data in column time, given in Unix time (referred to as epoch time in the metadata of the dataset) was converted to ISO 8601 date and time in order to comply with the EUPH standards for date and time, and sved in column datetime.
  2. Missing data was replaced by NULL.

Unresolved issues

  1. No units were specified to describe the columns. It is therefore not possible to standardise the data.

Table references

  1. Bencsik M. 2023 CO2_Gas_Measurements_Hive_1_ISTEC. B-GOOD Bee Health Data Portal. [2024-10-9] beehealthdata.org

Hive 5 HPP queen excluder

Table 10. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BGDCG179.HVHPP367.0
Name Hive 5 HPP queen excluder
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BGDCG179.HVHPP367.0
Table Type File
Licence CC BY-NC-ND 4.0
Description

Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 5 (HPP) from 2022-07-08 to 2022-12-06.

Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 5 (HPP) from 2022-07-08 to 2022-12-06.

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
time

Time of measurement in unix time format.

Integer number pms:unixTime [0.0.NXTME469]

n/a

datetime

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Date and Time iso-8601:calendarDateAndTime [0.0.DTNDT319]

n/a

scdCO2

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

Decimal number DecimalNumber [0.0.DCMLN314]

n/a

scdT

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

°C

scdH

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

%

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,801,996.3 1,657,287,014 1,660,542,671 1,663,798,650 1,667,059,692 1,670,327,277 1,180,479 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,479 ( 100.0% )
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,479 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,479 ( 100.0% )
scdCO2 5 - 8 3,291.287 43.00 2,185 3,066 4,153 18,640.00 1,180,479 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 10,316 ( 0.9% )
scdT 5 - 5 26.039 10.39 21.9 28.69 30.76 36.75 1,180,479 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2,374 ( 0.2% )
scdH 5 - 6 66.625 36.42 56.81 62.45 72.96 100.00 1,180,479 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6,186 ( 0.5% )

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
time
100.00%
100.00%
1657287014 1657287014
datetime
100.00%
100.00%
2022-07-08 15:30:14 2022-07-08 15:30:14
scdCO2
100.00%
0.87%
2505.00 9972.00
scdT
100.00%
0.20%
30.73 36.75
scdH
100.00%
0.52%
100.00 39.00

Changes made to preparatory file

  1. Column datetime was created to allow conversion of the Unix time to ISO 8601 time.

Changes made to data

  1. Data in column time, given in Unix time (referred to as epoch time in the metadata of the dataset) was converted to ISO 8601 date and time in order to comply with the EUPH standards for date and time, and sved in column datetime.
  2. Missing data was replaced by NULL.

Unresolved issues

  1. No units were specified to describe the columns. It is therefore not possible to standardise the data.

Table references

  1. Chamberlain L. 2023 CO2_Gas_Measurements_Hive_5_HPP. B-GOOD Bee Health Data Portal. [2024-10-9] beehealthdata.org

Hive 5 HPP crown board

Table 14. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BGDCG179.HVHPP368.0
Name Hive 5 HPP crown board
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BGDCG179.HVHPP368.0
Table Type File
Licence CC BY-NC-ND 4.0
Description

Measurement of carbon dioxide with a sensors near the crown board of beehive number 5 (HPP) from 2022-07-08 to 2022-12-06.

Measurement of carbon dioxide with a sensors near the crown board of beehive number 5 (HPP) from 2022-07-08 to 2022-12-06.

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
time

Time of measurement in unix time format.

Integer number pms:unixTime [0.0.NXTME469]

n/a

datetime

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Date and Time iso-8601:calendarDateAndTime [0.0.DTNDT319]

n/a

scdCO2

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

Decimal number DecimalNumber [0.0.DCMLN314]

n/a

scdT

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

°C

scdH

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

%

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,801,839.2 1,657,286,762 1,660,542,542.25 1,663,798,595.5 1,667,059,516.75 1,670,326,937 1,180,538 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,538 ( 100.0% )
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,538 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,538 ( 100.0% )
scdCO2 6 - 8 3,002.039 272.00 1,415 2,863 4,278 16,675.00 1,180,538 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 9,573 ( 0.8% )
scdT 4 - 5 19.104 1.44 12.61 18.94 24.01 46.94 1,180,538 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,551 ( 0.4% )
scdH 5 - 6 77.882 24.37 69.04 81.75 89.25 100.00 1,180,538 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,463 ( 0.6% )

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
time
100.00%
100.00%
1657286762 1657286762
datetime
100.00%
100.00%
2022-07-08 15:26:02 2022-07-08 15:26:02
scdCO2
100.00%
0.81%
412.00 362.00
scdT
100.00%
0.39%
20.14 46.93
scdH
100.00%
0.63%
93.84 26.85

Changes made to preparatory file

  1. Column datetime was created to allow conversion of the Unix time to ISO 8601 time.

Changes made to data

  1. Data in column time, given in Unix time (referred to as epoch time in the metadata of the dataset) was converted to ISO 8601 date and time in order to comply with the EUPH standards for date and time, and sved in column datetime.
  2. Missing data was replaced by NULL.

Unresolved issues

  1. No units were specified to describe the columns. It is therefore not possible to standardise the data.

Table references

  1. Chamberlain L. 2023 CO2_Gas_Measurements_Hive_5_HPP. B-GOOD Bee Health Data Portal. [2024-10-9] beehealthdata.org

Hive 6 HPP crown board

Table 18. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BGDCG179.HVHPP369.0
Name Hive 6 HPP crown board
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BGDCG179.HVHPP369.0
Table Type File
Licence CC BY-NC-ND 4.0
Description

Measurement of carbon dioxide with a sensors near the crown board of beehive number 6 (HPP) from 2022-07-08 to 2022-12-06.

Measurement of carbon dioxide with a sensors near the crown board of beehive number 6 (HPP) from 2022-07-08 to 2022-12-06.

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
time

Time of measurement in unix time format.

Integer number pms:unixTime [0.0.NXTME469]

n/a

datetime

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Date and Time iso-8601:calendarDateAndTime [0.0.DTNDT319]

n/a

scdCO2

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

Decimal number DecimalNumber [0.0.DCMLN314]

n/a

scdT

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

°C

scdH

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

%

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,801,157.2 1,657,286,447 1,660,541,882.5 1,663,797,748 1,667,058,779.5 1,670,326,349 1,180,413 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,413 ( 100.0% )
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,413 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,413 ( 100.0% )
scdCO2 6 - 7 1,612.692 327.00 563 1,252 2,522 7,381.00 1,180,413 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5,552 ( 0.5% )
scdT 4 - 5 17.905 0.77 11.53 16.74 22.35 48.61 1,180,413 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,785 ( 0.4% )
scdH 5 - 5 68.910 21.75 58.81 72.45 81.28 95.21 1,180,413 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,006 ( 0.6% )

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
time
100.00%
100.00%
1657286447 1657286447
datetime
100.00%
100.00%
2022-07-08 15:20:47 2022-07-08 15:20:47
scdCO2
100.00%
0.47%
470.00 5221.00
scdT
100.00%
0.41%
15.05 47.44
scdH
100.00%
0.59%
86.40 23.41

Changes made to preparatory file

  1. Column datetime was created to allow conversion of the Unix time to ISO 8601 time.

Changes made to data

  1. Data in column time, given in Unix time (referred to as epoch time in the metadata of the dataset) was converted to ISO 8601 date and time in order to comply with the EUPH standards for date and time, and sved in column datetime.
  2. Missing data was replaced by NULL.

Unresolved issues

  1. No units were specified to describe the columns. It is therefore not possible to standardise the data.

Table references

  1. Bencsik M. 2023 CO2_Gas_Measurements_Hive_6_HPP. B-GOOD Bee Health Data Portal. [2024-10-9] beehealthdata.org

Hive 6 HPP queen excluder

Table 22. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BGDCG179.HVHPP370.0
Name Hive 6 HPP queen excluder
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BGDCG179.HVHPP370.0
Table Type File
Licence CC BY-NC-ND 4.0
Description

Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 6 (HPP) from 2022-07-08 to 2022-12-06.

Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 6 (HPP) from 2022-07-08 to 2022-12-06.

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
time

Time of measurement in unix time format.

Integer number pms:unixTime [0.0.NXTME469]

n/a

datetime

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Date and Time iso-8601:calendarDateAndTime [0.0.DTNDT319]

n/a

scdCO2

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

Decimal number DecimalNumber [0.0.DCMLN314]

n/a

scdT

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

°C

scdH

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

%

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,801,322.8 1,657,286,445 1,660,542,061.25 1,663,798,030.5 1,667,058,956.75 1,670,326,344 1,180,478 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,478 ( 100.0% )
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,478 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,478 ( 100.0% )
scdCO2 4 - 8 2,812.580 0.00 1,701 2,713 3,760 12,035.00 1,180,478 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 10,281 ( 0.9% )
scdT 4 - 5 21.144 4.30 15.22 23.21 27.02 37.88 1,180,478 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3,333 ( 0.3% )
scdH 5 - 5 71.355 36.54 60.96 67.7 87.19 96.75 1,180,478 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6,008 ( 0.5% )

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
time
100.00%
100.00%
1657286445 1657286445
datetime
100.00%
100.00%
2022-07-08 15:20:45 2022-07-08 15:20:45
scdCO2
100.00%
0.87%
2122.00 346.00
scdT
100.00%
0.28%
25.15 37.88
scdH
100.00%
0.51%
93.86 37.40

Changes made to preparatory file

  1. Column datetime was created to allow conversion of the Unix time to ISO 8601 time.

Changes made to data

  1. Data in column time, given in Unix time (referred to as epoch time in the metadata of the dataset) was converted to ISO 8601 date and time in order to comply with the EUPH standards for date and time, and sved in column datetime.
  2. Missing data was replaced by NULL.

Unresolved issues

  1. No units were specified to describe the columns. It is therefore not possible to standardise the data.

Table references

  1. Bencsik M. 2023 CO2_Gas_Measurements_Hive_6_HPP. B-GOOD Bee Health Data Portal. [2024-10-9] beehealthdata.org

Hive 7 HPP crown board

Table 26. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BGDCG179.HVHPP371.0
Name Hive 7 HPP crown board
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BGDCG179.HVHPP371.0
Table Type File
Licence CC BY-NC-ND 4.0
Description

Measurement of carbon dioxide with a sensors near the crown board of beehive number 7 (HPP) from 2022-04-27 to 2022-09-25.

Measurement of carbon dioxide with a sensors near the crown board of beehive number 7 (HPP) from 2022-04-27 to 2022-09-25.

Metadata

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 Column Description Datatype Descriptor Unit
time

Time of measurement in unix time format.

Integer number pms:unixTime [0.0.NXTME469]

n/a

datetime

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Date and Time iso-8601:calendarDateAndTime [0.0.DTNDT319]

n/a

scdCO2

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

Decimal number DecimalNumber [0.0.DCMLN314]

n/a

scdT

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

°C

scdH

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

%

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 28. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,657,561,714.0 1,651,046,864 1,654,302,421.25 1,657,558,458.5 1,660,819,331.75 1,664,086,749 1,180,426 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,426 ( 100.0% )
datetime 19 - 19 2,022.0 2022-04-27 1… 2,022 2,022 2,022 2022-09-25 0… 1,180,426 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,426 ( 100.0% )
scdCO2 6 - 7 2,070.117 166.00 744 1,706 3,033 9,369.00 1,180,426 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,847 ( 0.7% )
scdT 4 - 5 17.757 0.18 10.96 16.84 22.68 48.94 1,180,426 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,914 ( 0.4% )
scdH 5 - 5 70.730 23.04 61.94 73.53 81.84 96.48 1,180,426 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,055 ( 0.6% )

Quality measures

Table 29. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
time
100.00%
100.00%
1651046864 1651046864
datetime
100.00%
100.00%
2022-04-27 10:07:44 2022-04-27 10:07:44
scdCO2
100.00%
0.66%
464.00 325.00
scdT
100.00%
0.42%
18.42 48.85
scdH
100.00%
0.60%
86.18 23.65

Changes made to preparatory file

  1. Column datetime was created to allow conversion of the Unix time to ISO 8601 time.

Changes made to data

  1. Data in column time, given in Unix time (referred to as epoch time in the metadata of the dataset) was converted to ISO 8601 date and time in order to comply with the EUPH standards for date and time, and sved in column datetime.
  2. Missing data was replaced by NULL.

Unresolved issues

  1. No units were specified to describe the columns. It is therefore not possible to standardise the data.

Table references

  1. Bencsik M. 2023 CO2_Gas_Measurements_Hive_7_HPP. B-GOOD Bee Health Data Portal. [2024-10-9] beehealthdata.org

Hive 8 HPP crown board

Table 30. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BGDCG179.HVHPP372.0
Name Hive 8 HPP crown board
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BGDCG179.HVHPP372.0
Table Type File
Licence CC BY-NC-ND 4.0
Description

Measurement of carbon dioxide with a sensors near the crown board of beehive number 8 (HPP) from 2022-07-08 to 2022-12-06.

Measurement of carbon dioxide with a sensors near the crown board of beehive number 8 (HPP) from 2022-07-08 to 2022-12-06.

Metadata

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

Time of measurement in unix time format.

Integer number pms:unixTime [0.0.NXTME469]

n/a

datetime

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Date and Time iso-8601:calendarDateAndTime [0.0.DTNDT319]

n/a

scdCO2

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

Decimal number DecimalNumber [0.0.DCMLN314]

n/a

scdT

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

°C

scdH

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

%

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 32. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,804,042.6 1,657,289,516 1,660,544,901.25 1,663,800,692.5 1,667,061,506.75 1,670,329,057 1,180,374 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,374 ( 100.0% )
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,374 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,374 ( 100.0% )
scdCO2 6 - 7 1,738.906 332.00 603 1,095 2,669 6,835.00 1,180,374 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6,241 ( 0.5% )
scdT 4 - 5 18.150 0.87 11.71 17.12 22.95 48.72 1,180,374 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,955 ( 0.4% )
scdH 5 - 5 62.520 26.03 55.22 63.28 70.28 82.27 1,180,374 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5,161 ( 0.4% )

Quality measures

Table 33. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
time
100.00%
100.00%
1657289516 1657289516
datetime
100.00%
100.00%
2022-07-08 16:11:56 2022-07-08 16:11:56
scdCO2
100.00%
0.53%
497.00 6201.00
scdT
100.00%
0.42%
14.17 47.32
scdH
100.00%
0.44%
63.73 26.03

Changes made to preparatory file

  1. Column datetime was created to allow conversion of the Unix time to ISO 8601 time.

Changes made to data

  1. Data in column time, given in Unix time (referred to as epoch time in the metadata of the dataset) was converted to ISO 8601 date and time in order to comply with the EUPH standards for date and time, and sved in column datetime.
  2. Missing data was replaced by NULL.

Unresolved issues

  1. No units were specified to describe the columns. It is therefore not possible to standardise the data.

Table references

  1. Bencsik M., Newton M. 2023 CO2_Gas_Measurements_Hive_8_HPP. B-GOOD Bee Health Data Portal. [2024-10-9] beehealthdata.org

Hive 8 HPP queen excluder

Table 34. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier BGDCG179.HVHPP373.0
Name Hive 8 HPP queen excluder
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/BGDCG179.HVHPP373.0
Table Type File
Licence CC BY-NC-ND 4.0
Description

Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 8 (HPP) from 2022-07-08 to 2022-12-06.

Measurement of carbon dioxide with a sensors near the queen excluder of beehive number 8 (HPP) from 2022-07-08 to 2022-12-06.

Metadata

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

Time of measurement in unix time format.

Integer number pms:unixTime [0.0.NXTME469]

n/a

datetime

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Date and Time iso-8601:calendarDateAndTime [0.0.DTNDT319]

n/a

scdCO2

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

Decimal number DecimalNumber [0.0.DCMLN314]

n/a

scdT

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

°C

scdH

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

Decimal number DecimalNumber [0.0.DCMLN314]

%

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 36. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,804,052.8 1,657,289,647 1,660,544,821.25 1,663,800,624.5 1,667,061,624.75 1,670,329,066 1,180,298 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,298 ( 100.0% )
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,298 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,298 ( 100.0% )
scdCO2 4 - 8 3,059.838 0.00 1,674 2,997 4,271 10,280.00 1,180,298 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8,465 ( 0.7% )
scdT 4 - 5 22.729 1.84 17.38 24.73 29.22 35.15 1,180,298 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3,261 ( 0.3% )
scdH 5 - 5 65.357 38.44 59.08 64.56 69.98 88.96 1,180,298 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,597 ( 0.4% )

Quality measures

Table 37. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
time
100.00%
100.00%
1657289647 1657289647
datetime
100.00%
100.00%
2022-07-08 16:14:07 2022-07-08 16:14:07
scdCO2
100.00%
0.72%
477.00 7710.00
scdT
100.00%
0.28%
30.28 34.84
scdH
100.00%
0.39%
61.81 44.53

Changes made to preparatory file

  1. Column datetime was created to allow conversion of the Unix time to ISO 8601 time.

Changes made to data

  1. Data in column time, given in Unix time (referred to as epoch time in the metadata of the dataset) was converted to ISO 8601 date and time in order to comply with the EUPH standards for date and time, and sved in column datetime.
  2. Missing data was replaced by NULL.

Unresolved issues

  1. No units were specified to describe the columns. It is therefore not possible to standardise the data.

Table references

  1. Bencsik M., Newton M. 2023 CO2_Gas_Measurements_Hive_8_HPP. B-GOOD Bee Health Data Portal. [2024-10-9] beehealthdata.org

References

There are no sources in the current document.

Querries

 

UPDATE tablereference SET colname = FROM_UNIXTIME(colname);

Annex 1: Table column reports

Table: Hive 1 ISTEC

Column: time

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 time
Description

Time of measurement in unix time format.

Data type Integer number
Descriptor pms:unixTime [UID:0.0.NXTME469]
Descriptor description

Unix time is a date and time representation widely used in computing. It measures time by the number of non-leap seconds that have elapsed since 00:00:00 UTC on 1 January 1970, the Unix epoch. [...] Unix time is sometimes referred to as Epoch time. This can be misleading since Unix time is not the only time system based on an epoch and the Unix epoch is not the only epoch used by other time systems.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NXTME469
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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,837,113.2 1,657,273,850 1,660,551,278.5 1,663,833,851 1,667,121,267.5 1,670,413,696 1,190,029 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,190,029 ( 100.0% )
Table 40. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
time
100.00%
100.00%
1657273850 1657273850

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

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 datetime
Description

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Data type Date and Time
Descriptor iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description

date and time representation [...] that includes all the time scale components [...] associated with the expression [...]

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

n/a

Table 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-07 1… 1,190,029 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,190,029 ( 100.0% )
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
datetime
100.00%
100.00%
2022-07-08 11:50:50 2022-07-08 11:50:50

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

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 scdCO2
Description

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

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

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdCO2 4 - 8 3,484.686 0.00 1,943 3,179 4,795 23,041.00 1,190,029 1 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 11,896 ( 1.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
scdCO2
100.00%
1.00%
1703.00 null

Continuous Data Distribution

Figure 8. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdT

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 scdT
Description

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

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

°C

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdT 4 - 5 22.804 5.31 20.25 25.07 27.61 34.20 1,190,029 1 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2,884 ( 0.2% )
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
scdT
100.00%
0.24%
26.45 null

Continuous Data Distribution

Figure 12. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdH

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 scdH
Description

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

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 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdH 5 - 5 66.577 42.76 59.24 66.53 73.15 84.90 1,190,029 1 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,175 ( 0.4% )
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
scdH
100.00%
0.35%
82.59 null

Continuous Data Distribution

Figure 16. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Hive 5 HPP queen excluder

Column: time

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 time
Description

Time of measurement in unix time format.

Data type Integer number
Descriptor pms:unixTime [UID:0.0.NXTME469]
Descriptor description

Unix time is a date and time representation widely used in computing. It measures time by the number of non-leap seconds that have elapsed since 00:00:00 UTC on 1 January 1970, the Unix epoch. [...] Unix time is sometimes referred to as Epoch time. This can be misleading since Unix time is not the only time system based on an epoch and the Unix epoch is not the only epoch used by other time systems.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NXTME469
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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,801,996.3 1,657,287,014 1,660,542,671 1,663,798,650 1,667,059,692 1,670,327,277 1,180,479 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,479 ( 100.0% )
Table 55. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
time
100.00%
100.00%
1657287014 1657287014

Continuous Data Distribution

Figure 20. Distribution of values in the column.

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

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 datetime
Description

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Data type Date and Time
Descriptor iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description

date and time representation [...] that includes all the time scale components [...] associated with the expression [...]

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

n/a

Table 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,479 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,479 ( 100.0% )
Table 58. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
datetime
100.00%
100.00%
2022-07-08 15:30:14 2022-07-08 15:30:14

Outliers

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

Completeness

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

Uniqueness

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

Column: scdCO2

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 scdCO2
Description

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

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

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdCO2 5 - 8 3,291.287 43.00 2,185 3,066 4,153 18,640.00 1,180,479 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 10,316 ( 0.9% )
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
scdCO2
100.00%
0.87%
2505.00 9972.00

Continuous Data Distribution

Figure 27. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdT

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 scdT
Description

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

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

°C

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdT 5 - 5 26.039 10.39 21.9 28.69 30.76 36.75 1,180,479 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2,374 ( 0.2% )
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
scdT
100.00%
0.20%
30.73 36.75

Continuous Data Distribution

Figure 31. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdH

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 scdH
Description

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

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 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdH 5 - 6 66.625 36.42 56.81 62.45 72.96 100.00 1,180,479 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6,186 ( 0.5% )
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
scdH
100.00%
0.52%
100.00 39.00

Continuous Data Distribution

Figure 35. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Hive 5 HPP crown board

Column: time

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 time
Description

Time of measurement in unix time format.

Data type Integer number
Descriptor pms:unixTime [UID:0.0.NXTME469]
Descriptor description

Unix time is a date and time representation widely used in computing. It measures time by the number of non-leap seconds that have elapsed since 00:00:00 UTC on 1 January 1970, the Unix epoch. [...] Unix time is sometimes referred to as Epoch time. This can be misleading since Unix time is not the only time system based on an epoch and the Unix epoch is not the only epoch used by other time systems.

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

n/a

Table 69. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,801,839.2 1,657,286,762 1,660,542,542.25 1,663,798,595.5 1,667,059,516.75 1,670,326,937 1,180,538 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,538 ( 100.0% )
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
time
100.00%
100.00%
1657286762 1657286762

Continuous Data Distribution

Figure 39. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: datetime

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 datetime
Description

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Data type Date and Time
Descriptor iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description

date and time representation [...] that includes all the time scale components [...] associated with the expression [...]

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

n/a

Table 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,538 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,538 ( 100.0% )
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
datetime
100.00%
100.00%
2022-07-08 15:26:02 2022-07-08 15:26:02

Outliers

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

Completeness

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

Uniqueness

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

Column: scdCO2

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 scdCO2
Description

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

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

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdCO2 6 - 8 3,002.039 272.00 1,415 2,863 4,278 16,675.00 1,180,538 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 9,573 ( 0.8% )
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
scdCO2
100.00%
0.81%
412.00 362.00

Continuous Data Distribution

Figure 46. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdT

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 scdT
Description

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

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

°C

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdT 4 - 5 19.104 1.44 12.61 18.94 24.01 46.94 1,180,538 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,551 ( 0.4% )
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
scdT
100.00%
0.39%
20.14 46.93

Continuous Data Distribution

Figure 50. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdH

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 scdH
Description

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

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 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdH 5 - 6 77.882 24.37 69.04 81.75 89.25 100.00 1,180,538 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,463 ( 0.6% )
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
scdH
100.00%
0.63%
93.84 26.85

Continuous Data Distribution

Figure 54. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Hive 6 HPP crown board

Column: time

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 time
Description

Time of measurement in unix time format.

Data type Integer number
Descriptor pms:unixTime [UID:0.0.NXTME469]
Descriptor description

Unix time is a date and time representation widely used in computing. It measures time by the number of non-leap seconds that have elapsed since 00:00:00 UTC on 1 January 1970, the Unix epoch. [...] Unix time is sometimes referred to as Epoch time. This can be misleading since Unix time is not the only time system based on an epoch and the Unix epoch is not the only epoch used by other time systems.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NXTME469
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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,801,157.2 1,657,286,447 1,660,541,882.5 1,663,797,748 1,667,058,779.5 1,670,326,349 1,180,413 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,413 ( 100.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
time
100.00%
100.00%
1657286447 1657286447

Continuous Data Distribution

Figure 58. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: datetime

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 datetime
Description

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Data type Date and Time
Descriptor iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description

date and time representation [...] that includes all the time scale components [...] associated with the expression [...]

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

n/a

Table 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,413 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,413 ( 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
datetime
100.00%
100.00%
2022-07-08 15:20:47 2022-07-08 15:20:47

Outliers

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

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

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 scdCO2
Description

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

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

n/a

Table 90. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdCO2 6 - 7 1,612.692 327.00 563 1,252 2,522 7,381.00 1,180,413 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5,552 ( 0.5% )
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
scdCO2
100.00%
0.47%
470.00 5221.00

Continuous Data Distribution

Figure 65. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdT

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 scdT
Description

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

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

°C

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdT 4 - 5 17.905 0.77 11.53 16.74 22.35 48.61 1,180,413 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,785 ( 0.4% )
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
scdT
100.00%
0.41%
15.05 47.44

Continuous Data Distribution

Figure 69. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdH

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 scdH
Description

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

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 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdH 5 - 5 68.910 21.75 58.81 72.45 81.28 95.21 1,180,413 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,006 ( 0.6% )
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
scdH
100.00%
0.59%
86.40 23.41

Continuous Data Distribution

Figure 73. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Hive 6 HPP queen excluder

Column: time

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 time
Description

Time of measurement in unix time format.

Data type Integer number
Descriptor pms:unixTime [UID:0.0.NXTME469]
Descriptor description

Unix time is a date and time representation widely used in computing. It measures time by the number of non-leap seconds that have elapsed since 00:00:00 UTC on 1 January 1970, the Unix epoch. [...] Unix time is sometimes referred to as Epoch time. This can be misleading since Unix time is not the only time system based on an epoch and the Unix epoch is not the only epoch used by other time systems.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NXTME469
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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,801,322.8 1,657,286,445 1,660,542,061.25 1,663,798,030.5 1,667,058,956.75 1,670,326,344 1,180,478 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,478 ( 100.0% )
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
time
100.00%
100.00%
1657286445 1657286445

Continuous Data Distribution

Figure 77. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: datetime

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 datetime
Description

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Data type Date and Time
Descriptor iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description

date and time representation [...] that includes all the time scale components [...] associated with the expression [...]

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

n/a

Table 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,478 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,478 ( 100.0% )
Table 103. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
datetime
100.00%
100.00%
2022-07-08 15:20:45 2022-07-08 15:20:45

Outliers

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

Completeness

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

Uniqueness

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

Column: scdCO2

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 scdCO2
Description

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

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

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdCO2 4 - 8 2,812.580 0.00 1,701 2,713 3,760 12,035.00 1,180,478 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 10,281 ( 0.9% )
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
scdCO2
100.00%
0.87%
2122.00 346.00

Continuous Data Distribution

Figure 84. Distribution of values in the column.

Outliers

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

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

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 scdT
Description

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

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

°C

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdT 4 - 5 21.144 4.30 15.22 23.21 27.02 37.88 1,180,478 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3,333 ( 0.3% )
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
scdT
100.00%
0.28%
25.15 37.88

Continuous Data Distribution

Figure 88. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdH

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 scdH
Description

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

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 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdH 5 - 5 71.355 36.54 60.96 67.7 87.19 96.75 1,180,478 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6,008 ( 0.5% )
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
scdH
100.00%
0.51%
93.86 37.40

Continuous Data Distribution

Figure 92. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Hive 7 HPP crown board

Column: time

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 time
Description

Time of measurement in unix time format.

Data type Integer number
Descriptor pms:unixTime [UID:0.0.NXTME469]
Descriptor description

Unix time is a date and time representation widely used in computing. It measures time by the number of non-leap seconds that have elapsed since 00:00:00 UTC on 1 January 1970, the Unix epoch. [...] Unix time is sometimes referred to as Epoch time. This can be misleading since Unix time is not the only time system based on an epoch and the Unix epoch is not the only epoch used by other time systems.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NXTME469
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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,657,561,714.0 1,651,046,864 1,654,302,421.25 1,657,558,458.5 1,660,819,331.75 1,664,086,749 1,180,426 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,426 ( 100.0% )
Table 115. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
time
100.00%
100.00%
1651046864 1651046864

Continuous Data Distribution

Figure 96. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: datetime

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 datetime
Description

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Data type Date and Time
Descriptor iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description

date and time representation [...] that includes all the time scale components [...] associated with the expression [...]

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

n/a

Table 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datetime 19 - 19 2,022.0 2022-04-27 1… 2,022 2,022 2,022 2022-09-25 0… 1,180,426 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,426 ( 100.0% )
Table 118. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
datetime
100.00%
100.00%
2022-04-27 10:07:44 2022-04-27 10:07:44

Outliers

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

Completeness

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

Uniqueness

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

Column: scdCO2

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 scdCO2
Description

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

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

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdCO2 6 - 7 2,070.117 166.00 744 1,706 3,033 9,369.00 1,180,426 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,847 ( 0.7% )
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
scdCO2
100.00%
0.66%
464.00 325.00

Continuous Data Distribution

Figure 103. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdT

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 scdT
Description

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

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

°C

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdT 4 - 5 17.757 0.18 10.96 16.84 22.68 48.94 1,180,426 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,914 ( 0.4% )
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
scdT
100.00%
0.42%
18.42 48.85

Continuous Data Distribution

Figure 107. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdH

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 scdH
Description

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdH 5 - 5 70.730 23.04 61.94 73.53 81.84 96.48 1,180,426 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,055 ( 0.6% )
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
scdH
100.00%
0.60%
86.18 23.65

Continuous Data Distribution

Figure 111. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Hive 8 HPP crown board

Column: time

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 time
Description

Time of measurement in unix time format.

Data type Integer number
Descriptor pms:unixTime [UID:0.0.NXTME469]
Descriptor description

Unix time is a date and time representation widely used in computing. It measures time by the number of non-leap seconds that have elapsed since 00:00:00 UTC on 1 January 1970, the Unix epoch. [...] Unix time is sometimes referred to as Epoch time. This can be misleading since Unix time is not the only time system based on an epoch and the Unix epoch is not the only epoch used by other time systems.

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

n/a

Table 129. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,804,042.6 1,657,289,516 1,660,544,901.25 1,663,800,692.5 1,667,061,506.75 1,670,329,057 1,180,374 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,374 ( 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
time
100.00%
100.00%
1657289516 1657289516

Continuous Data Distribution

Figure 115. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: datetime

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 datetime
Description

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Data type Date and Time
Descriptor iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description

date and time representation [...] that includes all the time scale components [...] associated with the expression [...]

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

n/a

Table 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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,374 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,374 ( 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
datetime
100.00%
100.00%
2022-07-08 16:11:56 2022-07-08 16:11:56

Outliers

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

Completeness

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

Uniqueness

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

Column: scdCO2

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 scdCO2
Description

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

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

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 Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdCO2 6 - 7 1,738.906 332.00 603 1,095 2,669 6,835.00 1,180,374 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6,241 ( 0.5% )
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
scdCO2
100.00%
0.53%
497.00 6201.00

Continuous Data Distribution

Figure 122. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdT

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

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

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

°C

Table 138. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdT 4 - 5 18.150 0.87 11.71 17.12 22.95 48.72 1,180,374 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,955 ( 0.4% )
Table 139. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
scdT
100.00%
0.42%
14.17 47.32

Continuous Data Distribution

Figure 126. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdH

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

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

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 141. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdH 5 - 5 62.520 26.03 55.22 63.28 70.28 82.27 1,180,374 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5,161 ( 0.4% )
Table 142. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
scdH
100.00%
0.44%
63.73 26.03

Continuous Data Distribution

Figure 130. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Hive 8 HPP queen excluder

Column: time

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

Time of measurement in unix time format.

Data type Integer number
Descriptor pms:unixTime [UID:0.0.NXTME469]
Descriptor description

Unix time is a date and time representation widely used in computing. It measures time by the number of non-leap seconds that have elapsed since 00:00:00 UTC on 1 January 1970, the Unix epoch. [...] Unix time is sometimes referred to as Epoch time. This can be misleading since Unix time is not the only time system based on an epoch and the Unix epoch is not the only epoch used by other time systems.

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

n/a

Table 144. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
time 10 - 10 1,663,804,052.8 1,657,289,647 1,660,544,821.25 1,663,800,624.5 1,667,061,624.75 1,670,329,066 1,180,298 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,298 ( 100.0% )
Table 145. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
time
100.00%
100.00%
1657289647 1657289647

Continuous Data Distribution

Figure 134. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: datetime

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

Date and time of day of measurement in ISO 8601 format, calculated from column time.

Data type Date and Time
Descriptor iso-8601:calendarDateAndTime [UID:0.0.DTNDT319]
Descriptor description

date and time representation [...] that includes all the time scale components [...] associated with the expression [...]

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

n/a

Table 147. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datetime 19 - 19 2,022.0 2022-07-08 1… 2,022 2,022 2,022 2022-12-06 1… 1,180,298 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,298 ( 100.0% )
Table 148. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
datetime
100.00%
100.00%
2022-07-08 16:14:07 2022-07-08 16:14:07

Outliers

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

Completeness

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

Uniqueness

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

Column: scdCO2

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

Carbon dioxide measurement of the sensor. The unit has not been specified by the data provider.

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

n/a

Table 150. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdCO2 4 - 8 3,059.838 0.00 1,674 2,997 4,271 10,280.00 1,180,298 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8,465 ( 0.7% )
Table 151. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
scdCO2
100.00%
0.72%
477.00 7710.00

Continuous Data Distribution

Figure 141. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdT

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

Neither parameter nor unit have been specified by the data provider. Presumably a temperature measurement.

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

°C

Table 153. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdT 4 - 5 22.729 1.84 17.38 24.73 29.22 35.15 1,180,298 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3,261 ( 0.3% )
Table 154. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
scdT
100.00%
0.28%
30.28 34.84

Continuous Data Distribution

Figure 145. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: scdH

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

Neither parameter nor unit have been specified by the data provider. Presumably a relative humidity measurement.

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 156. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
scdH 5 - 5 65.357 38.44 59.08 64.56 69.98 88.96 1,180,298 7 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4,597 ( 0.4% )
Table 157. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
scdH
100.00%
0.39%
61.81 44.53

Continuous Data Distribution

Figure 149. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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