IP2Location™ Country Information

More Information
Registration required
Basic

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 CSV text file (comma delimited).

The basic information download contains the data of country code, capital and total area. Please register for the details 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.

 

Product Features
Last Update 01/16/2015
Database Format CSV Text File (Comma Delimited)

 

Database Fields
Name Type Description
country_code CHAR(2) Two-character country code based on ISO 3166.
capital VARCHAR(50) Capital of the country.
total_area DOUBLE Total area in km2.
population INT(10) UNSIGNED Population of year 2014.
currency_code CHAR(3) Currency code based on ISO 4217.
currency_name VARCHAR(50) Currency name.
lang_code CHAR(2) Language code based on ISO 639.
lang_name VARCHAR(50) Language name.
cctld CHAR(2) Country-Code Top-Level Domain.

 

MySQL Statement

For the BASIC data, please only define the country_code, capital and total_area from the below MySQL statement
CREATE TABLE `ip2location_country_information`(
	`country_code` CHAR(2),
	`capital` VARCHAR(50),
	`total_area` DOUBLE,
	`population` INT(10) UNSIGNED,
	`currency_code` CHAR(3),
	`currency_name` VARCHAR(50),
	`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`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

 

License Information

IP2Location™ is a registered trademark of HEXASOFT. All other trademarks are the property of their respective owners.

 

Thank you for downloading

Sharing this great stuff to your friends!

Or share it on your blog or web page:

Free IP2Location geolocation resources available at <a href="http://www.ip2location.com">http://www.ip2location.com</a>
Copy & paste this text as HTML.