Baselight
Sign In

Culture And Tourism - Cities And Greater Cities

Eurostat code: urb_ctour · (1990 - 2023)

@eurostat.urb_ctour

Culture And Tourism - Cities And Greater Cities - Unpivoted
@eurostat.urb_ctour.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.

  • 321.91 KB
  • 72599 rows
  • 5 columns
freq

Freq

indic_ur

Indic Ur

cities

Cities

time_period

Time Period

value

Value

AnnualNumber of cinema seats (total capacity)Portugal1990111293
AnnualCinema attendance (per year)Budapest (greater city)19909697000
AnnualCinema attendance (per year)Miskolc1990892232
AnnualCinema attendance (per year)Nyíregyháza1990593517
AnnualCinema attendance (per year)Pécs1990886466
AnnualCinema attendance (per year)Portugal19909593000
AnnualNumber of museum visitors (per year)Budapest (greater city)19903346000
AnnualNumber of museum visitors (per year)Miskolc1990216618
AnnualNumber of museum visitors (per year)Nyíregyháza199078991
AnnualNumber of museum visitors (per year)Pécs1990695186

CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_ur" VARCHAR,
  "cities" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);