Population Structure - Functional Urban Areas

Eurostat code: urb_lpopstr · (1989 - 2024)

@eurostat.urb_lpopstr

Table List

2 tables(540.07 KB)

Population Structure - Functional Urban Areas - Raw

Population Structure - Functional Urban Areas - Unpivoted

Population Structure - Functional Urban Areas - Unpivoted

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

239.33 KB
121635 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Women per 100 men	Tallinn	1989	112.7
Annual	Women per 100 men	Tartu	1989	117.8
Annual	Women per 100 men	Vilnius	1989	109.8
Annual	Women per 100 men	Kaunas	1989	115.2
Annual	Women per 100 men	Panevežys	1989	115.5
Annual	Proportion of total population aged 55-64	Tallinn	1989	10.6
Annual	Proportion of total population aged 55-64	Tartu	1989	11.1
Annual	Proportion of total population aged 55-64	Vilnius	1989	9.8
Annual	Proportion of total population aged 55-64	Kaunas	1989	10
Annual	Proportion of total population aged 55-64	Panevežys	1989	9.7


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.