For more information, check the ReadMe section below. The "last modified" timestamp is in Central European Time.
Name Last modified Size Description
![[DIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
AD.zip 12-Dec-2013 06:33 63K
AE.zip 12-Dec-2013 06:33 198K
AF.zip 12-Dec-2013 06:33 4.4M
AG.zip 12-Dec-2013 06:33 17K
AI.zip 12-Dec-2013 06:33 7.3K
AL.zip 12-Dec-2013 06:33 274K
AM.zip 12-Dec-2013 06:33 77K
AO.zip 12-Dec-2013 06:33 1.1M
AQ.zip 12-Dec-2013 06:33 504K
AR.zip 12-Dec-2013 06:33 1.2M
AS.zip 12-Dec-2013 06:33 29K
AT.zip 12-Dec-2013 06:33 1.1M
AU.zip 12-Dec-2013 06:33 2.8M
AW.zip 12-Dec-2013 06:33 9.6K
AX.zip 12-Dec-2013 06:33 68K
AZ.zip 12-Dec-2013 06:33 295K
BA.zip 12-Dec-2013 06:33 1.2M
BB.zip 12-Dec-2013 06:33 19K
BD.zip 12-Dec-2013 06:33 1.2M
BE.zip 12-Dec-2013 06:33 524K
BF.zip 12-Dec-2013 06:33 247K
BG.zip 12-Dec-2013 06:33 451K
BH.zip 12-Dec-2013 06:33 22K
BI.zip 12-Dec-2013 06:33 229K
BJ.zip 12-Dec-2013 06:34 129K
BL.zip 12-Dec-2013 06:34 6.9K
BM.zip 12-Dec-2013 06:34 19K
BN.zip 12-Dec-2013 06:34 21K
BO.zip 12-Dec-2013 06:34 637K
BQ.zip 12-Dec-2013 06:34 12K
BR.zip 12-Dec-2013 06:34 2.8M
BS.zip 12-Dec-2013 06:34 52K
BT.zip 12-Dec-2013 06:34 15K
BV.zip 12-Dec-2013 06:34 5.6K
BW.zip 12-Dec-2013 06:34 94K
BY.zip 12-Dec-2013 06:34 1.0M
BZ.zip 12-Dec-2013 06:34 50K
CA.zip 12-Dec-2013 06:34 7.1M
CC.zip 12-Dec-2013 06:34 6.1K
CD.zip 12-Dec-2013 06:34 1.2M
CF.zip 12-Dec-2013 06:34 319K
CG.zip 12-Dec-2013 06:34 239K
CH.zip 12-Dec-2013 06:34 693K
CI.zip 12-Dec-2013 06:34 444K
CK.zip 12-Dec-2013 06:34 18K
CL.zip 12-Dec-2013 06:34 1.0M
CM.zip 12-Dec-2013 06:35 436K
CN.zip 12-Dec-2013 06:35 10M
CO.zip 12-Dec-2013 06:35 1.7M
CR.zip 12-Dec-2013 06:35 114K
CU.zip 12-Dec-2013 06:35 795K
CV.zip 12-Dec-2013 06:35 25K
CW.zip 12-Dec-2013 06:35 13K
CX.zip 12-Dec-2013 06:35 6.0K
CY.zip 12-Dec-2013 06:35 140K
CZ.zip 12-Dec-2013 06:35 604K
DE.zip 12-Dec-2013 06:35 4.7M
DJ.zip 12-Dec-2013 06:35 154K
DK.zip 12-Dec-2013 06:35 396K
DM.zip 12-Dec-2013 06:35 13K
DO.zip 12-Dec-2013 06:35 551K
DZ.zip 12-Dec-2013 06:36 1.4M
EC.zip 12-Dec-2013 06:36 341K
EE.zip 12-Dec-2013 06:36 303K
EG.zip 12-Dec-2013 06:36 1.2M
EH.zip 12-Dec-2013 06:36 64K
ER.zip 12-Dec-2013 06:36 175K
ES.zip 12-Dec-2013 06:36 1.9M
ET.zip 12-Dec-2013 06:36 526K
FI.zip 12-Dec-2013 06:36 949K
FJ.zip 12-Dec-2013 06:36 212K
FK.zip 12-Dec-2013 06:36 35K
FM.zip 12-Dec-2013 06:36 94K
FO.zip 12-Dec-2013 06:36 53K
FR.zip 12-Dec-2013 06:36 4.2M
GA.zip 12-Dec-2013 06:36 153K
GB.zip 12-Dec-2013 06:36 1.5M
GD.zip 12-Dec-2013 06:36 18K
GE.zip 12-Dec-2013 06:36 294K
GF.zip 12-Dec-2013 06:36 76K
GG.zip 12-Dec-2013 06:36 23K
GH.zip 12-Dec-2013 06:36 308K
GI.zip 12-Dec-2013 06:36 10K
GL.zip 12-Dec-2013 06:36 196K
GM.zip 12-Dec-2013 06:36 54K
GN.zip 12-Dec-2013 06:36 226K
GP.zip 12-Dec-2013 06:36 42K
GQ.zip 12-Dec-2013 06:36 103K
GR.zip 12-Dec-2013 06:36 940K
GS.zip 12-Dec-2013 06:36 19K
GT.zip 12-Dec-2013 06:36 306K
GU.zip 12-Dec-2013 06:36 46K
GW.zip 12-Dec-2013 06:36 139K
GY.zip 12-Dec-2013 06:36 143K
HK.zip 12-Dec-2013 06:36 55K
HM.zip 12-Dec-2013 06:36 7.0K
HN.zip 12-Dec-2013 06:36 394K
HR.zip 12-Dec-2013 06:36 561K
HT.zip 12-Dec-2013 06:36 317K
HU.zip 12-Dec-2013 06:36 604K
ID.zip 12-Dec-2013 06:37 7.8M
IE.zip 12-Dec-2013 06:37 545K
IL.zip 12-Dec-2013 06:37 320K
IM.zip 12-Dec-2013 06:37 7.4K
IN.zip 12-Dec-2013 06:37 1.4M
IO.zip 12-Dec-2013 06:37 9.1K
IQ.zip 12-Dec-2013 06:37 2.0M
IR.zip 12-Dec-2013 06:37 8.5M
IS.zip 12-Dec-2013 06:37 396K
IT.zip 12-Dec-2013 06:37 1.6M
JE.zip 12-Dec-2013 06:37 14K
JM.zip 12-Dec-2013 06:37 96K
JO.zip 12-Dec-2013 06:37 254K
JP.zip 12-Dec-2013 06:37 2.0M
KE.zip 12-Dec-2013 06:37 575K
KG.zip 12-Dec-2013 06:37 300K
KH.zip 12-Dec-2013 06:37 378K
KI.zip 12-Dec-2013 06:37 35K
KM.zip 12-Dec-2013 06:37 32K
KN.zip 12-Dec-2013 06:37 17K
KP.zip 12-Dec-2013 06:38 1.2M
KR.zip 12-Dec-2013 06:38 2.6M
KW.zip 12-Dec-2013 06:38 44K
KY.zip 12-Dec-2013 06:38 10K
KZ.zip 12-Dec-2013 06:38 663K
LA.zip 12-Dec-2013 06:38 508K
LB.zip 12-Dec-2013 06:38 837K
LC.zip 12-Dec-2013 06:38 18K
LI.zip 12-Dec-2013 06:38 8.0K
LK.zip 12-Dec-2013 06:38 1.0M
LR.zip 12-Dec-2013 06:38 176K
LS.zip 12-Dec-2013 06:38 34K
LT.zip 12-Dec-2013 06:38 267K
LU.zip 12-Dec-2013 06:38 36K
LV.zip 12-Dec-2013 06:38 254K
LY.zip 12-Dec-2013 06:38 819K
MA.zip 12-Dec-2013 06:38 1.2M
MC.zip 12-Dec-2013 06:38 5.4K
MD.zip 12-Dec-2013 06:38 97K
ME.zip 12-Dec-2013 06:38 343K
MF.zip 12-Dec-2013 06:38 9.4K
MG.zip 12-Dec-2013 06:38 588K
MH.zip 12-Dec-2013 06:38 55K
MK.zip 12-Dec-2013 06:38 317K
ML.zip 12-Dec-2013 06:38 595K
MM.zip 12-Dec-2013 06:38 1.1M
MN.zip 12-Dec-2013 06:38 273K
MO.zip 12-Dec-2013 06:38 9.3K
MP.zip 12-Dec-2013 06:38 37K
MQ.zip 12-Dec-2013 06:38 41K
MR.zip 12-Dec-2013 06:38 295K
MS.zip 12-Dec-2013 06:38 9.3K
MT.zip 12-Dec-2013 06:38 79K
MU.zip 12-Dec-2013 06:38 45K
MV.zip 12-Dec-2013 06:38 24K
MW.zip 12-Dec-2013 06:38 201K
MX.zip 12-Dec-2013 06:38 2.8M
MY.zip 12-Dec-2013 06:38 1.5M
MZ.zip 12-Dec-2013 06:38 1.1M
NA.zip 12-Dec-2013 06:38 170K
NC.zip 12-Dec-2013 06:38 105K
NE.zip 12-Dec-2013 06:38 605K
NF.zip 12-Dec-2013 06:38 5.4K
NG.zip 12-Dec-2013 06:38 1.1M
NI.zip 12-Dec-2013 06:38 167K
NL.zip 12-Dec-2013 06:38 585K
NO.zip 12-Dec-2013 06:38 1.8M
NP.zip 12-Dec-2013 06:38 2.4M
NR.zip 12-Dec-2013 06:38 7.5K
NU.zip 12-Dec-2013 06:38 4.9K
NZ.zip 12-Dec-2013 06:39 1.3M
OM.zip 12-Dec-2013 06:39 228K
PA.zip 12-Dec-2013 06:39 337K
PE.zip 12-Dec-2013 06:39 2.3M
PF.zip 12-Dec-2013 06:39 64K
PG.zip 12-Dec-2013 06:39 538K
PH.zip 12-Dec-2013 06:39 1.7M
PK.zip 12-Dec-2013 06:39 3.8M
PL.zip 12-Dec-2013 06:39 1.6M
PM.zip 12-Dec-2013 06:39 17K
PN.zip 12-Dec-2013 06:39 5.1K
PR.zip 12-Dec-2013 06:39 226K
PS.zip 12-Dec-2013 06:39 278K
PT.zip 12-Dec-2013 06:39 765K
PW.zip 12-Dec-2013 06:39 36K
PY.zip 12-Dec-2013 06:39 91K
QA.zip 12-Dec-2013 06:39 41K
RE.zip 12-Dec-2013 06:39 35K
RO.zip 12-Dec-2013 06:39 816K
RS.zip 12-Dec-2013 06:39 623K
RU.zip 12-Dec-2013 06:40 12M
RW.zip 12-Dec-2013 06:40 358K
SA.zip 12-Dec-2013 06:40 780K
SB.zip 12-Dec-2013 06:40 219K
SC.zip 12-Dec-2013 06:40 14K
SD.zip 12-Dec-2013 06:40 717K
SE.zip 12-Dec-2013 06:40 2.2M
SG.zip 12-Dec-2013 06:40 42K
SH.zip 12-Dec-2013 06:40 17K
SI.zip 12-Dec-2013 06:40 147K
SJ.zip 12-Dec-2013 06:40 186K
SK.zip 12-Dec-2013 06:40 232K
SL.zip 12-Dec-2013 06:40 155K
SM.zip 12-Dec-2013 06:40 5.0K
SN.zip 12-Dec-2013 06:40 292K
SO.zip 12-Dec-2013 06:40 459K
SR.zip 12-Dec-2013 06:40 59K
SS.zip 12-Dec-2013 06:40 285K
ST.zip 12-Dec-2013 06:40 18K
SV.zip 12-Dec-2013 06:40 161K
SX.zip 12-Dec-2013 06:40 8.1K
SY.zip 12-Dec-2013 06:40 1.2M
SZ.zip 12-Dec-2013 06:40 12K
TC.zip 12-Dec-2013 06:40 9.0K
TD.zip 12-Dec-2013 06:40 527K
TF.zip 12-Dec-2013 06:40 54K
TG.zip 12-Dec-2013 06:40 121K
TH.zip 12-Dec-2013 06:40 6.0M
TJ.zip 12-Dec-2013 06:40 150K
TK.zip 12-Dec-2013 06:40 6.9K
TL.zip 12-Dec-2013 06:40 166K
TM.zip 12-Dec-2013 06:40 131K
TN.zip 12-Dec-2013 06:40 605K
TO.zip 12-Dec-2013 06:40 21K
TR.zip 12-Dec-2013 06:40 2.0M
TT.zip 12-Dec-2013 06:40 46K
TV.zip 12-Dec-2013 06:40 14K
TW.zip 12-Dec-2013 06:40 1.7M
TZ.zip 12-Dec-2013 06:40 326K
UA.zip 12-Dec-2013 06:41 1.2M
UG.zip 12-Dec-2013 06:41 278K
UM.zip 12-Dec-2013 06:41 15K
US.zip 12-Dec-2013 06:43 57M
UY.zip 12-Dec-2013 06:43 143K
UZ.zip 12-Dec-2013 06:43 232K
VA.zip 12-Dec-2013 06:43 5.4K
VC.zip 12-Dec-2013 06:43 13K
VE.zip 12-Dec-2013 06:43 1.6M
VG.zip 12-Dec-2013 06:43 16K
VI.zip 12-Dec-2013 06:43 50K
VN.zip 12-Dec-2013 06:43 1.2M
VU.zip 12-Dec-2013 06:43 93K
WF.zip 12-Dec-2013 06:43 8.8K
WS.zip 12-Dec-2013 06:43 27K
XK.zip 12-Dec-2013 06:43 188K
YE.zip 12-Dec-2013 06:43 1.6M
YT.zip 12-Dec-2013 06:43 17K
ZA.zip 12-Dec-2013 06:43 2.4M
ZM.zip 12-Dec-2013 06:43 618K
ZW.zip 12-Dec-2013 06:43 601K
![[TXT]](/icons/text.gif)
admin1CodesASCII.txt 12-Dec-2013 06:43 136K
admin2Codes.txt 12-Dec-2013 06:43 1.8M
allCountries.zip 12-Dec-2013 06:43 234M
alternateNames.zip 12-Dec-2013 06:48 78M
alternateNamesDeletes-2013-12-11.txt 12-Dec-2013 06:48 101
alternateNamesModifications-2013-12-11.txt 12-Dec-2013 06:48 55K
cities1000.zip 12-Dec-2013 06:43 6.0M
cities15000.zip 12-Dec-2013 06:43 1.6M
cities5000.zip 12-Dec-2013 06:43 2.6M
countryInfo.txt 12-Dec-2013 06:23 31K
deletes-2013-12-11.txt 12-Dec-2013 06:48 0
featureCodes_bg.txt 12-Dec-2013 06:23 64K
featureCodes_en.txt 12-Dec-2013 06:23 56K
featureCodes_nb.txt 12-Dec-2013 06:23 56K
featureCodes_nn.txt 12-Dec-2013 06:23 56K
featureCodes_no.txt 12-Dec-2013 06:23 56K
featureCodes_ru.txt 12-Dec-2013 06:23 112K
featureCodes_sv.txt 12-Dec-2013 06:23 56K
hierarchy.zip 12-Dec-2013 06:50 1.1M
iso-languagecodes.txt 12-Dec-2013 06:23 124K
modifications-2013-12-11.txt 12-Dec-2013 06:43 226K
no-country.zip 12-Dec-2013 06:43 165K
readme.txt 12-Dec-2013 06:23 6.8K
timeZones.txt 12-Dec-2013 06:48 14K
userTags.zip 12-Dec-2013 06:48 164K
Readme for Geonames.org :
=========================
This work is licensed under a Creative Commons Attribution 3.0 License,
see http://creativecommons.org/licenses/by/3.0/
The Data is provided "as is" without warranty or any representation of accuracy, timeliness or completeness.
The data format is tab-delimited text in utf8 encoding.
Files :
-------
XX.zip : features for country with iso code XX, see 'geoname' table for columns
allCountries.zip : all countries combined in one file, see 'geoname' table for columns
cities1000.zip : all cities with a population > 1000 or seats of adm div (ca 80.000), see 'geoname' table for columns
cities5000.zip : all cities with a population > 5000 or PPLA (ca 40.000), see 'geoname' table for columns
cities15000.zip : all cities with a population > 15000 or capitals (ca 20.000), see 'geoname' table for columns
alternateNames.zip : two files, alternate names with language codes and geonameId, file with iso language codes
admin1CodesASCII.txt : ascii names of admin divisions. (beta > http://forum.geonames.org/gforum/posts/list/208.page#1143)
admin2Codes.txt : names for administrative subdivision 'admin2 code' (UTF8), Format : concatenated codes <tab>name <tab> asciiname <tab> geonameId
iso-languagecodes.txt : iso 639 language codes, as used for alternate names in file alternateNames.zip
featureCodes.txt : name and description for feature classes and feature codes
timeZones.txt : countryCode, timezoneId, gmt offset on 1st of January, dst offset to gmt on 1st of July (of the current year), rawOffset without DST
countryInfo.txt : country information : iso codes, fips codes, languages, capital ,...
see the geonames webservices for additional country information,
bounding box : http://ws.geonames.org/countryInfo?
country names in different languages : http://ws.geonames.org/countryInfoCSV?lang=it
modifications-<date>.txt : all records modified on the previous day, the date is in yyyy-MM-dd format. You can use this file to daily synchronize your own geonames database.
deletes-<date>.txt : all records deleted on the previous day, format : geonameId <tab> name <tab> comment.
alternateNamesModifications-<date>.txt : all alternate names modified on the previous day,
alternateNamesDeletes-<date>.txt : all alternate names deleted on the previous day, format : alternateNameId <tab> geonameId <tab> name <tab> comment.
userTags.zip : user tags , format : geonameId <tab> tag.
hierarchy.zip : parentId, childId, type. The type 'ADM' stands for the admin hierarchy modeled by the admin1-4 codes. The other entries are entered with the user interface. The relation toponym-adm hierarchy is not included in the file, it can instead be built from the admincodes of the toponym.
The main 'geoname' table has the following fields :
---------------------------------------------------
geonameid : integer id of record in geonames database
name : name of geographical point (utf8) varchar(200)
asciiname : name of geographical point in plain ascii characters, varchar(200)
alternatenames : alternatenames, comma separated varchar(5000)
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), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20)
admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
admin3 code : code for third level administrative division, varchar(20)
admin4 code : code for fourth level administrative division, varchar(20)
population : bigint (8 byte int)
elevation : in meters, integer
dem : digital elevation model, srtm3 or gtopo30, average elevation of 3''x3'' (ca 90mx90m) or 30''x30'' (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat.
timezone : the timezone id (see file timeZone.txt) varchar(40)
modification date : date of last modification in yyyy-MM-dd format
AdminCodes:
Most adm1 are FIPS codes. ISO codes are used for US, CH, BE and ME. UK and Greece are using an additional level between country and fips code.
The table 'alternate names' :
-----------------------------
alternateNameId : the id of this alternate name, int
geonameid : geonameId referring to id in table 'geoname', int
isolanguage : iso 639 language code 2- or 3-characters; 4-characters 'post' for postal codes and 'iata','icao' and faac for airport codes, fr_1793 for French Revolution names, abbr for abbreviation, link for a website, varchar(7)
alternate name : alternate name or name variant, varchar(200)
isPreferredName : '1', if this alternate name is an official/preferred name
isShortName : '1', if this is a short name like 'California' for 'State of California'
isColloquial : '1', if this alternate name is a colloquial or slang term
isHistoric : '1', if this alternate name is historic and was used in the past
Remark : the field 'alternatenames' in the table 'geoname' is a short version of the 'alternatenames' table without links and postal codes but with ascii transliterations. You probably don't need both.
If you don't need to know the language of a name variant, the field 'alternatenames' will be sufficient. If you need to know the language
of a name variant, then you will need to load the table 'alternatenames' and you can drop the column in the geoname table.
Statistics on the number of features per country and the feature class and code distributions : http://www.geonames.org/statistics/
Continent codes :
AF : Africa geonameId=6255146
AS : Asia geonameId=6255147
EU : Europe geonameId=6255148
NA : North America geonameId=6255149
OC : Oceania geonameId=6255151
SA : South America geonameId=6255150
AN : Antarctica geonameId=6255152
If you find errors or miss important places, please do use the wiki-style edit interface on our website
http://www.geonames.org to correct inaccuracies and to add new records.
Thanks in the name of the geonames community for your valuable contribution.
Data Sources:
http://www.geonames.org/data-sources.html
More Information is also available in the geonames faq :
http://forum.geonames.org/gforum/forums/show/6.page
The forum : http://forum.geonames.org
or the google group : http://groups.google.com/group/geonames