City List with Coordinates
Every U.S. city with the geography you need to map it — centroid coordinates, geohash, elevation, ZIP codes, timezone, and metro area.
Why teams buy the list instead of building one
Three reasons teams buy a dataset 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 single-seat 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 |
|---|---|---|
| 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. |
| state_name | text | Full U.S. state or territory name. |
| county_name | text | Primary (largest-overlap) county. |
| incorporated | boolean | TRUE for legally incorporated US municipalities (city, town, village, borough). FALSE for CDPs, consolidated-city balances, townships, and Puerto Rico unincorporated communities. |
| lat | number | Centroid latitude (ZIP-mean; interior-point fallback). |
| lng | number | Centroid longitude. |
| geohash_1 … geohash_8 | text | Progressive geohash prefixes from the centroid (8 columns). |
| elevation_ft | number | Ground elevation at the centroid. |
| land_area_pct | number | Land share of total area. |
| water_area_pct | number | Water share of total area. |
| zip_codes | text | Space-delimited list of member ZIPs. |
| timezone | text | IANA timezone from the centroid. |
| cbsa_name | text | Core-Based Statistical Area the city sits in. |
A UTF-8 CSV inside a .zip. It opens in Excel, Google Sheets, databases, BI tools, and any programming language.
Every dataset ships under a single-seat 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 U.S. city
on the map.
48,490 cities with the columns you need — one clean spreadsheet. $29 one-time, instant download, single-seat commercial license.