FREE

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.

Basic

Download
Free download

More Information

Download
Free with registration
Features
Last Update 06 December, 2023
Database Format CSV Text File (Comma Delimited)
Database Fields
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 2014.
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","76953","376","EUR","Euro","€","CA","Catalana","ad"
"AE","United Arab Emirates","United Arab Emirates","ARE","784","Abu Dhabi","Emirians","83600","9541615","971","AED","United Arab Emirates Dirham","د.إ","AR","Arabic","ae"
"AF","Afghanistan","Afghanistan","AFG","4","Kabul","Afghans","652230","36373176","93","AFN","Afghan Afghani","؋","FA","Persian","af"
"AG","Antigua and Barbuda","Antigua and Barbuda","ATG","28","Saint John's","Antiguans or Barbudans","442","103050","1268","XCD","East Caribbean Dollar","$","EN","English","ag"
"AI","Anguilla","Anguilla","AIA","660","The Valley","Anguillans","91","15045","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;
License Information

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."