Tourism Infrastructure

Eurostat code: enps_tour_cap_nat · (2005 - 2022)

@eurostat.enps_tour_cap_nat

Table List

2 tables(25.16 KB)

Tourism Infrastructure - Unpivoted

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

7.59 KB
362 rows
7 columns

freq Freq	unit Unit	accommod Accommod	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Thousand	Bedplaces	Hotels and similar accommodation	Algeria	2005	83.9
Annual	Thousand	Bedplaces	Hotels and similar accommodation	Egypt	2005	237
Annual	Thousand	Bedplaces	Hotels and similar accommodation	Israel	2005	115
Annual	Thousand	Bedplaces	Hotels and similar accommodation	Jordan	2005	20.8
Annual	Thousand	Bedplaces	Hotels and similar accommodation	Libya	2005	23.1
Annual	Thousand	Bedplaces	Hotels and similar accommodation	Morocco	2005	124
Annual	Thousand	Bedplaces	Hotels and similar accommodation	Palestine*	2005	7.7
Annual	Thousand	Bedplaces	Hotels and similar accommodation	Tunisia	2005	230
Annual	Thousand	Bedplaces	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Israel	2005	163
Annual	Thousand	Bedplaces	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Jordan	2005	40


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

Share link

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