Nights Spent At Tourism Accommodation Establishments

Eurostat code: enps_tour_occ_ninat · (2005 - 2022)

@eurostat.enps_tour_occ_ninat

Table List

2 tables(22.16 KB)

Nights Spent At Tourism Accommodation Establishments - Raw

Nights Spent At Tourism Accommodation Establishments - Unpivoted

Nights Spent At Tourism Accommodation Establishments - Unpivoted

@eurostat.enps_tour_occ_ninat.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.15 KB
165 rows
6 columns

freq Freq	unit Unit	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Thousand	Hotels and similar accommodation	Algeria	2005	4705.6
Annual	Thousand	Hotels and similar accommodation	Egypt	2005	44589
Annual	Thousand	Hotels and similar accommodation	Israel	2005	19087
Annual	Thousand	Hotels and similar accommodation	Libya	2005	569.2
Annual	Thousand	Hotels and similar accommodation	Morocco	2005	15215
Annual	Thousand	Hotels and similar accommodation	Palestine*	2005	350.2
Annual	Thousand	Hotels and similar accommodation	Tunisia	2005	36310
Annual	Thousand	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Israel	2005	23679.6
Annual	Thousand	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Morocco	2005	15215
Annual	Thousand	Hotels and similar accommodation	Algeria	2006	4905.2


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

Share link

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