Population By Sex, Age, Citizenship And Labour Status (1–000)

Eurostat code: lfsa_pganws · (1995 - 2024)

@eurostat.lfsa_pganws

Table List

2 tables(12.59 MB)

Population By Sex, Age, Citizenship And Labour Status (1–000) - Raw

Population By Sex, Age, Citizenship And Labour Status (1–000) - Unpivoted

Population By Sex, Age, Citizenship And Labour Status (1–000) - Unpivoted

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

6.02 MB
1871938 rows
9 columns

freq Freq	unit Unit	sex Sex	citizen Citizen	age Age	wstatus Wstatus	geo Geo	time_period Time Period	value Value
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Persons in the labour force	Germany	1995	15.2
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Persons in the labour force	Luxembourg	1995	0.8
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Employed persons	Germany	1995	14.6
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Employed persons	Luxembourg	1995	0.7
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Persons outside the labour force	Belgium	1995	9.7
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Persons outside the labour force	Germany	1995	41.9
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Persons outside the labour force	France	1995	15.8
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Persons outside the labour force	Luxembourg	1995	3.1
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Population	Belgium	1995	10.2
Annual	Thousand persons	Females	EU27 countries (from 2020) except reporting country	From 15 to 19 years	Population	Germany	1995	57.1


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

Share link

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