United States Cities Database

We're proud to offer a simple, accurate and up-to-date database of United States cities and towns. We've built it from the ground up using authoritative sources such as the U.S. Geological Survey and U.S. Census Bureau.

  • Up-to-date: It was last refreshed in February of 2017.
  • Comprehensive: Over 38,000 cities and towns from all 50 states, DC, Puerto Rico and the US Virgin Islands.
  • Accurate: Cleaned and aggregated from official public domain sources.
  • Simple: A single CSV file, concise field names, only one entry per city.

Databases

FreePro
Commercial useAllowedAllowed
File formatCSVCSV, Excel, SQL
AttributionBacklink requiredNot necessary
Fast email supportNot availableIncluded
UpdatesNot guaranteedIncluded for 12 months
RedistributionRestrictedRestricted
Refund policyN/A30-day guarantee
One-time feeNone$49
Buy Now!

Visualization

Here is a visualization of the data in the continental United States:

Sample Preview

Here is a sample of a few rows (and the most common columns) from the database:


All Fields

city The name of the city/town.
city_ascii city as an ASCII string.
lat The latitude of the city/town.
lng The longitude of the city/town.
state_id The state or territory's USPS postal abbreviation.
state_name The name of the state or territory that contains the city/town.
county_name The name of the county (or equivalent) that contains the city/town.
county_fips The 5-digit FIPS code for the county. The first two digits correspond to the state's FIPS code.
zips A string containing all five-digit zip codes in the city/town, delimited by a space. Learn more.
population The city/town's population as measured by the 2010 Census.
source For some cities, our data is generated from a polygon representing the city, for others we simply have a point.
id A 10-digit unique id generated by SimpleMaps. It is consistent across releases and databases (e.g. World Cities Database).

Frequently Asked Questions

How do you determine which zip codes are in a city?

Our zip code data comes from our Zip Code Database. Most zip codes are Zip Code Tabulation Areas and are represented as a geographic area. We consider a ZCTA to be part of a city if the area intersecting both the ZCTA and city is at least 10 percent of the area of either the city or the ZCTA. This means that a ZCTA can be in more than one city. If this method does not result in a zip code, we will use the closest zip in the immediate area. For some villages in remote locations (like the Aleutian Islands) no zip code exists.

Why should I trust this data?

This database was aggregated from authoritative sources and carefully processed by SimpleMaps. We've been developing and selling interactive maps to Fortune 500 companies and prominent international organizations for over 7 years. Over this time, we've learned a lot about geographic data. To get a sense of the expertise and support we offer, check out some of the testimonials from our happy customers.

How often do you release updates?

Our data comes from the U.S. government. When the U.S. Census Bureau updates their data, we release a new version.

Am I allowed to redistribute the database?

No. You are not allowed to sell the database or make it publicly available. However, you can make copies and backups of the data. You are also allowed to query the database to power publicly facing applications such as a store locator.

If I use the free database, what type of attribution is required?

If you use the free database, you must link back to this page:
http://simplemaps.com/data/us-cities
from a public webpage where you are using the data. If you want to use the data internally, you must link back to this page from your firm's website on a page that can be easily found though links on the root domain. The link must be clearly visible to the human eye.

How do I calculate the distance between two cities?

We've published free formulas in popular programming languages. Check them out.

© Simplemaps.com 2010-2017 | Home | License | Privacy Policy | Releases | Testimonials | Resources | Documentation
Formerly FlashUSAmap.com and Flashworldmap.com