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:

Complete List of 25,726 United States Cities & Towns

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)

 

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