Database
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
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.
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 |
|
| country | 226 |
|
| country_sub | 3,675 |
|
| country_sub_sub | 27,182 |
|
| country_sub_sub_sub | 15,288 |
|
| country_sub_sub_sub_to_hotel | 118,452 |
|
| country_sub_sub_to_hotel | 293,949 |
|
| country_sub_to_hotel | 576,180 |
|
| country_sub_type | 613 |
|
| hotel | 337,187 |
|
| hotel_feature | 177 |
|
| hotel_feature_to_hotel | 6,074,492 |
|
| hotel_feature_type | 5 |
|
| hotel_image | 3,723,510 |
|
| location | 21,359 |
|
| location_type | 16 |
|
| place_of_interest | 3,319,923 |
|
| place_of_interest_name | 18,560 |
|
| property_type | 10 |
|
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
Let us know and we'll see what we can do. Additional fees may apply.