Welcome to UK Business Listing Database
Please pay attention that this is the NEWEST and UPDATED UK Business Listing Database version with new additional records(over 1,5 million records in totally )
So, this database is the new version of my old UK Business Listing Database
For the references, here my previous OLD sales for UK Business Listings:
BUT THIS DATABASE HAS 1.572.597 RECORDS EXACTLY as you see the details at the below.
For my old customers for the old UK Business Listing Database;
I don't forget you, so this is the difference from other suppliers that also my old customers are very valueable for me. If you send a p.m to me , I'll help you about it.
This database is extremely awesome for UK websites.
Here the fields list which it includes:
1) ID
2) CAT
3) NAME
4) ADDRESS1
5) ADDRESS2EXTRA
6) ADDRESS3EXTRA
7) TOWN
8) COUNTRY
9) BUSINESS CATEGORY (this is the best field that you'll help)
10) POSTCODE
11) TELEPHONE
Address2 and
Address3 are extra fields for you.
Structure is here:
PHP Code:
CREATE TABLE `UKbusiness` (
`id` bigint(20) NOT NULL auto_increment,
`cat` varchar(50) NOT NULL default '',
`name` varchar(255) character set utf8 collate utf8 NOT NULL default '',
`address1` text character set utf8 collate utf8 NOT NULL,
`address2extra` text character set utf8 collate utf8,
`address3extra` text character set utf8 collate utf8,
`town` text character set utf8 collate utf8,
`country` text character set utf8 collate utf8,
`businesscategory` text character set utf8 collate utf8,
`postcode` text character set utf8 collate utf8,
`telephone` text character set utf8 collate utf8,
PRIMARY KEY (`id`),
KEY `cat_index` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1093211 ;
Sample from the db:
PHP Code:
INSERT INTO `UKbusiness` VALUES (33115, 'Q', 'Quality Fabrications', 'Unit E Smarden Business Est', '', '', 'Ashford', 'KENT', 'Sheet Metal Work', 'TN27 8QL', '01233 770702');
Records: 1.572.597
Price: 79$
Filetype: SQL
Regards