Usage & Publication License: database price dollar sign199.00

Global City Tourism w/ 22K Attractions & 219K Hotels Database

22,606 attractions of global city tourism & 219,580 hotels: address, phone, type, price, lat, lon, etc. from 108,546 cities

database structure screenshot of Global City Tourism w/ 22K Attractions & 219K Hotels Database

Description: This database is a great one to find more information of attractions, hotel and other travel information around the world. It has 22,606 attractions records from 108,546 popular cities. Each attraction includes title, city, address, phone, type and attraction slug.

It also has 219,580 hotels with price, address, phone number, E-mail, commission, room number, index and etc. in each. From this database, there are 6 other tables related with these hotels, they are hotel amenities with 219,580 records, hotel facilities with 33 records, hotel overview with 1,318,554 records, 1,069,964 hotel rate records, 168 hotel recreation records and hotel region with 11 records. Besides, there are 150,355 local information with description, location, nearest street and hotel in each, 239,810 local info airport records, 129,868 local info dining records and 150,778 local info sightseeing records. About rooms from this database, it includes 1,030,087 meeting room detail records, 98,248 room event records with meeting capacity, exhibit space, meeting space, largest meeting room and hotel and room name with 122,405 records. In the media sets of this database, it contains the 1.94G hotel cover images and 23.05G hotel photo images.

The whole world attractions with hotels database consists of 33 tables.

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

Related DBs:

Database Statistics

  • Size: 2.29 GB
  • Tables: 31
  • Records: 219,580
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
hotel_region 11
  1. id
  2. ts
  3. title
hotel_region_sub 354
  1. id
  2. ts
  3. title
letter 28
  1. id
  2. ts
  3. title
business_service 14
  1. id
  2. ts
  3. title
business_service_x_hotel 344,819
  1. id
  2. ts
city 108,546
  1. id
  2. ts
  3. title
city_x_hotel 2,840,891
  1. id
  2. ts
hotel 219,580
  1. id
  2. ts
  3. title
  4. address
  5. class
  6. type
  7. room_num
  8. commission
  9. price
  10. index
  11. post
  12. e_mail
  13. phone
  14. fax
  15. toll_free
  16. latitude
  17. longitude
hotel_amenities 45
  1. id
  2. ts
  3. title
hotel_amenities_x_hotel 1,390,480
  1. id
  2. ts
hotel_cover_image 181,447
  1. id
  2. ts
  3. source_content_type
  4. hash_file_content
  5. size
  6. path
  7. title
  8. access
hotel_facilities 33
  1. id
  2. ts
  3. title
hotel_facilities_x_hotel 1,010,703
  1. id
  2. ts
hotel_overview 1,318,554
  1. id
  2. ts
  3. key
  4. value
hotel_photo_detail 403,297
  1. id
  2. ts
  3. source_content_type
  4. hash_file_content
  5. size
  6. path
  7. title
  8. access
hotel_rate 1,069,964
  1. id
  2. ts
  3. key
  4. value
hotel_recreation 168
  1. id
  2. ts
  3. title
hotel_recreation_x_hotel 471,551
  1. id
  2. ts
localinfo 150,355
  1. id
  2. ts
  3. description
  4. location
  5. nearest_street
localinfo_airport 239,810
  1. id
  2. ts
  3. title
localinfo_airport_x_hotel 539,915
  1. id
  2. ts
localinfo_dining 129,868
  1. id
  2. ts
  3. title
localinfo_dining_x_hotel 278,408
  1. id
  2. ts
localinfo_sightseeing 150,778
  1. id
  2. ts
  3. title
localinfo_sightseeing_x_hotel 191,567
  1. id
  2. ts
meeting_room_detail 1,030,087
  1. id
  2. ts
  3. key
  4. value
phone_detail 18,565
  1. id
  2. ts
  3. phone_type
  4. phone_number
  5. phone_mark
photos_url 417,353
  1. id
  2. ts
region_sub_x_letter 3,435
  1. id
  2. ts
room_event 98,248
  1. id
  2. ts
  3. meeting_capacity
  4. exhibit_space
  5. meeting_space
  6. largest_meeting_room
room_name 122,405
  1. id
  2. ts
  3. title

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:

hotel_region

  • Africa
  • Asia
  • Australia & South Pacific
  • Canada
  • Caribbean
  • Europe
  • Latin America
  • Mexico
  • Middle East
  • United States
  • Airports

hotel_region_sub

  • 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

city

  • Adrar
  • Ain El Hamman
  • Ain Sefra
  • Ain Taya
  • Algiers
  • Annaba
  • Bab-Ezzouar
  • Batna
  • Bechar
  • Bejaia
  • Beni Abbes
  • Berriane
  • Biskra
  • Blida
  • Bordj Badji Mokhtar
  • Bou Saada
  • Bouira
  • Boussaada
  • Chlef
  • Constantine
  • Djanet
  • Djemila
  • El Bayadh
  • El Golea
  • El Kala
  • El Oued
  • Ghardaia
  • Hassi Messaoud
  • Hassi R Mel
  • I-n-Salah
  • Illizi
  • In Amenas
  • In Guezzam
  • In Salah
  • Jijel
  • Laghouat
  • Maghnia
  • Mascara
  • Mechria
  • Mostaganem
  • Oran
  • Ouargla
  • Saoura
  • Seraidi
  • Setif
  • Sidi Belabbes
  • Sidi Fredj
  • Skikda
  • Staoueli
  • Taghit
  • Talaguilef
  • Tamanrasset
  • Tbessa
  • Tiaret
  • Tigzirt
  • Timgad
  • Timimoun
  • Tindouf
  • Tipasa
  • Tizi-Ouzou
  • Tlemcen
  • Touggourt
  • Yakouren
  • Zeralda
  • Benguela
  • Cabinda
  • Catumbela
  • Dundo
  • Huambo
  • Kuito
  • Lobito
  • Luanda
  • Lubango
  • Luena
  • M'Banza Congo
  • Malange
  • Menongue
  • N'Zeto
  • Namibe
  • Ndalatandos
  • Negage
  • Ongiva
  • Porto Amboim
  • Saurimo
  • Soyo
  • Sumbe
  • Uige
  • Waco Kungo
  • Abomey
  • Cotonou
  • Ganvie
  • Grand Popo
  • Natitingou
  • Ouidah
  • Parakou
  • Porto Novo
  • Chobe Natl Park
  • Francistown
  • Gaborone
  • Ghanzi

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.

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

  2. What is your inquiry?

  3. What floats on water, boat or stone?

    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.