Number Of Adults By Sex, Age Groups, Number Of Children, Age Of Youngest Child And Household Composition (1–000)

Eurostat code: lfst_hhaceday · (2006 - 2024)

@eurostat.lfst_hhaceday

Table List

2 tables(11.02 MB)

Number Of Adults By Sex, Age Groups, Number Of Children, Age Of Youngest Child And Household Composition (1–000) - Raw

Number Of Adults By Sex, Age Groups, Number Of Children, Age Of Youngest Child And Household Composition (1–000) - Unpivoted

Number Of Adults By Sex, Age Groups, Number Of Children, Age Of Youngest Child And Household Composition (1–000) - Unpivoted

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

5.46 MB
2293358 rows
10 columns

freq Freq	sex Sex	age Age	agechild Agechild	n_child N Child	hhcomp Hhcomp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Austria	2006	30.1
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Belgium	2006	26.1
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Bulgaria	2006	17.8
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Cyprus	2006	0.7
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Czechia	2006	14.4
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Germany	2006	535.9
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Euro area – 20 countries (from 2023)	2006	1267.2
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Estonia	2006	4.4
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Greece	2006	69.8
Annual	Females	From 18 to 24 years	Not applicable	No children	Single adult - total	Thousand persons	Spain	2006	24.1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "agechild" VARCHAR,
  "n_child" VARCHAR,
  "hhcomp" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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