United States Business Yellow Pages Database

Database Description:

If you are ever in need of a huge database of US based companies, with over 3.4 million records, this one is it.

Prospective Applications / Implementations:

• US yellow pages site
• US business directory
• Marketing needs
• Business information site enhancement
• Business search site
• Business reverse phone lookup
• ...Order a custom build

Database Meta:

• Size: 390.6 MB
• Last updated: Dec. 1st, 2008
• Format: MySQL 5, compressed SQL text file
• Tables: 7

phpMyAdmin Screenshots:

Table Details:

• category

  Records:27

  Level 1 categorization.

  Table fields

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

• city

  Records:26170

  US cities and towns.

  Table fields

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

• listing

  Records:3477656

  Table containing all the company listings.

  Table fields

  1. id: int(11)
  2. title: varchar(255)
  3. phone: varchar(255)
  4. address: varchar(255)
  5. subcategory2city: mediumint(9)

• state

  Records:50

  All US states.

  Table fields

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

• subcategory

  Records:284

  Level 2 categorization.

  Table fields

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

• subcategory2city

  Records:585069

  Relational table of subcategory to city.

  Table fields

  1. id: mediumint(9)
  2. subcategory: smallint(6)
  3. city: smallint(6)

• subcategory2state

  Records:13084

  Relational table of subcategory to state.

  Table fields

  1. id: mediumint(9)
  2. subcategory: smallint(6)
  3. state: smallint(6)

Purchase: $789.95 (USD)