Population By Country Of Birth, Country Of Birth Of Mother And Father, Sex And Age (1–000)

Eurostat code: lfso_08cobsmf · (2008 - 2008)

@eurostat.lfso_08cobsmf

Table List

2 tables(284.28 KB)

Population By Country Of Birth, Country Of Birth Of Mother And Father, Sex And Age (1–000) - Raw

Population By Country Of Birth, Country Of Birth Of Mother And Father, Sex And Age (1–000) - Unpivoted

Population By Country Of Birth, Country Of Birth Of Mother And Father, Sex And Age (1–000) - Unpivoted

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

130.85 KB
36288 rows
9 columns

freq Freq	age Age	sex Sex	c_birth C Birth	c_bthfat C Bthfat	c_bthmot C Bthmot	geo Geo	time_period Time Period	value Value
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Austria	2008	15.1
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Belgium	2008	21.1
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Switzerland	2008	20.9
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Cyprus	2008	1.3
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Czechia	2008	6.8
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Germany	2008	93.2
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Euro area - 19 countries (2015-2022)	2008	373.1
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Greece	2008	8
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Spain	2008	101.2
Annual	From 15 to 24 years	Females	Foreign country	EU27 countries (2007-2013) except reporting country	EU27 countries (2007-2013) except reporting country	Hungary	2008	4


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "c_birth" VARCHAR,
  "c_bthfat" VARCHAR,
  "c_bthmot" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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