Baselight
Sign In

Emigration By Age Group, Sex And Country Of Birth

Eurostat code: migr_emi4ctb ยท (2008 - 2023)

@eurostat.migr_emi4ctb

Emigration By Age Group, Sex And Country Of Birth - Unpivoted
@eurostat.migr_emi4ctb.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.

  • 6.72 MB
  • 8551765 rows
  • 9 columns
freq

Freq

age

Age

agedef

Agedef

c_birth

C Birth

unit

Unit

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualTotalAge in completed yearsAndorraNumberFemalesAustria2008
AnnualTotalAge in completed yearsAndorraNumberFemalesDenmark2008
AnnualTotalAge in completed yearsAndorraNumberFemalesEstonia2008
AnnualTotalAge in completed yearsAndorraNumberFemalesFinland2008
AnnualTotalAge in completed yearsAndorraNumberFemalesCroatia2008
AnnualTotalAge in completed yearsAndorraNumberFemalesHungary2008
AnnualTotalAge in completed yearsAndorraNumberFemalesIreland2008
AnnualTotalAge in completed yearsAndorraNumberFemalesItaly2008
AnnualTotalAge in completed yearsAndorraNumberFemalesLiechtenstein2008
AnnualTotalAge in completed yearsAndorraNumberFemalesLithuania2008

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