Baselight

Number Of Bed-places By NACE Rev.2 (I)

Eurostat code: tin00182 ยท (2013 - 2024)

@eurostat.tin00182

Number Of Bed-places By NACE Rev.2 (I) - Unpivoted
@eurostat.tin00182.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.

  • 18.69 KB
  • 1905 rows
  • 7 columns
freq

Freq

accomunit

Accomunit

unit

Unit

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualBedplacesNumberHotels and similar accommodationAustria2013601483
AnnualBedplacesNumberHotels and similar accommodationBelgium2013128641
AnnualBedplacesNumberHotels and similar accommodationBulgaria2013262196
AnnualBedplacesNumberHotels and similar accommodationSwitzerland2013271298
AnnualBedplacesNumberHotels and similar accommodationCyprus201384715
AnnualBedplacesNumberHotels and similar accommodationCzechia2013317875
AnnualBedplacesNumberHotels and similar accommodationGermany20131757624
AnnualBedplacesNumberHotels and similar accommodationDenmark201387129
AnnualBedplacesNumberHotels and similar accommodationEstonia201331989
AnnualBedplacesNumberHotels and similar accommodationGreece2013773269

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.