eMarketMarket- Content for Web

A comprehensive database list of hotels worldwide. A total of at least 100,000 records with info like category,address,website,email,country, etc. This is in SQL format ready to dump into your SQL server.

The table structure is as follows:

CREATE TABLE `BIZ_HOTELS_MOTELS` (
  `bizID` INTEGER,
  `bizCat` VARCHAR(255),
  `bizCatSub` VARCHAR(255),
  `bizName` VARCHAR(255),
  `bizAddr` VARCHAR(255),
  `bizCity` VARCHAR(255),
  `bizState` VARCHAR(255),
  `bizZip` VARCHAR(255),
  `bizPhone` VARCHAR(255),
  `bizFax` VARCHAR(255),
  `bizEmail` VARCHAR(255),
  `bizURL` VARCHAR(255),
  `locAreaCode` VARCHAR(3),
  `locFIPS` VARCHAR(5),
  `locTimeZone` VARCHAR(6),
  `locDST` VARCHAR(1),
  `locLat` VARCHAR(10),
  `locLong` VARCHAR(10),
  `locMSA` VARCHAR(5),
  `locPMSA` VARCHAR(5),
  `locCounty` VARCHAR(30)
) TYPE=MyISAM;
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (103699, 'Hotels & Motels', 'Motels', 'Aaa Residence Inn', '3721 Watt Ave', 'Sacramento', 'CA', '95821', '(916)485-7125', NULL, NULL, NULL, '916', '06067', 'PST', 'Y', '38.6234', '-121.3827', NULL, '6920', 'Sacramento');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (103700, 'Hotels & Motels', 'Accommodations', 'Holiday Inn Express and Suites', '8101 Peach Street', 'Erie', 'PA', '16509', '(814)217-1100', NULL, NULL, 'www.ichotelsgroup.com/redirect?&path=hd&brandCode=ex&hotelCode=ERIPE&_IATAno=99601994', '814', '42049', 'EST', 'Y', '42.0595', '-80.0430', '2360', NULL, 'Erie');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (103701, 'Hotels & Motels', 'Accommodations', 'Silver Court', '509 Maple Street', 'Kadoka', 'SD', '57543', '(605)837-2361', NULL, NULL, NULL, '605', '46071', 'MST', 'Y', '43.8719', '-101.6807', NULL, NULL, 'Jackson');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (103702, 'Hotels & Motels', 'Hotels', 'Amsterdam Court Hotel', '226 West 50th Street', 'New York', 'NY', '10019', '(212)956-9268', NULL, NULL, NULL, '212', '36061', 'EST', 'Y', '40.7652', '-73.9853', NULL, '5600', 'New York');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (103703, 'Hotels & Motels', 'Accommodations', 'Jameson Inn', '226 Hitec Road', 'Seneca', 'SC', '29678', '(864)888-8300', NULL, NULL, 'www.jamesoninn.com', '864', '45073', 'EST', 'Y', '34.6760', '-82.9254', NULL, NULL, 'Oconee');