Culture And Tourism - Cities And Greater Cities

Eurostat code: urb_ctour$dv_168

@eurostat.urb_ctour_dv_168

Table List

2 tables(186.96 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_dv_168.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.

88.83 KB
19887 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Number of cinema seats per 1000 residents	Bulgaria	2014	5
Annual	Number of cinema seats per 1000 residents	Sofia	2014	16
Annual	Number of cinema seats per 1000 residents	Plovdiv	2014	8
Annual	Number of cinema seats per 1000 residents	Varna	2014	10
Annual	Number of cinema seats per 1000 residents	Burgas	2014	14
Annual	Number of cinema seats per 1000 residents	Pleven	2014	5
Annual	Number of cinema seats per 1000 residents	Ruse	2014	13
Annual	Number of cinema seats per 1000 residents	Vidin	2014	3
Annual	Number of cinema seats per 1000 residents	Stara Zagora	2014	16
Annual	Number of cinema seats per 1000 residents	Sliven	2014	1


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.