Michigan Yellow Pages Database

« Back to US Phone Number Home

Database Description:

Yellow pages Michigan database is a business directory of manufacturers, companies, stores, dealers, suppliers in Michigan. Phone number database of all businesses.

Prospective Applications / Implementations:

• Michigan yellow pages site
• Online phone book of Michigan providers
• Local classified information portal of Michigan
• Michigan business directory
• Phone number lookup & search of Michigan businesses
• Marketing campaign targeted at Michigan businesses
• Michigan business information site enhancement
• Michigan business search site
• Michigan reverse phone lookup
• ...Order a custom build

Database Meta:

• Listing records: Contact us for the number of total records.
• Last updated: Mar. 2nd, 2009
• Format: MySQL 5 SQL text file, CSV for MS Excel
• Tables: 7

phpMyAdmin Screenshots (Mother Database):

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:Inquire

  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)

Price(USD): Inquire