table_iv_colony_management
[UID:MUSTB76.TBLVC135.0]
Data in this table contains annotations made by beekeepers who maintained the hives for the duration of the study. It is designed to be a diary which could be completed whenever the hive was visited. Inputs, e.g. supplementary feed or Varroa treatment, and outputs, e.g. honey collection or removal of bees, should have been reported. This diary could also be used to record the general observations of the beekeeper.
Download
-
Licence
This file contains dataset licencing information.
Properties
Dataset
Unique Identifier
[MUSTB76.TBLVC135.0]
URI
https://app.pollinatorhub.eu/dataset-discovery/parts/MUSTB76.TBLVC135.0
Columns
14
Rows
1,781
Data points
24,934
Data providers
Data profiling
| Column description | Data type | Descriptor | ||
|---|---|---|---|---|
|
eventId
|
Identifier for the reported event.
|
String |
Default unit
|
|
|
beeKeeperID
|
Identifier for diary keeper.
|
String |
Default unit
|
|
|
siteNo
|
Identifier for the site.
|
Integer |
Default unit
|
|
|
hiveNo
|
Identifier for the hive.
|
Integer |
Default unit
|
|
|
eventY
|
Year of event.
|
Integer |
Default unit
|
|
|
eventM
|
Month of event.
|
Integer |
Default unit
|
|
|
eventD
|
Day of event.
|
Integer |
Default unit
|
|
|
eventType
|
Classification of type of event. One of the following terms: CLINICAL SIGNS / INPUT / INSPECTION / OTHER / OUTPUT / QUEEN LOSS / SAMPLE / SWARM
|
String |
Default unit
|
|
|
inoutType
|
Type of material added of removed from hive (e.g. Varroa treatment, supplementary feeding, altering bee population). Must be completed if INPUT or OUTPUT is selected in eventType. One of the following terms: Amitraz / Brewers yeast / Bromopropylate / Brood comb / Camphor / Coumaphos / Cymiazole / Empty frame / Eucalyptol / Fluvalinate / Food comb / Formic acid / Foundation comb / Honey / Lactic acid / Live bees / Menthol / No input-output / Oxalic acid / Pollen / Queen excluder / Soybean flour / Sucrose / Super + 10 frames / Thymol / Umethrin
|
String |
Default unit
|
|
|
inoutQuantity
|
Amount of material added to or taken from.
|
Decimal (float) |
Default unit
|
|
|
inoutUnit
|
Units for quantity reported.
|
String |
Default unit
|
|
|
inoutUnit_desc
|
Content of column efsa_dcf_catalogue.unit_term.termExtendedName.
|
String |
Default unit
|
|
|
clinicalSigns
|
Categorise the type of clinical signs observed if CLINICAL SIGNS is reported. One of the following terms: Black queen larvae / Black shiny honey bees / Brood and honey destruction / Cannibalism on larvae or on pupae / Cell cappings opened / Crawling honey bees, bees clinging to the grass / Dead bees in hive bottom / Dead colony / Dead honey bees in front of the hive / Dead bees in hive bottom / Dead honey bees within cells with the heads directed to the bottom of the cell (starvation) / Dead honey bees within cells with the heads sticking out the cells / Doubtful clinical signs / Galleries inside the frames / Honey bees with deformed and-or atrophied wings / Impeded/Occupied flight board / Larvae with a yellowish to brown colour / Mummified larvae / No clinical signs / Phoretic beetles-unusual larvae or eggs / Phoretic varroa / Queen problems / Ropy larvae (match test positive) / Slumped larvae / Specific odor of AFB / Spotty brood pattern / Suspect atypical mite / Traces of diarrhea / Trembling honey bees / Unusual honey bee mortality according to bee inspector
|
String |
Default unit
|
|
|
eventDescription
|
Details of reported event.
|
String |
Default unit
|
| Length | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct | Outliers | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
eventId
|
3 - 6
|
n/a
|
CM10
|
n/a
|
n/a
|
n/a
|
CM999
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1,781 (100.0 %)
|
n/a
|
|
beeKeeperID
|
32 - 32
|
n/a
|
5BC8557A401F84B44F1BF03B71F3CF7C
|
n/a
|
n/a
|
n/a
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
3 (0.2 %)
|
n/a
|
|
siteNo
|
1 - 3
|
3.3
|
1
|
2.0
|
2.0
|
5.0
|
340
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
7 (0.4 %)
|
691 (38.8 %)
|
|
hiveNo
|
1 - 2
|
5.2
|
1
|
2.0
|
5.0
|
7.0
|
20
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
20 (1.1 %)
|
632 (35.5 %)
|
|
eventY
|
4 - 4
|
2,019.5
|
2,019
|
2,019.0
|
2,020.0
|
2,020.0
|
2,021
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
3 (0.2 %)
|
6 (0.3 %)
|
|
eventM
|
1 - 2
|
6.7
|
1
|
5.0
|
7.0
|
8.0
|
12
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
12 (0.7 %)
|
739 (41.5 %)
|
|
eventD
|
1 - 2
|
16.4
|
1
|
9.0
|
16.0
|
24.0
|
31
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
31 (1.7 %)
|
762 (42.8 %)
|
|
eventType
|
5 - 14
|
n/a
|
CLINICAL SIGNS
|
n/a
|
n/a
|
n/a
|
SWARM
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
7 (0.4 %)
|
n/a
|
|
inoutType
|
0 - 17
|
n/a
|
Amitraz
|
n/a
|
n/a
|
n/a
|
Thymol
|
1,781
|
807 (45.3 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
14 (0.8 %)
|
n/a
|
|
inoutQuantity
|
12 - 14
|
7.73217522000
|
0.0000000000
|
1.00000000000
|
2.50000000000
|
6.00000000000
|
300.0000000000
|
1,781
|
802 (45.0 %)
|
1 (0.1 %)
|
0 (0.0 %)
|
259 (14.5 %)
|
374 (21.0 %)
|
|
inoutUnit
|
0 - 5
|
n/a
|
G090A
|
n/a
|
n/a
|
n/a
|
G294A
|
1,781
|
802 (45.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
6 (0.3 %)
|
n/a
|
|
inoutUnit_desc
|
1 - 17
|
n/a
|
.
|
n/a
|
n/a
|
n/a
|
hiveframe
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
6 (0.3 %)
|
n/a
|
|
clinicalSigns
|
11 - 91
|
n/a
|
Black shiny honey bees
|
n/a
|
n/a
|
n/a
|
Traces of diarrhea
|
1,781
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
19 (1.1 %)
|
n/a
|
|
eventDescription
|
0 - 86
|
n/a
|
"3 frames added "
|
n/a
|
n/a
|
n/a
|
very small family
|
1,781
|
251 (14.1 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
433 (24.3 %)
|
n/a
|
| eventId | beeKeeperID | siteNo | hiveNo | eventY | eventM | eventD | eventType | inoutType | inoutQuantity | inoutUnit | inoutUnit_desc | clinicalSigns | eventDescription |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CM10
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
2
|
2019
|
4
|
3
|
SAMPLE
|
|
|
|
.
|
No clinical signs
|
Nosema test
|
|
CM100
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
4
|
2019
|
5
|
15
|
INPUT
|
Super + 10 frames
|
2.3000000000
|
G167A
|
Kilogram
|
No clinical signs
|
|
|
CM1000
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
11
|
2020
|
9
|
3
|
SAMPLE
|
|
|
|
.
|
No clinical signs
|
Sample of pollen
|
|
CM1001
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
12
|
2020
|
9
|
3
|
SAMPLE
|
|
|
|
.
|
No clinical signs
|
Sample of pollen
|
|
CM1002
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
6
|
2020
|
9
|
3
|
CLINICAL SIGNS
|
|
|
|
.
|
Dead bees in hive bottom
|
|
|
CM1003
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
6
|
2020
|
9
|
3
|
CLINICAL SIGNS
|
|
|
|
.
|
Dead honey bees in front of the hive
|
|
|
CM1004
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
2
|
2020
|
9
|
9
|
OUTPUT
|
Sucrose
|
2.4000000000
|
G167A
|
Kilogram
|
No clinical signs
|
Removed feeder
|
|
CM1005
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
2
|
2020
|
9
|
9
|
INPUT
|
Thymol
|
1.0000000000
|
G133A
|
Piece
|
No clinical signs
|
|
|
CM1006
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
1
|
2020
|
9
|
9
|
INPUT
|
Thymol
|
1.0000000000
|
G133A
|
Piece
|
No clinical signs
|
|
|
CM1007
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
6
|
2020
|
9
|
9
|
INPUT
|
Thymol
|
1.0000000000
|
G133A
|
Piece
|
No clinical signs
|
|
|
CM1008
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
11
|
2020
|
9
|
9
|
INPUT
|
Thymol
|
1.0000000000
|
G133A
|
Piece
|
No clinical signs
|
|
|
CM1009
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
12
|
2020
|
9
|
9
|
INPUT
|
Thymol
|
1.0000000000
|
G133A
|
Piece
|
No clinical signs
|
|
|
CM101
|
89D81AA2C010D67185C9217788CBCCF6
|
5
|
2
|
2019
|
3
|
28
|
INPUT
|
Super + 10 frames
|
10.0000000000
|
G167A
|
Kilogram
|
No clinical signs
|
Upper nest with laminated wax
|
|
CM1010
|
5BC8557A401F84B44F1BF03B71F3CF7C
|
2
|
3
|
2020
|
4
|
13
|
INPUT
|
Sucrose
|
1.2500000000
|
G167A
|
Kilogram
|
No clinical signs
|
|
|
CM1011
|
EAC7A9C9E5F667F3D1071B4DFBA72CF8
|
4
|
6
|
2020
|
9
|
23
|
CLINICAL SIGNS
|
|
|
|
.
|
Dead colony
|
Dead because of robbing
|
|
CM1012
|
89D81AA2C010D67185C9217788CBCCF6
|
6
|
12
|
2020
|
4
|
8
|
INPUT
|
Super + 10 frames
|
7.3600000000
|
G167A
|
Kilogram
|
No clinical signs
|
8 frame honey supper with wax comb
|
|
CM1013
|
5BC8557A401F84B44F1BF03B71F3CF7C
|
1
|
1
|
2020
|
4
|
22
|
INPUT
|
Super + 10 frames
|
4.9000000000
|
G167A
|
Kilogram
|
No clinical signs
|
super added + frames no. 31-40
|
|
CM1014
|
5BC8557A401F84B44F1BF03B71F3CF7C
|
1
|
1
|
2020
|
4
|
22
|
SAMPLE
|
|
|
|
.
|
No clinical signs
|
5 g honey and 2 g pollen + pollen for identification
|
|
CM1015
|
5BC8557A401F84B44F1BF03B71F3CF7C
|
1
|
1
|
2020
|
4
|
22
|
CLINICAL SIGNS
|
|
|
|
.
|
Traces of diarrhea
|
on two frames
|
|
CM1016
|
5BC8557A401F84B44F1BF03B71F3CF7C
|
1
|
1
|
2020
|
4
|
22
|
OTHER
|
|
|
|
.
|
No clinical signs
|
22 dead bees in front of hive
|
|
CM1017
|
5BC8557A401F84B44F1BF03B71F3CF7C
|
1
|
1
|
2020
|
5
|
13
|
OTHER
|
|
|
|
.
|
No clinical signs
|
73 dead bees in front of hive
|
|
CM1018
|
5BC8557A401F84B44F1BF03B71F3CF7C
|
1
|
1
|
2020
|
5
|
13
|
INPUT
|
Super + 10 frames
|
4.9000000000
|
G167A
|
Kilogram
|
No clinical signs
|
super added + frames no. 41-50
|
|
CM1019
|
89D81AA2C010D67185C9217788CBCCF6
|
6
|
12
|
2020
|
4
|
8
|
INPUT
|
No input-output
|
2.3000000000
|
G167A
|
Kilogram
|
No clinical signs
|
Box for activity videos
|
|
CM102
|
89D81AA2C010D67185C9217788CBCCF6
|
5
|
5
|
2019
|
3
|
28
|
INPUT
|
Super + 10 frames
|
10.0000000000
|
G167A
|
Kilogram
|
No clinical signs
|
Upper nest with laminated wax
|
- eventId
- beeKeeperID
- siteNo
- hiveNo
- eventY
- eventM
- eventD
- eventType
- inoutType
- inoutQuantity
- inoutUnit
- inoutUnit_desc
- clinicalSigns
- eventDescription
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
Data unavailable