Table: metadata main table

This table contains metadata on the honey bee colonies used in the study, the period in which a particular hive sensor device was associated with a honey bee colony, information on the data files produced by a hive sensor device, technical information related to a hive sensor device, information on the fate of the honey bee colony in 2020 and some general remarks related to the honey bee colony.

• metadata main table.Device_id links to sensor devices.Device_id
• metadata main table.Device_id links to sensor definitions.Device_id

1. Changed header from Device ID to Device_id. Reason: It is good data management practice to use consistent metadata throughout the entire dataset.

1. Missing values were replaced by {NULL} (290 occurrences)

1. For many columns it is possible to guess the meaning based on the context. However, for some columns (latest LOG file used for importing 2022 data, Data length (days), Data size imported (timestamps), Data length imported (days), Data completeness (%) before importing data, Researches, Q replacement date(s), Remarks about Q info and .csv data file downloaded). Since it was decided to include this data in the data set, it should be explained in order to allow reuse of the data.
2. In column ID there are 31 occurrences of {NULL}. If there are no well-founded reasons to do so it is recommended to use an integer value. Otherwise, there is a risk of an error when the data is reused.
3. In cell H1 of worksheet meta data 2022 (20230303) of raw data file meta-data-compiled-2022-20230303.xlsx a comment has been added. This information gets lost when the data is imported in the EU Pollinator Hub. If there are no well-founded reasons to do so it is recommended to add such comments in a separate column.