Table: sample codes 2022

This table contains information on the codes of samples taken from honey bee colonies in the year 2022 and information on the analyses carried out.

• sample codes 2022.User_id links to apiaries 2022.User_id
• sample codes 2022.User_id links to hives 2022.User_id
• sample codes 2022.User_id links to sensor devices 2022.User_id
• sample codes 2022.User_id links to user consents 2022.User_id
• sample codes 2022.User_id links to users 2022.User_id
• sample codes 2022.Location_id links to metadata main table 2022.Hive_id
• sample codes 2022.Location_id links to hives 2022.Hive_id
• sample codes 2022.Location_id links to sample devices 2022.Hive_id
• sample codes 2022.Hive_id links to hives 2022.Hive_id
• sample codes 2022.Hive_id links to sensor devices 2022.Hive_id
• sample codes 2022.Hive_id links to metadata main table 2022.Hive_id
• sample codes 2022.Queenid links to hives 2022.Queenid
• sample codes 2022.Sample code links to B-GOOD health monitoring 2022.Field study.SampleID

None

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

1. Although the meaning of many columns can be guessed in context, the meaning of many columns (in particular of the columns Test type, Test date, Test result, Test lab name, Updated at, Deleted at) is not entirely clear. Since it was decided to include this data in the data set, it should be explained in order to allow reuse of the data.