Estonia cities list with latitude and longitude in CSV format

Estonia
Estonia
CSV, SQL, XML, JSON

Last update : 11 December 2023.

Country
Estonia
Capitale
Tallinn
Number of cities
6817
Download
Click here

This is the best list of 6817 cities in the Estonia available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the Estonia file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
8620620TaraskiTaraski,ТараскиEEPõlvamaaKanepi vald58.1677826.818060Europe/Tallinnpopulated place
793237LehtmetsaLehtmetsaEEHarjumaaAnija vald59.3225.35694789Europe/Tallinnpopulated place
590812LäilasteLailaste,Lyailaste,LäilasteEEPärnumaaPärnu linn58.4523.983330Europe/Tallinnpopulated place
8619774SitasillaSikka,SitasillaEEVõrumaaRõuge vald57.7522227.117220Europe/Tallinnpopulated place
793954SojamaaEETartuTartu vald58.482526.63417119Europe/Tallinnpopulated place
588764SaunamäeSaunamae,Saunamyae,SaunamäeEEJärvamaaTüri vald58.90525.413610Europe/Tallinnpopulated place
794566MähaEEValgamaaOtepää vald58.0536126.394440Europe/Tallinnpopulated place
589110RasivereRasivereEEHarjumaaAnija vald59.222525.373330Europe/Tallinnpopulated place
590258MetsakülaMetsakula,Metsakyula,MetsakülaEEViljandimaaMulgi vald58.2027825.296670Europe/Tallinnpopulated place
11550999ÜlejõeUksnurme,Ulejoe,ÜlejõeEEHarjumaaSaue vald59.3063924.441390Europe/Tallinnpopulated place
590436MäävliMaavli,Myavli,MäävliEEHiiumaaHiiumaa vald58.9355622.717220Europe/Tallinnpopulated place
8618983SaeEELääne-VirumaaVinni vald59.2694426.631940Europe/Tallinnpopulated place
793972KikivereEETartuTartu vald58.4794426.8150Europe/Tallinnpopulated place
8620176JuusaEEVõrumaaVõru vald57.847527.360280Europe/Tallinnpopulated place
590534LoobuLoebu,Loobu,ЛоебуEELääne-VirumaaKadrina vald59.4488925.923330Europe/Tallinnpopulated place
587918Väike-PuskuPusku,Vaike-Pusku,Väike-PuskuEELääneHaapsalu linn58.9036123.470Europe/Tallinnpopulated place
8619782KangavitsaKangavitsa,KankavitsaEEVõrumaaSetomaa vald57.77527.409170Europe/Tallinnpopulated place
8620672KusõkurmEEPõlvamaaPõlva vald58.0755627.2050Europe/Tallinnpopulated place
793991KaimiKaimiEETartuElva vald58.3405626.381390Europe/Tallinnpopulated place
590879KuusikuKuusiku,Kuusiku Metsavaht,Myza KuzikuEERaplamaaRapla vald58.9755624.71861210Europe/Tallinnpopulated place
589888ÕesteOeste,Yeste,ÕesteEESaareSaaremaa vald58.5416722.737220Europe/Tallinnpopulated place
794022SassiSassiEETartuNõo vald58.172526.451110Europe/Tallinnpopulated place
794607VilimeesteEEViljandimaaViljandi vald58.2433325.759170Europe/Tallinnpopulated place
8618174IskaIska,ViskaEEPärnumaaLääneranna vald58.5758324.201670Europe/Tallinnpopulated place
793310VäljataguseEEJärvamaaTüri vald58.9055625.454720Europe/Tallinnpopulated place
8620383ArukülaArukula,Aruküla,RaudnaEEViljandimaaPõhja-Sakala vald58.3952825.43750Europe/Tallinnpopulated place
8619703KossaKossa,Kosso,KossõEEVõrumaaSetomaa vald57.6155627.372220Europe/Tallinnpopulated place
588131Tuudi-JõeääreTuudi-Joeaare,Tuudi-Joeaarse,Tuudi-Jõeääre,Tuudi-JõeäärseEEPärnumaaLääneranna vald58.6861123.779440Europe/Tallinnpopulated place
588573SõrumäeSorumae,Sorumyae,SõrumäeEEIda-VirumaaAlutaguse vald59.1655627.356110Europe/Tallinnpopulated place
8618524TelliseTellise,Vaago-Taalamaa,Väägo-TäälamaaEEJõgevamaaMustvee vald58.8447226.901110Europe/Tallinnpopulated place
590210MihkliGanso-Mikhel’,Ganso-Mikhel’,Mihkli,Mikhayelis,Mikhkli,Sankt-MihaelisEEPärnumaaLääneranna vald58.6077824.116110Europe/Tallinnpopulated place
588880SaarekulaEEVõrumaaSetomaa vald57.9833327.683330Europe/Tallinnpopulated place
591240KoiklaKoikla,Koikla Asundus,Koykla,Myza KayklaEESaareSaaremaa vald58.47522.782780Europe/Tallinnpopulated place
588426TagukülaTagakula,Tagakyula,Tagaküla,Tagukula,TagukülaEEHiiumaaHiiumaa vald58.7947222.861110Europe/Tallinnpopulated place
8620760NahakülaEEPõlvamaaPõlva vald58.1566727.090560Europe/Tallinnpopulated place
592221HaapsipeaHaapsipeaEETartuPeipsiääre vald58.6402827.141670Europe/Tallinnpopulated place
591334KissaKissa,KiysaEELääne-VirumaaVinni vald59.0694426.447220Europe/Tallinnpopulated place
592212HaeskaHaeska,Haeska Asundus,Myza KhaeskaEELääneHaapsalu linn58.7833323.666670Europe/Tallinnpopulated place
793372TõikvereEEJõgevamaaJõgeva vald58.8005626.66111129Europe/Tallinnpopulated place
588786Põgari-SassiPogari-Sassi,Põgari-Sassi,SassiEELääneHaapsalu linn58.8041723.541670Europe/Tallinnpopulated place
591587KärksiKarksi,Karksi Asundus,Kyarksi,Kärksi,Kärksi AsundusEEJõgevamaaJõgeva vald58.5955626.595830Europe/Tallinnpopulated place
794696VeereVeereEESaare58.4555622.053060Europe/Tallinnpopulated place
592022IrtaIrta,ИртаEEPärnumaaLääneranna vald58.5566724.12750Europe/Tallinnpopulated place
590496LuguseLuguseEEHiiumaaHiiumaa vald58.8018422.720460Europe/Tallinnpopulated place
8620442IhasteGer’janurmu,Ihaste,ГерьянурмъEETartuElva vald58.2794426.399440Europe/Tallinnpopulated place
588461TääksiTaaksi,Tyavksi,TääksiEEViljandimaaPõhja-Sakala vald58.5147225.62556122Europe/Tallinnpopulated place
590816LaikmaLaikma,Laikmaa,LaylimaEERaplamaaRapla vald58.9422224.658610Europe/Tallinnpopulated place
587484VõllaVolla,Volla Asundus,Vylla,Võlla,Võlla AsundusEESaareMuhu vald58.5963923.361670Europe/Tallinnpopulated place
8619422HiieväljaHievalja,Hievälja,Hiievalja,HiieväljaEESaareSaaremaa vald58.5591722.751110Europe/Tallinnpopulated place
8620696KelmiküläKelmikula,Kelmiküla,KelmiküläEEPõlvamaaPõlva vald58.1322226.926390Europe/Tallinnpopulated place
591552KarusteKarusteEESaareSaaremaa vald57.9333322.016670Europe/Tallinnpopulated place
589659PaliEEViljandimaaMulgi vald58.182525.6650Europe/Tallinnpopulated place
8620124TiirhannaEEVõrumaaSetomaa vald57.7794427.50250Europe/Tallinnpopulated place
588657SirvasteSirvasteEEPõlvamaaKanepi vald58.0391726.710280Europe/Tallinnpopulated place
588701SigapusmaEEJärvamaaJärva vald58.8525.866670Europe/Tallinnpopulated place
591578KärplaKarpla,Kyarpla,KärplaEERaplamaaKehtna vald58.8866724.863060Europe/Tallinnpopulated place
589903NutuNutuEEHarjumaaKose vald59.0691725.213060Europe/Tallinnpopulated place
588226ToosiToosi,TosiEEViljandimaaMulgi vald58.1727825.488610Europe/Tallinnpopulated place
794115KokeKokeEETartuKastre vald58.3219426.884440Europe/Tallinnpopulated place
588310TeilmaTeilma,Teyl’ma,Teyl’maEEJõgevamaaJõgeva vald58.7483326.618330Europe/Tallinnpopulated place
795106VõrungiVorungi,VõrungiEEPärnumaaLääneranna vald58.5727824.258330Europe/Tallinnpopulated place
588097ÜlejõeUlejoe,Yuleyye,ÜlejõeEEHarjumaaAnija vald59.3413925.36972240Europe/Tallinnpopulated place
794303VõlsiEEVõrumaaVõru vald57.8277826.9850Europe/Tallinnpopulated place
591304KloogarannaKloga-Rand,Klooga-Rand,Klooga-Ranna,Kloogaranna,КлоогараннаEEHarjumaaLääne-Harju vald59.3480624.25444105Europe/Tallinnpopulated place
589043RidakülaRidakula,Ridakyula,RidakülaEEViljandimaaViljandi vald58.3733325.932780Europe/Tallinnpopulated place
588679SilmsiMyza Sil’msi,Myza Sil’msi,Silmsi,Silmsi AsundusEEJärvamaaJärva vald58.8736125.860830Europe/Tallinnpopulated place
589838OllamäeOllamae,Ollamyae,OllamäeEESaareSaaremaa vald58.4563923.001390Europe/Tallinnpopulated place
591388KikeperaKikepera,KikepereEEPärnumaaSaarde vald58.2547224.868890Europe/Tallinnpopulated place
590648LiimalaLiimala,Lijmala,Liymala,ЛиймалаEEIda-VirumaaLüganuse vald59.4316726.978330Europe/Tallinnpopulated place
8620838LabassaarõLabassaare,Labassaaro,LabassaarõEEPõlvamaaPõlva vald58.0872227.261670Europe/Tallinnpopulated place
591951JärvekülaJarvekula,Järveküla,YarvekyulyaEEHarjumaaRae vald59.3795924.8083190Europe/Tallinnpopulated place
591288KodesmaaEEPärnumaaPõhja-Pärnumaa vald58.6319824.500280Europe/Tallinnpopulated place
591005KülasemaKulasema,Kulasemaa,Kyulasema,Külasema,KülasemaaEESaareMuhu vald58.6344423.190830Europe/Tallinnpopulated place
591966JärvajõeJarvajoe,Jarvajogi Asundus,Järvajôgi Asundus,Järvajõe,Myza Yarvayye,Myza YervavggiEELääne-VirumaaTapa vald59.2041726.140Europe/Tallinnpopulated place
590233MetsapereMetsapereEEHiiumaaHiiumaa vald58.7979522.486590Europe/Tallinnpopulated place
589647PalukülaPalu,Palukula,PalukülaEEViljandimaaViljandi vald58.2461125.757780Europe/Tallinnpopulated place
589777OtsaOtsaEEVõrumaaRõuge vald57.7833326.883330Europe/Tallinnpopulated place
794877KoelaKoelaEELääneLääne-Nigula vald58.9823.7550Europe/Tallinnpopulated place
588678SilmsiSilmsiEEHarjumaaKose vald59.1141725.308610Europe/Tallinnpopulated place
590248MetsakülaMetsakjula,Metsakula,Metsakyula,Metsaküla,МетсакюлаEEJõgevamaaJõgeva vald58.9161126.635126Europe/Tallinnpopulated place
8618256SuuresadamaSuuresadama,SuursadamaEEHiiumaaHiiumaa vald58.9748322.907770Europe/Tallinnpopulated place
794244PlessiPlessiEEVõrumaaVõru vald57.742527.364170Europe/Tallinnpopulated place
588902SäälaSaala,Syala,SäälaEERaplamaaMärjamaa vald58.7286124.343060Europe/Tallinnpopulated place
589456PikeverePikevereEELääne-VirumaaVäike-Maarja vald59.0511126.085110Europe/Tallinnpopulated place
8620539RussakuRussako,Russaku,РуссакоEEPõlvamaaKanepi vald58.1497226.776110Europe/Tallinnpopulated place
588249TõllusteMyza Tylluste,Tolluste,TõllusteEESaareSaaremaa vald58.3091722.810830Europe/Tallinnpopulated place
588105UhtnaMyza Ukhtna,Uhtna,Uhtna Asundus,Ukhtna,УхтнаEELääne-VirumaaRakvere vald59.3916726.56222355Europe/Tallinnpopulated place
588558SulaojaSulaoja,SulaoyaEEPõlvamaaKanepi vald58.1030626.721390Europe/Tallinnpopulated place
590689LemmikkülaLemmikkula,Lemmikküla,Lemmikula,Lemmikyula,LemmikülaEELääneLääne-Nigula vald58.83524.052780Europe/Tallinnpopulated place
8619216AiandiAiandi,Tammiku-HaberistiEEIda-VirumaaJõhvi vald59.377527.371390Europe/Tallinnpopulated place
587905VaiknaVaikna,VayknaEERaplamaaMärjamaa vald58.9269424.119440Europe/Tallinnpopulated place
794140KõnnuEETartuKastre vald58.27527.209440Europe/Tallinnpopulated place
589132RannakülaRannakula,RannakülaEEHiiumaaHiiumaa vald58.6888922.571390Europe/Tallinnpopulated place
794277SuuremetsaSuuremetsaEEVõrumaaVõru vald57.8561127.341390Europe/Tallinnpopulated place
592593AhjaAhja,Akh’ja,Akh’ya,Akh’ya,АхьяEEPõlvamaaPõlva vald58.2038927.07333616Europe/Tallinnpopulated place
587707VastupääVastupaa,Vastupya,VastupääEEPärnumaaLääneranna vald58.6663924.105830Europe/Tallinnpopulated place
589107RässaRassa,Ryassa,RässaEESaareMuhu vald58.5572223.346390Europe/Tallinnpopulated place
8619746PihlakuPihlaku,VanalaaneEEVõrumaaRõuge vald57.7380626.732220Europe/Tallinnpopulated place
589692Paju-KurdlaPaju-Kurdla,Payu-KurdlaEESaareSaaremaa vald58.4336123.018610Europe/Tallinnpopulated place
588349TapaEELääne-VirumaaTapa vald59.2247225.918890Europe/Tallinnpopulated place

FaQ about Estonia

Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.