Baselight

Arrivals By Type Of Accommodation

Eurostat code: med_to12 ยท (2005 - 2018)

@eurostat.med_to12

Arrivals By Type Of Accommodation - Unpivoted
@eurostat.med_to12.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
  • 337 rows
  • 7 columns
freq

Freq

unit

Unit

accommod

Accommod

indic_to

Indic To

geo

Geo

time_period

Time Period

value

Value

AnnualThousandCollective accommodationArrivals of residentsIsrael20056753.2
AnnualThousandCollective accommodationArrivals of residentsMorocco20051400
AnnualThousandCollective accommodationArrivals of non-residentsIsrael20052233.5
AnnualThousandCollective accommodationArrivals of non-residentsMorocco20053470
AnnualThousandCollective accommodationArrivals, totalIsrael20058986.7
AnnualThousandCollective accommodationArrivals, totalMorocco20054870
AnnualThousandCollective accommodation: hotels and similar establismentsArrivals of residentsAlgeria20052526.7
AnnualThousandCollective accommodation: hotels and similar establismentsArrivals of residentsIsrael20055153.8
AnnualThousandCollective accommodation: hotels and similar establismentsArrivals of residentsMorocco20051400
AnnualThousandCollective accommodation: hotels and similar establismentsArrivals of residentsPalestine*200543.5

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.