United States cities list with latitude and longitude in CSV format

United_States
United States
CSV, SQL, XML, JSON

Last update : 24 April 2024.

Country
United States
Capitale
Washington
Number of cities
166794
Download

This is the best list of 166794 cities in the United States 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 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

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 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.