an sql file that uses as data the official names of countries in english as given in ISO 3166-1, the ISO 2-alpha code provided by the International Organization for Standardization, the ISO 3-alpha code provided by the United Nations Statistics Division and the 3-alpha code provided by The National Olympic Committees. you also have the flags for each country in the flags folder - the pictures of the flags are named using the ISO 2-alpha code of the country they represent so you should have no problems in determining which flag goes to which country this list is as of january 2006 so it might not be the most up to date list you could find. also, keep in mind that while all the countries have numeric id code and ISO 2-alpha code but not all the countries have ISO 3-alpha and NOC 3-alpha codes