Table structure and fields details for the adminDivisions database

definitions table

Look-up table with descriptions of codes used in some columns of the other tables.
fieldfield descriptiondata typeStandard
field_nameName of the field/columntext (max. 32 characters)
field_valueValue of the field/columntext (max. 32 characters)
iso_639_3ISO 639-3 code
A 3-character code uniquely identifying a language.
text (max. 5 characters)
charactersWriting system
Indicates which alphabet is used for the feature name.
text (max. 24 characters)
value_shortdescShort description of the valuetext (max. 64 characters)
value_shortdesc_pluralPlural form of the short descriptiontext (max. 64 characters)
value_longdescMore detailed description of the valuetext (max. 16777215 characters)

features_codes table

Contains ISO, FIPS and other codes. Not available for all features.
fieldfield descriptiondata typeStandard
feature_idFeature identifier
A number which uniquely identifies the feature.
integer (positive)
fips_alphaFIPS alpha code
A 2- or 3-character code identifying a geopolitical entity (country, state, region, etc...), according to the FIPS standard.
text (max. 3 characters)
fips_numericFIPS numeric code
A 2- or 3-digit code identifying a geopolitical entity (country, state, region, etc...), according to the FIPS standard.
text (max. 3 characters)
iso_alpha1ISO 3166-2 code, 1 letter
A 1-letter code identifying a geopolitical entity (state, region, etc...). Not available for all features.
text (1 character)
iso_alpha2ISO 3166 country code, 2 letterstext (2 characters)
iso_alpha3ISO 3166 country code, 3 letterstext (3 characters)
iso_numericISO 3166 country code, 3 digitstext (max. 3 characters)
postalAbbreviation used for postal purposes
Not available for all features.
text (max. 3 characters)
abbreviationFeature name abbreviation
Not available for all features.
text (max. 8 characters)
internetInternet country suffixtext (max. 2 characters)
phoneInternational or area phone code
Not available for all features.
text (max. 11 characters)
commentNotes and commentstext (max. 255 characters)

features_details table

This is the base table, which contains the features' general types (country, 1st-level administrative division,...) and, in most case, more detailed descriptions (state, county, province,...).
fieldfield descriptiondata typeStandard
feature_idFeature identifier
A number which uniquely identifies the feature.
integer (positive)
feature_typeGeneral description of the feature
Indicate the main type of feature (country, administrative division, city, etc...)
text (max. 32 characters)
feature_descriptionDetailed description of the feature
More detailed description than feature_type
text (max. 64 characters)

features_hierarchy table

Used to link the features. Both parent-child relationships and values for a Preorder Tree Traversal approach are included.
fieldfield descriptiondata typeStandard
feature_idFeature identifier
A number which uniquely identifies the feature.
integer (positive)
parent_idfeature_id of the parent feature
Used in the classic parent-child relationship
integer (positive)
lftLeft value
Used for the Preorder Tree Traversal
integer (positive)
rgtRight value
Used for the Preorder Tree Traversal
integer (positive)

features_names table

Full and shortnames of the features with ISO language code and type of name (local, translation, romanized version,...)
fieldfield descriptiondata typeStandard
feature_idFeature identifier
A number which uniquely identifies the feature.
integer (positive)
name_typeName type
Identifies if the name is in the local language, romanized version, translation, etc...
text (max. 3 characters)
iso_639_3ISO 639-3 code
A 3-character code uniquely identifying a language.
text (max. 3 characters)
charactersWriting system
Indicates which alphabet is used for the feature name.
text (max. 24 characters)
shortnameShort form of the name
A specific part of the name that could substitute for the full name.
text (max. 128 characters)
shortname_ndShort name without diacritics and special characters
Diacritics are symbols situated on top or below characters, such as accents,...
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)
fullname_ndFull name, without diacritics and special characters
Diacritics are symbols situated on top or below characters, such as accents,...
text (max. 200 characters)

official_languages table

Look-up table with the official language(s) of the countries and, in some cases, country subdivisions.
fieldfield descriptiondata typeStandard
feature_idFeature identifier
A number which uniquely identifies the feature.
integer (positive)
iso_639_3ISO 639-3 code
A 3-character code uniquely identifying a language.
text (3 characters)

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