TripAdvisor Restaurant Survival

How many restaurants from 2021 are still open?

@kaggle.artemfedorov_restraunt_survival

Table List

4 tables(4.09 MB)

Bg With Webscan

@kaggle.artemfedorov_restraunt_survival.bg_with_webscan

1.02 MB
4469 rows
49 columns

id Id	country_region Country Region	rest_name Rest Name	is_claimed Is Claimed	rating Rating	last_review Last Review	address Address	latitude Latitude	longitude Longitude	popularity_top Popularity Top	popularity_detailed Popularity Detailed	n_reviews N Reviews	price_range Price Range	cuisines Cuisines	meal_types Meal Types	special_diets Special Diets	features Features	working_hours Working Hours	telephone Telephone	food_rating Food Rating	service_rating Service Rating	value_rating Value Rating	traveller_rating_5 Traveller Rating 5	traveller_rating_4 Traveller Rating 4	traveller_rating_3 Traveller Rating 3	traveller_rating_2 Traveller Rating 2	traveller_rating_1 Traveller Rating 1	all_languages All Languages	status Status	id_destination Id Destination	price_category Price Category	top_tags Top Tags	type Type	english English	non_english Non-English	website Website	fb_last_update Fb Last Update	facebook_text Facebook Text	description Description	fb_last_update_year Fb Last Update Year	website_type Website Type	website_status Website Status	fb_rating Fb Rating	fb_reviews Fb Reviews	fb_followers Fb Followers
g1025615-d10148703	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'Enjoy Tea House']	Enjoy Tea House	Unclaimed	4.5	March 2, 2020	Chepelare, Pamporovo Bulgaria	41.65519	24.68011	#9 of 24 Restaurants in Pamporovo	#4 of 8 Pub in Pamporovo	29	nan	Bar, Pub	Breakfast, Brunch, Lunch	nan	Seating, Table Service			50	50	50	21	5	1		2	English (23), Turkish (6)	in rating	g1025615-d10148703	$$ - $$$	Bar, Pub	Restaurants	23	6	nan	nan	nan	nan		no_website	no_website
g1025615-d10225538	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'Restaurant The Castle, Hall Excalibur & The Terrace']	Restaurant The Castle, Hall Excalibur & The Terrace	Claimed	4	March 25, 2023	The Castle Hotel, Pamporovo 4870 Bulgaria	41.645412	24.695192	#11 of 24 Restaurants in Pamporovo	#3 of 5 International in Pamporovo	40	nan	International, European, Barbecue	Lunch, Dinner, Brunch, Late Night, Drinks	nan	Reservations, Seating, Accepts Credit Cards, Table Service, Delivery, Television, Highchairs Available, Serves Alcohol, Free Wifi, Playgrounds, Family style	true	true	40	40	40	24	4	2	3	7	English (37), French (1), Turkish (2)	in rating	g1025615-d10225538	$$ - $$$	International, Barbecue, European	Restaurants	37	3	http://www.pamporovocastle.com	nan	nan	nan		non-facebook	online
g1025615-d11815623	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'Restaurant FIS']	Restaurant FIS	Unclaimed	3.5	March 4, 2020	Pamporovo Studenets, Pamporovo 4870 Bulgaria	41.64281	24.68951	#15 of 24 Restaurants in Pamporovo	#15 of 24 Restaurants in Pamporovo	28	nan	nan	Breakfast, Lunch, Dinner	nan	Seating	true	true				9	10	4		5	English (16), Greek (3), Russian (4), Turkish (5)	in rating	g1025615-d11815623	$$ - $$$	nan	Restaurants	16	12	nan	nan	nan	nan		no_website	no_website
g1025615-d12195275	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'Golden Eagle']	Golden Eagle	Claimed	4	February 16, 2022	Snezhanka pick, Pamporovo 4870 Bulgaria	41.63593	24.679176	#16 of 24 Restaurants in Pamporovo	#16 of 24 Restaurants in Pamporovo	24	nan	nan	Brunch	nan	Reservations, Seating, Table Service		true	35	35	40	8	8	4	2	2	Turkish (3), English (20), Greek (1)	in rating	g1025615-d12195275	$$ - $$$	nan	Restaurants	20	4	http://www.facebook.com/pg/Alexs-Pub-1-170137659703956/photos/	nan	no_posts	Photos More Alex's Pub at ski Center Malina's Photos Tagged photos Albums		facebook	online			1800
g1025615-d12267716	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'The White House']	The White House	Unclaimed	2.5	July 1, 2023	4870 Pamporovo, Pamporovo 4870 Bulgaria	41.651794	24.694387	#24 of 24 Restaurants in Pamporovo	#6 of 6 Eastern European in Pamporovo	52	nan	Eastern European	nan	nan	Seating, Serves Alcohol, Table Service, Reservations		true	30	30	20	11	7	2	6	26	Dutch (1), English (35), Greek (5), French (4), Turkish (5), Russian (2)	in rating	g1025615-d12267716	$$ - $$$	Eastern European	Restaurants	35	17	http://www.facebook.com/THE-WHITE-HOUSE-%D0%91%D1%8F%D0%BB%D0%B0%D1%82%D0%B0-%D0%9A%D1%8A%D1%89%D0%B0-157607301000424/	December 13, 2022	nan	Intro Български ресторант с традиционна кухня. Page · Bulgarian Restaurant some@email.com the-white-house-pamporovo.business.site Price Range · $$$$	2022	facebook	online			675
g1025615-d13385228	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'Neptun Winter Home']	Neptun Winter Home	Claimed	4.5	March 14, 2023	H-L Perelik Kk, Pamporovo 4870 Bulgaria	41.658222	24.697145	#3 of 24 Restaurants in Pamporovo	#3 of 24 Restaurants in Pamporovo	96	₪11 - ₪119	Steakhouse, Seafood, International, Mediterranean, Barbecue, European	Breakfast, Lunch, Dinner, Brunch	Vegetarian Friendly, Vegan Options, Gluten Free Options	Reservations, Seating, Highchairs Available, Wheelchair Accessible, Serves Alcohol, Full Bar, Table Service	true	true	45	50	50	79	8	4	1	4	Spanish (1), Turkish (7), Swedish (1), Greek (5), English (80), Russian (2)	in rating	g1025615-d13385228	$$ - $$$	Steakhouse, Seafood, International	Restaurants	80	16	https://www.facebook.com/NeptunWinterHome/	March 14, 2023	She Say YES ! Neptun Winter Home #pamporovo #bulgaria #uluda #ski #vito #kayak #borovets #bansko #pamporovoski #banskoski #nature #skiing #snowboarding #winter #bulgaristan #a #mountains #bursa #bursabansko #chepelare #chepelareski #kayakmerkezi #aski #chepelarekayak #snow #pamporovokayak #borovets…	Intro resort Pamporovo hotel Perelik ***** Page · Barbecue Restaurant pamporovo, Smolyan, Bulgaria +359 87 732 6565 neptun-winter.com Closed now Dine-in · Outdoor seating · In-store pickup Price Range · $$ Offers free Wi-Fi	2023	facebook	online			2900
g1025615-d13393861	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'Rodopski Chanove 2']	Rodopski Chanove 2	Unclaimed	2.5	February 2, 2023	P-т.Родопски Чанове, срещу х-л.Мургавец, Pamporovo 4870 Bulgaria	41.655827	24.69945	#23 of 24 Restaurants in Pamporovo	#23 of 24 Restaurants in Pamporovo	7	₪33 - ₪174	Pizza, Barbecue, Eastern European	nan	nan	nan		true				2		1		4	Turkish (2), English (5)	in rating	g1025615-d13393861	$$ - $$$	Pizza, Barbecue, Eastern European	Restaurants	5	2	http://www.chanove2.com	nan	nan	nan		non-facebook	unavailable
g1025615-d1450405	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'Ranch']	Ranch	Unclaimed	5	May 28, 2009	Foot of 3-man chair lift Ski Centre 2, Pamporovo 4870 Bulgaria			#22 of 24 Restaurants in Pamporovo	#1 of 1 Diner in Pamporovo	1	nan	Diner	nan	nan	nan						1					English (1)	in rating	g1025615-d1450405	nan	Diner	Restaurants	1		nan	nan	nan	nan		no_website	no_website
g1025615-d15550930	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'Big Food ski restaurant Pamporovo']	Big Food ski restaurant Pamporovo	Claimed	4	January 6, 2020	Str. Snezhanka Tower Road, Kartala, Ski Restaurant Big Food Kartala, Pamporovo 4870 Bulgaria	41.637165	24.689587	#19 of 24 Restaurants in Pamporovo	#7 of 8 Barbecue in Pamporovo	4	₪21 - ₪64	Pizza, Cafe, Barbecue, Turkish, Soups	Breakfast, Lunch, Brunch, Drinks	nan	Reservations, Outdoor Seating, Seating, Television, Serves Alcohol, Wine and Beer, Free Wifi, Accepts Credit Cards	true	true				2	1			1	English (4)	in rating	g1025615-d15550930	$$ - $$$	Pizza, Cafe, Barbecue	Restaurants	4		http://www.facebook.com/Big-Food-511147769061746/	October 30, 2022	НОВА ГОДИНА 2023 в апарт-хотел "ФОРЕСТ НУК" - Пампорово! Предлагаме Ви пакети с включени: от 3 до 7 нощувки закуски веч… See more	Intro Бързо обслужване,добро качество и добра цена! Page · Restaurant Pamporovo, Smolyan, Bulgaria +359 89 260 1600 some@email.com forestnook-pamporovo.com Price Range · $$ Rating · 4.4 (71 Reviews)	2022	facebook	online	4.4	71	442
g1025615-d15601322	['Europe', 'Bulgaria', 'Smolyan Province', 'Pamporovo', 'Pamporovo Restaurants', 'The Pub']	The Pub	Unclaimed	3.5	February 9, 2020	Hotel Perelik, Pamporovo 4870 Bulgaria	41.65839	24.69767	#21 of 24 Restaurants in Pamporovo	#21 of 24 Restaurants in Pamporovo	2	nan	Irish, Bar, International, British, Pub	Lunch, Dinner	nan	nan	true	true					1	1			English (2)	in rating	g1025615-d15601322	nan	Irish, Bar, International, British	Restaurants	2		https://www.facebook.com/thepubpamporovo	August 28, 2020	https://m.facebook.com/story.php?story_fbid=10221332810368472&id=1194570336	Intro we make friends Page · Pub Smolyan, Bulgaria +359 87 733 9373 some@email.com Rating · 4.8 (136 Reviews)	2020	facebook	online	4.8	136	2800


CREATE TABLE bg_with_webscan (
  "id" VARCHAR,
  "country_region" VARCHAR,
  "rest_name" VARCHAR,
  "is_claimed" VARCHAR,
  "rating" DOUBLE,
  "last_review" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "popularity_top" VARCHAR,
  "popularity_detailed" VARCHAR,
  "n_reviews" BIGINT,
  "travellers_choice" BIGINT,
  "michelin" VARCHAR,
  "price_range" VARCHAR,
  "cuisines" VARCHAR,
  "meal_types" VARCHAR,
  "special_diets" VARCHAR,
  "features" VARCHAR,
  "working_hours" BOOLEAN,
  "telephone" BOOLEAN,
  "food_rating" DOUBLE,
  "service_rating" DOUBLE,
  "value_rating" DOUBLE,
  "atmosphere_rating" DOUBLE,
  "traveller_rating_5" DOUBLE,
  "traveller_rating_4" DOUBLE,
  "traveller_rating_3" DOUBLE,
  "traveller_rating_2" DOUBLE,
  "traveller_rating_1" DOUBLE,
  "all_languages" VARCHAR,
  "status" VARCHAR,
  "id_destination" VARCHAR,
  "price_category" VARCHAR,
  "top_tags" VARCHAR,
  "type" VARCHAR,
  "english" BIGINT,
  "non_english" BIGINT,
  "local" BIGINT,
  "website" VARCHAR,
  "fb_last_update" VARCHAR,
  "facebook_text" VARCHAR,
  "description" VARCHAR,
  "fb_last_update_year" BIGINT,
  "website_type" VARCHAR,
  "website_status" VARCHAR,
  "fb_rating" DOUBLE,
  "fb_reviews" DOUBLE,
  "fb_followers" BIGINT
);