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

Eurostat code: lfsa_agan · (1995 - 2024)

@eurostat.lfsa_agan

Table List

2 tables(3.01 MB)

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

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

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

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

1.36 MB
406940 rows
8 columns

freq Freq	unit Unit	sex Sex	age Age	citizen Citizen	geo Geo	time_period Time Period	value Value
Annual	Thousand persons	Females	From 15 to 19 years	EU27 countries (from 2020) except reporting country	Germany	1995	15.2
Annual	Thousand persons	Females	From 15 to 19 years	EU27 countries (from 2020) except reporting country	Luxembourg	1995	0.8
Annual	Thousand persons	Females	From 15 to 19 years	Foreign country	Austria	1995	10.3
Annual	Thousand persons	Females	From 15 to 19 years	Foreign country	Germany	1995	80.3
Annual	Thousand persons	Females	From 15 to 19 years	Foreign country	France	1995	11.8
Annual	Thousand persons	Females	From 15 to 19 years	Foreign country	Luxembourg	1995	0.9
Annual	Thousand persons	Females	From 15 to 19 years	Foreign country	United Kingdom	1995	11.8
Annual	Thousand persons	Females	From 15 to 19 years	Reporting country	Austria	1995	74.9
Annual	Thousand persons	Females	From 15 to 19 years	Reporting country	Belgium	1995	13.9
Annual	Thousand persons	Females	From 15 to 19 years	Reporting country	Germany	1995	490


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

Share link

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