Percentage Distribution Of Main Reason For Migration, Years Of Residence, Sex And Age (% Of Total Migrants)

Eurostat code: lfso_08resr · (2008 - 2008)

@eurostat.lfso_08resr

Table List

2 tables(23.04 KB)

Percentage Distribution Of Main Reason For Migration, Years Of Residence, Sex And Age (% Of Total Migrants) - Raw

Percentage Distribution Of Main Reason For Migration, Years Of Residence, Sex And Age (% Of Total Migrants) - Unpivoted

Percentage Distribution Of Main Reason For Migration, Years Of Residence, Sex And Age (% Of Total Migrants) - Unpivoted

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

11.6 KB
3832 rows
8 columns

freq Freq	sex Sex	age Age	reason Reason	duration Duration	geo Geo	time_period Time Period	value Value
Annual	Females	From 15 to 24 years	Education reasons	Total	Austria	2008	21
Annual	Females	From 15 to 24 years	Education reasons	Total	Belgium	2008	23
Annual	Females	From 15 to 24 years	Education reasons	Total	Switzerland	2008	18
Annual	Females	From 15 to 24 years	Education reasons	Total	Greece	2008	12
Annual	Females	From 15 to 24 years	Education reasons	Total	Spain	2008	8
Annual	Females	From 15 to 24 years	Education reasons	Total	Ireland	2008	12
Annual	Females	From 15 to 24 years	Education reasons	Total	Italy	2008	5
Annual	Females	From 15 to 24 years	Education reasons	Total	Netherlands	2008	40
Annual	Females	From 15 to 24 years	Education reasons	Total	United Kingdom	2008	31
Annual	Females	From 15 to 24 years	Education reasons	From 1 to 5 years	Austria	2008	24


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

Share link

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