As we frequently enhance our databases, make sure you revisit from time to time to stay updated of the databases you have purchased. Simply by clicking through the URL we have sent, you can download the new versions anytime.

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:

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:

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

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)


 

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

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)