Usage & Publication License: database price dollar sign199.00

39,737 US Hotels and Inns Database (141,040 Reviews)

All US hotels and inns information database with customer reviews and 3.77GB hotel photos

database structure screenshot of 39,737 US Hotels and Inns Database (141,040 Reviews)

Description: This is a complete database collection of all United States hotels and inns, 39,737 of them, from 13,353 travel destinations in 51 states. Each hotel record consists of multiple customer reviews (141,040 in total) and dozens of JPEG photo pictures of the rooms, views, dinners, swimming pools, gym and other facilities, which weighs 3.77GB.

Related DBs:

Database Statistics

  • Size: 133.00 MB
  • Tables: 4
  • Records: 141,040
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Images Statistics

  • Images: 3.86G
  • Dimensions: 300 x 200 on average
  • Image formats: JPEG
  • Images count: 227,175
  • Reference field: id

Database Structure

Table Records Fields
destination 13,353
  1. id
  2. title
  3. slug
  4. state
hotel 39,737
  1. id
  2. title
  3. slug
  4. price
  5. destination
  6. address
review 141,040
  1. id
  2. title
  3. rating
  4. author
  5. date
  6. content
  7. hotel
state 51
  1. id
  2. title
  3. slug

Database Attachments

Images: This database is attached with 227,175 images. See them under the Attachments tab.


Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

state

  • Alabama
  • Kentucky
  • North Dakota
  • Alaska
  • Louisiana
  • Ohio
  • Arizona
  • Maine
  • Oklahoma
  • Arkansas
  • Maryland
  • Oregon
  • California
  • Massachusetts
  • Pennsylvania
  • Colorado
  • Michigan
  • Rhode Island
  • Connecticut
  • Minnesota
  • South Carolina
  • Delaware
  • Mississippi
  • South Dakota
  • District of Columbia
  • Missouri
  • Tennessee
  • Florida
  • Montana
  • Texas
  • Georgia
  • Nebraska
  • Utah
  • Hawaii
  • Nevada
  • Vermont
  • Idaho
  • New Hampshire
  • Virginia
  • Illinois
  • New Jersey
  • Washington
  • Indiana
  • New Mexico
  • West Virginia
  • Iowa
  • New York
  • Wisconsin
  • Kansas
  • North Carolina
  • Wyoming

Miscellaneous

Notes:

  • After you have unzipped the photos package, there will be 22,379 directories / folders, each with the hotel id as its name.
  • 22,379 hotels and inns have photo images. On average, each hotel or inn has 10 photos.

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email: info@UsableDatabases.com

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. What prints, printer or milk?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.