Table structure and fields details for the worldCountries database

countries table

This table contains the country names (in English) and codes.
fieldfield descriptiondata typeStandard
CC1FIPS country code
A 2-character code uniquely identifying a geopolitical entity (countries, dependencies and areas of special sovereignty).
text (max. 2 characters)
FULLNAMEFull name, including diacritics and special characters
Diacritics are symbols situated on top or below characters, such as accents.
text (max. 255 characters)
REGION_IDRegion numeric code
A 3-digit code uniquely identifying a region, which allows to link the country to the corresponding sub-region, region, and continent.
text (max. 3 characters)
ISO_ALPHA2ISO 3166 country code, 2 letterstext (max. 2 characters)
ISO_ALPHA3ISO 3166 country code, 3 letterstext (max. 3 characters)
ISO_NUMERICISO 3166 country code, 3 digitstext (max. 3 characters)
INTERNETInternet country suffixtext (max. 3 characters)
ISO_4217ISO 4217 currency codetext (max. 3 characters)
PHONE_CCPhone country code
International phone prefix used when dialing to the country from outside.
text (max. 11 characters)
CC2Secondary FIPS country code
A 2-character code uniquely identifying the country code of a particular name if different than that of the feature. Also used to refer to the country of a dependency.
text (max. 2 characters)
COMMENTNotes and commentstext (max. 255 characters)

countries_variants table

This table contains all the country names in their local language(s) as well as in English and other languages. Variants (such as former names of some countries) are also included.
fieldfield descriptiondata typeStandard
UFIUnique Feature Identifier
A number which uniquely identifies the feature.
integer (positive or negative)
UNIUnique Name Identifier
A number which uniquely identifies a name.
integer (positive or negative)
CC1FIPS country code
A 2-character code uniquely identifying a geopolitical entity (countries, dependencies and areas of special sovereignty).
text (max. 2 characters)
DSGFeature Designation Code
A 2 to 5-character code used to identify the type of feature a name is applied to.
text (max. 5 characters)
NTName Typetext (1 character)
LCISO 639-3 language code
A 3-character code uniquely identifying the language of a feature name. Not available for all records.
text (max. 3 characters)
SHORTFORMShort name
A specific part of the name that could substitute for the full name.
text (max. 128 characters)
FULLNAMEFull name, including diacritics and special characters
Diacritics are symbols situated on top or below characters, such as accents.
text (max. 200 characters)
CHARACTERSWriting system
Indicates which alphabet is used for the feature name.
text (max. 24 characters)

regions table

This table contains the names and codes of the continents, regions and subregions.
fieldfield descriptiondata typeStandard
REGION_IDRegion numeric code
A 3-digit code uniquely identifying a region, which allows to link the country to the corresponding sub-region, region, and continent.
text (max. 3 characters)
REGION_PARENTParent region
A 3-digit code uniquely identifying the parent record of a region.
text (max. 3 characters)
REGION_NAMEName of the continent or regiontext (max. 128 characters)
LCISO 639-3 language code
A 3-character code uniquely identifying the language of a feature name. Not available for all records.
text (max. 3 characters)
CHARACTERSWriting system
Indicates which alphabet is used for the feature name.
text (max. 24 characters)

languages table

This table contains the languages codes used in the database, along with their name and ISO 639-1 codes, for easy cross-referencing with other data sources.
fieldfield descriptiondata typeStandard
LCISO 639-3 language code
A 3-character code uniquely identifying the language of a feature name. Not available for all records.
text (max. 3 characters)
ISO_639_1ISO 639-1 Language Codetext (max. 2 characters)
NAMENametext (max. 128 characters)

This information applies only to the data files available since the last update of the worldCountries database. The content of older files might differ.