Advertising Agencies & Counselors - Suppliers and Dealers across US

« Back to US Phone Number Home

Database Description:

US yellow pages database of Advertising Agencies & Counselors is a phone number database contains contact information such as phone number and postal address of Advertising Agencies & Counselors suppliers, manufacturers, stores, companies and dealers across United States.

Prospective Applications / Implementations:

• Advertising Agencies & Counselors yellow pages site
• Online phone book of Advertising Agencies & Counselors providers
• Local classified information portal of Advertising Agencies & Counselors
• Advertising Agencies & Counselors business directory
• Phone number lookup & search of Advertising Agencies & Counselors businesses
• Marketing campaign targeted at Advertising Agencies & Counselors businesses
• Advertising Agencies & Counselors business information site enhancement
• Advertising Agencies & Counselors business search site
• Advertising Agencies & Counselors 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