Number Of Establishments And Bed-places By NUTS 2 Region

Eurostat code: tgs00112 · (2013 - 2024)

@eurostat.tgs00112

Table List

2 tables(100.52 KB)

Number Of Establishments And Bed-places By NUTS 2 Region - Raw

Number Of Establishments And Bed-places By NUTS 2 Region - Unpivoted

Number Of Establishments And Bed-places By NUTS 2 Region - Unpivoted

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

46.91 KB
5936 rows
7 columns

freq Freq	accomunit Accomunit	unit Unit	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Burgenland	2013	28646
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Niederösterreich	2013	69154
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Wien	2013	68229
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Kärnten	2013	149157
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Steiermark	2013	97597
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Oberösterreich	2013	68931
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Salzburg	2013	167544
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Tirol	2013	273770
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Vorarlberg	2013	58042
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest	2013	38297


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

Share link

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