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 - Raw

@eurostat.tour_occ_nin2dc.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

1.04 MB
22842 rows
19 columns

freq Freq	c_resid C Resid	terrtypo Terrtypo	nace_r2 Nace R2	unit Unit	geo Geo	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Albania							270762		473755		777283	1281648
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Austria
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Belgium	1583446	1614310		1463142	1444281	1405345	1521232
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Bulgaria	1875435	1994158	2009021	2197612	2563983	2444809	2450694	2708867	2559739	3331515	3484664	3547559
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Switzerland
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Cyprus	1070385	880959	816655	663878	666450	650405	718566	801705	899958	1351988	1080361	974066
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Czechia
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Germany	27586217	28465248	29502925	30648389	32284031	32999506	33848896	35243868	21752211	22443231	31990180	32938008
Annual	Domestic country	Coastal areas	Hotels and similar accommodation	Number	Denmark	5980477	6179606	6601080	7172838	7615287	7902486	8164370	8838113	6336141	8363663	10749905	10671827
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)	225479099	229450067	233938591	242203664	248770360	255049442	261545172	266236853	152815264	208799168	265926382	271373359


CREATE TABLE raw (
  "freq" VARCHAR,
  "c_resid" VARCHAR,
  "terrtypo" VARCHAR,
  "nace_r2" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Share link

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