Usage & Publication License: database price dollar sign389.00

185.8K Hotels Database in 43K Cities Worldwide

185,816 hotels: address, phone, email, price, room, lat, lon, website, gds code

database structure screenshot of 185.8K Hotels Database in 43K Cities Worldwide

Description: This database is a great and rich fields one to find more information on hotels around the world. It has 185,816 hotel records from 43,017 popular cities. The hotel date set has price, address, phone number, email, latitude&longitude, gds, fax, website, commission, room number, class, amenity, facility, build year and etc.
In the media sets of this database, also contains 1,106,297 hotel images in 61.82G.

Data Samples (JSON, CSV, XML, Excel):
http://n3.datasn.io/data/api/v1/n3_lyz/globe_hotel_1/main/list/

Related DBs:

Database Statistics

  • Size: 2.40 GB
  • Tables: 6
  • Records: 185,816
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
region 10
  1. id
  2. ts
  3. region
subregion 303
  1. id
  2. ts
  3. subregion
  4. region
city 43,017
  1. id
  2. ts
  3. city
  4. region
  5. subregion
city_x_hotel 1,052,478
  1. id
  2. ts
hotel 185,816
  1. id
  2. ts
  3. title
  4. address
  5. class_number
  6. class
  7. room_num
  8. commission
  9. price
  10. overview
  11. year_built
  12. check_in_time
  13. check_out_time
  14. number_of_floors
  15. chain
  16. chain_website
  17. amadeus_gds
  18. ga_ap_gds
  19. sabre_gds
  20. worldspan_gds
  21. rate_policy
  22. start_from
  23. suit
  24. credit_cards
  25. reservation_policy
  26. included_meals
  27. deposit_policy
  28. cancellation_policy
  29. restrictions
  30. discounts_offered
  31. amenities
  32. on_site_recreation
  33. nearby_recreation
  34. services_facilities
  35. security_services
  36. address_detail
  37. phone
  38. fax
  39. toll_free
  40. meeting_capacity
  41. meeting_space
  42. exhibit_space
  43. largest_capacity
  44. service
  45. renovated
  46. website
  47. email
  48. latitude
  49. longitude
meeting_room 63,470
  1. id
  2. ts
  3. title
  4. location
  5. flooring
  6. por_walls_available
  7. size
  8. capacities

Database Attachments


Content Scope

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

subregion

  • Algeria
  • Angola
  • Benin
  • Botswana
  • Burkina Faso
  • Burundi
  • Cameroon
  • Cape Verde
  • Central African Republic
  • Chad
  • Comoros
  • Cote d'Ivoire
  • Democratic Republic of Congo
  • Djibouti
  • Equatorial Guinea
  • Eritrea
  • Ethiopia
  • Gabon
  • Gambia
  • Ghana
  • Guinea
  • Guinea-Bissau
  • Kenya
  • Lesotho
  • Liberia
  • Libya
  • Madagascar
  • Malawi
  • Mali
  • Mauritania
  • Mauritius
  • Mayotte
  • Morocco
  • Mozambique
  • Namibia
  • Niger
  • Nigeria
  • Republic of the Congo
  • Reunion Island
  • Rwanda
  • Sao Tome and Principe
  • Senegal
  • Seychelles
  • Sierra Leone
  • Somalia
  • South Africa
  • South Sudan
  • Sudan
  • Swaziland
  • Tanzania
  • Togo
  • Tunisia
  • Uganda
  • Zambia
  • Zimbabwe
  • Afghanistan
  • Bangladesh
  • Bhutan
  • Brunei Darussalam
  • Cambodia
  • China
  • East Timor
  • Hong Kong
  • India
  • Indonesia
  • Japan
  • Kazakhstan
  • Kyrgyz Republic
  • Laos
  • Macau
  • Malaysia
  • Maldives
  • Mongolia
  • Myanmar
  • Nepal
  • North Korea
  • Pakistan
  • Philippines
  • Singapore
  • South Korea
  • Sri Lanka
  • Taiwan
  • Tajikistan
  • Thailand
  • Turkmenistan
  • Uzbekistan
  • Vietnam
  • American Samoa
  • Antarctica
  • Australia
  • Cook Islands
  • Easter Island
  • Easter Island
  • Fiji
  • French Polynesia
  • Guam
  • Kiribati
  • Marshall Islands
  • Micronesia
  • Midway Islands
  • Nauru
  • New Caledonia
  • New Zealand
  • Niue
  • Norfolk Island
  • Northern Marianas
  • Palau
  • Papua New Guinea
  • Samoa
  • Solomon Islands
  • Tonga
  • Tuvalu
  • Vanuatu
  • Wallis & Futuna Islands
  • Alberta
  • British Columbia
  • Foresters Falls
  • Manitoba
  • New Brunswick
  • Newfoundland & Labrador
  • Northwest Territories
  • Nova Scotia
  • Nunavut
  • Ontario
  • Prince Edward Island
  • Quebec
  • Saskatchewan
  • St Lawrence River
  • Yukon Territory
  • Anguilla
  • Antigua and Barbuda
  • Aruba
  • Bahamas
  • Barbados
  • Bermuda
  • Bonaire
  • British Virgin Islands
  • Cayman Islands
  • Cuba
  • Curacao
  • Dominica
  • Dominican Republic
  • Grenada
  • Guadeloupe
  • Haiti
  • Jamaica
  • Margarita Island
  • Martinique
  • Montserrat
  • Puerto Rico
  • Saba
  • St Barthelemy
  • St Eustatius
  • St Kitts & Nevis
  • St Lucia
  • St Martin/St Maarten
  • St Vincent & Grenadines
  • Trinidad and Tobago
  • Turks & Caicos
  • US Virgin Islands
  • Albania
  • Andorra
  • Armenia
  • Austria
  • Azerbaijan
  • Belarus
  • Belgium
  • Bosnia and Herzegovina
  • Bulgaria
  • Channel Islands
  • Croatia
  • Czech Republic
  • Denmark
  • England
  • Estonia
  • Finland
  • France
  • Georgia
  • Germany
  • Gibraltar
  • Greece
  • Greenland
  • Hungary
  • Iceland
  • Ireland
  • Italy
  • Kosovo
  • Latvia
  • Liechtenstein
  • Lithuania
  • Luxembourg
  • Macedonia
  • Malta
  • Moldova
  • Monaco
  • Montenegro
  • Netherlands
  • Northern Ireland
  • Norway
  • Poland
  • Portugal
  • Romania
  • Russia
  • San Marino
  • Scotland
  • Serbia
  • Slovakia
  • Slovenia
  • Spain
  • Sweden
  • Switzerland
  • Ukraine
  • United Kingdom
  • Wales
  • Argentina
  • Belize
  • Bolivia
  • Brazil
  • Chile
  • Colombia
  • Costa Rica
  • Ecuador
  • El Salvador
  • Falkland Islands
  • French Guiana
  • Guatemala
  • Guyana
  • Honduras
  • Mexico
  • Nicaragua
  • Panama
  • Paraguay
  • Peru
  • Suriname
  • Uruguay
  • Venezuela
  • Bahrain
  • Cyprus
  • Egypt
  • Iran
  • Iraq
  • Israel
  • Jordan
  • Kuwait
  • Lebanon
  • Oman
  • Qatar
  • Saudi Arabia
  • Syria
  • Turkey
  • United Arab Emirates
  • Yemen
  • Alabama
  • Alaska
  • Arizona
  • Arkansas
  • California
  • Colorado
  • Connecticut
  • Delaware
  • Florida
  • Georgia
  • Hawaii
  • Idaho
  • Illinois
  • Indiana
  • Iowa
  • Kansas
  • Kentucky
  • Louisiana
  • Maine
  • Maryland
  • Massachusetts
  • Michigan
  • Minnesota
  • Mississippi
  • Missouri
  • Montana
  • Nebraska
  • Nevada
  • New Hampshire
  • New Jersey
  • New Mexico
  • New York
  • North Carolina
  • North Dakota
  • Ohio
  • Oklahoma
  • Oregon
  • Pennsylvania
  • Rhode Island
  • South Carolina
  • South Dakota
  • Tennessee
  • Texas
  • Utah
  • Vermont
  • Virginia
  • Washington
  • Washington, DC
  • West Virginia
  • Wisconsin
  • Wyoming

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 is opposite to yes?

    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.