Accommodation Establishments

Eurostat code: med_to21 · (2005 - 2018)

@eurostat.med_to21

Table List

2 tables(19.96 KB)

Accommodation Establishments - Unpivoted

Accommodation Establishments - Unpivoted

@eurostat.med_to21.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
141 rows
7 columns

freq Freq	unit Unit	accommod Accommod	indic_to Indic To	geo Geo	time_period Time Period	value Value
Annual	Number	Collective accommodation	Number of establishments	Israel	2005	1794
Annual	Number	Collective accommodation	Number of establishments	Morocco	2005	1148
Annual	Number	Collective accommodation: hotels and similar establisments	Number of establishments	Algeria	2005	1105
Annual	Number	Collective accommodation: hotels and similar establisments	Number of establishments	Egypt	2005	1442
Annual	Number	Collective accommodation: hotels and similar establisments	Number of establishments	Israel	2005	334
Annual	Number	Collective accommodation: hotels and similar establisments	Number of establishments	Jordan	2005	468
Annual	Number	Collective accommodation: hotels and similar establisments	Number of establishments	Libya	2005	245
Annual	Number	Collective accommodation: hotels and similar establisments	Number of establishments	Morocco	2005	1148
Annual	Number	Collective accommodation: hotels and similar establisments	Number of establishments	Palestine*	2005	77
Annual	Number	Collective accommodation: hotels and similar establisments	Number of establishments	Tunisia	2005	816


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.