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

United_States
United States
Excel, CSV, SQL, XML, JSON

Last update : 22 January 2026.

Country
United States
Capital
Washington
Number of cities
166794
Download
Click here

This is the best list of 166794 cities in the United States available in 5 formats ( Excel, CSV, JSON, SQL, XML ). You will find only data associated with the cities of a country (capital, towns and villages). There is no information concerning the environment, such as the location of a river or a mountain, for example. All cities are 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 States file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
5082698AntrimAntrim,Society LandUSNew HampshireHillsborough County43.03091-71.938972141397America/New_Yorkpopulated place
4643229Mount CumberlandUSTennesseeMcMinn County35.41174-84.551882690America/New_Yorkpopulated place
4227187TrudieUSGeorgiaBrantley County31.30022-81.96428170America/New_Yorkpopulated place
5712658BarviewBar View,Barview,Life Saving StationUSOregonTillamook County45.56983-123.94347110America/Los_Angelespopulated place
5145410AdamsvilleAdamsville,MechanicsvilleUSOhioMuskingum County40.06979-81.88235311116America/New_Yorkpopulated place
4583751Jordan MillUSSouth CarolinaKershaw County34.4071-80.507571060America/New_Yorkpopulated place
4065664GurleyUSAlabamaBlount County33.77649-86.63777194886America/Chicagopopulated place
4899248LakewoodUSIllinoisMason County40.24727-90.085121420America/Chicagopopulated place
4401559OaklandUSMissouriLaclede County37.63643-92.559343800America/Chicagopopulated place
4047603BendaleUSAlabamaJefferson County33.56205-86.78111860America/Chicagopopulated place
5763976DalzellUSSouth DakotaMeade County44.3436-102.396557630America/Denverpopulated place
5267288PlainfieldNorwich,PlainfieldUSWisconsinWaushara County44.21386-89.49234338834America/Chicagopopulated place
5782005Springtree CondominiumUSUtahSalt Lake County40.65078-111.8749313140America/Denverpopulated place
5171908ShepherdstownShepherds Town,Shepherdstown,ShepherdtownUSOhioBelmont County40.15896-80.943433760America/New_Yorkpopulated place
7191967Paradise Lakes Mobile Home ParkUSFloridaPolk County27.91933-81.97637400America/New_Yorkpopulated place
5129888Ontario BeachUSNew YorkMonroe County43.26006-77.61111790America/New_Yorkpopulated place
4202045InglesideUSGeorgiaBibb County32.85153-83.675461490America/New_Yorkpopulated place
5715674Breitenbush Hot SpringsBreitenbush,Breitenbush Hot Springs,Breitenbush SpringsUSOregonMarion County44.7829-121.978966830America/Los_Angelespopulated place
5524892Las Casitas Number 3 ColoniaUSTexasEl Paso County31.80816-106.1816512340America/Denverpopulated place
4716202OklaunionUSTexasWilbarger County34.12953-99.142853740America/Chicagopopulated place
5697633MitchellUSNebraskaScotts Bluff County41.94024-103.8085612051666America/Denverpopulated place
4385287Egypt MillsUSMissouriCape Girardeau County37.40505-89.46371130America/Chicagopopulated place
4055855Cliff HavenUSAlabamaColbert County34.77731-87.673081800America/Chicagopopulated place
5137767ShandeleeUSNew YorkSullivan County41.87898-74.871276460America/New_Yorkpopulated place
4478397MayfieldUSNorth CarolinaCaldwell County35.81874-81.481483620America/New_Yorkpopulated place
4467074Fox RunUSNorth CarolinaDurham County36.14125-78.964451580America/New_Yorkpopulated place
4818145PigeonUSWest VirginiaRoane County38.53676-81.208452660America/New_Yorkpopulated place
4772961MidwayUSVirginiaKing William County37.7557-77.12636450America/New_Yorkpopulated place
4265256Stalcup CornerUSIndianaGreene County38.99449-87.016121660America/Indiana/Indianapolispopulated place
4797264AndrewUSWest VirginiaBoone County38.1001-81.717342640America/New_Yorkpopulated place
5024054Deer CreekCity of Deer Creek,Deer CreekUSMinnesotaOtter Tail County46.39107-95.32142425323America/Chicagopopulated place
5815544West LongviewUSWashingtonCowlitz County46.16789-122.99942698America/Los_Angelespopulated place
5231799ShindlerUSSouth DakotaLincoln County43.47498-96.64866428584America/Chicagopopulated place
5569854Pumpkin CenterUSCaliforniaLassen County41.10989-121.1066412600America/Los_Angelespopulated place
4398038Meramec TerraceUSMissouriFranklin County38.41589-90.830131540America/Chicagopopulated place
4048042GwinnstoneUSGeorgiaGwinnett County33.83844-84.032693120America/New_Yorkpopulated place
4093781TinelaUSAlabamaMonroe County31.80849-87.39721640America/Chicagopopulated place
4070842KincheonUSAlabamaChilton County32.75707-86.701931690America/Chicagopopulated place
7258847Lebanon SouthLebanon South,Lebanon South CDPUSPennsylvaniaLebanon County40.32804-76.406441582270America/New_Yorkpopulated place
7208712Greenfield VillageUSTexasHarris County29.9472-95.4768320America/Chicagopopulated place
4813635ManBuffalo City,Man,man,mn wyrjynyay ghrby,Ман,مان,من، ویرجینیای غربیUSWest VirginiaLogan County37.73983-81.87762225704America/New_Yorkpopulated place
4671854BJB ColoniaBJB Colonia,BJB Subdivision ColoniaUSTexasHidalgo County26.3784-98.14529260America/Chicagopopulated place
4047413BellevueBellevue,Bellevue Highlands,BelvueUSAlabamaEtowah County34.03454-86.021922450America/Chicagopopulated place
5104773SomersetinUSNew JerseySomerset County40.7401-74.576271830America/New_Yorkpopulated place
7217005Fairview TerraceUSFloridaHillsborough County28.0347-82.4454100America/New_Yorkpopulated place
5565442HotlumUSCaliforniaSiskiyou County41.47404-122.3144612610America/Los_Angelespopulated place
4252767West EndWest End,WestendUSIllinoisSaline County37.89005-88.705611370America/Chicagopopulated place
4648911Peters MillUSTennesseeKnox County35.96731-83.702122610America/New_Yorkpopulated place
4635291LakesideUSTennesseeRhea County35.71035-84.751892260America/New_Yorkpopulated place
5724352DundeeDundee,Dundee JunctionUSOregonYamhill County45.27817-123.01094643200America/Los_Angelespopulated place
4668367WindmereUSTennesseeSullivan County36.50566-82.539324230America/New_Yorkpopulated place
5299095HuntUSArizonaApache County34.61003-109.6276116560America/Phoenixpopulated place
4968204JacksonvilleUSMaineWashington County44.76063-67.39527140America/New_Yorkpopulated place
4222176Shandra EstatesUSGeorgiaFulton County33.58956-84.522992900America/New_Yorkpopulated place
4398194MidlandUSMissouriCrawford County37.97838-91.327092700America/Chicagopopulated place
5251102DuveneckUSWisconsinManitowoc County44.01694-87.711752010America/Chicagopopulated place
5500696BristolBristol,Bristol City,National CityUSNevadaLincoln County38.07996-114.6194421410America/Los_Angelespopulated place
11387703Stepping StoneUSOhioFranklin County40.01981-82.822822960America/New_Yorkpopulated place
7209280Sterling Green SouthUSTexasHarris County29.7958-95.1553100America/Chicagopopulated place
4584597LandsdowneUSSouth CarolinaCharleston County32.72351-79.9534230America/New_Yorkpopulated place
4928117Western VillageUSIndianaMadison County40.1081-85.71722650America/Indiana/Indianapolispopulated place
4348037Bay Shore AcresUSMarylandWorcester County38.34289-75.1035210America/New_Yorkpopulated place
5551138Ali ChuksonAl Chuk Shon,Ali Chuk Son,Ali Chukson,Alit Ju Kson,Alitjukson,Little Tucson,Little Tuscon,Tucson Hill,Tucsoncito,Tucsonito,TusconcitoUSArizonaPima County31.91369-111.79929787132America/Phoenixpopulated place
7149239Telford ChaseUSPennsylvaniaBucks County40.3216-75.31511470America/New_Yorkpopulated place
4794236WinnieUSVirginiaNottoway County37.07321-78.132221480America/New_Yorkpopulated place
4316411Belmont LandingUSLouisianaWest Baton Rouge Parish30.50824-91.2431650America/Chicagopopulated place
4119248Little GarnettCross Road Station,Little GarnettUSArkansasLincoln County33.86316-91.803741160America/Chicagopopulated place
4378530BroseleyBailey,Baileys End,BroseleyUSMissouriButler County36.67506-90.24177980America/Chicagopopulated place
4370362Stevenson ParkUSMarylandAnne Arundel County39.1265-76.64747320America/New_Yorkpopulated place
4677432Bunker Hill VillageUSTexasHarris County29.76745-95.52994253957America/Chicagopopulated place
4664055Union GroveUSTennesseeBradley County35.08508-84.791892740America/New_Yorkpopulated place
4059921East IrondaleUSAlabamaJefferson County33.53066-86.688882810America/Chicagopopulated place
4304235Pilcher LandingUSKentuckyMeade County37.99202-86.017471260America/New_Yorkpopulated place
4924191NobleUSIndianaJay County40.46949-84.826072810America/Indiana/Indianapolispopulated place
4704261LagartoLagarta,LagartoUSTexasLive Oak County28.11945-97.95556490America/Chicagopopulated place
5436099RedlandsUSColoradoMesa County39.07887-108.6356514198685America/Denverpopulated place
5731629HolleyUSOregonLinn County44.35429-122.78342192378America/Los_Angelespopulated place
4945518North BeverlyUSMassachusettsEssex County42.58065-70.88699170America/New_Yorkpopulated place
4253772AlbionUSIndianaScott County38.74367-85.734131920America/Indiana/Indianapolispopulated place
4493188Stallings CrossroadsStallings,Stallings CrossroadsUSNorth CarolinaFranklin County36.09404-78.165271170America/New_Yorkpopulated place
5793434EdnaUSWashingtonBenton County46.58958-119.414471230America/Los_Angelespopulated place
5545568Red Lake VillageUSUtahSan Juan County37.19722-109.3237314530America/Denverpopulated place
4079925New MoonUSAlabamaCherokee County34.39314-85.520242070America/Chicagopopulated place
4777064Odricks CornerUSVirginiaFairfax County38.93872-77.231371140America/New_Yorkpopulated place
4828812JasperUSNorth CarolinaCraven County35.20155-77.20662110America/New_Yorkpopulated place
4192067DrewUSGeorgiaForsyth County34.20843-84.219643500America/New_Yorkpopulated place
4998189KingsfordKingsford,kynghzfwrd,kyngzfwrd myshygan,Кингсфорд,كينغزفورد,کینگزفورد، میشیگانUSMichiganDickinson County45.79496-88.072073355069America/Menomineepopulated place
4787037Spring Garden Mobile Home ParkUSVirginiaCity of Petersburg37.21432-77.3647420America/New_Yorkpopulated place
7236555Ruby’s Mobile Home ParkUSMichiganClare County43.83417-84.768892660America/Detroitpopulated place
4763793HerndonKherndon,hrndn wyrjynya,hyrndwn,Херндон,هرندن، ویرجینیا,هيرندونUSVirginiaFairfax County38.96955-77.386111024568America/New_Yorkpopulated place
5808636RockdaleUSWashingtonKing County47.39233-121.454267710America/Los_Angelespopulated place
5199342LymansvilleUSPennsylvaniaPotter County41.77312-77.984735210America/New_Yorkpopulated place
5138751South BolivarHoneoye Corners,Honeoye Forks,South BolivarUSNew YorkAllegany County42.0059-78.115294680America/New_Yorkpopulated place
4586328Marsh CoveUSSouth CarolinaCharleston County32.81684-80.0284250America/New_Yorkpopulated place
4600388WeeksUSSouth CarolinaColleton County33.04683-80.62649260America/New_Yorkpopulated place
4678872Cantu AdditionUSTexasBrooks County27.20254-98.1552834188America/Chicagopopulated place
4337903Porters River LandingUSLouisianaSaint Tammany Parish30.36214-89.7320140America/Chicagopopulated place
4764010High HillUSVirginiaHalifax County36.63597-78.749171500America/New_Yorkpopulated place
4678586Camp WillowUSTexasGuadalupe County29.66578-98.068621790America/Chicagopopulated place
4605074Beech HillUSTennesseeGiles County35.2298-86.889172300America/Chicagopopulated place

Understanding the United States: A Geographical Exploration

The Vast and Diverse Landscape of the United States

The United States, stretching from the Atlantic Ocean in the east to the Pacific Ocean in the west, is a country of remarkable geographical diversity. From the icy tundras of Alaska to the sun-drenched deserts of Arizona, and from the flat plains of the Midwest to the towering peaks of the Rockies, the geography of the United States is as varied as the people who live within it. This expansive country, which spans over 3.8 million square miles, offers a multitude of landscapes that range from coastal marshlands to dense forests, rugged mountains, and sprawling urban environments.

This geographic diversity has a profound impact on the country’s climate, culture, economy, and even the administrative divisions that govern its cities and regions. Understanding the geography of the United States requires not just knowledge of its physical features, but also an understanding of how these landscapes shape the lives of its inhabitants and influence the nation's development.

The Structure of Cities, Regions, and Administrative Divisions in the United States

The United States is divided into 50 states, each with its own government and geographical features. These states are further divided into counties, cities, towns, and other local jurisdictions. Within these cities, the boundaries between regions can be significant, shaping local culture, economy, and governance. While some cities serve as major metropolitan hubs like New York, Los Angeles, and Chicago, others are known for their regional importance, such as Denver in the West or Dallas in the South.

Each of these cities and their surrounding regions plays a vital role in the United States’ overall functioning. Understanding the geographic layout of cities, regions, and their administrative divisions is crucial for comprehending the complexities of the country’s political, economic, and social fabric. These cities are not just places on a map—they represent the beating heart of American life and governance.

How Geographical Data Shapes Our Understanding of the United States

Geographical data plays an essential role in understanding the United States. Knowing the precise locations of cities, counties, and regions, including their exact latitude and longitude, helps to provide a clear picture of how the United States is organized and how its population is distributed. This data is not merely academic—it has practical applications for businesses, urban planning, environmental studies, and much more.

For example, having access to accurate geographical coordinates allows for better transportation planning, disaster response strategies, and urban development projects. By understanding where cities and regions are located, how far they are from one another, and what geographical features separate them, we gain insights into their economic ties, cultural connections, and logistical challenges.

The Importance of Detailed Geographic Data for the United States

In today’s data-driven world, having access to comprehensive geographic data is more important than ever. For anyone researching, planning, or analyzing the United States, understanding the precise latitude and longitude of cities, their regions, and the departments they belong to is invaluable. Accurate data helps urban planners optimize city layouts, assists environmentalists in mapping ecosystems, and supports academics in researching geographical trends.

Our database offers exactly that—detailed, up-to-date information about the cities of the United States, their regions, and their administrative divisions. With this data, you can not only find the location of any city but also understand how it fits within the larger framework of the country’s geographical structure. Whether you are a geographer, urban planner, or someone with a deep interest in the United States, access to this data allows for a much more nuanced understanding of the country’s geographical makeup.

Unlocking the Potential of United States Geographic Data

Having the right geographical data opens up a world of possibilities for research, development, and decision-making. By accessing our comprehensive database of the United States’ cities, regions, and departments, you can unlock the potential to study the United States’ geography in more detail than ever before.

Our platform provides precise data on the geographical locations of cities, allowing for in-depth analysis of spatial distribution, population patterns, and regional economies. Whether you are studying the cities of the East Coast or the vast, open spaces of the West, this data is essential for anyone seeking to understand the United States on a deeper level.

A New Era of Geographical Exploration

As we continue to move further into the digital age, the accessibility of geographical data has become more important than ever. The ability to access detailed geographic information, such as the latitude and longitude of each city, provides an opportunity for greater exploration and analysis. Our platform is designed to facilitate this exploration by offering you the tools you need to access accurate and detailed data about the United States.

With our database, you can explore the country’s vast and diverse geography in ways that were once impossible. Whether you are focused on urban development, environmental studies, or simply want to learn more about the United States' geography, the possibilities are endless when you have the right data at your fingertips.

Conclusion: The Power of Geographical Data for Understanding the United States

The United States is a country of remarkable geographical diversity, with a vast array of cities, regions, and landscapes that shape its culture, economy, and society. By gaining access to detailed geographical data, you can unlock a deeper understanding of the United States and its many complexities. Our platform provides you with the tools to explore this country’s geography in ways that go beyond the surface—allowing for informed decision-making, enhanced research, and a more profound understanding of the nation as a whole.

FaQ about United States

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 5 Excel, 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 .zip archive containing the country files in Excel, 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.
Yes! We have recently updated our data packs and included the Excel (.xlsx) format, the latest Excel format. Take advantage now of 5 formats instead of 4 at no extra cost!

List of countries :

h2020-flow.eu

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