EU Pollinator Hub

, ,
• •
Dataset Report
Unique identifier: NNICA10.0.0
Title: Neonic
Long title: Development of bee colonies in areas exposed to high levels of neonicotinoid pesticides.
Status: Quality Validated
Current Version: v. 1.0
Published: 2023-12-18
Reviewed by:
Citation proposal:
Styrian Beekeepers Association (Steirischer Landesverband für Bienenzucht) 2023 Report of dataset Neonic, v. 1.0 [NNICA10.0.0]. EU Pollinator Hub. [2025-07-15] app.pollinatorhub.eu
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
Under evaluation

Document history

Release

Version v. 1.0 released on 2023-12-18.

Revision

Table 1. List of revisions made to the document. Identifier of revision (No); date of revision (Date); description of revision (Description); reason for revision (Reason).
No Date Description Reason
1 2023-12-18 00:12:00 Initial release. n/a

Abbreviations

No abbreviations.

Executive summary

Data overview:

n/a

Data value:

n/a

Data description:

n/a

interactions.single.section-about.data-overview-application:

n/a

Unresolved issues:

n/a

Introduction

n/a

Material and methods

Data acquisition

n/a
Table 2. List of raw data and metadata files included in the dataset. Identifier of table row (No); name of the file (File); the type of the file (Type); file contains data (D); file contains metadata (M); date of upload of the file to the EU Pollinator Hub (Arrival); number of data points contained within the file (if applicable); uploaded file size.
No File Type D M Arrival Data points File size
1 NEONIC_Calib_PREP_MR_231230.csv CSV - Comma seperated values Yes No 2024-01-01 16:01:42 3,040 13.91 KiB
2 NEONIC_Colony_PREP_MR_231230.csv CSV - Comma seperated values Yes No 2024-01-01 16:01:55 226,800 884.59 KiB
3 NEONIC_Hives_PREP_MR_231230.csv CSV - Comma seperated values Yes No 2024-01-01 17:01:16 480 2.55 KiB
4 NEONIC_Apiary_PREP_MR_231230.csv CSV - Comma seperated values Yes No 2024-01-11 09:01:54 30 249.00 B
5 NEONIC_Crops_PREP_MR_231230.csv CSV - Comma seperated values Yes No 2024-01-11 09:01:24 264 1.54 KiB
6 final report NEONIC.pdf Miscellaneous No Yes 2024-01-11 09:01:00 n/a 1.52 MiB
7 final report NEONIC en.pdf Miscellaneous No Yes 2024-01-11 09:01:45 n/a 3.07 MiB

Data preparation

n/a

Data validation

n/a

Data analysis

n/a

Data description

Dataset

Table 3. Summary of tables belonging to the dataset. Table row identifier (No); name of the table (Table); description of the table (Description).
No Table Description
1 Calibration The table contains the results from the calibration of operators for the estimation of the number of bees on frames.…
2 Colony The table contains the results from the assessments of colony size. The number of adult bees in a colony was…
3 Hives The table contains information in the hives used in the study.
4 Apiary The table contains information on the position of the apiaries; The geographical coordinates were blurred.
5 Crops The table contains information in the crops and the usage of clothianidin as active ingredient in the plant protection products…
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid NNICA10.0.0
Title Neonic
Long title Development of bee colonies in areas exposed to high levels of neonicotinoid pesticides.
Target IRI https://app.pollinatorhub.eu/dataset-discovery/NNICA10.0.0
interactions.single.section-details.licence CC BY-SA 4.0
DOI n/a
Created 2023-01-26
Published 2023-12-18
Contact n/a
Keywords Apis mellifera, Austria, colony development
Data collection years 2012-2013
Regions, the data was collected in Österreich
Abstract

This dataset contains data on regular assessemnts of colony development in colonies exposed to different levels of Clothinanidin as a consequence of corn production.
Table 5. Standardised metadata of the data provider Styrian Beekeepers Association (Steirischer Landesverband für Bienenzucht). Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Styrian Beekeepers Association (Steirischer Landesverband für Bienenzucht)
Url
Acronym StLVB
Contact n/a
Description

The Styrian Beekeepers Association (Steirischer Landesverband für Bienenzucht) is the biggest beekeeping association in the region of Styria.

Tables

Calibration

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier NNICA10.CLBRT171.0
Name Calibration
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/NNICA10.CLBRT171.0
Table Type File
Licence CC BY-SA 4.0
Description

The table contains the results from the calibration of operators for the estimation of the number of bees on frames. The persons who estimated colony size had to carry out a calibration immediately before the start of the estimation if the last calibration was more than a week ago. For the calibration, 20 photos of frames with a known number (578-1278) of bees were presented to the persons carrying out the estimation in order to determine measurement accuracy.

The table contains the results from the calibration of operators for the estimation of the number of bees on frames. The persons who estimated colony size had to carry out a calibration immediately before the start of the estimation if the last calibration was more than a week ago. For the calibration, 20 photos of frames with a known number (578-1278) of bees were presented to the persons carrying out the estimation in order to determine measurement accuracy.

Metadata

n/a
Table 7. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
id

Identifier of the record.

 Integer number Integer [0.0.NTGER313]

n/a
operator

Unique sequence of letters identifying the person who carried out the assessments on the colonies.

 String Text [0.0.TEXTA315]

n/a
date

Date at which estimates were performed.

 Date iso-8601:calendarDate [0.0.DATEA317]

n/a
assessment

Identifier at which the data collection at the individual locations should be compared, even if this did not take place at the same time.

 Integer number Integer [0.0.NTGER313]

n/a
image

Identifier of image used for calibration.

 Integer number Integer [0.0.NTGER313]

n/a
value

Actual number of bees on the image.

 Integer number Integer [0.0.NTGER313]

no.
estimate

Number of bees on the image, estimated by the operator.

 Integer number Integer [0.0.NTGER313]

no.
accuracy

Accuracy of the estimate value expressed in percent of actual value.

 Decimal number DecimalNumber [0.0.DCMLN314]

%

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 8. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 3 190.5 1 95.25 190.5 285.75 380 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 380 ( 100.0% )
operator 2 - 2 n/a BI n/a n/a n/a UL 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 1.1% )
date 10 - 10 n/a 2012-04-02 n/a n/a n/a 2013-04-16 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 3.4% )
assessment 1 - 1 4.4 1 2 4 6 8 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 2.1% )
image 1 - 2 10.5 1 5.25 10.5 15.75 20 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 20 ( 5.3% )
value 3 - 4 909.5 578 690.75 945 1,055 1,278 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 20 ( 5.3% )
estimate 3 - 4 882.4 300 680 900 1,100 1,350 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 91 ( 23.9% )
accuracy 2 - 5 95.84 51.9 90 99.25 104.9 117.6 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 189 ( 49.7% )

Quality measures

Table 9. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1
operator
100.00%
1.05%
BI KO
date
100.00%
3.42%
2012-04-02 2012-04-04
assessment
100.00%
2.11%
1 2
image
100.00%
5.26%
1 1
value
100.00%
5.26%
578 578
estimate
100.00%
23.95%
1200 860
accuracy
100.00%
49.74%
103 103.8

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Colony

Table 10. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier NNICA10.CLONY172.0
Name Colony
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/NNICA10.CLONY172.0
Table Type File
Licence CC BY-SA 4.0
Description

The table contains the results from the assessments of colony size. The number of adult bees in a colony was determined by estimation. The estimation was carried out before the start of flight (<12°C) in all frames of a colony by 2 persons, whereby one person estimated the number of adult bees and a second person recorded the data in writing. The estimation was always started in the bottom hive box. The colony was opened accompanied by a few puffs of smoke. The number of bees on the bottom board and on the frame walls was estimated to the nearest 50 bees. Then a frame was removed from the box and the number of bees sitting on each side of the frame was estimated to the nearest 50 bees. The geometric shape of the brood nest (elliptical or rectangular) was noted and its maximum horizontal and vertical extension was measured to the nearest 5 mm using a rule. This process was carried out in all frames of the hive.

The table contains the results from the assessments of colony size. The number of adult bees in a colony was determined by estimation. The estimation was carried out before the start of flight (<12°C) in all frames of a colony by 2 persons, whereby one person estimated the number of adult bees and a second person recorded the data in writing. The estimation was always started in the bottom hive box. The colony was opened accompanied by a few puffs of smoke. The number of bees on the bottom board and on the frame walls was estimated to the nearest 50 bees. Then a frame was removed from the box and the number of bees sitting on each side of the frame was estimated to the nearest 50 bees. The geometric shape of the brood nest (elliptical or rectangular) was noted and its maximum horizontal and vertical extension was measured to the nearest 5 mm using a rule. This process was carried out in all frames of the hive.

Metadata

n/a
Table 11. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
id

Identifier of the record.

 Integer number pms:recordID [0.0.RCRDD344]

n/a
assessment

Identifier at which the data collection at the individual locations should be compared, even if this did not take place at the same time.

 Integer number Integer [0.0.NTGER313]

n/a
date

Date at which colonies were assessed.

 Date iso-8601:calendarDate [0.0.DATEA317]

n/a
operator

Unique sequence of letters identifying the person who carried out the assessments on the colonies.

 String Text [0.0.TEXTA315]

n/a
apiary

Unique identifier of the apiary.

 Decimal number pms:apiaryID [0.0.PRYID342]

n/a
hive

Unique identifier of the hive.

 String pms:colonyID [0.0.CLNYD362]

n/a
box

Consecutive number of the boxes of a hive, starting with the bottom box, on which the assessemnts were carried out.

 Integer number Integer [0.0.NTGER313]

n/a
frame

Consecutive number of frames in a hive box, starting either with the leftmost or with the rightmost frame, on which the assessemnts were carried out.

 Integer number Integer [0.0.NTGER313]

n/a
bees_A

Estimated number of bees on one of the two sides of a frame.

 Integer number Integer [0.0.NTGER313]

no.
bees_B

Estimated number of bees on the other of the two sides of a frame.

 Integer number Integer [0.0.NTGER313]

no.
brood_A_x

Maximum horizontal extension of the brood nest in cm on one of the two sides of a frame.

 Decimal number DecimalNumber [0.0.DCMLN314]

cm
brood_A_y

Maximum vertical extension of the brood nest in cm on one of the two sides of a frame.

 Decimal number DecimalNumber [0.0.DCMLN314]

cm
brood_A_shape

Shape of the brood nest on one of the two sides of a frame (rectangle: 0; ellipse: 1), based on which the formula for a rectangle (area=brood_A_x x brood_A_y) or an ellipse (area=pi x (brood_A_x/2) x (brood_A_y/2) ) is used to calculate the area of the brood nest.

 Integer number Integer [0.0.NTGER313]

n/a
brood_B_x

Maximum horizontal extension of the brood nest in cm on the other of the two sides of a frame.

 Decimal number DecimalNumber [0.0.DCMLN314]

cm
brood_B_y

Maximum vertical extension of the brood nest in cm on the other of the two sides of a frame.

 Decimal number DecimalNumber [0.0.DCMLN314]

cm
brood_B_shape

Shape of the brood nest on the other of the two sides of a frame (rectangle: 0; elipse: 1), based on which the formula for a rectangle (area=brood_B_x x brood_B_y) or an ellipse (area=pi x (brood_B_x/2) x (brood_B_y/2) ) is used to calculate the area of the brood nest.

 Integer number Integer [0.0.NTGER313]

n/a
bees_extra

Estimated number of bees on any other part of the hive box.

 Integer number Integer [0.0.NTGER313]

no.
bees_n

Total number of bees estimated on the entire frame, including bees on any other part of the hive box.

 Integer number Integer [0.0.NTGER313]

no.
brood_cm2

Total area of brood cells estimated on the entire frame in cm2.

 Decimal number DecimalNumber [0.0.DCMLN314]

cm2
brood_n

Total number of brood cells estimated on the entire frame, assuming that there are 4 brood cells in one cm2.

 Integer number Integer [0.0.NTGER313]

no.

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 12. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 5 5,670.5 1 2,835.25 5,670.5 8,505.75 11,340 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 11,340 ( 100.0% )
assessment 1 - 1 4.4 1 3 4 6 8 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 0.1% )
date 10 - 10 n/a 2012-04-02 n/a n/a n/a 2013-04-17 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 24 ( 0.2% )
operator 2 - 2 n/a BI n/a n/a n/a UL 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.0% )
apiary 3 - 3 2.20 1.1 1.2 2.2 3.1 3.2 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 0.1% )
hive 5 - 8 n/a 1.1-10Gr n/a n/a n/a 3.2-8 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.5% )
box 1 - 1 1.8 1 1 2 2 4 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.0% )
frame 1 - 2 5.5 1 3 5.5 8 10 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 10 ( 0.1% )
bees_A 1 - 4 325.0 0 100 300 500 1,500 11,340 0 ( 0.0% ) 1,123 ( 9.9% ) 0 ( 0.0% ) 27 ( 0.2% )
bees_B 1 - 4 339.3 0 100 300 500 1,550 11,340 0 ( 0.0% ) 1,666 ( 14.7% ) 0 ( 0.0% ) 31 ( 0.3% )
brood_A_x 3 - 4 5.55 0.0 0 0 14 38.0 11,340 1 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 69 ( 0.6% )
brood_A_y 3 - 4 7.70 0.0 0 0 16 39.5 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 70 ( 0.6% )
brood_A_shape 1 - 1 0.2 0 0 0 0 1 11,340 0 ( 0.0% ) 8,947 ( 78.9% ) 0 ( 0.0% ) 2 ( 0.0% )
brood_B_x 3 - 4 5.28 0.0 0 0 13 38.0 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 64 ( 0.6% )
brood_B_y 3 - 4 7.04 0.0 0 0 14.5 39.0 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 68 ( 0.6% )
brood_B_shape 1 - 1 0.2 0 0 0 0 1 11,340 0 ( 0.0% ) 9,156 ( 80.7% ) 0 ( 0.0% ) 2 ( 0.0% )
bees_extra 1 - 4 45.1 0 0 0 0 9,000 11,340 1 ( 0.0% ) 10,597 ( 93.4% ) 0 ( 0.0% ) 46 ( 0.4% )
bees_n 1 - 4 709.4 0 250 650 1,050 9,950 11,340 0 ( 0.0% ) 923 ( 8.1% ) 0 ( 0.0% ) 104 ( 0.9% )
brood_cm2 3 - 6 224.07 0.0 0 0 384.075 7,200.0 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2,150 ( 19.0% )
brood_n 1 - 5 896.3 0 0 0 1,536 28,800 11,340 0 ( 0.0% ) 7,377 ( 65.1% ) 0 ( 0.0% ) 1,962 ( 17.3% )

Quality measures

Table 13. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1
assessment
100.00%
0.07%
4 1
date
100.00%
0.21%
2013-04-16 2013-04-07
operator
100.00%
0.04%
BI KO
apiary
100.00%
0.05%
2.1 1.2
hive
100.00%
0.53%
2.1-86 1.2-Z8
box
100.00%
0.04%
1 4
frame
100.00%
0.09%
1 1
bees_A
100.00%
0.24%
50 1300
bees_B
100.00%
0.27%
0 30
brood_A_x
99.99%
0.61%
0.0 5.5
brood_A_y
100.00%
0.62%
0.0 39.5
brood_A_shape
100.00%
0.02%
0 1
brood_B_x
100.00%
0.56%
0.0 37.5
brood_B_y
100.00%
0.60%
0.0 18.1
brood_B_shape
100.00%
0.02%
0 1
bees_extra
99.99%
0.41%
0 2750
bees_n
100.00%
0.92%
0 5150
brood_cm2
100.00%
18.96%
0.0 764.2
brood_n
100.00%
17.30%
0 3057

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Hives

Table 14. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier NNICA10.HIVES175.0
Name Hives
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/NNICA10.HIVES175.0
Table Type File
Licence CC BY-SA 4.0
Description

The table contains information in the hives used in the study.

The table contains information in the hives used in the study.

Metadata

n/a
Table 15. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
apiary

Unique identifier of the apiary.

 Decimal number pms:apiaryID [0.0.PRYID342]

n/a
hive

Unique identifier of the hive.

 String pms:colonyID [0.0.CLNYD362]

n/a
owner

Unique sequence of letters identifying the owner of the hive.

 String Text [0.0.TEXTA315]

n/a
frame_type

Type of frame used in the hive.

 String Text [0.0.TEXTA315]

n/a
frame_inner_width

Frame inner width.

 Integer number Integer [0.0.NTGER313]

mm
frame_inner_height

Frame inner height.

 Integer number Integer [0.0.NTGER313]

mm
box_isolated

Information on additional insulation of the hive boxes (0: no, only wooden boxes; 1: yes, polystyrene insulation)

 Integer number Integer [0.0.NTGER313]

n/a
bottomboard_height

Information on the inner height of the bottom boards: shallow, approximately 2 cm between bottom and frames; deep, more than approximately 2 cm between bottom and frames.

 String Text [0.0.TEXTA315]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 16. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
apiary 3 - 3 2.15 1.1 1.2 2.15 3.1 3.2 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 10.0% )
hive 5 - 8 n/a 1.1-10Gr n/a n/a n/a 3.2-8 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 100.0% )
owner 2 - 2 n/a FI n/a n/a n/a WO 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 10.0% )
frame_type 6 - 12 n/a Breitwabe n/a n/a n/a Zander 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 5.0% )
frame_inner_width 3 - 3 378.3 350 350 375 400 420 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 5.0% )
frame_inner_height 3 - 3 203.3 200 200 200 200 220 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 3.3% )
box_isolated 1 - 1 0.2 0 0 0 0 1 60 0 ( 0.0% ) 50 ( 83.3% ) 0 ( 0.0% ) 2 ( 3.3% )
bottomboard_height 4 - 7 n/a deep n/a n/a n/a shallow 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 3.3% )

Quality measures

Table 17. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
apiary
100.00%
10.00%
1.1 1.1
hive
100.00%
100.00%
1.1-Z9 1.1-Z9
owner
100.00%
10.00%
WO WO
frame_type
100.00%
5.00%
Einheitsmass Breitwabe
frame_inner_width
100.00%
5.00%
350 420
frame_inner_height
100.00%
3.33%
200 220
box_isolated
100.00%
3.33%
0 1
bottomboard_height
100.00%
3.33%
deep shallow

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Apiary

Table 18. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier NNICA10.PIARY190.0
Name Apiary
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/NNICA10.PIARY190.0
Table Type File
Licence CC BY-SA 4.0
Description

The table contains information on the position of the apiaries; The geographical coordinates were blurred.

The table contains information on the position of the apiaries; The geographical coordinates were blurred.

Metadata

n/a
Table 19. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
apiary

Identifier of the record.

 String pms:apiaryID [0.0.PRYID342]

n/a
elevation

Height above sea level.

 Decimal number pms:heightAboveMeanSeaLevel [0.0.HGHTB393]

m
wgs84_e

Longitude coordinate of geographical position.

 Decimal number dwc:decimalLongitude [0.0.LNGTD332]

°
wgs84_n

Latitude coordinate of geographical position.

 Decimal number dwc:decimalLatitude [0.0.LTTDE333]

°
lau

Code of teh local administrative unit (LAU).

 String eurostat:lauCode [0.0.LCODE73]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 20. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
apiary 3 - 3 2.15 1.1 1.175 2.15 3.125 3.2 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 100.0% )
elevation 3 - 3 267.2 203 221.75 253.5 332.25 333 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 100.0% )
wgs84_e 9 - 9 15.6716667 15.320000 15.3575 15.685 15.9625 16.030000 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 100.0% )
wgs84_n 9 - 9 46.7933333 46.680000 46.695 46.74 46.95 46.950000 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5 ( 83.3% )
lau 5 - 5 61,300.2 60,318 60,574.5 61,060.5 62,338.5 62,376 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 100.0% )

Quality measures

Table 21. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
apiary
100.00%
100.00%
1.1 1.1
elevation
100.00%
100.00%
203 203
wgs84_e
100.00%
100.00%
16.030000 16.030000
wgs84_n
100.00%
83.33%
46.950000 46.680000
lau
100.00%
100.00%
62376 62376

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Crops

Table 22. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier NNICA10.CROPS191.0
Name Crops
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/NNICA10.CROPS191.0
Table Type File
Licence CC BY-SA 4.0
Description

The table contains information in the crops and the usage of clothianidin as active ingredient in the plant protection products applied in the immediate surroundings (1000 m) of each apiary.

The table contains information in the crops and the usage of clothianidin as active ingredient in the plant protection products applied in the immediate surroundings (1000 m) of each apiary.

Metadata

n/a
Table 23. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
apiary

Unique identifier of the apiary.

 String pms:apiaryID [0.0.PRYID342]

n/a
crop

Type of crop.

 String Text [0.0.TEXTA315]

n/a
clothianidin

Information on the usage of clothianidin as active ingredient in the plant protection products.

 String Text [0.0.TEXTA315]

n/a
area_ha

Area of crop cultivated with the specified clothianidin treatment in the immediate surroundings (1000 m) of each apiary.

 Decimal number DecimalNumber [0.0.DCMLN314]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 24. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
apiary 3 - 3 2.15 1.1 1.2 2.15 3.1 3.2 66 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 9.1% )
crop 4 - 29 n/a cereals n/a n/a n/a unknown 66 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 9 ( 13.6% )
clothianidin 2 - 7 n/a no n/a n/a n/a yes 66 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 4.5% )
area_ha 1 - 10 26.3820059 0 1.0775 8.295 27.2276 151.72 66 0 ( 0.0% ) 11 ( 16.7% ) 0 ( 0.0% ) 55 ( 83.3% )

Quality measures

Table 25. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
apiary
100.00%
9.09%
1.1 1.1
crop
100.00%
13.64%
corn cereals
clothianidin
100.00%
4.55%
no yes
area_ha
100.00%
83.33%
0 75.98645

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

References

There are no sources in the current document.

Annex 1: Table column reports

Table: Calibration

Column: id

Table 26. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name id
Description

Identifier of the record.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 27. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 3 190.5 1 95.25 190.5 285.75 380 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 380 ( 100.0% )
Table 28. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 1. Distribution of values in the column.

Outliers

Figure 2. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 3. Visualization of completeness of the data in the column.

Uniqueness

Figure 4. Visualization of uniqueness of the data in the column.

Column: operator

Table 29. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name operator
Description

Unique sequence of letters identifying the person who carried out the assessments on the colonies.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 30. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
operator 2 - 2 n/a BI n/a n/a n/a UL 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 1.1% )
Table 31. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
operator
100.00%
1.05%
BI KO

Data Distribution Top 20

Figure 5. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 6. Visualization of completeness of the data in the column.

Uniqueness

Figure 7. Visualization of uniqueness of the data in the column.

Column: date

Table 32. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name date
Description

Date at which estimates were performed.
Data type Date
Descriptor iso-8601:calendarDate [UID:0.0.DATEA317]
Descriptor description

particular calendar day [...] represented by its calendar year [...], its calendar month [...] and its calendar day of month [...]
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DATEA317
Unit

n/a
Table 33. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
date 10 - 10 n/a 2012-04-02 n/a n/a n/a 2013-04-16 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 3.4% )
Table 34. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
date
100.00%
3.42%
2012-04-02 2012-04-04

Data Distribution Top 20

Figure 8. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 9. Visualization of completeness of the data in the column.

Uniqueness

Figure 10. Visualization of uniqueness of the data in the column.

Column: assessment

Table 35. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name assessment
Description

Identifier at which the data collection at the individual locations should be compared, even if this did not take place at the same time.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 36. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
assessment 1 - 1 4.4 1 2 4 6 8 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 2.1% )
Table 37. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
assessment
100.00%
2.11%
1 2

Data Distribution Top 20

Figure 11. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 12. Distribution of values in the column.

Outliers

Figure 13. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 14. Visualization of completeness of the data in the column.

Uniqueness

Figure 15. Visualization of uniqueness of the data in the column.

Column: image

Table 38. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name image
Description

Identifier of image used for calibration.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 39. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
image 1 - 2 10.5 1 5.25 10.5 15.75 20 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 20 ( 5.3% )
Table 40. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
image
100.00%
5.26%
1 1

Continuous Data Distribution

Figure 16. Distribution of values in the column.

Outliers

Figure 17. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 18. Visualization of completeness of the data in the column.

Uniqueness

Figure 19. Visualization of uniqueness of the data in the column.

Column: value

Table 41. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name value
Description

Actual number of bees on the image.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.
Table 42. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
value 3 - 4 909.5 578 690.75 945 1,055 1,278 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 20 ( 5.3% )
Table 43. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
value
100.00%
5.26%
578 578

Continuous Data Distribution

Figure 20. Distribution of values in the column.

Outliers

Figure 21. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 22. Visualization of completeness of the data in the column.

Uniqueness

Figure 23. Visualization of uniqueness of the data in the column.

Column: estimate

Table 44. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name estimate
Description

Number of bees on the image, estimated by the operator.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.
Table 45. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
estimate 3 - 4 882.4 300 680 900 1,100 1,350 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 91 ( 23.9% )
Table 46. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
estimate
100.00%
23.95%
1200 860

Continuous Data Distribution

Figure 24. Distribution of values in the column.

Outliers

Figure 25. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 26. Visualization of completeness of the data in the column.

Uniqueness

Figure 27. Visualization of uniqueness of the data in the column.

Column: accuracy

Table 47. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name accuracy
Description

Accuracy of the estimate value expressed in percent of actual value.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

%
Table 48. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
accuracy 2 - 5 95.84 51.9 90 99.25 104.9 117.6 380 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 189 ( 49.7% )
Table 49. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
accuracy
100.00%
49.74%
103 103.8

Continuous Data Distribution

Figure 28. Distribution of values in the column.

Outliers

Figure 29. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 30. Visualization of completeness of the data in the column.

Uniqueness

Figure 31. Visualization of uniqueness of the data in the column.

Table: Colony

Column: id

Table 50. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name id
Description

Identifier of the record.
Data type Integer number
Descriptor pms:recordID [UID:0.0.RCRDD344]
Descriptor description

Unique sequence of integers associated with a record within a certain table.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit

n/a
Table 51. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 5 5,670.5 1 2,835.25 5,670.5 8,505.75 11,340 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 11,340 ( 100.0% )
Table 52. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 32. Distribution of values in the column.

Outliers

Figure 33. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 34. Visualization of completeness of the data in the column.

Uniqueness

Figure 35. Visualization of uniqueness of the data in the column.

Column: assessment

Table 53. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name assessment
Description

Identifier at which the data collection at the individual locations should be compared, even if this did not take place at the same time.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 54. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
assessment 1 - 1 4.4 1 3 4 6 8 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 0.1% )
Table 55. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
assessment
100.00%
0.07%
4 1

Data Distribution Top 20

Figure 36. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 37. Distribution of values in the column.

Outliers

Figure 38. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 39. Visualization of completeness of the data in the column.

Uniqueness

Figure 40. Visualization of uniqueness of the data in the column.

Column: date

Table 56. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name date
Description

Date at which colonies were assessed.
Data type Date
Descriptor iso-8601:calendarDate [UID:0.0.DATEA317]
Descriptor description

particular calendar day [...] represented by its calendar year [...], its calendar month [...] and its calendar day of month [...]
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DATEA317
Unit

n/a
Table 57. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
date 10 - 10 n/a 2012-04-02 n/a n/a n/a 2013-04-17 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 24 ( 0.2% )
Table 58. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
date
100.00%
0.21%
2013-04-16 2013-04-07

Data Distribution Top 20

Figure 41. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 42. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 43. Visualization of completeness of the data in the column.

Uniqueness

Figure 44. Visualization of uniqueness of the data in the column.

Column: operator

Table 59. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name operator
Description

Unique sequence of letters identifying the person who carried out the assessments on the colonies.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 60. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
operator 2 - 2 n/a BI n/a n/a n/a UL 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.0% )
Table 61. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
operator
100.00%
0.04%
BI KO

Data Distribution Top 20

Figure 45. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 46. Visualization of completeness of the data in the column.

Uniqueness

Figure 47. Visualization of uniqueness of the data in the column.

Column: apiary

Table 62. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name apiary
Description

Unique identifier of the apiary.
Data type Decimal number
Descriptor pms:apiaryID [UID:0.0.PRYID342]
Descriptor description

Unique sequence of characters associated with an apiary, which is specific to a dataset or to a beekeeper.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PRYID342
Unit

n/a
Table 63. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
apiary 3 - 3 2.20 1.1 1.2 2.2 3.1 3.2 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 0.1% )
Table 64. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
apiary
100.00%
0.05%
2.1 1.2

Data Distribution Top 20

Figure 48. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 49. Distribution of values in the column.

Outliers

Figure 50. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 51. Visualization of completeness of the data in the column.

Uniqueness

Figure 52. Visualization of uniqueness of the data in the column.

Column: hive

Table 65. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name hive
Description

Unique identifier of the hive.
Data type String
Descriptor pms:colonyID [UID:0.0.CLNYD362]
Descriptor description

Unique sequence of characters associated with a colony within a certain dataset
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CLNYD362
Unit

n/a
Table 66. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
hive 5 - 8 n/a 1.1-10Gr n/a n/a n/a 3.2-8 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.5% )
Table 67. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
hive
100.00%
0.53%
2.1-86 1.2-Z8

Data Distribution Top 20

Figure 53. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 54. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 55. Visualization of completeness of the data in the column.

Uniqueness

Figure 56. Visualization of uniqueness of the data in the column.

Column: box

Table 68. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name box
Description

Consecutive number of the boxes of a hive, starting with the bottom box, on which the assessemnts were carried out.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 69. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
box 1 - 1 1.8 1 1 2 2 4 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.0% )
Table 70. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
box
100.00%
0.04%
1 4

Data Distribution Top 20

Figure 57. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 58. Distribution of values in the column.

Outliers

Figure 59. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 60. Visualization of completeness of the data in the column.

Uniqueness

Figure 61. Visualization of uniqueness of the data in the column.

Column: frame

Table 71. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name frame
Description

Consecutive number of frames in a hive box, starting either with the leftmost or with the rightmost frame, on which the assessemnts were carried out.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 72. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
frame 1 - 2 5.5 1 3 5.5 8 10 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 10 ( 0.1% )
Table 73. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
frame
100.00%
0.09%
1 1

Data Distribution Top 20

Figure 62. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 63. Distribution of values in the column.

Outliers

Figure 64. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 65. Visualization of completeness of the data in the column.

Uniqueness

Figure 66. Visualization of uniqueness of the data in the column.

Column: bees_A

Table 74. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name bees_A
Description

Estimated number of bees on one of the two sides of a frame.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.
Table 75. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
bees_A 1 - 4 325.0 0 100 300 500 1,500 11,340 0 ( 0.0% ) 1,123 ( 9.9% ) 0 ( 0.0% ) 27 ( 0.2% )
Table 76. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
bees_A
100.00%
0.24%
50 1300

Data Distribution Top 20

Figure 67. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 68. Distribution of 20 least common values, from lowest to highest.

Outliers

Figure 69. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 70. Visualization of completeness of the data in the column.

Uniqueness

Figure 71. Visualization of uniqueness of the data in the column.

Column: bees_B

Table 77. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name bees_B
Description

Estimated number of bees on the other of the two sides of a frame.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.
Table 78. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
bees_B 1 - 4 339.3 0 100 300 500 1,550 11,340 0 ( 0.0% ) 1,666 ( 14.7% ) 0 ( 0.0% ) 31 ( 0.3% )
Table 79. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
bees_B
100.00%
0.27%
0 30

Data Distribution Top 20

Figure 72. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 73. Distribution of 20 least common values, from lowest to highest.

Outliers

Figure 74. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 75. Visualization of completeness of the data in the column.

Uniqueness

Figure 76. Visualization of uniqueness of the data in the column.

Column: brood_A_x

Table 80. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name brood_A_x
Description

Maximum horizontal extension of the brood nest in cm on one of the two sides of a frame.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

cm
Table 81. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
brood_A_x 3 - 4 5.55 0.0 0 0 14 38.0 11,340 1 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 69 ( 0.6% )
Table 82. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
brood_A_x
99.99%
0.61%
0.0 5.5

Data Distribution Top 20

Figure 77. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 78. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 79. Visualization of completeness of the data in the column.

Uniqueness

Figure 80. Visualization of uniqueness of the data in the column.

Column: brood_A_y

Table 83. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name brood_A_y
Description

Maximum vertical extension of the brood nest in cm on one of the two sides of a frame.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

cm
Table 84. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
brood_A_y 3 - 4 7.70 0.0 0 0 16 39.5 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 70 ( 0.6% )
Table 85. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
brood_A_y
100.00%
0.62%
0.0 39.5

Data Distribution Top 20

Figure 81. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 82. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 83. Visualization of completeness of the data in the column.

Uniqueness

Figure 84. Visualization of uniqueness of the data in the column.

Column: brood_A_shape

Table 86. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name brood_A_shape
Description

Shape of the brood nest on one of the two sides of a frame (rectangle: 0; ellipse: 1), based on which the formula for a rectangle (area=brood_A_x x brood_A_y) or an ellipse (area=pi x (brood_A_x/2) x (brood_A_y/2) ) is used to calculate the area of the brood nest.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 87. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
brood_A_shape 1 - 1 0.2 0 0 0 0 1 11,340 0 ( 0.0% ) 8,947 ( 78.9% ) 0 ( 0.0% ) 2 ( 0.0% )
Table 88. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
brood_A_shape
100.00%
0.02%
0 1

Data Distribution Top 20

Figure 85. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 86. Distribution of values in the column.

Completeness

Figure 87. Visualization of completeness of the data in the column.

Uniqueness

Figure 88. Visualization of uniqueness of the data in the column.

Column: brood_B_x

Table 89. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name brood_B_x
Description

Maximum horizontal extension of the brood nest in cm on the other of the two sides of a frame.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

cm
Table 90. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
brood_B_x 3 - 4 5.28 0.0 0 0 13 38.0 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 64 ( 0.6% )
Table 91. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
brood_B_x
100.00%
0.56%
0.0 37.5

Data Distribution Top 20

Figure 89. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 90. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 91. Visualization of completeness of the data in the column.

Uniqueness

Figure 92. Visualization of uniqueness of the data in the column.

Column: brood_B_y

Table 92. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name brood_B_y
Description

Maximum vertical extension of the brood nest in cm on the other of the two sides of a frame.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

cm
Table 93. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
brood_B_y 3 - 4 7.04 0.0 0 0 14.5 39.0 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 68 ( 0.6% )
Table 94. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
brood_B_y
100.00%
0.60%
0.0 18.1

Data Distribution Top 20

Figure 93. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 94. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 95. Visualization of completeness of the data in the column.

Uniqueness

Figure 96. Visualization of uniqueness of the data in the column.

Column: brood_B_shape

Table 95. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name brood_B_shape
Description

Shape of the brood nest on the other of the two sides of a frame (rectangle: 0; elipse: 1), based on which the formula for a rectangle (area=brood_B_x x brood_B_y) or an ellipse (area=pi x (brood_B_x/2) x (brood_B_y/2) ) is used to calculate the area of the brood nest.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 96. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
brood_B_shape 1 - 1 0.2 0 0 0 0 1 11,340 0 ( 0.0% ) 9,156 ( 80.7% ) 0 ( 0.0% ) 2 ( 0.0% )
Table 97. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
brood_B_shape
100.00%
0.02%
0 1

Data Distribution Top 20

Figure 97. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 98. Distribution of values in the column.

Completeness

Figure 99. Visualization of completeness of the data in the column.

Uniqueness

Figure 100. Visualization of uniqueness of the data in the column.

Column: bees_extra

Table 98. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name bees_extra
Description

Estimated number of bees on any other part of the hive box.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.
Table 99. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
bees_extra 1 - 4 45.1 0 0 0 0 9,000 11,340 1 ( 0.0% ) 10,597 ( 93.4% ) 0 ( 0.0% ) 46 ( 0.4% )
Table 100. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
bees_extra
99.99%
0.41%
0 2750

Data Distribution Top 20

Figure 101. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 102. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 103. Visualization of completeness of the data in the column.

Uniqueness

Figure 104. Visualization of uniqueness of the data in the column.

Column: bees_n

Table 101. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name bees_n
Description

Total number of bees estimated on the entire frame, including bees on any other part of the hive box.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.
Table 102. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
bees_n 1 - 4 709.4 0 250 650 1,050 9,950 11,340 0 ( 0.0% ) 923 ( 8.1% ) 0 ( 0.0% ) 104 ( 0.9% )
Table 103. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
bees_n
100.00%
0.92%
0 5150

Data Distribution Top 20

Figure 105. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 106. Distribution of 20 least common values, from lowest to highest.

Outliers

Figure 107. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 108. Visualization of completeness of the data in the column.

Uniqueness

Figure 109. Visualization of uniqueness of the data in the column.

Column: brood_cm2

Table 104. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name brood_cm2
Description

Total area of brood cells estimated on the entire frame in cm2.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

cm2
Table 105. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
brood_cm2 3 - 6 224.07 0.0 0 0 384.075 7,200.0 11,340 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2,150 ( 19.0% )
Table 106. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
brood_cm2
100.00%
18.96%
0.0 764.2

Continuous Data Distribution

Figure 110. Distribution of values in the column.

Completeness

Figure 111. Visualization of completeness of the data in the column.

Uniqueness

Figure 112. Visualization of uniqueness of the data in the column.

Column: brood_n

Table 107. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name brood_n
Description

Total number of brood cells estimated on the entire frame, assuming that there are 4 brood cells in one cm2.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.
Table 108. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
brood_n 1 - 5 896.3 0 0 0 1,536 28,800 11,340 0 ( 0.0% ) 7,377 ( 65.1% ) 0 ( 0.0% ) 1,962 ( 17.3% )
Table 109. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
brood_n
100.00%
17.30%
0 3057

Continuous Data Distribution

Figure 113. Distribution of values in the column.

Completeness

Figure 114. Visualization of completeness of the data in the column.

Uniqueness

Figure 115. Visualization of uniqueness of the data in the column.

Table: Hives

Column: apiary

Table 110. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name apiary
Description

Unique identifier of the apiary.
Data type Decimal number
Descriptor pms:apiaryID [UID:0.0.PRYID342]
Descriptor description

Unique sequence of characters associated with an apiary, which is specific to a dataset or to a beekeeper.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PRYID342
Unit

n/a
Table 111. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
apiary 3 - 3 2.15 1.1 1.2 2.15 3.1 3.2 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 10.0% )
Table 112. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
apiary
100.00%
10.00%
1.1 1.1

Data Distribution Top 20

Figure 116. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 117. Distribution of values in the column.

Outliers

Figure 118. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 119. Visualization of completeness of the data in the column.

Uniqueness

Figure 120. Visualization of uniqueness of the data in the column.

Column: hive

Table 113. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name hive
Description

Unique identifier of the hive.
Data type String
Descriptor pms:colonyID [UID:0.0.CLNYD362]
Descriptor description

Unique sequence of characters associated with a colony within a certain dataset
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CLNYD362
Unit

n/a
Table 114. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
hive 5 - 8 n/a 1.1-10Gr n/a n/a n/a 3.2-8 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 100.0% )
Table 115. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
hive
100.00%
100.00%
1.1-Z9 1.1-Z9

Completeness

Figure 121. Visualization of completeness of the data in the column.

Uniqueness

Figure 122. Visualization of uniqueness of the data in the column.

Column: owner

Table 116. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name owner
Description

Unique sequence of letters identifying the owner of the hive.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 117. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
owner 2 - 2 n/a FI n/a n/a n/a WO 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 10.0% )
Table 118. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
owner
100.00%
10.00%
WO WO

Data Distribution Top 20

Figure 123. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 124. Visualization of completeness of the data in the column.

Uniqueness

Figure 125. Visualization of uniqueness of the data in the column.

Column: frame_type

Table 119. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name frame_type
Description

Type of frame used in the hive.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 120. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
frame_type 6 - 12 n/a Breitwabe n/a n/a n/a Zander 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 5.0% )
Table 121. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
frame_type
100.00%
5.00%
Einheitsmass Breitwabe

Data Distribution Top 20

Figure 126. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 127. Visualization of completeness of the data in the column.

Uniqueness

Figure 128. Visualization of uniqueness of the data in the column.

Column: frame_inner_width

Table 122. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name frame_inner_width
Description

Frame inner width.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

mm
Table 123. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
frame_inner_width 3 - 3 378.3 350 350 375 400 420 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 5.0% )
Table 124. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
frame_inner_width
100.00%
5.00%
350 420

Data Distribution Top 20

Figure 129. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 130. Distribution of values in the column.

Outliers

Figure 131. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 132. Visualization of completeness of the data in the column.

Uniqueness

Figure 133. Visualization of uniqueness of the data in the column.

Column: frame_inner_height

Table 125. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name frame_inner_height
Description

Frame inner height.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

mm
Table 126. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
frame_inner_height 3 - 3 203.3 200 200 200 200 220 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 3.3% )
Table 127. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
frame_inner_height
100.00%
3.33%
200 220

Data Distribution Top 20

Figure 134. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 135. Distribution of values in the column.

Outliers

Figure 136. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 137. Visualization of completeness of the data in the column.

Uniqueness

Figure 138. Visualization of uniqueness of the data in the column.

Column: box_isolated

Table 128. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name box_isolated
Description

Information on additional insulation of the hive boxes (0: no, only wooden boxes; 1: yes, polystyrene insulation)
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 129. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
box_isolated 1 - 1 0.2 0 0 0 0 1 60 0 ( 0.0% ) 50 ( 83.3% ) 0 ( 0.0% ) 2 ( 3.3% )
Table 130. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
box_isolated
100.00%
3.33%
0 1

Data Distribution Top 20

Figure 139. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 140. Distribution of values in the column.

Completeness

Figure 141. Visualization of completeness of the data in the column.

Uniqueness

Figure 142. Visualization of uniqueness of the data in the column.

Column: bottomboard_height

Table 131. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name bottomboard_height
Description

Information on the inner height of the bottom boards: shallow, approximately 2 cm between bottom and frames; deep, more than approximately 2 cm between bottom and frames.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 132. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
bottomboard_height 4 - 7 n/a deep n/a n/a n/a shallow 60 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 3.3% )
Table 133. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
bottomboard_height
100.00%
3.33%
deep shallow

Data Distribution Top 20

Figure 143. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 144. Visualization of completeness of the data in the column.

Uniqueness

Figure 145. Visualization of uniqueness of the data in the column.

Table: Apiary

Column: apiary

Table 134. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name apiary
Description

Identifier of the record.
Data type String
Descriptor pms:apiaryID [UID:0.0.PRYID342]
Descriptor description

Unique sequence of characters associated with an apiary, which is specific to a dataset or to a beekeeper.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PRYID342
Unit

n/a
Table 135. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
apiary 3 - 3 2.15 1.1 1.175 2.15 3.125 3.2 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 100.0% )
Table 136. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
apiary
100.00%
100.00%
1.1 1.1

Continuous Data Distribution

Figure 146. Distribution of values in the column.

Outliers

Figure 147. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 148. Visualization of completeness of the data in the column.

Uniqueness

Figure 149. Visualization of uniqueness of the data in the column.

Column: elevation

Table 137. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name elevation
Description

Height above sea level.
Data type Decimal number
Descriptor pms:heightAboveMeanSeaLevel [UID:0.0.HGHTB393]
Descriptor description

Height above mean sea level is a measure of the vertical distance (height, elevation or altitude) of a location in reference to a historic mean sea level taken as a vertical datum. In geodesy, it is formalized as orthometric heights.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HGHTB393
Unit

m
Table 138. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
elevation 3 - 3 267.2 203 221.75 253.5 332.25 333 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 100.0% )
Table 139. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
elevation
100.00%
100.00%
203 203

Continuous Data Distribution

Figure 150. Distribution of values in the column.

Outliers

Figure 151. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 152. Visualization of completeness of the data in the column.

Uniqueness

Figure 153. Visualization of uniqueness of the data in the column.

Column: wgs84_e

Table 140. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name wgs84_e
Description

Longitude coordinate of geographical position.
Data type Decimal number
Descriptor dwc:decimalLongitude [UID:0.0.LNGTD332]
Descriptor description

A term from the Darwin Core standard:

The geographic longitude (in decimal degrees, using the spatial reference system given in dwc:geodeticDatum) of the geographic center of a dcterms:Location. Positive values are east of the Greenwich Meridian, negative values are west of it. Legal values lie between -180 and 180, inclusive.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/decimalLongitude
Unit

°
Table 141. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
wgs84_e 9 - 9 15.6716667 15.320000 15.3575 15.685 15.9625 16.030000 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 100.0% )
Table 142. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
wgs84_e
100.00%
100.00%
16.030000 16.030000

Continuous Data Distribution

Figure 154. Distribution of values in the column.

Outliers

Figure 155. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 156. Visualization of completeness of the data in the column.

Uniqueness

Figure 157. Visualization of uniqueness of the data in the column.

Column: wgs84_n

Table 143. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name wgs84_n
Description

Latitude coordinate of geographical position.
Data type Decimal number
Descriptor dwc:decimalLatitude [UID:0.0.LTTDE333]
Descriptor description

A term from the Darwin Core standard:

The geographic latitude (in decimal degrees, using the spatial reference system given in dwc:geodeticDatum) of the geographic center of a dcterms:Location. Positive values are north of the Equator, negative values are south of it. Legal values lie between -90 and 90, inclusive.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/decimalLatitude
Unit

°
Table 144. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
wgs84_n 9 - 9 46.7933333 46.680000 46.695 46.74 46.95 46.950000 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5 ( 83.3% )
Table 145. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
wgs84_n
100.00%
83.33%
46.950000 46.680000

Continuous Data Distribution

Figure 158. Distribution of values in the column.

Outliers

Figure 159. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 160. Visualization of completeness of the data in the column.

Uniqueness

Figure 161. Visualization of uniqueness of the data in the column.

Column: lau

Table 146. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name lau
Description

Code of teh local administrative unit (LAU).
Data type String
Descriptor eurostat:lauCode [UID:0.0.LCODE73]
Descriptor description

To meet the demand for statistics at a local level, Eurostat maintains a system of local administrative units (LAUs) compatible with NUTS. These LAUs are the building blocks of the NUTS, and comprise the municipalities and communes of the European Union. [...]

The LAUs are:

administrative for reasons such as the availability of data and policy implementation capacity a subdivision of the NUTS 3 regions covering the whole economic territory of the Member States appropriate for the implementation of local level typologies included in Tercet, namely the coastal area and DEGURBA classification. Since there are frequent changes to the LAUs, Eurostat publishes an updated list towards the end of each year.

The NUTS regulation makes provision for EU Member States to send the lists of their LAUs to Eurostat. If available, Eurostat receives additionally basic administrative data by means of the annual LAU lists, namely total population and total area for each LAU.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LCODE73
Unit

n/a
Table 147. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
lau 5 - 5 61,300.2 60,318 60,574.5 61,060.5 62,338.5 62,376 6 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 100.0% )
Table 148. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
lau
100.00%
100.00%
62376 62376

Continuous Data Distribution

Figure 162. Distribution of values in the column.

Outliers

Figure 163. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 164. Visualization of completeness of the data in the column.

Uniqueness

Figure 165. Visualization of uniqueness of the data in the column.

Table: Crops

Column: apiary

Table 149. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name apiary
Description

Unique identifier of the apiary.
Data type String
Descriptor pms:apiaryID [UID:0.0.PRYID342]
Descriptor description

Unique sequence of characters associated with an apiary, which is specific to a dataset or to a beekeeper.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PRYID342
Unit

n/a
Table 150. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
apiary 3 - 3 2.15 1.1 1.2 2.15 3.1 3.2 66 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 9.1% )
Table 151. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
apiary
100.00%
9.09%
1.1 1.1

Data Distribution Top 20

Figure 166. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 167. Distribution of values in the column.

Outliers

Figure 168. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 169. Visualization of completeness of the data in the column.

Uniqueness

Figure 170. Visualization of uniqueness of the data in the column.

Column: crop

Table 152. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name crop
Description

Type of crop.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 153. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
crop 4 - 29 n/a cereals n/a n/a n/a unknown 66 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 9 ( 13.6% )
Table 154. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
crop
100.00%
13.64%
corn cereals

Completeness

Figure 171. Visualization of completeness of the data in the column.

Uniqueness

Figure 172. Visualization of uniqueness of the data in the column.

Column: clothianidin

Table 155. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name clothianidin
Description

Information on the usage of clothianidin as active ingredient in the plant protection products.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 156. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
clothianidin 2 - 7 n/a no n/a n/a n/a yes 66 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 4.5% )
Table 157. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
clothianidin
100.00%
4.55%
no yes

Data Distribution Top 20

Figure 173. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 174. Visualization of completeness of the data in the column.

Uniqueness

Figure 175. Visualization of uniqueness of the data in the column.

Column: area_ha

Table 158. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name area_ha
Description

Area of crop cultivated with the specified clothianidin treatment in the immediate surroundings (1000 m) of each apiary.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

n/a
Table 159. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
area_ha 1 - 10 26.3820059 0 1.0775 8.295 27.2276 151.72 66 0 ( 0.0% ) 11 ( 16.7% ) 0 ( 0.0% ) 55 ( 83.3% )
Table 160. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
area_ha
100.00%
83.33%
0 75.98645

Continuous Data Distribution

Figure 176. Distribution of values in the column.

Outliers

Figure 177. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 178. Visualization of completeness of the data in the column.

Uniqueness

Figure 179. Visualization of uniqueness of the data in the column.