Lifetime updates. Come back once in a while to stay updated of new versions of this database.

United States Gazetteer (Cities) Database of 3,141 Counties and 175,195 Local Towns / Cities / Settlements Place Names

Database Description:

This is the complete United States gazetteer (cities) database created from the official records released by federal government. Table county contains all census designated places (areas) with more than 25,000 population, any town, neighborhood or community (Populated Places) under this criterion but have an official federally recognized name is included as a unique entry in the place table.

Database Meta:

  • Size: 11.3 MB
  • Last updated: Sep. 10th, 2011
  • Formats Included: MySQL dump .sql text file, CSV, MS Excel
  • Tables: 3

Buy Now & Download: $69.00 (USD)


phpMyAdmin Screenshots:

MySQL Database: United States Gazetteer (Cities) Database of 3,141 Counties and 175,195 Local Towns / Cities / Settlements Place Names for Sale

Table Details (Data Structure / Schema):

  • state
    Records:50

    Table containing all United States states name and url stub.

    Data fields

    1. id: tinyint(4)
    2. title: varchar(255)
    3. slug: varchar(255)
  • county
    Records:3,141

    Table containing all United States counties, each related to one of the 50 states by id.

    Data fields

    1. id: smallint(6)
    2. title: varchar(255)
    3. slug: varchar(255)
    4. state: tinyint(4)
  • place
    Records:175,195

    Table containing all United States local cities and towns, each related to one of the 3,141 counties by id.

    Data fields

    1. id: mediumint(9)
    2. title: varchar(255)
    3. slug: varchar(255)
    4. county: smallint(6)

Buy Now & Download: $69.00 (USD)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

Potential Applications / Usage:

  • Local yellow pages sites
  • City-related guides
  • Traveling sites
  • National information site
  • Place names lists / drop-downs for HTML forms

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

  • Plain CSV
  • CSV for Microsoft Excel
  • Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
  • Microsoft Word .DOC file (2008, 2007, 2003, 2000)
  • LaTeX
  • Open Document Spreadsheet
  • Open Document Text
  • PDF
  • XML
  • YAML
  • WordPress Category / Post Database
  • Single Table Format

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.