Dataset: B-GOOD Health Monitoring

The dataset contains results from the analysis of the pathogens Deformed Wing Virus A (DWV-A), Deformed Wing Virus B (DWV-B); Acute Bee Paralysis Virus (ABPV), Chronic Bee Paralysis Virus (CBPV), Black Queen Cell Virus (BQCV), Sackbrood Virus (SBV), Paenibacillus larvae; Melissococcus plutonius; Nosema apis; Nosema ceranae; Malpighamoeba mellificae; Varroa destructor in honey bee samples collected in spring, summer and autumn of 2020, 2021 and 2022 in different locations. It was published by Schäfer MO (FLI) 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 data was published by Schäfer MO (FLI) 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 results from the analysis of pathogens (Deformed Wing Virus A, DWV A; Deformed Wing Virus B, DWV B; Acute Bee Paralysis Virus, ABPV; Chronic Bee Paralysis Virus CBPV; Black Queen Cell Virus BQCV; Sackbrood Virus, SBV; Paenibacillus larvae; Melissococcus plutonius; Nosema apis; Nosema ceranae; Malpighamoeba mellificae; Varroa destructor) in bee samples collected in spring, summer and autumn of 2020, 2021 and 2022 in different locations.

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 datset contains two tables. One contains the results from the pilot studies (1029 records, 333,43 kB), one the results from the field studies (769 records, 233,42 kB).

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.

The data was published by Schäfer MO (FLI) 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 results from the analysis of pathogens (Deformed Wing Virus A, DWV A; Deformed Wing Virus B, DWV B; Acute Bee Paralysis Virus, ABPV; Chronic Bee Paralysis Virus CBPV; Black Queen Cell Virus BQCV; Sackbrood Virus, SBV; Paenibacillus larvae; Melissococcus plutonius; Nosema apis; Nosema ceranae; Malpighamoeba mellificae; Varroa destructor) in bee samples collected in spring, summer and autumn of 2020, 2021 and 2022 in different locations.

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-07-04.

List of raw data and metadata files obtained from the data provider.

1. File b-good-pilot-a-results-2020-for-beep-v2.xlsx accesed on 2024-10-01 14:19:29, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
2. File b-good-pilot-a-results-2020-for-inrae-v2.xlsx accessed on 2024-10-01 14:21:11, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
3. File b-good-pilot-a-results-2020-for-mlu-v2.xlsx accessed on 2024-10-01 14:21:31, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
4. File b-good-pilot-a-results-2020-for-tntu-v2.xlsx accessed on 2024-10-01 14:22:01, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
5. File b-good-pilot-a-results-2020-for-ubern-v2.xlsx accessed on 2024-10-01 14:26:57, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
6. File b-good-pilot-a-results-2020-for-ucluj-v2.xlsx accessed on 2024-10-01 14:27:11, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
7. File b-good-pilot-a-results-2020-for-ucoi-v2.xlsx accessed on 2024-10-01 14:27:55, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
8. File b-good-pilot-a-results-2020-for-ugent-v2.xlsx accessed on 2024-10-01 14:28:07, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
9. File b-good-pilot-a-results-2020-for-wr-v2.xlsx accessed on 2024-10-01 14:28:19, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
10. File b-good-pilot-b-results-2020-for-wr-v3.xlsx accessed on 2024-10-01 14:28:33, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
11. File b-good-tier-1-results-2021-for-beep-v3.xlsx accessed on 2024-10-01 17:47:21, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
12. File b-good-tier-1-results-2021-for-inrae-v2.xlsx accessed on 2024-10-01 17:47:36, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
13. File b-good-tier-1-results-2021-for-mlu-v2.xlsx accessed on 2024-10-01 17:47:50, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
14. File b-good-tier-1-results-2021-for-tntu-v2.xlsx accessed on 2024-10-01 17:48:04, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
15. File b-good-tier-1-results-2021-for-ubern-v2.xlsx accessed on 2024-10-01 17:48:22, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
16. File b-good-tier-1-results-2021-for-ucluj-v2.xlsx accessed on 2024-10-01 17:48:34, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
17. File b-good-tier-1-results-2021-for-ucoi-v3.xlsx accessed on 2024-10-01 17:48:51, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
18. File b-good-tier-1-results-2021-for-ugent-v2.xlsx accessed on 2024-10-01 17:49:05, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
19. File b-good-tier1-results-2021-for-wr-v2.xlsx accessed on 2024-10-01 17:49:18, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
20. File b-good-pilot-b-results-2021-for-wr-v2.xlsx accessed on 2024-10-01 17:49:36, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
21. File b-good-tier-1-results-2022-for-beep.xlsx accessed on 2024-10-01 18:16:24, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
22. File b-good-tier-1-results-2022-for-inrae.xlsx accessed on 2024-10-01 18:16:44, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
23. File b-good-tier-1-results-2022-for-mlu.xlsx accessed on 2024-10-01 18:16:57, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
24. File b-good-tier-1-results-2022-for-tntu.xlsx accessed on 2024-10-01 18:17:10, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
25. File b-good-tier-1-results-2022-for-ubern.xlsx accessed on 2024-10-01 18:17:22, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
26. File b-good-tier-1-results-2022-for-ucluj.xlsx accessed on 2024-10-01 18:17:34, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
27. File b-good-tier-1-results-2022-for-ucoi.xlsx accessed on 2024-10-01 18:17:46, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
28. File b-good-tier-1-results-2022-for-ugent.xlsx accessed on 2024-10-01 18:18:09, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
29. File b-good-pilot-a-results-2022-for-wr.xlsx accessed on 2024-10-01 18:18:24, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
30. File b-good-pilot-b-results-2022-for-wr.xlsx accessed on 2024-10-01 18:18:41, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
31. File b-good-tier-2-results-2021-for-beep-v3.xlsx accessed on 2024-10-01 18:27:41, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
32. File b-good-tier-2-results-2021-for-bsour-v2.xlsx accessed on 2024-10-01 18:27:55, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
33. File b-good-tier-2-results-2021-for-mlu-v2.xlsx accessed on 2024-10-01 18:28:08, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
34. File b-good-tier-2-results-2021-for-sml-v2.xlsx accessed on 2024-10-01 18:28:22, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
35. File b-good-tier-2-results-2021-for-ubern-v3.xlsx accessed on 2024-10-01 18:28:34, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
36. File b-good-tier-2-results-2021-for-wr-v2.xlsx accessed on 2024-10-01 18:28:47, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
37. File b-good-tier-2-results-2022-for-beep-v2.xlsx accessed on 2024-10-01 18:22:14, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
38. File b-good-tier-2-results-2022-for-bsour.xlsx accessed on 2024-10-01 18:22:35, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
39. File b-good-tier-2-results-2022-for-mlu.xlsx accessed on 2024-10-01 18:22:47, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
40. File b-good-tier-2-results-2022-for-sml-v2.xlsx accessed on 2024-10-01 18:23:00, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
41. File b-good-tier-2-results-2022-for-ubern.xlsx accessed on 2024-10-01 18:23:15, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
42. File b-good-tier-2-results-2022-for-wr.xlsx accessed on 2024-10-01 18:23:29, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal
43. File b-good-tier-3-results-2022-for-beep.xlsx accessed on 2024-10-01 18:24:20, provided by Schäfer, MO (FLI) at B-GOOD Bee Health Data Portal

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

All files in the zip-archives were extracted using File Explorer (Microsoft Corporation, version 22H2). The data files were processed using MS Excel (Microsoft Corporation, version 2409).

For datasets B-GOOD Pilot A results 2020 for MLU V2, B-GOOD Pilot A results 2020 for TNTU V2, B-GOOD Pilot A results 2020 for UBERN V2, B-GOOD Pilot A results 2020 for UCLUJ V2, and B-GOOD Pilot B results 2020 for WR V3, two apparently identical raw data files (same name, size) were provided on the B-GOOD Bee Health Data Portal. These files were compared using the Get-FileHash command of the Microsoft.PowerShell.Utility module, which computes the hash value for each raw data file by using the SHA256 hash algorithm. Hash values were then compared with MS Excel using the EXACT function. All hash values were the same for each of the duplicate raw data files, therefore, one duplicate file per dataset was deleted.

Tier 1 Pilot A and B 2020. Even though this is not explicitly stated in the data description, the file of dataset B-GOOD Pilot A results 2020 for BEEP V2 (b-good-pilot-a-results-2020-for-beep-v2.xlsx) contains the data (180 records) form the following datasets, which were therefore not integrated in order to avoid duplicate records: B-GOOD Pilot A results 2020 for INRAe V2; B-GOOD Pilot A results 2020 for MLU V2; B-GOOD Pilot A results 2020 for TNTU V2; B-GOOD Pilot A results 2020 for UBERN V2; B-GOOD Pilot A results 2020 for UCLUJ V2; B-GOOD Pilot A results 2020 for UCOI V2; B-GOOD Pilot A results 2020 for UGENT V2; B-GOOD Pilot A results 2020 for WR V2.

The following issues were found and resolved:

• In column N. spores
  • file b-good-pilot-a-results-2020-for-beep-v2.xlsx contains {<25000} while file b-good-pilot-a-results-2020-for-ucluj-v2.xlsx contains {0} for Sample ID {AHJTRZLZ}. {< 25000} has been used, as b-good-pilot-a-results-2020-for-beep-v2.xlsx is assumed to be the single source of truth.
  • file b-good-pilot-a-results-2020-for-beep-v2.xlsx contains {<25000} while file b-good-pilot-a-results-2020-for-inrae-v2.xlsx contains {0} for Sample ID {MUDAXHCG}. {< 25000} has been used, as b-good-pilot-a-results-2020-for-beep-v2.xlsx is assumed to be the single source of truth.
  • file b-good-pilot-a-results-2020-for-beep-v2.xlsx contains {<25000} while file b-good-pilot-a-results-2020-for-inrae-v2.xlsx contains {0} for Sample ID {RRMUZUBR}. {< 25000} has been used, as b-good-pilot-a-results-2020-for-beep-v2.xlsx is assumed to be the single source of truth.
  • file b-good-pilot-a-results-2020-for-beep-v2.xlsx contains {<25000} while file b-good-pilot-a-results-2020-for-inrae-v2.xlsx contains {0} for Sample ID {SKLRARCR}. {< 25000} has been used, as b-good-pilot-a-results-2020-for-beep-v2.xlsx is assumed to be the single source of truth.
  • file b-good-pilot-a-results-2020-for-beep-v2.xlsx contains {<25000} while file b-good-pilot-a-results-2020-for-inrae-v2.xlsx contains {0} for Sample ID {XLFGKPJZ}. {< 25000} has been used, as b-good-pilot-a-results-2020-for-beep-v2.xlsx is assumed to be the single source of truth.

Tier 1 Pilot A and B 2021. Even though this is not explicitly stated in the data description, the file of dataset Tier1 Pilot A results 2021 for BEEP (b-good-tier-1-results-2021-for-beep-v3.xlsx) contains the data (186 records) form the following datasets, which were therefore not integrated in order to avoid duplicate records: Tier1 Pilot A results 2021 for INRAe; Tier1 Pilot A results 2021 for MLU; Tier1 Pilot A results 2021 for TNTU; Tier1 Pilot A results 2021 for UBERN; Tier1 Pilot A results 2021 for UCLUJ; Tier1 Pilot A results 2021 for UCOI; Tier1 Pilot A results 2021 for UGENT; Tier1 Pilot A results 2021 for WR.

Tier 1 Pilot A and B 2022. Even though this is not explicitly stated in the data description, the file of dataset Tier1 Pilot A results 2022 for BEEP (b-good-tier-1-results-2022-for-beep.xlsx) contains the data 186 records) form the following datasets, which were therefore not integrated in order to avoid duplicate records: Tier1 Pilot A results 2022 for INRAe; Tier1 Pilot A results 2022 for MLU; Tier1 Pilot A results 2022 for TNTU; Tier1 Pilot A results 2022 for UBERN; Tier1 Pilot A results 2022 for UCLUJ; Tier1 Pilot A results 2022 for UCOI; Tier 1 Pilot A results 2022 for UGENT; Tier1 Pilot A results 2022 for WR.

The following issues were found and resolved:

• Records with sample ID {XMMDKSCT; RGYMGYTM; GFGTGBKY} contained in file b-good-tier-1-results-2022-for-ucluj.xlsx (3 records), but not in file b-good-tier-1-results-2022-for-beep.xlsx were not integrated into the dataset, as file b-good-pilot-a-results-2020-for-beep-v2.xlsx is assumed to be the single source of truth.

Tier 2 Field study 2021. Even though this is not explicitly stated in the data description, the file of dataset Tier2 Field study results 2021 for BEEP (b-good-tier-2-results-2021-for-beep-v3.xlsx) contains the data (311 records) form the following datasets, which were therefore not integrated in order to avoid duplicate records: Tier2 Field study results 2021 for BSOUR; Tier2 Field study results 2021 for MLU; Tier2 Field study results 2021 for SML; Tier2 Field study results 2021 for UBERN; Tier2 Field study results 2021 for WR.

Tier 2 Field study A 2022. Even though this is not explicitly stated in the data description, the file of dataset Tier2 Field study A results 2022 for BEEP (b-good-tier-2-results-2022-for-beep-v2.xlsx) contains the data (300 records) form the following datasets, which were therefore not integrated in order to avoid duplicate records: Tier2 Field study A results 2022 for BSOUR; Tier2 Field study A results 2022 for MLU; Tier 2 Field study A results 2022 for SML; Tier 2 Field study A results 2022 for UBERN; Tier 2 Field study A results 2022 for WR.

Data from all pilot studies and data from all field studies was transferred into one single table (pilot studies, field studies) in order to facilitate automated evaluation and visualisation of the data. Six columns were added to the beginning and one column to the end (RecordNotes) of each table, which contained the following metadata, as provided in the metadata section of each dataset on the B-GOOD Bee Health Data Portal:

• name of the dataset (column dataset)
• tier level of the study (column StudyTierLevel)
• name of the study (column StudyName)
• year of the study (column year)
• name of the organisation that provided that data file (column organisation)
• attribute contained in some data files, starting with the letter V followed by a number (either 2 or 3) presumably indicating the version number (column V)
• pool of comments added to fields in individual records (RecordNotes)

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.