Welcome to UK Business Listing Database
Please pay attention that this is the NEW and UPDATED UK Business Listing Database version with new additional records(over 1 million  )
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.093.210
Price: 79$
Regards
|
new updated UK Business Listing Database - 1.093.210 RECORDS!!!
