World cities database with latitude and longitude
Last update : 11 October 2024.
Presentation of our World cities database of 4 510 988 towns around the world, accessible in four distinct formats: CSV, Json, SQL and XML. We have refined the Geoname database to show only metropolises, administrative centres and villages. All this data is carefully linked to geographical areas and sub-divisions, where available.
Each document provides information such as: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. For clarification on these elements, please consult our FAQ section below.
The World cities database contains data for every city in the world in separate files. Each archive contains data for a specific country. Here is an example of what can be found in a file:
Geoname_ID | City | Alternate_Name | Country_Code | Region | Sub_region | Latitude | Longitude | Elevation | Population | Timezone | Fcode_Name |
---|---|---|---|---|---|---|---|---|---|---|---|
1139546 | Jangal-e Mukhnōy | Jangal-e Mukhnoy,Jangal-e Mukhnuy,Jangal-e Mukhnōy,Jangal-e Mukhnūy,jngl mkhnwy,جنگل مخنوی | AF | Takhar | Warsaj | 36.18685 | 70.13691 | 0 | Asia/Kabul | populated place | |
7582712 | Āhangarān | Ahangaran,ahngran,Āhangarān,آهنگران | AF | Kabul | Surobi | 34.58367 | 69.73311 | 0 | Asia/Kabul | populated place | |
1423395 | Bāqī Khēl | Bakikheyl’,Bakikheyl’,Baqi Khel,Baqikheyl,Bāqī Khēl,Bāqīkheyl,baqy khyl,باقی خيل,باقی خېل | AF | Parwan | Jabal us Sarāj | 35.12791 | 69.26708 | 0 | Asia/Kabul | populated place | |
1138123 | Karīm Khēl | Karim Khel,Karim Kheyl,Karimkhel,Karimkheyl’,Karimkheyl’,Karīm Kheyl,Karīm Khēl,Kaṟīmkhēl,krym khyl,كريم خيل,کریم خېل | AF | Kapisa | Ḩişah-ye Awal-e Kōhistān | 35.10698 | 69.36288 | 0 | Asia/Kabul | populated place | |
1121453 | Wunchalāt | Ownchalat,Ownchalāt,Wuncalat,Wuncalāt,Wunchalat,Wunchalāt,awnchlat,wnchlat,اونچلات,ونچلات | AF | Faryab | Maīmanah | 35.89863 | 64.82508 | 0 | Asia/Kabul | populated place | |
1462103 | Yārdād | Yardad,Yārdād,yardad,یارداد | AF | Ghazni | Nāwur | 34.04597 | 67.33878 | 0 | Asia/Kabul | populated place | |
1143316 | Dilakchī | Delakchi,Delakchī,Delakci,Delakči,Dilakchi,Dilakchī,dlk chy,dlkchy,Дилакчи,دلكچی,دلک چی | AF | Ghazni | Jāghūrī | 33.03546 | 67.62692 | 0 | Asia/Kabul | populated place | |
1149523 | Āb-e Khānah | Ab-e Khanah,Abi Khana,Abi Khaneh,Abi Khāna,Abī Khāneh,ab khanh,Āb-e Khānah,آب خانه | AF | Balkh | Chahār Kent | 36.43414 | 67.14405 | 0 | Asia/Kabul | populated place | |
1457224 | Bōjī | Bodzhi,Boji,Buji,Bōji,Bōjī,Būjī,bwjy,بوجی | AF | Maidan Wardak Province | Nirkh | 34.32503 | 68.70457 | 0 | Asia/Kabul | populated place | |
1132641 | Mūrichāq | Mar-o-Chak,Maricaq,Maruchak,Marūchāk,Muricaq,Murichaq,Mār-o-Chāk,Māricāq,Mūrichāq,Mūrīchāq,Mūṟicāq,mwrchaq,mwrychaq,موريچاق,مورچاق | AF | Badghis | Murghāb | 35.8104 | 63.14265 | 0 | Asia/Kabul | populated place | |
1120922 | Zard Jōy | Zard Joy,Zard Jōy,Zarddzhoy,Zardjoy,Zardjuy,Zardjūy,Zaṟḏjōy,zrd jwy,زرد جوی | AF | Maidan Wardak Province | Markazi Bihsud | 34.17432 | 67.88157 | 0 | Asia/Kabul | populated place | |
1435689 | Wārêh | Vara,Wareh,Waṟeh,Wārêh,warh,واره | AF | Ghazni | Gēlān | 32.84448 | 67.58904 | 0 | Asia/Kabul | populated place | |
1142510 | Iraghlī | Eraghli,Eraghlī,Iraghli,Iraghlī,arghly,ارغلی | AF | Jowzjan | Shibirghān | 36.74967 | 65.86841 | 0 | Asia/Kabul | populated place | |
1121973 | Ūlastān | Owlastan,Owlastān,Ulastan,awlstan,Ūlastān,اولستان | AF | Farah | Pur Chaman | 33.35059 | 63.37863 | 0 | Asia/Kabul | populated place | |
1132075 | Nāw-e Tang | Naw-e Tang,Nawe Tang,Now-e Tang,Nāw-e Tang,naw tng,nw tng,ناو تنگ,نو تنگ | AF | Ghowr | Chahār Şadah | 35.19259 | 65.13404 | 0 | Asia/Kabul | populated place | |
1467949 | Khwāb Sārī | Khvab Sari,Khvāb Sāṟi,Khwab Sari,Khwāb Sārī,Khwāb Sāṟi,khwab sary,خواب ساری | AF | Badakhshan | Argō | 37.01038 | 70.31445 | 0 | Asia/Kabul | populated place | |
1146930 | Bārīkī | Barik,Barik-e,Bariki,Bārīk-e,Bārīkī,Bāṟik,Bāṟiki,baryky,باریکی | AF | Ghowr | La‘l wa Sar Jangal | 34.43229 | 66.05037 | 0 | Asia/Kabul | populated place | |
1468912 | Ḏāg Kêlay | Dag Kalay,Dag Kelay,Dagkalay,Dāg Kalay,Dāg Kêlay,قريۀ داگ,ډاگ کلی,Ḏāg Kêlay | AF | Nangarhar | Kāmah | 34.42902 | 70.55127 | 0 | Asia/Kabul | populated place | |
1462156 | Bālānah Takhak | Balana Takhak,Balanah Takhak,Balanatakhak,Balaneh Takhak,Bālāna Takhak,Bālānah Takhak,Bālāneh Takhak,balanh tkhk,بالانه تخک | AF | Bamyan | Waras̄ | 34.21885 | 67.02183 | 0 | Asia/Kabul | populated place | |
1138580 | Kalān Qōl | Kalan Qol,Kalanqol,Kalanqowl,Kalān Qōl,Kalānqowl,Kalānqōl,klan qwl,کلان قول | AF | Daykundi | Mīr Āmōr | 33.88806 | 66.81344 | 0 | Asia/Kabul | populated place |
To give you an idea of the content, here is a sample of the information included in the global file. You can retrieve a representative extract for a particular nation, in formats such as CSV, XML, JSON and SQL :
>> DOWNLOAD AN ARCHIVE CONTAINING A SAMPLE <<
World cities database: Your Ultimate World Country Database
Are you looking for a complete database of cities by country, with detailed information? Look no further than the World Pack! Find out why our country database is the best resource for all your geographical data needs.
Why choose the World cities database?
- Comprehensive: Our database covers every country in the world. From Afghanistan to Zimbabwe, we've got it all.
- Detailed data: Each city is associated with precise data from GeoNames. Take advantage of information such as country code, latitude, longitude and much more.
- Regular updates: We understand how essential up-to-date data is. That's why our database is regularly updated to reflect changes in geography or demographics.
How can our database help you?
- Web and Mobile Developers: Easily integrate geographic information into your applications and services.
- Analysts and Researchers: analyse demographic trends, plan development projects or carry out accurate market research.
- Logistics companies: plan your routes based on the most accurate geographical data.
Ease of use
The World cities database is formatted for easy integration. Whether you use SQL, Excel or any other data analysis tool, you can easily exploit the information provided.
Testimonials
"The World cities database has been a major asset for our logistics company. The data is accurate and always up to date." - M. Dupont, CEO LogistiquePro, Luxembourg
"As an application developer, I always need reliable geographical data. With the World Pack, I found everything I needed." - Sophie L., Freelance Developer
Conclusion
Whether you're a large enterprise, a freelance researcher or a geography enthusiast, the World cities database is the perfect resource for all your geographic data requirements. Join thousands of satisfied users and download the World Pack now to access all the countries in the world!
FaQ about World cities database
- 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.