|
BEELIFE EUROPEAN BEEKEEPING COORDINATION Avenue Louise 209/7, 1050 Brussels, Belgium info@pollinatorhub.eu • www.pollinatorhub.eu • +32 (0) 486 973 920 |
Dataset Report
| UID: | HNYMR172.0.0 |
| Name: | Honey Market & Api Sector |
| Status: | Honey market and socio-economic information of the beekeeping sector |
| Title: | Approved |
| Version: | v. 1.0 |
| Date: | 2025-01-17 |
| Author: | Michael Rubinigg |
| Citation proposal: | 2025, Report for Dataset Honey Market & Api Sector, v. 1.0; Editor EU Pollinator Hub; available at: https://app.pollinatorhub.eu/dataset-discovery/reports/65 Michael Rubinigg |
|
Data Quality
Under evaluation
|
|||||||||||||||
This document is intended for use by Data Providers to understand the quality of their data and it explains the data for third parties. This report ensures that Data Provider's data fulfills FAIR Principles (Findable, Accessible, Interoperable and Reusable)
Document History
Release
Version v. 1.0 released on 2025-01-18. Written by Michael Rubinigg. Reviewed by Michael Rubinigg. Approved by Michael Rubinigg.
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 | 2025-01-18 05:01:40 | Initial release. | N.A. |
Abbreviations
No Abbreviations.
Executive Summary
Data overview:
This Dataset contains several tables related to the beekeeping sector and the honey market.
Data value:
n/a
Data description:
n/a
Data application:
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 | RAW_Number beekeepers in EU.csv | CSV - Comma seperated values | Yes | No | 2025-01-14 12:01:15 | 162 | 811.00 B |
| 2 | EUPH_Fig5_Relative_Diff_Fuel_Labour_Feed_Vet.csv | CSV - Comma seperated values | Yes | No | 2025-01-14 12:01:55 | 72 | 1.17 KiB |
| 3 | Fig2_RAW_Data Imports non_EU Honey.csv | CSV - Comma seperated values | Yes | No | 2025-01-13 17:01:33 | 350 | 3.50 KiB |
| 4 | RAW_Fig3_Imports_exports per country 2014-2023.csv | CSV - Comma seperated values | Yes | No | 2025-01-13 17:01:10 | 2,688 | 20.59 KiB |
| 5 | RAW_Number of colonies in EU.csv | CSV - Comma seperated values | Yes | No | 2025-01-14 12:01:47 | 252 | 1.09 KiB |
| 6 | Data_National_Strategic_Plans.csv | CSV - Comma seperated values | Yes | No | 2025-01-14 12:01:12 | 378 | 4.23 KiB |
| 7 | EPH 2-1_EU Honey market.pdf | Miscellaneous | No | Yes | 2025-01-16 14:01:14 | n/a | 1.03 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 | Number of beekeepers in the EU | This dataset contains the number of beekeepers in the EU for the years 2019 and 2022 Provided by European Commission… |
| 2 | Rel Diff Production Cost | Relative difference in production costs for the years 2022 and 2023 with regards to 2021. It includes: Fuel (Source: EU… |
| 3 | Honey Imports non-EU Honey | Data on imports of non-EU Honey in the EU in weight (tons and Kg), value (Euros) and prices calculated (Euros/Kg).… |
| 4 | Honey Import Export Country | Data on Honey imports (non-EU) and exports (outside of the EU) per EU country. Extracted on 2024/04/09 14:35:14 Surce: Eurostat… |
| 5 | EU Honey Bee colonies | Number of Honey Bee colonies. Unit: Thousand units. Source: Civil Dialogue Group (CDG) “Animal Production - Honey" held on 08/10/2024. |
| 6 | Honey Production Costs | Production costs of honey (Euros/Kg) described by EU member states in the National Strategic Plans, National Beekeeping Programmes, published in… |
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | HNYMR172.0.0 |
| Name | Honey Market & Api Sector |
| Title | Honey market and socio-economic information of the beekeeping sector |
| Licence | CC BY-NC 4.0 |
| DOI | n/a |
| Creation date | 2024-08-09 |
| Publishing date | 2025-01-15 |
| Contact information | simon@bee-life.eu |
| Keywords | beekeeping, honey market, socio-economics, trade |
| Data collection years | 2014-2022 |
| Regions, the data was collected in | Belgique/België, Danmark, Deutschland, Eesti, España, France, Hrvatska, Italia, Latvija, Lietuva, Luxembourg, Magyarország, Malta, Nederland, Polska, Portugal, România, Slovenija, Slovensko, Suomi/Finland, Sverige, Éire/Ireland, Österreich, Česko, Ελλάδα , Κύπρος , България |
| Description | This is a series of datasets compiled in the framework of the drafting of the report "The Crisis of the Honey Sector in Europe". Socio-economic data (production, trade, cost of productions, etc.) has been brought together to develop and analyses of the honey sector in the EU during the last decade, with a special focus on the years 2021-2023. First we analyse he production data based on FAOSTAT data and beekeeping demographic data base on data shared at the Civil Dialogue Group of DG AGRI on beekeeping. Eurostat and Trade data from the EU commission is used to analyse the trade situation. Finally, a survey was performed by Copa-Cogeca and distributed by all European Beekeeping Associations to gain insight about the situation of beekeeping operations, with a special focus on costs of production. |
Table 5. Standardised metadata of the data provider Noa Simon Delso. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | noa-simon-delso-2 |
| Name | Noa Simon Delso |
| URL | |
| Acronym | Noa |
| Contact information | simon@bee-life.eu |
| Description | Noa Simón Delso became Scientific Director and Project Manager at BeeLife at the beginning of 2021. She holds a PhD in Agricultural Science and Bioengineering from the Université Catholique de Louvain (Belgium), an MSc in Economy, Management and Consumer Studies from Wageningen University (the Netherlands) and she is a DVM from the University of León (Spain). In her scientific career, Noa has specialised in environmental toxicology, particularly on bees, environmental policy and honey bee health, fields in which she has published several papers in peer-reviewed international journals in the field of environmental research, health and toxicology. In 2019 she started diversifying her activities, evolving towards the implementation of data science to pollinators health. In parallel, she has provided technical assistance to Belgian and European beekeepers and decision makers. Since 2009, she has advised in scientific-technical dossiers to the European organisation BeeLife, following the evolution and implementation of European legislation on the subject of pesticide authorisation, agricultural and environmental policy. During this time, she developed great expertise in the regulatory framework and policies related to pollinator health and conservation. More on: https://www.researchgate.net/profile/Noa-Simon-Delso |
Tables
Number of beekeepers in the EU
Table 6. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | HNYMR172.NMBRF350.0 |
| Name | Number of beekeepers in the EU |
| Type | File |
| Licence | CC BY-NC 4.0 |
| Description | Noa Simón Delso became Scientific Director and Project Manager at BeeLife at the beginning of 2021. She holds a PhD in Agricultural Science and Bioengineering from the Université Catholique de Louvain (Belgium), an MSc in Economy, Management and Consumer Studies from Wageningen University (the Netherlands) and she is a DVM from the University of León (Spain). In her scientific career, Noa has specialised in environmental toxicology, particularly on bees, environmental policy and honey bee health, fields in which she has published several papers in peer-reviewed international journals in the field of environmental research, health and toxicology. In 2019 she started diversifying her activities, evolving towards the implementation of data science to pollinators health. In parallel, she has provided technical assistance to Belgian and European beekeepers and decision makers. Since 2009, she has advised in scientific-technical dossiers to the European organisation BeeLife, following the evolution and implementation of European legislation on the subject of pesticide authorisation, agricultural and environmental policy. During this time, she developed great expertise in the regulatory framework and policies related to pollinator health and conservation. More on: https://www.researchgate.net/profile/Noa-Simon-Delso |
n/a
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).
| Name | Description | Data type | Descriptor | Unit |
|---|---|---|---|---|
| Country | Country | String | iso3166:alpha-2CountryCode [0.0.LPHCN4] | n/a |
| Year | Year | Integer number | iso8601:calendarYear [0.0.CLNDR340] | year |
| Number_beekeepers | Number of beekeepers | Integer number | Integer [0.0.NTGER313] | 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Country | 2 - 2 | n/a | AT | n/a | n/a | n/a | SK | 54 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 27 (50.0%) |
| Year | 4 - 4 | 2,020.5 | 2,019 | 2,019 | 2,020.5 | 2,022 | 2,022 | 54 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 2 (3.7%) |
| Number_beekeepers | 3 - 6 | n/a | 234 | n/a | n/a | n/a | N/A | 54 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 53 (98.1%) |
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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Country |
100.00%
|
50.00%
|
AT | AT |
| Year |
100.00%
|
3.70%
|
2019 | 2019 |
| Number_beekeepers |
100.00%
|
98.15%
|
7000 | 29745 |
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aRel Diff Production Cost
Table 10. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | HNYMR172.RLDFF543.0 |
| Name | Rel Diff Production Cost |
| Type | File |
| Licence | CC BY-NC 4.0 |
| Description | Noa Simón Delso became Scientific Director and Project Manager at BeeLife at the beginning of 2021. She holds a PhD in Agricultural Science and Bioengineering from the Université Catholique de Louvain (Belgium), an MSc in Economy, Management and Consumer Studies from Wageningen University (the Netherlands) and she is a DVM from the University of León (Spain). In her scientific career, Noa has specialised in environmental toxicology, particularly on bees, environmental policy and honey bee health, fields in which she has published several papers in peer-reviewed international journals in the field of environmental research, health and toxicology. In 2019 she started diversifying her activities, evolving towards the implementation of data science to pollinators health. In parallel, she has provided technical assistance to Belgian and European beekeepers and decision makers. Since 2009, she has advised in scientific-technical dossiers to the European organisation BeeLife, following the evolution and implementation of European legislation on the subject of pesticide authorisation, agricultural and environmental policy. During this time, she developed great expertise in the regulatory framework and policies related to pollinator health and conservation. More on: https://www.researchgate.net/profile/Noa-Simon-Delso |
n/a
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).
| Name | Description | Data type | Descriptor | Unit |
|---|---|---|---|---|
| Production_Cost_Type | Production Cost Type | String | Text [0.0.TEXTA315] | n/a |
| Source | Source of data | String | Text [0.0.TEXTA315] | n/a |
| Year | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Absolute | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Relative differences | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Link | String | Text [0.0.TEXTA315] | n/a |
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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Production_Cost_Type | 3 - 6 | n/a | Feed | n/a | n/a | n/a | Vet | 12 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 4 (33.3%) |
| Source | 8 - 40 | n/a | Copa-Cogeca… | n/a | n/a | n/a | Eurostat | 12 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 3 (25.0%) |
| Year | 4 - 4 | 2,022.0 | 2,021 | 2,021 | 2,022 | 2,023 | 2,023 | 12 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 3 (25.0%) |
| Absolute | 6 - 7 | 4,692.468 | 1,417.92 | 1,633.305 | 4,709.305 | 7,765.215 | 7,889.34 | 12 | 6 (50.0%) | 0 (0.0%) | 0 (0.0%) | 7 (58.3%) |
| Relative differences | 1 - 5 | 17.342 | -3.53 | 0 | 9 | 38.37 | 62 | 12 | 0 (0.0%) | 4 (33.3%) | 0 (0.0%) | 9 (75.0%) |
| Link | 23 - 68 | n/a | https://copa… | n/a | n/a | n/a | https://ener… | 12 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 3 (25.0%) |
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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Production_Cost_Type |
100.00%
|
33.33%
|
Fuel | Fuel |
| Source |
100.00%
|
25.00%
|
Copa-Cogeca Survey – Honey Working Group | EU Commission |
| Year |
100.00%
|
25.00%
|
2021 | 2021 |
| Absolute |
50.00%
|
58.33%
|
n/a | 1417.92 |
| Relative differences |
100.00%
|
75.00%
|
0 | 27.48 |
| Link |
100.00%
|
25.00%
|
https://copa-cogeca.eu/ | https://energy.ec.europa.eu/data-and-analysis/weekly-oil-bulletin_en |
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aHoney Imports non-EU Honey
Table 14. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | HNYMR172.HNYMP549.0 |
| Name | Honey Imports non-EU Honey |
| Type | File |
| Licence | CC BY-NC 4.0 |
| Description | Noa Simón Delso became Scientific Director and Project Manager at BeeLife at the beginning of 2021. She holds a PhD in Agricultural Science and Bioengineering from the Université Catholique de Louvain (Belgium), an MSc in Economy, Management and Consumer Studies from Wageningen University (the Netherlands) and she is a DVM from the University of León (Spain). In her scientific career, Noa has specialised in environmental toxicology, particularly on bees, environmental policy and honey bee health, fields in which she has published several papers in peer-reviewed international journals in the field of environmental research, health and toxicology. In 2019 she started diversifying her activities, evolving towards the implementation of data science to pollinators health. In parallel, she has provided technical assistance to Belgian and European beekeepers and decision makers. Since 2009, she has advised in scientific-technical dossiers to the European organisation BeeLife, following the evolution and implementation of European legislation on the subject of pesticide authorisation, agricultural and environmental policy. During this time, she developed great expertise in the regulatory framework and policies related to pollinator health and conservation. More on: https://www.researchgate.net/profile/Noa-Simon-Delso |
n/a
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).
| Name | Description | Data type | Descriptor | Unit |
|---|---|---|---|---|
| Year | Integer number | Integer [0.0.NTGER313] | n/a |
|
| TOTAL_Qt_Import_Honey_Kg | Integer number | Integer [0.0.NTGER313] | n/a |
|
| TOTAL_Qt_Import_Honey_tons | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Qt_Import_Intra_EU_Kg | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Qt_Import_Extra_EU_Kg | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Qt_Import_Intra_EU_tons | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Qt_Import_Extra_EU_tons | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Proportion_ Import_Intra_from_total | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Proportion_Import_Extra_from_total | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Ratio_Import_Intra_Extra | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| TOTAL_Qt_Export_Honey_Kg | Integer number | Integer [0.0.NTGER313] | n/a |
|
| TOTAL_Qt_Export_Honey_tons | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Qt_Export_Intra_EU_Kg | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Qt_Export_Extra_EU_Kg | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Qt_Export_Intra_EU_tons | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Qt_Export_Extra_EU_tons | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Proportion_ Export_Intra_from_total | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Proportion_Export_Extra_from_total | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Ratio_Export_Intra_Extra | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Qt_Difference_Export_Import_Intra | Integer number | Integer [0.0.NTGER313] | n/a |
|
| QT_Difference_Export_Import_Extra | Integer number | Integer [0.0.NTGER313] | n/a |
|
| TOTAL_Value_Import_Honey_EUR | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Value_Import_Intra_EU_EUR | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Value_Import_Extra_EU_EUR | Integer number | Integer [0.0.NTGER313] | n/a |
|
| TOTAL_Value_Export_Honey_EUR | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Value_Export_Intra_EU_EUR | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Value_Export_Extra_EU_EU | Integer number | Integer [0.0.NTGER313] | n/a |
|
| Avg_Import_Price_EUR_Kg | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Price_Import_Intra_EU_Honey_EUR_Kg | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Price_Import_Extra_EU_Honey_EUR_Kg | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Avg_Export_Price_EUR | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Price_Export_Intra_EU_Honey_EUR_Kg | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Price_Export_Extra_EU_Honey_EUR_Kg | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Avg_Price_Import_Export_Intra_EU_Honey | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Avg_ Price_Import_Export_Extra_EU_Honey | Decimal number | DecimalNumber [0.0.DCMLN314] | 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Year | 4 - 4 | 2,018.5 | 2,014 | 2,015.75 | 2,018.5 | 2,021.25 | 2,023 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| TOTAL_Qt_Import_Honey_Kg | 9 - 9 | 303,215,272.7 | 272,422,062 | 290,194,861 | 297,577,522.5 | 321,113,082.75 | 340,295,675 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| TOTAL_Qt_Import_Honey_tons | 8 - 9 | 303,215.272 | 272,422.06 | 290,194.86 | 297,577.52 | 321,113.085 | 340,295.68 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Import_Intra_EU_Kg | 9 - 9 | 136,982,929.0 | 127,607,782 | 128,947,220.5 | 134,373,794 | 146,793,354.25 | 149,850,638 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Import_Extra_EU_Kg | 9 - 9 | 166,232,343.7 | 143,235,421 | 161,580,840 | 163,471,662.5 | 173,782,847.5 | 190,445,037 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Import_Intra_EU_tons | 6 - 6 | 136,983.0 | 127,608 | 128,947 | 134,373.5 | 146,793.5 | 149,851 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Import_Extra_EU_tons | 6 - 6 | 166,232.3 | 143,235 | 161,580.5 | 163,472 | 173,782.5 | 190,445 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Proportion_ Import_Intra_from_total | 4 - 4 | 0.451 | 0.44 | 0.44 | 0.45 | 0.46 | 0.47 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 4 (40.0%) |
| Proportion_Import_Extra_from_total | 4 - 4 | 0.549 | 0.53 | 0.54 | 0.55 | 0.56 | 0.56 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 4 (40.0%) |
| Ratio_Import_Intra_Extra | 3 - 4 | 0.825 | 0.79 | 0.79 | 0.825 | 0.8425 | 0.9 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 7 (70.0%) |
| TOTAL_Qt_Export_Honey_Kg | 9 - 9 | 168,783,806.2 | 153,648,562 | 155,855,760.75 | 162,423,634 | 184,895,972 | 195,427,843 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| TOTAL_Qt_Export_Honey_tons | 8 - 9 | 168,783.807 | 153,648.56 | 155,855.7625 | 162,423.635 | 184,895.975 | 195,427.84 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Export_Intra_EU_Kg | 9 - 9 | 146,469,092.0 | 134,197,343 | 136,552,454 | 142,999,579.5 | 158,424,920 | 170,002,307 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Export_Extra_EU_Kg | 8 - 8 | 22,314,714.2 | 16,577,221 | 19,098,418 | 21,524,037 | 25,130,435 | 30,788,004 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Export_Intra_EU_tons | 6 - 6 | 146,469.0 | 134,197 | 136,552.25 | 142,999.5 | 158,424.75 | 170,002 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Export_Extra_EU_tons | 5 - 5 | 22,314.8 | 16,577 | 19,098.75 | 21,524 | 25,130.5 | 30,788 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Proportion_ Export_Intra_from_total | 4 - 4 | 0.868 | 0.84 | 0.8575 | 0.87 | 0.8825 | 0.89 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 6 (60.0%) |
| Proportion_Export_Extra_from_total | 4 - 4 | 0.132 | 0.11 | 0.1175 | 0.13 | 0.1425 | 0.16 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 6 (60.0%) |
| Ratio_Export_Intra_Extra | 4 - 4 | 6.720 | 5.15 | 5.9975 | 6.68 | 7.4775 | 8.27 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Qt_Difference_Export_Import_Intra | 7 - 8 | 9,486,163.0 | 2,075,411 | 4,286,855.75 | 8,226,104.5 | 13,531,551.25 | 22,253,101 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| QT_Difference_Export_Import_Extra | 10 - 10 | -143,917,629.5 | -165,412,969 | -147,974,045.25 | -143,234,474 | -138,550,681.75 | -126,658,200 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| TOTAL_Value_Import_Honey_EUR | 9 - 10 | 857,511,725.6 | 743,731,511 | 792,753,767.75 | 837,038,436 | 892,399,997.75 | 1,065,958,120 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Value_Import_Intra_EU_EUR | 9 - 9 | 481,163,027.7 | 437,264,813 | 446,844,598.75 | 470,915,919 | 512,959,627.5 | 561,579,005 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Value_Import_Extra_EU_EUR | 9 - 9 | 376,348,697.9 | 302,756,749 | 346,836,656.25 | 363,555,928.5 | 407,112,833 | 504,379,115 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| TOTAL_Value_Export_Honey_EUR | 9 - 9 | 636,579,118.3 | 554,974,534 | 590,507,562 | 623,219,302 | 679,220,471.25 | 738,026,692 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Value_Export_Intra_EU_EUR | 9 - 9 | 509,866,018.5 | 464,578,855 | 471,844,243.25 | 497,470,831.5 | 541,384,696.75 | 591,211,796 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Value_Export_Extra_EU_EU | 8 - 9 | 126,713,099.8 | 90,395,679 | 109,861,379.5 | 122,164,332.5 | 147,810,761.25 | 161,577,868 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Avg_Import_Price_EUR_Kg | 4 - 4 | 2.824 | 2.58 | 2.71 | 2.8 | 2.945 | 3.13 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
| Price_Import_Intra_EU_Honey_EUR_Kg | 3 - 4 | 3.511 | 3.21 | 3.405 | 3.535 | 3.61 | 3.75 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
| Price_Import_Extra_EU_Honey_EUR_Kg | 3 - 4 | 2.255 | 2.05 | 2.0975 | 2.195 | 2.38 | 2.65 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
| Avg_Export_Price_EUR | 4 - 4 | 3.771 | 3.49 | 3.6175 | 3.78 | 3.9025 | 4.02 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Price_Export_Intra_EU_Honey_EUR_Kg | 3 - 4 | 3.484 | 3.14 | 3.375 | 3.495 | 3.6025 | 3.7 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
| Price_Export_Extra_EU_Honey_EUR_Kg | 4 - 4 | 5.681 | 5.25 | 5.5475 | 5.735 | 5.795 | 6.07 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
| Avg_Price_Import_Export_Intra_EU_Honey | 3 - 4 | 3.499 | 3.18 | 3.39 | 3.55 | 3.575 | 3.73 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 8 (80.0%) |
| Avg_ Price_Import_Export_Extra_EU_Honey | 3 - 4 | 3.969 | 3.65 | 3.87 | 3.945 | 4.065 | 4.36 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Year |
100.00%
|
100.00%
|
2014 | 2014 |
| TOTAL_Qt_Import_Honey_Kg |
100.00%
|
100.00%
|
272422062 | 272422062 |
| TOTAL_Qt_Import_Honey_tons |
100.00%
|
100.00%
|
272422.06 | 272422.06 |
| Qt_Import_Intra_EU_Kg |
100.00%
|
100.00%
|
129186641 | 129186641 |
| Qt_Import_Extra_EU_Kg |
100.00%
|
100.00%
|
143235421 | 143235421 |
| Qt_Import_Intra_EU_tons |
100.00%
|
100.00%
|
129187 | 129187 |
| Qt_Import_Extra_EU_tons |
100.00%
|
100.00%
|
143235 | 143235 |
| Proportion_ Import_Intra_from_total |
100.00%
|
40.00%
|
0.44 | 0.47 |
| Proportion_Import_Extra_from_total |
100.00%
|
40.00%
|
0.56 | 0.53 |
| Ratio_Import_Intra_Extra |
100.00%
|
70.00%
|
0.79 | 0.9 |
| TOTAL_Qt_Export_Honey_Kg |
100.00%
|
100.00%
|
153648562 | 153648562 |
| TOTAL_Qt_Export_Honey_tons |
100.00%
|
100.00%
|
153648.56 | 153648.56 |
| Qt_Export_Intra_EU_Kg |
100.00%
|
100.00%
|
137071341 | 137071341 |
| Qt_Export_Extra_EU_Kg |
100.00%
|
100.00%
|
16577221 | 16577221 |
| Qt_Export_Intra_EU_tons |
100.00%
|
100.00%
|
137071 | 137071 |
| Qt_Export_Extra_EU_tons |
100.00%
|
100.00%
|
16577 | 16577 |
| Proportion_ Export_Intra_from_total |
100.00%
|
60.00%
|
0.87 | 0.88 |
| Proportion_Export_Extra_from_total |
100.00%
|
60.00%
|
0.13 | 0.12 |
| Ratio_Export_Intra_Extra |
100.00%
|
100.00%
|
8.27 | 8.27 |
| Qt_Difference_Export_Import_Intra |
100.00%
|
100.00%
|
7884700 | 7884700 |
| QT_Difference_Export_Import_Extra |
100.00%
|
100.00%
|
-126658200 | -126658200 |
| TOTAL_Value_Import_Honey_EUR |
100.00%
|
100.00%
|
743731511 | 743731511 |
| Value_Import_Intra_EU_EUR |
100.00%
|
100.00%
|
440974762 | 440974762 |
| Value_Import_Extra_EU_EUR |
100.00%
|
100.00%
|
302756749 | 302756749 |
| TOTAL_Value_Export_Honey_EUR |
100.00%
|
100.00%
|
554974534 | 554974534 |
| Value_Export_Intra_EU_EUR |
100.00%
|
100.00%
|
464578855 | 464578855 |
| Value_Export_Extra_EU_EU |
100.00%
|
100.00%
|
90395679 | 90395679 |
| Avg_Import_Price_EUR_Kg |
100.00%
|
90.00%
|
2.79 | 2.73 |
| Price_Import_Intra_EU_Honey_EUR_Kg |
100.00%
|
90.00%
|
3.61 | 3.41 |
| Price_Import_Extra_EU_Honey_EUR_Kg |
100.00%
|
90.00%
|
2.19 | 2.11 |
| Avg_Export_Price_EUR |
100.00%
|
100.00%
|
3.61 | 3.61 |
| Price_Export_Intra_EU_Honey_EUR_Kg |
100.00%
|
100.00%
|
3.39 | 3.39 |
| Price_Export_Extra_EU_Honey_EUR_Kg |
100.00%
|
90.00%
|
5.76 | 5.45 |
| Avg_Price_Import_Export_Intra_EU_Honey |
100.00%
|
80.00%
|
3.55 | 3.4 |
| Avg_ Price_Import_Export_Extra_EU_Honey |
100.00%
|
90.00%
|
3.92 | 3.78 |
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aHoney Import Export Country
Table 18. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | HNYMR172.HNYMP550.0 |
| Name | Honey Import Export Country |
| Type | File |
| Licence | CC BY-NC 4.0 |
| Description | Noa Simón Delso became Scientific Director and Project Manager at BeeLife at the beginning of 2021. She holds a PhD in Agricultural Science and Bioengineering from the Université Catholique de Louvain (Belgium), an MSc in Economy, Management and Consumer Studies from Wageningen University (the Netherlands) and she is a DVM from the University of León (Spain). In her scientific career, Noa has specialised in environmental toxicology, particularly on bees, environmental policy and honey bee health, fields in which she has published several papers in peer-reviewed international journals in the field of environmental research, health and toxicology. In 2019 she started diversifying her activities, evolving towards the implementation of data science to pollinators health. In parallel, she has provided technical assistance to Belgian and European beekeepers and decision makers. Since 2009, she has advised in scientific-technical dossiers to the European organisation BeeLife, following the evolution and implementation of European legislation on the subject of pesticide authorisation, agricultural and environmental policy. During this time, she developed great expertise in the regulatory framework and policies related to pollinator health and conservation. More on: https://www.researchgate.net/profile/Noa-Simon-Delso |
n/a
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).
| Name | Description | Data type | Descriptor | Unit |
|---|---|---|---|---|
| INDICATOR | String | Text [0.0.TEXTA315] | n/a |
|
| COUNTRY | String | Text [0.0.TEXTA315] | n/a |
|
| 2014 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2015 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2016 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2017 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2018 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2019 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2020 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2021 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2022 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2023 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| 2024 | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Comments on data | String | Text [0.0.TEXTA315] | n/a |
|
| Avg_10_years | Decimal number | DecimalNumber [0.0.DCMLN314] | n/a |
|
| Nat_Avg_Price_10_years | Decimal number | DecimalNumber [0.0.DCMLN314] | 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INDICATOR | 22 - 40 | n/a | Avg_Export_P… | n/a | n/a | n/a | SUM_Value_Im… | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 13 (7.7%) |
| COUNTRY | 2 - 5 | n/a | AT | n/a | n/a | n/a | Total | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 29 (17.3%) |
| 2014 | 1 - 9 | 6,662,231.173 | 0 | 5.4225 | 51,562.5 | 1,069,319.5 | 302,756,749 | 168 | 2 (1.2%) | 1 (0.6%) | 0 (0.0%) | 165 (98.2%) |
| 2015 | 1 - 9 | 8,355,338.623 | 1.29 | 5.835 | 78,419 | 1,525,281.5 | 408,037,367 | 168 | 3 (1.8%) | 0 (0.0%) | 0 (0.0%) | 166 (98.8%) |
| 2016 | 1 - 9 | 7,792,491.270 | 1 | 5.985 | 65,243.5 | 1,599,282.25 | 350,913,497 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 167 (99.4%) |
| 2017 | 1 - 9 | 8,126,952.683 | 1 | 5.9025 | 138,863 | 1,883,552 | 370,318,942 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 164 (97.6%) |
| 2018 | 1 - 9 | 7,996,799.962 | 0 | 5.545 | 104,478 | 1,728,779.25 | 367,800,363 | 168 | 2 (1.2%) | 1 (0.6%) | 0 (0.0%) | 162 (96.4%) |
| 2019 | 1 - 9 | 7,585,079.637 | 0 | 6.1125 | 108,058 | 2,015,424.25 | 334,606,134 | 168 | 2 (1.2%) | 1 (0.6%) | 0 (0.0%) | 164 (97.6%) |
| 2020 | 1 - 9 | 8,741,118.725 | 0 | 6.025 | 203,206 | 2,908,547.25 | 358,558,663 | 168 | 2 (1.2%) | 1 (0.6%) | 0 (0.0%) | 165 (98.2%) |
| 2021 | 3 - 9 | 8,954,607.167 | 1.53 | 6.4675 | 146,253 | 3,699,308.75 | 406,804,655 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 166 (98.8%) |
| 2022 | 2 - 9 | 10,378,246.953 | 1.58 | 7.2125 | 225,630 | 3,305,232 | 504,379,115 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 166 (98.8%) |
| 2023 | 1 - 9 | 8,259,614.577 | 1.21 | 6.8 | 165,017.5 | 3,178,753.75 | 359,311,494 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 166 (98.8%) |
| 2024 | 4 - 4 | 5.740 | 5.74 | n/a | n/a | n/a | 5.74 | 168 | 167 (99.4%) | 0 (0.0%) | 0 (0.0%) | 2 (1.2%) |
| Comments on data | 0 - 158 | n/a | (incl. Iles… | n/a | n/a | n/a | 168 | 132 (78.6%) | 6 (3.6%) | 0 (0.0%) | 7 (4.2%) | |
| Avg_10_years | 2 - 10 | 8,240,747.590 | 1.43 | 6.0975 | 172,133.85 | 2,401,279.25 | 376,348,698 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 165 (98.2%) |
| Nat_Avg_Price_10_years | 3 - 5 | 5.765 | 1.39 | 2.1725 | 4.745 | 6.57 | 24.25 | 168 | 112 (66.7%) | 0 (0.0%) | 0 (0.0%) | 55 (32.7%) |
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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| INDICATOR |
100.00%
|
7.74%
|
National_Value_Import_Extra_Honey_EUR | SUM_Value_Import_Extra_Honey_EUR |
| COUNTRY |
100.00%
|
17.26%
|
AT | Total |
| 2014 |
98.81%
|
98.21%
|
n/a | 7543265 |
| 2015 |
98.21%
|
98.81%
|
n/a | 9258202 |
| 2016 |
100.00%
|
99.40%
|
8 | 7189253 |
| 2017 |
100.00%
|
97.62%
|
1.61 | 8829138 |
| 2018 |
98.81%
|
96.43%
|
n/a | 7582970 |
| 2019 |
98.81%
|
97.62%
|
n/a | 8064910 |
| 2020 |
98.81%
|
98.21%
|
n/a | 6729068 |
| 2021 |
100.00%
|
98.81%
|
1.82 | 6157184 |
| 2022 |
100.00%
|
98.81%
|
4.63 | 7433389 |
| 2023 |
100.00%
|
98.81%
|
1.87 | 6370210 |
| 2024 |
0.60%
|
1.19%
|
n/a | 5.74 |
| Comments on data |
21.43%
|
4.17%
|
n/a | (incl. Luxembourg 'LU' -> 1998) |
| Avg_10_years |
100.00%
|
98.21%
|
2.28 | 7515759 |
| Nat_Avg_Price_10_years |
33.33%
|
32.74%
|
n/a | 2.76 |
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aEU Honey Bee colonies
Table 22. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | HNYMR172.HNYBC551.0 |
| Name | EU Honey Bee colonies |
| Type | File |
| Licence | CC BY-NC 4.0 |
| Description | Noa Simón Delso became Scientific Director and Project Manager at BeeLife at the beginning of 2021. She holds a PhD in Agricultural Science and Bioengineering from the Université Catholique de Louvain (Belgium), an MSc in Economy, Management and Consumer Studies from Wageningen University (the Netherlands) and she is a DVM from the University of León (Spain). In her scientific career, Noa has specialised in environmental toxicology, particularly on bees, environmental policy and honey bee health, fields in which she has published several papers in peer-reviewed international journals in the field of environmental research, health and toxicology. In 2019 she started diversifying her activities, evolving towards the implementation of data science to pollinators health. In parallel, she has provided technical assistance to Belgian and European beekeepers and decision makers. Since 2009, she has advised in scientific-technical dossiers to the European organisation BeeLife, following the evolution and implementation of European legislation on the subject of pesticide authorisation, agricultural and environmental policy. During this time, she developed great expertise in the regulatory framework and policies related to pollinator health and conservation. More on: https://www.researchgate.net/profile/Noa-Simon-Delso |
n/a
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).
| Name | Description | Data type | Descriptor | Unit |
|---|---|---|---|---|
| Country | Country | String | iso3166:alpha-2CountryCode [0.0.LPHCN4] | n/a |
| Year | Year | Integer number | iso8601:calendarYear [0.0.CLNDR340] | year |
| Number_colonies | Number of colonies | Integer number | Integer [0.0.NTGER313] | 1000u |
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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Country | 2 - 2 | n/a | AT | n/a | n/a | n/a | SK | 84 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 28 (33.3%) |
| Year | 4 - 4 | 2,021.0 | 2,020 | 2,020 | 2,021 | 2,022 | 2,022 | 84 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 3 (3.6%) |
| Number_colonies | 1 - 5 | 1,410.9 | 5 | 82 | 390.5 | 1,525 | 20,270 | 84 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 74 (88.1%) |
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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Country |
100.00%
|
33.33%
|
AT | AT |
| Year |
100.00%
|
3.57%
|
2020 | 2020 |
| Number_colonies |
100.00%
|
88.10%
|
179 | 426 |
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aHoney Production Costs
Table 26. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| UID | HNYMR172.HNYPR552.0 |
| Name | Honey Production Costs |
| Type | File |
| Licence | CC BY-NC 4.0 |
| Description | Noa Simón Delso became Scientific Director and Project Manager at BeeLife at the beginning of 2021. She holds a PhD in Agricultural Science and Bioengineering from the Université Catholique de Louvain (Belgium), an MSc in Economy, Management and Consumer Studies from Wageningen University (the Netherlands) and she is a DVM from the University of León (Spain). In her scientific career, Noa has specialised in environmental toxicology, particularly on bees, environmental policy and honey bee health, fields in which she has published several papers in peer-reviewed international journals in the field of environmental research, health and toxicology. In 2019 she started diversifying her activities, evolving towards the implementation of data science to pollinators health. In parallel, she has provided technical assistance to Belgian and European beekeepers and decision makers. Since 2009, she has advised in scientific-technical dossiers to the European organisation BeeLife, following the evolution and implementation of European legislation on the subject of pesticide authorisation, agricultural and environmental policy. During this time, she developed great expertise in the regulatory framework and policies related to pollinator health and conservation. More on: https://www.researchgate.net/profile/Noa-Simon-Delso |
n/a
Metadata
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).
| Name | Description | Data type | Descriptor | Unit |
|---|---|---|---|---|
| Source | Source | String | Text [0.0.TEXTA315] | n/a |
| Country | Country | String | dwc:country [0.0.DWCCN159] | n/a |
| Nb_BK_150_or_more | Number of beekeepers with 150 colonies or more | Integer number | Integer [0.0.NTGER313] | n/a |
| Nb_hives_by_150_or_more | Number of hives held by beekeepers with 150 hives and more | Integer number | Integer [0.0.NTGER313] | n/a |
| Avg_Price_Jar_EUR_kg | Average Price sold in Jars (EUR/Kg) | Integer number | Integer [0.0.NTGER313] | EUR kg-1 |
| Min_Price_Jar_EUR_kg | Minimum Price sold in Jars (EUR/Kg) | Decimal number | DecimalNumber [0.0.DCMLN314] | EUR kg-1 |
| Max_Price_Jar_EUR_kg | Maximum Price sold in Jars (EUR/Kg) | Decimal number | DecimalNumber [0.0.DCMLN314] | EUR kg-1 |
| Avg_Price_Drum_EUR_kg | Average Price sold in Drums (EUR/Kg) | Decimal number | DecimalNumber [0.0.DCMLN314] | EUR kg-1 |
| Min_Price_Drum_EUR_kg | Minimum Price sold in Drums (EUR/Kg) | Decimal number | DecimalNumber [0.0.DCMLN314] | EUR kg-1 |
| Max_Price_Drum_EUR_kg | Maximum Price sold in Drums (EUR/Kg) | Decimal number | DecimalNumber [0.0.DCMLN314] | EUR kg-1 |
| Production_kg_colony_year | Honey Production (kg/colony) | Integer number | Integer [0.0.NTGER313] | kg |
| Avg_Cost__EUR_kg | Average Cost of production (EUR/Kg) | Decimal number | DecimalNumber [0.0.DCMLN314] | EUR kg-1 |
| Avg_Cost_EUR_SUP_Avg_Price_Drums | Average Cost of production/Average Price sold in Drums | String | Text [0.0.TEXTA315] | n/a |
| Nb_Beekeepers | Number of beekeepers | Integer number | Integer [0.0.NTGER313] | n/a |
Metadata of individual tables can be found in Annex 1 .
Descriptive Measures
Table 28. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Source | 96 - 125 | n/a | https://agri… | n/a | n/a | n/a | https://agri… | 27 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 2 (7.4%) |
| Country | 2 - 2 | n/a | AT | n/a | n/a | n/a | SK | 27 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 27 (100.0%) |
| Nb_BK_150_or_more | 1 - 4 | 666.1 | 3 | 42 | 129 | 1,334 | 3,390 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 26 (96.3%) |
| Nb_hives_by_150_or_more | 0 - 7 | n/a | 1182 | n/a | n/a | n/a | error | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 26 (96.3%) |
| Avg_Price_Jar_EUR_kg | 1 - 5 | 8.755 | 2.25 | 5.655 | 7.76 | 11.2 | 19.25 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 25 (92.6%) |
| Min_Price_Jar_EUR_kg | 1 - 5 | 6.265 | 1.72 | 3.965 | 4.72 | 9.3 | 17.6 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 22 (81.5%) |
| Max_Price_Jar_EUR_kg | 1 - 5 | 12.093 | 2.79 | 7.335 | 12 | 15 | 30 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 23 (85.2%) |
| Avg_Price_Drum_EUR_kg | 1 - 5 | 5.273 | 1.82 | 3.065 | 4.78 | 6.3 | 14.31 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 26 (96.3%) |
| Min_Price_Drum_EUR_kg | 1 - 4 | 4.049 | 1.28 | 2.36 | 3.8 | 5.425 | 9 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 24 (88.9%) |
| Max_Price_Drum_EUR_kg | 1 - 4 | 6.910 | 1.93 | 4.61 | 7 | 8.1 | 20 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 24 (88.9%) |
| Production_kg_colony_year | 1 - 2 | 21.1 | 5 | 15 | 20 | 25.5 | 47 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 18 (66.7%) |
| Avg_Cost__EUR_kg | 1 - 4 | 4.615 | 1.3 | 2.595 | 3.75 | 7.05 | 10 | 27 | 1 (3.7%) | 0 (0.0%) | 0 (0.0%) | 27 (100.0%) |
| Avg_Cost_EUR_SUP_Avg_Price_Drums | 0 - 3 | n/a | lim | n/a | n/a | n/a | yes | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 4 (14.8%) |
| Nb_Beekeepers | 3 - 6 | 22,237.8 | 230 | 4,257.5 | 9,266 | 26,453 | 116,000 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 26 (96.3%) |
Quality Measures
Table 29. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Source |
100.00%
|
7.41%
|
https://agriculture.ec.europa.eu/farming/animal-products/honey/national-apiculture-programmes_en | https://agriculture.ec.europa.eu/document/download/f711567c-b9ae-4d3c-b1bd-52aab6fb4574_fr?filename=nap-be_fr.pdf&prefLang=en |
| Country |
100.00%
|
100.00%
|
AT | AT |
| Nb_BK_150_or_more |
92.59%
|
96.30%
|
423 | 423 |
| Nb_hives_by_150_or_more |
92.59%
|
96.30%
|
n/a | 80165 |
| Avg_Price_Jar_EUR_kg |
92.59%
|
92.59%
|
10.5 | 13 |
| Min_Price_Jar_EUR_kg |
92.59%
|
81.48%
|
4 | 7 |
| Max_Price_Jar_EUR_kg |
92.59%
|
85.19%
|
15 | 14 |
| Avg_Price_Drum_EUR_kg |
92.59%
|
96.30%
|
n/a | 5.5 |
| Min_Price_Drum_EUR_kg |
92.59%
|
88.89%
|
4 | 7 |
| Max_Price_Drum_EUR_kg |
92.59%
|
88.89%
|
7 | 12 |
| Production_kg_colony_year |
92.59%
|
66.67%
|
20 | 17 |
| Avg_Cost__EUR_kg |
96.30%
|
100.00%
|
4.05 | 4.05 |
| Avg_Cost_EUR_SUP_Avg_Price_Drums |
92.59%
|
14.81%
|
no | n/a |
| Nb_Beekeepers |
92.59%
|
96.30%
|
29745 | 29745 |
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aReferences
There are no sources in the current document.
Annexes
Annex 1: Table column reports
Number of beekeepers in the EU
Country
Table 30. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Country |
| Description | Country |
| Data type | String |
| Descriptor |
iso3166:alpha-2CountryCode
0.0.LPHCN4 |
| Unit | n/a |
Table 31. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Country | 2 - 2 | n/a | AT | n/a | n/a | n/a | SK | 54 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 27 (50.0%) |
Table 32. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Country |
100.00%
|
50.00%
|
AT | AT |
Completeness
Figure 1. Visualization of completeness of the data in the column.
Uniqueness
Figure 2. Visualization of uniqueness of the data in the column.
Year
Table 33. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Year |
| Description | Year |
| Data type | Integer number |
| Descriptor |
iso8601:calendarYear
0.0.CLNDR340 |
| Unit | year |
Table 34. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Year | 4 - 4 | 2,020.5 | 2,019 | 2,019 | 2,020.5 | 2,022 | 2,022 | 54 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 2 (3.7%) |
Table 35. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Year |
100.00%
|
3.70%
|
2019 | 2019 |
Data Distribution Top 20
Figure 3. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 4. Distribution of values in the column.
Outliers
Figure 5. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 6. Visualization of completeness of the data in the column.
Uniqueness
Figure 7. Visualization of uniqueness of the data in the column.
Number_beekeepers
Table 36. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Number_beekeepers |
| Description | Number of beekeepers |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 37. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Number_beekeepers | 3 - 6 | n/a | 234 | n/a | n/a | n/a | N/A | 54 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 53 (98.1%) |
Table 38. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Number_beekeepers |
100.00%
|
98.15%
|
7000 | 29745 |
Completeness
Figure 8. Visualization of completeness of the data in the column.
Uniqueness
Figure 9. Visualization of uniqueness of the data in the column.
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aRel Diff Production Cost
Production_Cost_Type
Table 39. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Production_Cost_Type |
| Description | Production Cost Type |
| Data type | String |
| Descriptor |
Text
0.0.TEXTA315 |
| Unit | n/a |
Table 40. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Production_Cost_Type | 3 - 6 | n/a | Feed | n/a | n/a | n/a | Vet | 12 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 4 (33.3%) |
Table 41. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Production_Cost_Type |
100.00%
|
33.33%
|
Fuel | Fuel |
Completeness
Figure 10. Visualization of completeness of the data in the column.
Uniqueness
Figure 11. Visualization of uniqueness of the data in the column.
Source
Table 42. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Source |
| Description | Source of data |
| Data type | String |
| Descriptor |
Text
0.0.TEXTA315 |
| Unit | n/a |
Table 43. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Source | 8 - 40 | n/a | Copa-Cogeca… | n/a | n/a | n/a | Eurostat | 12 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 3 (25.0%) |
Table 44. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Source |
100.00%
|
25.00%
|
Copa-Cogeca Survey – Honey Working Group | EU Commission |
Data Distribution Top 20
Figure 12. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 13. Visualization of completeness of the data in the column.
Uniqueness
Figure 14. Visualization of uniqueness of the data in the column.
Year
Table 45. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Year |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 46. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Year | 4 - 4 | 2,022.0 | 2,021 | 2,021 | 2,022 | 2,023 | 2,023 | 12 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 3 (25.0%) |
Table 47. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Year |
100.00%
|
25.00%
|
2021 | 2021 |
Data Distribution Top 20
Figure 15. Distribution of 20 most common values, from highest to lowest.
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.
Absolute
Table 48. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Absolute |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 49. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Absolute | 6 - 7 | 4,692.468 | 1,417.92 | 1,633.305 | 4,709.305 | 7,765.215 | 7,889.34 | 12 | 6 (50.0%) | 0 (0.0%) | 0 (0.0%) | 7 (58.3%) |
Table 50. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Absolute |
50.00%
|
58.33%
|
n/a | 1417.92 |
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.
Relative differences
Table 51. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Relative differences |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 52. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Relative differences | 1 - 5 | 17.342 | -3.53 | 0 | 9 | 38.37 | 62 | 12 | 0 (0.0%) | 4 (33.3%) | 0 (0.0%) | 9 (75.0%) |
Table 53. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Relative differences |
100.00%
|
75.00%
|
0 | 27.48 |
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.
Link
Table 54. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Link |
| Description | |
| Data type | String |
| Descriptor |
Text
0.0.TEXTA315 |
| Unit | n/a |
Table 55. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link | 23 - 68 | n/a | https://copa… | n/a | n/a | n/a | https://ener… | 12 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 3 (25.0%) |
Table 56. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Link |
100.00%
|
25.00%
|
https://copa-cogeca.eu/ | https://energy.ec.europa.eu/data-and-analysis/weekly-oil-bulletin_en |
Data Distribution Top 20
Figure 28. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 29. Visualization of completeness of the data in the column.
Uniqueness
Figure 30. Visualization of uniqueness of the data in the column.
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aHoney Imports non-EU Honey
Year
Table 57. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Year |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 58. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Year | 4 - 4 | 2,018.5 | 2,014 | 2,015.75 | 2,018.5 | 2,021.25 | 2,023 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 59. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Year |
100.00%
|
100.00%
|
2014 | 2014 |
Continuous Data Distribution
Figure 31. Distribution of values in the column.
Outliers
Figure 32. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 33. Visualization of completeness of the data in the column.
Uniqueness
Figure 34. Visualization of uniqueness of the data in the column.
TOTAL_Qt_Import_Honey_Kg
Table 60. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | TOTAL_Qt_Import_Honey_Kg |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 61. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TOTAL_Qt_Import_Honey_Kg | 9 - 9 | 303,215,272.7 | 272,422,062 | 290,194,861 | 297,577,522.5 | 321,113,082.75 | 340,295,675 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 62. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| TOTAL_Qt_Import_Honey_Kg |
100.00%
|
100.00%
|
272422062 | 272422062 |
Continuous Data Distribution
Figure 35. Distribution of values in the column.
Outliers
Figure 36. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 37. Visualization of completeness of the data in the column.
Uniqueness
Figure 38. Visualization of uniqueness of the data in the column.
TOTAL_Qt_Import_Honey_tons
Table 63. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | TOTAL_Qt_Import_Honey_tons |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 64. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TOTAL_Qt_Import_Honey_tons | 8 - 9 | 303,215.272 | 272,422.06 | 290,194.86 | 297,577.52 | 321,113.085 | 340,295.68 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 65. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| TOTAL_Qt_Import_Honey_tons |
100.00%
|
100.00%
|
272422.06 | 272422.06 |
Continuous Data Distribution
Figure 39. Distribution of values in the column.
Outliers
Figure 40. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 41. Visualization of completeness of the data in the column.
Uniqueness
Figure 42. Visualization of uniqueness of the data in the column.
Qt_Import_Intra_EU_Kg
Table 66. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Import_Intra_EU_Kg |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 67. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Import_Intra_EU_Kg | 9 - 9 | 136,982,929.0 | 127,607,782 | 128,947,220.5 | 134,373,794 | 146,793,354.25 | 149,850,638 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 68. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Import_Intra_EU_Kg |
100.00%
|
100.00%
|
129186641 | 129186641 |
Continuous Data Distribution
Figure 43. Distribution of values in the column.
Outliers
Figure 44. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 45. Visualization of completeness of the data in the column.
Uniqueness
Figure 46. Visualization of uniqueness of the data in the column.
Qt_Import_Extra_EU_Kg
Table 69. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Import_Extra_EU_Kg |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 70. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Import_Extra_EU_Kg | 9 - 9 | 166,232,343.7 | 143,235,421 | 161,580,840 | 163,471,662.5 | 173,782,847.5 | 190,445,037 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 71. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Import_Extra_EU_Kg |
100.00%
|
100.00%
|
143235421 | 143235421 |
Continuous Data Distribution
Figure 47. Distribution of values in the column.
Outliers
Figure 48. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 49. Visualization of completeness of the data in the column.
Uniqueness
Figure 50. Visualization of uniqueness of the data in the column.
Qt_Import_Intra_EU_tons
Table 72. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Import_Intra_EU_tons |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 73. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Import_Intra_EU_tons | 6 - 6 | 136,983.0 | 127,608 | 128,947 | 134,373.5 | 146,793.5 | 149,851 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 74. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Import_Intra_EU_tons |
100.00%
|
100.00%
|
129187 | 129187 |
Continuous Data Distribution
Figure 51. Distribution of values in the column.
Outliers
Figure 52. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 53. Visualization of completeness of the data in the column.
Uniqueness
Figure 54. Visualization of uniqueness of the data in the column.
Qt_Import_Extra_EU_tons
Table 75. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Import_Extra_EU_tons |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 76. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Import_Extra_EU_tons | 6 - 6 | 166,232.3 | 143,235 | 161,580.5 | 163,472 | 173,782.5 | 190,445 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 77. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Import_Extra_EU_tons |
100.00%
|
100.00%
|
143235 | 143235 |
Continuous Data Distribution
Figure 55. Distribution of values in the column.
Outliers
Figure 56. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 57. Visualization of completeness of the data in the column.
Uniqueness
Figure 58. Visualization of uniqueness of the data in the column.
Proportion_ Import_Intra_from_total
Table 78. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Proportion_ Import_Intra_from_total |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 79. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Proportion_ Import_Intra_from_total | 4 - 4 | 0.451 | 0.44 | 0.44 | 0.45 | 0.46 | 0.47 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 4 (40.0%) |
Table 80. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Proportion_ Import_Intra_from_total |
100.00%
|
40.00%
|
0.44 | 0.47 |
Continuous Data Distribution
Figure 59. Distribution of values in the column.
Outliers
Figure 60. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 61. Visualization of completeness of the data in the column.
Uniqueness
Figure 62. Visualization of uniqueness of the data in the column.
Proportion_Import_Extra_from_total
Table 81. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Proportion_Import_Extra_from_total |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 82. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Proportion_Import_Extra_from_total | 4 - 4 | 0.549 | 0.53 | 0.54 | 0.55 | 0.56 | 0.56 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 4 (40.0%) |
Table 83. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Proportion_Import_Extra_from_total |
100.00%
|
40.00%
|
0.56 | 0.53 |
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.
Ratio_Import_Intra_Extra
Table 84. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Ratio_Import_Intra_Extra |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 85. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ratio_Import_Intra_Extra | 3 - 4 | 0.825 | 0.79 | 0.79 | 0.825 | 0.8425 | 0.9 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 7 (70.0%) |
Table 86. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Ratio_Import_Intra_Extra |
100.00%
|
70.00%
|
0.79 | 0.9 |
Continuous Data Distribution
Figure 67. Distribution of values in the column.
Outliers
Figure 68. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 69. Visualization of completeness of the data in the column.
Uniqueness
Figure 70. Visualization of uniqueness of the data in the column.
TOTAL_Qt_Export_Honey_Kg
Table 87. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | TOTAL_Qt_Export_Honey_Kg |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 88. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TOTAL_Qt_Export_Honey_Kg | 9 - 9 | 168,783,806.2 | 153,648,562 | 155,855,760.75 | 162,423,634 | 184,895,972 | 195,427,843 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 89. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| TOTAL_Qt_Export_Honey_Kg |
100.00%
|
100.00%
|
153648562 | 153648562 |
Continuous Data Distribution
Figure 71. Distribution of values in the column.
Outliers
Figure 72. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 73. Visualization of completeness of the data in the column.
Uniqueness
Figure 74. Visualization of uniqueness of the data in the column.
TOTAL_Qt_Export_Honey_tons
Table 90. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | TOTAL_Qt_Export_Honey_tons |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 91. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TOTAL_Qt_Export_Honey_tons | 8 - 9 | 168,783.807 | 153,648.56 | 155,855.7625 | 162,423.635 | 184,895.975 | 195,427.84 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 92. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| TOTAL_Qt_Export_Honey_tons |
100.00%
|
100.00%
|
153648.56 | 153648.56 |
Continuous Data Distribution
Figure 75. Distribution of values in the column.
Outliers
Figure 76. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 77. Visualization of completeness of the data in the column.
Uniqueness
Figure 78. Visualization of uniqueness of the data in the column.
Qt_Export_Intra_EU_Kg
Table 93. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Export_Intra_EU_Kg |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 94. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Export_Intra_EU_Kg | 9 - 9 | 146,469,092.0 | 134,197,343 | 136,552,454 | 142,999,579.5 | 158,424,920 | 170,002,307 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 95. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Export_Intra_EU_Kg |
100.00%
|
100.00%
|
137071341 | 137071341 |
Continuous Data Distribution
Figure 79. Distribution of values in the column.
Outliers
Figure 80. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 81. Visualization of completeness of the data in the column.
Uniqueness
Figure 82. Visualization of uniqueness of the data in the column.
Qt_Export_Extra_EU_Kg
Table 96. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Export_Extra_EU_Kg |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 97. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Export_Extra_EU_Kg | 8 - 8 | 22,314,714.2 | 16,577,221 | 19,098,418 | 21,524,037 | 25,130,435 | 30,788,004 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 98. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Export_Extra_EU_Kg |
100.00%
|
100.00%
|
16577221 | 16577221 |
Continuous Data Distribution
Figure 83. Distribution of values in the column.
Outliers
Figure 84. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 85. Visualization of completeness of the data in the column.
Uniqueness
Figure 86. Visualization of uniqueness of the data in the column.
Qt_Export_Intra_EU_tons
Table 99. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Export_Intra_EU_tons |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 100. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Export_Intra_EU_tons | 6 - 6 | 146,469.0 | 134,197 | 136,552.25 | 142,999.5 | 158,424.75 | 170,002 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 101. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Export_Intra_EU_tons |
100.00%
|
100.00%
|
137071 | 137071 |
Continuous Data Distribution
Figure 87. Distribution of values in the column.
Outliers
Figure 88. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 89. Visualization of completeness of the data in the column.
Uniqueness
Figure 90. Visualization of uniqueness of the data in the column.
Qt_Export_Extra_EU_tons
Table 102. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Export_Extra_EU_tons |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 103. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Export_Extra_EU_tons | 5 - 5 | 22,314.8 | 16,577 | 19,098.75 | 21,524 | 25,130.5 | 30,788 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 104. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Export_Extra_EU_tons |
100.00%
|
100.00%
|
16577 | 16577 |
Continuous Data Distribution
Figure 91. Distribution of values in the column.
Outliers
Figure 92. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 93. Visualization of completeness of the data in the column.
Uniqueness
Figure 94. Visualization of uniqueness of the data in the column.
Proportion_ Export_Intra_from_total
Table 105. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Proportion_ Export_Intra_from_total |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 106. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Proportion_ Export_Intra_from_total | 4 - 4 | 0.868 | 0.84 | 0.8575 | 0.87 | 0.8825 | 0.89 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 6 (60.0%) |
Table 107. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Proportion_ Export_Intra_from_total |
100.00%
|
60.00%
|
0.87 | 0.88 |
Continuous Data Distribution
Figure 95. Distribution of values in the column.
Outliers
Figure 96. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 97. Visualization of completeness of the data in the column.
Uniqueness
Figure 98. Visualization of uniqueness of the data in the column.
Proportion_Export_Extra_from_total
Table 108. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Proportion_Export_Extra_from_total |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 109. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Proportion_Export_Extra_from_total | 4 - 4 | 0.132 | 0.11 | 0.1175 | 0.13 | 0.1425 | 0.16 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 6 (60.0%) |
Table 110. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Proportion_Export_Extra_from_total |
100.00%
|
60.00%
|
0.13 | 0.12 |
Continuous Data Distribution
Figure 99. Distribution of values in the column.
Outliers
Figure 100. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 101. Visualization of completeness of the data in the column.
Uniqueness
Figure 102. Visualization of uniqueness of the data in the column.
Ratio_Export_Intra_Extra
Table 111. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Ratio_Export_Intra_Extra |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 112. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ratio_Export_Intra_Extra | 4 - 4 | 6.720 | 5.15 | 5.9975 | 6.68 | 7.4775 | 8.27 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 113. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Ratio_Export_Intra_Extra |
100.00%
|
100.00%
|
8.27 | 8.27 |
Continuous Data Distribution
Figure 103. Distribution of values in the column.
Outliers
Figure 104. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 105. Visualization of completeness of the data in the column.
Uniqueness
Figure 106. Visualization of uniqueness of the data in the column.
Qt_Difference_Export_Import_Intra
Table 114. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Qt_Difference_Export_Import_Intra |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 115. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qt_Difference_Export_Import_Intra | 7 - 8 | 9,486,163.0 | 2,075,411 | 4,286,855.75 | 8,226,104.5 | 13,531,551.25 | 22,253,101 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 116. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Qt_Difference_Export_Import_Intra |
100.00%
|
100.00%
|
7884700 | 7884700 |
Continuous Data Distribution
Figure 107. Distribution of values in the column.
Outliers
Figure 108. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 109. Visualization of completeness of the data in the column.
Uniqueness
Figure 110. Visualization of uniqueness of the data in the column.
QT_Difference_Export_Import_Extra
Table 117. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | QT_Difference_Export_Import_Extra |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 118. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| QT_Difference_Export_Import_Extra | 10 - 10 | -143,917,629.5 | -165,412,969 | -147,974,045.25 | -143,234,474 | -138,550,681.75 | -126,658,200 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 119. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| QT_Difference_Export_Import_Extra |
100.00%
|
100.00%
|
-126658200 | -126658200 |
Continuous Data Distribution
Figure 111. Distribution of values in the column.
Outliers
Figure 112. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 113. Visualization of completeness of the data in the column.
Uniqueness
Figure 114. Visualization of uniqueness of the data in the column.
TOTAL_Value_Import_Honey_EUR
Table 120. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | TOTAL_Value_Import_Honey_EUR |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 121. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TOTAL_Value_Import_Honey_EUR | 9 - 10 | 857,511,725.6 | 743,731,511 | 792,753,767.75 | 837,038,436 | 892,399,997.75 | 1,065,958,120 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 122. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| TOTAL_Value_Import_Honey_EUR |
100.00%
|
100.00%
|
743731511 | 743731511 |
Continuous Data Distribution
Figure 115. Distribution of values in the column.
Outliers
Figure 116. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 117. Visualization of completeness of the data in the column.
Uniqueness
Figure 118. Visualization of uniqueness of the data in the column.
Value_Import_Intra_EU_EUR
Table 123. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Value_Import_Intra_EU_EUR |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 124. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Value_Import_Intra_EU_EUR | 9 - 9 | 481,163,027.7 | 437,264,813 | 446,844,598.75 | 470,915,919 | 512,959,627.5 | 561,579,005 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 125. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Value_Import_Intra_EU_EUR |
100.00%
|
100.00%
|
440974762 | 440974762 |
Continuous Data Distribution
Figure 119. Distribution of values in the column.
Outliers
Figure 120. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 121. Visualization of completeness of the data in the column.
Uniqueness
Figure 122. Visualization of uniqueness of the data in the column.
Value_Import_Extra_EU_EUR
Table 126. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Value_Import_Extra_EU_EUR |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 127. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Value_Import_Extra_EU_EUR | 9 - 9 | 376,348,697.9 | 302,756,749 | 346,836,656.25 | 363,555,928.5 | 407,112,833 | 504,379,115 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 128. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Value_Import_Extra_EU_EUR |
100.00%
|
100.00%
|
302756749 | 302756749 |
Continuous Data Distribution
Figure 123. Distribution of values in the column.
Outliers
Figure 124. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 125. Visualization of completeness of the data in the column.
Uniqueness
Figure 126. Visualization of uniqueness of the data in the column.
TOTAL_Value_Export_Honey_EUR
Table 129. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | TOTAL_Value_Export_Honey_EUR |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 130. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TOTAL_Value_Export_Honey_EUR | 9 - 9 | 636,579,118.3 | 554,974,534 | 590,507,562 | 623,219,302 | 679,220,471.25 | 738,026,692 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 131. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| TOTAL_Value_Export_Honey_EUR |
100.00%
|
100.00%
|
554974534 | 554974534 |
Continuous Data Distribution
Figure 127. Distribution of values in the column.
Outliers
Figure 128. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 129. Visualization of completeness of the data in the column.
Uniqueness
Figure 130. Visualization of uniqueness of the data in the column.
Value_Export_Intra_EU_EUR
Table 132. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Value_Export_Intra_EU_EUR |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 133. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Value_Export_Intra_EU_EUR | 9 - 9 | 509,866,018.5 | 464,578,855 | 471,844,243.25 | 497,470,831.5 | 541,384,696.75 | 591,211,796 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 134. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Value_Export_Intra_EU_EUR |
100.00%
|
100.00%
|
464578855 | 464578855 |
Continuous Data Distribution
Figure 131. Distribution of values in the column.
Outliers
Figure 132. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 133. Visualization of completeness of the data in the column.
Uniqueness
Figure 134. Visualization of uniqueness of the data in the column.
Value_Export_Extra_EU_EU
Table 135. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Value_Export_Extra_EU_EU |
| Description | |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 136. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Value_Export_Extra_EU_EU | 8 - 9 | 126,713,099.8 | 90,395,679 | 109,861,379.5 | 122,164,332.5 | 147,810,761.25 | 161,577,868 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 137. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Value_Export_Extra_EU_EU |
100.00%
|
100.00%
|
90395679 | 90395679 |
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.
Avg_Import_Price_EUR_Kg
Table 138. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_Import_Price_EUR_Kg |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 139. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_Import_Price_EUR_Kg | 4 - 4 | 2.824 | 2.58 | 2.71 | 2.8 | 2.945 | 3.13 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
Table 140. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_Import_Price_EUR_Kg |
100.00%
|
90.00%
|
2.79 | 2.73 |
Continuous Data Distribution
Figure 139. Distribution of values in the column.
Outliers
Figure 140. Visualization of median, min, max, and outliers 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.
Price_Import_Intra_EU_Honey_EUR_Kg
Table 141. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Price_Import_Intra_EU_Honey_EUR_Kg |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 142. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Price_Import_Intra_EU_Honey_EUR_Kg | 3 - 4 | 3.511 | 3.21 | 3.405 | 3.535 | 3.61 | 3.75 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
Table 143. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Price_Import_Intra_EU_Honey_EUR_Kg |
100.00%
|
90.00%
|
3.61 | 3.41 |
Continuous Data Distribution
Figure 143. Distribution of values in the column.
Outliers
Figure 144. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 145. Visualization of completeness of the data in the column.
Uniqueness
Figure 146. Visualization of uniqueness of the data in the column.
Price_Import_Extra_EU_Honey_EUR_Kg
Table 144. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Price_Import_Extra_EU_Honey_EUR_Kg |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 145. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Price_Import_Extra_EU_Honey_EUR_Kg | 3 - 4 | 2.255 | 2.05 | 2.0975 | 2.195 | 2.38 | 2.65 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
Table 146. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Price_Import_Extra_EU_Honey_EUR_Kg |
100.00%
|
90.00%
|
2.19 | 2.11 |
Continuous Data Distribution
Figure 147. Distribution of values in the column.
Outliers
Figure 148. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 149. Visualization of completeness of the data in the column.
Uniqueness
Figure 150. Visualization of uniqueness of the data in the column.
Avg_Export_Price_EUR
Table 147. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_Export_Price_EUR |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 148. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_Export_Price_EUR | 4 - 4 | 3.771 | 3.49 | 3.6175 | 3.78 | 3.9025 | 4.02 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 149. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_Export_Price_EUR |
100.00%
|
100.00%
|
3.61 | 3.61 |
Continuous Data Distribution
Figure 151. Distribution of values in the column.
Outliers
Figure 152. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 153. Visualization of completeness of the data in the column.
Uniqueness
Figure 154. Visualization of uniqueness of the data in the column.
Price_Export_Intra_EU_Honey_EUR_Kg
Table 150. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Price_Export_Intra_EU_Honey_EUR_Kg |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 151. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Price_Export_Intra_EU_Honey_EUR_Kg | 3 - 4 | 3.484 | 3.14 | 3.375 | 3.495 | 3.6025 | 3.7 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 10 (100.0%) |
Table 152. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Price_Export_Intra_EU_Honey_EUR_Kg |
100.00%
|
100.00%
|
3.39 | 3.39 |
Continuous Data Distribution
Figure 155. Distribution of values in the column.
Outliers
Figure 156. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 157. Visualization of completeness of the data in the column.
Uniqueness
Figure 158. Visualization of uniqueness of the data in the column.
Price_Export_Extra_EU_Honey_EUR_Kg
Table 153. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Price_Export_Extra_EU_Honey_EUR_Kg |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 154. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Price_Export_Extra_EU_Honey_EUR_Kg | 4 - 4 | 5.681 | 5.25 | 5.5475 | 5.735 | 5.795 | 6.07 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
Table 155. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Price_Export_Extra_EU_Honey_EUR_Kg |
100.00%
|
90.00%
|
5.76 | 5.45 |
Continuous Data Distribution
Figure 159. Distribution of values in the column.
Outliers
Figure 160. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 161. Visualization of completeness of the data in the column.
Uniqueness
Figure 162. Visualization of uniqueness of the data in the column.
Avg_Price_Import_Export_Intra_EU_Honey
Table 156. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_Price_Import_Export_Intra_EU_Honey |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 157. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_Price_Import_Export_Intra_EU_Honey | 3 - 4 | 3.499 | 3.18 | 3.39 | 3.55 | 3.575 | 3.73 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 8 (80.0%) |
Table 158. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_Price_Import_Export_Intra_EU_Honey |
100.00%
|
80.00%
|
3.55 | 3.4 |
Continuous Data Distribution
Figure 163. Distribution of values in the column.
Outliers
Figure 164. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 165. Visualization of completeness of the data in the column.
Uniqueness
Figure 166. Visualization of uniqueness of the data in the column.
Avg_ Price_Import_Export_Extra_EU_Honey
Table 159. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_ Price_Import_Export_Extra_EU_Honey |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 160. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_ Price_Import_Export_Extra_EU_Honey | 3 - 4 | 3.969 | 3.65 | 3.87 | 3.945 | 4.065 | 4.36 | 10 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 9 (90.0%) |
Table 161. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_ Price_Import_Export_Extra_EU_Honey |
100.00%
|
90.00%
|
3.92 | 3.78 |
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.
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aHoney Import Export Country
INDICATOR
Table 162. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | INDICATOR |
| Description | |
| Data type | String |
| Descriptor |
Text
0.0.TEXTA315 |
| Unit | n/a |
Table 163. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INDICATOR | 22 - 40 | n/a | Avg_Export_P… | n/a | n/a | n/a | SUM_Value_Im… | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 13 (7.7%) |
Table 164. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| INDICATOR |
100.00%
|
7.74%
|
National_Value_Import_Extra_Honey_EUR | SUM_Value_Import_Extra_Honey_EUR |
Completeness
Figure 171. Visualization of completeness of the data in the column.
Uniqueness
Figure 172. Visualization of uniqueness of the data in the column.
COUNTRY
Table 165. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | COUNTRY |
| Description | |
| Data type | String |
| Descriptor |
Text
0.0.TEXTA315 |
| Unit | n/a |
Table 166. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COUNTRY | 2 - 5 | n/a | AT | n/a | n/a | n/a | Total | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 29 (17.3%) |
Table 167. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| COUNTRY |
100.00%
|
17.26%
|
AT | Total |
Completeness
Figure 173. Visualization of completeness of the data in the column.
Uniqueness
Figure 174. Visualization of uniqueness of the data in the column.
2014
Table 168. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2014 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 169. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2014 | 1 - 9 | 6,662,231.173 | 0 | 5.4225 | 51,562.5 | 1,069,319.5 | 302,756,749 | 168 | 2 (1.2%) | 1 (0.6%) | 0 (0.0%) | 165 (98.2%) |
Table 170. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2014 |
98.81%
|
98.21%
|
n/a | 7543265 |
Continuous Data Distribution
Figure 175. Distribution of values in the column.
Outliers
Figure 176. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 177. Visualization of completeness of the data in the column.
Uniqueness
Figure 178. Visualization of uniqueness of the data in the column.
2015
Table 171. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2015 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 172. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015 | 1 - 9 | 8,355,338.623 | 1.29 | 5.835 | 78,419 | 1,525,281.5 | 408,037,367 | 168 | 3 (1.8%) | 0 (0.0%) | 0 (0.0%) | 166 (98.8%) |
Table 173. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2015 |
98.21%
|
98.81%
|
n/a | 9258202 |
Continuous Data Distribution
Figure 179. Distribution of values in the column.
Outliers
Figure 180. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 181. Visualization of completeness of the data in the column.
Uniqueness
Figure 182. Visualization of uniqueness of the data in the column.
2016
Table 174. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2016 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 175. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2016 | 1 - 9 | 7,792,491.270 | 1 | 5.985 | 65,243.5 | 1,599,282.25 | 350,913,497 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 167 (99.4%) |
Table 176. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2016 |
100.00%
|
99.40%
|
8 | 7189253 |
Continuous Data Distribution
Figure 183. Distribution of values in the column.
Outliers
Figure 184. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 185. Visualization of completeness of the data in the column.
Uniqueness
Figure 186. Visualization of uniqueness of the data in the column.
2017
Table 177. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2017 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 178. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2017 | 1 - 9 | 8,126,952.683 | 1 | 5.9025 | 138,863 | 1,883,552 | 370,318,942 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 164 (97.6%) |
Table 179. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2017 |
100.00%
|
97.62%
|
1.61 | 8829138 |
Continuous Data Distribution
Figure 187. Distribution of values in the column.
Outliers
Figure 188. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 189. Visualization of completeness of the data in the column.
Uniqueness
Figure 190. Visualization of uniqueness of the data in the column.
2018
Table 180. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2018 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 181. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018 | 1 - 9 | 7,996,799.962 | 0 | 5.545 | 104,478 | 1,728,779.25 | 367,800,363 | 168 | 2 (1.2%) | 1 (0.6%) | 0 (0.0%) | 162 (96.4%) |
Table 182. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2018 |
98.81%
|
96.43%
|
n/a | 7582970 |
Continuous Data Distribution
Figure 191. Distribution of values in the column.
Outliers
Figure 192. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 193. Visualization of completeness of the data in the column.
Uniqueness
Figure 194. Visualization of uniqueness of the data in the column.
2019
Table 183. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2019 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 184. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019 | 1 - 9 | 7,585,079.637 | 0 | 6.1125 | 108,058 | 2,015,424.25 | 334,606,134 | 168 | 2 (1.2%) | 1 (0.6%) | 0 (0.0%) | 164 (97.6%) |
Table 185. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2019 |
98.81%
|
97.62%
|
n/a | 8064910 |
Continuous Data Distribution
Figure 195. Distribution of values in the column.
Outliers
Figure 196. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 197. Visualization of completeness of the data in the column.
Uniqueness
Figure 198. Visualization of uniqueness of the data in the column.
2020
Table 186. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2020 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 187. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020 | 1 - 9 | 8,741,118.725 | 0 | 6.025 | 203,206 | 2,908,547.25 | 358,558,663 | 168 | 2 (1.2%) | 1 (0.6%) | 0 (0.0%) | 165 (98.2%) |
Table 188. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2020 |
98.81%
|
98.21%
|
n/a | 6729068 |
Continuous Data Distribution
Figure 199. Distribution of values in the column.
Outliers
Figure 200. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 201. Visualization of completeness of the data in the column.
Uniqueness
Figure 202. Visualization of uniqueness of the data in the column.
2021
Table 189. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2021 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 190. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021 | 3 - 9 | 8,954,607.167 | 1.53 | 6.4675 | 146,253 | 3,699,308.75 | 406,804,655 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 166 (98.8%) |
Table 191. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2021 |
100.00%
|
98.81%
|
1.82 | 6157184 |
Continuous Data Distribution
Figure 203. Distribution of values in the column.
Outliers
Figure 204. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 205. Visualization of completeness of the data in the column.
Uniqueness
Figure 206. Visualization of uniqueness of the data in the column.
2022
Table 192. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2022 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 193. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022 | 2 - 9 | 10,378,246.953 | 1.58 | 7.2125 | 225,630 | 3,305,232 | 504,379,115 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 166 (98.8%) |
Table 194. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2022 |
100.00%
|
98.81%
|
4.63 | 7433389 |
Continuous Data Distribution
Figure 207. Distribution of values in the column.
Outliers
Figure 208. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 209. Visualization of completeness of the data in the column.
Uniqueness
Figure 210. Visualization of uniqueness of the data in the column.
2023
Table 195. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2023 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 196. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023 | 1 - 9 | 8,259,614.577 | 1.21 | 6.8 | 165,017.5 | 3,178,753.75 | 359,311,494 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 166 (98.8%) |
Table 197. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2023 |
100.00%
|
98.81%
|
1.87 | 6370210 |
Continuous Data Distribution
Figure 211. Distribution of values in the column.
Outliers
Figure 212. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 213. Visualization of completeness of the data in the column.
Uniqueness
Figure 214. Visualization of uniqueness of the data in the column.
2024
Table 198. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | 2024 |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 199. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2024 | 4 - 4 | 5.740 | 5.74 | n/a | n/a | n/a | 5.74 | 168 | 167 (99.4%) | 0 (0.0%) | 0 (0.0%) | 2 (1.2%) |
Table 200. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| 2024 |
0.60%
|
1.19%
|
n/a | 5.74 |
Data Distribution Top 20
Figure 215. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 216. Distribution of values in the column.
Completeness
Figure 217. Visualization of completeness of the data in the column.
Uniqueness
Figure 218. Visualization of uniqueness of the data in the column.
Comments on data
Table 201. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Comments on data |
| Description | |
| Data type | String |
| Descriptor |
Text
0.0.TEXTA315 |
| Unit | n/a |
Table 202. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Comments on data | 0 - 158 | n/a | (incl. Iles… | n/a | n/a | n/a | 168 | 132 (78.6%) | 6 (3.6%) | 0 (0.0%) | 7 (4.2%) |
Table 203. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Comments on data |
21.43%
|
4.17%
|
n/a | (incl. Luxembourg 'LU' -> 1998) |
Data Distribution Top 20
Figure 219. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 220. Visualization of completeness of the data in the column.
Uniqueness
Figure 221. Visualization of uniqueness of the data in the column.
Avg_10_years
Table 204. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_10_years |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 205. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_10_years | 2 - 10 | 8,240,747.590 | 1.43 | 6.0975 | 172,133.85 | 2,401,279.25 | 376,348,698 | 168 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 165 (98.2%) |
Table 206. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_10_years |
100.00%
|
98.21%
|
2.28 | 7515759 |
Continuous Data Distribution
Figure 222. Distribution of values in the column.
Outliers
Figure 223. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 224. Visualization of completeness of the data in the column.
Uniqueness
Figure 225. Visualization of uniqueness of the data in the column.
Nat_Avg_Price_10_years
Table 207. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Nat_Avg_Price_10_years |
| Description | |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | n/a |
Table 208. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Nat_Avg_Price_10_years | 3 - 5 | 5.765 | 1.39 | 2.1725 | 4.745 | 6.57 | 24.25 | 168 | 112 (66.7%) | 0 (0.0%) | 0 (0.0%) | 55 (32.7%) |
Table 209. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Nat_Avg_Price_10_years |
33.33%
|
32.74%
|
n/a | 2.76 |
Continuous Data Distribution
Figure 226. Distribution of values in the column.
Outliers
Figure 227. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 228. Visualization of completeness of the data in the column.
Uniqueness
Figure 229. Visualization of uniqueness of the data in the column.
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aEU Honey Bee colonies
Country
Table 210. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Country |
| Description | Country |
| Data type | String |
| Descriptor |
iso3166:alpha-2CountryCode
0.0.LPHCN4 |
| Unit | n/a |
Table 211. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Country | 2 - 2 | n/a | AT | n/a | n/a | n/a | SK | 84 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 28 (33.3%) |
Table 212. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Country |
100.00%
|
33.33%
|
AT | AT |
Completeness
Figure 230. Visualization of completeness of the data in the column.
Uniqueness
Figure 231. Visualization of uniqueness of the data in the column.
Year
Table 213. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Year |
| Description | Year |
| Data type | Integer number |
| Descriptor |
iso8601:calendarYear
0.0.CLNDR340 |
| Unit | year |
Table 214. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Year | 4 - 4 | 2,021.0 | 2,020 | 2,020 | 2,021 | 2,022 | 2,022 | 84 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 3 (3.6%) |
Table 215. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Year |
100.00%
|
3.57%
|
2020 | 2020 |
Data Distribution Top 20
Figure 232. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 233. Distribution of values in the column.
Outliers
Figure 234. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 235. Visualization of completeness of the data in the column.
Uniqueness
Figure 236. Visualization of uniqueness of the data in the column.
Number_colonies
Table 216. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Number_colonies |
| Description | Number of colonies |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | 1000u |
Table 217. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Number_colonies | 1 - 5 | 1,410.9 | 5 | 82 | 390.5 | 1,525 | 20,270 | 84 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 74 (88.1%) |
Table 218. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Number_colonies |
100.00%
|
88.10%
|
179 | 426 |
Continuous Data Distribution
Figure 237. Distribution of values in the column.
Outliers
Figure 238. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 239. Visualization of completeness of the data in the column.
Uniqueness
Figure 240. Visualization of uniqueness of the data in the column.
Changes made to preparatory file
n/aChanges made to data
n/aUnresolved issues
n/aHoney Production Costs
Source
Table 219. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Source |
| Description | Source |
| Data type | String |
| Descriptor |
Text
0.0.TEXTA315 |
| Unit | n/a |
Table 220. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Source | 96 - 125 | n/a | https://agri… | n/a | n/a | n/a | https://agri… | 27 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 2 (7.4%) |
Table 221. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Source |
100.00%
|
7.41%
|
https://agriculture.ec.europa.eu/farming/animal-products/honey/national-apiculture-programmes_en | https://agriculture.ec.europa.eu/document/download/f711567c-b9ae-4d3c-b1bd-52aab6fb4574_fr?filename=nap-be_fr.pdf&prefLang=en |
Data Distribution Top 20
Figure 241. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 242. Visualization of completeness of the data in the column.
Uniqueness
Figure 243. Visualization of uniqueness of the data in the column.
Country
Table 222. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Country |
| Description | Country |
| Data type | String |
| Descriptor |
dwc:country
0.0.DWCCN159 |
| Unit | n/a |
Table 223. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Country | 2 - 2 | n/a | AT | n/a | n/a | n/a | SK | 27 | 0 (0.0%) | 0 (0.0%) | 0 (0.0%) | 27 (100.0%) |
Table 224. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Country |
100.00%
|
100.00%
|
AT | AT |
Completeness
Figure 244. Visualization of completeness of the data in the column.
Uniqueness
Figure 245. Visualization of uniqueness of the data in the column.
Nb_BK_150_or_more
Table 225. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Nb_BK_150_or_more |
| Description | Number of beekeepers with 150 colonies or more |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 226. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Nb_BK_150_or_more | 1 - 4 | 666.1 | 3 | 42 | 129 | 1,334 | 3,390 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 26 (96.3%) |
Table 227. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Nb_BK_150_or_more |
92.59%
|
96.30%
|
423 | 423 |
Continuous Data Distribution
Figure 246. Distribution of values in the column.
Outliers
Figure 247. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 248. Visualization of completeness of the data in the column.
Uniqueness
Figure 249. Visualization of uniqueness of the data in the column.
Nb_hives_by_150_or_more
Table 228. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Nb_hives_by_150_or_more |
| Description | Number of hives held by beekeepers with 150 hives and more |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 229. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Nb_hives_by_150_or_more | 0 - 7 | n/a | 1182 | n/a | n/a | n/a | error | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 26 (96.3%) |
Table 230. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Nb_hives_by_150_or_more |
92.59%
|
96.30%
|
n/a | 80165 |
Completeness
Figure 250. Visualization of completeness of the data in the column.
Uniqueness
Figure 251. Visualization of uniqueness of the data in the column.
Avg_Price_Jar_EUR_kg
Table 231. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_Price_Jar_EUR_kg |
| Description | Average Price sold in Jars (EUR/Kg) |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | EUR kg-1 |
Table 232. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_Price_Jar_EUR_kg | 1 - 5 | 8.755 | 2.25 | 5.655 | 7.76 | 11.2 | 19.25 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 25 (92.6%) |
Table 233. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_Price_Jar_EUR_kg |
92.59%
|
92.59%
|
10.5 | 13 |
Continuous Data Distribution
Figure 252. Distribution of values in the column.
Outliers
Figure 253. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 254. Visualization of completeness of the data in the column.
Uniqueness
Figure 255. Visualization of uniqueness of the data in the column.
Min_Price_Jar_EUR_kg
Table 234. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Min_Price_Jar_EUR_kg |
| Description | Minimum Price sold in Jars (EUR/Kg) |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | EUR kg-1 |
Table 235. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Min_Price_Jar_EUR_kg | 1 - 5 | 6.265 | 1.72 | 3.965 | 4.72 | 9.3 | 17.6 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 22 (81.5%) |
Table 236. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Min_Price_Jar_EUR_kg |
92.59%
|
81.48%
|
4 | 7 |
Continuous Data Distribution
Figure 256. Distribution of values in the column.
Outliers
Figure 257. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 258. Visualization of completeness of the data in the column.
Uniqueness
Figure 259. Visualization of uniqueness of the data in the column.
Max_Price_Jar_EUR_kg
Table 237. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Max_Price_Jar_EUR_kg |
| Description | Maximum Price sold in Jars (EUR/Kg) |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | EUR kg-1 |
Table 238. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Max_Price_Jar_EUR_kg | 1 - 5 | 12.093 | 2.79 | 7.335 | 12 | 15 | 30 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 23 (85.2%) |
Table 239. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Max_Price_Jar_EUR_kg |
92.59%
|
85.19%
|
15 | 14 |
Continuous Data Distribution
Figure 260. Distribution of values in the column.
Outliers
Figure 261. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 262. Visualization of completeness of the data in the column.
Uniqueness
Figure 263. Visualization of uniqueness of the data in the column.
Avg_Price_Drum_EUR_kg
Table 240. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_Price_Drum_EUR_kg |
| Description | Average Price sold in Drums (EUR/Kg) |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | EUR kg-1 |
Table 241. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_Price_Drum_EUR_kg | 1 - 5 | 5.273 | 1.82 | 3.065 | 4.78 | 6.3 | 14.31 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 26 (96.3%) |
Table 242. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_Price_Drum_EUR_kg |
92.59%
|
96.30%
|
n/a | 5.5 |
Continuous Data Distribution
Figure 264. Distribution of values in the column.
Outliers
Figure 265. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 266. Visualization of completeness of the data in the column.
Uniqueness
Figure 267. Visualization of uniqueness of the data in the column.
Min_Price_Drum_EUR_kg
Table 243. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Min_Price_Drum_EUR_kg |
| Description | Minimum Price sold in Drums (EUR/Kg) |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | EUR kg-1 |
Table 244. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Min_Price_Drum_EUR_kg | 1 - 4 | 4.049 | 1.28 | 2.36 | 3.8 | 5.425 | 9 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 24 (88.9%) |
Table 245. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Min_Price_Drum_EUR_kg |
92.59%
|
88.89%
|
4 | 7 |
Continuous Data Distribution
Figure 268. Distribution of values in the column.
Outliers
Figure 269. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 270. Visualization of completeness of the data in the column.
Uniqueness
Figure 271. Visualization of uniqueness of the data in the column.
Max_Price_Drum_EUR_kg
Table 246. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Max_Price_Drum_EUR_kg |
| Description | Maximum Price sold in Drums (EUR/Kg) |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | EUR kg-1 |
Table 247. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Max_Price_Drum_EUR_kg | 1 - 4 | 6.910 | 1.93 | 4.61 | 7 | 8.1 | 20 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 24 (88.9%) |
Table 248. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Max_Price_Drum_EUR_kg |
92.59%
|
88.89%
|
7 | 12 |
Continuous Data Distribution
Figure 272. Distribution of values in the column.
Outliers
Figure 273. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 274. Visualization of completeness of the data in the column.
Uniqueness
Figure 275. Visualization of uniqueness of the data in the column.
Production_kg_colony_year
Table 249. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Production_kg_colony_year |
| Description | Honey Production (kg/colony) |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | kg |
Table 250. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Production_kg_colony_year | 1 - 2 | 21.1 | 5 | 15 | 20 | 25.5 | 47 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 18 (66.7%) |
Table 251. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Production_kg_colony_year |
92.59%
|
66.67%
|
20 | 17 |
Continuous Data Distribution
Figure 276. Distribution of values in the column.
Outliers
Figure 277. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 278. Visualization of completeness of the data in the column.
Uniqueness
Figure 279. Visualization of uniqueness of the data in the column.
Avg_Cost__EUR_kg
Table 252. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_Cost__EUR_kg |
| Description | Average Cost of production (EUR/Kg) |
| Data type | Decimal number |
| Descriptor |
DecimalNumber
0.0.DCMLN314 |
| Unit | EUR kg-1 |
Table 253. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_Cost__EUR_kg | 1 - 4 | 4.615 | 1.3 | 2.595 | 3.75 | 7.05 | 10 | 27 | 1 (3.7%) | 0 (0.0%) | 0 (0.0%) | 27 (100.0%) |
Table 254. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_Cost__EUR_kg |
96.30%
|
100.00%
|
4.05 | 4.05 |
Continuous Data Distribution
Figure 280. Distribution of values in the column.
Outliers
Figure 281. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 282. Visualization of completeness of the data in the column.
Uniqueness
Figure 283. Visualization of uniqueness of the data in the column.
Avg_Cost_EUR_SUP_Avg_Price_Drums
Table 255. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Avg_Cost_EUR_SUP_Avg_Price_Drums |
| Description | Average Cost of production/Average Price sold in Drums |
| Data type | String |
| Descriptor |
Text
0.0.TEXTA315 |
| Unit | n/a |
Table 256. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg_Cost_EUR_SUP_Avg_Price_Drums | 0 - 3 | n/a | lim | n/a | n/a | n/a | yes | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 4 (14.8%) |
Table 257. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Avg_Cost_EUR_SUP_Avg_Price_Drums |
92.59%
|
14.81%
|
no | n/a |
Data Distribution Top 20
Figure 284. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 285. Visualization of completeness of the data in the column.
Uniqueness
Figure 286. Visualization of uniqueness of the data in the column.
Nb_Beekeepers
Table 258. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
| Parameter | Content |
|---|---|
| Name | Nb_Beekeepers |
| Description | Number of beekeepers |
| Data type | Integer number |
| Descriptor |
Integer
0.0.NTGER313 |
| Unit | n/a |
Table 259. 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).
| Name | Length | Mean | Min | Q1 | Median | Q3 | Max | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Nb_Beekeepers | 3 - 6 | 22,237.8 | 230 | 4,257.5 | 9,266 | 26,453 | 116,000 | 27 | 2 (7.4%) | 0 (0.0%) | 0 (0.0%) | 26 (96.3%) |
Table 260. 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).
| Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| Nb_Beekeepers |
92.59%
|
96.30%
|
29745 | 29745 |
Continuous Data Distribution
Figure 287. Distribution of values in the column.
Outliers
Figure 288. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 289. Visualization of completeness of the data in the column.
Uniqueness
Figure 290. Visualization of uniqueness of the data in the column.