Nights Spent At Tourist Accommodation Establishments By Degree Of Urbanisation And Coastal/non-coastal Area And NUTS 2 Region

Eurostat code: tour_occ_nin2dc · (2012 - 2024)

@eurostat.tour_occ_nin2dc

Table List

2 tables(2.07 MB)

Nights Spent At Tourist Accommodation Establishments By Degree Of Urbanisation And Coastal/non-coastal Area And NUTS 2 Region - Raw

Nights Spent At Tourist Accommodation Establishments By Degree Of Urbanisation And Coastal/non-coastal Area And NUTS 2 Region - Unpivoted

Nights Spent At Tourist Accommodation Establishments By Degree Of Urbanisation And Coastal/non-coastal Area And NUTS 2 Region - Unpivoted

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

1.03 MB
203416 rows
8 columns

freq Freq	c_resid C Resid	terrtypo Terrtypo	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Austria	2012
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Belgium	2012	1583446
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Bulgaria	2012	1875435
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Switzerland	2012
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Cyprus	2012	1070385
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Czechia	2012
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Germany	2012	27586217
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Denmark	2012	5980477
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2012	225479099
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Estonia	2012	699303


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

Share link

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