table_v_colony_inspection
[UID:MUSTB76.TBLVC136.0]
Data in this table contains information obtained during the fortnightly inspections.
Download
-
Licence
This file contains dataset licencing information.
Properties
Dataset
Unique Identifier
[MUSTB76.TBLVC136.0]
URI
https://app.pollinatorhub.eu/dataset-discovery/parts/MUSTB76.TBLVC136.0
Columns
16
Rows
435,964
Data points
6,975,424
Data providers
Data profiling
| Column description | Data type | Descriptor | ||
|---|---|---|---|---|
|
resId
|
Identification code of an analytical result (a row of the data table) in the transmitted file.
|
String |
Default unit
|
|
|
siteNo
|
Identifier for the site.
|
Integer |
Default unit
|
|
|
hiveNo
|
Identifier for the hive.
|
Integer |
Default unit
|
|
|
frameNo
|
Identifier for the frame to be used for comb observations.
|
String |
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
|
|
|
paramText
|
Observation made at the hive. One of the following objects: Colony weight / Number of adult bees / Number of beebread cells / Number of cells honey / Number of cells nectar / Number of departing foragers / Number of eggs / Number of larvae / Number of other cells / Number of returning foragers / Number of worker brood cells
|
String |
Default unit
|
|
|
anMethText
|
Methods used to take the observations listed above. One of the following objects: Automatic recording / Comb inspectionVideo and image analysis
|
String |
Default unit
|
|
|
resVal
|
Quantitative assessment of the observation. This value must be complete for all quantative assessments e.g. number of the different types of bees.
|
Decimal (float) |
Default unit
|
|
|
resUnit
|
Unit of measurement for the values reported. This must be reported for all quantative assessments.
|
String |
Default unit
|
|
|
resUnit_desc
|
Content of column in efsa dcf catalogue: unit_term.termExtendedName
|
String |
Default unit
|
|
|
resValUncert
|
Indicate the expanded uncertainty value (usually 95% confidence interval) associated with the measurement expressed in the unit reported in the field 'Result unit'.
|
n/a
|
n/a
|
Default unit
|
|
resValUncertSD
|
Standard deviation for the uncertainty of measurement.
|
n/a
|
n/a
|
Default unit
|
|
resQualValue
|
This value must be completed for the qualitative clinical sign observations. For each sign absence or presence should be indicated.
|
n/a
|
n/a
|
Default unit
|
| Length | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct | Outliers | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
resId
|
3 - 8
|
n/a
|
CA1
|
n/a
|
n/a
|
n/a
|
NAB999
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
435,964 (100.0 %)
|
n/a
|
|
siteNo
|
1 - 3
|
17.5
|
1
|
2.0
|
4.0
|
6.0
|
340
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
7 (0.0 %)
|
89,847 (20.6 %)
|
|
hiveNo
|
1 - 2
|
5.5
|
1
|
2.0
|
4.0
|
8.0
|
22
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
18 (0.0 %)
|
135,709 (31.1 %)
|
|
frameNo
|
0 - 9
|
n/a
|
59a
|
n/a
|
n/a
|
n/a
|
frame 9B
|
435,964
|
284,722 (65.3 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
104 (0.0 %)
|
n/a
|
|
sampY
|
4 - 4
|
2,019.5
|
1,970
|
2,019.0
|
2,019.0
|
2,020.0
|
2,020
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
3 (0.0 %)
|
4 (0.0 %)
|
|
sampM
|
1 - 2
|
6.7
|
1
|
5.0
|
7.0
|
8.0
|
12
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
12 (0.0 %)
|
158,175 (36.3 %)
|
|
sampD
|
1 - 2
|
16.0
|
1
|
9.0
|
16.0
|
24.0
|
31
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
31 (0.0 %)
|
205,493 (47.1 %)
|
|
sampT
|
1 - 2
|
11.8
|
0
|
8.0
|
12.0
|
16.0
|
23
|
435,964
|
0 (0.0 %)
|
11,723 (2.7 %)
|
0 (0.0 %)
|
24 (0.0 %)
|
191,632 (44.0 %)
|
|
paramText
|
13 - 28
|
n/a
|
Colony weight
|
n/a
|
n/a
|
n/a
|
Number of worker brood cells
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
11 (0.0 %)
|
n/a
|
|
anMethText
|
15 - 24
|
n/a
|
Automatic recording
|
n/a
|
n/a
|
n/a
|
Video and image analysis
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
3 (0.0 %)
|
n/a
|
|
resVal
|
12 - 16
|
251.61278683000
|
0.0000000000
|
26.80000000000
|
37.80000000000
|
73.00000000000
|
12,438.0000000000
|
435,964
|
0 (0.0 %)
|
32,328 (7.4 %)
|
0 (0.0 %)
|
5,454 (1.3 %)
|
217,435 (49.9 %)
|
|
resUnit
|
5 - 5
|
n/a
|
G167A
|
n/a
|
n/a
|
n/a
|
G293A
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
3 (0.0 %)
|
n/a
|
|
resUnit_desc
|
6 - 9
|
n/a
|
Kilogram
|
n/a
|
n/a
|
n/a
|
comb cell
|
435,964
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
3 (0.0 %)
|
n/a
|
|
resValUncert
|
0 - 0
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
435,964
|
435,964 (100.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.0 %)
|
n/a
|
|
resValUncertSD
|
0 - 0
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
435,964
|
435,964 (100.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.0 %)
|
n/a
|
|
resQualValue
|
0 - 0
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
435,964
|
435,964 (100.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.0 %)
|
n/a
|
| resId | siteNo | hiveNo | frameNo | sampY | sampM | sampD | sampT | paramText | anMethText | resVal | resUnit | resUnit_desc | resValUncert | resValUncertSD | resQualValue |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CA1
|
1
|
1
|
frame 1A
|
2019
|
4
|
25
|
13
|
Number of worker brood cells
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA10
|
1
|
1
|
frame 7B
|
2019
|
4
|
25
|
13
|
Number of beebread cells
|
Video and image analysis
|
135.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100
|
1
|
1
|
frame 1B
|
2019
|
4
|
25
|
13
|
Number of cells honey
|
Video and image analysis
|
11.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA1000
|
6
|
3
|
frame 6A
|
2019
|
3
|
9
|
12
|
Number of cells nectar
|
Video and image analysis
|
95.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA10000
|
6
|
3
|
frame 3A
|
2019
|
6
|
27
|
12
|
Number of eggs
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100000
|
6
|
16
|
frame 2A
|
2020
|
7
|
29
|
12
|
Number of other cells
|
Video and image analysis
|
1157.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100001
|
6
|
16
|
frame 2A
|
2020
|
7
|
29
|
12
|
Number of cells honey
|
Video and image analysis
|
1009.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100002
|
6
|
16
|
frame 2A
|
2020
|
7
|
29
|
12
|
Number of cells nectar
|
Video and image analysis
|
183.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100003
|
6
|
16
|
frame 2A
|
2020
|
7
|
29
|
12
|
Number of beebread cells
|
Video and image analysis
|
841.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100004
|
6
|
16
|
frame 2A
|
2020
|
7
|
29
|
12
|
Number of larvae
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100005
|
6
|
16
|
frame 2A
|
2020
|
7
|
29
|
12
|
Number of eggs
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100006
|
6
|
16
|
frame 1A
|
2020
|
7
|
29
|
12
|
Number of eggs
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100007
|
6
|
16
|
frame 1A
|
2020
|
7
|
29
|
12
|
Number of larvae
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100008
|
6
|
16
|
frame 1A
|
2020
|
7
|
29
|
12
|
Number of beebread cells
|
Video and image analysis
|
491.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100009
|
6
|
16
|
frame 1A
|
2020
|
7
|
29
|
12
|
Number of cells nectar
|
Video and image analysis
|
119.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA10001
|
6
|
3
|
frame 3A
|
2019
|
6
|
27
|
12
|
Number of worker brood cells
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100010
|
6
|
16
|
frame 1A
|
2020
|
7
|
29
|
12
|
Number of cells honey
|
Video and image analysis
|
1114.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100011
|
6
|
16
|
frame 1A
|
2020
|
7
|
29
|
12
|
Number of other cells
|
Video and image analysis
|
1417.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100012
|
6
|
16
|
frame 3A
|
2020
|
7
|
29
|
12
|
Number of cells nectar
|
Video and image analysis
|
85.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100013
|
6
|
16
|
frame 1B
|
2020
|
7
|
29
|
12
|
Number of worker brood cells
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100014
|
6
|
16
|
frame 1B
|
2020
|
7
|
29
|
12
|
Number of larvae
|
Video and image analysis
|
0.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100015
|
6
|
16
|
frame 1B
|
2020
|
7
|
29
|
12
|
Number of beebread cells
|
Video and image analysis
|
294.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100016
|
6
|
16
|
frame 1B
|
2020
|
7
|
29
|
12
|
Number of cells nectar
|
Video and image analysis
|
7.0000000000
|
G293A
|
comb cell
|
|
|
|
|
CA100017
|
6
|
16
|
frame 1B
|
2020
|
7
|
29
|
12
|
Number of cells honey
|
Video and image analysis
|
74.0000000000
|
G293A
|
comb cell
|
|
|
|
- resId
- siteNo
- hiveNo
- frameNo
- sampY
- sampM
- sampD
- sampT
- paramText
- anMethText
- resVal
- resUnit
- resUnit_desc
- resValUncert
- resValUncertSD
- resQualValue
Data Distribution Top 20
Data Distribution Bottom 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
Data Distribution Bottom 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
Data Distribution Bottom 20
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
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable