Baselight

Outgoing 'Dublin' Transfers By Receiving Country (PARTNER), Legal Provision, Duration Of Transfer, Sex And Type Of Applicant

Eurostat code: migr_dubto ยท (2008 - 2024)

@eurostat.migr_dubto

Outgoing 'Dublin' Transfers By Receiving Country (PARTNER), Legal Provision, Duration Of Transfer, Sex And Type Of Applicant - Unpivoted
@eurostat.migr_dubto.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.

  • 1.57 MB
  • 11432695 rows
  • 10 columns
freq

Freq

unit

Unit

leg_prov

Leg Prov

duration

Duration

partner

Partner

applicant

Applicant

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualNumberTake back requestFrom 1 to 6 monthsAustriaAdultFemalesBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaAdultMalesBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaAdultTotalBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaAdultUnknownBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaAccompanied minorFemalesBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaAccompanied minorMalesBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaAccompanied minorTotalBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaAccompanied minorUnknownBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaTotalFemalesBelgium2008
AnnualNumberTake back requestFrom 1 to 6 monthsAustriaTotalMalesBelgium2008

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

Share link

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