Varroa sampling
This table contains data on Varroa infestation levels (the number of varroa mites found in the sampling event) measured in individual hives on a given apiary at a given time with a given quality standard. Varroa samples were collected from citizen and mined data using 3 standard method sources between the years 2012-2020. This data contains 11124 varroa sampling events. Roughly 21% of these events record zero mites present. The highest number of mites present in a single sampling event is 5016. Sampling events are collected from 04/02/12 to 11/11/20, and last on average 7.2 days each (range: 1.0-23.8 days). Roughly 75% of Varroa Sampling events occur between 3 and 9 days.
Data on mite infestation levels were collected from 3 sources by a standard method - natural mite falls - from 2012 to 2020, mainly in the spring, early summer, and late summer. Data were collected from 3 different sources of differing quality. Data from the highest quality, described as quality_control=2, was examined with the BeeVS diagnostic system (Apisfero, Turin, Italy), which consists of a high-resolution scanner to take a picture of the samples (sticky boards placed under the brood nest of colonies) and cloud-based software used to count the number of mites on the sticky boards. Data from the intermediate source is described as quality_control=1 and were examined manually by a trained group. Data from the poorest quality source is described as quality_control=0 and were examined manually by untrained individuals according to a classification scheme. Data was entered via a web terminal by whomever analyzed the sample. The software vetted the data for plausibility (rejection of values that exceed 100 mites/day) and completeness (rejection of values that did not fall between a 3 day and 21-day measuring interval). Data exceeding these limits, which can be found in the data set, has been imported from external resources and has been approved by the supervisor. The data collected by untrained individuals were checked by the supervisor for plausibility.
From 2012 to 2016 the project was only implemented in the Austrian province of Styria, where approximately 3500 beekeepers supervised 53000 to 56000 honeybee colonies. In 2017 the crowdsourcing initiative was extended to all nine Austrian provinces, consisting of 28032 to 30237 beekeepers and 329402 to 390607 honeybee colonies in their care.
The total number of samples collected is 11124. 4033 (36%) were medium quality samples (QC=1) and 3267 (29%) were high quality samples (QC=2).
The varroa survey dataset includes 99 users (beekeepers), 242 bee yards (apiaries), and 2,116 hives from the nine Austrian provinces for a total of 11124 records pertaining to varroa infestation.
-
Licence
This file contains dataset licencing information.
Dataset
Columns
Rows
Data points
Data profiling
Column description | Data type | Descriptor | ||
---|---|---|---|---|
sampling_id
|
The sampling event identifier
|
Integer |
Default unit
|
|
date_from
|
The first date (year, month, day) and time (hours, minutes) of the sampling event
|
String |
Default unit
|
|
date_to
|
The final date (year, month, day) and time (hours, minutes) of the sampling event
|
String |
Default unit
|
|
varroa_count
|
The number of varroa mites found in the sampling event
|
Integer |
Default unit
|
|
quality_control
|
The quality level of the sample collected
* 2 = examined with the BeeVS diagnostic system
* 1 = examined manually by a trained group.
* 0 = examined manually by untrained individuals
|
Integer |
Default unit
|
|
hive_id
|
The hive identifier
|
Integer |
Default unit
|
|
yard_id
|
The yard identifier
|
Integer |
Default unit
|
Length | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct | Outliers | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sampling_id
|
1 - 5
|
5,788.6
|
1
|
2,953.3
|
5,828.5
|
8,625.8
|
11,427
|
11,124
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
11,124 (100.0 %)
|
5,562 (50.0 %)
|
date_from
|
11 - 14
|
n/a
|
1/1/19 13:00
|
n/a
|
n/a
|
n/a
|
9/9/18 15:30
|
11,124
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1,903 (17.1 %)
|
n/a
|
date_to
|
11 - 14
|
n/a
|
1/12/18 16:00
|
n/a
|
n/a
|
n/a
|
9/9/20 18:00
|
11,124
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
2,227 (20.0 %)
|
n/a
|
varroa_count
|
1 - 4
|
28.3
|
0
|
1.0
|
4.0
|
16.0
|
5,016
|
11,124
|
0 (0.0 %)
|
2,301 (20.7 %)
|
0 (0.0 %)
|
387 (3.5 %)
|
4,985 (44.8 %)
|
quality_control
|
1 - 1
|
0.9
|
0
|
0.0
|
1.0
|
2.0
|
2
|
11,124
|
0 (0.0 %)
|
3,824 (34.4 %)
|
0 (0.0 %)
|
3 (0.0 %)
|
0 (0.0 %)
|
hive_id
|
1 - 4
|
820.6
|
1
|
289.0
|
715.0
|
1,199.0
|
2,501
|
11,124
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
2,116 (19.0 %)
|
5,539 (49.8 %)
|
yard_id
|
2 - 3
|
370.5
|
73
|
194.0
|
391.0
|
522.0
|
664
|
11,124
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
242 (2.2 %)
|
5,279 (47.5 %)
|
sampling_id | date_from | date_to | varroa_count | quality_control | hive_id | yard_id |
---|---|---|---|---|---|---|
1
|
4/13/17 12:00
|
4/22/17 12:00
|
0
|
1
|
412
|
87
|
2
|
7/6/17 12:00
|
7/10/17 12:00
|
3
|
1
|
412
|
87
|
3
|
4/13/17 12:00
|
4/22/17 12:00
|
0
|
1
|
278
|
87
|
4
|
4/22/17 12:00
|
4/30/17 12:00
|
1
|
1
|
278
|
87
|
5
|
4/30/17 12:00
|
5/8/17 12:00
|
5
|
1
|
278
|
87
|
6
|
7/6/17 12:00
|
7/10/17 12:00
|
1
|
1
|
278
|
87
|
7
|
4/13/17 12:00
|
4/22/17 12:00
|
1
|
1
|
256
|
87
|
8
|
4/22/17 12:00
|
4/30/17 12:00
|
1
|
1
|
256
|
87
|
9
|
4/30/17 12:00
|
5/8/17 12:00
|
1
|
1
|
256
|
87
|
10
|
7/6/17 12:00
|
7/10/17 12:00
|
8
|
1
|
256
|
87
|
11
|
4/13/17 12:00
|
4/22/17 12:00
|
4
|
1
|
259
|
87
|
12
|
4/22/17 12:00
|
4/30/17 12:00
|
0
|
1
|
259
|
87
|
13
|
4/30/17 12:00
|
5/8/17 12:00
|
3
|
1
|
259
|
87
|
14
|
7/6/17 12:00
|
7/10/17 12:00
|
11
|
1
|
259
|
87
|
15
|
4/13/17 12:00
|
4/22/17 12:00
|
3
|
1
|
284
|
87
|
16
|
4/22/17 12:00
|
4/30/17 12:00
|
0
|
1
|
284
|
87
|
17
|
4/30/17 12:00
|
5/8/17 12:00
|
2
|
1
|
284
|
87
|
18
|
7/6/17 12:00
|
7/10/17 12:00
|
11
|
1
|
284
|
87
|
19
|
4/13/17 12:00
|
4/22/17 12:00
|
0
|
1
|
272
|
87
|
20
|
4/22/17 12:00
|
4/30/17 12:00
|
0
|
1
|
272
|
87
|
21
|
4/30/17 12:00
|
5/8/17 12:00
|
0
|
1
|
272
|
87
|
22
|
7/6/17 12:00
|
7/10/17 12:00
|
13
|
1
|
272
|
87
|
23
|
4/13/17 12:00
|
4/22/17 12:00
|
1
|
1
|
312
|
87
|
24
|
4/22/17 12:00
|
4/30/17 12:00
|
1
|
1
|
312
|
87
|