City List with Coordinates
Map-ready coordinates for 48,490 cities, towns, and other places in the 50 states, DC, and Puerto Rico, plus elevation, ZIP codes, time zone, and metro area.
Why teams buy the list instead of building one
Three reasons teams buy a List instead of building one.
Straight from the federal record
Every column traces to an official source — the U.S. Census Bureau, HUD, and the Department of the Interior. Compiled and cleaned, not scraped. Delivered as a spreadsheet the moment you check out.
A company-wide commercial license
Use it in personal, business, and commercial projects — no subscription, no recurring fees, no user limits, and no attribution required. Buy once; use it whenever.
Clean, and built to join
Consistent place names and FIPS keys mean it opens in Excel, Google Sheets, or any database and drops straight into your data. The City, County, and ZIP lists share those keys, so they join to each other too.
Every column in the file, typed and documented. Want to start building before you buy? Download a 100-row sample — the real database with real values, free to integrate against.
| CSV column | Type | What it represents |
|---|---|---|
| id | number | Unique per-row identifier assigned by the data vendor for this data vintage — the join key to the matching row in City List – Demographics. |
| fips_place_code | text | Place GEOID (state + place FIPS); functioning townships use the 10-digit county-subdivision GEOID. |
| name | text | Cleaned, consumer-facing place name. |
| name_ascii | text | Plain-ASCII version of name, with accents and special characters removed — used for case/accent-insensitive matching and joins. |
| state_code | text | USPS two-letter state or territory code. |
| state_name | text | Full U.S. state or territory name. |
| type | text | Census/vendor place-type code. Values in the current data: balance, borough, cdp, city, comunidad, consolidated_city, town, township, village, and zona_urbana (the last two are Puerto Rico designations). |
| incorporated | boolean | TRUE for legally incorporated US municipalities (city, town, village, borough). FALSE for CDPs, consolidated-city balances, townships, and Puerto Rico unincorporated communities. |
| county_fips | text | The city's main county (5-digit FIPS code). Cities that span several counties list the primary one; blank for Washington, DC and a handful of places without a county on file (the lat/lng still supports spatial joins). |
| county_name | text | Primary (largest-overlap) county. |
| population | number | Latest population estimate (2024 vintage). Blank for CDPs and other localities without an annual estimate. |
| lat | number | Latitude of a single point chosen to represent the city — not a street address, and not a guaranteed center. |
| lng | number | Longitude of that same point. |
| geohash_1 … geohash_8 | text | Progressive geohash prefixes for that same point (8 columns). |
| elevation_ft | number | Elevation at a single representative point for the city. A city does not have one single elevation, and the figure depends on which point is measured. Blank where no elevation could be determined. |
| land_area_sqmi | number | Land area in square miles; land_area_pct is this value's share of the city's total area. |
| water_area_sqmi | number | Water area in square miles; water_area_pct is this value's share of the city's total area. |
| land_area_pct | number | Land share of total area. |
| water_area_pct | number | Water share of total area. |
| timezone | text | IANA timezone for that same point. |
| cbsa_name | text | Core-Based Statistical Area the city sits in. |
| zip_codes | text | Space-delimited list of member ZIPs. |
A UTF-8 CSV inside a .zip. It opens in Excel, Google Sheets, databases, BI tools, and any programming language.
Every List ships under a company-wide commercial license — use it in personal, business, and commercial projects. No subscriptions or user limits.
Annually, as the underlying federal releases publish. Your purchase is the current vintage at download time.
An instant, secure download link, valid for 30 days. No account required.
Because the data is delivered instantly as a download, sales are final. If a file is corrupt or incorrect, email us and we'll make it right.
Put every city in the list
on the map.
48,490 cities with the columns you need — one clean spreadsheet. $29 one-time, instant download, company-wide commercial license.