TripAdvisor Restaurant Survival

How many restaurants from 2021 are still open?

@kaggle.artemfedorov_restraunt_survival

Table List

4 tables(4.09 MB)

Fi With Webscan

@kaggle.artemfedorov_restraunt_survival.fi_with_webscan

1.36 MB
7372 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	atmosphere_rating Atmosphere 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	local Local	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
g1016321-d1372364	['Europe', 'Finland', 'Northern Savonia', 'Nilsia', 'Nilsia Restaurants', 'Vanha Maatila']	Vanha Maatila	Unclaimed	4	February 29, 2016	Rantalankuja, Nilsia Finland	63.26566	28.047316	#2 of 4 Restaurants in Nilsia	#1 of 1 Diner in Nilsia	2	nan	Diner	nan	nan	Buffet								2				English (1), Finnish (1)	in rating	g1016321-d1372364	nan	Diner	Restaurants	1	1	1	http://www.liinamaapalvelut.com/english/wanhamaatila.asp	nan	nan	nan		non-facebook	unavailable
g1016321-d17664599	['Europe', 'Finland', 'Northern Savonia', 'Nilsia', 'Nilsia Restaurants', 'Syvarin Helmi']	Syvarin Helmi	Unclaimed	3	August 31, 2022	Ukko-Paavontie 2, Nilsia 73300 Finland	63.20441	28.09286	#3 of 4 Restaurants in Nilsia	#1 of 1 International in Nilsia	5	nan	International	nan	nan	nan		true						3		2		English (2), Finnish (3)	in rating	g1016321-d17664599	nan	International	Restaurants	2	3	3	http://www.syvari.com/syvarinhelmi_menu.htm	nan	nan	nan		non-facebook	online
g1016321-d18826847	['Europe', 'Finland', 'Northern Savonia', 'Nilsia', 'Nilsia Restaurants', 'Restaurant Piazza']	Restaurant Piazza	Unclaimed	3	February 17, 2022	Saaskiniementie 560, Nilsia 73310 Finland	63.29159	28.03717	#4 of 4 Restaurants in Nilsia	#4 of 4 Restaurants in Nilsia	2	nan	nan	nan	nan	nan		true						1		1		English (2)	in rating	g1016321-d18826847	nan	nan	Restaurants	2			http://www.piazzatahko.fi	nan	nan	nan		non-facebook	online
g1016321-d2031316	['Europe', 'Finland', 'Northern Savonia', 'Nilsia', 'Nilsia Restaurants', 'Ravintola El Monte']	Ravintola El Monte	Claimed	4.5	August 26, 2023	Tahtitie 1 73310 Tahkovuori, Nilsia 73310 Finland	63.288334	28.041098	#1 of 4 Restaurants in Nilsia	#1 of 1 Steakhouse in Nilsia	101	nan	Steakhouse, European, Scandinavian	Dinner	Vegetarian Friendly	Reservations, Seating, Parking Available, Highchairs Available, Wheelchair Accessible, Serves Alcohol, Full Bar, Free Wifi, Table Service, Takeout	true	true	40	40	35	35	65	19	12	4	1	Swedish (1), Spanish (1), Finnish (57), Russian (9), English (32), German (1)	in rating	g1016321-d2031316	$$ - $$$	Steakhouse, European, Scandinavian	Restaurants	32	69	57	http://www.elmonte.fi/language/en/restaurant-el-monte/	nan	nan	nan		non-facebook	online
g1016321-d20934561	['Europe', 'Finland', 'Northern Savonia', 'Nilsia', 'Nilsia Restaurants', 'Liepuskan Herkkupaja Oy']	Liepuskan Herkkupaja Oy	Unclaimed		nan	Kaunisahontie 37, Nilsia 73320 Finland	63.193096	28.08095	nan	nan		nan	nan	nan	nan	nan		true										nan	in rating	g1016321-d20934561	nan	nan	nan				http://www.liepuska.fi	nan	nan	nan		non-facebook	online
g1016321-d22839844	['Europe', 'Finland', 'Northern Savonia', 'Nilsia', 'Nilsia Restaurants', 'Bistro Ukko']	Bistro Ukko	Unclaimed		nan	Ukontie 7, Nilsia 73310 Finland			nan	nan		₪30 - ₪145	European	nan	nan	nan		true										nan	in rating	g1016321-d22839844	$$ - $$$	European	nan				https://www.facebook.com/BARUKKO/	nan	nan	nan		facebook	unavailable
g1020250-d22978295	['Europe', 'Finland', 'Northern Ostrobothnia', 'Varpupera', 'Varpupera Restaurants', 'Kahvila Korppi']	Kahvila Korppi - CLOSED	Claimed	5	March 24, 2023	Eratie 1 Syote Visitor Centre, Varpupera 93280 Finland	65.63507	27.60925	nan	nan	2	₪34 - ₪85	Cafe	Lunch	nan	Parking Available, Wheelchair Accessible, Free Wifi, Dog Friendly, Non-smoking restaurants		true					2					English (2)	closed	g26527019-d22978295	$$ - $$$	Cafe	nan	2			http://www.facebook.com/kahvilakorppi	April 29, 2023	On aika kiittää lämpimästi kaikkia ihania asiakkaitamme, loistavia työntekijöitämme ja mahtavia yhteistyökumppaneita, joiden kanssa olemme saaneet toimia kuluneina vuosina! Kahvila Korppi sulkeutuu pysyvästi luontokeskuksella 30.4. Myös Taigavireen vuokraamon palvelut päättyvät luontokeskuksella. …	Intro Kahvila Korppi tarjoaa Syötteen luontokeskuksella herkullisia makeita ja suolaisia leivonnaisia, ke Page · Coffee shop Erätie 1, Syöte, Pudasjärvi, Finland +358 44 2306202 some@email.com taigavire.fi Permanently Closed Price Range · $$ Rating · 5.0 (13 Reviews)	2023	facebook	online	5	13	879
g1022644-d10045234	['Europe', 'Finland', 'Northern Ostrobothnia', 'Ylivieska', 'Ylivieska Restaurants', 'Taivaallinen Rauha Tian An Oy']	Taivaallinen Rauha Tian An Oy	Unclaimed	4	September 29, 2023	Asemakatu 4, Ylivieska 84100 Finland	64.07246	24.535881	#3 of 9 Restaurants in Ylivieska	#1 of 1 Chinese in Ylivieska	20	nan	Chinese	nan	nan	nan		true	40	40	40		6	8	3	1	2	English (7), Finnish (12), Swedish (1)	in rating	g1022644-d10045234	$$ - $$$	Chinese	Restaurants	7	13	12	http://taivaallinenrauha.fi	nan	nan	nan		non-facebook	online
g1022644-d10239702	['Europe', 'Finland', 'Northern Ostrobothnia', 'Ylivieska', 'Ylivieska Restaurants', 'Haggman Ylivieska - Keskusta']	Häggman Ylivieska - Keskusta	Unclaimed	3.5	June 7, 2022	Rautatiekatu 8, Ylivieska 84100 Finland	64.07252	24.538738	#4 of 9 Restaurants in Ylivieska	#1 of 2 Cafe in Ylivieska	6	₪9 - ₪85	Cafe	nan	nan	nan		true						4	2			English (1), Finnish (5)	in rating	g1022644-d10239702	$$ - $$$	Cafe	Restaurants	1	5	5	http://www.haggman.fi/kahvilat/ylivieska-keskusta/	nan	nan	nan		non-facebook	online
g1022644-d12573954	['Europe', 'Finland', 'Northern Ostrobothnia', 'Ylivieska', 'Ylivieska Restaurants', 'Ravintola Citrus']	Ravintola Citrus	Unclaimed	4	June 14, 2019	Ollilanojankatu 2 Karkkaisen Kauppapaikka, Ylivieska 84100 Finland	64.06209	24.56317	#7 of 9 Restaurants in Ylivieska	#3 of 3 European in Ylivieska	1	nan	Pizza, European, Turkish	nan	nan	nan		true						1				English, Finnish (1)	in rating	g1022644-d12573954	nan	Pizza, European, Turkish	Restaurants		1	1	https://www.facebook.com/RavintolaCitrus/	November 19, 2020	Ravintola citruksen KESKIVIIKKO lounas. Ylivieska/kärkkäinen	Intro aukioloaika:ma-per_10:30-20:30 la:10:30-17:30 su:12:00-17:30 Page · Restaurant OLLILAOJANKATU2.KÄRKKÄINEN, Ylivieska, Finland +358 41 5054151 some@email.com ravintolacitrus.com Closed now Dine-in · In-store pickup Price Range · $$ Rating · 3.5 (67 Reviews)	2020	facebook	online	3.5	67	437


CREATE TABLE fi_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" BIGINT,
  "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
);