EU Pollinator Hub

, ,
• •
Dataset Report
Unique identifier: HNYPR6.0.0
Title: Honey production Austria
Long title: Honey production in Austria
Status: Quality Validated
Current Version: v. 1.0
Published: 2023-04-17
Reviewed by:
Citation proposal:
Biene Österreich – Imkereidachverband 2023 Report of dataset Honey production Austria, v. 1.0 [HNYPR6.0.0]. EU Pollinator Hub. [2026-02-24] 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-04-17.

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-04-17 00:04:00 Initial release. n/a

Abbreviations

No abbreviations.

Executive summary

Data overview:

n/a

Data value:

n/a

Data description:

n/a

Data 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 euph_000006_honeyat_table_honey.csv CSV - Comma seperated values Yes No 2023-11-21 15:11:42 137,130 807.53 KiB

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 Honey breeding program Data was provided by the Austrian Beekeepers Federation (BÖ, Biene Österreich-Imkereidachverband). Data on honey production was obtained from the Austrian…
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid HNYPR6.0.0
Title Honey production Austria
Long title Honey production in Austria
Target IRI https://app.pollinatorhub.eu/dataset-discovery/HNYPR6.0.0
interactions.single.section-details.licence CC BY-NC-SA 4.0
DOI n/a
Created 2023-01-26
Published 2023-04-17
Contact n/a
Keywords Austria, honey, production, yield
Data collection years 1998-2022
Regions, the data was collected in Österreich
Abstract

The dataset contains anonymised total annual honey yields of test colonies from the performance testing scheme of the Austrian honey bee breeding program. The locations of apiaries were aggregated by NUTS level 1 and HPG.
Table 5. Standardised metadata of the data provider Biene Österreich – Imkereidachverband. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Biene Österreich – Imkereidachverband
Url
Acronym BÖ
IRI https://app.pollinatorhub.eu/data-providers/boe
Address Georg-Coch Platz3/11a, 1010 Wien, Austria
Country Austria
Contact Georg-Coch Platz 3/11a, 1010 Wien www.biene-oesterreich.at office@biene-oesterreich.at
Description

The Austrian Beekeepers Federation (BÖ, Biene Österreich-Imkereidachverband) is the umbrella organisation of the two largest beekeeping associations in Austria, the Austrian Beekepers Association (ÖIB, Österreichischer Imkerbund) and the Austrian Professional Beekeepers Association (ÖEIB, Österreichischer Erwerbsimkerbund).

Tables

Honey breeding program

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

Data was provided by the Austrian Beekeepers Federation (BÖ, Biene Österreich-Imkereidachverband). Data on honey production was obtained from the Austrian breeding program, administrated by BÖ, in which queen testing operations assess the performance of honey bee colonies according to a standardised protocol. The queen testing operations were assigned to different geographic entities (HPG, Main agricultural production zones; NUTS, Nomenclature of territorial units for statistics) based on the Local Administrative Unit (LAU) of their home address, independent of the actual site of their apiary. It covers the period of 1998 to 2022.

Data was provided by the Austrian Beekeepers Federation (BÖ, Biene Österreich-Imkereidachverband). Data on honey production was obtained from the Austrian breeding program, administrated by BÖ, in which queen testing operations assess the performance of honey bee colonies according to a standardised protocol. The queen testing operations were assigned to different geographic entities (HPG, Main agricultural production zones; NUTS, Nomenclature of territorial units for statistics) based on the Local Administrative Unit (LAU) of their home address, independent of the actual site of their apiary. It covers the period of 1998 to 2022.

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 pms:recordID [0.0.RCRDD344]

n/a
year

Calendar year in which the honey was harvested.

 Integer number Year [HNYPR6.0.YEARA151]

n/a
beekeeper

Identifier of the breeding operation by which the honey was harvested.

 Integer number pms:beekeeperID [0.0.BKPRD343]

n/a
apiary

Identifier of the apiary of a given beekeeper on which the honey was harvested.

 Integer number pms:apiaryID [0.0.PRYID342]

n/a
honey

Total production of honey from one honey bee colony within a calendar year or within a more precicely defined period of one year.

 Decimal number Annual honey yield [HNYPR6.0.HNYYL154]

n/a
nuts

A 3 to 5 digit code with the following structure: It begins with a two-letter code referencing the country, which is not necessarily identical with the alpha-2 code in ISO 3166-1. Each of three possible subdivision of the country are then referred to with one additional number from 1 to 9, or a latin capital letter where a subdivision has more than nine entities.

 String eurostat:nuts2021Code [0.0.NTSCD55]

n/a
hpg

Division of Austria into main agricultural production zones (Landwirtschaftliche Hauptproduktionsgebiete, HPG), which are an aggregate of minor agricultural production areas (Landwirtschaftliche Kleinproduktionsgebiete, KPG), which in turn aggregate municipalties with similar conditions for agricultural production.

 Integer number HPG [HNYPR6.0.HPGAB156]

n/a

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 - 5 9,795.5 1 4,897.75 9,795.5 14,693.25 19,590 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 19,590 ( 100.0% )
year 4 - 4 2,009.9 1,998 2,005 2,009 2,016 2,022 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 24 ( 0.1% )
beekeeper 1 - 3 161.0 8 71 179 241 317 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 274 ( 1.4% )
apiary 1 - 2 5.4 1 1 2 5 83 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 52 ( 0.3% )
honey 3 - 5 43.62 0.1 21.6 36.4 56.125 202.0 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,343 ( 6.9% )
nuts 3 - 3 n/a AT1 n/a n/a n/a AT3 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.0% )
hpg 1 - 1 5.2 1 3 6 7 8 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 0.0% )

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
year
100.00%
0.12%
2001 2004
beekeeper
100.00%
1.40%
317 88
apiary
100.00%
0.27%
1 28
honey
100.00%
6.86%
28.0 0.8
nuts
100.00%
0.02%
AT3 AT1
hpg
100.00%
0.04%
6 5

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: Honey breeding program

Column: id

Table 10. 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 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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 5 9,795.5 1 4,897.75 9,795.5 14,693.25 19,590 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 19,590 ( 100.0% )
Table 12. 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: year

Table 13. 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 year
Description

Calendar year in which the honey was harvested.
Data type Integer number
Descriptor Year [UID:HNYPR6.0.YEARA151]
Descriptor description

Year in which the honey was harvested.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/HNYPR6.0.YEARA151
Unit

n/a
Table 14. 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
year 4 - 4 2,009.9 1,998 2,005 2,009 2,016 2,022 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 24 ( 0.1% )
Table 15. 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
year
100.00%
0.12%
2001 2004

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: beekeeper

Table 16. 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 beekeeper
Description

Identifier of the breeding operation by which the honey was harvested.
Data type Integer number
Descriptor pms:beekeeperID [UID:0.0.BKPRD343]
Descriptor description

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

n/a
Table 17. 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
beekeeper 1 - 3 161.0 8 71 179 241 317 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 274 ( 1.4% )
Table 18. 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
beekeeper
100.00%
1.40%
317 88

Continuous Data Distribution

Figure 10. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: apiary

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).
Parameter Content
Column name apiary
Description

Identifier of the apiary of a given beekeeper on which the honey was harvested.
Data type Integer number
Descriptor pms:apiaryID [UID:0.0.PRYID342]
Descriptor description

An apiary ID is a 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 20. 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 1 - 2 5.4 1 1 2 5 83 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 52 ( 0.3% )
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%
0.27%
1 28

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: honey

Table 22. 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 honey
Description

Total production of honey from one honey bee colony within a calendar year or within a more precicely defined period of one year.
Data type Decimal number
Descriptor Annual honey yield [UID:HNYPR6.0.HNYYL154]
Descriptor description

Annual total honey yield per colony in kg.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/HNYPR6.0.HNYYL154
Unit

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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
honey 3 - 5 43.62 0.1 21.6 36.4 56.125 202.0 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,343 ( 6.9% )
Table 24. 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
honey
100.00%
6.86%
28.0 0.8

Continuous Data Distribution

Figure 19. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: nuts

Table 25. 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 nuts
Description

A 3 to 5 digit code with the following structure: It begins with a two-letter code referencing the country, which is not necessarily identical with the alpha-2 code in ISO 3166-1. Each of three possible subdivision of the country are then referred to with one additional number from 1 to 9, or a latin capital letter where a subdivision has more than nine entities.
Data type String
Descriptor eurostat:nuts2021Code [UID:0.0.NTSCD55]
Descriptor description

A NUTS code defined in the NUTS classification 2021, valid from 2021-01-01 to 2023-12-31, containing 92 regions at NUTS level 1, 244 regions at NUTS level 2 and 1165 regions at NUTS level 3 level.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTSCD55
Unit

n/a
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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
nuts 3 - 3 n/a AT1 n/a n/a n/a AT3 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.0% )
Table 27. 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
nuts
100.00%
0.02%
AT3 AT1

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: hpg

Table 28. 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 hpg
Description

Division of Austria into main agricultural production zones (Landwirtschaftliche Hauptproduktionsgebiete, HPG), which are an aggregate of minor agricultural production areas (Landwirtschaftliche Kleinproduktionsgebiete, KPG), which in turn aggregate municipalties with similar conditions for agricultural production.
Data type Integer number
Descriptor HPG [UID:HNYPR6.0.HPGAB156]
Descriptor description

Main agricultural production areas (Landwirtschaftliche Hauptproduktionsgebiete, HPG) according to Wagner 1990 [1, 2] in which the beekeeper resides.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/HNYPR6.0.HPGAB156
Unit

n/a
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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
hpg 1 - 1 5.2 1 3 6 7 8 19,590 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 0.0% )
Table 30. 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
hpg
100.00%
0.04%
6 5

Data Distribution Top 20

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

Continuous Data Distribution

Figure 27. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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