Youth Population On 1 January By Sex, Age And Country Of Birth

Eurostat code: yth_demo_060 · (1998 - 2024)

@eurostat.yth_demo_060

Table List

2 tables(4.92 MB)

Youth Population On 1 January By Sex, Age And Country Of Birth - Raw

Youth Population On 1 January By Sex, Age And Country Of Birth - Unpivoted

Youth Population On 1 January By Sex, Age And Country Of Birth - Unpivoted

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

2.36 MB
1198428 rows
8 columns

freq Freq	c_birth C Birth	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	From 15 to 19 years	Males	Number	Spain	1998	1515530
Annual	Total	From 15 to 19 years	Total	Number	Spain	1998	2959304
Annual	Total	From 15 to 29 years	Females	Number	Spain	1998	4763389
Annual	Total	From 15 to 29 years	Males	Number	Spain	1998	4978538
Annual	Total	From 15 to 29 years	Total	Number	Spain	1998	9741927
Annual	Total	From 20 to 24 years	Males	Number	Spain	1998	1755001
Annual	Total	From 20 to 24 years	Total	Number	Spain	1998	3432865
Annual	Total	From 25 to 29 years	Males	Number	Spain	1998	1708007
Annual	Total	From 25 to 29 years	Total	Number	Spain	1998	3349758
Annual	Total	Less than 15 years	Males	Number	Spain	1998	3178121


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

Share link

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