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 March of 2019.
  • Comprehensive: Over 37,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.


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


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_fips The 5-digit FIPS code for the county. The first two digits correspond to the state's FIPS code.
county_name The name of the county (or equivalent) that contains the city/town.
population An estimate of the city's urban population as measured by the Census. 2016 data (when available).
population_proper An estimate of the city's municipal population as measured by the Census. 2016 data (when available).
density The number of people per square kilometer. population / land_area (estimated when area unknown).
source For some cities, our data is generated from a polygon representing the city, for others we simply have a point.
incorporated TRUE if the place is a city/town. FALSE if the place is just a commonly known name for a populated area.
timezone The city's timezone in the tz database format. (e.g. America/Los_Angeles)
zips A string containing all five-digit zip codes in the city/town, delimited by a space. Learn more.
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 8 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.

Does the database contain neighborhoods?

No, the database does not typically contained named places that are within other listed cities. The only exception to this is that both New York City, and its boroughs (Brooklyn, Manhattan, Queens, The Bronx, and Staten Island) are included.

Does the database include commonly known populated places even if they don't have a legal/municipal existence?

Yes, such places are included. The field incorporated will have a value of FALSE for such places.

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

Home (Maps) | Database License | Privacy | Database Releases | Database Order Lookup
© SimpleMaps.com 2010-2019