Number Of Bed Places In Hotels And Similar Accommodation

Eurostat code: enps_tour_cap_natb · (2005 - 2022)

@eurostat.enps_tour_cap_natb

Table List

2 tables(19.3 KB)

Number Of Bed Places In Hotels And Similar Accommodation - Raw

Number Of Bed Places In Hotels And Similar Accommodation - Unpivoted

Number Of Bed Places In Hotels And Similar Accommodation - Unpivoted

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

4.71 KB
124 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Thousand	Algeria	2005	83.9
Annual	Thousand	Egypt	2005	237
Annual	Thousand	Israel	2005	115
Annual	Thousand	Jordan	2005	20.8
Annual	Thousand	Libya	2005	23.1
Annual	Thousand	Morocco	2005	124
Annual	Thousand	Palestine*	2005	7.7
Annual	Thousand	Tunisia	2005	230
Annual	Thousand	Algeria	2006	84.9
Annual	Thousand	Egypt	2006	255


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

Share link

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