Baselight
Sign In

Unilateral 'Dublin' Decisions By Partner Country, Type Of Decision, Sex And Type Of Applicant

Eurostat code: migr_dubduni ยท (2014 - 2024)

@eurostat.migr_dubduni

Unilateral 'Dublin' Decisions By Partner Country, Type Of Decision, Sex And Type Of Applicant - Unpivoted
@eurostat.migr_dubduni.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.

  • 116.71 KB
  • 429527 rows
  • 9 columns
freq

Freq

unit

Unit

leg_prov

Leg Prov

partner

Partner

applicant

Applicant

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualNumberMember State to become responsible by defaultAustriaAdultFemalesNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaAdultMalesNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaAdultTotalNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaAdultUnknownNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaAccompanied minorFemalesNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaAccompanied minorMalesNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaAccompanied minorTotalNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaAccompanied minorUnknownNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaTotalFemalesNetherlands2014
AnnualNumberMember State to become responsible by defaultAustriaTotalMalesNetherlands2014

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