The Most Comprehensive Database
of U.S. Cities

  • Contains all 47,172 incorporated cities in the United States.
  • Includes linked counties, states, ZIP codes, latitude-longitude, populations and more.
  • Data in Excel, CSV and SQL formats
  • Fully updated for Fall 2024

Download the data Find out more ›

The US cities database in Excel format

What’s included in the database?

  • City name
  • County
  • State
  • State code
  • ZIP code
  • Area code
  • Latitude & Longitude
  • Population
  • Households
  • Median income
  • Land area
  • Water area
  • Time zone area
  • Type

Key information

  • Number of cities: 47,172
  • Last updated: October 24th, 2024
  • Update frequency: Quarterly
  • Coverage: All 50 states plus Washington DC
  • Data formats: CSV, SQL and Excel
  • Data size: 8.7MB (zipped)
  • Language and Encoding: en-US, UTF-8
  • Supply: Online download

Over 14,000 hours of time saved

No one wants to spend hours – or even days – manually researching, scraping data sources and doing complex conversions just to get a list of cities. Our database is designed so you can simply download the information you need and get to work in minutes, freeing you up to focus on what’s actually important to you. Since we launched in 2011 we estimate that our database has saved businesses and individuals over 14,000 hours of manual work.

Comprehensive, accurate and reliable

You can be confident that the data is correct. Our list of all US cities uses information from official sources only — including the US Census Bureau, US Geological Survey and American Community Survey — and all currently incorporated cities, towns, villages, townships and boroughs in the United States are included. The database is completely refreshed every quarter and undergoes regression testing and quality assurance checks before each release.

Worry-free licencing

There are no limits on the number of devices or users, so you are free to work and grow without worrying about artificial ceilings. Our ‘Business’ package also allows you to use the data for business and commercial purposes with almost no restrictions. Take a look at the available packages.

Used by hundreds of businesses and individuals across the United States

Our list of U.S. cities is perfect for:

  • Location search and mapping functionality
  • Auto-fill and auto-complete boxes
  • Website localization
  • Marketing and advertising campaigns
  • Data verification and quality assurance checks

“I needed a list of cities that was accurate, cost effective and easy to consume. Your dataset provided this and came with scripts for loading into SQL without any extra work.”

— Phil Breeze, Sepura

“The presence of zip, lat, long and population are excellent. We will probably implement geosearch, so having the data ready is great… This was a great purchase worth every penny.”

— John Beavans, JobFinderUSA

“Does the database contain all cities?” and other FAQs

Does the database contain all cities?

Yes. All currently incorporated cities, towns, villages, townships and boroughs in the U.S. are listed. Census Designated Places (populated areas which don't have a municipal government, but which otherwise physically resemble incorporated places) are also included. The database covers all 50 U.S. states plus Washington D.C.

Who else uses your data?

Since 2011 we’ve worked with hundreds of businesses and individuals to provide the data they need to help run their websites and internal systems. We serve customers from major national companies (like General Electric, Deloitte and Prudential), through to web development, design and marketing agencies across the U.S.

Are future updates included?

Yes, all purchases includes quarterly data updates for the next 12 months. The updates will be automatically emailed to you at the start of January, April, July and October.

Can I use the data commercially?

Yes. Our 'Business' package allows you to use the data for business and commercial purposes. Please see the terms of use for more information.

How do I buy the data?

You can buy online with credit card, debit card or PayPal. Immediately after purchase you’ll be taken to a webpage which contains a unique link to your data. Clicking this link will download the full database directly to your computer. We’ll also send an email receipt which includes a backup of your download link, so you can download the database again at any time. If you can’t pay online we are happy to accept payment via purchase order and invoice. Please message us to let us know your requirements and we will arrange the next steps with you.

How accurate is the data? When was it last updated?

All records have been updated for Fall 2024 with the last quarterly refresh on .