39,862 United States Hotels & Local Inn / Suites Database with 141,496 Hotel Reviews

Database Description:

A premium database of nearly 40,000 hotels in United States, from 14,000 US cities and towns across 50 states and Columbia District, with up to 5 reviews for each of them. In addition to the database of nearly 200 MB text information, after purchase, you will also be able to download a package of over 240,000 hotel pictures and interior room photos (4.0 GB) referenced by the ID of each of the hotels in the database. That's 6 photos of each of the hotels on average.

Prospective Applications / Implementations:

• Travel site information enhancement
• Local information site enhancement
• US hotels directory
• US hotels review site
• ...Order a custom build

Database Meta:

• Size: 163.3 + 4052.0 MB
• Last updated: Mar. 2nd, 2010
• Available Formats: MySQL 5 SQL text file, CSV for MS Excel
• Tables: 4

phpMyAdmin Screenshots:

Table Details:

• destination

  Records:13354

  County, city, town or any visitworthy place with at least 1 hotel.

  Table fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. state: smallint(6)

• hotel

  Records:39862

  Hotel listings.

  Table fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. price: smallint(6)
  5. destination: mediumint(9)
  6. address: varchar(255)

• review

  Records:141496

  Hotel reviews for each of the hotels.

  Table fields

  1. id: int(11)
  2. title: varchar(255)
  3. rating: tinyint(4)
  4. author: varchar(255)
  5. date: varchar(255)
  6. content: text
  7. hotel: mediumint(9)

• state

  Records:51

  Table of 50 states and Columbia District.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)

Purchase: $489.95 (USD)

Other Available Formats:

After purchase, please contact us for any of the specific data formats listed below and we will send it right away.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database (Extra $400)