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: July 17th, 2008
- Format: MySQL 5, compressed SQL text file
- Tables: 4
phpMyAdmin Screenshots:

Table Details:
-
classifications
Records:874Business classifications table is comprised of a total of 874 distinct company classifications organized in a 3-level pyramid structure.
Table fields
- id: smallint(5)
- title: varchar(255)
- parent_id: smallint(5)
- url: varchar(255)
- count: smallint(5)
-
listings
Records:381911Actual yellow pages business listings table.
Table fields
- id: int(10)
- title: varchar(255)
- address: text
- tel: varchar(255)
- classification: smallint(5)
- location: smallint(5)
- type: smallint(5)
-
locations
Records:1705UK locations table for local business search.
Table fields
- id: smallint(5)
- title: varchar(255)
- parent_id: smallint(5)
- url: varchar(255)
- count: smallint(5)
-
types
Records:1474Business types table.
Table fields
- id: smallint(5)
- letter: tinytext
- title: varchar(255)
- url: varchar(255)
- count: smallint(5)
Purchase: $489.95 (USD)
Instant automatic download upon payment success, just press return button on PayPal website after finishing payment.