Hotels - SQL Database

Download free Hotels - SQL Database. List of hotels to build your website or application.

Hotels - SQL Database
Hotels - SQL Database

Hotels database. Contact information, location.

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;

Example table.

'Hotels & Motels', 'Hotels', 'Holiday Inn Ft Collins', '3836 East Mulberry', 'Fort Collins', 'CO', '80524', '(970)484-4660', '(970)484-2326', NULL, NULL, '970', '08069', 'MST', 'Y', '40.6475', '-105.0476', '2670', NULL, 'Larimer'