Indian Hotels On Booking.com

6,000 Indian hotels on Booking.com

@kaggle.promptcloudhq_indian_hotels_on_bookingcom

Table List

1 table(1.68 MB)

Booking Com Travel Sample

@kaggle.promptcloudhq_indian_hotels_on_bookingcom.booking_com_travel_sample

1.68 MB
6000 rows
29 columns

address Address	city City	country Country	crawl_date Crawl Date	hotel_brand Hotel Brand	hotel_description Hotel Description	hotel_facilities Hotel Facilities	hotel_star_rating Hotel Star Rating	image_count Image Count	latitude Latitude	locality Locality	longitude Longitude	pageurl Pageurl	property_id Property Id	property_name Property Name	property_type Property Type	province Province	qts Qts	room_count Room Count	room_type Room Type	similar_hotel Similar Hotel	site_review_count Site Review Count	site_review_rating Site Review Rating	site_stay_review_rating Site Stay Review Rating	sitename Sitename	special_tag Special Tag	state State	uniq_id Uniq Id	zone Zone
KHIRSU, 246147 Pauri, India – Great location -	pauri	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Khirsu By GMVN offers accommodation in Pauri. Each room has a TV and offers views of the mountains. Some rooms have a seating area where you can relax. Rooms have a private bathroom. Khirsu By GMVN features free WiFi . You will find room service at the property. The hotel also offers car hire. The n…	Bathroom:Toilet paper\|Linen\|Towels\|Bathroom\|Toilet•Bedroom:Wardrobe/Closet•View:Mountain view\|View•Room Amenities:Clothes rack•Pets:Pets are not allowed.•Living Area:Seating Area\|Desk•Media & Technology:Satellite Channels\|TV•Food & Drink:Breakfast in the room•Internet:Free! WiFi is available in publ…	nan	3	30.12374875460044	nan	78.79377365112305	http://www.booking.com/hotel/in/khirsu-by-gmvn.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=01&checkin_year_month=2016-12&checkout_monthday=02&checkout_year_month=2016-1…	1742658	Khirsu By GMVN	204	nan	2016-09-01 11:52:38 +0000	18	Economy Double Room	Hotel Mandakini			nan	http://www.booking.com/	Share	Uttarakhand	a5ea72415f8007fcbe65759830fdd3d9	nan
Kaathadimattam, Balacola Post, NEAR Siva Tea Factory, Ooty, 643203 Ooty, India – Great location -	ooty	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Situated in Ooty in the Tamil Nadu Region, 8 km from Ooty Lake, Global Village Ooty features a barbecue, children's playground and terrace. Good Shepherd International School is 5 km away. Free WiFi is offered throughout the property and free private parking is available on site. Each unit is equipp…	Bathroom:Toilet paper\|Linen\|Towels\|Bidet\|Towels/Sheets (extra fee)\|Bathroom\|Toilet\|Free toiletries\|Shared Bathroom\|Hairdryer\|Shower•View:Mountain view\|View•Outdoors:BBQ facilities\|Terrace\|Garden•Kitchen:Children's high chair\|Kitchenware\|Electric kettle•Room Amenities:Drying rack for clothing•Pets:Pe…	3 stars		11.3295949192368	nan	76.686732172966	http://www.booking.com/hotel/in/global-village-ooty.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=17&checkin_year_month=2016-12&checkout_monthday=18&checkout_year_month=2…	1755986	Global Village Ooty	212	nan	2016-09-01 11:52:38 +0000	10	British Empire Chalet	Treebo Yantra Leisures\|Western Valley Resorts\|Two Seas Residence	5	7.6	Location:8.5\|Staff:8\|Cleanliness:7.5\|Comfort:7.5\|Value for money:7.5\|Facilities:6.5	http://www.booking.com/	Share	Tamil Nadu	7e0b055417271bbd9dae902f3e231ed4	nan
PIPALKOTI, 246472 Pīpalkoti, India – Show map	pīpalkoti	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	TRH Pipalkoti offers accommodation in Pīpalkoti. Free private parking is available on site. Certain rooms include a seating area to relax in after a busy day. Rooms are fitted with a private bathroom. TRH Pipalkoti features free WiFi throughout the property. A TV is featured. You will find a 24-hour…	Bathroom:Toilet paper\|Linen\|Towels\|Bathroom•View:Mountain view\|View•Pets:Pets are not allowed.•Living Area:Desk•Food & Drink:Special diet menus (on request)\|Breakfast in the room•Internet:Free! WiFi is available in all areas and is free of charge.•Parking:Free! Free private parking is possible on si…	nan	4	30.42953964129101	nan	79.42811608314514	http://www.booking.com/hotel/in/trh-pipalkoti.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=09&checkin_year_month=2016-12&checkout_monthday=10&checkout_year_month=2016-12…	1741747	TRH Pipalkoti	204	nan	2016-09-01 11:52:38 +0000	28	Economy Double Room	TRH Joshimath (New)			nan	http://www.booking.com/	Share	Uttarakhand	72c0af09827bbb620365aa5df523ba1d	nan
1 KARIYIL HOUSE KUMARAKOM NORTH PO KOTTAYAM, 686563 Kumarakom, India – Show map	kumarakom	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Swasti house boat 2 is located in Kumarakom, 3.9 km from Vembanad Lake. Guests can enjoy the on-site restaurant. Free private parking is available on site. Every room at this hotel is air conditioned and comes with a TV. Certain units have a seating area where you can relax. There is a cash machine,…	Bathroom:Toilet paper\|Towels\|Bath\|Shower•Bedroom:Wardrobe/Closet•View:Lake view\|View•Outdoors:Sun terrace\|Terrace•Kitchen:Dining table•Room Amenities:Clothes rack•Pets:Pets are not allowed.•Activities:Massage\|Fishing•Living Area:Dining area\|Seating Area•Media & Technology:Cable Channels\|TV•Food & Dr…	nan	2	9.616056771806416	nan	76.42826914787292	http://www.booking.com/hotel/in/swasti-house-boat-2.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=16&checkin_year_month=2016-12&checkout_monthday=17&checkout_year_month=2…	1747392	Swasti house boat 2	204	nan	2016-09-01 11:52:38 +0000	1	Deluxe Room	nan			nan	http://www.booking.com/	Share	Kerala	eb6fd33d99aa4a8088caa8f3ecb08275	nan
Kavanattinkara, 686563 Kumarakom, India – Show map	kumarakom	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Amrutham Houseboat 2 is set in Kumarakom, 5 km from Vembanad Lake. Kumarakom Bird Sanctuary is 300 metres away. Free private parking is available on site. All units are air conditioned and feature a seating area. There is also a dining area and a kitchen equipped with a fridge. Towels are offered. G…	Bathroom:Toilet paper\|Linen\|Towels\|Towels/Sheets (extra fee)\|Free toiletries\|Bath\|Shower•Bedroom:Wardrobe/Closet\|Extra Long Beds (> 2 metres)•View:Lake view•Kitchen:Dining table\|Kitchen\|Refrigerator•Room Amenities:Clothes rack•Pets:Free! Pets are allowed on request. No extra charges.•Activities:Even…	nan		9.632854358119618	nan	76.42356991767883	http://www.booking.com/hotel/in/amrutham-houseboat-2.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=01&checkin_year_month=2016-12&checkout_monthday=02&checkout_year_month=…	1744962	Amrutham Houseboat 2	215	nan	2016-09-01 11:52:38 +0000	2	Mobile Home	Mandala Beach House & Cottages			nan	http://www.booking.com/	Share	Kerala	0814d9af7ad808863c04db8f30437c57	nan
15 A Arani House Ooty, 643002 Ooty, India – Show map	ooty	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Located 3.4 km from Ooty Lake and 800 m from Hebron School Ooty, The Hill Side offers accommodation in Ooty. The property is 1 km from Ooty Botanical Gardens and free private parking is offered. Free WiFi is provided throughout the property. A flat-screen TV is available. Other facilities at The Hil…	Miscellaneous:Non-smoking rooms•Bathroom:Toilet paper\|Linen\|Towels\|Bathroom\|Toilet\|Hairdryer•Bedroom:Wardrobe/Closet•Outdoors:Terrace•Kitchen:Electric kettle•Room Amenities:Clothes rack\|Tile/Marble floor\|Soundproofing\|Ironing Facilities•Services & Extras:Wake-up service•Pets:Pets are not allowed.•Me…	nan	12	11.4134596475073	nan	76.71859949827194	http://www.booking.com/hotel/in/the-hill-side.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=09&checkin_year_month=2016-12&checkout_monthday=10&checkout_year_month=2016-12…	1756349	The Hill Side	201	nan	2016-09-01 11:52:38 +0000	20	Standard Room in Apartment	Two Seas Residence	81	8.4	nan	http://www.booking.com/	Share	Tamil Nadu	cd2caff07410c06831e50a5ed0807f6c	nan
Near White Meadows Resorts Prini, Manali Distt. Kullu (H.P.), 175131 Manāli, India – Show map	manāli	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	One of our bestsellers in Manāli! Hotel Mountain Face offers accommodation in Manāli. The hotel has a terrace and views of the mountain, and guests can enjoy a meal at the restaurant. Free private parking is available on site. Rooms come with a flat-screen TV. Every room is equipped with a private b…	Bathroom:Toilet paper\|Linen\|Towels\|Towels/Sheets (extra fee)\|Bath or Shower\|Bathroom\|Toilet\|Free toiletries\|Shower•Outdoors:Terrace\|Garden•Room Amenities:Clothes rack•Pets:Pets are not allowed.•Living Area:Dining area\|Sofa•Media & Technology:Flat-screen TV•Food & Drink:Special diet menus (on request…	2-star hotel	45	32.22145594765875	nan	77.19583421945572	http://www.booking.com/hotel/in/mountain-face.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=01&checkin_year_month=2016-12&checkout_monthday=02&checkout_year_month=2016-12…	1737428	Hotel Mountain Face	204	nan	2016-09-01 11:52:38 +0000	28	Budget Double Room	Sparsh Resort\|Pause at Manali\|Hotel Mountain Trail Manali	16	6.9	nan	http://www.booking.com/	Share	Himachal Pradesh	e7482ae06a72dee32708e226d5dcf73d	nan
Near Railway Station Near Railway Station, 249401 Haridwār, India – Great location -	haridwār	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Rahi Motel Haridwar is located in Haridwār, 1.5 km from Mansa Devi Temple and 1 km from Har Ki Pauri. Guests can enjoy the on-site restaurant. Free private parking is available on site. The rooms are fitted with a TV with cable channels. Each room is equipped with a private bathroom. Rahi Motel Hari…	Bathroom:Toilet paper\|Linen\|Towels\|Towels/Sheets (extra fee)\|Slippers\|Bathroom\|Toilet\|Shower•Bedroom:Wardrobe/Closet•Outdoors:Garden•Room Amenities:Clothes rack•Pets:Pets are not allowed.•Living Area:Desk•Media & Technology:Cable Channels\|TV•Food & Drink:Special diet menus (on request)\|Breakfast in …	nan		29.94695888439015	nan	78.15648894550782	http://www.booking.com/hotel/in/rahi-motel-haridwar.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=03&checkin_year_month=2016-12&checkout_monthday=04&checkout_year_month=2…	1742655	Rahi Motel Haridwar	204	nan	2016-09-01 11:52:38 +0000	32	Economy Double Room	Himgiri Residency\|Hotel Le Central	55	6.2	nan	http://www.booking.com/	Share	Uttarakhand	afe4c16fa1512557020acaa51ff744ef	nan
1 KARIYIL HOUSE KUMARAKOM NORTH PO KOTTAYAM, 686563 Kumarakom, India – Show map	kumarakom	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Situated in Kumarakom, 3.9 km from Vembanad Lake, Swasti house boat 4 features air-conditioned rooms and free private parking. Guests can enjoy the on-site restaurant. Every room includes a TV. Some units feature a seating area where you can relax. You will find a gift shop at the property. Car hire…	Bathroom:Toilet paper\|Towels\|Bath\|Shower•Bedroom:Wardrobe/Closet•View:Lake view\|View•Kitchen:Dining table\|Refrigerator•Room Amenities:Clothes rack•Pets:Pets are not allowed.•Activities:Massage\|Fishing•Living Area:Dining area\|Seating Area•Media & Technology:TV•Food & Drink:Snack bar\|Restaurant (buffe…	3-star hotel	1	9.617156891168982	nan	76.42783999443054	http://www.booking.com/hotel/in/swasti-house-boat-4.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=16&checkin_year_month=2016-12&checkout_monthday=17&checkout_year_month=2…	1747391	Swasti house boat 4	204	nan	2016-09-01 11:52:38 +0000	2	Deluxe Room	Sreekrishna Houseboat C/o Sreekrishna ayurveda Panchakarma Centre	30	8.2	nan	http://www.booking.com/	Share	Kerala	b0ac79ef7273575d5ce09de1c8f29db0	nan
nan	pura raghunāth	India	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	5-star hotel		25.2632040662184	nan	82.8412191952521	http://www.booking.com/hotel/in/sanjay-motels-i-pvt-ltd.en-gb.html?label=gen173nr-15CAsobEIadGhlLWxlZWxhLXBhbGFjZS1iYW5nYWxvcmVIM2IFbm9yZWZobIgBAZgBLrgBBMgBBNgBA-gBAfgBAw;sid=f341da5cb268bae3ab8d5a82ed66e21f;dcid=4;checkin_monthday=03&checkin_year_month=2016-12&checkout_monthday=04&checkout_year_mon…		nan	City	nan	2016-09-01 11:52:38 +0000		Superior Double Room	nan		7.7	nan	http://www.booking.com/	nan	Uttar Pradesh	4e8b622d006998420ab908936ce6d7c7	nan


CREATE TABLE booking_com_travel_sample (
  "address" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "crawl_date" TIMESTAMP,
  "hotel_brand" VARCHAR,
  "hotel_description" VARCHAR,
  "hotel_facilities" VARCHAR,
  "hotel_star_rating" VARCHAR,
  "image_count" DOUBLE,
  "latitude" DOUBLE,
  "locality" VARCHAR,
  "longitude" DOUBLE,
  "pageurl" VARCHAR,
  "property_id" DOUBLE,
  "property_name" VARCHAR,
  "property_type" VARCHAR,
  "province" VARCHAR,
  "qts" VARCHAR,
  "room_count" DOUBLE,
  "room_type" VARCHAR,
  "similar_hotel" VARCHAR,
  "site_review_count" DOUBLE,
  "site_review_rating" DOUBLE,
  "site_stay_review_rating" VARCHAR,
  "sitename" VARCHAR,
  "special_tag" VARCHAR,
  "state" VARCHAR,
  "uniq_id" VARCHAR,
  "zone" VARCHAR
);