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 16 March, 2024
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
AF Afghanistan
AX Aland Islands
AL Albania
DZ Algeria
AS American Samoa
Show More »
AD Andorra
AO Angola
AI Anguilla
AQ Antarctica
AG Antigua and Barbuda
AR Argentina
AM Armenia
AW Aruba
AU Australia
AT Austria
AZ Azerbaijan
BS Bahamas
BH Bahrain
BD Bangladesh
BB Barbados
BY Belarus
BE Belgium
BZ Belize
BJ Benin
BM Bermuda
BT Bhutan
BO Bolivia (Plurinational State of)
BQ Bonaire, Sint Eustatius and Saba
BA Bosnia and Herzegovina
BW Botswana
BV Bouvet Island
BR Brazil
IO British Indian Ocean Territory
BN Brunei Darussalam
BG Bulgaria
BF Burkina Faso
BI Burundi
CV Cabo Verde
KH Cambodia
CM Cameroon
CA Canada
KY Cayman Islands
CF Central African Republic
TD Chad
CL Chile
CN China
CX Christmas Island
CC Cocos (Keeling) Islands
CO Colombia
KM Comoros
CG Congo
CD Congo (Democratic Republic of the)
CK Cook Islands
CR Costa Rica
CI Cote d'Ivoire
HR Croatia
CU Cuba
CW CuraƧao
CY Cyprus
CZ Czechia
DK Denmark
DJ Djibouti
DM Dominica
DO Dominican Republic
EC Ecuador
EG Egypt
SV El Salvador
GQ Equatorial Guinea
ER Eritrea
EE Estonia
SZ Eswatini
ET Ethiopia
FK Falkland Islands (Malvinas)
FO Faroe Islands
FJ Fiji
FI Finland
FR France
GF French Guiana
PF French Polynesia
TF French Southern Territories
GA Gabon
GM Gambia
GE Georgia
DE Germany
GH Ghana
GI Gibraltar
GR Greece
GL Greenland
GD Grenada
GP Guadeloupe
GU Guam
GT Guatemala
GG Guernsey
GN Guinea
GW Guinea-Bissau
GY Guyana
HT Haiti
HM Heard Island and McDonald Islands
VA Holy See
HN Honduras
HK Hong Kong
HU Hungary
IS Iceland
IN India
ID Indonesia
IR Iran (Islamic Republic of)
IQ Iraq
IE Ireland
IM Isle of Man
IL Israel
IT Italy
JM Jamaica
JP Japan
JE Jersey
JO Jordan
KZ Kazakhstan
KE Kenya
KI Kiribati
KP Korea (Democratic People's Republic of)
KR Korea (Republic of)
KW Kuwait
KG Kyrgyzstan
LA Lao People's Democratic Republic
LV Latvia
LB Lebanon
LS Lesotho
LR Liberia
LY Libya
LI Liechtenstein
LT Lithuania
LU Luxembourg
MO Macao
MG Madagascar
MW Malawi
MY Malaysia
MV Maldives
ML Mali
MT Malta
MH Marshall Islands
MQ Martinique
MR Mauritania
MU Mauritius
YT Mayotte
MX Mexico
FM Micronesia (Federated States of)
MD Moldova (Republic of)
MC Monaco
MN Mongolia
ME Montenegro
MS Montserrat
MA Morocco
MZ Mozambique
MM Myanmar
NA Namibia
NR Nauru
NP Nepal
NL Netherlands
NC New Caledonia
NZ New Zealand
NI Nicaragua
NE Niger
NG Nigeria
NU Niue
NF Norfolk Island
MK North Macedonia
MP Northern Mariana Islands
NO Norway
OM Oman
PK Pakistan
PW Palau
PS Palestine, State of
PA Panama
PG Papua New Guinea
PY Paraguay
PE Peru
PH Philippines
PN Pitcairn
PL Poland
PT Portugal
PR Puerto Rico
QA Qatar
RE Reunion
RO Romania
RU Russian Federation
RW Rwanda
BL Saint Barthelemy
SH Saint Helena, Ascension and Tristan da Cunha
KN Saint Kitts and Nevis
LC Saint Lucia
MF Saint Martin (French Part)
PM Saint Pierre and Miquelon
VC Saint Vincent and the Grenadines
WS Samoa
SM San Marino
ST Sao Tome and Principe
SA Saudi Arabia
SN Senegal
RS Serbia
SC Seychelles
SL Sierra Leone
SG Singapore
SX Sint Maarten (Dutch Part)
SK Slovakia
SI Slovenia
SB Solomon Islands
SO Somalia
ZA South Africa
GS South Georgia and the South Sandwich Islands
SS South Sudan
ES Spain
LK Sri Lanka
SD Sudan
SR Suriname
SJ Svalbard and Jan Mayen
SE Sweden
CH Switzerland
SY Syrian Arab Republic
TW Taiwan (Province of China)
TJ Tajikistan
TZ Tanzania, United Republic of
TH Thailand
TL Timor-Leste
TG Togo
TK Tokelau
TO Tonga
TT Trinidad and Tobago
TN Tunisia
TR Turkey
TM Turkmenistan
TC Turks and Caicos Islands
TV Tuvalu
UG Uganda
UA Ukraine
AE United Arab Emirates
GB United Kingdom of Great Britain and Northern Ireland
UM United States Minor Outlying Islands
US United States of America
UY Uruguay
UZ Uzbekistan
VU Vanuatu
VE Venezuela (Bolivarian Republic of)
VN Viet Nam
VG Virgin Islands (British)
VI Virgin Islands (U.S.)
WF Wallis and Futuna
EH Western Sahara
YE Yemen
ZM Zambia
ZW Zimbabwe