Usage & Publication License: 199.00 Add to Cart View Cart Checkout with

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/

Related DBs: US & Canada Yellow Pages Database of 13.8 Million Businesses Database of Over 330,000 World Hotels in 226 Countries w/ 3.72 Million Images Database of 348,814 Businesses Yellow Pages in UK 43,115 Nail Salons Database of US 53,061 Hair Salons Database in US Car Makes & Models Database by Trim & Engine Database of 1,391,989 US Rehabilitation Services US 125K Wedding Services: Address, Lat, Lon, Image, Tel. Database 315K Parts & 197K Assemblies of Powersports Vehicles Database 32K Riding Gear, Helmets & Motor Parts: Image, Model, Make Motorcycles, Boats, ATVs, New Cars, Used Cars & RVs Campers 3M Canada Yellow Pages: Desc, Address, Lat, Lon, Tel. Database Database of 15,606 Golf Courses in US 288,531 Veterinary Clinics Database in US US 4,480 Airsoft Guns in 11 Categories Database of 1,560,021 Pet Care Services in US US 64,115 Animal Hospitals & Clinics Database 24,496 Bicycles in 24 Types from 320 Brands Database of 19,101 Funeral Homes of US 32,602 Family Practice Doctors Database in US 1,241 Jewelers and 329 Appraisers Database in US 38,440 Slot Machines Database in US US 536,521 Antique Reproduction Dealers Database Database of US 4,327 Men’s Health Gyms Database of 17,393 Bakeries in US Database of 21,412 Moving Companies in US Database of 34,418 Dry Cleaners of US Database of 122,593 Electricians in US 83,477 US Photographers and Videographers Database of 158,990 ATM Locations in US 196,673 Restaurants Database of United States Database of 91,054 Supermarkets of 15,064 Cities in US 275 Organic Products Export Companies in US 46,271 Pizza Shops in 9,816 Cities of US 69,240 Flower Shops across 27,185 Cities in US 185,000 Air Conditioning Cleaning Companies 2,210 Banks Database in US 372,108 City Frequencies with Control Points US 1,444,230 Appliances Services & Repairs 44,917 Indoor Advertising Companies of US US 4,140 Walmart Stores over 62 States 5,322 KFC over 51 States in US Database of Over 330,000 World Hotels in 226 Countries w/ 3.72 Million Images Airports Database of 9,436 Airports in 230 Countries 39,737 US Hotels and Inns Database (141,040 Reviews) ISBN Database of 18.4 Million Library Books (Title, Author, ISBN, Cover Images) Database of Over 330,000 World Hotels in 226 Countries w/ 3.72 Million Images 213,589 College Textbooks Database by 700 Universities US 125K Wedding Services: Address, Lat, Lon, Image, Tel. Database 315K Parts & 197K Assemblies of Powersports Vehicles Database 32K Riding Gear, Helmets & Motor Parts: Image, Model, Make Motorcycles, Boats, ATVs, New Cars, Used Cars & RVs Campers US 1K Top Colleges Database: Address, Global Rank, Subject, Tel. ATVs, Boats, Motorcycles, New Cars, Used Cars, RVs Campers Data Database of World Flags, Currency Images of 196 Countries Database of 300,000 Free Icons in 1,653 Icon Sets 39,737 US Hotels and Inns Database (141,040 Reviews) 251 DOS Games Database 140GB Historical Pictures, Prints & Photographs from Library of Congress Database of Over 330,000 World Hotels in 226 Countries w/ 3.72 Million Images US Statistics Database of 41,837 US Cities & 3,140 Counties World 1K Top Colleges: City, Address, Rank of 5 Regions Database Database of World Flags, Currency Images of 196 Countries Airports Database of 9,436 Airports in 230 Countries 39,737 US Hotels and Inns Database (141,040 Reviews) 42,050 Zip Codes Database of 29,809 Cities in US Database of 1,668,040 NPA NXX Codes & Phone Number Prefixes Scanner Frequencies and Radio Frequency Reference Database 140GB Historical Pictures, Prints & Photographs from Library of Congress 372,108 City Frequencies with Control Points Go

Database Structure

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

All Databases