One payment, lifetime updates. Come back once in a while to stay updated of new versions of this database.

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 5 SQL dump text file, CSV, MS Excel
  • Tables: 5

Buy Now & Download: $189.95 (USD)


phpMyAdmin Screenshots:

MySQL Database: United Kingdom Business Directory Yellow Pages Database (327,418 Phone Numbers) for Sale

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: $189.95 (USD)



Download link will be automatically sent to your PayPal email. Please check the spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive the download link 10 minutes after payment. We will manually send the download details as soon as we see your message. Our delivery / support staff work in the time zone of GMT+8.

Instant automatic download upon payment success, just press return button on PayPal website after finishing payment.

Prospective Applications / Implementations:

  • 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

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the URL we sent to you, you can download updated versions free.