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

219,580 Hotels Around The World: Address, Phone, Latitude, Longitude

219,580 hotels from 345 countries and regions, 108546 cities around the world, include address, phone, price, latitude, longitude and 584754 images.

Description: This database is a great one to find more informations of attractions and hotel around the world. It has 219,580 hotels records from 108,546 popular cities. Each hotel includes type, class, address, email, phone, fax, price, room number, latitude, longitude. Besides, there are 150,355 local infomations with description, location, nearest street and hotel in each, localinfo airport records, localinfo dining records and 1 localinfo 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.

Data Samples (JSON, CSV, Excel):
http://n3.datasn.io/data/api/v1/n3_lyz/globe_hotel_1/main/list/?app=html-bunker

Related DBs: 315721 Parts And 197966 Assemblies of 3 Brands (Arctic Cat,Kawasaki,and Yamaha) from 1980 to 2019 309584 Models and 32097 Productions of Riding Gear, Helmets & Motor Parts From100 Well-Known Brands 49067 Models of Car for Sale in US from year 2007 to 2018 2,918,163 Canada Yellow Pages Database Database of 348,814 Businesses Yellow Pages in UK Car Makes & Models Database by Trim & Engine 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 43,115 Nail Salons Database of US 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 53,061 Hair Salons Database in US 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 1,391,989 US Rehabilitation Services 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) 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