UK Business Directory

United Kingdom Business Directory Yellow Pages Database (Phone Numbers)

Data Structure

business [348,814]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ phone (100%)
varchar(30)
+ zip_code (99.7%)
varchar(255)
+ address (100%)
category [8]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
int(11)
+ count (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
city [61]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
int(11)
+ count (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
sub_category [135]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
int(11)
+ count (100%)
bigint(20) unsigned
+ category_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
sub_category_to_city_to_business [740,506]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ sub_category_id (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ business_id (100%)

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.

Data Profile

Size 173.05M
Tables 5
Last Commit 2016-12-07 00:34:47

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:34:47 173.05M 5 27 1089524
2016-08-30 05:52:52 173.05M 5 27 1089524

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
business 348,814 .001 348.814
category 8 .001 0.008
city 61 .001 0.061
sub_category 135 .001 0.135
sub_category_to_city_to_business 740,506 .001 740.506
Total Credits 1089.524 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.