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:

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)

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