Culture And Tourism - Cities And Greater Cities

Eurostat code: urb_ctour · (1990 - 2023)

@eurostat.urb_ctour

Table List

2 tables(668.14 KB)

Culture And Tourism - Cities And Greater Cities - Raw

Culture And Tourism - Cities And Greater Cities - Unpivoted

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
Annual	Number of cinema seats (total capacity)	Portugal	1990	111293
Annual	Cinema attendance (per year)	Budapest (greater city)	1990	9697000
Annual	Cinema attendance (per year)	Miskolc	1990	892232
Annual	Cinema attendance (per year)	Nyíregyháza	1990	593517
Annual	Cinema attendance (per year)	Pécs	1990	886466
Annual	Cinema attendance (per year)	Portugal	1990	9593000
Annual	Number of museum visitors (per year)	Budapest (greater city)	1990	3346000
Annual	Number of museum visitors (per year)	Miskolc	1990	216618
Annual	Number of museum visitors (per year)	Nyíregyháza	1990	78991
Annual	Number of museum visitors (per year)	Pécs	1990	695186


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

Share link

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