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: Mar. 15th, 2009
• Available Formats: MySQL 5 SQL text file, CSV for MS Excel
• 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: $789.95 (USD)

Other Available Formats:

After purchase, please contact us for any of the specific data formats listed below and we will send it right away.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database (Extra $400)