Ratio Of Young People In The Total Population On 1 January By Sex And Age

Eurostat code: yth_demo_020 · (2008 - 2024)

@eurostat.yth_demo_020

Table List

2 tables(48.12 KB)

Ratio Of Young People In The Total Population On 1 January By Sex And Age - Raw

Ratio Of Young People In The Total Population On 1 January By Sex And Age - Unpivoted

Ratio Of Young People In The Total Population On 1 January By Sex And Age - Unpivoted

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

15.36 KB
7278 rows
7 columns

freq Freq	unit Unit	age Age	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Percentage	From 15 to 19 years	Total	Andorra	2008	4.7
Annual	Percentage	From 15 to 19 years	Total	Albania	2008	10.4
Annual	Percentage	From 15 to 19 years	Total	Armenia	2008	9.8
Annual	Percentage	From 15 to 19 years	Total	Austria	2008	6
Annual	Percentage	From 15 to 19 years	Total	Azerbaijan	2008	10.7
Annual	Percentage	From 15 to 19 years	Total	Belgium	2008	6.1
Annual	Percentage	From 15 to 19 years	Total	Bulgaria	2008	6.2
Annual	Percentage	From 15 to 19 years	Total	Belarus	2008	7.4
Annual	Percentage	From 15 to 19 years	Total	Switzerland	2008	6
Annual	Percentage	From 15 to 19 years	Total	Cyprus	2008	7.9


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

Share link

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