Complete United States Gazetteer of 50 States, 3,141 Counties and 175,195 Local Towns / Cities / Settlements / Populated Places Place Names

Database Description:

This is the complete United States gazetteer 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.

Prospective Applications / Implementations:

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

Database Meta:

• Size: 11.3 MB
• Last updated: May 7th, 2009
• Available Formats: MySQL 5 SQL text file, CSV for MS Excel
• Tables: 3

phpMyAdmin Screenshots:

Table Details:

• state

  Records:50

  Table containing all United States states name and url stub.

  Table fields

  1. id: tinyint(4)
  2. title: varchar(255)
  3. slug: varchar(255)

• county

  Records:3141

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

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. state: tinyint(4)

• place

  Records:175195

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

  Table fields

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

Purchase: $49.95 (USD)

Other Available Formats:

After purchase, please contact us for any of the specific data formats listed below and we will send it right away.

• 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 (Extra $400)