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. [2025-05-20] 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.

interactions.single.section-about.data-overview-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 n/a 2022-07-08 1… n/a n/a n/a 2022-12-07 1… 1,190,029 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,190,029 ( 100.0% )
scdCO2 1 - 5 3,484.7 0 1,943 3,179 4,795 23,041 1,190,029 1 ( 0.0% ) 10 ( 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 313
scdT
100.00%
0.24%
26.45 n/a
scdH
100.00%
0.35%
82.59 n/a

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 n/a 2022-07-08 1… n/a n/a n/a 2022-12-06 1… 1,180,479 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,479 ( 100.0% )
scdCO2 2 - 5 3,291.3 43 2,185 3,066 4,153 18,640 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 9972
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 n/a 2022-07-08 1… n/a n/a n/a 2022-12-06 1… 1,180,538 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,538 ( 100.0% )
scdCO2 3 - 5 3,002.0 272 1,415 2,863 4,278 16,675 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 362
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 n/a 2022-07-08 1… n/a n/a n/a 2022-12-06 1… 1,180,413 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,413 ( 100.0% )
scdCO2 3 - 4 1,612.7 327 563 1,252 2,522 7,381 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 5221
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 n/a 2022-07-08 1… n/a n/a n/a 2022-12-06 1… 1,180,478 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,478 ( 100.0% )
scdCO2 1 - 5 2,812.6 0 1,701 2,713 3,760 12,035 1,180,478 7 ( 0.0% ) 2 ( 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 346
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 n/a 2022-04-27 1… n/a n/a n/a 2022-09-25 0… 1,180,426 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,426 ( 100.0% )
scdCO2 3 - 4 2,070.1 166 744 1,706 3,033 9,369 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% ) 25 ( 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 325
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
scdH

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

 Decimal number DecimalNumber [0.0.DCMLN314]

%
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

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
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% )
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 n/a 2022-07-08 1… n/a n/a n/a 2022-12-06 1… 1,180,374 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,374 ( 100.0% )
scdCO2 3 - 4 1,738.9 332 603 1,095 2,669 6,835 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% ) 18 ( 0.0% ) 0 ( 0.0% ) 4,955 ( 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
scdH
100.00%
0.44%
63.73 26.03
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 6201
scdT
100.00%
0.42%
14.17 47.32

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 n/a 2022-07-08 1… n/a n/a n/a 2022-12-06 1… 1,180,298 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,180,298 ( 100.0% )
scdCO2 1 - 5 3,059.8 0 1,674 2,997 4,271 10,280 1,180,298 7 ( 0.0% ) 6 ( 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 7710
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.