table_vii_observation_colony
[UID:MUSTB76.TBLVB138.0]
Data in this table contains information obtained from the observation colony in order to determine foraging locations based on the interpretation of waggle dances.
Download
-
Licence
This file contains dataset licencing information.
Properties
Dataset
Unique Identifier
[MUSTB76.TBLVB138.0]
URI
https://app.pollinatorhub.eu/dataset-discovery/parts/MUSTB76.TBLVB138.0
Columns
14
Rows
769
Data points
10,766
Data providers
Data profiling
Column description | Data type | Descriptor | ||
---|---|---|---|---|
observationId
|
Unique identifier of the observation of the waggle dance performed at a certain time by one individual.
|
Integer |
Default unit
|
|
dancerId
|
Unique identifier of the bee performing the waggle dance.
|
Integer |
Default unit
|
|
siteNo
|
Identifier for the site.
|
Integer |
Default unit
|
|
hiveNo
|
Identifier for the observation hive.
|
Integer |
Default unit
|
|
sampY
|
Year of visit.
|
Integer |
Default unit
|
|
sampM
|
Month of visit.
|
Integer |
Default unit
|
|
sampD
|
Day of visit.
|
Integer |
Default unit
|
|
sampT
|
Time of visit.
|
Integer |
Default unit
|
|
waggleDuration
|
Duration of waggle dance in seconds.
|
Decimal (float) |
s
|
|
waggleLength
|
Radius of waggle dance in mm.
|
n/a
|
n/a
|
mm
|
waggleOrientation
|
Orientation in degrees.
|
Decimal (float) |
°
|
|
waggleDirection
|
Direction in degrees.
|
Decimal (float) |
°
|
|
pollenColor
|
Classification of pollen.
|
n/a
|
n/a
|
Default unit
|
pollenAbundance
|
Abundance of pollen classified by colour.
|
n/a
|
n/a
|
Default unit
|
Length | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct | Outliers | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
observationId
|
3 - 4
|
1,248.7
|
779
|
972.5
|
1,165.0
|
1,604.5
|
1,796
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
769 (100.0 %)
|
384 (49.9 %)
|
dancerId
|
5 - 5
|
54,946.0
|
11,177
|
32,387.0
|
54,619.0
|
77,308.5
|
99,714
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
767 (99.7 %)
|
384 (49.9 %)
|
siteNo
|
1 - 1
|
2.8
|
1
|
1.0
|
1.0
|
6.0
|
6
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
3 (0.4 %)
|
0 (0.0 %)
|
hiveNo
|
1 - 2
|
12.1
|
8
|
8.0
|
8.0
|
20.0
|
20
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
2 (0.3 %)
|
0 (0.0 %)
|
sampY
|
4 - 4
|
2,019.0
|
2,018
|
2,019.0
|
2,019.0
|
2,019.0
|
2,019
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
2 (0.3 %)
|
37 (4.8 %)
|
sampM
|
1 - 1
|
5.4
|
3
|
4.0
|
5.0
|
7.0
|
8
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
6 (0.8 %)
|
82 (10.7 %)
|
sampD
|
1 - 2
|
14.0
|
2
|
9.0
|
11.0
|
20.0
|
30
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
13 (1.7 %)
|
297 (38.6 %)
|
sampT
|
2 - 2
|
12.7
|
11
|
12.0
|
12.0
|
13.0
|
15
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
5 (0.7 %)
|
149 (19.4 %)
|
waggleDuration
|
12 - 12
|
1.46051300000
|
0.2090000000
|
1.05550000000
|
1.39200000000
|
1.80000000000
|
6.1380000000
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
399 (51.9 %)
|
383 (49.8 %)
|
waggleLength
|
0 - 0
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
769
|
769 (100.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.1 %)
|
n/a
|
waggleOrientation
|
12 - 13
|
-0.52104522000
|
-6.2133866670
|
-2.25115957000
|
-0.04360624000
|
1.59920471000
|
5.9164443800
|
769
|
0 (0.0 %)
|
2 (0.3 %)
|
0 (0.0 %)
|
665 (86.5 %)
|
384 (49.9 %)
|
waggleDirection
|
12 - 13
|
3.37559357000
|
-3.1146163940
|
0.60469758000
|
3.14302945000
|
5.30914854000
|
9.1990213390
|
769
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
752 (97.8 %)
|
384 (49.9 %)
|
pollenColor
|
0 - 0
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
769
|
769 (100.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.1 %)
|
n/a
|
pollenAbundance
|
0 - 0
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
769
|
769 (100.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.1 %)
|
n/a
|
observationId | dancerId | siteNo | hiveNo | sampY | sampM | sampD | sampT | waggleDuration | waggleLength | waggleOrientation | waggleDirection | pollenColor | pollenAbundance |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1000
|
95352
|
2
|
8
|
2019
|
5
|
15
|
13
|
2.1500000000
|
|
-0.1528245470
|
3.2673008440
|
|
|
1001
|
33959
|
2
|
8
|
2019
|
5
|
15
|
13
|
2.3200000000
|
|
-0.0305840080
|
3.1593344210
|
|
|
1002
|
25554
|
2
|
8
|
2019
|
5
|
15
|
13
|
2.2500000000
|
|
-0.0049458330
|
3.1622505190
|
|
|
1003
|
36914
|
2
|
8
|
2019
|
5
|
15
|
13
|
2.6000000000
|
|
-0.0102892740
|
3.0748844150
|
|
|
1004
|
43739
|
2
|
8
|
2019
|
5
|
15
|
13
|
1.8500000000
|
|
0.5559219460
|
2.8474545480
|
|
|
1005
|
91896
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.0000000000
|
|
0.5559219460
|
2.8679025170
|
|
|
1006
|
47376
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.0500000000
|
|
0.5559219460
|
2.8814537530
|
|
|
1007
|
76479
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.3500000000
|
|
-0.0019299810
|
3.4460561280
|
|
|
1008
|
36546
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.2300000000
|
|
0.0069504010
|
3.4506249430
|
|
|
1009
|
49632
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.3000000000
|
|
0.1908611630
|
3.2667143340
|
|
|
1010
|
36878
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.1000000000
|
|
0.1456956660
|
3.3252580170
|
|
|
1011
|
74382
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.0000000000
|
|
0.0342751790
|
3.4366786480
|
|
|
1012
|
47972
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.5000000000
|
|
0.6608782250
|
2.8167374130
|
|
|
1013
|
94288
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.2000000000
|
|
0.6406263170
|
2.8369894030
|
|
|
1014
|
21162
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.2500000000
|
|
0.5802130510
|
2.9238626960
|
|
|
1015
|
37999
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.3000000000
|
|
0.5947291530
|
2.9093465810
|
|
|
1016
|
78638
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.2600000000
|
|
0.5900414130
|
2.9140343670
|
|
|
1017
|
79558
|
2
|
8
|
2019
|
5
|
15
|
14
|
2.1200000000
|
|
0.6052094430
|
2.9315009120
|
|
|
1018
|
13311
|
1
|
8
|
2019
|
7
|
10
|
13
|
0.8000000000
|
|
2.9460569070
|
-0.0558029520
|
|
|
1019
|
75328
|
1
|
8
|
2019
|
7
|
10
|
13
|
0.8300000000
|
|
-0.5173107330
|
3.5596144200
|
|
|
1020
|
87622
|
1
|
8
|
2019
|
7
|
10
|
13
|
2.0000000000
|
|
-2.6018371110
|
5.6364221570
|
|
|
1021
|
66532
|
1
|
8
|
2019
|
7
|
10
|
13
|
1.6000000000
|
|
-0.9904167710
|
4.0250020030
|
|
|
1022
|
98435
|
1
|
8
|
2019
|
7
|
10
|
13
|
0.3500000000
|
|
-0.9904167710
|
4.0250020030
|
|
|
1023
|
33863
|
1
|
8
|
2019
|
7
|
10
|
13
|
0.5200000000
|
|
-0.4584638370
|
3.4930491450
|
|
|
- observationId
- dancerId
- siteNo
- hiveNo
- sampY
- sampM
- sampD
- sampT
- waggleDuration
- waggleLength
- waggleOrientation
- waggleDirection
- pollenColor
- pollenAbundance
Continuous Data Distribution
Outliers
Completeness
Uniqueness
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
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
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable