FAO Look Up

FAO has since 2010 made it's formerly for fee databases available for free as well as creating a new interface for accessing the data at http://faostat.fao.org/. The data for the newer interface is available either for download either as a query or a bulk download from http://faostat3.fao.org/home/index.html#DOWNLOAD.

FAO also supplies a complete list of country names including the ISO Alph2 code and additional information on continents, regions, food status, etc. at http://faostat.fao.org/site/371/default.aspx these latter files have been used to build the lookup table because it any one data table may not include all of the countries FAO collects data for.

Note that unlike organizations like the World Bank, FAO does not recalculate previous time series data when getographical boundaries change-- so there is still data based on the USSR and other regions that no longer exist as entities. Also, for current countries, the FAO spelling of country names is inconsistent with 19 of the ISO country name spellings.

The fields in the FAO_LU table are:
FAOCountryLC: The lower case spelling of the country name provided by FAO.
ISOA3: The ISO three character alpha code.
ISOA2: The ISO two character alpha code.
ISOCountryLC: The lower case spelling of the ISO country name.
FAOContinent: The FAO identification of the countinent in which the country is located.
FAOSubRegion: The FAO identification of the region in which the country is located
FAOEconomicGroup: The special economic group to which the country belongs.
FAOLandlocked: Indicates whether the country is landlocked or not.
FAOFood1: Identifies countries which are Low Income Food Deficit countries.
FAOFood2: Identifies countries which are Net Food Importing Developing Countries.
FAOAnnex: Indicates the FAO annex status of the country.

The whole FAO lookup table is too wide to show on this page. The chart below shows the first few rows of the first six columns of the lookup table.

To download the FAO_LU lookup table which is in Excel (.xls) format click here.

Copyright 1998/2015 GRI    Updated 5 May 2015