United Kingdom cities list with latitude and longitude in CSV,SQL,XML,JSON formats

United_Kingdom
United Kingdom
CSV, SQL, XML, JSON

Last update : 15 January 2025.

Country
United Kingdom
Capitale
London
Number of cities
21435
Download
Click here

This is the best list of 21435 cities in the United Kingdom 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 United Kingdom file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
2652544Colnekwln lankashr,کولن، لانکاشرGBEnglandLancashire53.85713-2.1685120118Europe/Londonpopulated place
2646850HintonHintonGBEnglandSouth Gloucestershire51.48972-2.384723533Europe/Londonpopulated place
2655235Bolton BridgeGBEnglandNorth Yorkshire53.9732-1.893940Europe/Londonpopulated place
12263421West CurthwaiteWest CurthwaiteGBEnglandCumbria54.82886-3.057720Europe/Londonpopulated place
2654808BredhurstBredhurstGBEnglandKent51.330990.576050Europe/Londonpopulated place
6620446Hampton CourtGBEnglandGreater London51.4036-0.33749100Europe/Londonpopulated place
2636681StrattonStrattonGBEnglandCornwall50.83333-4.516670Europe/Londonpopulated place
12266003NewholmNewholmGBEnglandNorth Yorkshire54.48284-0.663470Europe/Londonpopulated place
2640401Penton MewseyPenton MewseyGBEnglandHampshire51.22503-1.52809412Europe/Londonpopulated place
12264060St JohnSt JohnGBEnglandCornwall50.36135-4.240230Europe/Londonpopulated place
12263361Pecket WellPecket WellGBEnglandCalderdale53.76421-2.008670Europe/Londonpopulated place
2641693New BuildingsAn Baile Nua,New BuildingsGBNorthern IrelandDerry City and Strabane54.9603-7.355813381Europe/Londonpopulated place
12262995LewistownLewistownGBWalesBridgend county borough51.58446-3.540950Europe/Londonpopulated place
12261839Leicester Forest WestLeicester Forest WestGBEnglandLeicestershire52.61567-1.259980Europe/Londonpopulated place
2646486HownamHounam,HownamGBScotlandThe Scottish Borders55.46649-2.352190Europe/Londonpopulated place
11592280FaifleyGBScotlandWest Dunbartonshire55.92853-4.385095030Europe/Londonpopulated place
12263030RidgewayRidgewayGBEnglandDerbyshire53.06009-1.466870Europe/Londonpopulated place
2640364PerranzabuloePerranzabuloeGBEnglandCornwall50.326-5.133170Europe/Londonpopulated place
2643652LongniddryLongniddryGBScotlandEast Lothian55.97543-2.895932430Europe/Londonpopulated place
12264305CramhurstCramhurstGBEnglandSurrey51.16053-0.656270Europe/Londonpopulated place
12265364FardenFardenGBEnglandShropshire52.38302-2.618370Europe/Londonpopulated place
2643231MadingleyGBEnglandCambridgeshire52.223510.04060Europe/Londonpopulated place
8440085CarrowclareGBNorthern IrelandCauseway Coast and Glens55.08623-7.00490Europe/Londonpopulated place
2640705OystermouthOystermouthGBWalesCity and County of Swansea51.57507-4.005080Europe/Londonpopulated place
2640412PensaxGBEnglandWorcestershire52.3176-2.405880Europe/Londonpopulated place
2646665HonileyHonileyGBEnglandWarwickshire52.34937-1.651080Europe/Londonpopulated place
12263317TyttenhangerTyttenhangerGBEnglandHertfordshire51.73846-0.294020Europe/Londonpopulated place
11551006LakenhamGBEnglandNorfolk52.61861.298880Europe/Londonpopulated place
12262713CompstallCompstallGBEnglandBorough of Stockport53.41493-2.055190Europe/Londonpopulated place
11592615WhitminsterGBEnglandGloucestershire51.77358-2.326010Europe/Londonpopulated place
2645081Kyre MagnaGreat Kyre,Kyre,Kyre MagnaGBEnglandWorcestershire52.26667-2.550Europe/Londonpopulated place
2637182SproustonGBScotlandThe Scottish Borders55.60798-2.390930Europe/Londonpopulated place
12265840BringtonBringtonGBEnglandCambridgeshire52.3735-0.408520Europe/Londonpopulated place
2647517HanthorpeGBEnglandLincolnshire52.80229-0.391390Europe/Londonpopulated place
11550752Westbury on TrymGBEnglandCity of Bristol51.49239-2.620450Europe/Londonpopulated place
2655413BlaenavonGBWalesTorfaen County Borough51.77402-3.085375647Europe/Londonpopulated place
12265722High BradfieldHigh BradfieldGBEnglandSheffield53.4283-1.597610Europe/Londonpopulated place
2644670LegonielLegoneil,Legoniel,LigonielGBNorthern IrelandCity of Belfast54.61667-5.983330Europe/Londonpopulated place
2636991StavertonStavertonGBEnglandDevon50.46667-3.70Europe/Londonpopulated place
2652274CotonCoton,CottonGBEnglandShropshire52.9-2.716670Europe/Londonpopulated place
2647489HardwickeGBEnglandGloucestershire51.80694-2.291280Europe/Londonpopulated place
2640071PortchesterPorchester,PortchesterGBEnglandHampshire50.84172-1.120430Europe/Londonpopulated place
2641336North HinkseyNorth HinkseyGBEnglandOxfordshire51.75015-1.292010Europe/Londonpopulated place
12265962Isle AbbottsIsle AbbottsGBEnglandSomerset50.98282-2.92690Europe/Londonpopulated place
12262212KneepCnip,KneepGBScotlandEilean Siar58.22156-6.948280Europe/Londonpopulated place
2653484CauntonCauntonGBEnglandNottinghamshire53.13309-0.88676483Europe/Londonpopulated place
2636805StonesfieldStonesfieldGBEnglandOxfordshire51.85142-1.42961527Europe/Londonpopulated place
12264834SheetSheetGBEnglandShropshire52.36446-2.689570Europe/Londonpopulated place
2657593AirorAirorGBScotlandHighland57.06667-5.766670Europe/Londonpopulated place
9538944St. Helens, RydeGBEnglandIsle of Wight50.6917-1.112410Europe/Londonpopulated place
2645152KniptonGBEnglandLeicestershire52.87265-0.776940Europe/Londonpopulated place
2641329NorthingtonGBEnglandHampshire51.13278-1.18910Europe/Londonpopulated place
12265080Holy CrossHoly CrossGBEnglandWorcestershire52.40562-2.114510Europe/Londonpopulated place
2644323Little HabtonGBEnglandNorth Yorkshire54.18414-0.860880Europe/Londonpopulated place
2650777DunballGBEnglandSomerset51.163-2.986580Europe/Londonpopulated place
2640478PenderynPenderynGBWalesRhondda Cynon Taf51.75992-3.522180Europe/Londonpopulated place
2655273BodminBodamina,Bodmin,Bosvenegh,bo de ming,bwdmyn,Бодмин,بودمین,博德明GBEnglandCornwall50.47151-4.724314614Europe/Londonpopulated place
12265623Great HarrowdenGreat HarrowdenGBEnglandNorthamptonshire52.32877-0.708810Europe/Londonpopulated place
11593388Shamley GreenGBEnglandSurrey51.18354-0.526230Europe/Londonpopulated place
2640963OnecoteGBEnglandStaffordshire53.09318-1.927330Europe/Londonpopulated place
2653847Capel HendreCapel Hendre,HendreGBWalesCarmarthenshire51.78278-4.041940Europe/Londonpopulated place
12265052Crazies HillCrazies HillGBEnglandWokingham51.52184-0.847860Europe/Londonpopulated place
12265221Great Lea CommonGreat Lea CommonGBEnglandWokingham51.41209-0.979650Europe/Londonpopulated place
12264440Newton ValenceNewton ValenceGBEnglandHampshire51.0926-0.975530Europe/Londonpopulated place
2656903AskhamGBEnglandCumbria54.60668-2.753110Europe/Londonpopulated place
2657134ArdnoGBScotlandArgyll and Bute56.23133-4.987110Europe/Londonpopulated place
2651378DenhamDenham,dnhm,دنهمGBEnglandBuckinghamshire51.56667-0.51432Europe/Londonpopulated place
2646561HorseyHorseyGBEnglandNorfolk52.733331.666670Europe/Londonpopulated place
12261742Collier StreetCollier StreetGBEnglandKent51.188050.454940Europe/Londonpopulated place
2635162UpavonUPV,UpavonGBEnglandWiltshire51.2946-1.80791474Europe/Londonpopulated place
2635940ThorringtonThorringtonGBEnglandEssex51.841241.038890Europe/Londonpopulated place
6620338RedworthGBEnglandDarlington54.60404-1.629320Europe/Londonpopulated place
2637836SillothSilloth-on-Solway,sylwth,سیلوثGBEnglandCumbria54.8687-3.384482906Europe/Londonpopulated place
2652190CowleyGBEnglandGloucestershire51.83084-2.055990Europe/Londonpopulated place
2637083Stanford RiversGBEnglandEssex51.685190.217350Europe/Londonpopulated place
12266629Spey BaySpey BayGBScotlandMoray57.66869-3.083380Europe/Londonpopulated place
2638479SawdonGBEnglandNorth Yorkshire54.25258-0.557180Europe/Londonpopulated place
2655385BlakeneyBlakeneyGBEnglandGloucestershire51.75851-2.492260Europe/Londonpopulated place
7521857ButterknowleGBEnglandCounty Durham54.62606-1.837890Europe/Londonpopulated place
12265224WatersideWatersideGBScotlandEast Ayrshire55.66257-4.411190Europe/Londonpopulated place
2639837PuseyGBEnglandOxfordshire51.66791-1.485490Europe/Londonpopulated place
2644113LlandygwyddLlandygwyddGBWalesCounty of Ceredigion52.06349-4.567720Europe/Londonpopulated place
12263478DundonaldDundonaldGBScotlandFife56.13807-3.261680Europe/Londonpopulated place
12262139PortnaguranPort nan Giuran,Port nan Giùran,PortnaguranGBScotlandEilean Siar58.25195-6.166570Europe/Londonpopulated place
2657078ArkholmeArkholmeGBEnglandLancashire54.14321-2.640140Europe/Londonpopulated place
2637873SibbertoftSibbertoftGBEnglandNorthamptonshire52.43732-0.999410Europe/Londonpopulated place
12261700DumpfordDumpfordGBEnglandWest Sussex50.99039-0.819910Europe/Londonpopulated place
2651565DalnessGBScotlandHighland56.61667-4.983330Europe/Londonpopulated place
2651351DepdenGBEnglandSuffolk52.180880.605620Europe/Londonpopulated place
2643973LlannonGBWalesCarmarthenshire51.75519-4.11752869Europe/Londonpopulated place
12263276Hungerford GreenHungerford GreenGBEnglandWest Berkshire51.51176-1.197370Europe/Londonpopulated place
11071766BadninishGBScotlandHighland57.91724-4.092190Europe/Londonpopulated place
12262858MetcombeMetcombeGBEnglandDevon50.71872-3.292790Europe/Londonpopulated place
12261922Low ValleyfieldLow ValleyfieldGBScotlandFife56.05881-3.605710Europe/Londonpopulated place
6324493NewmillerdamGBEnglandCity and Borough of Wakefield53.63825-1.497860Europe/Londonpopulated place
2648099Great GivendaleGreat GivendaleGBEnglandEast Riding of Yorkshire53.96667-0.766670Europe/Londonpopulated place
12266150Little CarltonLittle CarltonGBEnglandNottinghamshire53.10879-0.836760Europe/Londonpopulated place
2639063RoughtonRoughtonGBEnglandNorfolk52.883331.3571Europe/Londonpopulated place
2636715Stratfield SayeStratfield SayeGBEnglandHampshire51.34981-1.020180Europe/Londonpopulated place
2647969GreenhaughGBEnglandNorthumberland55.17921-2.322810Europe/Londonpopulated place

Exploring the United Kingdom: A Geographical Insight

An Overview of the United Kingdom's Unique Geographical Landscape

The United Kingdom (UK), comprising four distinct nations—England, Scotland, Wales, and Northern Ireland—presents a geographical tapestry that has fascinated geographers for centuries. From the rugged highlands of Scotland to the rolling hills of England’s countryside, the UK's geography is as varied as it is captivating. Situated to the northwest of mainland Europe, the UK is bordered by the Atlantic Ocean, the North Sea, the English Channel, and the Irish Sea, which gives the country a unique position for maritime history and development.

This geographical diversity extends beyond its landscapes to include diverse climate zones, varying altitudes, and a rich variety of ecosystems that make the UK an exceptional place for both environmental study and urban analysis. Understanding this country's geography requires more than just an appreciation of its scenic beauty—it's about connecting the landforms with the social, cultural, and economic dynamics that define each region.

Cities, Regions, and Administrative Divisions of the United Kingdom

One of the most fascinating aspects of the UK is its structure of cities, regions, and departments. Each of the four nations has its own set of administrative divisions, each with its own identity and geographical significance. For instance, England is divided into counties, regions, and metropolitan counties, while Scotland and Wales have their own respective systems of local governance, with cities and regions often reflecting historical boundaries.

Whether it's London, the capital and a global hub of finance and culture, or the smaller cities like Cambridge and Oxford, each city within the UK offers its own geographical identity. But it's not just the cities themselves that matter—understanding their regions and the departments they belong to provides a deeper insight into the cultural and economic divisions that shape the nation.

How Geographical Data Shapes Our Understanding of the United Kingdom

Access to geographical data, especially regarding the latitude and longitude of cities, regions, and departments, is crucial for any meaningful analysis of the UK’s geography. With the advent of digital databases and mapping technologies, obtaining precise location data has never been easier. By understanding the geographical coordinates of cities and their administrative areas, researchers can gain insights into everything from population density to economic trends.

The UK is home to a vast number of cities and towns, each with unique geographical characteristics. Some, like Edinburgh and Cardiff, serve as both political and cultural capitals of their respective regions, while others, like Birmingham and Manchester, represent major industrial hubs. But to truly understand these cities and their surrounding areas, having access to comprehensive, accurate data is essential.

Unlocking the Potential of Geographical Data for Informed Decision-Making

When it comes to research, planning, or development, having access to reliable geographical data is indispensable. Our platform offers an extensive database that includes detailed information about every city in the United Kingdom, including their regions and departments. With this database, you can easily access precise data such as latitude and longitude, helping to pinpoint the exact location of any city in the UK.

This data can be invaluable for a wide range of applications, from urban planning and infrastructure development to environmental studies and academic research. Whether you're a geographer, an urban planner, or just a curious mind looking to explore the geography of the United Kingdom in greater depth, our database is designed to support your needs with accuracy and precision.

A New Frontier in Geographical Data Access

The key to fully understanding the geographical dynamics of the United Kingdom lies not just in studying the landscape or the political divisions, but in having the right data at your fingertips. By utilizing our comprehensive database, you can explore the geographic intricacies of the UK like never before.

With the ability to access data on cities, regions, and their exact geographical coordinates, you are equipped with the tools needed to unlock a deeper understanding of the UK's complex geography. From the bustling streets of London to the quiet towns nestled in the Scottish Highlands, every corner of the UK is filled with valuable data that tells a unique story.

Conclusion: Embrace the Power of Data for Geographical Exploration

The United Kingdom, with its rich history and complex geography, offers endless opportunities for exploration. By leveraging accurate, detailed geographical data, we can gain a more profound understanding of the UK's cities, regions, and administrative boundaries. This approach is essential for anyone seeking to engage with the UK's geography at a deeper level—whether you're involved in academic research, urban planning, or simply fascinated by the complexities of the land.

Access to this data opens new doors for informed decision-making, strategic planning, and a more nuanced understanding of the UK’s geographical landscape. Our platform offers just that—precise and comprehensive data that will help you navigate the geographical intricacies of this remarkable country.

FaQ about United Kingdom

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.