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

Eurostat code: ilc_lvps15 · (2003 - 2024)

@eurostat.ilc_lvps15

Table List

2 tables(709.46 KB)

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

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

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

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

314.45 KB
201402 rows
9 columns

freq Freq	unit Unit	tenure Tenure	citizen Citizen	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	54.1
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	26.7
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Ireland	2003	46.4
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Norway	2003	72.3
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Belgium	2003	54.6
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	28.5
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Ireland	2003	48.3
Annual	Percentage	Owner	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Norway	2003	74.7


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tenure" VARCHAR,
  "citizen" 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.