ISO 3166-2 country subdivision codes

The country names are based on the cartographic section of the United Nations.
The ISO 3166-2 standard is published by the International Organization for Standardization (ISO) and defines subdivisions/regions codes.

Data structure


FieldTypeDescriptionKey
ISOvarchar(2)ISO-3166-1 country codePK
Countrynvarchar(45)Country name
Categorynvarchar(45)Category
Codevarchar(10)ISO 3166-2 region codePK
Languagevarchar(2)ISO 639-1 language code 
Namevarchar(85)Region name 
AltNamevarchar(85)Altenative region name 
Parentvarchar(10)Parent code 
Records: 6 240
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