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.
|File format||CSV||CSV, Excel, SQL|
|Attribution||Backlink required||Not necessary|
|Fast email support||Not available||Included|
|Updates||Not guaranteed||Included for 12 months|
|Refund policy||N/A||30-day guarantee|
Here is a visualization of the data in the continental United States:
Here is a sample of a few rows (and the most common columns) from the database:
||The name of the city/town.|
||The latitude of the city/town.|
||The longitude of the city/town.|
||The state or territory's USPS postal abbreviation.|
||The name of the state or territory that contains the city/town.|
||The 5-digit FIPS code for the county. The first two digits correspond to the state's FIPS code.|
||The name of the county (or equivalent) that contains the city/town.|
||An estimate of the city's urban population as measured by the Census. 2016 data (when available).|
||An estimate of the city's municipal population as measured by the Census. 2016 data (when available).|
||The number of people per square kilometer.
||For some cities, our data is generated from a polygon representing the city, for others we simply have a point.|
||TRUE if the place is a city/town. FALSE if the place is just a commonly known name for a populated area.|
||The city's timezone in the tz database format. (e.g. America/Los_Angeles)|
||A string containing all five-digit zip codes in the city/town, delimited by a space. Learn more.|
||A 10-digit unique id generated by SimpleMaps. It is consistent across releases and databases (e.g. World Cities Database).|
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.
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 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.
We've published free formulas in popular programming languages. Check them out.