United Kingdom cities list with latitude and longitude in CSV format

United_Kingdom
United Kingdom
CSV, SQL, XML, JSON

Last update : 27 April 2024.

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

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.