For more information, check the ReadMe section below. The "last modified" timestamp is in Central European Time.
Name Last modified Size Description
![[PARENTDIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
AD.zip 2025-07-17 10:04 95K
AE.zip 2025-07-17 10:04 334K
AF.zip 2025-07-17 10:04 4.6M
AG.zip 2025-07-17 10:04 31K
AI.zip 2025-07-17 10:04 11K
AL.zip 2025-07-17 10:04 368K
AM.zip 2025-07-17 10:04 1.0M
AN.zip 2025-07-17 10:04 4.1K
AO.zip 2025-07-17 10:05 1.6M
AQ.zip 2025-07-17 10:05 558K
AR.zip 2025-07-17 10:05 1.7M
AS.zip 2025-07-17 10:05 34K
AT.zip 2025-07-17 10:05 1.5M
AU.zip 2025-07-17 10:05 5.4M
AW.zip 2025-07-17 10:05 18K
AX.zip 2025-07-17 10:05 91K
AZ.zip 2025-07-17 10:05 562K
BA.zip 2025-07-17 10:05 1.3M
BB.zip 2025-07-17 10:05 37K
BD.zip 2025-07-17 10:05 1.6M
BE.zip 2025-07-17 10:05 659K
BF.zip 2025-07-17 10:05 307K
BG.zip 2025-07-17 10:05 728K
BH.zip 2025-07-17 10:05 34K
BI.zip 2025-07-17 10:05 320K
BJ.zip 2025-07-17 10:05 161K
BL.zip 2025-07-17 10:05 11K
BM.zip 2025-07-17 10:05 24K
BN.zip 2025-07-17 10:05 28K
BO.zip 2025-07-17 10:05 1.0M
BQ.zip 2025-07-17 10:05 23K
BR.zip 2025-07-17 10:05 6.8M
BS.zip 2025-07-17 10:05 84K
BT.zip 2025-07-17 10:05 25K
BV.zip 2025-07-17 10:05 7.1K
BW.zip 2025-07-17 10:05 112K
BY.zip 2025-07-17 10:05 1.2M
BZ.zip 2025-07-17 10:05 75K
CA.zip 2025-07-17 10:05 7.7M
CC.zip 2025-07-17 10:05 8.4K
CD.zip 2025-07-17 10:05 1.5M
CF.zip 2025-07-17 10:05 354K
CG.zip 2025-07-17 10:05 251K
CH.zip 2025-07-17 10:05 2.6M
CI.zip 2025-07-17 10:05 528K
CK.zip 2025-07-17 10:05 27K
CL.zip 2025-07-17 10:05 1.3M
CM.zip 2025-07-17 10:05 557K
CN.zip 2025-07-17 10:06 30M
CO.zip 2025-07-17 10:06 2.1M
CR.zip 2025-07-17 10:06 565K
CS.zip 2025-07-17 10:06 5.1K
CU.zip 2025-07-17 10:06 1.0M
CV.zip 2025-07-17 10:06 172K
CW.zip 2025-07-17 10:06 18K
CX.zip 2025-07-17 10:06 8.8K
CY.zip 2025-07-17 10:06 284K
CZ.zip 2025-07-17 10:06 1.5M
DE.zip 2025-07-17 10:06 6.7M
DJ.zip 2025-07-17 10:06 167K
DK.zip 2025-07-17 10:06 456K
DM.zip 2025-07-17 10:06 23K
DO.zip 2025-07-17 10:06 1.0M
DZ.zip 2025-07-17 10:06 1.7M
EC.zip 2025-07-17 10:06 609K
EE.zip 2025-07-17 10:06 496K
EG.zip 2025-07-17 10:06 1.8M
EH.zip 2025-07-17 10:06 67K
ER.zip 2025-07-17 10:06 191K
ES.zip 2025-07-17 10:06 3.2M
ET.zip 2025-07-17 10:06 567K
FI.zip 2025-07-17 10:07 12M
FJ.zip 2025-07-17 10:07 446K
FK.zip 2025-07-17 10:07 39K
FM.zip 2025-07-17 10:07 102K
FO.zip 2025-07-17 10:07 68K
FR.zip 2025-07-17 10:07 6.9M
GA.zip 2025-07-17 10:07 166K
GB.zip 2025-07-17 10:07 3.5M
GD.zip 2025-07-17 10:07 30K
GE.zip 2025-07-17 10:07 387K
GF.zip 2025-07-17 10:07 115K
GG.zip 2025-07-17 10:07 27K
GH.zip 2025-07-17 10:07 586K
GI.zip 2025-07-17 10:07 15K
GL.zip 2025-07-17 10:07 219K
GM.zip 2025-07-17 10:07 64K
GN.zip 2025-07-17 10:07 252K
GP.zip 2025-07-17 10:07 112K
GQ.zip 2025-07-17 10:07 109K
GR.zip 2025-07-17 10:07 1.6M
GS.zip 2025-07-17 10:07 36K
GT.zip 2025-07-17 10:07 1.0M
GU.zip 2025-07-17 10:07 50K
GW.zip 2025-07-17 10:07 143K
GY.zip 2025-07-17 10:07 168K
HK.zip 2025-07-17 10:07 116K
HM.zip 2025-07-17 10:07 9.8K
HN.zip 2025-07-17 10:07 468K
HR.zip 2025-07-17 10:07 774K
HT.zip 2025-07-17 10:07 414K
HU.zip 2025-07-17 10:07 673K
ID.zip 2025-07-17 10:07 9.8M
IE.zip 2025-07-17 10:07 797K
IL.zip 2025-07-17 10:07 555K
IM.zip 2025-07-17 10:07 12K
IN.zip 2025-07-17 10:07 15M
IO.zip 2025-07-17 10:07 12K
IQ.zip 2025-07-17 10:07 2.7M
IR.zip 2025-07-17 10:08 13M
IS.zip 2025-07-17 10:08 456K
IT.zip 2025-07-17 10:08 4.1M
JE.zip 2025-07-17 10:08 19K
JM.zip 2025-07-17 10:08 230K
JO.zip 2025-07-17 10:08 674K
JP.zip 2025-07-17 10:08 4.7M
KE.zip 2025-07-17 10:08 826K
KG.zip 2025-07-17 10:08 332K
KH.zip 2025-07-17 10:08 754K
KI.zip 2025-07-17 10:08 39K
KM.zip 2025-07-17 10:08 37K
KN.zip 2025-07-17 10:08 23K
KP.zip 2025-07-17 10:08 1.7M
KR.zip 2025-07-17 10:08 5.1M
KW.zip 2025-07-17 10:08 55K
KY.zip 2025-07-17 10:08 17K
KZ.zip 2025-07-17 10:08 2.6M
LA.zip 2025-07-17 10:08 691K
LB.zip 2025-07-17 10:08 1.1M
LC.zip 2025-07-17 10:08 51K
LI.zip 2025-07-17 10:08 50K
LK.zip 2025-07-17 10:08 1.4M
LR.zip 2025-07-17 10:08 240K
LS.zip 2025-07-17 10:08 49K
LT.zip 2025-07-17 10:08 1.0M
LU.zip 2025-07-17 10:08 52K
LV.zip 2025-07-17 10:08 973K
LY.zip 2025-07-17 10:08 936K
MA.zip 2025-07-17 10:08 4.0M
MC.zip 2025-07-17 10:08 8.2K
MD.zip 2025-07-17 10:08 142K
ME.zip 2025-07-17 10:08 365K
MF.zip 2025-07-17 10:08 13K
MG.zip 2025-07-17 10:08 1.3M
MH.zip 2025-07-17 10:08 58K
MK.zip 2025-07-17 10:08 885K
ML.zip 2025-07-17 10:08 653K
MM.zip 2025-07-17 10:08 1.7M
MN.zip 2025-07-17 10:08 290K
MO.zip 2025-07-17 10:08 14K
MP.zip 2025-07-17 10:08 44K
MQ.zip 2025-07-17 10:08 94K
MR.zip 2025-07-17 10:08 452K
MS.zip 2025-07-17 10:08 14K
MT.zip 2025-07-17 10:08 95K
MU.zip 2025-07-17 10:08 58K
MV.zip 2025-07-17 10:08 64K
MW.zip 2025-07-17 10:08 333K
MX.zip 2025-07-17 10:08 13M
MY.zip 2025-07-17 10:08 1.7M
MZ.zip 2025-07-17 10:08 1.2M
NA.zip 2025-07-17 10:08 347K
NC.zip 2025-07-17 10:08 136K
NE.zip 2025-07-17 10:09 624K
NF.zip 2025-07-17 10:09 8.5K
NG.zip 2025-07-17 10:09 1.8M
NI.zip 2025-07-17 10:09 199K
NL.zip 2025-07-17 10:09 703K
NO.zip 2025-07-17 10:09 15M
NP.zip 2025-07-17 10:09 3.3M
NR.zip 2025-07-17 10:09 13K
NU.zip 2025-07-17 10:09 12K
NZ.zip 2025-07-17 10:09 1.4M
OM.zip 2025-07-17 10:09 569K
PA.zip 2025-07-17 10:09 887K
PE.zip 2025-07-17 10:09 2.9M
PF.zip 2025-07-17 10:09 124K
PG.zip 2025-07-17 10:09 595K
PH.zip 2025-07-17 10:09 2.4M
PK.zip 2025-07-17 10:09 5.9M
PL.zip 2025-07-17 10:09 1.9M
PM.zip 2025-07-17 10:09 20K
PN.zip 2025-07-17 10:09 7.4K
PR.zip 2025-07-17 10:09 263K
PS.zip 2025-07-17 10:09 297K
PT.zip 2025-07-17 10:09 1.1M
PW.zip 2025-07-17 10:09 44K
PY.zip 2025-07-17 10:09 531K
QA.zip 2025-07-17 10:09 183K
RE.zip 2025-07-17 10:09 66K
RO.zip 2025-07-17 10:09 1.7M
RS.zip 2025-07-17 10:09 738K
RU.zip 2025-07-17 10:10 14M
RW.zip 2025-07-17 10:10 465K
SA.zip 2025-07-17 10:10 1.2M
SB.zip 2025-07-17 10:10 244K
SC.zip 2025-07-17 10:10 30K
SD.zip 2025-07-17 10:10 777K
SE.zip 2025-07-17 10:10 2.5M
SG.zip 2025-07-17 10:10 66K
SH.zip 2025-07-17 10:10 23K
SI.zip 2025-07-17 10:10 373K
SJ.zip 2025-07-17 10:10 192K
SK.zip 2025-07-17 10:10 433K
SL.zip 2025-07-17 10:10 369K
SM.zip 2025-07-17 10:10 11K
SN.zip 2025-07-17 10:10 312K
SO.zip 2025-07-17 10:10 474K
SR.zip 2025-07-17 10:10 78K
SS.zip 2025-07-17 10:10 314K
ST.zip 2025-07-17 10:10 44K
SV.zip 2025-07-17 10:10 220K
SX.zip 2025-07-17 10:10 12K
SY.zip 2025-07-17 10:10 1.9M
SZ.zip 2025-07-17 10:10 55K
TC.zip 2025-07-17 10:10 24K
TD.zip 2025-07-17 10:10 587K
TF.zip 2025-07-17 10:10 59K
TG.zip 2025-07-17 10:10 131K
TH.zip 2025-07-17 10:10 9.3M
TJ.zip 2025-07-17 10:10 167K
TK.zip 2025-07-17 10:10 7.8K
TL.zip 2025-07-17 10:10 209K
TM.zip 2025-07-17 10:10 194K
TN.zip 2025-07-17 10:10 875K
TO.zip 2025-07-17 10:10 28K
TR.zip 2025-07-17 10:10 3.2M
TT.zip 2025-07-17 10:10 63K
TV.zip 2025-07-17 10:10 17K
TW.zip 2025-07-17 10:10 2.2M
TZ.zip 2025-07-17 10:10 514K
UA.zip 2025-07-17 10:10 2.0M
UG.zip 2025-07-17 10:10 713K
UM.zip 2025-07-17 10:10 19K
US.zip 2025-07-17 10:11 68M
UY.zip 2025-07-17 10:11 265K
UZ.zip 2025-07-17 10:11 353K
VA.zip 2025-07-17 10:11 12K
VC.zip 2025-07-17 10:11 29K
VE.zip 2025-07-17 10:11 1.7M
VG.zip 2025-07-17 10:11 28K
VI.zip 2025-07-17 10:11 70K
VN.zip 2025-07-17 10:11 1.8M
VU.zip 2025-07-17 10:11 132K
WF.zip 2025-07-17 10:11 23K
WS.zip 2025-07-17 10:11 36K
XK.zip 2025-07-17 10:11 215K
YE.zip 2025-07-17 10:11 3.5M
YT.zip 2025-07-17 10:11 24K
YU.zip 2025-07-17 10:11 3.8K
ZA.zip 2025-07-17 10:11 2.6M
ZM.zip 2025-07-17 10:11 646K
ZW.zip 2025-07-17 10:11 632K
![[TXT]](/icons/text.gif)
admin1CodesASCII.txt 2025-07-17 10:11 144K
admin2Codes.txt 2025-07-17 10:11 2.3M
adminCode5.zip 2025-07-17 10:11 350K
allCountries.zip 2025-07-17 10:11 392M
alternateNames.zip 2025-07-17 10:13 186M
alternateNamesDelete..> 2025-07-17 10:16 303
alternateNamesModifi..> 2025-07-17 10:16 342K
alternateNamesV2.zip 2025-07-17 10:16 187M
![[DIR]](/icons/folder.gif)
alternatenames/ 2025-07-17 10:16 -
cities1000.zip 2025-07-17 10:11 9.3M
cities15000.zip 2025-07-17 10:11 2.8M
cities500.zip 2025-07-17 10:11 12M
cities5000.zip 2025-07-17 10:11 4.7M
countryInfo.txt 2025-07-17 10:16 31K
deletes-2025-07-16.txt 2025-07-17 10:16 108
featureCodes_bg.txt 2025-07-17 10:03 66K
featureCodes_en.txt 2025-07-17 10:03 57K
featureCodes_nb.txt 2025-07-17 10:03 57K
featureCodes_nn.txt 2025-07-17 10:03 57K
featureCodes_no.txt 2025-07-17 10:03 57K
featureCodes_ru.txt 2025-07-17 10:03 113K
featureCodes_sv.txt 2025-07-17 10:03 58K
hierarchy.zip 2025-07-17 10:16 2.0M
iso-languagecodes.txt 2025-07-17 10:03 135K
modifications-2025-0..> 2025-07-17 10:11 1.5M
no-country.zip 2025-07-17 10:11 253K
readme.txt 2025-07-17 10:03 8.6K
shapes_all_low.zip 2025-07-17 10:16 1.3M
shapes_simplified_lo..> 2025-07-17 10:16 1.2M
timeZones.txt 2025-07-17 10:16 14K
userTags.zip 2025-07-17 10:16 184K
Readme for GeoNames Gazetteer extract files
============================================================================================================
This work is licensed under a Creative Commons Attribution 4.0 License,
see https://creativecommons.org/licenses/by/4.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. 'no-country' for features not belonging to a country.
allCountries.zip : all countries combined in one file, see 'geoname' table for columns
cities500.zip : all cities with a population > 500 or seats of adm div down to PPLA4 (ca 185.000), see 'geoname' table for columns
cities1000.zip : all cities with a population > 1000 or seats of adm div down to PPLA3 (ca 130.000), see 'geoname' table for columns
cities5000.zip : all cities with a population > 5000 or PPLA (ca 50.000), see 'geoname' table for columns
cities15000.zip : all cities with a population > 15000 or capitals (ca 25.000), see 'geoname' table for columns
alternateNamesV2.zip : alternate names with language codes and geonameId, file with iso language codes, with new columns from and to
alternateNames.zip : obsolete use V2, this file does not have the new columns to and from and will be removed in the future
admin1CodesASCII.txt : names in English for admin divisions. Columns: code, name, name ascii, geonameid
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://api.geonames.org/countryInfo?
country names in different languages : http:/api.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.
adminCode5.zip : the new adm5 column is not yet exported in the other files (in order to not break import scripts). Instead it is availabe as separate file.
columns: geonameId,adm5code
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, ascii names automatically transliterated, convenience attribute from alternatename table, varchar(10000)
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, 200 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 iana 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 code '00' stands for general features where no specific adm1 code is defined.
The corresponding admin feature is found with the same countrycode and adminX codes and the respective feature code ADMx.
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, optionally followed by a hyphen and a countrycode for country specific variants (ex:zh-CN) or by a variant name (ex: zh-Hant); 4-characters 'post' for postal codes and 'iata','icao' and faac for airport codes, fr_1793 for French Revolution names, abbr for abbreviation, link to a website (mostly to wikipedia), wkdt for the wikidataid, varchar(7)
alternate name : alternate name or name variant, varchar(400)
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. Example: 'Big Apple' for 'New York'.
isHistoric : '1', if this alternate name is historic and was used in the past. Example 'Bombay' for 'Mumbai'.
from : from period when the name was used
to : to period when the name was used
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.
Boundaries:
Simplified country boundaries are available in two slightly different formats:
shapes_simplified_low:
geonameId: The geonameId of the feature
geoJson: The boundary in geoJson format
shapes_simplified_low.json:
similar to the abovementioned file, but fully in geojson format. The geonameId is a feature property in the geojson string.
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
feature classes:
A: country, state, region,...
H: stream, lake, ...
L: parks,area, ...
P: city, village,...
R: road, railroad
S: spot, building, farm
T: mountain,hill,rock,...
U: undersea
V: forest,heath,...
If you find errors or miss important places, please do use the wiki-style edit interface on our website
https://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:
https://www.geonames.org/datasources/
More Information is also available in the geonames faq :
https://forum.geonames.org/gforum/forums/show/6.page
The forum : https://forum.geonames.org
or the google group : https://groups.google.com/group/geonames