Usage & Publication License: database price dollar sign195.00

Database of 348,814 Businesses Yellow Pages in UK

348,814 UK business directory yellow pages database with 327,418 unique phone numbers

database structure screenshot of Database of 348,814 Businesses Yellow Pages in UK

Description: With 348,814 business records (327,418 unique phone numbers & 35k mobile phone numbers) of United Kingdom, classified by 8 categories (Business Services, Entertainment, Health & Beauty, Home Improvement, Motoring, Moving Home, Property and Shopping) and further into 135 sub-categories, this 348,814 business directory Yellow Pages Database is filled with business contact information such as phone numbers and detailed street addresses across 61 cities in UK. The whole database consists of 5 tables.

Related DBs:

Database Statistics

  • Size: 97.40 MB
  • Tables: 5
  • Records: 348,814
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
business 348,814
  1. id
  2. title
  3. phone
  4. zip_code
  5. address
category 8
  1. id
  2. count
  3. title
  4. slug
city 61
  1. id
  2. count
  3. title
  4. slug
sub_category 135
  1. id
  2. count
  3. category_id
  4. title
  5. slug
sub_category_to_city_to_business 740,506
  1. id
  2. sub_category_id
  3. city_id
  4. business_id

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

category

  • Business Services - 171,704
  • Entertainment - 99,685
  • Health & Beauty - 99,330
  • Home Improvement - 137,617
  • Motoring - 90,057
  • Moving Home - 27,272
  • Property - 75,395
  • Shopping - 39,446
  • - 0

sub_category

  • Accountants - 10,499
  • Book Keepers - 4,649
  • Cleaners - 6,659
  • Cleaning Services - 6,664
  • Commercial Cleaning Services - 6,017
  • Computer Consultants - 3,544
  • Computer Repairs - 7,057
  • Computer Services - 4,972
  • Computer Support - 9,421
  • Creches - 6,213
  • Driving Instructors - 10,498
  • Driving Schools - 10,492
  • Florists - 7,650
  • Funeral Directors - 5,781
  • Funeral Services - 6,200
  • Glass Replacement - 704
  • Glaziers - 2,294
  • Halls For Hire - 2,206
  • Industrial and Business Removals - 726
  • Joiners - 5,401
  • Locksmiths - 6,158
  • Nursery Schools - 6,163
  • Photographers - 7,895
  • Post Offices - 8,305
  • Printers - 8,083
  • Rubbish Clearance - 4,057
  • Skip Hire - 3,858
  • Solicitors - 9,538
  • Bars - 11,972
  • Bed and Breakfast - 1,613
  • Caterers - 5,354
  • Chinese Restaurants - 3,059
  • Chip Shops - 8,190
  • English Restaurants - 4,011
  • Guest Houses - 5,217
  • Hotels - 8,333
  • Indian Restaurants - 7,024
  • Italian Restaurants - 3,739
  • Pub Restaurants - 12,039
  • Pubs - 11,974
  • Riding Schools - 2,632
  • Self Catering holiday Accommodation - 2,221
  • Stables - 471
  • Take Aways - 11,836
  • Beauticians - 1,419
  • Beauty Consultants - 3,479
  • Beauty Salons - 9,723
  • Beauty Specialists - 10,208
  • Chiropodists - 4,716
  • Dentists - 10,649
  • Doctors - 12,002
  • Hair Extensions Wigs - 1,140
  • Hair Stylists - 11,688
  • Hairdressers - 12,145
  • Ladies Hairdressers - 4,409
  • Mens Hairdressers - 3,707
  • Podiatrists - 4,696
  • Veterinary Surgeons - 4,685
  • Vets - 4,664
  • Architects - 5,765
  • Auto Electricians - 1,064
  • Builders - 11,182
  • Building Services - 3,027
  • Carpenters - 4,672
  • Double Glazing Installers - 6,223
  • Electricians - 10,849
  • Fencing Contractors - 3,329
  • Fireplaces - 1,868
  • Flooring Services - 3,807
  • Garage Services - 11,313
  • Garden Centres - 3,461
  • Garden Design - 7,500
  • Garden Sheds - 796
  • Gardeners - 6,904
  • Gardening Services - 6,896
  • Handyman Services - 2,188
  • Kitchen Installation - 6,709
  • Laminate Flooring - 4,486
  • Painters and Decorators - 10,012
  • Plumbers - 10,452
  • Roofing Services - 8,818
  • Sash Windows - 6,296
  • Cabs - 2,007
  • Car Accessories - 4,990
  • Car Air Conditioning - 1,537
  • Car Body Repairs - 7,045
  • Car Breakers - 1,958
  • Car Dealers - 7,190
  • Car Dismantlers - 7,219
  • Car Engine Services - 11,314
  • Car Parts - 4,807
  • Car Rental - 2,796
  • Car Valeting - 2,472
  • Chauffeurs - 1,999
  • Exhaust Repairs - 693
  • Mini Cabs - 1,221
  • Mot Testing - 5,618
  • Taxis - 9,174
  • Truck hire - 1,842
  • Tyre Dealers - 6,543
  • Used Cars - 7,177
  • Van Hire - 2,455
  • Estate Agents - 9,616
  • Household Removals - 5,558
  • Letting Agents - 7,408
  • Overseas Removals - 267
  • Property Management - 4,423
  • Boiler Repairs - 2,141
  • Boilers Servicing - 2,105
  • Builders Merchants - 4,263
  • Building Supplies - 4,280
  • Central Heating Installation - 6,491
  • Central Heating Servicing - 6,487
  • Chimney Sweeps - 1,386
  • Double Glazing Repairs - 1,245
  • Double Glazing Suppliers - 1,081
  • Electrical Engineers - 1,950
  • Electrical Inspecting - 7,781
  • Electrical Testing - 10,898
  • Electrical Wholesalers - 1,403
  • Plumbing supplies - 359
  • Property Maintenance - 5,976
  • Property Repairs - 6,314
  • Replacement Boilers - 2,111
  • Window Cleaners - 3,556
  • Window Repairs - 824
  • Window Replacement - 823
  • Wood Flooring - 3,921
  • Bridal Shops - 2,496
  • Holiday Companies - 7,283
  • Pet Shops - 3,907
  • Pet Supplies - 3,890
  • Travel Agents - 7,297
  • Wedding Services - 7,286
  • Wedding Suppliers - 7,287
  • - 0

One Payment, Lifetime Updates

This database is being constantly updated with regards to the volume and structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out. You can download the updated version from the Download page by the same credentials we sent to you when you made the purchase, for a lifetime.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries.

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. Is a boy female or male?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.