EU Pollinator Hub

, ,

Dataset Report
Unique identifier: FSTTQ230.0.0
Title: FAOSTAT QCL Pollinated Crops
Long title: FAOSTAT data on production of pollinated crops
Status: Quality Validated
Current Version: v. 1.0
Published: 2025-02-28
Reviewed by: Rubinigg Michael as Data scientist
Citation proposal:
Food and Agriculture Organization of the United Nations 2025 Report of dataset FAOSTAT QCL Pollinated Crops, v. 1.0 [FSTTQ230.0.0]. EU Pollinator Hub. [2026-04-07] 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 2025-02-28. 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 2025-02-28 00:02:00 Initial release. n/a

Abbreviations

No abbreviations.

Executive summary

Data overview:

n/a

Data value:

n/a

Data description:

n/a

Data application:

n/a

Unresolved issues:

n/a

Introduction

n/a

Material and methods

Data acquisition

File Production_Crops_Livestock_E_All_Data_(Normalized).zip was downloaded from the website of the Food and Agriculture Organization Corporate Statistical Database FAOSTAT provided by FAO on 2025-04-01 14:37:21.

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_PP_area harvested_PREP_MR_250401.csv CSV - Comma seperated values Yes No 2025-04-01 16:04:06 4,859,596 42.74 MiB
2 FAOSTAT_PP_yield_PREP_MR_250401.csv CSV - Comma seperated values Yes No 2025-04-01 16:04:55 4,221,588 35.64 MiB
3 FAOSTAT_PP_production_PREP_MR_250401.csv CSV - Comma seperated values Yes No 2025-04-01 16:04:39 5,289,788 45.16 MiB
4 QCL_methodology_e.pdf Miscellaneous No Yes 2025-04-01 16:04:38 n/a 134.32 KiB
5 Q_Revision_Note_e.pdf Miscellaneous No Yes 2025-04-01 16:04:34 n/a 602.13 KiB
6 cd3755en.pdf Miscellaneous No Yes 2025-04-01 16:04:33 n/a 681.06 KiB
7 history_updates.csv Miscellaneous No Yes 2025-04-01 16:04:05 n/a 2.35 KiB

Data preparation

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

Data validation

n/a

Data analysis

n/a

Data description

Dataset

Table 3. Summary of tables belonging to the dataset. Table row identifier (No); name of the table (Table); description of the table (Description).
No Table Description
1 Area harvested World production (are harvested) of crops requiring pollination by animals according to Klein et al. 2007, given in ha.
2 Yield World production (yield) of crops requiring pollination by animals according to Klein et al. 2007, given in kg/ha.
3 Production World production (production) of crops requiring pollination by animals according to Klein et al. 2007, given in t.
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid FSTTQ230.0.0
Title FAOSTAT QCL Pollinated Crops
Long title FAOSTAT data on production of pollinated crops
Target IRI https://app.pollinatorhub.eu/dataset-discovery/FSTTQ230.0.0
interactions.single.section-details.licence CC BY 4.0
DOI n/a
Created 2025-04-01
Published 2025-02-28
Contact n/a
Keywords FAOSTAT, crops, pollination, production
Data collection years n/a
Regions, the data was collected in Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antigua and Barbuda, Argentina, Armenia, Aruba, Ascension Island, Australia, Austria, Azerbaijan, Bahamas (the), Bahrain, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia (Plurinational State of), Bonaire, Sint Eustatius and Saba, Bosnia and Herzegovina, Botswana, Bouvet Island, Brazil, British Antarctic Territory, British Indian Ocean Territory (the), Brunei Darussalam, Bulgaria, Burkina Faso, Burma, Burundi, Byelorussian SSR, Cabo Verde, Cambodia, Cameroon, Canada, Canton and Enderbury Islands, Cayman Islands (the), Central African Republic (the), Chad, Chile, China, Christmas Island, Clipperton Island, Cocos (Keeling) Islands (the), Colombia, Comoros (the), Congo (the Democratic Republic of the), Congo (the), Cook Islands (the), Costa Rica, Croatia, Cuba, Curaçao, Cyprus, Czechia, Czechoslovakia, Côte d'Ivoire, Dahomey, Denmark, Diego Garcia, Djibouti, Dominica, Dominican Republic (the), Dronning Maud Land, East Timor, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Eswatini, Ethiopia, Falkland Islands (the) [Malvinas], Faroe Islands (the), Fiji, Finland, France, France, Metropolitan, French Afars and Issas, French Guiana, French Polynesia, French Southern Territories (the), French Southern and Antarctic Territories, Gabon, Gambia (the), Georgia, German Democratic Republic, Germany, Ghana, Gibraltar, Gilbert and Ellice Islands, Greece, Greenland, Grenada, Guadeloupe, Guam, Guatemala, Guernsey, Guinea, Guinea-Bissau, Guyana, Haiti, Heard Island and McDonald Islands, Holy See (the), Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iran (Islamic Republic of), Iraq, Ireland, Island of Sark, Isle of Man, Israel, Italy, Jamaica, Japan, Jersey, Johnston Island, Jordan, Kazakhstan, Kenya, Kiribati, Korea (the Democratic People's Republic of), Korea (the Republic of), Kuwait, Kyrgyzstan, Lao People's Democratic Republic (the), Latvia, Lebanon, Lesotho, Liberia, Libya, Liechtenstein, Lithuania, Luxembourg, Macao, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands (the), Martinique, Mauritania, Mauritius, Mayotte, Mexico, Micronesia (Federated States of), Midway Islands, Moldova (the Republic of), Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Myanmar, Namibia, Nauru, Nepal, Netherlands (the), Netherlands Antilles, Neutral Zone, New Caledonia, New Hebrides, New Zealand, Nicaragua, Niger (the), Nigeria, Niue, Norfolk Island, North Macedonia, Northern Mariana Islands (the), Norway, Oman, Pacific Islands (Trust Territory), Pakistan, Palau, Palestine, State of, Panama, Panama Canal Zone, Papua New Guinea, Paraguay, Peru, Philippines (the), Pitcairn, Poland, Portugal, Puerto Rico, Qatar, Romania, Russian Federation (the), Rwanda, Réunion, Saint Barthélemy, Saint Helena, Ascension and Tristan da Cunha, Saint Kitts and Nevis, Saint Lucia, Saint Martin (French part), Saint Pierre and Miquelon, Saint Vincent and the Grenadines, Samoa, San Marino, Sao Tome and Principe, Saudi Arabia, Senegal, Serbia, Serbia and Montenegro, Seychelles, Sierra Leone, Sikkim, Singapore, Sint Maarten (Dutch part), Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, South Georgia and the South Sandwich Islands, South Sudan, Southern Rhodesia, Spain, Sri Lanka, Sudan (the), Suriname, Svalbard and Jan Mayen, Sweden, Switzerland, Syrian Arab Republic (the), Taiwan (Province of China), Tajikistan, Tanzania, the United Republic of, Thailand, Timor-Leste, Togo, Tokelau, Tonga, Trinidad and Tobago, Tristan da Cunha, Tunisia, Turkmenistan, Turks and Caicos Islands (the), Tuvalu, Türkiye, USSR, Uganda, Ukraine, United Arab Emirates (the), United Kingdom of Great Britain and Northern Ireland (the), United States Minor Outlying Islands (the), United States Miscellaneous Pacific Islands, United States of America (the), Upper Volta, Uruguay, Uzbekistan, Vanuatu, Venezuela (Bolivarian Republic of), Viet Nam, Viet-Nam, Democratic Republic of, Virgin Islands (British), Virgin Islands (U.S.), Wake Island, Wallis and Futuna, Western Sahara, Yemen, Yemen, Democratic, Yugoslavia, Zaire, Zambia, Zimbabwe, Åland Islands
Abstract

This dataset contains data related to crops that require pollination by animals according to Klein et al. 2007 from the FAOSTAT crop and livestock statistics. It includes also the relevant metadata published by FAO.

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

Area harvested

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTQ230.RHRVS575.0
Name Area harvested
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTQ230.RHRVS575.0
Table Type File
Licence CC BY 4.0
Description

World production (are harvested) of crops requiring pollination by animals according to Klein et al. 2007, given in ha.

World production (are harvested) of crops requiring pollination by animals according to Klein et al. 2007, given in ha.

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
AreaCode
Integer number faostat:areaCode [0.0.ARECD411]

n/a

M49Code
Integer number unsd:m49Code [0.0.MCODE356]

n/a

Area
String faostat:areaLabel [0.0.ARLBL412]

n/a

ItemCode
Integer number faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCpc
String unsd:cpcCode [0.0.CPCCD426]

n/a

Item
String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode
Integer number faostat:elementCode [0.0.LMNTC418]

n/a

Element
String faostat:elementLabel [0.0.LMNTL419]

n/a

YearCode
Integer number faostat:yearCode [0.0.YERCD429]

n/a

Year
Integer number faostat:yearDescription [0.0.RDSCR430]

n/a

Unit
String faostat:Unit [0.0.UNITA94]

n/a

Value
Integer number dwc:measurementValue [0.0.MSRMN621]

n/a

Flag
String faostat:flag [0.0.FLAGA421]

n/a

Note
String Text [0.0.TEXTA315]

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
AreaCode 1 - 4 1,498.3 1 89 171 5,000 5,817 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
M49Code 3 - 3 354.7 1 100 320 604 902 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
Area 4 - 52 n/a Chad n/a n/a n/a United Kingd… 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
ItemCode 2 - 4 465.8 89 289 430 554 1,804 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
ItemCodeCpc 4 - 8 n/a 0141 n/a n/a n/a 01379.02 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
Item 4 - 60 n/a Figs n/a n/a n/a Chillies and… 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
ElementCode 4 - 4 5,312.0 5,312 5,312 5,312 5,312 5,312 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Element 14 - 14 n/a Area harvest… n/a n/a n/a Area harvest… 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
YearCode 4 - 4 1,993.4 1,961 1,978 1,994 2,009 2,023 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Year 4 - 4 1,993.4 1,961 1,978 1,994 2,009 2,023 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Unit 2 - 2 n/a ha n/a n/a n/a ha 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Value 8 - 16 274,319.5192824 0.000000 735 6,500 47,499 136,903,849.000000 347,114 35,197 ( 10.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 90,448 ( 26.1% )
Flag 1 - 1 n/a A n/a n/a n/a M 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5 ( 0.0% )
Note 0 - 17 n/a n/a n/a n/a Unofficial f… 347,114 338,873 ( 97.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )

Quality measures

Table 9. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
AreaCode
100.00%
0.07%
5000 127
M49Code
100.00%
0.07%
001 584
Area
100.00%
0.07%
World Marshall Islands
ItemCode
100.00%
0.02%
571 224
ItemCodeCpc
100.00%
0.02%
01316 01379.02
Item
100.00%
0.02%
Mangoes, guavas and mangosteens Kola nuts
ElementCode
100.00%
0.00%
5312 5312
Element
100.00%
0.00%
Area harvested Area harvested
YearCode
100.00%
0.02%
2018 1961
Year
100.00%
0.02%
2018 1961
Unit
100.00%
0.00%
ha ha
Value
89.86%
26.06%
null 13469.000000
Flag
100.00%
0.00%
A X
Note
2.37%
0.00%
null Unofficial figure

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Table references

  1. Klein A., Vaissière BE., Cane JH., Steffan-Dewenter I., Cunningham SA., Kremen C. et al. 2007 Importance of pollinators in changing landscapes for world crops. Proceedings of the Royal Society B: Biological Sciences. Vol. 274, (1608) pp. 303-313. doi: 10.1098/rspb.2006.3721

Yield

Table 10. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTQ230.YIELD576.0
Name Yield
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTQ230.YIELD576.0
Table Type File
Licence CC BY 4.0
Description

World production (yield) of crops requiring pollination by animals according to Klein et al. 2007, given in kg/ha.

World production (yield) of crops requiring pollination by animals according to Klein et al. 2007, given in kg/ha.

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
AreaCode
Integer number faostat:areaCode [0.0.ARECD411]

n/a

M49Code
Integer number unsd:m49Code [0.0.MCODE356]

n/a

Area
String dwc:country [0.0.CNTRY159]

n/a

ItemCode
Integer number faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCpc
String unsd:cpcCode [0.0.CPCCD426]

n/a

Item
String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode
Integer number faostat:elementCode [0.0.LMNTC418]

n/a

Element
String faostat:elementLabel [0.0.LMNTL419]

n/a

YearCode
Integer number faostat:yearCode [0.0.YERCD429]

n/a

Year
Integer number dwc:year [0.0.YEARA340]

year

Unit
String faostat:Unit [0.0.UNITA94]

n/a

Value
Decimal number dwciri:measurementValue [0.0.MSRMN620]

n/a

Flag
String faostat:flag [0.0.FLAGA421]

n/a

Note
String Text [0.0.TEXTA315]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 12. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
AreaCode 1 - 4 1,680.9 1 95 177 5,103 5,817 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 243 ( 0.1% )
M49Code 3 - 3 346.7 1 84 288 598 902 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 243 ( 0.1% )
Area 4 - 52 n/a Chad n/a n/a n/a United Kingd… 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 243 ( 0.1% )
ItemCode 2 - 4 468.5 89 289 430 552 1,804 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
ItemCodeCpc 4 - 8 n/a 0141 n/a n/a n/a 01379.02 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
Item 4 - 60 n/a Figs n/a n/a n/a Chillies and… 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
ElementCode 4 - 4 5,412.0 5,412 5,412 5,412 5,412 5,412 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Element 5 - 5 n/a Yield n/a n/a n/a Yield 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
YearCode 4 - 4 1,995.1 1,961 1,981 1,997 2,010 2,023 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Year 4 - 4 1,995.1 1,961 1,981 1,997 2,010 2,023 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Unit 5 - 5 n/a kg/ha n/a n/a n/a kg/ha 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Value 8 - 13 10,442.6824177 0.000000 1,261 5,583.6 12,507.65 875,527.800000 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 131,521 ( 43.6% )
Flag 1 - 1 n/a E n/a n/a n/a X 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.0% )
Note 0 - 0 n/a n/a n/a n/a 301,542 301,542 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )

Quality measures

Table 13. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
AreaCode
100.00%
0.08%
5000 127
M49Code
100.00%
0.08%
001 584
Area
100.00%
0.08%
World Marshall Islands
ItemCode
100.00%
0.02%
571 224
ItemCodeCpc
100.00%
0.02%
01316 01379.02
Item
100.00%
0.02%
Mangoes, guavas and mangosteens Kola nuts
ElementCode
100.00%
0.00%
5412 5412
Element
100.00%
0.00%
Yield Yield
YearCode
100.00%
0.02%
2017 1961
Year
100.00%
0.02%
2017 1961
Unit
100.00%
0.00%
kg/ha kg/ha
Value
100.00%
43.62%
10000.000000 2623.400000
Flag
100.00%
0.00%
E X
Note
0.00%
0.00%
null null

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Table references

  1. Klein A., Vaissière BE., Cane JH., Steffan-Dewenter I., Cunningham SA., Kremen C. et al. 2007 Importance of pollinators in changing landscapes for world crops. Proceedings of the Royal Society B: Biological Sciences. Vol. 274, (1608) pp. 303-313. doi: 10.1098/rspb.2006.3721

Production

Table 14. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier FSTTQ230.PRDCT577.0
Name Production
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/FSTTQ230.PRDCT577.0
Table Type File
Licence CC BY 4.0
Description

World production (production) of crops requiring pollination by animals according to Klein et al. 2007, given in t.

World production (production) of crops requiring pollination by animals according to Klein et al. 2007, given in t.

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
AreaCode
Integer number faostat:areaCode [0.0.ARECD411]

n/a

M49Code
Integer number unsd:m49Code [0.0.MCODE356]

n/a

Area
String dwc:country [0.0.CNTRY159]

n/a

ItemCode
Integer number faostat:ItemCode [0.0.ITMCD423]

n/a

ItemCodeCpc
String unsd:cpcCode [0.0.CPCCD426]

n/a

Item
String faostat:ItemLabel [0.0.TMLBL425]

n/a

ElementCode
Integer number faostat:elementCode [0.0.LMNTC418]

n/a

Element
String faostat:elementCode [0.0.LMNTC418]

n/a

YearCode
Integer number faostat:yearCode [0.0.YERCD429]

n/a

Year
Integer number dwc:year [0.0.YEARA340]

year

Unit
String faostat:Unit [0.0.UNITA94]

n/a

Value
Decimal number pms:maximumMeasurementValue [0.0.MXMMM853]

n/a

Flag
String faostat:flag [0.0.FLAGA421]

n/a

Note
String Text [0.0.TEXTA315]

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
AreaCode 1 - 4 1,512.3 1 89 171 5,100 5,817 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
M49Code 3 - 3 354.3 1 100 312 600 902 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
Area 4 - 52 n/a Chad n/a n/a n/a United Kingd… 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
ItemCode 2 - 4 454.3 89 268 426 550 1,804 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 0.0% )
ItemCodeCpc 4 - 8 n/a 0141 n/a n/a n/a 01379.02 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 0.0% )
Item 4 - 60 n/a Figs n/a n/a n/a Chillies and… 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 0.0% )
ElementCode 4 - 4 5,510.0 5,510 5,510 5,510 5,510 5,510 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Element 10 - 10 n/a Production n/a n/a n/a Production 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
YearCode 4 - 4 1,993.1 1,961 1,977 1,994 2,009 2,023 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Year 4 - 4 1,993.1 1,961 1,977 1,994 2,009 2,023 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Unit 1 - 1 n/a t n/a n/a n/a t 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Value 8 - 16 937,394.4644328 0.000000 2,471.7425 26,307 199,600 414,427,109.820000 377,842 27,686 ( 7.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 170,501 ( 45.1% )
Flag 1 - 1 n/a A n/a n/a n/a M 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5 ( 0.0% )
Note 0 - 17 n/a n/a n/a n/a Unofficial f… 377,842 363,679 ( 96.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )

Quality measures

Table 17. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
AreaCode
100.00%
0.06%
5000 127
M49Code
100.00%
0.06%
001 584
Area
100.00%
0.06%
World Marshall Islands
ItemCode
100.00%
0.02%
571 216
ItemCodeCpc
100.00%
0.02%
01316 01377
Item
100.00%
0.02%
Mangoes, guavas and mangosteens Brazil nuts, in shell
ElementCode
100.00%
0.00%
5510 5510
Element
100.00%
0.00%
Production Production
YearCode
100.00%
0.02%
2018 1962
Year
100.00%
0.02%
2018 1962
Unit
100.00%
0.00%
t t
Value
92.67%
45.12%
null 11773.990000
Flag
100.00%
0.00%
A X
Note
3.75%
0.00%
null Unofficial figure

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

Table references

  1. Klein A., Vaissière BE., Cane JH., Steffan-Dewenter I., Cunningham SA., Kremen C. et al. 2007 Importance of pollinators in changing landscapes for world crops. Proceedings of the Royal Society B: Biological Sciences. Vol. 274, (1608) pp. 303-313. doi: 10.1098/rspb.2006.3721

References

  1. FAO 2025 FAOSTAT Crops and livestock products. Food and Agriculture Organization Corporate Statistical Database. [2025-4-1] www.fao.org
  2. FAO 2024 Agricultural production statistics 2010–2023. FAOSTST Analytical Brief 96. [2025-4-1] openknowledge.fao.org
  3. Klein A., Vaissière BE., Cane JH., Steffan-Dewenter I., Cunningham SA., Kremen C. et al. 2007 Importance of pollinators in changing landscapes for world crops. Proceedings of the Royal Society B: Biological Sciences. Vol. 274, (1608) pp. 303-313. doi: 10.1098/rspb.2006.3721

Annex 1: Table column reports

Table: Area harvested

Column: AreaCode

Table 18. Structural analysis of the table. Column name (Name); concise description 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 AreaCode
Description
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 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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
AreaCode 1 - 4 1,498.3 1 89 171 5,000 5,817 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
Table 20. Quality analysis of the table. Column name (Name); completeness of the column (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
AreaCode
100.00%
0.07%
5000 127

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: M49Code

Table 21. Structural analysis of the table. Column name (Name); concise description 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 M49Code
Description
Data type Integer number
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 22. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
M49Code 3 - 3 354.7 1 100 320 604 902 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
Table 23. Quality analysis of the table. Column name (Name); completeness of the column (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
M49Code
100.00%
0.07%
001 584

Data Distribution Top 20

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

Data Distribution Bottom 20

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

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

Table 24. Structural analysis of the table. Column name (Name); concise description 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 Area
Description
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 25. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Area 4 - 52 n/a Chad n/a n/a n/a United Kingd… 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
Table 26. Quality analysis of the table. Column name (Name); completeness of the column (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
Area
100.00%
0.07%
World Marshall Islands

Data Distribution Top 20

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

Data Distribution Bottom 20

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

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

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).
Parameter Content
Column name ItemCode
Description
Data type Integer number
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 28. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCode 2 - 4 465.8 89 289 430 554 1,804 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
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
ItemCode
100.00%
0.02%
571 224

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: ItemCodeCpc

Table 30. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ItemCodeCpc
Description
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 31. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCodeCpc 4 - 8 n/a 0141 n/a n/a n/a 01379.02 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
Table 32. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeCpc
100.00%
0.02%
01316 01379.02

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: Item

Table 33. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Item
Description
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 34. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item 4 - 60 n/a Figs n/a n/a n/a Chillies and… 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
Table 35. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Item
100.00%
0.02%
Mangoes, guavas and mangosteens Kola nuts

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: ElementCode

Table 36. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ElementCode
Description
Data type Integer number
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 37. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ElementCode 4 - 4 5,312.0 5,312 5,312 5,312 5,312 5,312 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 38. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ElementCode
100.00%
0.00%
5312 5312

Data Distribution Top 20

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

Continuous Data Distribution

Figure 29. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Element

Table 39. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Element
Description
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 40. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element 14 - 14 n/a Area harvest… n/a n/a n/a Area harvest… 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
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
Element
100.00%
0.00%
Area harvested Area harvested

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: YearCode

Table 42. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name YearCode
Description
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 43. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
YearCode 4 - 4 1,993.4 1,961 1,978 1,994 2,009 2,023 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Table 44. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
YearCode
100.00%
0.02%
2018 1961

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Year

Table 45. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Year
Description
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 46. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 1,993.4 1,961 1,978 1,994 2,009 2,023 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Table 47. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Year
100.00%
0.02%
2018 1961

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Unit

Table 48. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Unit
Description
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 49. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Unit 2 - 2 n/a ha n/a n/a n/a ha 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 50. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Unit
100.00%
0.00%
ha ha

Data Distribution Top 20

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

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

Table 51. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Value
Description
Data type Integer number
Descriptor dwc:measurementValue [UID:0.0.MSRMN621]
Descriptor description

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

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

n/a

Table 52. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 8 - 16 274,319.5192824 0.000000 735 6,500 47,499 136,903,849.000000 347,114 35,197 ( 10.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 90,448 ( 26.1% )
Table 53. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Value
89.86%
26.06%
null 13469.000000

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.

Column: Flag

Table 54. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Flag
Description
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 55. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flag 1 - 1 n/a A n/a n/a n/a M 347,114 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5 ( 0.0% )
Table 56. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Flag
100.00%
0.00%
A X

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Note

Table 57. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Note
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 58. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Note 0 - 17 n/a n/a n/a n/a Unofficial f… 347,114 338,873 ( 97.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )
Table 59. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Note
2.37%
0.00%
null Unofficial figure

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: Yield

Column: AreaCode

Table 60. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name AreaCode
Description
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 61. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
AreaCode 1 - 4 1,680.9 1 95 177 5,103 5,817 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 243 ( 0.1% )
Table 62. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
AreaCode
100.00%
0.08%
5000 127

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: M49Code

Table 63. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name M49Code
Description
Data type Integer number
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 64. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
M49Code 3 - 3 346.7 1 84 288 598 902 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 243 ( 0.1% )
Table 65. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
M49Code
100.00%
0.08%
001 584

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Area

Table 66. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Area
Description
Data type String
Descriptor dwc:country [UID:0.0.CNTRY159]
Descriptor description

A collective generic term that refers here to a wide variety of dependencies, areas of special sovereignty, uninhabited islands, and other entities in addition to the traditional countries or independent states.

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

n/a

Table 67. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Area 4 - 52 n/a Chad n/a n/a n/a United Kingd… 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 243 ( 0.1% )
Table 68. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Area
100.00%
0.08%
World Marshall Islands

Data Distribution Top 20

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

Data Distribution Bottom 20

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

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

Table 69. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ItemCode
Description
Data type Integer number
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 70. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCode 2 - 4 468.5 89 289 430 552 1,804 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
Table 71. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCode
100.00%
0.02%
571 224

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: ItemCodeCpc

Table 72. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ItemCodeCpc
Description
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 73. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCodeCpc 4 - 8 n/a 0141 n/a n/a n/a 01379.02 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
Table 74. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeCpc
100.00%
0.02%
01316 01379.02

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: Item

Table 75. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Item
Description
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 76. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item 4 - 60 n/a Figs n/a n/a n/a Chillies and… 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 60 ( 0.0% )
Table 77. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Item
100.00%
0.02%
Mangoes, guavas and mangosteens Kola nuts

Data Distribution Top 20

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

Data Distribution Bottom 20

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

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

Table 78. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ElementCode
Description
Data type Integer number
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 79. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ElementCode 4 - 4 5,412.0 5,412 5,412 5,412 5,412 5,412 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 80. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ElementCode
100.00%
0.00%
5412 5412

Data Distribution Top 20

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

Continuous Data Distribution

Figure 87. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Element

Table 81. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Element
Description
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 82. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element 5 - 5 n/a Yield n/a n/a n/a Yield 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 83. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Element
100.00%
0.00%
Yield Yield

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: YearCode

Table 84. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name YearCode
Description
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 85. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
YearCode 4 - 4 1,995.1 1,961 1,981 1,997 2,010 2,023 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Table 86. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
YearCode
100.00%
0.02%
2017 1961

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Year

Table 87. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Year
Description
Data type Integer number
Descriptor dwc:year [UID:0.0.YEARA340]
Descriptor description

time scale unit [...] defined by the calendar [...] system

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

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 1,995.1 1,961 1,981 1,997 2,010 2,023 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Table 89. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Year
100.00%
0.02%
2017 1961

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

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

Table 90. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Unit
Description
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 91. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Unit 5 - 5 n/a kg/ha n/a n/a n/a kg/ha 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 92. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Unit
100.00%
0.00%
kg/ha kg/ha

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Value

Table 93. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Value
Description
Data type Decimal number
Descriptor dwciri:measurementValue [UID:0.0.MSRMN620]
Descriptor description

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

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

n/a

Table 94. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 8 - 13 10,442.6824177 0.000000 1,261 5,583.6 12,507.65 875,527.800000 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 131,521 ( 43.6% )
Table 95. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Value
100.00%
43.62%
10000.000000 2623.400000

Continuous Data Distribution

Figure 107. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Flag

Table 96. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Flag
Description
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 97. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flag 1 - 1 n/a E n/a n/a n/a X 301,542 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.0% )
Table 98. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Flag
100.00%
0.00%
E X

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

Table 99. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Note
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 100. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Note 0 - 0 n/a n/a n/a n/a 301,542 301,542 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 101. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Note
0.00%
0.00%
null null

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: Production

Column: AreaCode

Table 102. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name AreaCode
Description
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 103. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
AreaCode 1 - 4 1,512.3 1 89 171 5,100 5,817 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
Table 104. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
AreaCode
100.00%
0.06%
5000 127

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: M49Code

Table 105. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name M49Code
Description
Data type Integer number
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 106. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
M49Code 3 - 3 354.3 1 100 312 600 902 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
Table 107. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
M49Code
100.00%
0.06%
001 584

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Area

Table 108. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Area
Description
Data type String
Descriptor dwc:country [UID:0.0.CNTRY159]
Descriptor description

A collective generic term that refers here to a wide variety of dependencies, areas of special sovereignty, uninhabited islands, and other entities in addition to the traditional countries or independent states.

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

n/a

Table 109. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Area 4 - 52 n/a Chad n/a n/a n/a United Kingd… 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 244 ( 0.1% )
Table 110. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Area
100.00%
0.06%
World Marshall Islands

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: ItemCode

Table 111. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ItemCode
Description
Data type Integer number
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 112. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCode 2 - 4 454.3 89 268 426 550 1,804 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 0.0% )
Table 113. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCode
100.00%
0.02%
571 216

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

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

Table 114. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ItemCodeCpc
Description
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 115. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ItemCodeCpc 4 - 8 n/a 0141 n/a n/a n/a 01379.02 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 0.0% )
Table 116. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ItemCodeCpc
100.00%
0.02%
01316 01377

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: Item

Table 117. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Item
Description
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 118. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Item 4 - 60 n/a Figs n/a n/a n/a Chillies and… 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 65 ( 0.0% )
Table 119. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Item
100.00%
0.02%
Mangoes, guavas and mangosteens Brazil nuts, in shell

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: ElementCode

Table 120. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ElementCode
Description
Data type Integer number
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 121. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ElementCode 4 - 4 5,510.0 5,510 5,510 5,510 5,510 5,510 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 122. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ElementCode
100.00%
0.00%
5510 5510

Data Distribution Top 20

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

Continuous Data Distribution

Figure 145. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Element

Table 123. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Element
Description
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 124. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Element 10 - 10 n/a Production n/a n/a n/a Production 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 125. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Element
100.00%
0.00%
Production Production

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: YearCode

Table 126. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name YearCode
Description
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 127. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
YearCode 4 - 4 1,993.1 1,961 1,977 1,994 2,009 2,023 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Table 128. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
YearCode
100.00%
0.02%
2018 1962

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Year

Table 129. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Year
Description
Data type Integer number
Descriptor dwc:year [UID:0.0.YEARA340]
Descriptor description

time scale unit [...] defined by the calendar [...] system

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

year

Table 130. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Year 4 - 4 1,993.1 1,961 1,977 1,994 2,009 2,023 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 63 ( 0.0% )
Table 131. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Year
100.00%
0.02%
2018 1962

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: Unit

Table 132. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Unit
Description
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 133. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Unit 1 - 1 n/a t n/a n/a n/a t 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 134. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Unit
100.00%
0.00%
t t

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Value

Table 135. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Value
Description
Data type Decimal number
Descriptor pms:maximumMeasurementValue [UID:0.0.MXMMM853]
Descriptor description

The upper limit of a range of measurement Values.

Descriptor target IRI https://app.pollinatorhub.eu/dashboard/descriptors/853
Unit

n/a

Table 136. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Value 8 - 16 937,394.4644328 0.000000 2,471.7425 26,307 199,600 414,427,109.820000 377,842 27,686 ( 7.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 170,501 ( 45.1% )
Table 137. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Value
92.67%
45.12%
null 11773.990000

Continuous Data Distribution

Figure 165. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: Flag

Table 138. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Flag
Description
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 139. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flag 1 - 1 n/a A n/a n/a n/a M 377,842 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5 ( 0.0% )
Table 140. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Flag
100.00%
0.00%
A X

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Note

Table 141. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Note
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 142. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Note 0 - 17 n/a n/a n/a n/a Unofficial f… 377,842 363,679 ( 96.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )
Table 143. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Note
3.75%
0.00%
null Unofficial figure

Data Distribution Top 20

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

Completeness

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

Uniqueness

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