EU Pollinator Hub Data Catalogue FAOSTAT TM Trade Matrix Dataset Report

EU Pollinator Hub 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: FSTTT207.0.0
Name: FAOSTAT TM Trade Matrix
Status: FAOSTAT data on the detailed trade matrix with beekeeping livestock and products
Title: Approved
Version: v. 1.0
Date: 2024-12-02
Author: Michael Rubinigg
Citation proposal: 2024, Report for Dataset FAOSTAT TM Trade Matrix, v. 1.0; Editor EU Pollinator Hub; available at: https://app.pollinatorhub.eu/dataset-discovery/reports/59 Michael Rubinigg
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
* See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
Good
This document is intended for use by collaborators of the EU Pollinator Hub and may be passed on with the express permission of the leader of the consortium and for the purpose determined by the leader of the consortium.

Document History

Release

Version v. 1.0 released on 2025-01-02. Written by Michael Rubinigg. Reviewed 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-02 15:01:17 Initial release. N.A.

Abbreviations

FAO
Food and Agriculture Organization of the United Nation
FAOSTAT
Food and Agriculture Organization Corporate Statistical Database
CSV
Comma-Separated Value

Executive Summary

Data overview:

n/a

Data value:

n/a

Data description:

n/a

Data application:

n/a

Introduction

n/a

Material and Methods

Data Acquisition

All raw data files were downloaded from the website of FAOSTAT.

List of raw data obtained from the data provider.

  1. Archive Trade_DetailedTradeMatrix_E_All_Data_(Normalized).zip accessed on 2024-02-12 14:29:30, provided by FAOSTAT
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 FAOSTAT_data_en_12-2-2024_TM bees quantity_PREP_MR_240212.csv CSV - Comma seperated values Yes No 2024-12-03 17:12:42 99,360 740.88 KiB
2 FAOSTAT_data_en_12-2-2024_TM beeswax quantity_PREP_MR_240212.csv CSV - Comma seperated values Yes No 2024-12-03 16:12:33 696,708 5.36 MiB
3 FAOSTAT_data_en_12-2-2024_TM honey quantity_PREP_MR_240212.csv CSV - Comma seperated values Yes No 2024-12-03 16:12:07 1,978,002 15.34 MiB
4 FAOSTAT_data_en_12-2-2024_TM honey value_PREP_MR_240212.csv CSV - Comma seperated values Yes No 2024-12-03 16:12:21 1,978,002 15.68 MiB
5 FAOSTAT_data_en_12-2-2024_TM beeswax value_PREP_MR_240212.csv CSV - Comma seperated values Yes No 2024-12-03 16:12:46 696,708 5.49 MiB
6 FAOSTAT_data_en_12-2-2024_TM bees value_PREP_MR_240212.csv CSV - Comma seperated values Yes No 2024-12-03 16:12:15 99,360 759.66 KiB
7 FAOSTAT_TM_Metadata.csv Miscellaneous No Yes 2024-12-02 17:12:35 n/a 21.57 KiB
8 cc9206en.pdf Miscellaneous No Yes 2024-12-02 17:12:02 n/a 842.01 KiB
9 TM_e.pdf Miscellaneous No Yes 2024-12-02 17:12:59 n/a 5.36 KiB

Data Preparation

Raw data files were processed using a SQL database (MariaDB foundation, server version 10.4.32) running in an XAMPP environment (BitRock, version 5.2.1).

Data Validation

No data validation was performed.

Data Analysis

No data analysis was performed.

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 bees trade matrix quantity This table contains the trade matrix (quantity of import and export) for honey bees, expressed as number of units of…
2 beeswax trade matrix quantity This table contains the trade matrix (quantity of import and export) for beeswax, expressed as tonnes, usually but not always…
3 honey trade matrix quantity This table contains the trade matrix (quantity of import and export) for honey, expressed as tonnes, usually but not always…
4 honey trade matrix value This table contains the trade matrix (value of import and export) for honey, expressed as 1000 USD, usually but not…
5 beeswax trade matrix value This table contains the trade matrix (value of import and export) for beeswax, expressed as 1000 USD, usually but not…
6 bees trade matrix value This table contains the trade matrix (value of import and export) for honey bees, expressed as 1000 USD, usually but…
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
UID FSTTT207.0.0
Name FAOSTAT TM Trade Matrix
Title FAOSTAT data on the detailed trade matrix with beekeeping livestock and products
Licence CC BY 4.0
DOI n/a
Creation date 2024-12-02
Publishing date 2024-04-14
Contact information n/a
Keywords Honey bees, beeswax, export, honey, import, trade matrix
Data collection years n/a
Regions, the data was collected in Belgique/België, Danmark, Deutschland, Eesti, España, France, Hrvatska, Ireland, Italia, Latvija, Lietuva, Luxembourg, Magyarország, Malta, Nederland, Norge, Polska, Portugal, România, Schweiz/Suisse/Svizzera, Shqipëria, Slovenija, Slovensko, Srbija/Сpбија, Suomi/Finland, Sverige, Türkiye, United Kingdom, Ísland, Österreich, Ελλάδα , Κύπρος , България , Северна Македонија, Црна Гора
Description

The food and agricultural trade dataset is collected, processed and disseminated by FAO according to the standard International Merchandise Trade Statistics (IMTS) Methodology. The data is mainly provided by UNSD, Eurostat, and other national authorities as needed. This source data is checked for outliers, trade partner data is used for non-reporting countries or missing cells, and data on food aid is added to take into account total cross-border trade flows. The trade database includes the following variables: export quantity, export value, import quantity, and import value. The trade database includes all food and agricultural products imported/exported annually by all the countries in the world.
Table 5. Standardised metadata of the data provider Food and Agriculture Organization of the United Nations. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
UID food-and-agriculture-organization-of-the-united-nations
Name Food and Agriculture Organization of the United Nations
URL
Acronym FAO
Address
Country Italy
Contact information www.fao.org
Description

The Food and Agriculture Organization of the United Nations (FAO) is a specialized agency of the United Nations that helps governments and development agencies coordinate their activities to improve and develop agriculture, forestry, fisheries, and land and water resources.

Tables

bees trade matrix quantity

Table 6. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
UID FSTTT207.BEESA516.0
Name bees trade matrix quantity
Type File
Licence CC BY 4.0
Description

The Food and Agriculture Organization of the United Nations (FAO) is a specialized agency of the United Nations that helps governments and development agencies coordinate their activities to improve and develop agriculture, forestry, fisheries, and land and water resources.
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
ReporterAreaCodeFAO FAO area code of the country or region which has reported the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
ReporterAreaCodeM49 M49 area code of the country or region which has reported the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
ReporterAreaCodeISO2 ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
ReporterArea Name of the area (country or region) which has reported the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
PartnerAreaCodeFAO FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
PartnerAreaCodeM49 M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
PartnerAreaCodeISO2 ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
PartnerArea Name of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
ItemCodeFAO Item code assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Code [0.0.FSTTT423]

n/a
ItemCodeCPC Central Product Classification (CPC) Code of the item for which the value in the record is reported. String CPC Code [0.0.CPCCD426]

n/a
Item Name of the item assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Description [FSTTM9.ITEMA214.FSTTT424]

n/a
ElementCode Element code assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Code [0.0.FSTTL418]

n/a
Element Name of the element assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Description [0.0.FSTTL419]

n/a
YearCode Year code used by FAOSTAT to describe the period for which the value in the record is reported. String FAOSTAT Year Code [0.0.FSTTY429]

n/a
Year Period for which the value in the record is reported. String FAOSTAT Year Code Description [0.0.FSTTY430]

n/a
Unit Unit in which the value in the record is reported. String FAOSTAT Unit [0.0.FSTTN94]

n/a
Value Trade quantity reported for the item (bees) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)) between reporter and partner country, expressed in the unit [number](https://app.pollinatorhub.eu/dictionary/classes/548), as specified in the record. Decimal number Decimal Number [0.0.DCMLN314]

n/a
Flag Flag assigned to the value reported in the record. String FAOSTAT Flag []

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
ReporterAreaCodeFAO 1 - 3 133.3 1 69.25 138 195 299 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
ReporterAreaCodeM49 1 - 3 435.8 4 208 440 643 862 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZA 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Viet Nam 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
PartnerAreaCodeFAO 1 - 3 139.1 1 79 150 203 299 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
PartnerAreaCodeM49 1 - 3 443.5 4 218 422 703 894 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
ItemCodeFAO 4 - 4 1,181.0 1,181 1,181 1,181 1,181 1,181 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ItemCodeCPC 4 - 4 2,196.0 2,196 2,196 2,196 2,196 2,196 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Item 4 - 4 n/a Bees n/a n/a n/a Bees 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ElementCode 4 - 4 5,747.2 5,607 5,607 5,607 5,907 5,907 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Element 15 - 15 n/a Export Quant… n/a n/a n/a Import Quant… 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
YearCode 4 - 4 2,014.4 1,986 2,013 2,017 2,020 2,022 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.7%)
Year 4 - 4 2,014.4 1,986 2,013 2,017 2,020 2,022 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.7%)
Unit 2 - 2 n/a No n/a n/a n/a No 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Value 1 - 9 194,961.2 0 0 0 0 196,484,000 5,520 0 (0.0%) 4,325 (78.4%) 0 (0.0%) 531 (9.6%)
Flag 1 - 1 n/a A n/a n/a n/a X 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 4 (0.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
ReporterAreaCodeFAO
100.00%
2.25%
150 12
ReporterAreaCodeM49
100.00%
2.25%
528 44
ReporterAreaCodeISO2
100.00%
2.25%
NL BS
ReporterArea
100.00%
2.25%
Netherlands (Kingdom of the) Bahamas
PartnerAreaCodeFAO
100.00%
2.90%
150 19
PartnerAreaCodeM49
100.00%
2.90%
528 68
PartnerAreaCodeISO2
100.00%
2.90%
NL BO
PartnerArea
100.00%
2.90%
Netherlands (Kingdom of the) Bolivia (Plurinational State of)
ItemCodeFAO
100.00%
0.02%
1181 1181
ItemCodeCPC
100.00%
0.02%
2196 2196
Item
100.00%
0.02%
Bees Bees
ElementCode
100.00%
0.04%
5607 5907
Element
100.00%
0.04%
Import Quantity Export Quantity
YearCode
100.00%
0.67%
2022 1996
Year
100.00%
0.67%
2022 1996
Unit
100.00%
0.02%
No No
Value
100.00%
9.62%
0 206
Flag
100.00%
0.07%
A E

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

beeswax trade matrix quantity

Table 10. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
UID FSTTT207.BSWAX517.0
Name beeswax trade matrix quantity
Type File
Licence CC BY 4.0
Description

The Food and Agriculture Organization of the United Nations (FAO) is a specialized agency of the United Nations that helps governments and development agencies coordinate their activities to improve and develop agriculture, forestry, fisheries, and land and water resources.
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
ReporterAreaCodeFAO FAO area code of the country or region which has reported the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
ReporterAreaCodeM49 M49 area code of the country or region which has reported the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
ReporterAreaCodeISO2 ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
ReporterArea Name of the area (country or region) which has reported the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
PartnerAreaCodeFAO FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
PartnerAreaCodeM49 M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
PartnerAreaCodeISO2 ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
PartnerArea Name of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
ItemCodeFAO Item code assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Code [0.0.FSTTT423]

n/a
ItemCodeCPC Central Product Classification (CPC) Code of the item for which the value in the record is reported. String CPC Code [0.0.CPCCD426]

n/a
Item Name of the item assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Description [FSTTM9.ITEMA214.FSTTT424]

n/a
ElementCode Element code assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Code [0.0.FSTTL418]

n/a
Element Name of the element assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Description [0.0.FSTTL419]

n/a
YearCode Year code used by FAOSTAT to describe the period for which the value in the record is reported. String FAOSTAT Year Code [0.0.FSTTY429]

n/a
Year Period for which the value in the record is reported. String FAOSTAT Year Code Description [0.0.FSTTY430]

n/a
Unit Unit in which the value in the record is reported. String FAOSTAT Unit [0.0.FSTTN94]

n/a
Value Trade quantity reported for the item ([beeswax](https://app.pollinatorhub.eu/dictionary/classes/1159)) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)) between reporter and partner country, expressed in the unit [tonnes](https://app.pollinatorhub.eu/dictionary/classes/594), as specified in the record. Decimal number Decimal Number [0.0.DCMLN314]

n/a
Flag Flag assigned to the value reported in the record. String FAOSTAT Flag []

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
ReporterAreaCodeFAO 1 - 3 131.9 1 68 117 203 299 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
ReporterAreaCodeM49 1 - 3 437.2 4 246 380 705 894 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
PartnerAreaCodeFAO 1 - 3 131.9 1 68 117 203 299 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
PartnerAreaCodeM49 1 - 3 438.9 4 233 384 703 894 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
ItemCodeFAO 4 - 4 1,183.0 1,183 1,183 1,183 1,183 1,183 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ItemCodeCPC 8 - 8 2,960.010 2,960.01 2,960.01 2,960.01 2,960.01 2,960.01 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Item 7 - 7 n/a Beeswax n/a n/a n/a Beeswax 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ElementCode 4 - 4 5,758.6 5,610 5,610 5,610 5,910 5,910 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Element 15 - 15 n/a Export Quant… n/a n/a n/a Import Quant… 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
YearCode 4 - 4 2,008.0 1,986 2,000 2,010 2,017 2,022 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.1%)
Year 4 - 4 2,008.0 1,986 2,000 2,010 2,017 2,022 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.1%)
Unit 1 - 1 n/a t n/a n/a n/a t 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Value 1 - 7 28.022 0 0.01 1.08 11 19,476 38,706 0 (0.0%) 9,541 (24.6%) 0 (0.0%) 3,704 (9.6%)
Flag 1 - 1 n/a A n/a n/a n/a X 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 4 (0.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
ReporterAreaCodeFAO
100.00%
0.48%
79 12
ReporterAreaCodeM49
100.00%
0.48%
276 44
ReporterAreaCodeISO2
100.00%
0.48%
DE BS
ReporterArea
100.00%
0.48%
Germany Bahamas
PartnerAreaCodeFAO
100.00%
0.53%
79 140
PartnerAreaCodeM49
100.00%
0.53%
276 492
PartnerAreaCodeISO2
100.00%
0.53%
DE MC
PartnerArea
100.00%
0.53%
Germany Monaco
ItemCodeFAO
100.00%
0.00%
1183 1183
ItemCodeCPC
100.00%
0.00%
02960.01 02960.01
Item
100.00%
0.00%
Beeswax Beeswax
ElementCode
100.00%
0.01%
5610 5910
Element
100.00%
0.01%
Import Quantity Export Quantity
YearCode
100.00%
0.10%
2021 1988
Year
100.00%
0.10%
2021 1988
Unit
100.00%
0.00%
t t
Value
100.00%
9.57%
0 123.36
Flag
100.00%
0.01%
A E

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

honey trade matrix quantity

Table 14. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
UID FSTTT207.HONEY518.0
Name honey trade matrix quantity
Type File
Licence CC BY 4.0
Description

The Food and Agriculture Organization of the United Nations (FAO) is a specialized agency of the United Nations that helps governments and development agencies coordinate their activities to improve and develop agriculture, forestry, fisheries, and land and water resources.
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
ReporterAreaCodeFAO FAO area code of the country or region which has reported the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
ReporterAreaCodeM49 M49 area code of the country or region which has reported the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
ReporterAreaCodeISO2 ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
ReporterArea Name of the area (country or region) which has reported the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
PartnerAreaCodeFAO FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
PartnerAreaCodeM49 M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
PartnerAreaCodeISO2 ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
PartnerArea Name of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
ItemCodeFAO Item code assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Code [0.0.FSTTT423]

n/a
ItemCodeCPC Central Product Classification (CPC) Code of the item for which the value in the record is reported. String CPC Code [0.0.CPCCD426]

n/a
Item Name of the item assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Description [FSTTM9.ITEMA214.FSTTT424]

n/a
ElementCode Element code assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Code [0.0.FSTTL418]

n/a
Element Name of the element assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Description [0.0.FSTTL419]

n/a
YearCode Year code used by FAOSTAT to describe the period for which the value in the record is reported. String FAOSTAT Year Code [0.0.FSTTY429]

n/a
Year Period for which the value in the record is reported. String FAOSTAT Year Code Description [0.0.FSTTY430]

n/a
Unit Unit in which the value in the record is reported. String FAOSTAT Unit [0.0.FSTTN94]

n/a
Value Trade quantity reported for the item (honey) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)), expressed in the unit [tonnes](https://app.pollinatorhub.eu/dictionary/classes/594) between reporter and partner country, as specified in the record. Decimal number Decimal Number [0.0.DCMLN314]

n/a
Flag Flag assigned to the value reported in the record. String FAOSTAT Flag []

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
ReporterAreaCodeFAO 1 - 3 131.8 1 68 126 203 299 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
ReporterAreaCodeM49 1 - 3 437.9 4 231 410 702 894 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
PartnerAreaCodeFAO 1 - 3 133.2 1 68 126 203 299 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
PartnerAreaCodeM49 1 - 3 446.4 4 233 414 702 894 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
ItemCodeFAO 4 - 4 1,182.0 1,182 1,182 1,182 1,182 1,182 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ItemCodeCPC 4 - 4 2,910.0 2,910 2,910 2,910 2,910 2,910 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Item 13 - 13 n/a Natural hone… n/a n/a n/a Natural hone… 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ElementCode 4 - 4 5,759.3 5,610 5,610 5,610 5,910 5,910 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Element 15 - 15 n/a Export Quant… n/a n/a n/a Import Quant… 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
YearCode 4 - 4 2,009.2 1,986 2,002 2,011 2,017 2,022 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.0%)
Year 4 - 4 2,009.2 1,986 2,002 2,011 2,017 2,022 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.0%)
Unit 1 - 1 n/a t n/a n/a n/a t 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Value 1 - 7 281.392 0 0.24 5 51 70,256.4 109,889 0 (0.0%) 17,652 (16.1%) 0 (0.0%) 16,025 (14.6%)
Flag 1 - 1 n/a A n/a n/a n/a X 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 4 (0.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
ReporterAreaCodeFAO
100.00%
0.17%
79 244
ReporterAreaCodeM49
100.00%
0.17%
276 882
ReporterAreaCodeISO2
100.00%
0.17%
DE WS
ReporterArea
100.00%
0.17%
Germany Samoa
PartnerAreaCodeFAO
100.00%
0.19%
231 218
PartnerAreaCodeM49
100.00%
0.19%
840 772
PartnerAreaCodeISO2
100.00%
0.19%
US TK
PartnerArea
100.00%
0.19%
United States of America Tokelau
ItemCodeFAO
100.00%
0.00%
1182 1182
ItemCodeCPC
100.00%
0.00%
2910 2910
Item
100.00%
0.00%
Natural honey Natural honey
ElementCode
100.00%
0.00%
5610 5910
Element
100.00%
0.00%
Import Quantity Export Quantity
YearCode
100.00%
0.03%
2021 1987
Year
100.00%
0.03%
2021 1987
Unit
100.00%
0.00%
t t
Value
100.00%
14.58%
0 1829
Flag
100.00%
0.00%
A E

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

honey trade matrix value

Table 18. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
UID FSTTT207.HNYTR523.0
Name honey trade matrix value
Type File
Licence CC BY 4.0
Description

The Food and Agriculture Organization of the United Nations (FAO) is a specialized agency of the United Nations that helps governments and development agencies coordinate their activities to improve and develop agriculture, forestry, fisheries, and land and water resources.
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
ElementCode Element code assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Code [0.0.FSTTL418]

n/a
Element Name of the element assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Description [0.0.FSTTL419]

n/a
ItemCodeCPC Central Product Classification (CPC) Code of the item for which the value in the record is reported. String CPC Code [0.0.CPCCD426]

n/a
ItemCodeFAO Item code assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Code [0.0.FSTTT423]

n/a
Item Name of the item assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Description [FSTTM9.ITEMA214.FSTTT424]

n/a
YearCode Year code used by FAOSTAT to describe the period for which the value in the record is reported. String FAOSTAT Year Code [0.0.FSTTY429]

n/a
Year Period for which the value in the record is reported. String FAOSTAT Year Code Description [0.0.FSTTY430]

n/a
Unit Unit in which the value in the record is reported. String FAOSTAT Unit [0.0.FSTTN94]

n/a
Value Trade value reported for the item (honey) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)), expressed in the unit [1000 USD](https://app.pollinatorhub.eu/dictionary/classes/513) between reporter and partner country, as specified in the record. Integer number Integer [0.0.NTGER313]

n/a
Flag Flag assigned to the value reported in the record. String FAOSTAT Flag []

n/a
ReporterAreaCodeFAO FAO area code of the country or region which has reported the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
ReporterAreaCodeM49 M49 area code of the country or region which has reported the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
ReporterAreaCodeISO2 ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
ReporterArea Name of the area (country or region) which has reported the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
PartnerAreaCodeFAO FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
PartnerAreaCodeM49 M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
PartnerAreaCodeISO2 ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
PartnerArea Name of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Area [0.0.MAREA519]

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
ElementCode 4 - 4 5,771.3 5,622 5,622 5,622 5,922 5,922 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Element 12 - 12 n/a Export Value n/a n/a n/a Import Value 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
ItemCodeCPC 4 - 4 2,910.0 2,910 2,910 2,910 2,910 2,910 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ItemCodeFAO 4 - 4 1,182.0 1,182 1,182 1,182 1,182 1,182 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Item 13 - 13 n/a Natural hone… n/a n/a n/a Natural hone… 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
YearCode 4 - 4 2,009.2 1,986 2,002 2,011 2,017 2,022 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.0%)
Year 4 - 4 2,009.2 1,986 2,002 2,011 2,017 2,022 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.0%)
Unit 8 - 8 n/a 1000 USD n/a n/a n/a 1000 USD 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Value 1 - 6 727.0 0 2 21 166 219,749 109,889 0 (0.0%) 15,852 (14.4%) 0 (0.0%) 6,840 (6.2%)
Flag 1 - 1 n/a A n/a n/a n/a X 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 3 (0.0%)
ReporterAreaCodeFAO 1 - 3 131.8 1 68 126 203 299 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
ReporterAreaCodeM49 1 - 3 437.9 4 231 410 702 894 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
PartnerAreaCodeFAO 1 - 3 133.2 1 68 126 203 299 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
PartnerAreaCodeM49 1 - 3 446.4 4 233 414 702 894 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)

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
ElementCode
100.00%
0.00%
5622 5922
Element
100.00%
0.00%
Import Value Export Value
ItemCodeCPC
100.00%
0.00%
2910 2910
ItemCodeFAO
100.00%
0.00%
1182 1182
Item
100.00%
0.00%
Natural honey Natural honey
YearCode
100.00%
0.03%
2021 1987
Year
100.00%
0.03%
2021 1987
Unit
100.00%
0.00%
1000 USD 1000 USD
Value
100.00%
6.22%
0 4051
Flag
100.00%
0.00%
A E
ReporterAreaCodeFAO
100.00%
0.17%
79 244
ReporterAreaCodeM49
100.00%
0.17%
276 882
ReporterAreaCodeISO2
100.00%
0.17%
DE WS
ReporterArea
100.00%
0.17%
Germany Samoa
PartnerAreaCodeFAO
100.00%
0.19%
231 218
PartnerAreaCodeM49
100.00%
0.19%
840 772
PartnerAreaCodeISO2
100.00%
0.19%
US TK
PartnerArea
100.00%
0.19%
United States of America Tokelau

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

beeswax trade matrix value

Table 22. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
UID FSTTT207.BSWXT524.0
Name beeswax trade matrix value
Type File
Licence CC BY 4.0
Description

The Food and Agriculture Organization of the United Nations (FAO) is a specialized agency of the United Nations that helps governments and development agencies coordinate their activities to improve and develop agriculture, forestry, fisheries, and land and water resources.
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
ElementCode Element code assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Code [0.0.FSTTL418]

n/a
Element Name of the element assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Description [0.0.FSTTL419]

n/a
ItemCodeCPC Central Product Classification (CPC) Code of the item for which the value in the record is reported. String CPC Code [0.0.CPCCD426]

n/a
ItemCodeFAO Item code assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Code [0.0.FSTTT423]

n/a
Item Name of the item assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Description [FSTTM9.ITEMA214.FSTTT424]

n/a
YearCode Year code used by FAOSTAT to describe the period for which the value in the record is reported. String FAOSTAT Year Code [0.0.FSTTY429]

n/a
Year Period for which the value in the record is reported. String FAOSTAT Year Code Description [0.0.FSTTY430]

n/a
Unit Unit in which the value in the record is reported. String FAOSTAT Unit [0.0.FSTTN94]

n/a
Value Trade value reported for the item ([beeswax](https://app.pollinatorhub.eu/dictionary/classes/1159)) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)) between reporter and partner country, expressed in the unit [1000 USD](https://app.pollinatorhub.eu/dictionary/classes/513), as specified in the record. Integer number Integer [0.0.NTGER313]

n/a
Flag Flag assigned to the value reported in the record. String FAOSTAT Flag []

n/a
ReporterAreaCodeFAO FAO area code of the country or region which has reported the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
ReporterAreaCodeM49 M49 area code of the country or region which has reported the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
ReporterAreaCodeISO2 ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
ReporterArea Name of the area (country or region) which has reported the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
PartnerAreaCodeFAO FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
PartnerAreaCodeM49 M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
PartnerAreaCodeISO2 ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
PartnerArea Name of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Area [0.0.MAREA519]

n/a

Metadata of individual tables can be found in Annex 1 .

Descriptive Measures

Table 24. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Name Length Mean Min Q1 Median Q3 Max Total Missing Zero Blank Distinct
ElementCode 4 - 4 5,770.6 5,622 5,622 5,622 5,922 5,922 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Element 12 - 12 n/a Export Value n/a n/a n/a Import Value 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
ItemCodeCPC 8 - 8 2,960.010 2,960.01 2,960.01 2,960.01 2,960.01 2,960.01 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ItemCodeFAO 4 - 4 1,183.0 1,183 1,183 1,183 1,183 1,183 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Item 7 - 7 n/a Beeswax n/a n/a n/a Beeswax 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
YearCode 4 - 4 2,008.0 1,986 2,000 2,010 2,017 2,022 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.1%)
Year 4 - 4 2,008.0 1,986 2,000 2,010 2,017 2,022 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.1%)
Unit 8 - 8 n/a 1000 USD n/a n/a n/a 1000 USD 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Value 1 - 5 126.0 0 2 9 56 18,480 38,706 0 (0.0%) 6,023 (15.6%) 0 (0.0%) 1,673 (4.3%)
Flag 1 - 1 n/a A n/a n/a n/a X 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
ReporterAreaCodeFAO 1 - 3 131.9 1 68 117 203 299 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
ReporterAreaCodeM49 1 - 3 437.2 4 246 380 705 894 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
PartnerAreaCodeFAO 1 - 3 131.9 1 68 117 203 299 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
PartnerAreaCodeM49 1 - 3 438.9 4 233 384 703 894 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)

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
ElementCode
100.00%
0.01%
5622 5922
Element
100.00%
0.01%
Import Value Export Value
ItemCodeCPC
100.00%
0.00%
02960.01 02960.01
ItemCodeFAO
100.00%
0.00%
1183 1183
Item
100.00%
0.00%
Beeswax Beeswax
YearCode
100.00%
0.10%
2021 1988
Year
100.00%
0.10%
2021 1988
Unit
100.00%
0.00%
1000 USD 1000 USD
Value
100.00%
4.32%
0 1768
Flag
100.00%
0.01%
A X
ReporterAreaCodeFAO
100.00%
0.48%
79 12
ReporterAreaCodeM49
100.00%
0.48%
276 44
ReporterAreaCodeISO2
100.00%
0.48%
DE BS
ReporterArea
100.00%
0.48%
Germany Bahamas
PartnerAreaCodeFAO
100.00%
0.53%
79 140
PartnerAreaCodeM49
100.00%
0.53%
276 492
PartnerAreaCodeISO2
100.00%
0.53%
DE MC
PartnerArea
100.00%
0.53%
Germany Monaco

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

bees trade matrix value

Table 26. Standardised metadata of the table. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
UID FSTTT207.BSTRD525.0
Name bees trade matrix value
Type File
Licence CC BY 4.0
Description

The Food and Agriculture Organization of the United Nations (FAO) is a specialized agency of the United Nations that helps governments and development agencies coordinate their activities to improve and develop agriculture, forestry, fisheries, and land and water resources.
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
ElementCode Element code assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Code [0.0.FSTTL418]

n/a
Element Name of the element assigned by FAOSTAT to the item for which the value in the record is reported. String FAOSTAT Element Description [0.0.FSTTL419]

n/a
ItemCodeCPC Central Product Classification (CPC) Code of the item for which the value in the record is reported. String CPC Code [0.0.CPCCD426]

n/a
ItemCodeFAO Item code assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Code [0.0.FSTTT423]

n/a
Item Name of the item assigned by FAOSTAT to the value reported in the record. String FAOSTAT Item Description [FSTTM9.ITEMA214.FSTTT424]

n/a
YearCode Year code used by FAOSTAT to describe the period for which the value in the record is reported. String FAOSTAT Year Code [0.0.FSTTY429]

n/a
Year Period for which the value in the record is reported. String FAOSTAT Year Code Description [0.0.FSTTY430]

n/a
Unit Unit in which the value in the record is reported. String FAOSTAT Unit [0.0.FSTTN94]

n/a
Value Trade value reported for the item (bees) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)) between reporter and partner country, expressed in the unit [1000 USD](https://app.pollinatorhub.eu/dictionary/classes/513), as specified in the record. Integer number Integer [0.0.NTGER313]

n/a
Flag Flag assigned to the value reported in the record. String FAOSTAT Flag []

n/a
ReporterAreaCodeFAO FAO area code of the country or region which has reported the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
ReporterAreaCodeM49 M49 area code of the country or region which has reported the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
ReporterAreaCodeISO2 ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
ReporterArea Name of the area (country or region) which has reported the trade value in the record. String M49 Area [0.0.MAREA519]

n/a
PartnerAreaCodeFAO FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String Faostat Area Code [0.0.FSTTR411]

n/a
PartnerAreaCodeM49 M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Code [0.0.MCODE356]

n/a
PartnerAreaCodeISO2 ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record. String alpha-2 country code [0.0.LPHCN4]

n/a
PartnerArea Name of the trade partner country or region for which the reporting country has provided the trade value in the record. String M49 Area [0.0.MAREA519]

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
ElementCode 4 - 4 5,762.2 5,622 5,622 5,622 5,922 5,922 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Element 12 - 12 n/a Export Value n/a n/a n/a Import Value 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
ItemCodeCPC 4 - 4 2,196.0 2,196 2,196 2,196 2,196 2,196 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
ItemCodeFAO 4 - 4 1,181.0 1,181 1,181 1,181 1,181 1,181 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Item 4 - 4 n/a Bees n/a n/a n/a Bees 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
YearCode 4 - 4 2,014.4 1,986 2,013 2,017 2,020 2,022 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.7%)
Year 4 - 4 2,014.4 1,986 2,013 2,017 2,020 2,022 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.7%)
Unit 8 - 8 n/a 1000 USD n/a n/a n/a 1000 USD 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Value 1 - 5 310.4 0 3 13 77 24,303 5,520 0 (0.0%) 552 (10.0%) 0 (0.0%) 835 (15.1%)
Flag 1 - 1 n/a A n/a n/a n/a X 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 3 (0.1%)
ReporterAreaCodeFAO 1 - 3 133.3 1 69.25 138 195 299 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
ReporterAreaCodeM49 1 - 3 435.8 4 208 440 643 862 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZA 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Viet Nam 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
PartnerAreaCodeFAO 1 - 3 139.1 1 79 150 203 299 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
PartnerAreaCodeM49 1 - 3 443.5 4 218 422 703 894 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)

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
ElementCode
100.00%
0.04%
5622 5922
Element
100.00%
0.04%
Import Value Export Value
ItemCodeCPC
100.00%
0.02%
2196 2196
ItemCodeFAO
100.00%
0.02%
1181 1181
Item
100.00%
0.02%
Bees Bees
YearCode
100.00%
0.67%
2022 1996
Year
100.00%
0.67%
2022 1996
Unit
100.00%
0.02%
1000 USD 1000 USD
Value
100.00%
15.13%
0 259
Flag
100.00%
0.05%
A E
ReporterAreaCodeFAO
100.00%
2.25%
150 12
ReporterAreaCodeM49
100.00%
2.25%
528 44
ReporterAreaCodeISO2
100.00%
2.25%
NL BS
ReporterArea
100.00%
2.25%
Netherlands (Kingdom of the) Bahamas
PartnerAreaCodeFAO
100.00%
2.90%
150 19
PartnerAreaCodeM49
100.00%
2.90%
528 68
PartnerAreaCodeISO2
100.00%
2.90%
NL BO
PartnerArea
100.00%
2.90%
Netherlands (Kingdom of the) Bolivia (Plurinational State of)

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

References

Reference

  • FAO 2023-12-21 FAOSTAT Detailed trade matrix. FAOSTAT. [2024-12-2] www.fao.org

Annexes

Annex 1: Table column reports

bees trade matrix quantity

ReporterAreaCodeFAO

Table 30. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeFAO
Description FAO area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
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
ReporterAreaCodeFAO 1 - 3 133.3 1 69.25 138 195 299 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
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
ReporterAreaCodeFAO
100.00%
2.25%
150 12
Continuous Data Distribution
Figure 1. Distribution of values in the column.
Outliers
Figure 2. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 3. Visualization of completeness of the data in the column.
Uniqueness
Figure 4. Visualization of uniqueness of the data in the column.

ReporterAreaCodeM49

Table 33. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeM49
Description M49 area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
Unit

n/a
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
ReporterAreaCodeM49 1 - 3 435.8 4 208 440 643 862 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
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
ReporterAreaCodeM49
100.00%
2.25%
528 44
Continuous Data Distribution
Figure 5. Distribution of values in the column.
Outliers
Figure 6. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 7. Visualization of completeness of the data in the column.
Uniqueness
Figure 8. Visualization of uniqueness of the data in the column.

ReporterAreaCodeISO2

Table 36. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeISO2
Description ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
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
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZA 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
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
ReporterAreaCodeISO2
100.00%
2.25%
NL BS
Completeness
Figure 9. Visualization of completeness of the data in the column.
Uniqueness
Figure 10. Visualization of uniqueness of the data in the column.

ReporterArea

Table 39. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterArea
Description Name of the area (country or region) which has reported the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
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
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Viet Nam 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
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
ReporterArea
100.00%
2.25%
Netherlands (Kingdom of the) Bahamas
Completeness
Figure 11. Visualization of completeness of the data in the column.
Uniqueness
Figure 12. Visualization of uniqueness of the data in the column.

PartnerAreaCodeFAO

Table 42. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeFAO
Description FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
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
PartnerAreaCodeFAO 1 - 3 139.1 1 79 150 203 299 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
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
PartnerAreaCodeFAO
100.00%
2.90%
150 19
Continuous Data Distribution
Figure 13. Distribution of values in the column.
Outliers
Figure 14. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 15. Visualization of completeness of the data in the column.
Uniqueness
Figure 16. Visualization of uniqueness of the data in the column.

PartnerAreaCodeM49

Table 45. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeM49
Description M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
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
PartnerAreaCodeM49 1 - 3 443.5 4 218 422 703 894 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
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
PartnerAreaCodeM49
100.00%
2.90%
528 68
Continuous Data Distribution
Figure 17. Distribution of values in the column.
Outliers
Figure 18. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 19. Visualization of completeness of the data in the column.
Uniqueness
Figure 20. Visualization of uniqueness of the data in the column.

PartnerAreaCodeISO2

Table 48. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeISO2
Description ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
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
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
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
PartnerAreaCodeISO2
100.00%
2.90%
NL BO
Completeness
Figure 21. Visualization of completeness of the data in the column.
Uniqueness
Figure 22. Visualization of uniqueness of the data in the column.

PartnerArea

Table 51. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerArea
Description Name of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
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
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
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
PartnerArea
100.00%
2.90%
Netherlands (Kingdom of the) Bolivia (Plurinational State of)
Completeness
Figure 23. Visualization of completeness of the data in the column.
Uniqueness
Figure 24. Visualization of uniqueness of the data in the column.

ItemCodeFAO

Table 54. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeFAO
Description Item code assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Code
0.0.FSTTT423
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
ItemCodeFAO 4 - 4 1,181.0 1,181 1,181 1,181 1,181 1,181 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
ItemCodeFAO
100.00%
0.02%
1181 1181
Data Distribution Top 20
Figure 25. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 26. Distribution of values in the column.
Outliers
Figure 27. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 28. Visualization of completeness of the data in the column.
Uniqueness
Figure 29. Visualization of uniqueness of the data in the column.

ItemCodeCPC

Table 57. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeCPC
Description Central Product Classification (CPC) Code of the item for which the value in the record is reported.
Data type String
Descriptor CPC Code
0.0.CPCCD426
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
ItemCodeCPC 4 - 4 2,196.0 2,196 2,196 2,196 2,196 2,196 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
ItemCodeCPC
100.00%
0.02%
2196 2196
Data Distribution Top 20
Figure 30. Distribution of 20 most common values, from highest to lowest.
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.

Item

Table 60. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Item
Description Name of the item assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Description
FSTTM9.ITEMA214.FSTTT424
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
Item 4 - 4 n/a Bees n/a n/a n/a Bees 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
Item
100.00%
0.02%
Bees Bees
Data Distribution Top 20
Figure 35. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 36. Visualization of completeness of the data in the column.
Uniqueness
Figure 37. Visualization of uniqueness of the data in the column.

ElementCode

Table 63. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ElementCode
Description Element code assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Code
0.0.FSTTL418
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
ElementCode 4 - 4 5,747.2 5,607 5,607 5,607 5,907 5,907 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.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
ElementCode
100.00%
0.04%
5607 5907
Data Distribution Top 20
Figure 38. Distribution of 20 most common values, from highest to lowest.
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.

Element

Table 66. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Element
Description Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Description
0.0.FSTTL419
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
Element 15 - 15 n/a Export Quant… n/a n/a n/a Import Quant… 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.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
Element
100.00%
0.04%
Import Quantity Export Quantity
Data Distribution Top 20
Figure 43. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 44. Visualization of completeness of the data in the column.
Uniqueness
Figure 45. Visualization of uniqueness of the data in the column.

YearCode

Table 69. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name YearCode
Description Year code used by FAOSTAT to describe the period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code
0.0.FSTTY429
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
YearCode 4 - 4 2,014.4 1,986 2,013 2,017 2,020 2,022 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.7%)
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
YearCode
100.00%
0.67%
2022 1996
Data Distribution Top 20
Figure 46. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 47. Distribution of 20 least common values, from lowest to highest.
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.

Year

Table 72. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Year
Description Period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code Description
0.0.FSTTY430
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
Year 4 - 4 2,014.4 1,986 2,013 2,017 2,020 2,022 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.7%)
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
Year
100.00%
0.67%
2022 1996
Data Distribution Top 20
Figure 51. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 52. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 53. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 54. Visualization of completeness of the data in the column.
Uniqueness
Figure 55. Visualization of uniqueness of the data in the column.

Unit

Table 75. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Unit
Description Unit in which the value in the record is reported.
Data type String
Descriptor FAOSTAT Unit
0.0.FSTTN94
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
Unit 2 - 2 n/a No n/a n/a n/a No 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
Unit
100.00%
0.02%
No No
Data Distribution Top 20
Figure 56. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 57. Visualization of completeness of the data in the column.
Uniqueness
Figure 58. Visualization of uniqueness of the data in the column.

Value

Table 78. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Value
Description Trade quantity reported for the item (bees) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)) between reporter and partner country, expressed in the unit [number](https://app.pollinatorhub.eu/dictionary/classes/548), as specified in the record.
Data type Decimal number
Descriptor Decimal Number
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
Value 1 - 9 194,961.2 0 0 0 0 196,484,000 5,520 0 (0.0%) 4,325 (78.4%) 0 (0.0%) 531 (9.6%)
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
Value
100.00%
9.62%
0 206
Continuous Data Distribution
Figure 59. Distribution of values in the column.
Completeness
Figure 60. Visualization of completeness of the data in the column.
Uniqueness
Figure 61. Visualization of uniqueness of the data in the column.

Flag

Table 81. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Flag
Description Flag assigned to the value reported in the record.
Data type String
Descriptor FAOSTAT Flag
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
Flag 1 - 1 n/a A n/a n/a n/a X 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 4 (0.1%)
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
Flag
100.00%
0.07%
A E
Data Distribution Top 20
Figure 62. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 63. Visualization of completeness of the data in the column.
Uniqueness
Figure 64. Visualization of uniqueness of the data in the column.

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

beeswax trade matrix quantity

ReporterAreaCodeFAO

Table 84. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeFAO
Description FAO area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
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
ReporterAreaCodeFAO 1 - 3 131.9 1 68 117 203 299 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
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
ReporterAreaCodeFAO
100.00%
0.48%
79 12
Data Distribution Top 20
Figure 65. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 66. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 67. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 68. Visualization of completeness of the data in the column.
Uniqueness
Figure 69. Visualization of uniqueness of the data in the column.

ReporterAreaCodeM49

Table 87. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeM49
Description M49 area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
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
ReporterAreaCodeM49 1 - 3 437.2 4 246 380 705 894 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
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
ReporterAreaCodeM49
100.00%
0.48%
276 44
Data Distribution Top 20
Figure 70. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 71. Distribution of 20 least common values, from lowest to highest.
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.

ReporterAreaCodeISO2

Table 90. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeISO2
Description ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
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
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
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
ReporterAreaCodeISO2
100.00%
0.48%
DE BS
Data Distribution Top 20
Figure 75. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 76. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 77. Visualization of completeness of the data in the column.
Uniqueness
Figure 78. Visualization of uniqueness of the data in the column.

ReporterArea

Table 93. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterArea
Description Name of the area (country or region) which has reported the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
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
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
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
ReporterArea
100.00%
0.48%
Germany Bahamas
Data Distribution Top 20
Figure 79. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 80. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 81. Visualization of completeness of the data in the column.
Uniqueness
Figure 82. Visualization of uniqueness of the data in the column.

PartnerAreaCodeFAO

Table 96. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeFAO
Description FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
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
PartnerAreaCodeFAO 1 - 3 131.9 1 68 117 203 299 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
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
PartnerAreaCodeFAO
100.00%
0.53%
79 140
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.

PartnerAreaCodeM49

Table 99. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeM49
Description M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
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
PartnerAreaCodeM49 1 - 3 438.9 4 233 384 703 894 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
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
PartnerAreaCodeM49
100.00%
0.53%
276 492
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.

PartnerAreaCodeISO2

Table 102. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeISO2
Description ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
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
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
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
PartnerAreaCodeISO2
100.00%
0.53%
DE MC
Completeness
Figure 91. Visualization of completeness of the data in the column.
Uniqueness
Figure 92. Visualization of uniqueness of the data in the column.

PartnerArea

Table 105. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerArea
Description Name of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
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
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
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
PartnerArea
100.00%
0.53%
Germany Monaco
Completeness
Figure 93. Visualization of completeness of the data in the column.
Uniqueness
Figure 94. Visualization of uniqueness of the data in the column.

ItemCodeFAO

Table 108. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeFAO
Description Item code assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Code
0.0.FSTTT423
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
ItemCodeFAO 4 - 4 1,183.0 1,183 1,183 1,183 1,183 1,183 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
ItemCodeFAO
100.00%
0.00%
1183 1183
Data Distribution Top 20
Figure 95. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 96. Distribution of values in the column.
Outliers
Figure 97. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 98. Visualization of completeness of the data in the column.
Uniqueness
Figure 99. Visualization of uniqueness of the data in the column.

ItemCodeCPC

Table 111. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeCPC
Description Central Product Classification (CPC) Code of the item for which the value in the record is reported.
Data type String
Descriptor CPC Code
0.0.CPCCD426
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
ItemCodeCPC 8 - 8 2,960.010 2,960.01 2,960.01 2,960.01 2,960.01 2,960.01 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
ItemCodeCPC
100.00%
0.00%
02960.01 02960.01
Data Distribution Top 20
Figure 100. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 101. Distribution of values in the column.
Outliers
Figure 102. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 103. Visualization of completeness of the data in the column.
Uniqueness
Figure 104. Visualization of uniqueness of the data in the column.

Item

Table 114. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Item
Description Name of the item assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Description
FSTTM9.ITEMA214.FSTTT424
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
Item 7 - 7 n/a Beeswax n/a n/a n/a Beeswax 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
Item
100.00%
0.00%
Beeswax Beeswax
Data Distribution Top 20
Figure 105. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 106. Visualization of completeness of the data in the column.
Uniqueness
Figure 107. Visualization of uniqueness of the data in the column.

ElementCode

Table 117. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ElementCode
Description Element code assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Code
0.0.FSTTL418
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
ElementCode 4 - 4 5,758.6 5,610 5,610 5,610 5,910 5,910 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.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
ElementCode
100.00%
0.01%
5610 5910
Data Distribution Top 20
Figure 108. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 109. Distribution of values in the column.
Outliers
Figure 110. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 111. Visualization of completeness of the data in the column.
Uniqueness
Figure 112. Visualization of uniqueness of the data in the column.

Element

Table 120. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Element
Description Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Description
0.0.FSTTL419
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
Element 15 - 15 n/a Export Quant… n/a n/a n/a Import Quant… 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.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
Element
100.00%
0.01%
Import Quantity Export Quantity
Data Distribution Top 20
Figure 113. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 114. Visualization of completeness of the data in the column.
Uniqueness
Figure 115. Visualization of uniqueness of the data in the column.

YearCode

Table 123. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name YearCode
Description Year code used by FAOSTAT to describe the period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code
0.0.FSTTY429
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
YearCode 4 - 4 2,008.0 1,986 2,000 2,010 2,017 2,022 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.1%)
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
YearCode
100.00%
0.10%
2021 1988
Data Distribution Top 20
Figure 116. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 117. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 118. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 119. Visualization of completeness of the data in the column.
Uniqueness
Figure 120. Visualization of uniqueness of the data in the column.

Year

Table 126. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Year
Description Period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code Description
0.0.FSTTY430
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
Year 4 - 4 2,008.0 1,986 2,000 2,010 2,017 2,022 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.1%)
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
Year
100.00%
0.10%
2021 1988
Data Distribution Top 20
Figure 121. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 122. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 123. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 124. Visualization of completeness of the data in the column.
Uniqueness
Figure 125. Visualization of uniqueness of the data in the column.

Unit

Table 129. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Unit
Description Unit in which the value in the record is reported.
Data type String
Descriptor FAOSTAT Unit
0.0.FSTTN94
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
Unit 1 - 1 n/a t n/a n/a n/a t 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
Unit
100.00%
0.00%
t t
Data Distribution Top 20
Figure 126. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 127. Visualization of completeness of the data in the column.
Uniqueness
Figure 128. Visualization of uniqueness of the data in the column.

Value

Table 132. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Value
Description Trade quantity reported for the item ([beeswax](https://app.pollinatorhub.eu/dictionary/classes/1159)) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)) between reporter and partner country, expressed in the unit [tonnes](https://app.pollinatorhub.eu/dictionary/classes/594), as specified in the record.
Data type Decimal number
Descriptor Decimal Number
0.0.DCMLN314
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 1 - 7 28.022 0 0.01 1.08 11 19,476 38,706 0 (0.0%) 9,541 (24.6%) 0 (0.0%) 3,704 (9.6%)
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
100.00%
9.57%
0 123.36
Continuous Data Distribution
Figure 129. Distribution of values in the column.
Outliers
Figure 130. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 131. Visualization of completeness of the data in the column.
Uniqueness
Figure 132. Visualization of uniqueness of the data in the column.

Flag

Table 135. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Flag
Description Flag assigned to the value reported in the record.
Data type String
Descriptor FAOSTAT Flag
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
Flag 1 - 1 n/a A n/a n/a n/a X 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 4 (0.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
Flag
100.00%
0.01%
A E
Data Distribution Top 20
Figure 133. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 134. Visualization of completeness of the data in the column.
Uniqueness
Figure 135. Visualization of uniqueness of the data in the column.

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

honey trade matrix quantity

ReporterAreaCodeFAO

Table 138. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeFAO
Description FAO area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
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
ReporterAreaCodeFAO 1 - 3 131.8 1 68 126 203 299 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
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
ReporterAreaCodeFAO
100.00%
0.17%
79 244
Data Distribution Top 20
Figure 136. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 137. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 138. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 139. Visualization of completeness of the data in the column.
Uniqueness
Figure 140. Visualization of uniqueness of the data in the column.

ReporterAreaCodeM49

Table 141. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeM49
Description M49 area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
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
ReporterAreaCodeM49 1 - 3 437.9 4 231 410 702 894 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
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
ReporterAreaCodeM49
100.00%
0.17%
276 882
Data Distribution Top 20
Figure 141. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 142. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 143. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 144. Visualization of completeness of the data in the column.
Uniqueness
Figure 145. Visualization of uniqueness of the data in the column.

ReporterAreaCodeISO2

Table 144. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeISO2
Description ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
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
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
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
ReporterAreaCodeISO2
100.00%
0.17%
DE WS
Data Distribution Top 20
Figure 146. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 147. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 148. Visualization of completeness of the data in the column.
Uniqueness
Figure 149. Visualization of uniqueness of the data in the column.

ReporterArea

Table 147. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterArea
Description Name of the area (country or region) which has reported the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
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
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
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
ReporterArea
100.00%
0.17%
Germany Samoa
Data Distribution Top 20
Figure 150. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 151. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 152. Visualization of completeness of the data in the column.
Uniqueness
Figure 153. Visualization of uniqueness of the data in the column.

PartnerAreaCodeFAO

Table 150. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeFAO
Description FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
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
PartnerAreaCodeFAO 1 - 3 133.2 1 68 126 203 299 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
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
PartnerAreaCodeFAO
100.00%
0.19%
231 218
Data Distribution Top 20
Figure 154. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 155. Distribution of 20 least common values, from lowest to highest.
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.

PartnerAreaCodeM49

Table 153. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeM49
Description M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
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
PartnerAreaCodeM49 1 - 3 446.4 4 233 414 702 894 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
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
PartnerAreaCodeM49
100.00%
0.19%
840 772
Data Distribution Top 20
Figure 159. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 160. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 161. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 162. Visualization of completeness of the data in the column.
Uniqueness
Figure 163. Visualization of uniqueness of the data in the column.

PartnerAreaCodeISO2

Table 156. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeISO2
Description ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
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
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
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
PartnerAreaCodeISO2
100.00%
0.19%
US TK
Data Distribution Top 20
Figure 164. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 165. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 166. Visualization of completeness of the data in the column.
Uniqueness
Figure 167. Visualization of uniqueness of the data in the column.

PartnerArea

Table 159. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerArea
Description Name of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
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
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
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
PartnerArea
100.00%
0.19%
United States of America Tokelau
Data Distribution Top 20
Figure 168. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 169. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 170. Visualization of completeness of the data in the column.
Uniqueness
Figure 171. Visualization of uniqueness of the data in the column.

ItemCodeFAO

Table 162. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeFAO
Description Item code assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Code
0.0.FSTTT423
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
ItemCodeFAO 4 - 4 1,182.0 1,182 1,182 1,182 1,182 1,182 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
ItemCodeFAO
100.00%
0.00%
1182 1182
Data Distribution Top 20
Figure 172. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 173. Distribution of values in the column.
Outliers
Figure 174. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 175. Visualization of completeness of the data in the column.
Uniqueness
Figure 176. Visualization of uniqueness of the data in the column.

ItemCodeCPC

Table 165. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeCPC
Description Central Product Classification (CPC) Code of the item for which the value in the record is reported.
Data type String
Descriptor CPC Code
0.0.CPCCD426
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
ItemCodeCPC 4 - 4 2,910.0 2,910 2,910 2,910 2,910 2,910 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
ItemCodeCPC
100.00%
0.00%
2910 2910
Data Distribution Top 20
Figure 177. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 178. Distribution of values in the column.
Outliers
Figure 179. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 180. Visualization of completeness of the data in the column.
Uniqueness
Figure 181. Visualization of uniqueness of the data in the column.

Item

Table 168. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Item
Description Name of the item assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Description
FSTTM9.ITEMA214.FSTTT424
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
Item 13 - 13 n/a Natural hone… n/a n/a n/a Natural hone… 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
Item
100.00%
0.00%
Natural honey Natural honey
Data Distribution Top 20
Figure 182. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 183. Visualization of completeness of the data in the column.
Uniqueness
Figure 184. Visualization of uniqueness of the data in the column.

ElementCode

Table 171. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ElementCode
Description Element code assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Code
0.0.FSTTL418
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
ElementCode 4 - 4 5,759.3 5,610 5,610 5,610 5,910 5,910 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
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
ElementCode
100.00%
0.00%
5610 5910
Data Distribution Top 20
Figure 185. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 186. Distribution of values in the column.
Outliers
Figure 187. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 188. Visualization of completeness of the data in the column.
Uniqueness
Figure 189. Visualization of uniqueness of the data in the column.

Element

Table 174. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Element
Description Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Description
0.0.FSTTL419
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
Element 15 - 15 n/a Export Quant… n/a n/a n/a Import Quant… 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
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
Element
100.00%
0.00%
Import Quantity Export Quantity
Data Distribution Top 20
Figure 190. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 191. Visualization of completeness of the data in the column.
Uniqueness
Figure 192. Visualization of uniqueness of the data in the column.

YearCode

Table 177. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name YearCode
Description Year code used by FAOSTAT to describe the period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code
0.0.FSTTY429
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
YearCode 4 - 4 2,009.2 1,986 2,002 2,011 2,017 2,022 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.0%)
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
YearCode
100.00%
0.03%
2021 1987
Data Distribution Top 20
Figure 193. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 194. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 195. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 196. Visualization of completeness of the data in the column.
Uniqueness
Figure 197. Visualization of uniqueness of the data in the column.

Year

Table 180. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Year
Description Period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code Description
0.0.FSTTY430
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
Year 4 - 4 2,009.2 1,986 2,002 2,011 2,017 2,022 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.0%)
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
Year
100.00%
0.03%
2021 1987
Data Distribution Top 20
Figure 198. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 199. Distribution of 20 least common values, from lowest to highest.
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.

Unit

Table 183. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Unit
Description Unit in which the value in the record is reported.
Data type String
Descriptor FAOSTAT Unit
0.0.FSTTN94
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
Unit 1 - 1 n/a t n/a n/a n/a t 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
Unit
100.00%
0.00%
t t
Data Distribution Top 20
Figure 203. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 204. Visualization of completeness of the data in the column.
Uniqueness
Figure 205. Visualization of uniqueness of the data in the column.

Value

Table 186. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Value
Description Trade quantity reported for the item (honey) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)), expressed in the unit [tonnes](https://app.pollinatorhub.eu/dictionary/classes/594) between reporter and partner country, as specified in the record.
Data type Decimal number
Descriptor Decimal Number
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
Value 1 - 7 281.392 0 0.24 5 51 70,256.4 109,889 0 (0.0%) 17,652 (16.1%) 0 (0.0%) 16,025 (14.6%)
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
Value
100.00%
14.58%
0 1829
Continuous Data Distribution
Figure 206. Distribution of values in the column.
Outliers
Figure 207. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 208. Visualization of completeness of the data in the column.
Uniqueness
Figure 209. Visualization of uniqueness of the data in the column.

Flag

Table 189. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Flag
Description Flag assigned to the value reported in the record.
Data type String
Descriptor FAOSTAT Flag
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
Flag 1 - 1 n/a A n/a n/a n/a X 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 4 (0.0%)
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
Flag
100.00%
0.00%
A E
Data Distribution Top 20
Figure 210. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 211. Visualization of completeness of the data in the column.
Uniqueness
Figure 212. Visualization of uniqueness of the data in the column.

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

honey trade matrix value

ElementCode

Table 192. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ElementCode
Description Element code assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Code
0.0.FSTTL418
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
ElementCode 4 - 4 5,771.3 5,622 5,622 5,622 5,922 5,922 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
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
ElementCode
100.00%
0.00%
5622 5922
Data Distribution Top 20
Figure 213. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 214. Distribution of values in the column.
Outliers
Figure 215. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 216. Visualization of completeness of the data in the column.
Uniqueness
Figure 217. Visualization of uniqueness of the data in the column.

Element

Table 195. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Element
Description Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Description
0.0.FSTTL419
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
Element 12 - 12 n/a Export Value n/a n/a n/a Import Value 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
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
Element
100.00%
0.00%
Import Value Export Value
Data Distribution Top 20
Figure 218. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 219. Visualization of completeness of the data in the column.
Uniqueness
Figure 220. Visualization of uniqueness of the data in the column.

ItemCodeCPC

Table 198. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeCPC
Description Central Product Classification (CPC) Code of the item for which the value in the record is reported.
Data type String
Descriptor CPC Code
0.0.CPCCD426
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
ItemCodeCPC 4 - 4 2,910.0 2,910 2,910 2,910 2,910 2,910 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
ItemCodeCPC
100.00%
0.00%
2910 2910
Data Distribution Top 20
Figure 221. Distribution of 20 most common values, from highest to lowest.
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.

ItemCodeFAO

Table 201. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeFAO
Description Item code assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Code
0.0.FSTTT423
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
ItemCodeFAO 4 - 4 1,182.0 1,182 1,182 1,182 1,182 1,182 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
ItemCodeFAO
100.00%
0.00%
1182 1182
Data Distribution Top 20
Figure 226. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 227. Distribution of values in the column.
Outliers
Figure 228. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 229. Visualization of completeness of the data in the column.
Uniqueness
Figure 230. Visualization of uniqueness of the data in the column.

Item

Table 204. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Item
Description Name of the item assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Description
FSTTM9.ITEMA214.FSTTT424
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
Item 13 - 13 n/a Natural hone… n/a n/a n/a Natural hone… 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
Item
100.00%
0.00%
Natural honey Natural honey
Data Distribution Top 20
Figure 231. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 232. Visualization of completeness of the data in the column.
Uniqueness
Figure 233. Visualization of uniqueness of the data in the column.

YearCode

Table 207. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name YearCode
Description Year code used by FAOSTAT to describe the period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code
0.0.FSTTY429
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
YearCode 4 - 4 2,009.2 1,986 2,002 2,011 2,017 2,022 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.0%)
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
YearCode
100.00%
0.03%
2021 1987
Data Distribution Top 20
Figure 234. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 235. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 236. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 237. Visualization of completeness of the data in the column.
Uniqueness
Figure 238. Visualization of uniqueness of the data in the column.

Year

Table 210. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Year
Description Period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code Description
0.0.FSTTY430
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
Year 4 - 4 2,009.2 1,986 2,002 2,011 2,017 2,022 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.0%)
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
Year
100.00%
0.03%
2021 1987
Data Distribution Top 20
Figure 239. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 240. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 241. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 242. Visualization of completeness of the data in the column.
Uniqueness
Figure 243. Visualization of uniqueness of the data in the column.

Unit

Table 213. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Unit
Description Unit in which the value in the record is reported.
Data type String
Descriptor FAOSTAT Unit
0.0.FSTTN94
Unit

n/a
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
Unit 8 - 8 n/a 1000 USD n/a n/a n/a 1000 USD 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
Unit
100.00%
0.00%
1000 USD 1000 USD
Data Distribution Top 20
Figure 244. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 245. Visualization of completeness of the data in the column.
Uniqueness
Figure 246. Visualization of uniqueness of the data in the column.

Value

Table 216. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Value
Description Trade value reported for the item (honey) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)), expressed in the unit [1000 USD](https://app.pollinatorhub.eu/dictionary/classes/513) between reporter and partner country, as specified in the record.
Data type Integer number
Descriptor Integer
0.0.NTGER313
Unit

n/a
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
Value 1 - 6 727.0 0 2 21 166 219,749 109,889 0 (0.0%) 15,852 (14.4%) 0 (0.0%) 6,840 (6.2%)
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
Value
100.00%
6.22%
0 4051
Continuous Data Distribution
Figure 247. Distribution of values in the column.
Outliers
Figure 248. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 249. Visualization of completeness of the data in the column.
Uniqueness
Figure 250. Visualization of uniqueness of the data in the column.

Flag

Table 219. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Flag
Description Flag assigned to the value reported in the record.
Data type String
Descriptor FAOSTAT Flag
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
Flag 1 - 1 n/a A n/a n/a n/a X 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 3 (0.0%)
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
Flag
100.00%
0.00%
A E
Data Distribution Top 20
Figure 251. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 252. Visualization of completeness of the data in the column.
Uniqueness
Figure 253. Visualization of uniqueness of the data in the column.

ReporterAreaCodeFAO

Table 222. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeFAO
Description FAO area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
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
ReporterAreaCodeFAO 1 - 3 131.8 1 68 126 203 299 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
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
ReporterAreaCodeFAO
100.00%
0.17%
79 244
Data Distribution Top 20
Figure 254. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 255. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 256. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 257. Visualization of completeness of the data in the column.
Uniqueness
Figure 258. Visualization of uniqueness of the data in the column.

ReporterAreaCodeM49

Table 225. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeM49
Description M49 area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
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
ReporterAreaCodeM49 1 - 3 437.9 4 231 410 702 894 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
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
ReporterAreaCodeM49
100.00%
0.17%
276 882
Data Distribution Top 20
Figure 259. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 260. Distribution of 20 least common values, from lowest to highest.
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.

ReporterAreaCodeISO2

Table 228. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeISO2
Description ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
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
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
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
ReporterAreaCodeISO2
100.00%
0.17%
DE WS
Data Distribution Top 20
Figure 264. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 265. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 266. Visualization of completeness of the data in the column.
Uniqueness
Figure 267. Visualization of uniqueness of the data in the column.

ReporterArea

Table 231. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterArea
Description Name of the area (country or region) which has reported the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
Unit

n/a
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
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 189 (0.2%)
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
ReporterArea
100.00%
0.17%
Germany Samoa
Data Distribution Top 20
Figure 268. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 269. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 270. Visualization of completeness of the data in the column.
Uniqueness
Figure 271. Visualization of uniqueness of the data in the column.

PartnerAreaCodeFAO

Table 234. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeFAO
Description FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
Unit

n/a
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
PartnerAreaCodeFAO 1 - 3 133.2 1 68 126 203 299 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
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
PartnerAreaCodeFAO
100.00%
0.19%
231 218
Data Distribution Top 20
Figure 272. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 273. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 274. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 275. Visualization of completeness of the data in the column.
Uniqueness
Figure 276. Visualization of uniqueness of the data in the column.

PartnerAreaCodeM49

Table 237. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeM49
Description M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
Unit

n/a
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
PartnerAreaCodeM49 1 - 3 446.4 4 233 414 702 894 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.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
PartnerAreaCodeM49
100.00%
0.19%
840 772
Data Distribution Top 20
Figure 277. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 278. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 279. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 280. Visualization of completeness of the data in the column.
Uniqueness
Figure 281. Visualization of uniqueness of the data in the column.

PartnerAreaCodeISO2

Table 240. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeISO2
Description ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
Unit

n/a
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
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
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
PartnerAreaCodeISO2
100.00%
0.19%
US TK
Data Distribution Top 20
Figure 282. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 283. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 284. Visualization of completeness of the data in the column.
Uniqueness
Figure 285. Visualization of uniqueness of the data in the column.

PartnerArea

Table 243. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerArea
Description Name of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
Unit

n/a
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
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 109,889 0 (0.0%) 0 (0.0%) 0 (0.0%) 210 (0.2%)
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
PartnerArea
100.00%
0.19%
United States of America Tokelau
Data Distribution Top 20
Figure 286. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 287. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 288. Visualization of completeness of the data in the column.
Uniqueness
Figure 289. Visualization of uniqueness of the data in the column.

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

beeswax trade matrix value

ElementCode

Table 246. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ElementCode
Description Element code assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Code
0.0.FSTTL418
Unit

n/a
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
ElementCode 4 - 4 5,770.6 5,622 5,622 5,622 5,922 5,922 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
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
ElementCode
100.00%
0.01%
5622 5922
Data Distribution Top 20
Figure 290. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 291. Distribution of values in the column.
Outliers
Figure 292. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 293. Visualization of completeness of the data in the column.
Uniqueness
Figure 294. Visualization of uniqueness of the data in the column.

Element

Table 249. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Element
Description Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Description
0.0.FSTTL419
Unit

n/a
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
Element 12 - 12 n/a Export Value n/a n/a n/a Import Value 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
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
Element
100.00%
0.01%
Import Value Export Value
Data Distribution Top 20
Figure 295. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 296. Visualization of completeness of the data in the column.
Uniqueness
Figure 297. Visualization of uniqueness of the data in the column.

ItemCodeCPC

Table 252. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeCPC
Description Central Product Classification (CPC) Code of the item for which the value in the record is reported.
Data type String
Descriptor CPC Code
0.0.CPCCD426
Unit

n/a
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
ItemCodeCPC 8 - 8 2,960.010 2,960.01 2,960.01 2,960.01 2,960.01 2,960.01 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.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
ItemCodeCPC
100.00%
0.00%
02960.01 02960.01
Data Distribution Top 20
Figure 298. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 299. Distribution of values in the column.
Outliers
Figure 300. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 301. Visualization of completeness of the data in the column.
Uniqueness
Figure 302. Visualization of uniqueness of the data in the column.

ItemCodeFAO

Table 255. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeFAO
Description Item code assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Code
0.0.FSTTT423
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
ItemCodeFAO 4 - 4 1,183.0 1,183 1,183 1,183 1,183 1,183 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
ItemCodeFAO
100.00%
0.00%
1183 1183
Data Distribution Top 20
Figure 303. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 304. Distribution of values in the column.
Outliers
Figure 305. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 306. Visualization of completeness of the data in the column.
Uniqueness
Figure 307. Visualization of uniqueness of the data in the column.

Item

Table 258. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Item
Description Name of the item assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Description
FSTTM9.ITEMA214.FSTTT424
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
Item 7 - 7 n/a Beeswax n/a n/a n/a Beeswax 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
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
Item
100.00%
0.00%
Beeswax Beeswax
Data Distribution Top 20
Figure 308. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 309. Visualization of completeness of the data in the column.
Uniqueness
Figure 310. Visualization of uniqueness of the data in the column.

YearCode

Table 261. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name YearCode
Description Year code used by FAOSTAT to describe the period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code
0.0.FSTTY429
Unit

n/a
Table 262. 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
YearCode 4 - 4 2,008.0 1,986 2,000 2,010 2,017 2,022 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.1%)
Table 263. 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
YearCode
100.00%
0.10%
2021 1988
Data Distribution Top 20
Figure 311. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 312. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 313. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 314. Visualization of completeness of the data in the column.
Uniqueness
Figure 315. Visualization of uniqueness of the data in the column.

Year

Table 264. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Year
Description Period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code Description
0.0.FSTTY430
Unit

n/a
Table 265. 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,008.0 1,986 2,000 2,010 2,017 2,022 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.1%)
Table 266. 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%
0.10%
2021 1988
Data Distribution Top 20
Figure 316. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 317. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 318. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 319. Visualization of completeness of the data in the column.
Uniqueness
Figure 320. Visualization of uniqueness of the data in the column.

Unit

Table 267. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Unit
Description Unit in which the value in the record is reported.
Data type String
Descriptor FAOSTAT Unit
0.0.FSTTN94
Unit

n/a
Table 268. 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
Unit 8 - 8 n/a 1000 USD n/a n/a n/a 1000 USD 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Table 269. 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
Unit
100.00%
0.00%
1000 USD 1000 USD
Data Distribution Top 20
Figure 321. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 322. Visualization of completeness of the data in the column.
Uniqueness
Figure 323. Visualization of uniqueness of the data in the column.

Value

Table 270. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Value
Description Trade value reported for the item ([beeswax](https://app.pollinatorhub.eu/dictionary/classes/1159)) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)) between reporter and partner country, expressed in the unit [1000 USD](https://app.pollinatorhub.eu/dictionary/classes/513), as specified in the record.
Data type Integer number
Descriptor Integer
0.0.NTGER313
Unit

n/a
Table 271. 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 1 - 5 126.0 0 2 9 56 18,480 38,706 0 (0.0%) 6,023 (15.6%) 0 (0.0%) 1,673 (4.3%)
Table 272. 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
100.00%
4.32%
0 1768
Continuous Data Distribution
Figure 324. Distribution of values in the column.
Outliers
Figure 325. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 326. Visualization of completeness of the data in the column.
Uniqueness
Figure 327. Visualization of uniqueness of the data in the column.

Flag

Table 273. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Flag
Description Flag assigned to the value reported in the record.
Data type String
Descriptor FAOSTAT Flag
Unit

n/a
Table 274. 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
Flag 1 - 1 n/a A n/a n/a n/a X 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Table 275. 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
Flag
100.00%
0.01%
A X
Data Distribution Top 20
Figure 328. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 329. Visualization of completeness of the data in the column.
Uniqueness
Figure 330. Visualization of uniqueness of the data in the column.

ReporterAreaCodeFAO

Table 276. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeFAO
Description FAO area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
Unit

n/a
Table 277. 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
ReporterAreaCodeFAO 1 - 3 131.9 1 68 117 203 299 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
Table 278. 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
ReporterAreaCodeFAO
100.00%
0.48%
79 12
Data Distribution Top 20
Figure 331. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 332. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 333. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 334. Visualization of completeness of the data in the column.
Uniqueness
Figure 335. Visualization of uniqueness of the data in the column.

ReporterAreaCodeM49

Table 279. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeM49
Description M49 area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
Unit

n/a
Table 280. 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
ReporterAreaCodeM49 1 - 3 437.2 4 246 380 705 894 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
Table 281. 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
ReporterAreaCodeM49
100.00%
0.48%
276 44
Data Distribution Top 20
Figure 336. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 337. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 338. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 339. Visualization of completeness of the data in the column.
Uniqueness
Figure 340. Visualization of uniqueness of the data in the column.

ReporterAreaCodeISO2

Table 282. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeISO2
Description ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
Unit

n/a
Table 283. 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
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
Table 284. 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
ReporterAreaCodeISO2
100.00%
0.48%
DE BS
Data Distribution Top 20
Figure 341. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 342. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 343. Visualization of completeness of the data in the column.
Uniqueness
Figure 344. Visualization of uniqueness of the data in the column.

ReporterArea

Table 285. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterArea
Description Name of the area (country or region) which has reported the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
Unit

n/a
Table 286. 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
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 184 (0.5%)
Table 287. 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
ReporterArea
100.00%
0.48%
Germany Bahamas
Data Distribution Top 20
Figure 345. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 346. Distribution of 20 least common values, from lowest to highest.
Completeness
Figure 347. Visualization of completeness of the data in the column.
Uniqueness
Figure 348. Visualization of uniqueness of the data in the column.

PartnerAreaCodeFAO

Table 288. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeFAO
Description FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
Unit

n/a
Table 289. 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
PartnerAreaCodeFAO 1 - 3 131.9 1 68 117 203 299 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
Table 290. 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
PartnerAreaCodeFAO
100.00%
0.53%
79 140
Continuous Data Distribution
Figure 349. Distribution of values in the column.
Outliers
Figure 350. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 351. Visualization of completeness of the data in the column.
Uniqueness
Figure 352. Visualization of uniqueness of the data in the column.

PartnerAreaCodeM49

Table 291. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeM49
Description M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
Unit

n/a
Table 292. 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
PartnerAreaCodeM49 1 - 3 438.9 4 233 384 703 894 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
Table 293. 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
PartnerAreaCodeM49
100.00%
0.53%
276 492
Continuous Data Distribution
Figure 353. Distribution of values in the column.
Outliers
Figure 354. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 355. Visualization of completeness of the data in the column.
Uniqueness
Figure 356. Visualization of uniqueness of the data in the column.

PartnerAreaCodeISO2

Table 294. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeISO2
Description ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
Unit

n/a
Table 295. 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
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
Table 296. 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
PartnerAreaCodeISO2
100.00%
0.53%
DE MC
Completeness
Figure 357. Visualization of completeness of the data in the column.
Uniqueness
Figure 358. Visualization of uniqueness of the data in the column.

PartnerArea

Table 297. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerArea
Description Name of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
Unit

n/a
Table 298. 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
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 38,706 0 (0.0%) 0 (0.0%) 0 (0.0%) 207 (0.5%)
Table 299. 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
PartnerArea
100.00%
0.53%
Germany Monaco
Completeness
Figure 359. Visualization of completeness of the data in the column.
Uniqueness
Figure 360. Visualization of uniqueness of the data in the column.

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

bees trade matrix value

ElementCode

Table 300. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ElementCode
Description Element code assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Code
0.0.FSTTL418
Unit

n/a
Table 301. 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
ElementCode 4 - 4 5,762.2 5,622 5,622 5,622 5,922 5,922 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Table 302. 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
ElementCode
100.00%
0.04%
5622 5922
Data Distribution Top 20
Figure 361. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 362. Distribution of values in the column.
Outliers
Figure 363. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 364. Visualization of completeness of the data in the column.
Uniqueness
Figure 365. Visualization of uniqueness of the data in the column.

Element

Table 303. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Element
Description Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Element Description
0.0.FSTTL419
Unit

n/a
Table 304. 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
Element 12 - 12 n/a Export Value n/a n/a n/a Import Value 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 2 (0.0%)
Table 305. 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
Element
100.00%
0.04%
Import Value Export Value
Data Distribution Top 20
Figure 366. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 367. Visualization of completeness of the data in the column.
Uniqueness
Figure 368. Visualization of uniqueness of the data in the column.

ItemCodeCPC

Table 306. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeCPC
Description Central Product Classification (CPC) Code of the item for which the value in the record is reported.
Data type String
Descriptor CPC Code
0.0.CPCCD426
Unit

n/a
Table 307. 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
ItemCodeCPC 4 - 4 2,196.0 2,196 2,196 2,196 2,196 2,196 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Table 308. 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
ItemCodeCPC
100.00%
0.02%
2196 2196
Data Distribution Top 20
Figure 369. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 370. Distribution of values in the column.
Outliers
Figure 371. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 372. Visualization of completeness of the data in the column.
Uniqueness
Figure 373. Visualization of uniqueness of the data in the column.

ItemCodeFAO

Table 309. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ItemCodeFAO
Description Item code assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Code
0.0.FSTTT423
Unit

n/a
Table 310. 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
ItemCodeFAO 4 - 4 1,181.0 1,181 1,181 1,181 1,181 1,181 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Table 311. 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
ItemCodeFAO
100.00%
0.02%
1181 1181
Data Distribution Top 20
Figure 374. Distribution of 20 most common values, from highest to lowest.
Continuous Data Distribution
Figure 375. Distribution of values in the column.
Outliers
Figure 376. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 377. Visualization of completeness of the data in the column.
Uniqueness
Figure 378. Visualization of uniqueness of the data in the column.

Item

Table 312. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Item
Description Name of the item assigned by FAOSTAT to the value reported in the record.
Data type String
Descriptor FAOSTAT Item Description
FSTTM9.ITEMA214.FSTTT424
Unit

n/a
Table 313. 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
Item 4 - 4 n/a Bees n/a n/a n/a Bees 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Table 314. 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
Item
100.00%
0.02%
Bees Bees
Data Distribution Top 20
Figure 379. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 380. Visualization of completeness of the data in the column.
Uniqueness
Figure 381. Visualization of uniqueness of the data in the column.

YearCode

Table 315. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name YearCode
Description Year code used by FAOSTAT to describe the period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code
0.0.FSTTY429
Unit

n/a
Table 316. 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
YearCode 4 - 4 2,014.4 1,986 2,013 2,017 2,020 2,022 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.7%)
Table 317. 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
YearCode
100.00%
0.67%
2022 1996
Data Distribution Top 20
Figure 382. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 383. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 384. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 385. Visualization of completeness of the data in the column.
Uniqueness
Figure 386. Visualization of uniqueness of the data in the column.

Year

Table 318. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Year
Description Period for which the value in the record is reported.
Data type String
Descriptor FAOSTAT Year Code Description
0.0.FSTTY430
Unit

n/a
Table 319. 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,014.4 1,986 2,013 2,017 2,020 2,022 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 37 (0.7%)
Table 320. 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%
0.67%
2022 1996
Data Distribution Top 20
Figure 387. Distribution of 20 most common values, from highest to lowest.
Data Distribution Bottom 20
Figure 388. Distribution of 20 least common values, from lowest to highest.
Outliers
Figure 389. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 390. Visualization of completeness of the data in the column.
Uniqueness
Figure 391. Visualization of uniqueness of the data in the column.

Unit

Table 321. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Unit
Description Unit in which the value in the record is reported.
Data type String
Descriptor FAOSTAT Unit
0.0.FSTTN94
Unit

n/a
Table 322. 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
Unit 8 - 8 n/a 1000 USD n/a n/a n/a 1000 USD 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 1 (0.0%)
Table 323. 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
Unit
100.00%
0.02%
1000 USD 1000 USD
Data Distribution Top 20
Figure 392. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 393. Visualization of completeness of the data in the column.
Uniqueness
Figure 394. Visualization of uniqueness of the data in the column.

Value

Table 324. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Value
Description Trade value reported for the item (bees) and the elements ([import](https://app.pollinatorhub.eu/dictionary/classes/7444), [export](https://app.pollinatorhub.eu/dictionary/classes/7445)) between reporter and partner country, expressed in the unit [1000 USD](https://app.pollinatorhub.eu/dictionary/classes/513), as specified in the record.
Data type Integer number
Descriptor Integer
0.0.NTGER313
Unit

n/a
Table 325. 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 1 - 5 310.4 0 3 13 77 24,303 5,520 0 (0.0%) 552 (10.0%) 0 (0.0%) 835 (15.1%)
Table 326. 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
100.00%
15.13%
0 259
Continuous Data Distribution
Figure 395. Distribution of values in the column.
Outliers
Figure 396. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 397. Visualization of completeness of the data in the column.
Uniqueness
Figure 398. Visualization of uniqueness of the data in the column.

Flag

Table 327. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Flag
Description Flag assigned to the value reported in the record.
Data type String
Descriptor FAOSTAT Flag
Unit

n/a
Table 328. 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
Flag 1 - 1 n/a A n/a n/a n/a X 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 3 (0.1%)
Table 329. 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
Flag
100.00%
0.05%
A E
Data Distribution Top 20
Figure 399. Distribution of 20 most common values, from highest to lowest.
Completeness
Figure 400. Visualization of completeness of the data in the column.
Uniqueness
Figure 401. Visualization of uniqueness of the data in the column.

ReporterAreaCodeFAO

Table 330. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeFAO
Description FAO area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
Unit

n/a
Table 331. 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
ReporterAreaCodeFAO 1 - 3 133.3 1 69.25 138 195 299 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
Table 332. 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
ReporterAreaCodeFAO
100.00%
2.25%
150 12
Continuous Data Distribution
Figure 402. Distribution of values in the column.
Outliers
Figure 403. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 404. Visualization of completeness of the data in the column.
Uniqueness
Figure 405. Visualization of uniqueness of the data in the column.

ReporterAreaCodeM49

Table 333. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeM49
Description M49 area code of the country or region which has reported the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
Unit

n/a
Table 334. 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
ReporterAreaCodeM49 1 - 3 435.8 4 208 440 643 862 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
Table 335. 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
ReporterAreaCodeM49
100.00%
2.25%
528 44
Continuous Data Distribution
Figure 406. Distribution of values in the column.
Outliers
Figure 407. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 408. Visualization of completeness of the data in the column.
Uniqueness
Figure 409. Visualization of uniqueness of the data in the column.

ReporterAreaCodeISO2

Table 336. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterAreaCodeISO2
Description ISO 3166 Alpha-2 code code of the country or region which has reported the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
Unit

n/a
Table 337. 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
ReporterAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZA 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
Table 338. 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
ReporterAreaCodeISO2
100.00%
2.25%
NL BS
Completeness
Figure 410. Visualization of completeness of the data in the column.
Uniqueness
Figure 411. Visualization of uniqueness of the data in the column.

ReporterArea

Table 339. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name ReporterArea
Description Name of the area (country or region) which has reported the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
Unit

n/a
Table 340. 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
ReporterArea 4 - 52 n/a Afghanistan n/a n/a n/a Viet Nam 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 124 (2.2%)
Table 341. 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
ReporterArea
100.00%
2.25%
Netherlands (Kingdom of the) Bahamas
Completeness
Figure 412. Visualization of completeness of the data in the column.
Uniqueness
Figure 413. Visualization of uniqueness of the data in the column.

PartnerAreaCodeFAO

Table 342. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeFAO
Description FAO area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor Faostat Area Code
0.0.FSTTR411
Unit

n/a
Table 343. 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
PartnerAreaCodeFAO 1 - 3 139.1 1 79 150 203 299 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
Table 344. 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
PartnerAreaCodeFAO
100.00%
2.90%
150 19
Continuous Data Distribution
Figure 414. Distribution of values in the column.
Outliers
Figure 415. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 416. Visualization of completeness of the data in the column.
Uniqueness
Figure 417. Visualization of uniqueness of the data in the column.

PartnerAreaCodeM49

Table 345. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeM49
Description M49 area code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Code
0.0.MCODE356
Unit

n/a
Table 346. 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
PartnerAreaCodeM49 1 - 3 443.5 4 218 422 703 894 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
Table 347. 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
PartnerAreaCodeM49
100.00%
2.90%
528 68
Continuous Data Distribution
Figure 418. Distribution of values in the column.
Outliers
Figure 419. Visualization of median, min, max, and outliers in the column.
Completeness
Figure 420. Visualization of completeness of the data in the column.
Uniqueness
Figure 421. Visualization of uniqueness of the data in the column.

PartnerAreaCodeISO2

Table 348. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerAreaCodeISO2
Description ISO 3166 Alpha-2 code of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor alpha-2 country code
0.0.LPHCN4
Unit

n/a
Table 349. 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
PartnerAreaCodeISO2 2 - 4 n/a AE n/a n/a n/a ZW 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
Table 350. 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
PartnerAreaCodeISO2
100.00%
2.90%
NL BO
Completeness
Figure 422. Visualization of completeness of the data in the column.
Uniqueness
Figure 423. Visualization of uniqueness of the data in the column.

PartnerArea

Table 351. Standardised metadata of the column. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name PartnerArea
Description Name of the trade partner country or region for which the reporting country has provided the trade value in the record.
Data type String
Descriptor M49 Area
0.0.MAREA519
Unit

n/a
Table 352. 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
PartnerArea 4 - 52 n/a Afghanistan n/a n/a n/a Zimbabwe 5,520 0 (0.0%) 0 (0.0%) 0 (0.0%) 160 (2.9%)
Table 353. 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
PartnerArea
100.00%
2.90%
Netherlands (Kingdom of the) Bolivia (Plurinational State of)
Completeness
Figure 424. Visualization of completeness of the data in the column.
Uniqueness
Figure 425. Visualization of uniqueness of the data in the column.

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a