Culture And Tourism - Cities And Greater Cities
Eurostat code: urb_ctour$dv_169
@eurostat.urb_ctour_dv_169
Table List
- 2 tables(32.1 KB)
Culture And Tourism - Cities And Greater Cities - Unpivoted
@eurostat.urb_ctour_dv_169.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.
- 14.13 KB
- 2468 rows
- 5 columns
freqFreq | indic_urIndic Ur | citiesCities | time_periodTime Period | valueValue |
|---|---|---|---|---|
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | St. Gallen (greater city) | 2014 | 5 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | Biel/Bienne (greater city) | 2014 | 2 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | Berlin | 2014 | 95 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | Hamburg | 2014 | 25 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | München | 2014 | 17 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | Köln | 2014 | 13 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | Frankfurt am Main | 2014 | 14 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | Essen | 2014 | 10 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | Stuttgart | 2014 | 16 |
| Annual | Number of public swimming pools (indoor and outdoor, excluding beaches) | Leipzig | 2014 | 15 |
CREATE TABLE tidy (
"freq" VARCHAR,
"indic_ur" VARCHAR,
"cities" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);