EU Pollinator Hub

, ,

Dataset Report
Unique identifier: FSTTT207.0.0
Title: FAOSTAT TM Trade Matrix
Long title: FAOSTAT data on the detailed trade matrix with beekeeping livestock and products
Status: Quality Validated
Current Version: v. 1.0
Published: 2024-04-14
Reviewed by: Rubinigg Michael as Data scientist
Citation proposal:
Food and Agriculture Organization of the United Nations 2024 Report of dataset FAOSTAT TM Trade Matrix, v. 1.0 [FSTTT207.0.0]. EU Pollinator Hub. [2026-04-05] app.pollinatorhub.eu
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
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 2024-04-14. Reviewed by Rubinigg Michael.

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

Abbreviations

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

Executive summary

Data overview:

n/a

Data value:

n/a

Data description:

n/a

Data application:

n/a

Unresolved issues:

n/a

Introduction

n/a

Material and methods

Data acquisition

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
interactions.single.uid FSTTT207.0.0
Title FAOSTAT TM Trade Matrix
Long title FAOSTAT data on the detailed trade matrix with beekeeping livestock and products
Target IRI https://app.pollinatorhub.eu/dataset-discovery/FSTTT207.0.0
interactions.single.section-details.licence CC BY 4.0
DOI n/a
Created 2024-12-02
Published 2024-04-14
Contact 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, Ελλάδα , Κύπρος , България , Северна Македонија, Црна Гора
Abstract

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
Name Food and Agriculture Organization of the United Nations
Url
Acronym FAO
IRI https://app.pollinatorhub.eu/data-providers/food-and-agriculture-organization-of-the-united-nations
Address
Country Italy
Contact 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 dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTT207.BEESA516.0
Name bees trade matrix quantity
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTT207.BEESA516.0
Table Type File
Licence CC BY 4.0
Description

This table contains the trade matrix (quantity of import and export) for honey bees, expressed as number of units of animals, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

This table contains the trade matrix (quantity of import and export) for honey bees, expressed as number of units of animals, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

Metadata

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

FAO area code of the country or region which has reported the trade value in the record.

String faostat:areaCode [0.0.ARECD411]

n/a

ReporterAreaCodeM49

M49 area code of the country or region which has reported the trade value in the record.

String unsd:m49Code [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 iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

ReporterArea

Name of the area (country or region) which has reported the trade value in the record.

String unsd:m49Area [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:areaCode [0.0.ARECD411]

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 unsd:m49Code [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 iso-3166:alpha-2CountryCode [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 unsd:m49Area [0.0.MAREA519]

n/a

ItemCodeFAO

Item code assigned by FAOSTAT to the value reported in the record.

String faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCPC

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

String unsd:cpcCode [0.0.CPCCD426]

n/a

Item

Name of the item assigned by FAOSTAT to the value reported in the record.

String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementCode [0.0.LMNTC418]

n/a

Element

Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementLabel [0.0.LMNTL419]

n/a

YearCode

Year code used by FAOSTAT to describe the period for which the value in the record is reported.

String faostat:yearCode [0.0.YERCD429]

n/a

Year

Period for which the value in the record is reported.

String faostat:yearDescription [0.0.RDSCR430]

n/a

Unit

Unit in which the value in the record is reported.

String faostat:Unit [0.0.UNITA94]

n/a

Value

Trade quantity reported for the item (bees) and the elements (import, export) between reporter and partner country, expressed in the unit number, as specified in the record.

Integer number dwc:measurementValue [0.0.MSRMN621]

n/a

Flag

Flag assigned to the value reported in the record.

String faostat:flag [0.0.FLAGA421]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 8. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 3 - 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 BE n/a n/a n/a F299 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 124 ( 2.2% )
ReporterArea 4 - 52 n/a Fiji n/a n/a n/a United Kingd… 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 3 - 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 AL n/a n/a n/a F248 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 160 ( 2.9% )
PartnerArea 4 - 52 n/a Iraq n/a n/a n/a United Kingd… 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 5 - 5 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 0 - 0 n/a n/a n/a n/a 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 I 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeFAO
100.00%
2.25%
150 12
ReporterAreaCodeM49
100.00%
2.25%
528 044
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 068
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%
02196 02196
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%
0 0
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 dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTT207.BSWAX517.0
Name beeswax trade matrix quantity
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTT207.BSWAX517.0
Table Type File
Licence CC BY 4.0
Description

This table contains the trade matrix (quantity of import and export) for beeswax, expressed as tonnes, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

This table contains the trade matrix (quantity of import and export) for beeswax, expressed as tonnes, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

Metadata

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

FAO area code of the country or region which has reported the trade value in the record.

String faostat:areaCode [0.0.ARECD411]

n/a

ReporterAreaCodeM49

M49 area code of the country or region which has reported the trade value in the record.

String unsd:m49Code [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 iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

ReporterArea

Name of the area (country or region) which has reported the trade value in the record.

String unsd:m49Area [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:areaCode [0.0.ARECD411]

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 unsd:m49Code [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 iso-3166:alpha-2CountryCode [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 unsd:m49Area [0.0.MAREA519]

n/a

ItemCodeFAO

Item code assigned by FAOSTAT to the value reported in the record.

String faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCPC

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

String unsd:cpcCode [0.0.CPCCD426]

n/a

Item

Name of the item assigned by FAOSTAT to the value reported in the record.

String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementCode [0.0.LMNTC418]

n/a

Element

Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementLabel [0.0.LMNTL419]

n/a

YearCode

Year code used by FAOSTAT to describe the period for which the value in the record is reported.

String faostat:yearCode [0.0.YERCD429]

n/a

Year

Period for which the value in the record is reported.

String faostat:yearDescription [0.0.RDSCR430]

n/a

Unit

Unit in which the value in the record is reported.

String faostat:Unit [0.0.UNITA94]

n/a

Value

Trade quantity reported for the item (beeswax) and the elements (import, export) between reporter and partner country, expressed in the unit tonnes, as specified in the record.

Decimal number dwc:measurementValue [0.0.MSRMN621]

n/a

Flag

Flag assigned to the value reported in the record.

String faostat:flag [0.0.FLAGA421]

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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 3 - 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 BB n/a n/a n/a F299 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 184 ( 0.5% )
ReporterArea 4 - 52 n/a Peru n/a n/a n/a United Kingd… 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 3 - 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 AG n/a n/a n/a F299 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 207 ( 0.5% )
PartnerArea 4 - 52 n/a Cuba n/a n/a n/a United Kingd… 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 Import Quant… n/a n/a n/a Export 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 E 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeFAO
100.00%
0.48%
79 12
ReporterAreaCodeM49
100.00%
0.48%
276 044
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 dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTT207.HONEY518.0
Name honey trade matrix quantity
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTT207.HONEY518.0
Table Type File
Licence CC BY 4.0
Description

This table contains the trade matrix (quantity of import and export) for honey, expressed as tonnes, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

This table contains the trade matrix (quantity of import and export) for honey, expressed as tonnes, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

Metadata

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

FAO area code of the country or region which has reported the trade value in the record.

String faostat:areaCode [0.0.ARECD411]

n/a

ReporterAreaCodeM49

M49 area code of the country or region which has reported the trade value in the record.

String unsd:m49Code [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 iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

ReporterArea

Name of the area (country or region) which has reported the trade value in the record.

String unsd:m49Area [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:areaCode [0.0.ARECD411]

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 unsd:m49Code [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 iso-3166:alpha-2CountryCode [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 unsd:m49Area [0.0.MAREA519]

n/a

ItemCodeFAO

Item code assigned by FAOSTAT to the value reported in the record.

String faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCPC

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

String unsd:cpcCode [0.0.CPCCD426]

n/a

Item

Name of the item assigned by FAOSTAT to the value reported in the record.

String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementCode [0.0.LMNTC418]

n/a

Element

Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementLabel [0.0.LMNTL419]

n/a

YearCode

Year code used by FAOSTAT to describe the period for which the value in the record is reported.

String faostat:yearCode [0.0.YERCD429]

n/a

Year

Period for which the value in the record is reported.

String faostat:yearDescription [0.0.RDSCR430]

n/a

Unit

Unit in which the value in the record is reported.

String faostat:Unit [0.0.UNITA94]

n/a

Value

Trade quantity reported for the item (honey) and the elements (import, export), expressed in the unit tonnes between reporter and partner country, as specified in the record.

Decimal number dwc:measurementValue [0.0.MSRMN621]

n/a

Flag

Flag assigned to the value reported in the record.

String faostat:flag [0.0.FLAGA421]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 16. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 3 - 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 AG n/a n/a n/a F299 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 189 ( 0.2% )
ReporterArea 4 - 52 n/a Oman n/a n/a n/a United Kingd… 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 3 - 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 AR n/a n/a n/a F228 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 210 ( 0.2% )
PartnerArea 4 - 52 n/a Cuba n/a n/a n/a United Kingd… 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 5 - 5 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 Import Quant… n/a n/a n/a Export 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 E 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).
Column 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%
02910 02910
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 dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTT207.HNYTR523.0
Name honey trade matrix value
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTT207.HNYTR523.0
Table Type File
Licence CC BY 4.0
Description

This table contains the trade matrix (value of import and export) for honey, expressed as 1000 USD, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

This table contains the trade matrix (value of import and export) for honey, expressed as 1000 USD, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

Metadata

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

FAO area code of the country or region which has reported the trade value in the record.

String faostat:areaCode [0.0.ARECD411]

n/a

ReporterAreaCodeM49

M49 area code of the country or region which has reported the trade value in the record.

String unsd:m49Code [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 iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

ReporterArea

Name of the area (country or region) which has reported the trade value in the record.

String unsd:m49Area [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:areaCode [0.0.ARECD411]

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 unsd:m49Code [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 iso-3166:alpha-2CountryCode [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 unsd:m49Area [0.0.MAREA519]

n/a

ItemCodeFAO

Item code assigned by FAOSTAT to the value reported in the record.

String faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCPC

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

String unsd:cpcCode [0.0.CPCCD426]

n/a

Item

Name of the item assigned by FAOSTAT to the value reported in the record.

String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementCode [0.0.LMNTC418]

n/a

Element

Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementLabel [0.0.LMNTL419]

n/a

YearCode

Year code used by FAOSTAT to describe the period for which the value in the record is reported.

String faostat:yearCode [0.0.YERCD429]

n/a

Year

Period for which the value in the record is reported.

String faostat:yearDescription [0.0.RDSCR430]

n/a

Unit

Unit in which the value in the record is reported.

String faostat:Unit [0.0.UNITA94]

n/a

Value

Trade value reported for the item (honey) and the elements (import, export), expressed in the unit 1000 USD between reporter and partner country, as specified in the record.

String dwc:measurementValue [0.0.MSRMN621]

n/a

Flag

Flag assigned to the value reported in the record.

String faostat:flag [0.0.FLAGA421]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 20. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 3 - 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 AG n/a n/a n/a F299 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 189 ( 0.2% )
ReporterArea 4 - 52 n/a Oman n/a n/a n/a United Kingd… 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 3 - 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 AR n/a n/a n/a F228 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 210 ( 0.2% )
PartnerArea 4 - 52 n/a Cuba n/a n/a n/a United Kingd… 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 5 - 5 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,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 Import Value n/a n/a n/a Export Value 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 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 E 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.0% )

Quality measures

Table 21. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
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%
02910 02910
Item
100.00%
0.00%
Natural honey Natural honey
ElementCode
100.00%
0.00%
5622 5922
Element
100.00%
0.00%
Import Value Export Value
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

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 dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTT207.BSWXT524.0
Name beeswax trade matrix value
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTT207.BSWXT524.0
Table Type File
Licence CC BY 4.0
Description

This table contains the trade matrix (value of import and export) for beeswax, expressed as 1000 USD, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

This table contains the trade matrix (value of import and export) for beeswax, expressed as 1000 USD, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

Metadata

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

FAO area code of the country or region which has reported the trade value in the record.

String faostat:areaCode [0.0.ARECD411]

n/a

ReporterAreaCodeM49

M49 area code of the country or region which has reported the trade value in the record.

String unsd:m49Code [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 iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

ReporterArea

Name of the area (country or region) which has reported the trade value in the record.

String unsd:m49Area [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:areaCode [0.0.ARECD411]

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 unsd:m49Code [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 iso-3166:alpha-2CountryCode [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 unsd:m49Area [0.0.MAREA519]

n/a

ItemCodeFAO

Item code assigned by FAOSTAT to the value reported in the record.

String faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCPC

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

String unsd:cpcCode [0.0.CPCCD426]

n/a

Item

Name of the item assigned by FAOSTAT to the value reported in the record.

String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementCode [0.0.LMNTC418]

n/a

Element

Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementLabel [0.0.LMNTL419]

n/a

YearCode

Year code used by FAOSTAT to describe the period for which the value in the record is reported.

String faostat:yearCode [0.0.YERCD429]

n/a

Year

Period for which the value in the record is reported.

String faostat:yearDescription [0.0.RDSCR430]

n/a

Unit

Unit in which the value in the record is reported.

String faostat:Unit [0.0.UNITA94]

n/a

Value

Trade value reported for the item (beeswax) and the elements (import, export) between reporter and partner country, expressed in the unit 1000 USD, as specified in the record.

Integer number dwc:measurementValue [0.0.MSRMN621]

n/a

Flag

Flag assigned to the value reported in the record.

String faostat:flag [0.0.FLAGA421]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 24. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 3 - 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 BB n/a n/a n/a F299 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 184 ( 0.5% )
ReporterArea 4 - 52 n/a Peru n/a n/a n/a United Kingd… 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 3 - 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 AG n/a n/a n/a F299 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 207 ( 0.5% )
PartnerArea 4 - 52 n/a Cuba n/a n/a n/a United Kingd… 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,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 Import Value n/a n/a n/a Export Value 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 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% )

Quality measures

Table 25. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeFAO
100.00%
0.48%
79 12
ReporterAreaCodeM49
100.00%
0.48%
276 044
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%
5622 5922
Element
100.00%
0.01%
Import Value Export Value
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

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 dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTT207.BSTRD525.0
Name bees trade matrix value
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTT207.BSTRD525.0
Table Type File
Licence CC BY 4.0
Description

This table contains the trade matrix (value of import and export) for honey bees, expressed as 1000 USD, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

This table contains the trade matrix (value of import and export) for honey bees, expressed as 1000 USD, usually but not always per calendar year (see metadata document Trade - Crops and livestock products - Methodology for exceptions), in each country of the world from 1961 to 2022, reported by FAOSTAT.

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).
Column Name Column Description Datatype Descriptor Unit
ReporterAreaCodeFAO

FAO area code of the country or region which has reported the trade value in the record.

String faostat:areaCode [0.0.ARECD411]

n/a

ReporterAreaCodeM49

M49 area code of the country or region which has reported the trade value in the record.

String unsd:m49Code [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 iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

ReporterArea

Name of the area (country or region) which has reported the trade value in the record.

String unsd:m49Area [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:areaCode [0.0.ARECD411]

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 unsd:m49Code [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 iso-3166:alpha-2CountryCode [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 unsd:m49Area [0.0.MAREA519]

n/a

ItemCodeFAO

Item code assigned by FAOSTAT to the value reported in the record.

String faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCPC

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

String unsd:cpcCode [0.0.CPCCD426]

n/a

Item

Name of the item assigned by FAOSTAT to the value reported in the record.

String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementCode [0.0.LMNTC418]

n/a

Element

Name of the element assigned by FAOSTAT to the item for which the value in the record is reported.

String faostat:elementLabel [0.0.LMNTL419]

n/a

YearCode

Year code used by FAOSTAT to describe the period for which the value in the record is reported.

String faostat:yearCode [0.0.YERCD429]

n/a

Year

Period for which the value in the record is reported.

String faostat:yearDescription [0.0.RDSCR430]

n/a

Unit

Unit in which the value in the record is reported.

String faostat:Unit [0.0.UNITA94]

n/a

Value

Trade value reported for the item (bees) and the elements (import, export) between reporter and partner country, expressed in the unit 1000 USD, as specified in the record.

Decimal number dwc:measurementValue [0.0.MSRMN621]

n/a

Flag

Flag assigned to the value reported in the record.

String faostat:flag [0.0.FLAGA421]

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum 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 3 - 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 BE n/a n/a n/a F299 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 124 ( 2.2% )
ReporterArea 4 - 52 n/a Fiji n/a n/a n/a United Kingd… 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 3 - 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 AL n/a n/a n/a F248 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 160 ( 2.9% )
PartnerArea 4 - 52 n/a Iraq n/a n/a n/a United Kingd… 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 5 - 5 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,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% )
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 E 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.1% )

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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeFAO
100.00%
2.25%
150 12
ReporterAreaCodeM49
100.00%
2.25%
528 044
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 068
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%
02196 02196
Item
100.00%
0.02%
Bees Bees
ElementCode
100.00%
0.04%
5622 5922
Element
100.00%
0.04%
Import Value Export Value
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

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

References

  1. FAO 2023 FAOSTAT Detailed trade matrix. FAOSTAT. [2024-12-2] www.fao.org
  2. FAO 2023 Trade of agricultural commodities 2005–2022. FAOSTAT Analytical Briefs, No. 80. Rome.. doi: 10.4060/cc9206en

Annex 1: Table column reports

Table: bees trade matrix quantity

Column: ReporterAreaCodeFAO

Table 30. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 31. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ReporterAreaCodeM49

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

M49 area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 34. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeM49 3 - 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeM49
100.00%
2.25%
528 044

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.

Column: ReporterAreaCodeISO2

Table 36. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 37. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeISO2 2 - 4 n/a BE n/a n/a n/a F299 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).
Column 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.

Column: ReporterArea

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

Name of the area (country or region) which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 40. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterArea 4 - 52 n/a Fiji n/a n/a n/a United Kingd… 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).
Column 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.

Column: PartnerAreaCodeFAO

Table 42. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 43. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: PartnerAreaCodeM49

Table 45. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 46. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeM49 3 - 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeM49
100.00%
2.90%
528 068

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.

Column: PartnerAreaCodeISO2

Table 48. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 49. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeISO2 2 - 4 n/a AL n/a n/a n/a F248 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).
Column 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.

Column: PartnerArea

Table 51. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 52. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerArea 4 - 52 n/a Iraq n/a n/a n/a United Kingd… 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).
Column 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.

Column: ItemCodeFAO

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

Item code assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemCode [UID:0.0.ITMCD423]
Descriptor description

Code of the item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ITMCD423
Unit

n/a

Table 55. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ItemCodeCPC

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

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

Data type String
Descriptor unsd:cpcCode [UID:0.0.CPCCD426]
Descriptor description

Code of a product in the Central Product Classification (CPC)

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CPCCD426
Unit

n/a

Table 58. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCodeCPC 5 - 5 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeCPC
100.00%
0.02%
02196 02196

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.

Column: Item

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

Name of the item assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemLabel [UID:0.0.TMLBL425]
Descriptor description

Item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMLBL425
Unit

n/a

Table 61. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ElementCode

Table 63. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:elementCode [UID:0.0.LMNTC418]
Descriptor description

Code of the element for which FAOSTAT provides data, summarised in the "Element" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTC418
Unit

n/a

Table 64. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Element

Table 66. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:elementLabel [UID:0.0.LMNTL419]
Descriptor description

Element for which FAOSTAT provides data, summarised in the "Element", "Item" or "Item Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTL419
Unit

n/a

Table 67. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: YearCode

Table 69. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:yearCode [UID:0.0.YERCD429]
Descriptor description

Any period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.YERCD429
Unit

n/a

Table 70. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Year

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

Period for which the value in the record is reported.

Data type String
Descriptor faostat:yearDescription [UID:0.0.RDSCR430]
Descriptor description

Description of a period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RDSCR430
Unit

n/a

Table 73. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 2,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).
Column 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.

Column: Unit

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

Unit in which the value in the record is reported.

Data type String
Descriptor faostat:Unit [UID:0.0.UNITA94]
Descriptor description

Unit in which FAOSTAT provides data, summarised in the "Units" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.UNITA94
Unit

n/a

Table 76. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Unit 0 - 0 n/a n/a n/a n/a 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Unit
100.00%
0.02%
0 0

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.

Column: Value

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

Trade quantity reported for the item (bees) and the elements (import, export) between reporter and partner country, expressed in the unit number, as specified in the record.

Data type Integer number
Descriptor dwc:measurementValue [UID:0.0.MSRMN621]
Descriptor description

A measurement datum is an information content entity that is a recording of the output of a measurement such as produced by a device.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/measurementValue
Unit

n/a

Table 79. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 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).
Column 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.

Column: Flag

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

Flag assigned to the value reported in the record.

Data type String
Descriptor faostat:flag [UID:0.0.FLAGA421]
Descriptor description

Flag used to add standardised comments to data provided by FAOSTAT, summarised in the "Flags" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.FLAGA421
Unit

n/a

Table 82. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flag 1 - 1 n/a A n/a n/a n/a I 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).
Column 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.

Table: beeswax trade matrix quantity

Column: ReporterAreaCodeFAO

Table 84. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 85. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ReporterAreaCodeM49

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

M49 area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 88. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeM49 3 - 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeM49
100.00%
0.48%
276 044

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.

Column: ReporterAreaCodeISO2

Table 90. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 91. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeISO2 2 - 4 n/a BB n/a n/a n/a F299 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).
Column 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.

Column: ReporterArea

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

Name of the area (country or region) which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 94. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterArea 4 - 52 n/a Peru n/a n/a n/a United Kingd… 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).
Column 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.

Column: PartnerAreaCodeFAO

Table 96. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 97. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: PartnerAreaCodeM49

Table 99. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 100. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeM49 3 - 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).
Column 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.

Column: PartnerAreaCodeISO2

Table 102. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 103. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeISO2 2 - 4 n/a AG n/a n/a n/a F299 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).
Column 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.

Column: PartnerArea

Table 105. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 106. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerArea 4 - 52 n/a Cuba n/a n/a n/a United Kingd… 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).
Column 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.

Column: ItemCodeFAO

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

Item code assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemCode [UID:0.0.ITMCD423]
Descriptor description

Code of the item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ITMCD423
Unit

n/a

Table 109. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ItemCodeCPC

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

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

Data type String
Descriptor unsd:cpcCode [UID:0.0.CPCCD426]
Descriptor description

Code of a product in the Central Product Classification (CPC)

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CPCCD426
Unit

n/a

Table 112. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Item

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

Name of the item assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemLabel [UID:0.0.TMLBL425]
Descriptor description

Item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMLBL425
Unit

n/a

Table 115. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ElementCode

Table 117. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:elementCode [UID:0.0.LMNTC418]
Descriptor description

Code of the element for which FAOSTAT provides data, summarised in the "Element" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTC418
Unit

n/a

Table 118. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Element

Table 120. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:elementLabel [UID:0.0.LMNTL419]
Descriptor description

Element for which FAOSTAT provides data, summarised in the "Element", "Item" or "Item Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTL419
Unit

n/a

Table 121. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element 15 - 15 n/a Import Quant… n/a n/a n/a Export 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).
Column 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.

Column: YearCode

Table 123. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:yearCode [UID:0.0.YERCD429]
Descriptor description

Any period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.YERCD429
Unit

n/a

Table 124. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Year

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

Period for which the value in the record is reported.

Data type String
Descriptor faostat:yearDescription [UID:0.0.RDSCR430]
Descriptor description

Description of a period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RDSCR430
Unit

n/a

Table 127. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 2,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).
Column 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.

Column: Unit

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

Unit in which the value in the record is reported.

Data type String
Descriptor faostat:Unit [UID:0.0.UNITA94]
Descriptor description

Unit in which FAOSTAT provides data, summarised in the "Units" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.UNITA94
Unit

n/a

Table 130. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Value

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

Trade quantity reported for the item (beeswax) and the elements (import, export) between reporter and partner country, expressed in the unit tonnes, as specified in the record.

Data type Decimal number
Descriptor dwc:measurementValue [UID:0.0.MSRMN621]
Descriptor description

A measurement datum is an information content entity that is a recording of the output of a measurement such as produced by a device.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/measurementValue
Unit

n/a

Table 133. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 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).
Column 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.

Column: Flag

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

Flag assigned to the value reported in the record.

Data type String
Descriptor faostat:flag [UID:0.0.FLAGA421]
Descriptor description

Flag used to add standardised comments to data provided by FAOSTAT, summarised in the "Flags" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.FLAGA421
Unit

n/a

Table 136. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flag 1 - 1 n/a A n/a n/a n/a E 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).
Column 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.

Table: honey trade matrix quantity

Column: ReporterAreaCodeFAO

Table 138. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 139. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ReporterAreaCodeM49

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

M49 area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 142. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeM49 3 - 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).
Column 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.

Column: ReporterAreaCodeISO2

Table 144. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 145. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeISO2 2 - 4 n/a AG n/a n/a n/a F299 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).
Column 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.

Column: ReporterArea

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

Name of the area (country or region) which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 148. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterArea 4 - 52 n/a Oman n/a n/a n/a United Kingd… 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).
Column 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.

Column: PartnerAreaCodeFAO

Table 150. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 151. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: PartnerAreaCodeM49

Table 153. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 154. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeM49 3 - 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).
Column 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.

Column: PartnerAreaCodeISO2

Table 156. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 157. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeISO2 2 - 4 n/a AR n/a n/a n/a F228 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).
Column 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.

Column: PartnerArea

Table 159. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column 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 unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 160. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerArea 4 - 52 n/a Cuba n/a n/a n/a United Kingd… 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).
Column 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.

Column: ItemCodeFAO

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

Item code assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemCode [UID:0.0.ITMCD423]
Descriptor description

Code of the item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ITMCD423
Unit

n/a

Table 163. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ItemCodeCPC

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

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

Data type String
Descriptor unsd:cpcCode [UID:0.0.CPCCD426]
Descriptor description

Code of a product in the Central Product Classification (CPC)

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CPCCD426
Unit

n/a

Table 166. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCodeCPC 5 - 5 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeCPC
100.00%
0.00%
02910 02910

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.

Column: Item

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

Name of the item assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemLabel [UID:0.0.TMLBL425]
Descriptor description

Item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMLBL425
Unit

n/a

Table 169. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: ElementCode

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

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

Data type String
Descriptor faostat:elementCode [UID:0.0.LMNTC418]
Descriptor description

Code of the element for which FAOSTAT provides data, summarised in the "Element" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTC418
Unit

n/a

Table 172. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Element

Table 174. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:elementLabel [UID:0.0.LMNTL419]
Descriptor description

Element for which FAOSTAT provides data, summarised in the "Element", "Item" or "Item Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTL419
Unit

n/a

Table 175. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element 15 - 15 n/a Import Quant… n/a n/a n/a Export 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).
Column 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.

Column: YearCode

Table 177. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:yearCode [UID:0.0.YERCD429]
Descriptor description

Any period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.YERCD429
Unit

n/a

Table 178. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Year

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

Period for which the value in the record is reported.

Data type String
Descriptor faostat:yearDescription [UID:0.0.RDSCR430]
Descriptor description

Description of a period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RDSCR430
Unit

n/a

Table 181. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 2,009.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).
Column 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.

Column: Unit

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

Unit in which the value in the record is reported.

Data type String
Descriptor faostat:Unit [UID:0.0.UNITA94]
Descriptor description

Unit in which FAOSTAT provides data, summarised in the "Units" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.UNITA94
Unit

n/a

Table 184. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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).
Column 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.

Column: Value

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

Trade quantity reported for the item (honey) and the elements (import, export), expressed in the unit tonnes between reporter and partner country, as specified in the record.

Data type Decimal number
Descriptor dwc:measurementValue [UID:0.0.MSRMN621]
Descriptor description

A measurement datum is an information content entity that is a recording of the output of a measurement such as produced by a device.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/measurementValue
Unit

n/a

Table 187. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 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).
Column 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.

Column: Flag

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

Flag assigned to the value reported in the record.

Data type String
Descriptor faostat:flag [UID:0.0.FLAGA421]
Descriptor description

Flag used to add standardised comments to data provided by FAOSTAT, summarised in the "Flags" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.FLAGA421
Unit

n/a

Table 190. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flag 1 - 1 n/a A n/a n/a n/a E 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).
Column 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.

Table: honey trade matrix value

Column: ReporterAreaCodeFAO

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

FAO area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor faostat:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 193. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeFAO
100.00%
0.17%
79 244

Data Distribution Top 20

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

Data Distribution Bottom 20

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

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.

Column: ReporterAreaCodeM49

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

M49 area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 196. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeM49 3 - 3 437.9 4 231 410 702 894 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 189 ( 0.2% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeM49
100.00%
0.17%
276 882

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: ReporterAreaCodeISO2

Table 198. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 199. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeISO2 2 - 4 n/a AG n/a n/a n/a F299 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 189 ( 0.2% )
Table 200. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeISO2
100.00%
0.17%
DE WS

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: ReporterArea

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

Name of the area (country or region) which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 202. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterArea 4 - 52 n/a Oman n/a n/a n/a United Kingd… 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 189 ( 0.2% )
Table 203. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterArea
100.00%
0.17%
Germany Samoa

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: PartnerAreaCodeFAO

Table 204. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 205. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeFAO
100.00%
0.19%
231 218

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: PartnerAreaCodeM49

Table 207. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 208. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeM49 3 - 3 446.4 4 233 414 702 894 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 210 ( 0.2% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeM49
100.00%
0.19%
840 772

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: PartnerAreaCodeISO2

Table 210. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 211. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeISO2 2 - 4 n/a AR n/a n/a n/a F228 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 210 ( 0.2% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeISO2
100.00%
0.19%
US TK

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: PartnerArea

Table 213. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 214. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerArea 4 - 52 n/a Cuba n/a n/a n/a United Kingd… 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 210 ( 0.2% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerArea
100.00%
0.19%
United States of America Tokelau

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: ItemCodeFAO

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

Item code assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemCode [UID:0.0.ITMCD423]
Descriptor description

Code of the item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ITMCD423
Unit

n/a

Table 217. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeFAO
100.00%
0.00%
1182 1182

Data Distribution Top 20

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

Continuous Data Distribution

Figure 250. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: ItemCodeCPC

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

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

Data type String
Descriptor unsd:cpcCode [UID:0.0.CPCCD426]
Descriptor description

Code of a product in the Central Product Classification (CPC)

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CPCCD426
Unit

n/a

Table 220. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCodeCPC 5 - 5 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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeCPC
100.00%
0.00%
02910 02910

Data Distribution Top 20

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

Continuous Data Distribution

Figure 255. Distribution of values in the column.

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.

Column: Item

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

Name of the item assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemLabel [UID:0.0.TMLBL425]
Descriptor description

Item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMLBL425
Unit

n/a

Table 223. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Item
100.00%
0.00%
Natural honey Natural honey

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: ElementCode

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

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

Data type String
Descriptor faostat:elementCode [UID:0.0.LMNTC418]
Descriptor description

Code of the element for which FAOSTAT provides data, summarised in the "Element" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTC418
Unit

n/a

Table 226. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ElementCode
100.00%
0.00%
5622 5922

Data Distribution Top 20

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

Continuous Data Distribution

Figure 263. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Element

Table 228. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:elementLabel [UID:0.0.LMNTL419]
Descriptor description

Element for which FAOSTAT provides data, summarised in the "Element", "Item" or "Item Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTL419
Unit

n/a

Table 229. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element 12 - 12 n/a Import Value n/a n/a n/a Export Value 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Element
100.00%
0.00%
Import Value Export Value

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: YearCode

Table 231. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:yearCode [UID:0.0.YERCD429]
Descriptor description

Any period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.YERCD429
Unit

n/a

Table 232. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
YearCode
100.00%
0.03%
2021 1987

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Year

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

Period for which the value in the record is reported.

Data type String
Descriptor faostat:yearDescription [UID:0.0.RDSCR430]
Descriptor description

Description of a period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RDSCR430
Unit

n/a

Table 235. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 2,009.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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Year
100.00%
0.03%
2021 1987

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Unit

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

Unit in which the value in the record is reported.

Data type String
Descriptor faostat:Unit [UID:0.0.UNITA94]
Descriptor description

Unit in which FAOSTAT provides data, summarised in the "Units" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.UNITA94
Unit

n/a

Table 238. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Unit
100.00%
0.00%
1000 USD 1000 USD

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Value

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

Trade value reported for the item (honey) and the elements (import, export), expressed in the unit 1000 USD between reporter and partner country, as specified in the record.

Data type String
Descriptor dwc:measurementValue [UID:0.0.MSRMN621]
Descriptor description

A measurement datum is an information content entity that is a recording of the output of a measurement such as produced by a device.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/measurementValue
Unit

n/a

Table 241. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Value
100.00%
6.22%
0 4051

Continuous Data Distribution

Figure 283. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Flag

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

Flag assigned to the value reported in the record.

Data type String
Descriptor faostat:flag [UID:0.0.FLAGA421]
Descriptor description

Flag used to add standardised comments to data provided by FAOSTAT, summarised in the "Flags" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.FLAGA421
Unit

n/a

Table 244. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flag 1 - 1 n/a A n/a n/a n/a E 109,889 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.0% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Flag
100.00%
0.00%
A E

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: beeswax trade matrix value

Column: ReporterAreaCodeFAO

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

FAO area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor faostat:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 247. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeFAO
100.00%
0.48%
79 12

Data Distribution Top 20

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

Data Distribution Bottom 20

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

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.

Column: ReporterAreaCodeM49

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

M49 area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 250. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeM49 3 - 3 437.2 4 246 380 705 894 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 184 ( 0.5% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeM49
100.00%
0.48%
276 044

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: ReporterAreaCodeISO2

Table 252. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 253. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeISO2 2 - 4 n/a BB n/a n/a n/a F299 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 184 ( 0.5% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeISO2
100.00%
0.48%
DE BS

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: ReporterArea

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

Name of the area (country or region) which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 256. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterArea 4 - 52 n/a Peru n/a n/a n/a United Kingd… 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 184 ( 0.5% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterArea
100.00%
0.48%
Germany Bahamas

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: PartnerAreaCodeFAO

Table 258. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 259. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeFAO
100.00%
0.53%
79 140

Continuous Data Distribution

Figure 308. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: PartnerAreaCodeM49

Table 261. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 262. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeM49 3 - 3 438.9 4 233 384 703 894 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 207 ( 0.5% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeM49
100.00%
0.53%
276 492

Continuous Data Distribution

Figure 312. Distribution of values in the column.

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.

Column: PartnerAreaCodeISO2

Table 264. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 265. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeISO2 2 - 4 n/a AG n/a n/a n/a F299 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 207 ( 0.5% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeISO2
100.00%
0.53%
DE MC

Completeness

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

Uniqueness

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

Column: PartnerArea

Table 267. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 268. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerArea 4 - 52 n/a Cuba n/a n/a n/a United Kingd… 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 207 ( 0.5% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerArea
100.00%
0.53%
Germany Monaco

Completeness

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

Uniqueness

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

Column: ItemCodeFAO

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

Item code assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemCode [UID:0.0.ITMCD423]
Descriptor description

Code of the item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ITMCD423
Unit

n/a

Table 271. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeFAO
100.00%
0.00%
1183 1183

Data Distribution Top 20

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

Continuous Data Distribution

Figure 321. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: ItemCodeCPC

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

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

Data type String
Descriptor unsd:cpcCode [UID:0.0.CPCCD426]
Descriptor description

Code of a product in the Central Product Classification (CPC)

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CPCCD426
Unit

n/a

Table 274. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeCPC
100.00%
0.00%
02960.01 02960.01

Data Distribution Top 20

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

Continuous Data Distribution

Figure 326. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Item

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

Name of the item assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemLabel [UID:0.0.TMLBL425]
Descriptor description

Item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMLBL425
Unit

n/a

Table 277. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Item
100.00%
0.00%
Beeswax Beeswax

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: ElementCode

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

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

Data type String
Descriptor faostat:elementCode [UID:0.0.LMNTC418]
Descriptor description

Code of the element for which FAOSTAT provides data, summarised in the "Element" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTC418
Unit

n/a

Table 280. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ElementCode
100.00%
0.01%
5622 5922

Data Distribution Top 20

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

Continuous Data Distribution

Figure 334. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Element

Table 282. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:elementLabel [UID:0.0.LMNTL419]
Descriptor description

Element for which FAOSTAT provides data, summarised in the "Element", "Item" or "Item Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTL419
Unit

n/a

Table 283. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element 12 - 12 n/a Import Value n/a n/a n/a Export Value 38,706 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Element
100.00%
0.01%
Import Value Export Value

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: YearCode

Table 285. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:yearCode [UID:0.0.YERCD429]
Descriptor description

Any period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.YERCD429
Unit

n/a

Table 286. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
YearCode
100.00%
0.10%
2021 1988

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.

Outliers

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

Completeness

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

Uniqueness

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

Column: Year

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

Period for which the value in the record is reported.

Data type String
Descriptor faostat:yearDescription [UID:0.0.RDSCR430]
Descriptor description

Description of a period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RDSCR430
Unit

n/a

Table 289. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 2,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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Year
100.00%
0.10%
2021 1988

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Unit

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

Unit in which the value in the record is reported.

Data type String
Descriptor faostat:Unit [UID:0.0.UNITA94]
Descriptor description

Unit in which FAOSTAT provides data, summarised in the "Units" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.UNITA94
Unit

n/a

Table 292. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Unit
100.00%
0.00%
1000 USD 1000 USD

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Value

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

Trade value reported for the item (beeswax) and the elements (import, export) between reporter and partner country, expressed in the unit 1000 USD, as specified in the record.

Data type Integer number
Descriptor dwc:measurementValue [UID:0.0.MSRMN621]
Descriptor description

A measurement datum is an information content entity that is a recording of the output of a measurement such as produced by a device.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/measurementValue
Unit

n/a

Table 295. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Value
100.00%
4.32%
0 1768

Continuous Data Distribution

Figure 354. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Flag

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

Flag assigned to the value reported in the record.

Data type String
Descriptor faostat:flag [UID:0.0.FLAGA421]
Descriptor description

Flag used to add standardised comments to data provided by FAOSTAT, summarised in the "Flags" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.FLAGA421
Unit

n/a

Table 298. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Flag
100.00%
0.01%
A X

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: bees trade matrix value

Column: ReporterAreaCodeFAO

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

FAO area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor faostat:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 301. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeFAO
100.00%
2.25%
150 12

Continuous Data Distribution

Figure 361. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: ReporterAreaCodeM49

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

M49 area code of the country or region which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 304. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeM49 3 - 3 435.8 4 208 440 643 862 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 124 ( 2.2% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeM49
100.00%
2.25%
528 044

Continuous Data Distribution

Figure 365. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: ReporterAreaCodeISO2

Table 306. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 307. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterAreaCodeISO2 2 - 4 n/a BE n/a n/a n/a F299 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 124 ( 2.2% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterAreaCodeISO2
100.00%
2.25%
NL BS

Completeness

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

Uniqueness

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

Column: ReporterArea

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

Name of the area (country or region) which has reported the trade value in the record.

Data type String
Descriptor unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 310. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ReporterArea 4 - 52 n/a Fiji n/a n/a n/a United Kingd… 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 124 ( 2.2% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ReporterArea
100.00%
2.25%
Netherlands (Kingdom of the) Bahamas

Completeness

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

Uniqueness

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

Column: PartnerAreaCodeFAO

Table 312. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:areaCode [UID:0.0.ARECD411]
Descriptor description

Identifier code of a country or a goup of countries for which FAOSTAT aggregates data, summarised in the "Country Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ARECD411
Unit

n/a

Table 313. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeFAO
100.00%
2.90%
150 19

Continuous Data Distribution

Figure 373. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: PartnerAreaCodeM49

Table 315. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 unsd:m49Code [UID:0.0.MCODE356]
Descriptor description

Three-digit numerical code of of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MCODE356
Unit

n/a

Table 316. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeM49 3 - 3 443.5 4 218 422 703 894 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 160 ( 2.9% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeM49
100.00%
2.90%
528 068

Continuous Data Distribution

Figure 377. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: PartnerAreaCodeISO2

Table 318. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN4
Unit

n/a

Table 319. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerAreaCodeISO2 2 - 4 n/a AL n/a n/a n/a F248 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 160 ( 2.9% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerAreaCodeISO2
100.00%
2.90%
NL BO

Completeness

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

Uniqueness

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

Column: PartnerArea

Table 321. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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 unsd:m49Area [UID:0.0.MAREA519]
Descriptor description

Name of the countries or areas or geographic regions in the M49 standard used for statistical processing purposes by the Statistics Division of the United Nations Secretariat.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MAREA519
Unit

n/a

Table 322. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PartnerArea 4 - 52 n/a Iraq n/a n/a n/a United Kingd… 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 160 ( 2.9% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PartnerArea
100.00%
2.90%
Netherlands (Kingdom of the) Bolivia (Plurinational State of)

Completeness

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

Uniqueness

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

Column: ItemCodeFAO

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

Item code assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemCode [UID:0.0.ITMCD423]
Descriptor description

Code of the item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ITMCD423
Unit

n/a

Table 325. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeFAO
100.00%
0.02%
1181 1181

Data Distribution Top 20

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

Continuous Data Distribution

Figure 386. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: ItemCodeCPC

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

Central Product Classification (CPC) Code of the item for which the value in the record is reported.

Data type String
Descriptor unsd:cpcCode [UID:0.0.CPCCD426]
Descriptor description

Code of a product in the Central Product Classification (CPC)

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CPCCD426
Unit

n/a

Table 328. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCodeCPC 5 - 5 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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeCPC
100.00%
0.02%
02196 02196

Data Distribution Top 20

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

Continuous Data Distribution

Figure 391. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Item

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

Name of the item assigned by FAOSTAT to the value reported in the record.

Data type String
Descriptor faostat:ItemLabel [UID:0.0.TMLBL425]
Descriptor description

Item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMLBL425
Unit

n/a

Table 331. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Item
100.00%
0.02%
Bees Bees

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: ElementCode

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

Element code assigned by FAOSTAT to the item for which the value in the record is reported.

Data type String
Descriptor faostat:elementCode [UID:0.0.LMNTC418]
Descriptor description

Code of the element for which FAOSTAT provides data, summarised in the "Element" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTC418
Unit

n/a

Table 334. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ElementCode
100.00%
0.04%
5622 5922

Data Distribution Top 20

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

Continuous Data Distribution

Figure 399. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Element

Table 336. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:elementLabel [UID:0.0.LMNTL419]
Descriptor description

Element for which FAOSTAT provides data, summarised in the "Element", "Item" or "Item Group" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LMNTL419
Unit

n/a

Table 337. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Element
100.00%
0.04%
Import Value Export Value

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: YearCode

Table 339. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name 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:yearCode [UID:0.0.YERCD429]
Descriptor description

Any period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.YERCD429
Unit

n/a

Table 340. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
YearCode
100.00%
0.67%
2022 1996

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Year

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

Period for which the value in the record is reported.

Data type String
Descriptor faostat:yearDescription [UID:0.0.RDSCR430]
Descriptor description

Description of a period lasting one year for which FAOSTAT provides data, summarised in the "Definitions and standards - Crops and livestock products" list on the web page "Crops and livestock products" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RDSCR430
Unit

n/a

Table 343. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 2,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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Year
100.00%
0.67%
2022 1996

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Unit

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

Unit in which the value in the record is reported.

Data type String
Descriptor faostat:Unit [UID:0.0.UNITA94]
Descriptor description

Unit in which FAOSTAT provides data, summarised in the "Units" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.UNITA94
Unit

n/a

Table 346. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Unit
100.00%
0.02%
1000 USD 1000 USD

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Value

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

Trade value reported for the item (bees) and the elements (import, export) between reporter and partner country, expressed in the unit 1000 USD, as specified in the record.

Data type Decimal number
Descriptor dwc:measurementValue [UID:0.0.MSRMN621]
Descriptor description

A measurement datum is an information content entity that is a recording of the output of a measurement such as produced by a device.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/measurementValue
Unit

n/a

Table 349. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 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 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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Value
100.00%
15.13%
0 259

Continuous Data Distribution

Figure 419. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Flag

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

Flag assigned to the value reported in the record.

Data type String
Descriptor faostat:flag [UID:0.0.FLAGA421]
Descriptor description

Flag used to add standardised comments to data provided by FAOSTAT, summarised in the "Flags" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.FLAGA421
Unit

n/a

Table 352. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flag 1 - 1 n/a A n/a n/a n/a E 5,520 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.1% )
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).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Flag
100.00%
0.05%
A E

Data Distribution Top 20

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

Completeness

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

Uniqueness

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