• Your shopping cart is empty!
FREE

IP2Location™ Region Multilingual Database

IP2Location™ Region Multilingual Database contains the fully translated world region names in English, Spanish, Italian, Portuguese and Chinese. The data is being offered absolutely FREE to our valued customers. The database is provided in the CSV format, so that you can easily import into any database of your choice.

Download
For Customers Only
Languages Supported
Language Code Language Name
AR Arabic
CS Czech
DA Danish
DE German
EN English
ES Spanish
ET Estonian
FI Finnish
FR French
GA Irish
IT Italian
JA Japanese
KO Korean
MS Malay
NL Dutch
PT Portuguese
RU Russian
SV Swedish
TR Turkish
VI Vietnamese
ZH-CN Chinese Simplified
ZH-TW Chinese Traditional
Features
Last Update 01 November, 2019
Database Format CSV Text File (Comma Delimited)
Database Fields
Name Type Description
country_alpha2_code VARCHAR(2) Two-character country code based on ISO 3166.
country_numeric_code VARCHAR(3) Numeric country code based on ISO 3166.
country_name VARCHAR(64) Country name based on ISO 3166.
region_code VARCHAR(10) Region code
region_name VARCHAR(128) Region name
lang_code VARCHAR(5) Language code
lang_name VARCHAR(50) Language name
lang_region_name VARCHAR(200) Region name in native language based on language code.

Sample Database

"country_alpha2_code","country_numeric_code","country_name","region_code","region_name","lang_code","lang_name","lang_region_name"
"AD","020","Andorra","07","Andorra la Vella","EN","ENGLISH","Andorra la Vella"
"AD","020","Andorra","02","Canillo","EN","ENGLISH","Canillo"
"AD","020","Andorra","03","Encamp","EN","ENGLISH","Encamp"
"AD","020","Andorra","08","Escaldes-Engordany","EN","ENGLISH","Escaldes-Engordany"
"AD","020","Andorra","04","La Massana","EN","ENGLISH","La Massana"

MySQL Statement

CREATE TABLE `ip2location_region_multilingual`(
	`country_alpha2_code` VARCHAR(2),
	`country_numeric_code` VARCHAR(3),
	`country_name` VARCHAR(64),
	`region_code` VARCHAR(10),
	`region_name` VARCHAR(128),
	`lang_code` VARCHAR(5),
	`lang_name` VARCHAR(50),
	`lang_region_name` VARCHAR(200),
    PRIMARY KEY (`country_alpha2_code`,`region_name`)
) CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-COUNTRY-REGION.CSV' INTO TABLE `ip2location_region_multilingual`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
License Information

Attribution is required by mentioning the use of this data as follows, "The IP geolocation data is provided by https://www.ip2location.com", on your webpage and in the documentation or advertising.

IP2Location™ and IP2Proxy™ are registered trademarks of HEXASOFT. All other trademarks are the properties of their respective owners.

Country Name (English)
Country Code Country Name
AF Afghanistan
AX Aland Islands
AL Albania
DZ Algeria
AS American Samoa
Show More »