Complete List of 25,726 United States Cities & Towns

Database Description:

Database of 50 states and 26,000 cities / towns of United States.

Prospective Applications / Implementations:

• Local yellow pages sites
• City-related guides
• Traveling sites
• National information site
• ...Order a custom build

Database Meta:

• Size: 2.5 MB
• Last updated: Oct. 21th, 2008
• Format: MySQL 5, compressed SQL text file
• Tables: 2

phpMyAdmin Screenshots:

Table Details:

• state

  Records:50

  Table containing all United States states name and url stub.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. url: varchar(255)

• city

  Records:25726

  Table containing all United States cities and towns, related to states, arranged / indexed by initial letter with unique url stubs.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. url: varchar(255)
  4. state: smallint(6)
  5. letter: char(1)
  6. url2: varchar(255)

Purchase: $49.95 (USD)