Population Structure - Cities And Greater Cities

Eurostat code: urb_cpopstr · (1989 - 2024)

@eurostat.urb_cpopstr

Table List

2 tables(742.54 KB)

Population Structure - Cities And Greater Cities - Raw

Population Structure - Cities And Greater Cities - Unpivoted

Population Structure - Cities And Greater Cities - Unpivoted

@eurostat.urb_cpopstr.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.

345.85 KB
174379 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Women per 100 men	Tallinn	1989	115.2
Annual	Women per 100 men	Tartu	1989	119.7
Annual	Women per 100 men	Vilnius	1989	110.6
Annual	Women per 100 men	Kaunas	1989	116.5
Annual	Women per 100 men	Panevėžys	1989	116.3
Annual	Women per 100 men	Warszawa	1989	114.2
Annual	Women per 100 men	Łódź	1989	117.5
Annual	Women per 100 men	Kraków	1989	109.9
Annual	Women per 100 men	Wrocław	1989	109.9
Annual	Women per 100 men	Poznań	1989	112.8


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.