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