Usage & Publication License: database price dollar sign649.00

Database of Over 330,000 World Hotels in 226 Countries w/ 3.72 Million Images

Phone, email, website, fax, address of 337,187 hotels by longitude, latitude, city, state, country

database structure screenshot of Database of Over 330,000 World Hotels in 226 Countries w/ 3.72 Million Images

Description: This database comes with 19 data tables (1.5 GB) and 3.72 million image files (69.8 GB) of the hotel rooms, facilities and views. The hotel table is comprised of 337,187 hotel records (hotels, motels, inns, B&Bs, hostels, resorts, etc.) from around the world in 226 countries or territories, 3,675 sub-national areas (states, provinces, etc.) and 42,470 cities / towns (or other sub-sub-national places), with each record consisting of 38 different field columns.

Identified are 384 hotel chains, 177 hotel features (such as casino, pet friendly or not, parking, swimming pool, etc.) in 5 categories, 18,560 + 21,359 famous places / locations with longitudes and latitudes.

The most useful data in the hotel table are email, phone, fax, website, street address, longitude, latitude, star rating, number of rooms, local currency code, USD price, customer ratings and reviews.

Please see the structure details below for the data fields of each of the tables. Further below are the scope tables such as hotel property types, types of tourist attractions, hotel features, countries and hotel chains.

Related DBs:

Database Statistics

  • Size: 1.54 GB
  • Tables: 19
  • Records: 337,187
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Images Statistics

  • Images: 69.81G
  • Dimensions: 400 x 300 on average
  • Image formats: JPEG
  • Images count: 3,723,510
  • Reference field: hotel_image.path

Database Structure

Table Records Fields
chain 384
  1. id
  2. title
  3. slug
country 226
  1. id
  2. title
  3. slug
  4. iso_country_code_2
  5. iso_country_code_3
  6. calling_code
  7. count
country_sub 3,675
  1. id
  2. title
  3. slug
  4. type
  5. country_id
  6. count
country_sub_sub 27,182
  1. id
  2. title
  3. country_sub_id
  4. country_id
  5. count
country_sub_sub_sub 15,288
  1. id
  2. title
  3. country_sub_sub_id
  4. country_sub_id
  5. country_id
  6. count
country_sub_sub_sub_to_hotel 118,452
  1. id
  2. hotel_id
  3. country_sub_sub_sub_id
country_sub_sub_to_hotel 293,949
  1. id
  2. hotel_id
  3. country_sub_sub_id
country_sub_to_hotel 576,180
  1. id
  2. hotel_id
  3. country_sub_id
country_sub_type 613
  1. id
  2. title
  3. country_id
hotel 337,187
  1. id
  2. title
  3. hotel_name
  4. slug
  5. country_sub_id
  6. address_full
  7. address_short
  8. locations
  9. email
  10. website
  11. phone
  12. fax
  13. longitude
  14. latitude
  15. star_rating
  16. star_self_rated
  17. rooms
  18. local_currency_code
  19. price_usd
  20. price_from
  21. check_in
  22. check_out
  23. property_type_id
  24. chain_id
  25. rating_overall
  26. rating_overall_text
  27. rating_cleanliness
  28. rating_dining
  29. rating_facilities
  30. rating_location
  31. rating_rooms
  32. rating_service
  33. rating_points
  34. reviews_count
  35. reviews_summary_positive
  36. reviews_summary_negative
  37. description
  38. FAQ
  39. images_count
hotel_feature 177
  1. id
  2. title
  3. type
hotel_feature_to_hotel 6,074,492
  1. id
  2. hotel_id
  3. hotel_feature_id
hotel_feature_type 5
  1. id
  2. title
hotel_image 3,723,510
  1. id
  2. title
  3. dir
  4. path
  5. file_size_bytes
  6. width_px
  7. height_px
  8. hotel_id
location 21,359
  1. id
  2. title
  3. slug
  4. location_type_id
  5. latitude
  6. longitude
location_type 16
  1. id
  2. title
  3. slug
place_of_interest 3,319,923
  1. id
  2. longitude
  3. latitude
  4. name
  5. hotel_id
place_of_interest_name 18,560
  1. id
  2. title
property_type 10
  1. id
  2. title
  3. slug

Database Attachments

Images: This database is attached with 3,723,510 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:

chain

  • (No Chain)
  • Best Western
  • Comfort Inns
  • Super 8
  • Days Inn
  • Accor
  • Hampton
  • Quality Inn
  • Hotusa
  • Ramada
  • Econolodge
  • Extended Stay
  • La Quinta
  • Innlink
  • Courtyard
  • Scanres
  • Americas Best Value
  • Comfort Suites
  • Fairfield
  • Residence
  • Travelodge
  • Howard Johnson
  • Envergure
  • Country Inn
  • Sheraton
  • Supranational
  • Sleep Inn
  • Small Luxury
  • Keytel
  • Hilton Garden
  • Red Roof
  • Radisson Worldwide
  • Marriott
  • Leading
  • Relais & Chateaux
  • Rodeway
  • Hyatt
  • Knights
  • Clarion
  • Innpoints
  • Microtel
  • NH
  • Hilton
  • Hilton International
  • Sol Melia
  • Baymont
  • Springhill
  • Preferred
  • AmericInn
  • Homewood
  • Luxe
  • Wingate
  • Doubletree
  • Embassy
  • Design
  • Towneplace
  • Golden Tulip
  • Westin
  • Signature
  • Ringhotels
  • Exclusive
  • Renaissance
  • Summit
  • Select
  • Srs-Worldhotels
  • Four Seasons
  • Barcelo
  • Le Meridien
  • Top International
  • Fiesta Americana
  • Park Inn
  • Guesthouse
  • Millennium / Copthorne
  • Hawthorn
  • Wyndham
  • Interstate
  • Ritz-Carlton
  • Acc-Nifos
  • Nikko
  • Red Lion
  • Vagabond
  • Maritim
  • Kempinski
  • Shangri La
  • Marriott Vacation Club
  • Taj
  • Shilo
  • Sterling
  • WestCoast
  • Fairmont
  • Divi
  • Helmsley
  • Movenpick
  • Dorint
  • Mainstay
  • Jolly
  • Scandic
  • Thistle
  • Orient-Express
  • Kimpton
  • Travelodge Europe
  • Rydges
  • Macdonald
  • Omni
  • ANA
  • Delta
  • Destination
  • Doyle
  • Joie De Vivre
  • Park Plaza
  • Concorde Hotels
  • Abba
  • Aston
  • Charming
  • Harrah's
  • Outrigger
  • Starhotels
  • Swissotel
  • Boscolo
  • W
  • Warwick
  • Sonesta
  • Camino Real
  • Hyatt Summerfield
  • K
  • Holiday Inn
  • Mandarin Oriental
  • Clubhouse
  • Okura
  • Robert F Warner
  • Executive
  • Loews
  • Princess
  • Hyatt Vacations
  • Woodfin
  • Pan Pacific
  • Sandals
  • Noble House
  • Oberoi
  • Marco Polo
  • Ian Schrager
  • Rihga Royal
  • Meritus
  • Regent
  • Westmark
  • Grand Heritage
  • Marriott Conference
  • Prince
  • Raffles
  • Club Quarters
  • Caesar Park
  • MGM
  • New Otani
  • Sarova
  • Savoy
  • Crowne Plaza
  • Country Comfort
  • KSL
  • AmeriSuites
  • Sutton Place
  • Classic
  • Copthorne
  • World Class
  • Bulgari
  • Grand Hospitality
  • Peabody
  • Walt Disney
  • Wellesley
  • Staybridge
  • Regal
  • Flag Choice
  • Domina
  • CMNet
  • Candlewood
  • Concorde
  • Arcotel
  • Astra
  • Intercontinental
  • Morgans
  • Othon
  • Gaylord
  • ResortQuest
  • Motel 6
  • Budget Host
  • Kessler
  • Thunderbird
  • Celebrity
  • Drury
  • Value Place
  • Crossland
  • Homestead
  • All Seasons Resort Lodging
  • Raintree
  • Identity Properties
  • Premier Resorts
  • Sofitel
  • LXR
  • Sunterra
  • Settle Inn
  • America's Best Inn
  • Country Hearth
  • Westgate
  • Studio 6
  • NYLO
  • Defender
  • EVRentals
  • Oakwood
  • Castle
  • Suburban Extended Stay
  • Bridgestreet
  • Carefree
  • Crestwood
  • Oak Tree
  • AAE
  • Admiral
  • Heartland
  • Cambria
  • RockResorts
  • Starwood
  • Lees
  • Dolce
  • StudioPLUS
  • Sun Suites
  • Sierra
  • Aloft
  • Good Nite
  • Indigo
  • Vista
  • Larkspur Landing
  • Red Carpet
  • Ayres
  • AKA
  • Ascend
  • Diamond
  • Peppers
  • Waldorf
  • Stein
  • Premier Inn
  • Desires
  • Lexington Collection
  • Ascott
  • Banyan Tree
  • Windsor
  • Rede Atlantico
  • Slaviero
  • Blue Tree
  • Tropical
  • Grupo Espirito Santo
  • Pestana
  • Transamerica
  • Principal Hayley
  • Langham
  • Red Carnation
  • Legacy
  • Fountain Court
  • Dreamhouse
  • Oxford
  • Menzies
  • Moran
  • De Vere
  • Lady Glen
  • Swallow
  • Crerar
  • SACO
  • Swiss-Belhotel
  • Jameson
  • Standard
  • Meininger
  • Ramee
  • Marmotte
  • Imperial
  • Sarovar
  • Masters
  • Corinthia
  • Magnuson
  • Victory
  • Ishin
  • Akzent
  • APA
  • Key West
  • Korman Communities
  • Marriott ExecuStay
  • Adaaran
  • Six Senses
  • Fleming's
  • Parkroyal
  • GHM
  • Ibis
  • Landis
  • Dusit
  • Supertel
  • Carlson
  • Choice
  • Mantra
  • Breakfree
  • Oaks
  • Grand Hotels
  • StayWell
  • Amora
  • Rendezvous
  • Stamford
  • Frasers
  • Mirvac
  • Voyages
  • Heritage
  • Sokos
  • Abad
  • Awana
  • Britannia
  • Folio
  • Amari
  • Camden
  • City Express
  • Palace
  • H10
  • Fiesta
  • Villa Group
  • Oasis
  • Mision
  • Occidental
  • Riu
  • Iberostar
  • Stella
  • WorldHotels
  • Kiwi
  • Sandman
  • Coastal
  • Conrad
  • Lakeview
  • Insotel
  • City Crash Pad
  • Husa
  • Grupotel
  • Paradores
  • Eurostars
  • Sentido
  • AC
  • Zenit
  • Van Der Valk
  • Travelodge Australia
  • Lindner
  • Pullman
  • Novotel
  • Mercure
  • Suitehotel
  • MGallery
  • All Seasons
  • Etap
  • HotelF1
  • Formule 1
  • Adagio
  • Barriere
  • Orbis
  • Canadas Best Value
  • Coast
  • St. Regis
  • Element
  • The Luxury Collection
  • Thalassa
  • Home2
  • Edition
  • Autograph
  • Extended Stay Deluxe Hotel
  • Extended Stay America
  • Chinas Best Value Inn
  • Value Inn Worldwide
  • Louvre Hotels
  • Première Classe
  • Campanile
  • Kyriad
  • Kyriad Prestige
  • Tulip Inn
  • Royal Tulip
  • Kingsgate
  • JalHotels
  • Park Hyatt
  • Andaz
  • Hyatt Place
  • Grand Hyatt
  • Hyatt Resorts
  • Worldmark
  • Four Points
  • Affinia
  • Hôtels & Résidences du Roy

country

  • Afghanistan
  • Albania
  • Algeria
  • American Samoa
  • Andorra
  • Angola
  • Anguilla
  • Antigua and Barbuda
  • Argentina
  • Armenia
  • Aruba
  • Australia
  • Austria
  • Azerbaijan
  • Bahrain
  • Bangladesh
  • Barbados
  • Belarus
  • Belgium
  • Belize
  • Benin
  • Bermuda
  • Bhutan
  • Bolivia
  • Bosnia and Herzegovina
  • Botswana
  • Brazil
  • British Virgin Islands
  • Brunei Darussalam
  • Bulgaria
  • Burkina Faso
  • Burundi
  • Cambodia
  • Cameroon
  • Canada
  • Cape Verde
  • Caribbean Netherlands
  • Cayman Islands
  • Chad
  • Chile
  • China
  • Cocos (Keeling) Islands
  • Colombia
  • Comoros
  • Congo
  • Cook Islands
  • Costa Rica
  • Cote d'Ivoire
  • Croatia
  • Cuba
  • Curacao
  • Cyprus
  • Czech Republic
  • Democratic Republic of the Congo
  • Denmark
  • Djibouti
  • Dominica
  • Dominican Republic
  • East Timor
  • Ecuador
  • Egypt
  • El Salvador
  • Equatorial Guinea
  • Eritrea
  • Estonia
  • Ethiopia
  • Falkland Islands
  • Faroe Islands
  • Fiji
  • Finland
  • France
  • French Guiana
  • French Polynesia
  • Gabon
  • Georgia
  • Germany
  • Ghana
  • Gibraltar
  • Greece
  • Greenland
  • Grenada
  • Guadeloupe
  • Guam
  • Guatemala
  • Guinea
  • Guinea-Bissau
  • Guyana
  • Haiti
  • Honduras
  • Hong Kong
  • Hungary
  • Iceland
  • India
  • Indonesia
  • Iran
  • Iraq
  • Ireland
  • Israel
  • Italy
  • Jamaica
  • Japan
  • Jordan
  • Kazakhstan
  • Kenya
  • Kiribati
  • Kosovo
  • Kuwait
  • Kyrgyzstan
  • Laos
  • Latvia
  • Lebanon
  • Lesotho
  • Liberia
  • Libya
  • Liechtenstein
  • Lithuania
  • Luxembourg
  • Macau
  • Macedonia (FYROM)
  • Madagascar
  • Malawi
  • Malaysia
  • Maldives
  • Mali
  • Malta
  • Martinique
  • Mauritania
  • Mauritius
  • Mayotte
  • Mexico
  • Micronesia
  • Moldova
  • Monaco
  • Mongolia
  • Montenegro
  • Montserrat
  • Morocco
  • Mozambique
  • Myanmar (Burma)
  • Namibia
  • Nepal
  • New Caledonia
  • New Zealand
  • Nicaragua
  • Niger
  • Nigeria
  • Niue
  • Norfolk Island
  • North Korea
  • Northern Mariana Islands
  • Norway
  • Oman
  • Pakistan
  • Palau
  • Palestinian Territory
  • Panama
  • Papua New Guinea
  • Paraguay
  • Peru
  • Philippines
  • Poland
  • Portugal
  • Puerto Rico
  • Qatar
  • Reunion
  • Romania
  • Russia
  • Rwanda
  • Saint Barthelemy
  • Samoa
  • San Marino
  • Sao Tome and Principe
  • Saudi Arabia
  • Senegal
  • Serbia
  • Seychelles
  • Sierra Leone
  • Singapore
  • Sint Maarten
  • Slovakia
  • Slovenia
  • Solomon Islands
  • South Africa
  • South Korea
  • Spain
  • Sri Lanka
  • St Kitts and Nevis
  • St Lucia
  • St Martin
  • St Pierre and Miquelon
  • St Vincent and the Grenadines
  • Sudan
  • Suriname
  • Swaziland
  • Sweden
  • Switzerland
  • Syria
  • Taiwan
  • Tajikistan
  • Tanzania
  • Thailand
  • The Bahamas
  • The Gambia
  • The Netherlands
  • Togo
  • Tonga
  • Trinidad & Tobago
  • Tunisia
  • Turkey
  • Turkmenistan
  • Turks and Caicos Islands
  • Uganda
  • Ukraine
  • United Arab Emirates
  • United Kingdom
  • United States
  • Uruguay
  • US Virgin Islands
  • Uzbekistan
  • Vanuatu
  • Venezuela
  • Vietnam
  • Western Sahara
  • Yemen
  • Zambia
  • Zimbabwe

hotel_feature

  • 24 Hour Reception
  • Air Conditioned
  • Allergy-Free Room Available
  • ATM / Cash Machine
  • Baby Listening/Monitoring
  • Babysitting / Child Services
  • Ballroom
  • Banquet Facilities
  • Bar / Lounge
  • Bath / Hot Tub
  • Bath Menu
  • Bathrobes
  • Bathtub/Shower Combination
  • Beach (Direct Access)
  • Beach (Nearby)
  • Beach Soccer and Volleyball
  • Beauty Salon
  • Bedding/Pillow Choices
  • Bicycle Rental
  • Bidet
  • Billiards
  • Boating
  • Body Treatments
  • Bowling Alley
  • Breakfast in the Room
  • Business Center
  • Cable / Satellite TV
  • Canoeing
  • Casino
  • CD Player
  • Cell phone/mobile rental
  • Ceremonies
  • Child Pool
  • Clay Pigeon Shooting
  • Coffee / Tea Maker
  • Coffee Shop/Cafeteria
  • Complimentary Toiletries
  • Computer
  • Concierge
  • Conference Manager
  • Conference Room(s)
  • Connecting Rooms
  • Convention Center
  • Cots
  • Courier
  • Cricket Pitch
  • Currency Exchange
  • Custom event planning available
  • Cycling
  • Dart Board
  • Designated Smoking Area
  • Desk
  • Disabled Access
  • Disabled Accessible Rooms
  • Disabled Parking
  • Diving Centre
  • Dry Cleaning
  • DVD Player
  • Ecotours on Site
  • Elevator / Lift
  • En suite
  • Excursions
  • Executive Floor
  • Exhibit Space
  • Express Check-In/Check-Out
  • Facial Treatments
  • Facsimile
  • Family Room
  • Fine Dining
  • Fishing
  • Fitness Room/Gym
  • Football Field
  • Full-service catering
  • Function Rooms
  • Games Available
  • Garden
  • Gay/Lesbian Friendly
  • Golf (miniature)
  • Golf Course
  • Golf Course (nearby)
  • Golf Course (on site)
  • Grab bars in bathroom
  • Hair Dryer
  • High-speed Internet is available at this hotel
  • Highchairs
  • Hiking
  • Horse Riding
  • Ice Machine
  • In Room Movies
  • Jacuzzi
  • Jet-Ski
  • Karaoke
  • Kayaking
  • Kids Club
  • Kitchenette
  • Knock Light (Hearing Impaired)
  • Lake
  • Laptop
  • Late check-out (subject to availability)
  • Laundry service
  • Luggage Storage
  • Massage
  • Massage / Beauty Centre
  • Meeting Coordinator
  • Meeting Rooms
  • Microwave
  • Mini Bar
  • Mountain Climbing
  • Multilingual Staff
  • Nature Trail
  • News Stand
  • Nightclubs
  • Non-Smoking Rooms
  • Office Supplies
  • Outdoor heated pool
  • Packed Lunches
  • Parking is available
  • Personal Shopper Service
  • Pet Friendly
  • Photocopier
  • Picnic Area/Tables
  • Pillow Top Mattress
  • Playground
  • Pool Indoor
  • Pool Outdoor
  • Poolside Bar
  • Porters
  • Private Bathroom
  • Private beach
  • Private Toilet
  • Pub
  • Refrigerator
  • Restaurant
  • Rock Climbing
  • Room Service
  • Safe-Deposit Box
  • Salon
  • Sauna
  • Scooter/moped rentals are available at the hotel
  • Scuba Diving
  • Secretarial Service
  • Security Guard
  • Self Laundry
  • Shared Bathroom
  • Shoe Shine
  • Shops
  • Shops in Hotel
  • Shower
  • Skating Rink
  • Smoking Room
  • Souvenirs/Gift Shop
  • Spa & Wellness Centre
  • Spa bath / Jacuzzi
  • Squash Courts
  • Steam Bath
  • Supervised child care/activities
  • Surfing
  • Swimming pool
  • Tennis Courts
  • Tennis Courts (indoor)
  • The hotel has free parking
  • There is an airport shuttle that runs from the hotel
  • There is no parking on site
  • Ticket Service
  • Tour Desk
  • Towels
  • TV
  • Valet parking is offered at the hotel
  • Vending Machines
  • Video Conferencing
  • Volleyball
  • Wake-up Service
  • Water Activities
  • Water-skiing
  • Windsurfing
  • Wine Tasting
  • Wireless internet on site

location_type

  • 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

property_type

  • Hotel
  • Motel
  • Inn
  • Bed & Breakfast
  • Vacation Rental
  • Hostel
  • Retreat
  • Resort
  • Other
  • Apartment

Miscellaneous

Notes:

  • ALL records have the physical address, longitude and latitude.
  • There are 38,497 records with an email.
  • There are 124,525 records with a website address.
  • There are 95,159 records with a phone number.
  • There are 39,781 records with a fax number.
  • There are 304,881 records with a star rating.
  • There are 7,298 records with a count of rooms.
  • There are 214,299 records with a price in USD.
  • There are 66,644 records with a local currency code.
  • There are 310,131 records have a check in time.
  • There are 308,030 records with a check out time.
  • There are 78,205 records that are identified with a property type.
  • There are 55,929 records that are identified with a chain.
  • There are 154,209 records with customer ratings and reviews.

Defects:

  • Slightly more than 50,000 hotels, or 15%, have no photo images.

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. The 3 letter word for what we breathe?

    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.