EU Pollinator Hub

, ,

Dataset Report
Unique identifier: FSTTM9.0.0
Title: FAOSTAT Metadata
Long title: Definitions and standards used in FAOSTAT
Status: Quality Validated
Current Version: v. 1.0
Published: 2023-06-14
Reviewed by: Rubinigg Michael as Data scientist
Citation proposal:
Food and Agriculture Organization of the United Nations 2023 Report of dataset FAOSTAT Metadata, v. 1.0 [FSTTM9.0.0]. EU Pollinator Hub. [2026-02-24] app.pollinatorhub.eu
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
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 2023-06-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 2023-06-14 00:06:00 Initial release. n/a

Abbreviations

FAO
Food and Agriculture Organization of the United Nations
FAOSTAT
Statistical division of the Food and Agriculture Organization of the United Nations
n.a.
not available

Executive summary

Data overview:

The dataset contains a selection of tables on worldwide crop and livestock production as well as macroeconomic and environmental indicators related to agriculture and forestry obtained from the statistical division of the Food and Agriculture Organization of the United Nations (FAOSTAT) [1].

Data value:

The dataset contains social, environmental, and economic data and indicators of the whole world, directly or indirectly related to bees. Datasets are produced and maintained by the statistical division of an international organisation (FAO) and therefore allow comparison between countries.

Data description:

The dataset contains 15 out of a total of 67 data tables contained in the bulk download provided by FAOSTAT which are considered to be relevant for bees (production of crops and livestock, value of production, prices, trade with crops and livestock, detailed trade matrices for each country and country groups/regions, consumer price indices, exchange rates, macroeconomic key indicators, pesticide inputs, pesticide indicators, population, land use, land use percentage shares, land cover and average temperature change). In addition, 7 tables containing definitions and standards provided by FAOSTAT have been included in the dataset (abbreviations, list of countries and country groups/regions, elements, items, flags and units used in the data tables).

Data application:

This data is suited to produce concise tabular and graphical overviews and summaries on a range of social, economic, and ecologic parameters for stakeholders in beekeeping industry (e.g. organisations relying on monitoring of the market). Possible research questions include the following:

Unresolved issues:

n/a

Introduction

Monitoring the development of the European beekeeping industry and predicting future developments is an important prerequisite for individuals and organisations involved in the policy making process related to beekeeping and other agricultural activities. On a macroeconomic scale, data from international organisation such as statistical division of FAO (FAOSTAT) – despite shortcomings due to difficulties in standardisation, data quality and availability – ensure the best possible and freely available quality of information to compare countries and country groups. At lower levels (member states, regions), data from national statistical agencies should be used.

Material and methods

Data acquisition

Data and metadata was obtained from the Food and Agriculture Organization Corporate Statistical Database (FAOSTAT) [1], the statistical data website of the Food and Agriculture Organization of the United Nations (FAO) on 2022-03-29. Later versions of the database are therefore not considered. The entire normalized dataset was downloaded in bulk. Data is made available under the Creative Commons Attribution-NonCommercial-ShareAlike 3.0 IGO license (CC BY-NC-SA 3.0 IGO; https://creativecommons.org/licenses/by-nc-sa/3.0/igo). In addition to this license, some database specific terms of use are listed: https://www.fao.org/contact-us/terms/db-terms-of-use/en/.

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_metadata_abbreviations_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:50 200 5.03 KiB
2 FAOSTAT_metadata_countrygroup_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:15 21,264 199.06 KiB
3 FAOSTAT_metadata_countryregion_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:58 2,415 18.24 KiB
4 FAOSTAT_metadata_element_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:18 2,710 55.40 KiB
5 FAOSTAT_metadata_flags_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:36 22 339.00 B
6 FAOSTAT_metadata_item_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:52 40,005 1.21 MiB
7 FAOSTAT_metadata_itemgroup_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:08 123,255 1.49 MiB
8 FAOSTAT_metadata_units_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:28 130 2.25 KiB
9 FAOSTAT_metadata_year_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:05 128 978.00 B
10 FAOSTAT_metadata_month_PREP_MR_250127.csv CSV - Comma seperated values Yes No 2025-01-27 11:01:47 34 367.00 B

Data preparation

Data from imported for profiling into a SQL database (MariaDB foundation, Server-Version 10.4.24) running in a XAMPP environment (BitRock, version 3.3.0). Data was exported from the MySQL database to CSV format using utf-8 coding. Data profiling was performed according to SOP-005 Data profiling using phpMyAdmin (version 5.2.0).

Data validation

None

Data analysis

None

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 Abbreviations Abbreviations published in the section "Definitions and standards used in FAOSTAT"
2 Country Group Country Groups published in the section "Definitions and standards used in FAOSTAT"
3 Country-Region Country-Regions published in the section "Definitions and standards used in FAOSTAT"
4 Element Elements published in the section "Definitions and standards used in FAOSTAT"
5 Flags Flags published in the section "Definitions and standards used in FAOSTAT"
6 Item Items published in the section "Definitions and standards used in FAOSTAT"
7 Item Group Item Groups published in the section "Definitions and standards used in FAOSTAT"
8 Units Units published in the section "Definitions and standards used in FAOSTAT"
9 Year Years published in the section "Definitions and standards" of individual datasets
10 Month Various subdivisions of a year and periods deviating from the standard definition of a year used by FAOSTAT in various…
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid FSTTM9.0.0
Title FAOSTAT Metadata
Long title Definitions and standards used in FAOSTAT
Target IRI https://app.pollinatorhub.eu/dataset-discovery/FSTTM9.0.0
interactions.single.section-details.licence CC BY-NC-SA 3.0 IGO
DOI n/a
Created 2022-12-19
Published 2023-06-14
Contact n/a
Keywords n/a
Data collection years n/a
Regions, the data was collected in n/a
Abstract

Definitions and standards used in FAOSTAT

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

Abbreviations

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.BBRVT209.0
Name Abbreviations
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.BBRVT209.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Abbreviations published in the section "Definitions and standards used in FAOSTAT"

Abbreviations published in the section "Definitions and standards used in 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
Definition

Abbreviations used by FAOSTAT, summarised in the "Abbreviations" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

String faostat:abbreviation [0.0.BBRVT409]

n/a

"Abbreviation"

Definition of the abbreviations used by FAOSTAT, summarised in the "Abbreviations" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

String faostat:abbreviationDescription [0.0.BBRVT410]

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
Definition 6 - 356 n/a Arab Authori… n/a n/a n/a World Trade… 100 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 100 ( 100.0% )
"Abbreviation" 1 - 9 n/a AAAID n/a n/a n/a WTO 100 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 100 ( 100.0% )

Quality measures

Table 9. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Definition
100.00%
100.00%
Arab Authority for Agricultural Investment and Development Arab Authority for Agricultural Investment and Development
"Abbreviation"
100.00%
100.00%
AAAID AAAID

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Country Group

Table 10. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.CNTRY210.0
Name Country Group
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.CNTRY210.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Country Groups published in the section "Definitions and standards used in FAOSTAT"

Country Groups published in the section "Definitions and standards used in 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
Country Group

Name of a group 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.

String faostat:areaLabel [0.0.ARLBL412]

n/a

Group M49 Code

Standard code (M49) for a group of countries used by the Statistics Division of the United Nations Secretariat, 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.

String unsd:m49Code [0.0.MCODE356]

n/a

Country Code

Code of a country or region for which FAOSTAT reports data, summarised in the "Country/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

String faostat:areaCode [0.0.ARECD411]

n/a

Country

Name of a country or region for which FAOSTAT reports data, summarised in the "Country/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

String faostat:areaLabel [0.0.ARLBL412]

n/a

M49 Code

Standard code (M49) for a country or region used by the Statistics Division of the United Nations Secretariat, for which FAOSTAT reports data, summarised in the "Contry/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

String unsd:m49Code [0.0.MCODE356]

n/a

ISO2 Code

A two-letter code that represents a country name, recommended as the general purpose code in ISO 3166-1 (Codes for the representation of names of countries and their subdivisions Part 1: Country code) and ISO 3166-3 (Codes for the representation of names of countries and their subdivisions Part 3: Code for formerly used names of countries).

String iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

ISO3 Code

A three-letter code that represents a country name, which is usually more closely related to the country name, in ISO 3166-1 (Codes for the representation of names of countries and their subdivisions Part 1: Country code) and ISO 3166-3 (Codes for the representation of names of countries and their subdivisions Part 3: Code for formerly used names of countries).

String iso-3166:alpha-3CountryCode [0.0.LPHCN5]

n/a

Country Group Code

Code of a group 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.

Integer number faostat:areaCode [0.0.ARECD411]

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
Country Group 4 - 92 n/a Africa n/a n/a n/a World 2,658 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 61 ( 2.3% )
Group M49 Code 1 - 3 375.8 1 19 202 738 912 2,658 529 ( 19.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 57 ( 2.1% )
Country Code 1 - 4 241.7 1 81 155.5 230 1,202 2,658 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 423 ( 15.9% )
Country 4 - 64 n/a Adaptation F… n/a n/a n/a Åland Island… 2,658 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 423 ( 15.9% )
M49 Code 3 - 6 491.028 4 231 466 703.75 1,642 2,658 98 ( 3.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 375 ( 14.1% )
ISO2 Code 0 - 5 n/a AD n/a n/a n/a ZW 2,658 90 ( 3.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 379 ( 14.3% )
ISO3 Code 0 - 5 n/a 76 n/a n/a n/a ZWE 2,658 90 ( 3.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 379 ( 14.3% )
"Country Group Code" 3 - 4 4,757.0 336 5,000 5,400 5,826 5,901 2,658 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 61 ( 2.3% )

Quality measures

Table 13. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Country Group
100.00%
2.29%
World Antarctic Region
Group M49 Code
80.10%
2.14%
1 912
Country Code
100.00%
15.91%
122 252
Country
100.00%
15.91%
Lesotho Unspecified Area
M49 Code
96.31%
14.11%
n/a 896
ISO2 Code
96.61%
14.26%
n/a F252
ISO3 Code
96.61%
14.26%
n/a F252
"Country Group Code"
100.00%
2.29%
5000 5600

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Country-Region

Table 14. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.CNTRY211.0
Name Country-Region
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.CNTRY211.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Country-Regions published in the section "Definitions and standards used in FAOSTAT"

Country-Regions published in the section "Definitions and standards used in 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
Country

Name of a country or region for which FAOSTAT reports data, summarised in the "Country/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

String faostat:areaLabel [0.0.ARLBL412]

n/a

M49 Code

Standard code (M49) for a country or region used by the Statistics Division of the United Nations Secretariat, for which FAOSTAT reports data, summarised in the "Contry/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

String unsd:m49Code [0.0.MCODE356]

n/a

ISO2 Code

A two-letter code that represents a country name, recommended as the general purpose code in ISO 3166-1 (Codes for the representation of names of countries and their subdivisions Part 1: Country code) and ISO 3166-3 (Codes for the representation of names of countries and their subdivisions Part 3: Code for formerly used names of countries).

String iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

ISO3 Code

A three-letter code that represents a country name, which is usually more closely related to the country name, in ISO 3166-1 (Codes for the representation of names of countries and their subdivisions Part 1: Country code) and ISO 3166-3 (Codes for the representation of names of countries and their subdivisions Part 3: Code for formerly used names of countries).

String iso-3166:alpha-3CountryCode [0.0.LPHCN5]

n/a

Start Year

Calendar year in which the validity of a country code starts (i.e. in which a country starts to exist).

Integer number pms:startYear [0.0.CLNDR414]

n/a

End Year

Calendar year in which the validity of a country code ends (i.e. in which a country ceases to exist).

Integer number pms:endYear [0.0.CLNDR415]

n/a

"Country Code"

Code of a country or region for which FAOSTAT reports data, summarised in the "Country/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Integer number faostat:areaCode [0.0.ARECD411]

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
Country 4 - 67 n/a Afghanistan n/a n/a n/a Åland Island… 345 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 345 ( 100.0% )
M49 Code 1 - 5 4,713.7 1 182 440 704.5 99,032 345 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 343 ( 99.4% )
ISO2 Code 0 - 6 n/a AD n/a n/a n/a ZW 345 1 ( 0.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 343 ( 99.4% )
ISO3 Code 0 - 6 n/a ABW n/a n/a n/a ZWE 345 1 ( 0.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 343 ( 99.4% )
Start Year 4 - 4 1,996.6 1,991 1,992 1,992 2,000 2,012 345 306 ( 88.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 2.3% )
End Year 4 - 4 1,997.9 1,990 1,991 1,992 2,007.5 2,011 345 336 ( 97.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 2.3% )
"Country Code" 1 - 5 5,346.0 1 88.5 176 277.5 99,032 345 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 343 ( 99.4% )

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
Country
100.00%
100.00%
Afghanistan Afghanistan
M49 Code
100.00%
99.42%
654 4
ISO2 Code
99.71%
99.42%
SH AF
ISO3 Code
99.71%
99.42%
SHN AFG
Start Year
11.30%
2.32%
1992 2000
End Year
2.61%
2.32%
1992 1999
"Country Code"
100.00%
99.42%
187 2

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Element

Table 18. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.LMENT212.0
Name Element
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.LMENT212.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Elements published in the section "Definitions and standards used in FAOSTAT"

Elements published in the section "Definitions and standards used in 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
Domain

Description of the domain 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.

String faostat:domainLabel [0.0.DMNLB417]

n/a

Element Code

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

String faostat:elementCode [0.0.LMNTC418]

n/a

Element

Description 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.

String faostat:elementLabel [0.0.LMNTL419]

n/a

Unit

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.

String faostat:Unit [0.0.UNITA94]

n/a

"Domain Code"

Code of the domain 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.

String faostat:domainCode [0.0.DMNCD416]

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
Domain 17 - 103 n/a Climate Chan… n/a n/a n/a World Census… 542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 66 ( 12.2% )
Element Code 2 - 6 n/a 55 n/a n/a n/a SLC 542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 371 ( 68.5% )
Element 4 - 80 n/a Agricultural… n/a n/a n/a Zinc content… 542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 278 ( 51.3% )
Unit 0 - 29 n/a % n/a n/a n/a μg/cap/d 542 28 ( 5.2% ) 0 ( 0.0% ) 0 ( 0.0% ) 66 ( 12.2% )
"Domain Code" 2 - 4 n/a AE n/a n/a n/a WCAD 542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 66 ( 12.2% )

Quality measures

Table 21. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Domain
100.00%
12.18%
Trade: Crops and livestock products Discontinued archives and data series: Food Aid Shipments (WFP)
Element Code
100.00%
68.45%
5910 72257
Element
100.00%
51.29%
Value Burning crop residues (Emissions CH4)
Unit
94.83%
12.18%
t t/cap
"Domain Code"
100.00%
12.18%
TCL FA

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Flags

Table 22. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.FLAGS213.0
Name Flags
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.FLAGS213.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Flags published in the section "Definitions and standards used in FAOSTAT"

Flags published in the section "Definitions and standards used in 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
Flags

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

String faostat:flagDescription [0.0.FLGDS422]

n/a

"Flag"

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

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
Flags 13 - 49 n/a Estimated va… n/a n/a n/a Time series… 11 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 11 ( 100.0% )
"Flag" 1 - 1 n/a A n/a n/a n/a X 11 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 11 ( 100.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
Flags
100.00%
100.00%
Official figure Official figure
"Flag"
100.00%
100.00%
A A

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Item

Table 26. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.ITEMA214.0
Name Item
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.ITEMA214.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Items published in the section "Definitions and standards used in FAOSTAT"

Items published in the section "Definitions and standards used in 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
Domain

Description of the domain 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.

String faostat:domainLabel [0.0.DMNLB417]

n/a

Item Code

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

String faostat:ItemCode [0.0.ITMCD423]

n/a

Item

Name 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.

String faostat:ItemLabel [0.0.TMLBL425]

n/a

Description

Description 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.

String faostat:ItemDescription [0.0.TMDSC424]

n/a

CPC Code

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

String unsd:cpcCode [0.0.CPCCD426]

n/a

HS Code
String Text [0.0.TEXTA315]

n/a

HS07 Code

The 2007 edition of the WCO Harmonized Commodity Description and Coding System entered into force on 1 January 2007

String faostat:hsCode07 [0.0.HSCDE427]

n/a

HS12 Code

The 2007 edition of the WCO Harmonized Commodity Description and Coding System entered into force on 1 January 2012

String faostat:hsCode12 [0.0.HSCDE428]

n/a

"Domain Code"

Code of the domain 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.

String faostat:domainCode [0.0.DMNCD416]

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
Domain 17 - 95 n/a Climate Chan… n/a n/a n/a World Census… 4,445 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 57 ( 1.3% )
Item Code 1 - 15 n/a 1 n/a n/a n/a 2700305 4,445 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,813 ( 40.8% )
Item 3 - 220 n/a 12.3.1a Food… n/a n/a n/a hydrogenated… 4,445 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,772 ( 39.9% )
Description 0 - 4,871 n/a (NH4)2SO4, i… n/a n/a n/a v (Unofficia… 4,445 865 ( 19.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 994 ( 22.4% )
CPC Code 0 - 29 n/a 0111 n/a n/a n/a T0010 4,445 1,185 ( 26.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 814 ( 18.3% )
HS Code 6 - 6 848,195.1 843,210 843,240 843,352 843,420 870,130 4,445 4,434 ( 99.8% ) 0 ( 0.0% ) 0 ( 0.0% ) 12 ( 0.3% )
HS07 Code 0 - 366 n/a 010110, 0101… n/a n/a n/a 530500 4,445 1,540 ( 34.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 406 ( 9.1% )
HS12 Code 0 - 374 n/a 010121, 0101… n/a n/a n/a 530500 4,445 1,540 ( 34.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 443 ( 10.0% )
"Domain Code" 2 - 4 n/a AE n/a n/a n/a WCAD 4,445 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 57 ( 1.3% )

Quality measures

Table 29. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Domain
100.00%
1.28%
Trade: Crops and livestock products Discontinued archives and data series: ASTI-Expenditures
Item Code
100.00%
40.79%
44 1712
Item
100.00%
39.87%
Oats All Crops
Description
80.54%
22.36%
n/a A lowland, tropical or subtropical vegetation formation, characterized by a continuous grassland cover occasionally interrupted by trees and shrubs.
CPC Code
73.34%
18.31%
n/a F1712
HS Code
0.25%
0.27%
843340 843340
HS07 Code
65.35%
9.13%
n/a 170112
HS12 Code
65.35%
9.97%
n/a 170112
"Domain Code"
100.00%
1.28%
TCL AE

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Item Group

Table 30. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.TMGRP215.0
Name Item Group
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.TMGRP215.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Item Groups published in the section "Definitions and standards used in FAOSTAT"

Item Groups published in the section "Definitions and standards used in FAOSTAT"

Metadata

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 Column Description Datatype Descriptor Unit
Domain

Description of the domain 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.

String faostat:domainLabel [0.0.DMNLB417]

n/a

Item Group Code

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

String faostat:ItemCode [0.0.ITMCD423]

n/a

Item Group

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

String faostat:ItemLabel [0.0.TMLBL425]

n/a

Item Code

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

String faostat:ItemCode [0.0.ITMCD423]

n/a

Item

Name 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.

String faostat:ItemLabel [0.0.TMLBL425]

n/a

Factor
Decimal number DecimalNumber [0.0.DCMLN314]

n/a

CPC Code

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

String unsd:cpcCode [0.0.CPCCD426]

n/a

HS Code
String Text [0.0.TEXTA315]

n/a

HS07 Code

The 2007 edition of the WCO Harmonized Commodity Description and Coding System entered into force on 1 January 2007.

String faostat:hsCode07 [0.0.HSCDE427]

n/a

HS12 Code

The 2012 edition of the WCO Harmonized Commodity Description and Coding System entered into force on 1 January 2012.

String faostat:hsCode12 [0.0.HSCDE428]

n/a

"Domain Code"

Code of the domain 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.

String faostat:domainCode [0.0.DMNCD416]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 32. 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
Domain 8 - 54 n/a Bioenergy n/a n/a n/a Value of Agr… 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 33 ( 0.3% )
Item Group Code 2 - 5 n/a 1048 n/a n/a n/a TP 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 239 ( 2.1% )
Item Group 4 - 50 n/a AFOLU n/a n/a n/a Wood-based p… 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 220 ( 2.0% )
Item Code 2 - 7 n/a 15 n/a n/a n/a 2700305 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,235 ( 11.0% )
Item 3 - 220 n/a 2,4,5-T and… n/a n/a n/a hydrogenated… 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,223 ( 10.9% )
Factor 1 - 6 0.99277 0.0312 1 1 1 1 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 32 ( 0.3% )
CPC Code 0 - 29 n/a 0111 n/a n/a n/a F2076 11,205 1,234 ( 11.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 762 ( 6.8% )
HS Code 0 - 0 n/a n/a n/a n/a 11,205 11,205 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
HS07 Code 0 - 366 n/a 010110, 0101… n/a n/a n/a 530500 11,205 1,613 ( 14.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 406 ( 3.6% )
HS12 Code 0 - 374 n/a 010121, 0101… n/a n/a n/a 530500 11,205 1,613 ( 14.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 443 ( 4.0% )
"Domain Code" 2 - 4 n/a BE n/a n/a n/a WCAD 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 34 ( 0.3% )

Quality measures

Table 33. Quality analysis of the table. Column name (Name); completeness of the column (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
Domain
100.00%
0.29%
Crops and livestock products Cropland Nutrient Balance
Item Group Code
100.00%
2.13%
TP 6530
Item Group
100.00%
1.96%
Crops and livestock products Gaseous biofuels
Item Code
100.00%
11.02%
490 6524
Item
100.00%
10.91%
Oats Charcoal
Factor
100.00%
0.29%
1 0.08
CPC Code
88.99%
6.80%
n/a 34510
HS Code
0.00%
0.01%
n/a n/a
HS07 Code
85.60%
3.62%
n/a 4402
HS12 Code
85.60%
3.95%
n/a 4402
"Domain Code"
100.00%
0.30%
TCL ESB

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Units

Table 34. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.UNITS216.0
Name Units
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.UNITS216.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Units published in the section "Definitions and standards used in FAOSTAT"

Units published in the section "Definitions and standards used in FAOSTAT"

Metadata

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

Description of the 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.

String faostat:unitDescription [0.0.UNTDS420]

n/a

"Unit Name"

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.

String faostat:Unit [0.0.UNITA94]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 36. 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
Description 5 - 64 n/a Animals n/a n/a n/a thousand US… 65 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 100.0% )
"Unit Name" 1 - 29 n/a % n/a n/a n/a μg/cap/d 65 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 100.0% )

Quality measures

Table 37. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Description
100.00%
100.00%
Percent Percent
"Unit Name"
100.00%
100.00%
% %

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Year

Table 38. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.YEARA217.0
Name Year
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.YEARA217.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Years published in the section "Definitions and standards" of individual datasets

Years published in the section "Definitions and standards" of individual datasets

Metadata

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

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.

Integer number faostat:yearCode [0.0.YERCD429]

n/a

Year

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.

Integer number faostat:yearDescription [0.0.RDSCR430]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 40. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year Code 4 - 4 1,992.5 1,961 1,976.25 1,992.5 2,008.75 2,024 64 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 64 ( 100.0% )
Year 4 - 4 1,992.5 1,961 1,976.25 1,992.5 2,008.75 2,024 64 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 64 ( 100.0% )

Quality measures

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
Year Code
100.00%
100.00%
1961 1961
Year
100.00%
100.00%
1961 1961

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Month

Table 42. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTM9.MONTH221.0
Name Month
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTM9.MONTH221.0
Table Type File
Licence CC BY-NC-SA 3.0 IGO
Description

Various subdivisions of a year and periods deviating from the standard definition of a year used by FAOSTAT in various datasets.

Various subdivisions of a year and periods deviating from the standard definition of a year used by FAOSTAT in various datasets.

Metadata

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 Column Description Datatype Descriptor Unit
Months

Description of a period lasting one or more months 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.

String faostat:monthDescription [0.0.MNTHD794]

n/a

"Months Code"

Any period lasting one or more months 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.

Integer number faostat:monthCode [0.0.MNTHC793]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 44. 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
Months 3 - 19 n/a April n/a n/a n/a Sep–Oct–Nov 17 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 17 ( 100.0% )
"Months Code" 4 - 4 7,009.9 7,001 7,004.5 7,009 7,016.5 7,020 17 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 17 ( 100.0% )

Quality measures

Table 45. Quality analysis of the table. Column name (Name); completeness of the column (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
Months
100.00%
100.00%
January January
"Months Code"
100.00%
100.00%
7001 7001

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Table references

  1. FAO 2024 FAOSTAT. Food and Agriculture Organization Corporate Statistical Database. [2024-3-4] www.fao.org

References

  1. FAO 2024 Definitions and standards used in FAOSTAT. FAOSTAT. [2024-3-10] www.fao.org

Annex 1: Table column reports

Table: Abbreviations

Column: Definition

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

Abbreviations used by FAOSTAT, summarised in the "Abbreviations" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Data type String
Descriptor faostat:abbreviation [UID:0.0.BBRVT409]
Descriptor description

Abbreviations used by FAOSTAT, summarised in the "Abbreviations" 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.BBRVT409
Unit

n/a

Table 47. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Definition 6 - 356 n/a Arab Authori… n/a n/a n/a World Trade… 100 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 100 ( 100.0% )
Table 48. Quality analysis of the table. Column name (Name); completeness of the column (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
Definition
100.00%
100.00%
Arab Authority for Agricultural Investment and Development Arab Authority for Agricultural Investment and Development

Completeness

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

Uniqueness

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

Column: "Abbreviation"

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

Definition of the abbreviations used by FAOSTAT, summarised in the "Abbreviations" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Data type String
Descriptor faostat:abbreviationDescription [UID:0.0.BBRVT410]
Descriptor description

Description of the abbreviations used by FAOSTAT, summarised in the "Abbreviations" 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.BBRVT410
Unit

n/a

Table 50. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
"Abbreviation" 1 - 9 n/a AAAID n/a n/a n/a WTO 100 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 100 ( 100.0% )
Table 51. Quality analysis of the table. Column name (Name); completeness of the column (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
"Abbreviation"
100.00%
100.00%
AAAID AAAID

Completeness

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

Uniqueness

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

Table: Country Group

Column: Country Group

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

Name of a group 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.

Data type String
Descriptor faostat:areaLabel [UID:0.0.ARLBL412]
Descriptor description

Name of a country or a group 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.ARLBL412
Unit

n/a

Table 53. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Country Group 4 - 92 n/a Africa n/a n/a n/a World 2,658 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 61 ( 2.3% )
Table 54. Quality analysis of the table. Column name (Name); completeness of the column (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
Country Group
100.00%
2.29%
World Antarctic Region

Completeness

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

Uniqueness

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

Column: Group M49 Code

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).
Parameter Content
Column name Group M49 Code
Description

Standard code (M49) for a group of countries used by the Statistics Division of the United Nations Secretariat, 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.

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 56. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Group M49 Code 1 - 3 375.8 1 19 202 738 912 2,658 529 ( 19.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 57 ( 2.1% )
Table 57. Quality analysis of the table. Column name (Name); completeness of the column (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
Group M49 Code
80.10%
2.14%
1 912

Continuous Data Distribution

Figure 7. Distribution of values in the column.

Outliers

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

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: Country Code

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

Code of a country or region for which FAOSTAT reports data, summarised in the "Country/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

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 59. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Country Code 1 - 4 241.7 1 81 155.5 230 1,202 2,658 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 423 ( 15.9% )
Table 60. Quality analysis of the table. Column name (Name); completeness of the column (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
Country Code
100.00%
15.91%
122 252

Continuous Data Distribution

Figure 11. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Country

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

Name of a country or region for which FAOSTAT reports data, summarised in the "Country/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Data type String
Descriptor faostat:areaLabel [UID:0.0.ARLBL412]
Descriptor description

Name of a country or a group 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.ARLBL412
Unit

n/a

Table 62. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Country 4 - 64 n/a Adaptation F… n/a n/a n/a Åland Island… 2,658 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 423 ( 15.9% )
Table 63. Quality analysis of the table. Column name (Name); completeness of the column (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
Country
100.00%
15.91%
Lesotho Unspecified Area

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: M49 Code

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

Standard code (M49) for a country or region used by the Statistics Division of the United Nations Secretariat, for which FAOSTAT reports data, summarised in the "Contry/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

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 65. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
M49 Code 3 - 6 491.028 4 231 466 703.75 1,642 2,658 98 ( 3.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 375 ( 14.1% )
Table 66. Quality analysis of the table. Column name (Name); completeness of the column (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
M49 Code
96.31%
14.11%
n/a 896

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: ISO2 Code

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

A two-letter code that represents a country name, recommended as the general purpose code in ISO 3166-1 (Codes for the representation of names of countries and their subdivisions Part 1: Country code) and ISO 3166-3 (Codes for the representation of names of countries and their subdivisions Part 3: Code for formerly used names of countries).

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 68. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ISO2 Code 0 - 5 n/a AD n/a n/a n/a ZW 2,658 90 ( 3.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 379 ( 14.3% )
Table 69. Quality analysis of the table. Column name (Name); completeness of the column (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
ISO2 Code
96.61%
14.26%
n/a F252

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: ISO3 Code

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

A three-letter code that represents a country name, which is usually more closely related to the country name, in ISO 3166-1 (Codes for the representation of names of countries and their subdivisions Part 1: Country code) and ISO 3166-3 (Codes for the representation of names of countries and their subdivisions Part 3: Code for formerly used names of countries).

Data type String
Descriptor iso-3166:alpha-3CountryCode [UID:0.0.LPHCN5]
Descriptor description

A three-letter code that represents a country name, which is usually more closely related to the country name.

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

n/a

Table 71. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ISO3 Code 0 - 5 n/a 76 n/a n/a n/a ZWE 2,658 90 ( 3.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 379 ( 14.3% )
Table 72. Quality analysis of the table. Column name (Name); completeness of the column (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
ISO3 Code
96.61%
14.26%
n/a F252

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: "Country Group Code"

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).
Parameter Content
Column name Country Group Code
Description

Code of a group 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.

Data type Integer number
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 74. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
"Country Group Code" 3 - 4 4,757.0 336 5,000 5,400 5,826 5,901 2,658 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 61 ( 2.3% )
Table 75. Quality analysis of the table. Column name (Name); completeness of the column (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
"Country Group Code"
100.00%
2.29%
5000 5600

Continuous Data Distribution

Figure 25. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Country-Region

Column: Country

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

Name of a country or region for which FAOSTAT reports data, summarised in the "Country/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Data type String
Descriptor faostat:areaLabel [UID:0.0.ARLBL412]
Descriptor description

Name of a country or a group 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.ARLBL412
Unit

n/a

Table 77. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Country 4 - 67 n/a Afghanistan n/a n/a n/a Åland Island… 345 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 345 ( 100.0% )
Table 78. Quality analysis of the table. Column name (Name); completeness of the column (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
Country
100.00%
100.00%
Afghanistan Afghanistan

Completeness

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

Uniqueness

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

Column: M49 Code

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

Standard code (M49) for a country or region used by the Statistics Division of the United Nations Secretariat, for which FAOSTAT reports data, summarised in the "Contry/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

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 80. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
M49 Code 1 - 5 4,713.7 1 182 440 704.5 99,032 345 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 343 ( 99.4% )
Table 81. Quality analysis of the table. Column name (Name); completeness of the column (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
M49 Code
100.00%
99.42%
654 4

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: ISO2 Code

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

A two-letter code that represents a country name, recommended as the general purpose code in ISO 3166-1 (Codes for the representation of names of countries and their subdivisions Part 1: Country code) and ISO 3166-3 (Codes for the representation of names of countries and their subdivisions Part 3: Code for formerly used names of countries).

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 83. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ISO2 Code 0 - 6 n/a AD n/a n/a n/a ZW 345 1 ( 0.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 343 ( 99.4% )
Table 84. Quality analysis of the table. Column name (Name); completeness of the column (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
ISO2 Code
99.71%
99.42%
SH AF

Completeness

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

Uniqueness

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

Column: ISO3 Code

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

A three-letter code that represents a country name, which is usually more closely related to the country name, in ISO 3166-1 (Codes for the representation of names of countries and their subdivisions Part 1: Country code) and ISO 3166-3 (Codes for the representation of names of countries and their subdivisions Part 3: Code for formerly used names of countries).

Data type String
Descriptor iso-3166:alpha-3CountryCode [UID:0.0.LPHCN5]
Descriptor description

A three-letter code that represents a country name, which is usually more closely related to the country name.

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

n/a

Table 86. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ISO3 Code 0 - 6 n/a ABW n/a n/a n/a ZWE 345 1 ( 0.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 343 ( 99.4% )
Table 87. Quality analysis of the table. Column name (Name); completeness of the column (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
ISO3 Code
99.71%
99.42%
SHN AFG

Completeness

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

Uniqueness

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

Column: Start Year

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

Calendar year in which the validity of a country code starts (i.e. in which a country starts to exist).

Data type Integer number
Descriptor pms:startYear [UID:0.0.CLNDR414]
Descriptor description

dwc:year in which a dwc:Event starts.

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

n/a

Table 89. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Start Year 4 - 4 1,996.6 1,991 1,992 1,992 2,000 2,012 345 306 ( 88.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 2.3% )
Table 90. Quality analysis of the table. Column name (Name); completeness of the column (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
Start Year
11.30%
2.32%
1992 2000

Data Distribution Top 20

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

Continuous Data Distribution

Figure 40. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: End Year

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

Calendar year in which the validity of a country code ends (i.e. in which a country ceases to exist).

Data type Integer number
Descriptor pms:endYear [UID:0.0.CLNDR415]
Descriptor description

dwc:year in which a dwc:Event ends.

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

n/a

Table 92. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
End Year 4 - 4 1,997.9 1,990 1,991 1,992 2,007.5 2,011 345 336 ( 97.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 2.3% )
Table 93. Quality analysis of the table. Column name (Name); completeness of the column (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
End Year
2.61%
2.32%
1992 1999

Data Distribution Top 20

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

Continuous Data Distribution

Figure 45. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: "Country Code"

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).
Parameter Content
Column name "Country Code"
Description

Code of a country or region for which FAOSTAT reports data, summarised in the "Country/Region" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.

Data type Integer number
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 95. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
"Country Code" 1 - 5 5,346.0 1 88.5 176 277.5 99,032 345 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 343 ( 99.4% )
Table 96. Quality analysis of the table. Column name (Name); completeness of the column (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
"Country Code"
100.00%
99.42%
187 2

Continuous Data Distribution

Figure 49. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Element

Column: Domain

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

Description of the domain 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.

Data type String
Descriptor faostat:domainLabel [UID:0.0.DMNLB417]
Descriptor description

Domain 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.DMNLB417
Unit

n/a

Table 98. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Domain 17 - 103 n/a Climate Chan… n/a n/a n/a World Census… 542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 66 ( 12.2% )
Table 99. Quality analysis of the table. Column name (Name); completeness of the column (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
Domain
100.00%
12.18%
Trade: Crops and livestock products Discontinued archives and data series: Food Aid Shipments (WFP)

Completeness

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

Uniqueness

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

Column: Element Code

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

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

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 101. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element Code 2 - 6 n/a 55 n/a n/a n/a SLC 542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 371 ( 68.5% )
Table 102. Quality analysis of the table. Column name (Name); completeness of the column (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 Code
100.00%
68.45%
5910 72257

Completeness

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

Uniqueness

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

Column: Element

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

Description 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.

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 104. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element 4 - 80 n/a Agricultural… n/a n/a n/a Zinc content… 542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 278 ( 51.3% )
Table 105. Quality analysis of the table. Column name (Name); completeness of the column (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%
51.29%
Value Burning crop residues (Emissions CH4)

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: Unit

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

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 107. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Unit 0 - 29 n/a % n/a n/a n/a μg/cap/d 542 28 ( 5.2% ) 0 ( 0.0% ) 0 ( 0.0% ) 66 ( 12.2% )
Table 108. Quality analysis of the table. Column name (Name); completeness of the column (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
94.83%
12.18%
t t/cap

Completeness

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

Uniqueness

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

Column: "Domain Code"

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).
Parameter Content
Column name "Domain Code"
Description

Code of the domain 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.

Data type String
Descriptor faostat:domainCode [UID:0.0.DMNCD416]
Descriptor description

Code of the domain for which FAOSTAT provides data, as 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.DMNCD416
Unit

n/a

Table 110. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
"Domain Code" 2 - 4 n/a AE n/a n/a n/a WCAD 542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 66 ( 12.2% )
Table 111. Quality analysis of the table. Column name (Name); completeness of the column (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
"Domain Code"
100.00%
12.18%
TCL FA

Completeness

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

Uniqueness

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

Table: Flags

Column: Flags

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

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

Data type String
Descriptor faostat:flagDescription [UID:0.0.FLGDS422]
Descriptor description

Description of the flag used to add standardised comments to data provided by FAOSTAT data, 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.FLGDS422
Unit

n/a

Table 113. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flags 13 - 49 n/a Estimated va… n/a n/a n/a Time series… 11 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 11 ( 100.0% )
Table 114. Quality analysis of the table. Column name (Name); completeness of the column (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
Flags
100.00%
100.00%
Official figure Official figure

Completeness

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

Uniqueness

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

Column: "Flag"

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

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

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 116. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
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 11 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 11 ( 100.0% )
Table 117. Quality analysis of the table. Column name (Name); completeness of the column (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%
100.00%
A A

Completeness

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

Uniqueness

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

Table: Item

Column: Domain

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

Description of the domain 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.

Data type String
Descriptor faostat:domainLabel [UID:0.0.DMNLB417]
Descriptor description

Domain 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.DMNLB417
Unit

n/a

Table 119. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Domain 17 - 95 n/a Climate Chan… n/a n/a n/a World Census… 4,445 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 57 ( 1.3% )
Table 120. Quality analysis of the table. Column name (Name); completeness of the column (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
Domain
100.00%
1.28%
Trade: Crops and livestock products Discontinued archives and data series: ASTI-Expenditures

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: Item Code

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

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

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 122. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item Code 1 - 15 n/a 1 n/a n/a n/a 2700305 4,445 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,813 ( 40.8% )
Table 123. Quality analysis of the table. Column name (Name); completeness of the column (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 Code
100.00%
40.79%
44 1712

Completeness

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

Uniqueness

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

Column: Item

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

Name 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.

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 125. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item 3 - 220 n/a 12.3.1a Food… n/a n/a n/a hydrogenated… 4,445 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,772 ( 39.9% )
Table 126. Quality analysis of the table. Column name (Name); completeness of the column (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%
39.87%
Oats All Crops

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: Description

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

Description 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.

Data type String
Descriptor faostat:ItemDescription [UID:0.0.TMDSC424]
Descriptor description

Description 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.TMDSC424
Unit

n/a

Table 128. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Description 0 - 4,871 n/a (NH4)2SO4, i… n/a n/a n/a v (Unofficia… 4,445 865 ( 19.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 994 ( 22.4% )
Table 129. Quality analysis of the table. Column name (Name); completeness of the column (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
Description
80.54%
22.36%
n/a A lowland, tropical or subtropical vegetation formation, characterized by a continuous grassland cover occasionally interrupted by trees and shrubs.

Completeness

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

Uniqueness

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

Column: CPC Code

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

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

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 131. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
CPC Code 0 - 29 n/a 0111 n/a n/a n/a T0010 4,445 1,185 ( 26.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 814 ( 18.3% )
Table 132. Quality analysis of the table. Column name (Name); completeness of the column (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
CPC Code
73.34%
18.31%
n/a F1712

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: HS Code

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).
Parameter Content
Column name HS Code
Description
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

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

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

n/a

Table 134. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
HS Code 6 - 6 848,195.1 843,210 843,240 843,352 843,420 870,130 4,445 4,434 ( 99.8% ) 0 ( 0.0% ) 0 ( 0.0% ) 12 ( 0.3% )
Table 135. Quality analysis of the table. Column name (Name); completeness of the column (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
HS Code
0.25%
0.27%
843340 843340

Data Distribution Top 20

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

Continuous Data Distribution

Figure 80. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: HS07 Code

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

The 2007 edition of the WCO Harmonized Commodity Description and Coding System entered into force on 1 January 2007

Data type String
Descriptor faostat:hsCode07 [UID:0.0.HSCDE427]
Descriptor description

The 2007 edition of the WCO Harmonized System Nomenclature entered into force on 1 January 2007.

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

n/a

Table 137. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
HS07 Code 0 - 366 n/a 010110, 0101… n/a n/a n/a 530500 4,445 1,540 ( 34.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 406 ( 9.1% )
Table 138. Quality analysis of the table. Column name (Name); completeness of the column (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
HS07 Code
65.35%
9.13%
n/a 170112

Completeness

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

Uniqueness

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

Column: HS12 Code

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

The 2007 edition of the WCO Harmonized Commodity Description and Coding System entered into force on 1 January 2012

Data type String
Descriptor faostat:hsCode12 [UID:0.0.HSCDE428]
Descriptor description

The 2012 edition of the WCO Harmonized System Nomenclature entered into force on 1 January 2012.

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

n/a

Table 140. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
HS12 Code 0 - 374 n/a 010121, 0101… n/a n/a n/a 530500 4,445 1,540 ( 34.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 443 ( 10.0% )
Table 141. Quality analysis of the table. Column name (Name); completeness of the column (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
HS12 Code
65.35%
9.97%
n/a 170112

Completeness

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

Uniqueness

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

Column: "Domain Code"

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).
Parameter Content
Column name "Domain Code"
Description

Code of the domain 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.

Data type String
Descriptor faostat:domainCode [UID:0.0.DMNCD416]
Descriptor description

Code of the domain for which FAOSTAT provides data, as 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.DMNCD416
Unit

n/a

Table 143. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
"Domain Code" 2 - 4 n/a AE n/a n/a n/a WCAD 4,445 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 57 ( 1.3% )
Table 144. Quality analysis of the table. Column name (Name); completeness of the column (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
"Domain Code"
100.00%
1.28%
TCL AE

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Table: Item Group

Column: Domain

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

Description of the domain 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.

Data type String
Descriptor faostat:domainLabel [UID:0.0.DMNLB417]
Descriptor description

Domain 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.DMNLB417
Unit

n/a

Table 146. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Domain 8 - 54 n/a Bioenergy n/a n/a n/a Value of Agr… 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 33 ( 0.3% )
Table 147. Quality analysis of the table. Column name (Name); completeness of the column (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
Domain
100.00%
0.29%
Crops and livestock products Cropland Nutrient Balance

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: Item Group Code

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).
Parameter Content
Column name Item Group Code
Description

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

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 149. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item Group Code 2 - 5 n/a 1048 n/a n/a n/a TP 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 239 ( 2.1% )
Table 150. Quality analysis of the table. Column name (Name); completeness of the column (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 Group Code
100.00%
2.13%
TP 6530

Completeness

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

Uniqueness

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

Column: Item Group

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

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

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 152. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item Group 4 - 50 n/a AFOLU n/a n/a n/a Wood-based p… 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 220 ( 2.0% )
Table 153. Quality analysis of the table. Column name (Name); completeness of the column (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 Group
100.00%
1.96%
Crops and livestock products Gaseous biofuels

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: Item Code

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

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

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 155. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item Code 2 - 7 n/a 15 n/a n/a n/a 2700305 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,235 ( 11.0% )
Table 156. Quality analysis of the table. Column name (Name); completeness of the column (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 Code
100.00%
11.02%
490 6524

Completeness

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

Uniqueness

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

Column: Item

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

Name 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.

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 158. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item 3 - 220 n/a 2,4,5-T and… n/a n/a n/a hydrogenated… 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,223 ( 10.9% )
Table 159. Quality analysis of the table. Column name (Name); completeness of the column (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%
10.91%
Oats Charcoal

Completeness

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

Uniqueness

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

Column: Factor

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).
Parameter Content
Column name Factor
Description
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.

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

n/a

Table 161. Structural analysis of the table. Column name (Name); concise description 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
Factor 1 - 6 0.99277 0.0312 1 1 1 1 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 32 ( 0.3% )
Table 162. Quality analysis of the table. Column name (Name); completeness of the column (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
Factor
100.00%
0.29%
1 0.08

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: CPC Code

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

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

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 164. Structural analysis of the table. Column name (Name); concise description 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
CPC Code 0 - 29 n/a 0111 n/a n/a n/a F2076 11,205 1,234 ( 11.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 762 ( 6.8% )
Table 165. Quality analysis of the table. Column name (Name); completeness of the column (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
CPC Code
88.99%
6.80%
n/a 34510

Completeness

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

Uniqueness

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

Column: HS Code

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).
Parameter Content
Column name HS Code
Description
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

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

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

n/a

Table 167. Structural analysis of the table. Column name (Name); concise description 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
HS Code 0 - 0 n/a n/a n/a n/a 11,205 11,205 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 168. Quality analysis of the table. Column name (Name); completeness of the column (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
HS Code
0.00%
0.01%
n/a n/a

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: HS07 Code

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

The 2007 edition of the WCO Harmonized Commodity Description and Coding System entered into force on 1 January 2007.

Data type String
Descriptor faostat:hsCode07 [UID:0.0.HSCDE427]
Descriptor description

The 2007 edition of the WCO Harmonized System Nomenclature entered into force on 1 January 2007.

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

n/a

Table 170. Structural analysis of the table. Column name (Name); concise description 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
HS07 Code 0 - 366 n/a 010110, 0101… n/a n/a n/a 530500 11,205 1,613 ( 14.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 406 ( 3.6% )
Table 171. Quality analysis of the table. Column name (Name); completeness of the column (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
HS07 Code
85.60%
3.62%
n/a 4402

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: HS12 Code

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

The 2012 edition of the WCO Harmonized Commodity Description and Coding System entered into force on 1 January 2012.

Data type String
Descriptor faostat:hsCode12 [UID:0.0.HSCDE428]
Descriptor description

The 2012 edition of the WCO Harmonized System Nomenclature entered into force on 1 January 2012.

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

n/a

Table 173. Structural analysis of the table. Column name (Name); concise description 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
HS12 Code 0 - 374 n/a 010121, 0101… n/a n/a n/a 530500 11,205 1,613 ( 14.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 443 ( 4.0% )
Table 174. Quality analysis of the table. Column name (Name); completeness of the column (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
HS12 Code
85.60%
3.95%
n/a 4402

Completeness

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

Uniqueness

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

Column: "Domain Code"

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).
Parameter Content
Column name "Domain Code"
Description

Code of the domain 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.

Data type String
Descriptor faostat:domainCode [UID:0.0.DMNCD416]
Descriptor description

Code of the domain for which FAOSTAT provides data, as 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.DMNCD416
Unit

n/a

Table 176. Structural analysis of the table. Column name (Name); concise description 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
"Domain Code" 2 - 4 n/a BE n/a n/a n/a WCAD 11,205 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 34 ( 0.3% )
Table 177. Quality analysis of the table. Column name (Name); completeness of the column (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
"Domain Code"
100.00%
0.30%
TCL ESB

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Table: Units

Column: Description

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

Description of the 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.

Data type String
Descriptor faostat:unitDescription [UID:0.0.UNTDS420]
Descriptor description

Description of the 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.UNTDS420
Unit

n/a

Table 179. Structural analysis of the table. Column name (Name); concise description 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
Description 5 - 64 n/a Animals n/a n/a n/a thousand US… 65 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 100.0% )
Table 180. Quality analysis of the table. Column name (Name); completeness of the column (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
Description
100.00%
100.00%
Percent Percent

Completeness

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

Uniqueness

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

Column: "Unit Name"

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).
Parameter Content
Column name "Unit Name"
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.

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 182. Structural analysis of the table. Column name (Name); concise description 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 Name" 1 - 29 n/a % n/a n/a n/a μg/cap/d 65 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 100.0% )
Table 183. Quality analysis of the table. Column name (Name); completeness of the column (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 Name"
100.00%
100.00%
% %

Completeness

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

Uniqueness

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

Table: Year

Column: Year Code

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).
Parameter Content
Column name Year Code
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.

Data type Integer number
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 185. Structural analysis of the table. Column name (Name); concise description 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 Code 4 - 4 1,992.5 1,961 1,976.25 1,992.5 2,008.75 2,024 64 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 64 ( 100.0% )
Table 186. Quality analysis of the table. Column name (Name); completeness of the column (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 Code
100.00%
100.00%
1961 1961

Continuous Data Distribution

Figure 126. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Year

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

Data type Integer number
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 188. Structural analysis of the table. Column name (Name); concise description 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 1,992.5 1,961 1,976.25 1,992.5 2,008.75 2,024 64 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 64 ( 100.0% )
Table 189. Quality analysis of the table. Column name (Name); completeness of the column (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%
100.00%
1961 1961

Continuous Data Distribution

Figure 130. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Table: Month

Column: Months

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

Description of a period lasting one or more months 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.

Data type String
Descriptor faostat:monthDescription [UID:0.0.MNTHD794]
Descriptor description

Description of a period lasting one or more months 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.MNTHD794
Unit

n/a

Table 191. Structural analysis of the table. Column name (Name); concise description 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
Months 3 - 19 n/a April n/a n/a n/a Sep–Oct–Nov 17 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 17 ( 100.0% )
Table 192. Quality analysis of the table. Column name (Name); completeness of the column (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
Months
100.00%
100.00%
January January

Completeness

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

Uniqueness

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

Column: "Months Code"

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).
Parameter Content
Column name "Months Code"
Description

Any period lasting one or more months 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.

Data type Integer number
Descriptor faostat:monthCode [UID:0.0.MNTHC793]
Descriptor description

Any period lasting one month or more months 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.MNTHC793
Unit

n/a

Table 194. Structural analysis of the table. Column name (Name); concise description 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
"Months Code" 4 - 4 7,009.9 7,001 7,004.5 7,009 7,016.5 7,020 17 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 17 ( 100.0% )
Table 195. Quality analysis of the table. Column name (Name); completeness of the column (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
"Months Code"
100.00%
100.00%
7001 7001

Continuous Data Distribution

Figure 136. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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