IP2Location™ Region Multilingual Database
IP2Location™ Region Multilingual Database contains the translation of world region names, such as English, Spanish, Italian, Portuguese, Chinese and so on. 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.
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 |
Last Update | 06 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 |
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","AD-07","Andorra la Vella","EN","ENGLISH","Andorra la Vella"
"AD","020","Andorra","AD-02","Canillo","EN","ENGLISH","Canillo"
"AD","020","Andorra","AD-03","Encamp","EN","ENGLISH","Encamp"
"AD","020","Andorra","AD-08","Escaldes-Engordany","EN","ENGLISH","Escaldes-Engordany"
"AD","020","Andorra","AD-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;
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 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 |