IP2Location™ ISO 3166-2 Subdivision Code

IP2Location™ ISO 3166-2 Subdivision Code is a free data offered for your download. This data contains the ISO3166-2 code for the states/regions used in our geolocation database. You can easily retrieve the ISO3166-2 code by mapping the country code and subdivision name.

IP2Location™ geolocation database or service is compliant with ISO 3166-2 for all countries except,

Singapore - we categorize Singapore as a single subdivision.

Please note that the below 49 countries that don't have the official ISO3166-2 subdivisions defined.
Anguilla, Antarctica, American Samoa, Aruba, Aland Islands, Saint Barthelemy, Bermuda, Bouvet Island, Cocos (Keeling) Islands, Cook Islands, Curacao, Christmas Island, Western Sahara, Falkland Islands (Malvinas), Faroe Islands, French Guiana, Guernsey, Gibraltar, Guadeloupe, Heard Island and Mcdonald Islands, South Georgia and The South Sandwich Islands, Guam, Hong Kong, Isle of Man, British Indian Ocean Territory, Jersey, Cayman Islands, Saint Martin (French Part), Macao, Northern Mariana Islands, Martinique, Montserrat, New Caledonia, Norfolk Island, Niue, French Polynesia, Saint Pierre and Miquelon, Pitcairn, Puerto Rico, Reunion, Svalbard and Jan Mayen, Sint Maarten (Dutch Part), Turks and Caicos Islands, French Southern Territories, Tokelau, Holy See, Virgin Islands, British, Virgin Islands, U.S., Mayotte.

Download

Free download

Features

Last Update	01 December, 2024
Database Format	CSV Text File (Comma Delimited)

Database Fields

Name	Type	Description
country_code	CHAR(2)	Two-character country code based on ISO 3166.
subdivision_name	VARCHAR(128)	Subdivision name.
code	VARCHAR(10)	ISO3166-2 code.

Sample Database

"country_code","subdivision_name","code"
"AD","Andorra la Vella","AD-07"
"AD","Canillo","AD-02"
"AD","Encamp","AD-03"
"AD","Escaldes-Engordany","AD-08"
"AD","La Massana","AD-04"

MySQL Statement

CREATE TABLE `ip2location_iso3166_2`(
	`country_code` CHAR(2),
	`subdivision_name` VARCHAR(128),
	`code` VARCHAR(10),
	INDEX `idx_country_code` (`country_code`),
	INDEX `idx_region_name` (`subdivision_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-ISO3166-2.CSV' INTO TABLE `ip2location_iso3166_2`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

License Information

This works is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0).

It is free for personal or commercial use with attribution required by mentioning the use of this works as follows:
"This site or product includes IP2Location™ ISO 3166-2 Subdivision Code which available from https://www.ip2location.com."