United Kingdom Business Directory Yellow Pages Database (327,418 Phone Numbers)

Database Description:

This is the 2nd edition of our UK yellow pages database that has 348,814 businesses listed across the United Kingdom. There are a total of 327,418 unique phone numbers, readily accessible by 8 business categories, and further by 135 sub-categories from 61 major cities / towns.This is a yellow pages database filled with business contact information such as postal codes, detailed street addresses and phone numbers. The whole database consists of 5 associated tables.

This database does not have emails. For emails, check out this UK business emails list.

Database Meta:

• Size: 97.40 MB
• Last updated: Dec. 22nd 2012
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 5

Buy Now & Download: $259.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• business

  Records:348,814

  Business listings table.

  Data fields

  1. id: int(10) unsigned
  2. title: varchar(255)
  3. phone: varchar(255)
  4. zip_code: varchar(30)
  5. address: varchar(255)

• category

  Records:8

  Top categories of the businesses.

  Data fields

  1. id: int(10) unsigned
  2. count: int(11)
  3. title: varchar(255)
  4. slug: varchar(255)

• city

  Records:61

  Cities in UK.

  Data fields

  1. id: int(10) unsigned
  2. count: int(11)
  3. title: varchar(255)
  4. slug: varchar(255)

• sub_category

  Records:135

  Sub-categories for the businesses.

  Data fields

  1. id: int(10) unsigned
  2. count: int(11)
  3. category_id: int(11)
  4. title: varchar(255)
  5. slug: varchar(255)

• sub_category_to_city_to_business

  Records:740,506

  Relationships table for businesses in a specific city and under a specific sub-category.

  Data fields

  1. id: int(10) unsigned
  2. sub_category_id: int(11)
  3. city_id: int(11)
  4. business_id: int(11)

Buy Now & Download: $259.00 (USD)

Potential Applications / Usage:

• Online UK yellow pages directory
• UK business directory
• UK phone numbers directory
• Telephone marketing targeted at the UK market

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• 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
• Single Table Format