Baselight

Outgoing 'Dublin' Requests By Receiving Country (PARTNER), Type Of Request, Legal Provision, Sex And Type Of Applicant

Eurostat code: migr_dubro ยท (2008 - 2024)

@eurostat.migr_dubro

Outgoing 'Dublin' Requests By Receiving Country (PARTNER), Type Of Request, Legal Provision, Sex And Type Of Applicant - Unpivoted
@eurostat.migr_dubro.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.67 MB
  • 6347732 rows
  • 10 columns
freq

Freq

unit

Unit

request

Request

leg_prov

Leg Prov

partner

Partner

applicant

Applicant

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualNumberRequestsTake back requestAustriaTotalTotalAustria2008
AnnualNumberRequestsTake back requestAustriaTotalTotalBelgium200878
AnnualNumberRequestsTake back requestAustriaTotalTotalBulgaria20081
AnnualNumberRequestsTake back requestAustriaTotalTotalSwitzerland2008
AnnualNumberRequestsTake back requestAustriaTotalTotalCyprus20081
AnnualNumberRequestsTake back requestAustriaTotalTotalCzechia200816
AnnualNumberRequestsTake back requestAustriaTotalTotalGermany2008383
AnnualNumberRequestsTake back requestAustriaTotalTotalEstonia2008
AnnualNumberRequestsTake back requestAustriaTotalTotalGreece2008
AnnualNumberRequestsTake back requestAustriaTotalTotalSpain20086

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