Living Conditions - Functional Urban Areas

Eurostat code: urb_llivcon · (1989 - 2024)

@eurostat.urb_llivcon

Table List

2 tables(961.38 KB)

Living Conditions - Functional Urban Areas - Raw

Living Conditions - Functional Urban Areas - Unpivoted

Living Conditions - Functional Urban Areas - Unpivoted

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

454.17 KB
98458 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Lone parent private households (with children aged 0 to under 18)	Tallinn	1989	30929
Annual	Lone parent private households (with children aged 0 to under 18)	Tartu	1989	7220
Annual	Households with children aged 0 to under 18	Tallinn	1989	174785
Annual	Households with children aged 0 to under 18	Tartu	1989	41734
Annual	Lone parent households per 100 households with children aged 0-17	Tallinn	1989	18
Annual	Lone parent households per 100 households with children aged 0-17	Tartu	1989	17
Annual	Private households (excluding institutional households)	Switzerland	1990	2841850
Annual	Private households (excluding institutional households)	Bern	1990	155439
Annual	Private households (excluding institutional households)	Zürich	1990	459618
Annual	Private households (excluding institutional households)	Genève	1990	190705


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.