United Kingdom Business Directory Yellow Pages Database (380,000 Phone Numbers)

Database Description:

With over 380,000 unique records of UK based businesses, readily accessible by business classification, location and type, this is a yellow pages database filled with the business contact information such as detailed street addresses and phone numbers. The whole database consists of 4 tables.

Database Meta:

• Size: 54.7 MB
• Last updated: Mar. 21st, 2011
• 3 Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 4

Buy Now & Download: $49.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• classifications

  Records:874

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

  Data fields

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

• listings

  Records:381,911

  Actual yellow pages business listings table with all the businesses in UK.

  Data fields

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

• locations

  Records:1,705

  UK locations table containing counties and towns, for local business search.

  Data fields

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

• types

  Records:1,474

  Business types table containing all the business categories.

  Data fields

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

Buy Now & Download: $49.95 (USD)

Prospective Applications / Implementations:

• Online UK yellow pages directory
• UK business directory
• UK phone numbers directory
• Telephone marketing targeted at the UK market
• ...Order a custom build

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 $175)
• Single Table Format (Extra $100)