Distribution Of Population By Group Of Country Of Birth And Tenure Status (population Aged 18 And Over)

Eurostat code: ilc_lvps16 · (2003 - 2024)

@eurostat.ilc_lvps16

Table List

2 tables(804.89 KB)

Distribution Of Population By Group Of Country Of Birth And Tenure Status (population Aged 18 And Over) - Raw

Distribution Of Population By Group Of Country Of Birth And Tenure Status (population Aged 18 And Over) - Unpivoted

Distribution Of Population By Group Of Country Of Birth And Tenure Status (population Aged 18 And Over) - Unpivoted

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

360.69 KB
240412 rows
9 columns

freq Freq	unit Unit	tenure Tenure	c_birth C Birth	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Belgium	2003	55.4
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Denmark	2003	55.1
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Greece	2003	41.8
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Ireland	2003	65.1
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Norway	2003	81
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Belgium	2003	56.4
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Denmark	2003	54.2
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Greece	2003	43.2
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Ireland	2003	65.4
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Norway	2003	82.5


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

Share link

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