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 - Raw

@eurostat.tour_dem_tnw.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

706.31 KB
24000 rows
18 columns

freq Freq	c_dest C Dest	purpose Purpose	duration Duration	unit Unit	geo Geo	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2022 2022	n_2023 2023
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Austria
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Belgium
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Bulgaria
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Switzerland
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Cyprus
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Germany
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Denmark
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Euro area – 20 countries (from 2023)	641155	847094	799033	665746	632566	999337	719225	1042820	172376	927701	1429761
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Estonia
Annual	Africa	Personal reasons	From 1 to 3 nights	Number	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "c_dest" VARCHAR,
  "purpose" VARCHAR,
  "duration" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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