Complete US City Data – All In One Place

The most comprehensive single listing of all 45,606 U.S. cities – with linked counties, states, coordinates, ZIP codes, populations and more. It is ideal for location lookups, website localization, marketing and data verification.

Download a free sample
Screenshot of the cities list in Excel
Our data is used by…
Prudential SolarCity General Electric Continental Mercato

Linked locations and demographic data

No complicated lookups are necessary – all records include linked location data (including county, state, latitude and longitude, ZIP codes, area codes and time zones), plus the most recent US census information (including population, households and average household income for each city).

Includes SQL, CSV and Excel formats

The data is compatible out-of-the-box with nearly all SQL databases, GIS systems, programming languages and spreadsheet applications – including Excel – so you can use the data easily without worrying about time-consuming file conversions or imports.

Updated for 2018

All records have been updated for 2018 using the most recent population estimates from the US Census Bureau, demographic data from the American Community Survey and location information from the US Geological Survey. The last complete refresh was on .

Unrestricted & developer-friendly licensing

There are no restrictive license conditions or ongoing fees. The data is yours to use permanently without renewal charges, there are no limits on the number of devices or users, and you can use the data for commercial purposes at no extra cost. Find out more about the terms of use.

Tried and tested with…
Access MySQL SQL Server PostgreSQL SQLite Access PHPMyAdmin Open Office

“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 for every state.

Can I use the data commercially?

Yes. You're free to use the data for business and commercial purposes and without attribution. Please see the licencing terms and conditions for more information.

What areas are covered?

The data covers all 50 U.S states (including Alaska and Hawaii) plus Washington, D.C.

When was the data last updated?

The last update was made on . This release was a full quarterly refresh which updated city coordinates, ZIP codes, area codes and demographic data.

Are future updates available?

Yes. With the annual subscription package you can download the data today, plus you'll receive complete updates every quarter for the next year.

Can I get a different sample?

Yes. If our standard sample data doesn't give you the assurances you need please feel free to ask us for a custom sample.