IP2Location™ Country Information
IP2Location™ Country Information contains data of commonly used currency, commonly used language, population, capital, total area information and country-code top-level domain for each country. This information is available for download in a CSV text file (comma delimited).
The basic information download contains data such as country code, capital and total area. Please register for the more detailed information download.
Please take note that the database will randomly select a currency or language value if the country has more than one commonly used language or currency.
| Last Update | 31 May, 2024 |
|---|---|
| Database Format | CSV Text File (Comma Delimited) |
| Name | Type | Description |
|---|---|---|
| country_code | CHAR(2) | Two-character country code based on ISO 3166. |
| country_name | VARCHAR(200) | Country name based on ISO 3166. |
| country_name_d | VARCHAR(200) | Country name in diacritic. |
| country_alpha3_code | CHAR(3) | Three-character country code based on ISO 3166. |
| country_numeric_code | CHAR(3) | Three-character country numeric code based on ISO 3166. |
| capital | VARCHAR(50) | Capital of the country. |
| country_demonym | VARCHAR(100) | Demonym of the country. |
| total_area | DOUBLE | Total area in km2. |
| population | INT(10) UNSIGNED | Population of year 2023. |
| idd_code | VARCHAR(5) | The IDD prefix to call the city from another country |
| currency_code | CHAR(3) | Currency code based on ISO 4217. |
| currency_name | VARCHAR(50) | Currency name. |
| currency_symbol | VARCHAR(10) | Currency symbol. |
| lang_code | CHAR(2) | Language code based on ISO 639. |
| lang_name | VARCHAR(50) | Language name. |
| cctld | CHAR(2) | Country-Code Top-Level Domain. |
Sample Database
"country_code","country_name","country_name_d","country_alpha3_code","country_numeric_code","capital","country_demonym","total_area","population","idd_code","currency_code","currency_name","currency_symbol","lang_code","lang_name","cctld"
"AD","Andorra","Andorra","AND","20","Andorra la Vella","Andorrans","468","85468","376","EUR","Euro","€","CA","Catalana","ad"
"AE","United Arab Emirates","United Arab Emirates","ARE","784","Abu Dhabi","Emirians","83600","9973449","971","AED","United Arab Emirates Dirham","د.إ","AR","Arabic","ae"
"AF","Afghanistan","Afghanistan","AFG","4","Kabul","Afghans","652230","39232003","93","AFN","Afghan Afghani","؋","FA","Persian","af"
"AG","Antigua and Barbuda","Antigua and Barbuda","ATG","28","Saint John's","Antiguans or Barbudans","442","101489","1268","XCD","East Caribbean Dollar","$","EN","English","ag"
"AI","Anguilla","Anguilla","AIA","660","The Valley","Anguillans","91","19079","1264","XCD","East Caribbean Dollar","$","EN","English","ai"MySQL Statement
CREATE TABLE `ip2location_country_information`(
`country_code` CHAR(2),
`country_name` VARCHAR(200),
`country_name_d` VARCHAR(200),
`country_alpha3_code` CHAR(3),
`country_numeric_code` CHAR(3),
`capital` VARCHAR(50),
`country_demonym` VARCHAR(100),
`total_area` DOUBLE,
`population` INT(10) UNSIGNED,
`idd_code` VARCHAR(5),
`currency_code` CHAR(3),
`currency_name` VARCHAR(50),
`currency_symbol` VARCHAR(10),
`lang_code` CHAR(2),
`lang_name` VARCHAR(50),
`cctld` CHAR(2),
INDEX `idx_country_code` (`country_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
LOAD DATA LOCAL
INFILE 'IP2LOCATION-COUNTRY-INFORMATION.CSV' INTO TABLE `ip2location_country_information`
CHARACTER SET latin1
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;This works is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0).
It is free for personal or commercial use with attribution required by mentioning the use of this works as follows:
"This site or product includes IP2Location™ Country Information Database which available from https://www.ip2location.com."
