Nights Spent By Type Of Accommodation

Eurostat code: med_to13 · (2005 - 2018)

@eurostat.med_to13

Table List

2 tables(19.95 KB)

Nights Spent By Type Of Accommodation - Raw

Nights Spent By Type Of Accommodation - Unpivoted

Nights Spent By Type Of Accommodation - Unpivoted

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

6.29 KB
122 rows
7 columns

freq Freq	unit Unit	accommod Accommod	indic_to Indic To	geo Geo	time_period Time Period	value Value
Annual	Thousand	Collective accommodation	Nights spent, total	Israel	2005	23679.6
Annual	Thousand	Collective accommodation	Nights spent, total	Morocco	2005	15215
Annual	Thousand	Collective accommodation: hotels and similar establisments	Nights spent, total	Algeria	2005	4705.6
Annual	Thousand	Collective accommodation: hotels and similar establisments	Nights spent, total	Egypt	2005	44589
Annual	Thousand	Collective accommodation: hotels and similar establisments	Nights spent, total	Israel	2005	19087
Annual	Thousand	Collective accommodation: hotels and similar establisments	Nights spent, total	Libya	2005	569.2
Annual	Thousand	Collective accommodation: hotels and similar establisments	Nights spent, total	Morocco	2005	15215
Annual	Thousand	Collective accommodation: hotels and similar establisments	Nights spent, total	Palestine*	2005	350.2
Annual	Thousand	Collective accommodation: hotels and similar establisments	Nights spent, total	Tunisia	2005	36310
Annual	Thousand	Collective accommodation	Nights spent, total	Israel	2006	23950.1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "accommod" VARCHAR,
  "indic_to" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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