Arrivals At Tourism Accommodation Establishments By Type Of Accommodation

Eurostat code: enps_tour_occ_arnat · (2005 - 2022)

@eurostat.enps_tour_occ_arnat

Table List

2 tables(26.17 KB)

Arrivals At Tourism Accommodation Establishments By Type Of Accommodation - Raw

Arrivals At Tourism Accommodation Establishments By Type Of Accommodation - Unpivoted

Arrivals At Tourism Accommodation Establishments By Type Of Accommodation - Unpivoted

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

8.18 KB
416 rows
7 columns

freq Freq	unit Unit	c_resid C Resid	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Thousand	Foreign country	Hotels and similar accommodation	Algeria	2005	199.9
Annual	Thousand	Foreign country	Hotels and similar accommodation	Israel	2005	2004.7
Annual	Thousand	Foreign country	Hotels and similar accommodation	Morocco	2005	3470
Annual	Thousand	Foreign country	Hotels and similar accommodation	Palestine*	2005	88.4
Annual	Thousand	Foreign country	Hotels and similar accommodation	Tunisia	2005	5443
Annual	Thousand	Foreign country	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Israel	2005	2233.5
Annual	Thousand	Foreign country	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Morocco	2005	3470
Annual	Thousand	Reporting country	Hotels and similar accommodation	Algeria	2005	2526.7
Annual	Thousand	Reporting country	Hotels and similar accommodation	Israel	2005	5153.8
Annual	Thousand	Reporting country	Hotels and similar accommodation	Morocco	2005	1400


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

Share link

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