Fertility And Mortality - Functional Urban Areas

Eurostat code: urb_lfermor · (1990 - 2023)

@eurostat.urb_lfermor

Table List

2 tables(594.47 KB)

Fertility And Mortality - Functional Urban Areas - Raw

Fertility And Mortality - Functional Urban Areas - Unpivoted

Fertility And Mortality - Functional Urban Areas - Unpivoted

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

236.14 KB
92792 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Number of live births per year	Geneva crossborder FUA	1990	8151
Annual	Number of live births per year	Basel crossborder FUA	1990	8021
Annual	Infant mortality rate (per 1000 live births)	Switzerland	1991	6
Annual	Infant mortality rate (per 1000 live births)	Zürich	1991	6
Annual	Infant mortality rate (per 1000 live births)	Oulu/Uleåborg	1991	6
Annual	Infant mortality rate (per 1000 live births)	Vilnius	1991	15
Annual	Infant mortality rate (per 1000 live births)	Kaunas	1991	14
Annual	Infant mortality rate (per 1000 live births)	Panevežys	1991	14
Annual	Infant mortality rate (per 1000 live births)	Leeds	1991	9
Annual	Infant mortality rate (per 1000 live births)	Leicester	1991	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.