• Your shopping cart is empty!
FREE

IP2Location™ City Multilingual Database

IP2Location™ City Multilingual Database is a free database offered to our valued customers. This database enables you to query the region and city names in their country's native language (Note: For countries that have multiple native languages, only one language will be selected for our database inclusion). The database is provided in the CSV format, so that you can easily import into any database of your choice.

Download
For Customers Only
Features
Last Update 01 May, 2023
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
city_name VARCHAR(128) City 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.
lang_city_name VARCHAR(200) City name in native language based on language code.
* Please note that if a region/city couldn't get translated, the lang_code, lang_name, lang_region_name and lang_city_name will be filled with '-' (hyphen).
Sample Database
"country_alpha2_code","country_numeric_code","country_name","region_code","region_name","city_name","lang_code","lang_name","lang_region_name","lang_city_name"
"AD","020","Andorra","AD-07","Andorra la Vella","Andorra la Vella","CA","CATALAN","Andorra la Vella","Andorra la Vella"
"AD","020","Andorra","AD-07","Andorra la Vella","Santa Coloma","CA","CATALAN","Andorra la Vella","Santa Coloma"
"AD","020","Andorra","AD-02","Canillo","Canillo","CA","CATALAN","Canillo","Canillo"
"AD","020","Andorra","AD-02","Canillo","El Tarter","CA","CATALAN","Canillo","el Tarter"
"AD","020","Andorra","AD-02","Canillo","Ransol","CA","CATALAN","Canillo","Ransol"
MySQL Statement
CREATE TABLE `ip2location_city_multilingual`(
	`country_alpha2_code` VARCHAR(2),
	`country_numeric_code` VARCHAR(3),
	`country_name` VARCHAR(64),
	`region_code` VARCHAR(10),
	`region_name` VARCHAR(128),
	`city_name` VARCHAR(128),
	`lang_code` VARCHAR(5),
	`lang_name` VARCHAR(50),
	`lang_region_name` VARCHAR(200),
	`lang_city_name` VARCHAR(200),
    PRIMARY KEY (`country_alpha2_code`,`region_name`,`city_name`)
) CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-COUNTRY-REGION-CITY.CSV' INTO TABLE `ip2location_city_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.

Languages Supported
Language Code Language Name
Native Translation based on native language of the country. For example, EN for United States
ZH-CN Chinese Simplified
ZH-TW Chinese Traditional
Country Name (English)
Country Code Country Name
AD Andorra
AE United Arab Emirates
AF Afghanistan
AG Antigua and Barbuda
AI Anguilla
Show More »