Ohio Yellow Pages Database

« Back to US Phone Number Home

Database Description:

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

Prospective Applications / Implementations:

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