The Most Comprehensive Database
of U.S. Cities
- Contains all 47,063 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 2023
What’s included in the database?
- City name
- State code
- ZIP code
- Area code
- Latitude & Longitude
- Median income
- Land area
- Water area
- Time zone area
- Number of towns: 47,063
- Last updated: January 5th, 2023
- Update frequency: Quarterly
- Coverage: All 50 states plus Washington DC
- Data formats: CSV, SQL and Excel
- Data size: 8.3MB (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.
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. You can browse information about past data updates in the change log.
Can I use the data commercially?
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 2023 with the last quarterly refresh on . The details of this update and more information can be found in the change log.