Trips By Duration Of The Trip

Eurostat code: tour_dem_ttls · (2012 - 2023)

@eurostat.tour_dem_ttls

Table List

2 tables(491.91 KB)

Trips By Duration Of The Trip - Unpivoted

Trips By Duration Of The Trip - Unpivoted

@eurostat.tour_dem_ttls.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

248.52 KB
31896 rows
8 columns

freq Freq	c_dest C Dest	purpose Purpose	duration Duration	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Austria	2012	5777112
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Belgium	2012	1489881
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Bulgaria	2012	1941286
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Switzerland	2012	3905121
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Cyprus	2012	1074564
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Czechia	2012	18628902
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Germany	2012	84908064
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Denmark	2012	17342909
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Euro area – 20 countries (from 2023)	2012	371389983
Annual	Domestic country	Personal reasons	From 1 to 3 nights	Number	Estonia	2012	1353968


CREATE TABLE tidy (
  "freq" VARCHAR,
  "c_dest" VARCHAR,
  "purpose" VARCHAR,
  "duration" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.