The data was published by Alaux CA (INRAE) 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 records of daily number of exits and entrances of bees from 6 colonies per location in 2023 in the locations Avignon/France (31.03.2023 – 15.11.2023), Halle/Germany (2023-05-17 – 2023-11-15) and Gent/Belgium (2023-06-02 – 2023-11-15).

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.

The dataset consists of one table (591,97 KB), which contains 6.960 records.

Currently, the data integrated from the B-GOOD Bee Health Data Portal contains maior 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.

The data was published by Alaux CA (INRAE) 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 records of daily number of exits and entrances of bees from 6 colonies per location in 2023 in the locations Avignon/France (31.03.2023 – 15.11.2023), Halle/Germany (17.05.2023 – 15.11.23) and Gent/Belgium (02.06.2023 – 15.11.23).

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.

All raw data files were downloaded from the B-GOOD Bee Health Data Portal on 2024-09-23 18:47:55.

List of raw data obtained from the data provider.

1. File bee-counters-exen-daily-counts, accessed on 2024-09-23 18:47:55, provided by B-GOOD Bee Health Data Portal

Metadata was obtained from the web pages of the dataset's web page.

The file in the zip-archive was extracted using File Explorer (Microsoft Corporation, version 22H2).

The file GOOD_Virus_Data_2018_2020 Pool size.xlsx was processed with MS Excel (Microsoft Corporation, version 2409). Column date was separated into column time and date and correctly formated to ISO 8601 format and the additional columns city, NUTS3, device, device_ID and direction were inserted and filled with the appropriate information. The worksheets were then exported to separate data files in CSV format (UTF-8 encoding) and imported into Notepad++ (version 8.7) where missing values were substituted by {NULL} using regular expressions. All data files were then merged using the Python script MergeCsv.py. Finally, the merged data file was unpivoted using the Python script UnpivotToCsv.py.

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

No data validation was performed.

No data analysis was performed.

Table bee counter data contains 6.960 records of daily number of exits and entrances of bees from 6 colonies in the locations INRAE (Avignon, France), measured from 2023-03-31 to 2023-05-15), HALLE (Halle, Germany), measured from 2023-05-17 to 2023-11-15 and GENT (Gent, Belgium), measured from 2023-06-02 to 2023-11-15. For location INRAE, HALLE and GENT there are 2.760, 2.196 and 2.004 records, respectively. A total of 138 values for total number of bees were missing, 114 records in location INRAE, 18 records in location HALLE and 6 records in location GENT. The analysis of outliers revealed extreme values in the number of bees entering and exiting the hive greater than 340.000 day-1 (up to 1.805.380 day-1), in device CPT_0651 (12 records, measured on 2023-09-27 and from 2023-11-11 to 2023-11-15) and in device CPT_7680 (2 records) measured on 2023-08-20, both placed in Halle.

1. Columns city and NUTS3 were inserted. Values in the columns were derived from the metadata provided by the data owner on the B-GOOD Bee Health Data Portal.
2. Colum time was inserted. Values in columns date and time were derived from the datetime in column date in the raw data provided on the B-GOOD Bee Health Data Portal. The meaning of the datetime was not specified by the data provider but there are good reasons to assume that this is the date and time of data transmission by the remote sensors, which did not occur at the same time in all records (either 01:00 or 02:00 am) . In order to facilitate automated data processing it has been decided to store date and time separately, as the exact time of transmission might be irrelevant.
3. Column device was inserted. Values in column device were derived from the header of the values acquired with the respective device in the raw data provided on the B-GOOD Bee Health Data Portal].
4. Column device_ID was inserted. Values in column device_ID were derived from the assumed device name contained in column device.
5. Column direction was inserted. Values in column direction were derived from the direction of movements of bees at the hive entrance ({in}: bees entering the beehive; {out}: bees leaving the beehive) extracted from the column device.

1. In 138 records in which column number contained missing data (114 records for location INRAE, 18 records for location HALLE, 6 records for location GENT) it was replaced by {NULL}.

1. Due to the missing description of the data it is unclear what the time provided with the date in the raw data refers to. The data provider is requested to make this information available.
2. It is unclear, whether the number of bees entering or leaving the beehive reported in the raw data refer to the date provided in column date or to the previous day, given that the time provided with the date (either 01:00 or 02:00) is often used as transmission time for remote devices. The data provider is requested to make this information available.
3. Extreme outliers have been found in the number of bees entering and exiting the hive, which should be further investigated by the data provider.

1. Columns city and NUTS3 were inserted. Values in the columns were derived from the metadata provided by the data owner on the B-GOOD Bee Health Data Portal.
2. Colum time was inserted. Values in columns date and time were derived from the datetime in column date in the raw data provided on the B-GOOD Bee Health Data Portal. The meaning of the datetime was not specified by the data provider but there are good reasons to assume that this is the date and time of data transmission by the remote sensors, which did not occur at the same time in all records (either 01:00 or 02:00 am) . In order to facilitate automated data processing it has been decided to store date and time separately, as the exact time of transmission might be irrelevant.
3. Column device was inserted. Values in column device were derived from the header of the values acquired with the respective device in the raw data provided on the B-GOOD Bee Health Data Portal].
4. Column device_ID was inserted. Values in column device_ID were derived from the assumed device name contained in column device.
5. Column direction was inserted. Values in column direction were derived from the direction of movements of bees at the hive entrance ({in}: bees entering the beehive; {out}: bees leaving the beehive) extracted from the column device.

1. In 138 records in which column number contained missing data (114 records for location INRAE, 18 records for location HALLE, 6 records for location GENT) it was replaced by {NULL}.

1. Due to the missing description of the data it is unclear what the time provided with the date in the raw data refers to. The data provider is requested to make this information available.
2. It is unclear, whether the number of bees entering or leaving the beehive reported in the raw data refer to the date provided in column date or to the previous day, given that the time provided with the date (either 01:00 or 02:00) is often used as transmission time for remote devices. The data provider is requested to make this information available.
3. Extreme outliers have been found in the number of bees entering and exiting the hive, which should be further investigated by the data provider.