World cities database with latitude and longitude | Download CSV,SQL,JSON,XML formats

World Cities Database
CSV, SQL, XML, JSON

Last update : 13 December 2024.

All Countries
World
Number of countries
245
Number of cities
4 510 988
Download

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_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
1139546Jangal-e MukhnōyJangal-e Mukhnoy,Jangal-e Mukhnuy,Jangal-e Mukhnōy,Jangal-e Mukhnūy,jngl mkhnwy,جنگل مخنویAFTakharWarsaj36.1868570.136910Asia/Kabulpopulated place
7582712ĀhangarānAhangaran,ahngran,Āhangarān,آهنگرانAFKabulSurobi34.5836769.733110Asia/Kabulpopulated place
1423395Bāqī KhēlBakikheyl’,Bakikheyl’,Baqi Khel,Baqikheyl,Bāqī Khēl,Bāqīkheyl,baqy khyl,باقی خيل,باقی خېلAFParwanJabal us Sarāj35.1279169.267080Asia/Kabulpopulated place
1138123Karīm KhēlKarim Khel,Karim Kheyl,Karimkhel,Karimkheyl’,Karimkheyl’,Karīm Kheyl,Karīm Khēl,Kaṟīmkhēl,krym khyl,كريم خيل,کریم خېلAFKapisaḨişah-ye Awal-e Kōhistān35.1069869.362880Asia/Kabulpopulated place
1121453WunchalātOwnchalat,Ownchalāt,Wuncalat,Wuncalāt,Wunchalat,Wunchalāt,awnchlat,wnchlat,اونچلات,ونچلاتAFFaryabMaīmanah35.8986364.825080Asia/Kabulpopulated place
1462103YārdādYardad,Yārdād,yardad,یاردادAFGhazniNāwur34.0459767.338780Asia/Kabulpopulated place
1143316DilakchīDelakchi,Delakchī,Delakci,Delakči,Dilakchi,Dilakchī,dlk chy,dlkchy,Дилакчи,دلكچی,دلک چیAFGhazniJāghūrī33.0354667.626920Asia/Kabulpopulated place
1149523Āb-e KhānahAb-e Khanah,Abi Khana,Abi Khaneh,Abi Khāna,Abī Khāneh,ab khanh,Āb-e Khānah,آب خانهAFBalkhChahār Kent36.4341467.144050Asia/Kabulpopulated place
1457224BōjīBodzhi,Boji,Buji,Bōji,Bōjī,Būjī,bwjy,بوجیAFMaidan Wardak ProvinceNirkh34.3250368.704570Asia/Kabulpopulated place
1132641MūrichāqMar-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,موريچاق,مورچاقAFBadghisMurghāb35.810463.142650Asia/Kabulpopulated place
1120922Zard JōyZard Joy,Zard Jōy,Zarddzhoy,Zardjoy,Zardjuy,Zardjūy,Zaṟḏjōy,zrd jwy,زرد جویAFMaidan Wardak ProvinceMarkazi Bihsud34.1743267.881570Asia/Kabulpopulated place
1435689WārêhVara,Wareh,Waṟeh,Wārêh,warh,وارهAFGhazniGēlān32.8444867.589040Asia/Kabulpopulated place
1142510IraghlīEraghli,Eraghlī,Iraghli,Iraghlī,arghly,ارغلیAFJowzjanShibirghān36.7496765.868410Asia/Kabulpopulated place
1121973ŪlastānOwlastan,Owlastān,Ulastan,awlstan,Ūlastān,اولستانAFFarahPur Chaman33.3505963.378630Asia/Kabulpopulated place
1132075Nāw-e TangNaw-e Tang,Nawe Tang,Now-e Tang,Nāw-e Tang,naw tng,nw tng,ناو تنگ,نو تنگAFGhowrChahār Şadah35.1925965.134040Asia/Kabulpopulated place
1467949Khwāb SārīKhvab Sari,Khvāb Sāṟi,Khwab Sari,Khwāb Sārī,Khwāb Sāṟi,khwab sary,خواب ساریAFBadakhshanArgō37.0103870.314450Asia/Kabulpopulated place
1146930BārīkīBarik,Barik-e,Bariki,Bārīk-e,Bārīkī,Bāṟik,Bāṟiki,baryky,باریکیAFGhowrLa‘l wa Sar Jangal34.4322966.050370Asia/Kabulpopulated place
1468912Ḏāg KêlayDag Kalay,Dag Kelay,Dagkalay,Dāg Kalay,Dāg Kêlay,قريۀ داگ,ډاگ کلی,Ḏāg KêlayAFNangarharKāmah34.4290270.551270Asia/Kabulpopulated place
1462156Bālānah TakhakBalana Takhak,Balanah Takhak,Balanatakhak,Balaneh Takhak,Bālāna Takhak,Bālānah Takhak,Bālāneh Takhak,balanh tkhk,بالانه تخکAFBamyanWaras̄34.2188567.021830Asia/Kabulpopulated place
1138580Kalān QōlKalan Qol,Kalanqol,Kalanqowl,Kalān Qōl,Kalānqowl,Kalānqōl,klan qwl,کلان قولAFDaykundiMīr Āmōr33.8880666.813440Asia/Kabulpopulated 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!

Download data files for the World cities in CSV, SQL, XML and JSON formats

The Global City Database: Harnessing the Potential of Geographic Information

The significance of comprehensive city-level data in geographic analysis is paramount. Comprehending the specific details of each city is essential for research, business, or policy-making. Envision possessing a comprehensive database that encompasses every city globally, together with their administrative divisions, departments, and, crucially, the precise latitude and longitude for each site. This data opens up new potential for geospatial research, providing a clearer picture of how cities fit into the larger global landscape.

For geographers, urban planners, and data scientists, access to granular data in several formats—CSV, SQL, JSON, and XML—provides exceptional flexibility and integration ease. It beyond mere knowledge of city locations; it involves a profound comprehension of the complex interrelations among them, their regions, and the global context they occupy.

The Significance of City-Level Data

Municipal-level data is the basis for numerous analyses. From urbanization trends and economic modeling to disaster response planning and environmental studies, the data from cities offers insights into the dynamics of human settlements. City data encompasses not only the cities themselves but also their connections with other regions and agencies. These administrative entities provide context, helping to clarify local governing structures, economic policies, and social variables that influence each urban region.

Acquiring precise and current information about cities, including regions and departments, facilitates a deeper comprehension of urban development, growth, and functionality within both national and international frameworks. This knowledge is essential for various professionals, including policy analysts and corporate leaders, seeking to make educated judgements grounded in geographical and political contexts.

The Significance of Latitude and Longitude Data

The geographic coordinates—latitude and longitude—constitute one of the most valuable elements of urban data. These data points enable the precise identification of any city's location on the globe, which is crucial for mapping, navigation, and spatial analysis. This information enables academics and developers to produce extremely accurate maps, develop location-based applications, and examine the spatial relationships between cities and their surroundings.

Latitude and longitude serve as essential coordinates, offering spatial context for comprehending the interrelations of cities worldwide. The geographic coordinates of cities are essential data points for conducting significant, large-scale analysis in studies of global transportation networks, climate change, or migration patterns.

Diverse Formats for Versatility and Accessibility

The ability to obtain city data in numerous formats is vital for maximizing its utility. Having many alternatives for manipulating data in spreadsheets, querying it in databases, or integrating it into web applications guarantees that you can deal with the data in a manner that best meets your requirements.

CSV files offer a straightforward and accessible method for storing and analysing municipal data via applications like as Excel or Google Sheets. SQL databases provide robust querying functionalities for intricate analysis, enabling users to filter and arrange data based on defined criteria. JSON and XML formats are ideal for developers requiring the integration of city data into apps or websites, facilitating easy parsing and dynamic utilisation in real-time contexts.

These formats guarantee that regardless of the project type, the data can be readily tailored and modified to satisfy your particular needs. Whether you’re establishing a geographic information system (GIS), creating an e-commerce platform, or evaluating patterns in urbanization, the availability of city-level data in various formats is indispensable.

A Comprehensive Global Database for All Cities

Access to a comprehensive worldwide database encompassing every city, together with its areas and agencies, presents numerous options. This data is essential for professionals in international development, disaster management, environmental research, and tourism. The capacity to reference and utilise this data globally facilitates a more profound and comprehensive comprehension of cities and their distinct attributes.

Businesses seeking worldwide expansion can utilise this data to get insights into regional marketplaces, local regulations, and the socio-economic situations of various areas. Governments can utilise it to strategise infrastructure initiatives, distribute resources, and evaluate the effects of policy modifications. Researchers can track urban growth patterns, analyse the implications of climate change, or evaluate the effectiveness of urban planning programs.

Consolidating Data for Enhanced Insights

The intrinsic worth of an extensive global city database resides in its capacity to amalgamate and scrutinise data across many cities and regions. Integrating city-level data with details regarding administrative divisions, geographic locations, and many socio-economic characteristics enables users to acquire profound insights into global patterns, regional disparities, and the interrelations among urban centres.

By examining cities in connection to their physical locations, one can discern how proximity to the coast, mountains, or other natural elements affects urban development. Analysing the correlation between a city's economic production and its administrative region can assist firms and governments in identifying growth or intervention opportunities.

The Prospects of Geographic Data

With the world becoming more interconnected, the demand for precise and comprehensive geospatial data is growing. Accessing a comprehensive database of global city data, encompassing latitude, longitude, regional divisions, and administrative contexts, is essential for professionals in geospatial analysis, urban planning, or similar disciplines. Acquiring municipal data in many formats—CSV, SQL, JSON, and XML—unlocks numerous opportunities for innovation and exploration.

This data transcends mere world mapping, it facilitates a precise, actionable, and meaningful comprehension of the universe. Accessing comprehensive city-level data is essential for making educated and transformational decisions in academic research, commercial strategy, or government policy, ultimately benefiting the future of our cities and the world.

FaQ about World cities database


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.