Distribution Of Households By Household Type From 2003 Onwards

Eurostat code: ilc_lvph02 · (2003 - 2024)

@eurostat.ilc_lvph02

Table List

2 tables(83.79 KB)

Distribution Of Households By Household Type From 2003 Onwards - Raw

Distribution Of Households By Household Type From 2003 Onwards - Unpivoted

Distribution Of Households By Household Type From 2003 Onwards - Unpivoted

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

25.38 KB
13090 rows
6 columns

freq Freq	hhtyp Hhtyp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Single person	Percentage	Austria	2003	31.6
Annual	Single person	Percentage	Belgium	2003	33
Annual	Single person	Percentage	Denmark	2003	43.8
Annual	Single person	Percentage	Greece	2003	19.7
Annual	Single person	Percentage	Ireland	2003	21.7
Annual	Single person	Percentage	Luxembourg	2003	29.3
Annual	Single person	Percentage	Norway	2003	40.3
Annual	Single female	Percentage	Austria	2003	18.8
Annual	Single female	Percentage	Belgium	2003	18.5
Annual	Single female	Percentage	Denmark	2003	22.8


CREATE TABLE tidy (
  "freq" VARCHAR,
  "hhtyp" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.