Database
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

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/
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 |
|
hotel_region_sub | 354 |
|
letter | 28 |
|
business_service | 14 |
|
business_service_x_hotel | 344,819 |
|
city | 108,546 |
|
city_x_hotel | 2,840,891 |
|
hotel | 219,580 |
|
hotel_amenities | 45 |
|
hotel_amenities_x_hotel | 1,390,480 |
|
hotel_cover_image | 181,447 |
|
hotel_facilities | 33 |
|
hotel_facilities_x_hotel | 1,010,703 |
|
hotel_overview | 1,318,554 |
|
hotel_photo_detail | 403,297 |
|
hotel_rate | 1,069,964 |
|
hotel_recreation | 168 |
|
hotel_recreation_x_hotel | 471,551 |
|
localinfo | 150,355 |
|
localinfo_airport | 239,810 |
|
localinfo_airport_x_hotel | 539,915 |
|
localinfo_dining | 129,868 |
|
localinfo_dining_x_hotel | 278,408 |
|
localinfo_sightseeing | 150,778 |
|
localinfo_sightseeing_x_hotel | 191,567 |
|
meeting_room_detail | 1,030,087 |
|
phone_detail | 18,565 |
|
photos_url | 417,353 |
|
region_sub_x_letter | 3,435 |
|
room_event | 98,248 |
|
room_name | 122,405 |
|
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
Let us know and we'll see what we can do. Additional fees may apply.