Baselight
Sign In

Persons Participating In Tourism For Personal Purposes By Activity Status

Eurostat code: tour_dem_tows · (2012 - 2023)

@eurostat.tour_dem_tows

Persons Participating In Tourism For Personal Purposes By Activity Status - Unpivoted
@eurostat.tour_dem_tows.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.

  • 84.85 KB
  • 12253 rows
  • 8 columns
freq

Freq

c_dest

C Dest

duration

Duration

wstatus

Wstatus

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberAustria20121355097
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberBelgium2012518284
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberBulgaria20121012968
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberSwitzerland2012816571
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberCyprus2012203007
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberCzechia20123177297
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberGermany201217587516
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberDenmark2012958961
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberEuro area – 20 countries (from 2023)201295003434
AnnualDomestic country1 night or overPersons in- and outside the labour forceNumberEstonia2012230663

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

Share link

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