Baselight
Sign In

Emigration By Group Of Country Of Next Usual Residence

Eurostat code: migr_emi5nxt ยท (2013 - 2023)

@eurostat.migr_emi5nxt

Emigration By Group Of Country Of Next Usual Residence - Unpivoted
@eurostat.migr_emi5nxt.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.

  • 13.51 KB
  • 1441 rows
  • 6 columns
freq

Freq

partner

Partner

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryNumberAustria201331566
AnnualEU27 countries (from 2020) except reporting countryNumberBelgium201355233
AnnualEU27 countries (from 2020) except reporting countryNumberBulgaria201312566
AnnualEU27 countries (from 2020) except reporting countryNumberSwitzerland201350013
AnnualEU27 countries (from 2020) except reporting countryNumberCzechia201312356
AnnualEU27 countries (from 2020) except reporting countryNumberGermany2013123515
AnnualEU27 countries (from 2020) except reporting countryNumberDenmark201319171
AnnualEU27 countries (from 2020) except reporting countryNumberEstonia20135848
AnnualEU27 countries (from 2020) except reporting countryNumberGreece201345587
AnnualEU27 countries (from 2020) except reporting countryNumberSpain2013185880

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

Share link

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