Number Of Establishments And Bed-places

Eurostat code: tin00181 · (2013 - 2024)

@eurostat.tin00181

Table List

2 tables(29.15 KB)

Number Of Establishments And Bed-places - Raw

Number Of Establishments And Bed-places - Unpivoted

Number Of Establishments And Bed-places - Unpivoted

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

11.4 KB
759 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	Austria	2013	981070
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Belgium	2013	372867
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Bulgaria	2013	302433
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Cyprus	2013	87143
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Czechia	2013	740671
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Germany	2013	3326821
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Denmark	2013	417594
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Estonia	2013	55482
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Greece	2013	1207394
Annual	Bedplaces	Number	Hotels; holiday and other short-stay accommodation; camping grounds, recreational vehicle parks and trailer parks	Spain	2013	3437362


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.