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'

 



on the site are taken from open sources. The site does not contain files for download. All links to files from open sources. Owners of copyrights to the material may request removal of the post from the site.