United Kingdom Business Database, Yellow Pages Database, 400,000 Records

Database Description:

With over 380,000 distinct records of UK based businesses, readily accessible by business classification, location and type, it is a business directory coming with the contact information you need such as detailed street addresses and phone numbers. The whole database consists of 4 tables, helping data fetcher navigate through all the records more easily by adding business classification, location and type.

Prospective Applications / Implementations:

• UK yellow pages look up site
• UK business directory
• Marketing needs
• ...Order a custom build

Database Meta:

• Size: 86.2 MB
• Last updated: July 17th, 2008
• Format: MySQL 5, compressed SQL text file
• Tables: 4

phpMyAdmin Screenshots:

Table Details:

• classifications

  Records:874

  Business classifications table is comprised of a total of 874 distinct company classifications organized in a 3-level pyramid structure.

  Table fields

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

• listings

  Records:381911

  Actual yellow pages business listings table.

  Table fields

  1. id: int(10)
  2. title: varchar(255)
  3. address: text
  4. tel: varchar(255)
  5. classification: smallint(5)
  6. location: smallint(5)
  7. type: smallint(5)

• locations

  Records:1705

  UK locations table for local business search.

  Table fields

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

• types

  Records:1474

  Business types table.

  Table fields

  1. id: smallint(5)
  2. letter: tinytext
  3. title: varchar(255)
  4. url: varchar(255)
  5. count: smallint(5)

Purchase: $489.95 (USD)