Readme for Geonames.org :

This work is licensed under a Creative Commons Attribution 2.5 License, see http://creativecommons.org/licenses/by/2.5/


The file allCountries.zip contains all countries combined in one file.

Statistics on the number of features per country and the feature class and code distributions : http://www.geonames.org/statistics/ 
The data format is tab-delimited text in utf8 encoding, with the following fields :


geonameid         : integer id of record in geonames database
name              : name of geographical point (utf8) varchar(200)
ansiname          : name of geographical point in ansi characters varchar(200)
alternatenames    : alternatenames, comma seperated varchar(4000)
latitude          : latitude in decimal degrees (wgs84)
longitude         : longitude in decimal degrees (wgs84)
feature class     : see http://www.geonames.org/export/codes.html, char(1)
feature code      : see http://www.geonames.org/export/codes.html, varchar(10)
country code      : ISO-3166 2-letter country code, 2 characters
cc2               : alternate country codes, comma separated, ISO-3166 2-letter country code, 60 characters
admin1  code      : fipscode (subject to change to iso code), isocode for the us, varchar(20)
population        : integer 
elevation         : in meters, integer
gtopo30           : average elevation of 30' area in meters, integer
modification date : date of last modification