Skiing Hotels

About 400 hotels in Ski resorts across Europe, with details about each resort.

@kaggle.jacklacey_skiing_hotels

Table List

1 table(49.15 KB)

Ski Hotels

@kaggle.jacklacey_skiing_hotels.ski_hotels

49.15 KB
407 rows
24 columns

unnamed_0 Unnamed: 0	country Country	resort Resort	hotel Hotel	price Price (£)	distance_from_lift_m Distance From Lift (m)	altitude_m Altitude (m)	totalpiste_km TotalPiste (km)	totallifts TotalLifts	gondolas Gondolas	chairlifts Chairlifts	draglifts Draglifts	blues Blues	reds Reds	blacks Blacks	totalruns TotalRuns	link Link	sleeps Sleeps	decsnowlow2020_cm DecSnowLow2020(cm)	decsnowhigh2020_cm DecSnowHigh2020(cm)	jansnowlow2020_cm JanSnowLow2020(cm)	jansnowhigh2020_cm JanSnowHigh2020(cm)	febsnowlow2020_cm FebSnowLow2020(cm)	febsnowhigh2020_cm FebSnowHigh2020(cm)
	italy	bardonecchia	residence-tabor	550	unknown	1312	140	23		9	14	17	24	1	42	https://www.igluski.com/ski-resorts/italy/bardonecchia/residence-tabor_38648?holidayId=58413613	unknown	70	170	60	200	47	177
1	italy	bardonecchia	residence-villa-frejus	561	unknown	1312	140	23		9	14	17	24	1	42	https://www.igluski.com/ski-resorts/italy/bardonecchia/residence-villa-frejus_38647?holidayId=58464837	unknown	70	170	60	200	47	177
2	bulgaria	bansko	hotel-mura	566	1100	935	70	24	1	7	16	5	8	1	14	https://www.igluski.com/ski-resorts/bulgaria/bansko/hotel-mura_20914?holidayId=58542822	140	0	70	5	75	5	77
3	bulgaria	borovets	hotel-samokov	574	75	1390	58	18	1	4	13	1	13	1	15	https://www.igluski.com/ski-resorts/bulgaria/borovets/hotel-samokov_1092?holidayId=58456610	590	0	0	160	200	194	246
4	bulgaria	bansko	hotel-lion---bansko	596	800	935	70	24	1	7	16	5	8	1	14	https://www.igluski.com/ski-resorts/bulgaria/bansko/hotel-lion---bansko_20625?holidayId=58322886	386	0	70	5	75	5	77
5	andorra	arinsal	hotel-xalet-besoli	597	500	1550	63	30	2	11	13	22	16	4	42	https://www.igluski.com/ski-resorts/andorra/arinsal/hotel-xalet-besoli_2446?holidayId=58503135	66	30	60	130	180	120	170
6	austria	mayrhofen	hotel-obermair	601	600	630	600	52	8	27	17	43	75	15	133	https://www.igluski.com/ski-resorts/austria/mayrhofen/hotel-obermair_1829?holidayId=58408829	60	0	60	5	80	2	99
7	bulgaria	borovets	hotel-lion-borovets	603	1200	1390	58	18	1	4	13	1	13	1	15	https://www.igluski.com/ski-resorts/bulgaria/borovets/hotel-lion-borovets_20502?holidayId=58429096	314	0	0	160	200	194	246
8	andorra	arinsal	hotel-xalet-verdu	606	300	1550	63	30	2	11	13	22	16	4	42	https://www.igluski.com/ski-resorts/andorra/arinsal/hotel-xalet-verdu_1602?holidayId=58515499	104	30	60	130	180	120	170
9	andorra	arinsal	hotel-patagonia	632	100	1550	63	30	2	11	13	22	16	4	42	https://www.igluski.com/ski-resorts/andorra/arinsal/hotel-patagonia_7184?holidayId=58452151	160	30	60	130	180	120	170


CREATE TABLE ski_hotels (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "resort" VARCHAR,
  "hotel" VARCHAR,
  "price" BIGINT,
  "distance_from_lift_m" VARCHAR,
  "altitude_m" BIGINT,
  "totalpiste_km" BIGINT,
  "totallifts" BIGINT,
  "gondolas" BIGINT,
  "chairlifts" BIGINT,
  "draglifts" BIGINT,
  "blues" DOUBLE,
  "reds" DOUBLE,
  "blacks" DOUBLE,
  "totalruns" DOUBLE,
  "link" VARCHAR,
  "sleeps" VARCHAR,
  "decsnowlow2020_cm" VARCHAR,
  "decsnowhigh2020_cm" VARCHAR,
  "jansnowlow2020_cm" VARCHAR,
  "jansnowhigh2020_cm" VARCHAR,
  "febsnowlow2020_cm" VARCHAR,
  "febsnowhigh2020_cm" VARCHAR
);