208,065 World Hotels Database with Photo Images by City, State, Country

Database Description:

This is a comprehensive world hotels / global travel accommodations database that is well structured with a wide range of data fields. There are a total of 208,065 international hotels (383 global or local hotel chains) from 198 countries, 151 states / sub-national areas and 47,853 world famous cities.

Every hotel is identified by hotelstar, city, state, country, street address, minimal rate, latitude, longitude, property type, chain, facilities, popularity rank, checkin and checkout hours. Each hotel has a detailed text description and up to 2 image pictures of about 350x350 in resolution. Each hotel has 7 different review ratings by customers: overall, cleanliness, service, facilities, location, dining and rooms.

There are also 21,359 sightseeing attractions / travel-worthy locations in each city with precise latitude and longitude so you can calculate the distance from any of the hotels to the tourist attractions.

Hotel property types: Hotel, Motel, Inn, Bed & Breakfast, Vacation Rental, Hostel, Retreat, Resort, Other, Apartment.

Location types: Airport, Attraction, Beach, Business Area, Convention Centre, District, Institution, Landmark or Monument, Marina, Museum, Park, Popular Area, Shopping Area, Stadium or Arena, Theatre, Train Station.

Database Meta:

• Size: 332.2 + 7125.4 MB
• Images / Multi-media: 389,564 JPEG image files, 7125.4 MB. File name: images/{hotel.slug}-0.jpg,{hotel.slug}-1.jpg
• Last updated: June 3rd, 2011
• Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 9

Buy Now & Download: $589.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• chain

  Records:384

  All the hotel chains, associated with hotels by id.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• city

  Records:47,853

  All travel-worthy cities from around the globe, with latitude and longitude, associated with state and country by id and country_code.

  Data fields

  1. id: int(11)
  2. slug: varchar(255)
  3. title: varchar(255)
  4. latitude: varchar(255)
  5. longitude: varchar(255)
  6. state_id: int(11)
  7. country_code: char(2)

• country

  Records:198

  All the countries of the world. Each hotel has a country code associated with it.

  Data fields

  1. id: int(11)
  2. code: char(2)
  3. slug: varchar(255)
  4. title: varchar(255)

• facility

  Records:249

  The variety of different accommodation facilities that hotels may or may not have. Each hotel has a detailed list of facilities in the facility field of the hotel table.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• hotel

  Records:208,065

  All the world hotels, each associated with a variety of other tables.

  Data fields

  1. id: int(11)
  2. slug: varchar(255)
  3. title: varchar(255)
  4. hotelstar: float
  5. city_id: int(11)
  6. state_id: int(11)
  7. country_code: char(2)
  8. address: varchar(255)
  9. min_rate: float
  10. currency_code: char(3)
  11. latitude: varchar(255)
  12. longitude: varchar(255)
  13. num_reviews: int(11)
  14. property_type_id: int(11)
  15. chain_id: int(11)
  16. facilities: varchar(255)
  17. popularity: int(11)
  18. overall_rating: float
  19. cleanliness_rating: float
  20. service_rating: float
  21. facilities_rating: float
  22. location_rating: float
  23. dining_rating: float
  24. rooms_rating: float
  25. checkin: varchar(255)
  26. checkout: varchar(255)
  27. descriptions: text

• location

  Records:21,359

  Important locations within the city by latitude and longitude for each location. So you can calculate the distance from each hotel to any of the famous locations.

  Data fields

  1. id: int(11)
  2. city_id: int(11)
  3. title: varchar(255)
  4. slug: varchar(255)
  5. location_type_id: int(11)
  6. latitude: varchar(255)
  7. longitude: varchar(255)

• location_type

  Records:16

  Different types of locations, associated with each location.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• property_type

  Records:10

  Different types of hotel property, associated with each hotel.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• state

  Records:151

  All the states (for US) and sub-national administrations under some of the countries. Each hotel is associated with a state if applicable.

  Data fields

  1. id: int(11)
  2. slug: varchar(255)
  3. title: varchar(255)
  4. country_code: char(2)

Buy Now & Download: $589.95 (USD)

Prospective Applications / Implementations:

• Hotels comparison site
• Travel site / community
• Hotels online booking site
• Hotels affiliate program site
• ...Order a custom build

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 $175)
• Single Table Format (Extra $100)