However, in this case the "COUNTRY" field is made up of a collection of country names with different spellings collected from data downloads generated for a number of UN and other organizations as well as country groupings used by the World Bank. This list is not comprehensive in that it doesn't include all the possible variations of a country name (including misspellings) but does include variations from a number of the more popular data download sites. It includes the UNDP data in which a hard space is inserted before the country name. This table is used by linking the country name in the downloaded data with the COUNTRY field in "country_list, this will provide at least a preliminary list of country names and their associated ISO codes. It may be necessary to fill in the blanks manually, but the downloaded "country_list" table can be updated to include alternative country name spellings by the user. The table can be downloaded at COUNTRIES_LU. This table was updated 21 May 2019. It includes multiple variations for the spelling of some country names,including obvious misspellings. New spelling variants used in downloadable databases are added when they are discovered.
Special Cases--Individual lookup tables are also provided for
special cases-- data downloads from important sites which have their own
codes. In these cases the data from "country_list" will be attached to
the country name and code produced by each of the organizations.
These tables are available here.
USCB-- The US Census Bureau has developed its own code and also publishes the ISO2 code. The list is available at https://www.census.gov/foreign-trade/schdules/countrycode.html . The column headings are:
A text version of the list was downloaded from https://www.census.gov/foreign-trade/schedules/c/country.txt and converted to xls spreadsheet format. The file can be downloaded at USCB_LU.