Nights Spent By Detailed Country/world Region Of The Main Destination Of The Trip

Eurostat code: tour_dem_tnw · (2012 - 2023)

@eurostat.tour_dem_tnw

Table List

2 tables(1.42 MB)

Nights Spent By Detailed Country/world Region Of The Main Destination Of The Trip - Raw

Nights Spent By Detailed Country/world Region Of The Main Destination Of The Trip - Unpivoted

Nights Spent By Detailed Country/world Region Of The Main Destination Of The Trip - Unpivoted

@eurostat.tour_dem_tnw.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.

748.83 KB
95275 rows
8 columns

freq Freq	c_dest C Dest	purpose Purpose	duration Duration	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Euro area – 20 countries (from 2023)	2012	641155
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Spain	2012	372733
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	European Union - 27 countries (from 2020)	2012	659178
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	United Kingdom	2012	138490
Annual	Africa	Personal reasons	1 night or over	Number	Austria	2012	1798115
Annual	Africa	Personal reasons	1 night or over	Number	Belgium	2012	4182871
Annual	Africa	Personal reasons	1 night or over	Number	Switzerland	2012	3683811
Annual	Africa	Personal reasons	1 night or over	Number	Czechia	2012	2979594
Annual	Africa	Personal reasons	1 night or over	Number	Germany	2012	26826257
Annual	Africa	Personal reasons	1 night or over	Number	Denmark	2012	2237473


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.