Countries

This database contains the standard codes and names of all countries and territories.
Country names are based on the cartographic section of the United Nations.

Data structure


FieldTypeDescriptionKey
ISOvarchar(2)ISO-3166-1 codePK
Countrynvarchar(45)NamePK
Sovereignvarchar(2)Sovereign country code
Capitalnvarchar(45)Capitale
Languagevarchar(2)ISO 639-1 code 
LanguagePCvarchar(10)Postcodes data available in languages 
Currencyvarchar(3)ISO 4217 code 
Records: 252
Download
 Reference data
Administrative divisions
Countries
Countries names
Currencies
Languages
Postal codes format
Time zones
Formulas & samples
Distance between points
Locate points in a radius
Find postal code of a point