World Bank Look Up

The World Bank provides a downloadable country lookup table which includes the name of the country, a three-character country code, it's geographical region, it's income status and other information. The file downloads as an Excel spreadsheet and a second worksheet provides data on special statuses by country. The table is available at http://data.worldbank.org/about/country-classifications/country-and-lending-groups.  The databases themselves are available at href="http://databank.worldbank.org/data/databases.aspx.

The first thing to note is that there are three discrepancies between the spelling of country names in the database and the country lookup table--the difference is due to the country lookup table including accents in the spelling while the data base does not include accents.  The World Bank also includes data for a two "countries" not included in the ISO listing. There are also many differences in the spelling of country names between the World Bank and the ISO and some discrepancies between the three character country code used by the World Bank and those of the ISO.

The WB_LU lookup table uses the data from the main lookup table in the World Bank downloadable table but does not use the secondary worksheet. For those who need this secondary data it can easily be linked (in a database application) to the WB_LU table using the World Bank three character codes (do not use the country names-- this will omit data for three countries because of the spelling differences.

The fields in the WB_LU table are:
WBCountryLC: The World Bank country name.
WBA3: The World Bank three character country code.
WBRegion: The World Bank geographical region.
WBIncomeGroup: The World Bank income classification.
WBLendingCategory: The World Bank lendding category.
WBOther: Information on other statuses--for example Heavily indebted poor countries (HIPC) or European Monetary Union (EMU).
ISOA3: The ISO three character country code.
ISOCountryLC: The ISO lower case country name.

No sample of the table is provided-- it is too wide to fit comfortably on the web page. To download the WB_LU lookup table which is in Excel (.xls) format click here.

Copyright 1998/2015 GRI    Updated 6 May 2015