Young Immigrants By Sex, Age And Country Of Birth

Eurostat code: yth_demo_070 · (2008 - 2023)

@eurostat.yth_demo_070

Table List

2 tables(5.75 MB)

Young Immigrants By Sex, Age And Country Of Birth - Raw

Young Immigrants By Sex, Age And Country Of Birth - Unpivoted

Young Immigrants By Sex, Age And Country Of Birth - Unpivoted

@eurostat.yth_demo_070.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.7 MB
3290784 rows
9 columns

freq Freq	agedef Agedef	c_birth C Birth	unit Unit	sex Sex	age Age	geo Geo	time_period Time Period
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 19 years	Austria	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 19 years	Finland	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 19 years	Croatia	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 19 years	Ireland	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 19 years	Lithuania	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 19 years	Luxembourg	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 19 years	Romania	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 19 years	Slovenia	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 29 years	Austria	2008
Annual	Age in completed years	Andorra	Percentage	Females	From 15 to 29 years	Finland	2008


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