Ideally something free will work but I'm willing to pay for it if its not too expensive and its complete.
A simple, accurate, and up-to-date database of United States cities and towns, built from the ground up using authoritative sources such as the U.S. Geological Survey and U.S. Census Bureau.
- Up-to-date: Data updated as of November 18, 2020.
- Comprehensive: Over 108,000 cities and towns from all 50 states, DC, Puerto Rico, and the US Virgin Islands.
- Useful fields: From latitude and longitude to household income.
- Accurate: Aggregated and cleaned from official sources.
- Simple: A single CSV file, concise field names, only one entry per city/town.
The Basic (free) database will meet many users' needs. You may want to purchase the Pro or Comprehensive versions if:
- You need data for rural towns/villages or places that aren't incorporated municipalities.
- You need demographic data such as age, race, education, or income.
- You don't want to (or can't) attribute your use of our data on a public-facing website.
The SQL file contains two tables:
US_STATES: ID, STATE_CODE, and STATE_NAME.
US_CITIES: ID, ID_STATE, CITY, COUNTY, LATITUDE, and LONGITUDE.
The US_CITIES table has all (or almost all) cities from the United States.
The U.S. Census Bureau is the authoritative government agency that has been tasked with managing national data about governments (state, local, and municipal) and the boundaries that they claim.
The latest data includes administrative boundaries for cities, towns, and CDP's (Census Designated Places). What is a CDP? Think of them as an area that is not a city/town nor is incorporated but is recognized as a distinct area for which to produce economic/social estimates.
If you're feeling adventurous and want to look through the boundaries shapefile joined with an abundance of demographic/social/economic estimates through their American Community Survey you might be able to delve into their Demographic Profile series in this directory.